IZ63699: IF THE DATABASE HAS A DATABASE PARTITION GROUP CREATED AND YOU RUN DB2LOOK WITH OPTION -L WITH -CT IT GIVES ERROR -443.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as fixed if next.

Error description

• If the DATABASE has a DATABASE PARTITION GROUP created and you
  run db2look with option -l with -ct it gives error -443.
  
  Call DB2LK_GENERATE_DDL failed, sqlcode is -443;
  
  SYSPROC.DB2LK_GENERATE_DDL DB2LK_GENERATE_DDL SQL0100
       SQLERFRP;
  
  If db2look cannot access the database partion you receive error
  -1131
  
  Call DB2LK_GENERATE_DDL failed, sqlcode is -1131;
  
  Workaround remove option -ct
  

Local fix

• Workaround remove option -ct
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User using db2 v970 FP0                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If the DATABASE has a DATABASE PARTITION GROUP created and   *
  * you run db2look with option -l with -ct it gives error -443. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to db2 v970 FP1 or higher                            *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IZ49607

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R970 PSN

     UP