IZ49607: 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.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 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 v950 FP4 or lower                             *
  ****************************************************************
  * 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:                                              *
  * Upgrading to db2 v950 FP5 or higher                          *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

  IZ63699

Fix information

Applicable component levels

• R950 PSN

     UP