Duplicated tables on DB2 with Desc "Old name F...."

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

Re: Duplicated tables on DB2 with Desc \"Old name F....\"

There may have been a problem while restoring the files. Authorities?

The files with the counter-type suffixes wouldn't be recognized or accessible by JDE so you should be able to delete them. Don't F0911000001 and F09100002 have fewer records than F0911?

Re: Duplicated tables on DB2 with Desc \"Old name F....\"

For the conditions that cause file conditions like this, see Chapter 9 in the Backup and Recovery manual here:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/books/sc415304.pdf