JR62871: IDR FOR DB2LUW WILL NOW REPORT PRIMARY INDEXES PROPERLY IN CHCCLP LIST TABLE INDEXES COMMAND

APAR status

• Closed as program error.

Error description

• If primary key is defined implicitly with the
  table
  creation,primary index is appearing as "NO" when we query
  with
  CHCCLP. Instead if primary key constraint is created as
  user
  defined the below logic may work.
  
  From DB2
  db2 => create
  table CDCEDM.BENCHECK1 (CUSTCD
  varchar(10),BENNAME
  varchar(10),BENACNO integer not
  null,BENBANK integer, primary
  key(BENACNO))
  DB20000I The SQL command completed
  successfully.
  db2 => commit
  DB20000I The SQL command completed
  successfully.
  
  ------------
  From CHCCLP
  Repl > connect server
  hostname 10.20.235.165 port 10111
  username <user> password
  <pwd>;
  Repl > connect datastore name CNPKTEST;
  Repl > list
  table indexes name CNPKTEST schema CDCEDM
  table
  BENCHECK1;
  
  Indexes for table CDCEDM.BENCHECK1.
  INDEX
  NAME PRIMARY INDEX UNIQUE INDEX
  ---------------------------
  ---------------- ----------------
  SYSIBM.SQL190702110947870 No
  Yes
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you use CDC 11.4.0.3-5569 or    *
  * older for Db2, and you use CHCCLP to list a table mapping's  *
  * indexes and columns where source tables have both a primary  *
  * key and a unique key.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If you call chcclp commands such as "list table indexes" or  *
  * "list index columns", chcclp returns a line for the primary  *
  * index and a line for the unique index. For columns in a      *
  * table that were part of both indexes, chcclp was returning   *
  * PRIMARY KEY "YES" and UNIQUE KEY "YES" on the line for the   *
  * unique index. After this fix, chcclp now returns PRIMARY KEY *
  * "NO" and UNIQUE KEY "YES" on the line for the unique index.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.4.0.3-5560 or newer for Db2.              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IIDR 11.4.0.3-5560 or newer for Db2 resolves the
  issue.
  

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:

Fix information

• Fixed component name

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels