PM90568: IFI 306 LOG READ DBID/PSID FILTERING SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add DB2 10 IFI 306 Log Read DBID/PSID Filtering support.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS replication product or      *
  *                 IFI 306 users.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 for z/OS replication products and   *
  *                      other users of IFI READS of IFCID 306   *
  *                      will receive log records for all tables *
  *                      which are enabled for CAPTURE CHANGES   *
  *                      even in cases where they are interested *
  *                      in only a subset. This results in       *
  *                      unneccesary CPU consumption which could *
  *                      be avoided if there was a way to        *
  *                      qualify which table spaces were of      *
  *                      interest.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The WQAL control block is modified to optionally allow setting
  the address (WQALWQLS or WQALWQL4) of a new qualification
  specification control block called the WQLS. The WQLSTYPE must
  be set to a value of 'DBSP' to identify that the qualification
  list is an array of DBID and PSID pairs. For the returned log
  records to include the ALTER COLUMN diagnostic log records the
  PSID should be the OBID of the tables within the table spaces.
  
  Additional Keywords:
  IDAAV4R1/K
  

Problem conclusion

Temporary fix

Comments

• temp
  

APAR Information

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

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

  UK97013

Modules/Macros

• DSNDQJ00 DSNDWQAL DSNIDALC DSNIDEFR DSNIDLGR DSNIDMPS DSNIFLAR
  DSNIFLRD DSNILGRX DSNILGSL DSNILOGA DSNIREDO DSNIRSTR DSNIUNDO
  DSNJRE01 DSNJRM01 DSNJRM02 DSNJRM03 DSNJR001 DSNJR003 DSNJR006
  DSNJR106 DSNUCLOG DSNUGLGR DSNURLOG DSNWALRS DSNWARDS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK97013

     UP13/09/11 P F309

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.