IBM Support

PI45362: SQLCODE 100 DURING SUBSCRIPTION STARTUP CAUSES SUBSCRIPTION TO FAIL.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • After applying PTF UI27018 for coordination with IDAA V4 PTF 5,
    if the CHCBNDPL sample JCL is run with the OWNER and QUALIFIER
    keywords having different values, then an SQLCODE 100 is
    received from an SQL request issued during subscription
    validation.  The subscription fails to start.
    

Local fix

  • Code the QUALIFIER keyword on all the BIND PLAN statements,
    using the same QUALIFIER keyword value as is coded on the BIND
    PACKAGE statements.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the IBM DB2 Analytics Accelerator   *
    *                 product Version 4 with PTF 5 applied and     *
    *                 with PTF UI27018 applied to IIDR CDC for     *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Some customers may BIND the plans for   *
    *                      IIDR CDC for z/OS with the BIND PACKAGE *
    *                      statements' OWNER and QUALIFER operands *
    *                      set to different values.  When a        *
    *                      subscription starts, the QUALIFIER      *
    *                      value will be extracted from the plan   *
    *                      (where it is not set, but defaulted to  *
    *                      the plan's OWNER) instead of from one   *
    *                      of the packages, using it as the owner  *
    *                      of the meta-data tables.  If the target *
    *                      is an IDAA-Netezza system, the the      *
    *                      subscription will try to look up the    *
    *                      DMMD_SIGNALS table in SYSIBM.SYSTABLES. *
    *                      Because the OWNER of the plan is not    *
    *                      the same as the owner of the meta-data  *
    *                      tables, this will result in a SQLCODE   *
    *                      100, and the subscription will fail.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    
    The wrong plan datum is used as the owner of the meta-data.
    

Problem conclusion

  • Instead of the plan's QUALIFIER value, one of the packages'
    QUALIFIER values will be used as the owner of the meta-data
    tables.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI45362

  • Reported component name

    INFO SRVR CDC Z

  • Reported component ID

    5655U7600

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-07-21

  • Closed date

    2015-08-03

  • Last modified date

    2015-09-02

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

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

    UI29776 UI29777

Modules/Macros

  • CHCDSCDB CHCDSCPF CHCDTCFR CHCMDPDB CHCMDPGP
    CHCMDPMD
    

Fix information

  • Fixed component name

    INFO SRVR CDC Z

  • Fixed component ID

    5655U7600

Applicable component levels

  • RA20 PSY UI29776

       UP15/08/08 P F508

  • RA21 PSY UI29777

       UP15/08/08 P F508

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.



Document information

More support for: InfoSphere Data Replication for DB2 for z/OS

Software version: 10.2.1

Reference #: PI45362

Modified date: 02 September 2015


Translate this page: