IBM Support

PH28162: SQL/REP Z/OS TO NON Z/OS: SQL APPLY RECEIVING A -551 OR -204 OR ANY OTHER ERROR ON A TRUNCATE OPERATION SHOULD BE TOLERATED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Apply receives sqlcode -551 on a Truncate operation when
    replicating data from z/OS to non z/OS target in a SQL
    Replication configuration.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- EP customers                              *
    *                 2- All SQL Apply users                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- When you create or alter a           *
    *                      publication with delimited messages by  *
    *                      using the ASNCLP command-line program   *
    *                      in Event Publishing, the ASNCLP         *
    *                      program incorrectly allows you to       *
    *                      specify a BEFORE VALUES option of N     *
    *                      (no before values are sent). Before     *
    *                      values must be sent for delimited       *
    *                      messages, so the only valid option for  *
    *                      BEFORE VALUES is Y (yes).               *
    *                      2- Apply receives sqlcode -551 on a     *
    *                      Truncate operation when replicating     *
    *                      data from z/OS to non z/OS target in a  *
    *                      SQL Replication configuration.          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- The ASNCLP program should check the specified BEFORE VALUES
    option and if the N option is specified issue an error message
    and not create the delimited publication.
    2- SQL Apply should tolerate any error when accessing the Db2
    catalog to determine if a TRUNCATE table should be performed.
    

Problem conclusion

  • 1- With this fix, the ASNCLP program issues the ASN2019E error
    message if the N option is specified and does not create the
    publication.
    2- SQL Apply will perform a DELETE table when it fails to
    access the Db2 catalog for information required for target
    table processing.
    Note: ASNCLP has been updated from db2_v111m4fp6 n2008201900.
    Function Level: 1140.103
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH28162

  • 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

    2020-08-04

  • Closed date

    2020-08-25

  • Last modified date

    2020-10-01

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

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

    UI71219 UI71220 UI71221 UI71222

Modules/Macros

  •    ASNAAPP  ASNACMD  ASNADMSP ASNAPPLY ASNCAP
    ASNCATM  ASNCCMD  ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS
    ASNCLPQA ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQCAP  ASNQCCMD
    ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP
    ASNTRC   ASN2BASE
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI71219

       UP20/09/02 P F009

  • RB34 PSY UI71220

       UP20/09/03 P F009

  • RB35 PSY UI71221

       UP20/09/02 P F009

  • RB36 PSY UI71222

       UP20/09/02 P F009

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:
02 October 2020