IBM Support

PH33099: NEW Q APPLY PARAMETER RECORD_TEMPORALHISTORY TO ALLOW REPLICATING NON-TEMPORAL SOURCE TO TEMPORAL TARGET

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Q Apply always calls
    SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored
    procedure which prevents supporting replication of non-temporal
    source to temporal target.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- All Q Apply users                         *
    *                 2- Synchronized Q Apply with TERM=Y          *
    *                 3- Q Apply                                   *
    *                 4- All SQL Apply users                       *
    *                 5- Global Elite, AIX ETS                     *
    *                 6- All SQL Apply users                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- Q Apply ignores STOP commands in     *
    *                      TERM=N case after Apply encountering    *
    *                      an error                                *
    *                      2- Q Apply does not terminate when      *
    *                      running in synchronized mode (MCG)      *
    *                      with TERM=Y even when update to         *
    *                      IBMQREP_MCGSYNC table fails due to DB2  *
    *                      termination                             *
    *                      3- Q Apply always calls                 *
    *                      SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPOR *
    *                      ALHISTORY stored procedure which        *
    *                      prevents supporting replication of      *
    *                      non-temporal source to temporal target. *
    *                      4- unexpected results when using event  *
    *                      based scheduling                        *
    *                      5- Suspension of monitor for zos        *
    *                      doesn't work correctly.                 *
    *                      6- SQL Apply failed in ASNLOAD with     *
    *                      SQLCODE -104                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Q Apply does not terminate for STOP command when Q Apply
    starts with TERM=N and encounters an error
    2- Q Apply with TERM=Y keeps looping on update of
    IBMQREP_MCGSYNC table even when the update fails with SQL -924
    due to DB2 termination.
    3- Ability needed in Q Apply to disable
    SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored
    procedure call on agent connections to support non-temporal to
    temporal replication.
    4- SQL Apply is applying changes beyond the timestamp specified
    in ASN.IBMSNAP_SUBS_EVENT.END_OF_PERIOD
    5- Suspension of monitor for zos doesn't work correctly.
    6- ASNLOAD failed when loading CCD target tables on LUW because
    the CAST function for IBMSNAP_OPERATION included some z
    specific syntax
    

Problem conclusion

  • 1- Q Apply is changed to set the flag rcvdStop when Apply
    receives a stop command.
    2- Q Apply browser will handle DB2 termination failures
    correctly when updating IBMQREP_MCGSYNC table by terminating
    the Q Apply program.
    3- New Q Apply parameter RECORD_TEMPORALHISTORY=N/Y to control
    whether Q Apply threads will call
    SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored
    procedure to disable DB2 from generating temporal history at
    target. RECORD_TEMPORALHISTORY=N default allows temporal source
    to temporal target replication, whereas,
    RECORD_TEMPORALHISTORY=Y will allow non-temporal source to
    temporal target replication.
    4- If event-based scheduling is in use, set the upper limit of
    replication to max synchpoint in the UOW table with the
    synchtime <= END_OF_PERIOD.
    5- After code changes, the suspension works fine.
    6- Remove z specific syntax in the CAST function for
    IBMSNAP_OPERATION when ASNLOAD loads CCD target tables.
    Note: ASNCLP has been updated from db2_v111m4fp6 s2102031900.
    Function Level: 1140.103
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH33099

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    B33

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-01-05

  • Closed date

    2021-02-10

  • Last modified date

    2021-03-05

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

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

    UI73894 UI73897 UI73895 UI73896

Modules/Macros

  •    ASNACMD  ASNADMSP ASNAISO  ASNAPPLY ASNCAP
    ASNCATM  ASNCCMD  ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS
    ASNCLPQA ASNLOAD  ASNMCMD  ASNMON   ASNQACMD ASNQAPAG ASNQAPP
    ASNQAROW ASNQASUB ASNQBRWZ ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP
    ASNQMFMT ASNQSPIL ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP  ASNTRC
    ASN2BASE
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI73894

       UP21/02/18 P F102

  • RB34 PSY UI73895

       UP21/02/19 P F102

  • RB35 PSY UI73896

       UP21/02/19 P F102

  • RB36 PSY UI73897

       UP21/02/18 P F102

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]

Document Information

Modified date:
06 March 2021