Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    11

    Unanswered: Where does the db2move.lst file get it's numbering system from?

    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.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •