Jane_d
Member
Duplicated tables on DB2 with Desc \"Old name F....\"
Folks,
I have notices that our as400 libraries have been growing in size pretty rapidly. One issue I'm looking into is why do we have what seem to be copies of tables. I think that the issue stems from a generate issued with in JDE. The distinguishing features of these 'Extra' Tables include the following:
1. The description on the tables follow this convention "Old name F0911 in CRPDTA810 owned by XPSFT.
2. The file names seems to use the next available 'short name'. for example a table that has the above description may have a 'short name of F091100001 or F091100002.
3. The tables have have an owner that is also a JDE proxy user name, not a as400 ID. This tells me it was created from within JDE.
4. These tables are not visible from within JDE UTB
Like I said, I suspect the issue is caused by the generation process but can not replicate the issue.
Thank you for your time to look at this issue
Jane
Folks,
I have notices that our as400 libraries have been growing in size pretty rapidly. One issue I'm looking into is why do we have what seem to be copies of tables. I think that the issue stems from a generate issued with in JDE. The distinguishing features of these 'Extra' Tables include the following:
1. The description on the tables follow this convention "Old name F0911 in CRPDTA810 owned by XPSFT.
2. The file names seems to use the next available 'short name'. for example a table that has the above description may have a 'short name of F091100001 or F091100002.
3. The tables have have an owner that is also a JDE proxy user name, not a as400 ID. This tells me it was created from within JDE.
4. These tables are not visible from within JDE UTB
Like I said, I suspect the issue is caused by the generation process but can not replicate the issue.
Thank you for your time to look at this issue
Jane