Hi,

Can anybody advise where DB2 gets it's numbering system for table names in a "db2move.lst" file once you run a db2move on a database. Ie, tab1.ixf, tab2.ixf, tab3.ixf, etc. For example:

!"DB2ADMIN"."ACCOUNT"!tab1.ixf!tab1.msg!
!"DB2ADMIN"."ACCOUNT_NUMBER"!tab2.ixf!tab2.msg!
!"DB2ADMIN"."ACCOUNT_TYPE2"!tab3.ixf!tab3.msg!
!"DB2ADMIN"."ACCT"!tab4.ixf!tab4.msg!

I am trying to query this from the database, but can't find it.

Thanks.

It is assigned randomly at each execution. Not sure if they sort the tables by table name. No guarantee that the same table will have the same number next time you run it (especially if new tables are added, or tables are dropped).