IBM Support

II11809: INFORMATIONAL APAR II11809 INFOSPHERE REPLICATION SERVER FOR ZOS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as canceled.

Error description

  • Order of contents.
    1. Information and JCL for downloading PTFs from FTP site
    2. V11.4 latest APAR and PTF's available
    3. V10.2.1 latest APAR and PTF's available
    4. Replication Server PMR and APAR search keywords
    5. Hints and tips
    6. Recommended DB2 APARs
    
    ***********************************************************
    1. Information and JCL for downloading PTFs from FTP site
    The latest PTFs are found on the testcase.boulder.ibm.com
    FTP server.  They are located in the directory:
     /fromibm/im/dataprop
    If you need a PTF and it's not on the FTP site
    send an email to Richard Drakulich, [email protected].
    
    These files are not tersed so be sure to receive them into a
    FB LRECL 80 dataset and download as BIN.
    
    JCL for downloading these PTF's is located at this web site:
     http://ibm.co/H8vfAw
    
    ***********************************************************
    2.
    The most recent v11.4 APAR/PTF's as of Mar 30 2020
    
    Feature                 FMID      PTF      APAR
    V11.4   Common Base     JAAWB32   UI79876  PH44950
    V11.4   Q Capture       JAAWB34   UI79877  PH44950
    V11.4   Q Apply         JAAWB35   UI79878  PH44950
    V11.4   SQL Replication JAAWB36   UI79879  PH44950
    
    PH40710 is latest Refresh APAR shipped 09/2021
    
    
    
    
    
    
    ***********************************************************
    3.
    The most recent V10.2.1 APAR/PTF's as of June 4th 2020
    
    
    Feature                 FMID    PTF      APAR
    V10.2.1 Common base     HAAWA21 UI69886  PH24517
    V10.2.1 Q Capture       JAAWA24 UI69887  PH24517
    V10.2.1 Q Apply         JAAWA25 UI69888  PH24517
    V10.2.1 SQL Replication JAAWA26 UI69889  PH24517
    
    
    
    ***********************************************************
    ***********************************************************
    4.
     The following keywords are added to Replication PMRs for
     enhancing Retain search cababilities:
     QCAPTURE
     QAPPLY
     REPCENTER
     SQLCAPTURE
     SQLAPPLY
     PERFORMANCE
     ABENDSXXX      -  EX: ABENDS0C4
     SQLXXXXN       -  EX: SQL1024N
     EVENTPUBLISH
     ASNMON
     MSGASNXXXXX    - EX: MSGASN1054E
     TOOLS
     FULLREFRESH
     COLDSTART
     MQRCxxxx       - EX: MQRC2035  (MQRC_NOT_AUTHORIZED)
    *****************************************************
    5. Hints and tips
    If capture or apply job issues ASN0531E with RC f30034
    run this query to verify the userid running capture or
    apply has authority to use the plan.
    SELECT * FROM SYSIBM.SYSPLANAUTH WHERE
    NAME = 'ASNTxxxx' AND GRANTEE = 'yyyy';
    where ASNTxxxx is the plan name and yyyy is the userid.
    ------------------------------------------------------
    SQL Capture issues ASN0013E:
      The Capture program required a column that was not
      defined in the change-data (CD) table.  The table name
      is "<table_name>".
    A common cause of this error is the definition of the
    columns, IBMSNAP_COMMITSEQ and IBMSNAP_INTENTSEQ
    with the option FOR BIT DATA.
    ALTER TABLE !CD_OWNER!.!CD_TABLE! ALTER COLUMN
    IBMSNAP_COMMITSEQ SET DATA TYPE VARCHAR(16) FOR BIT DATA;
    - and -
    IBMSNAP_INTENTSEQ SET DATA TYPE VARCHAR(16) FOR BIT DATA;
    
    Also make sure that the datatype is VARCHAR.
    
    *******************************************************
    6. Recommended DB2 APARs
    
    DB2 V13 - You must be at APAR IIDR 1140 APAR PH39026 or later
    
    DB2 V12 APARs recommended for Replication.
    PH43814  for z/OS users of IFCID 306
    ABEND04E RC00C90101
    in DSNIDCVL:50C8
    * during IFCID 306 READS request to
    * convert data in the version that was
    * current at the time the delete log
    * record was written.
    PH42417   Missing Db2 log record at QREP
    Active/Active replication target
    PH01117 corrects Qcapture/SQL capture
    00E60830 error
    
    PI93252 During an IFI306 READ by QREP QCAPTURE, Db2
    RC00C900B0
    
    
    DB2 V11 APARs recommeded for Replication:
    PH20625: CDC/Qrep/SQLrep
     HANG BECAUSE THREAD ENCOUNTERS DECOMPRESSION ERROR AND THEN
     LOOPS IN COMMIT PHASE Added November 25, 2015
    
    HIPER PI50992
    Replication data loss is possible.
    APAR PI50992, PTF UI32571
    With Db2 V11 only, both SQL and Q Capture can get
    ASN0725E, LOG RECORDS OUT OF ORDER ON BOTH 6 AND
    10 BYTE RBA / LRSN.
    Additional symptoms ASN0633W ASN0634W ASN0726E
    
    Both DB2 V11/V12 Apars
    PH19985  ABEND0C4 DSNIDALC when processing
    IFCID 306 records.
    The abend occurs because the CTDYMLST pointer storage has
    already been freed.
    
    
    PH28849 Memory Leak with IFI306 and compression dictionaries
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • close for internet viewing
    

APAR Information

  • APAR number

    II11809

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    CLOSED CAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    1999-04-23

  • Closed date

    1999-05-29

  • Last modified date

    2022-06-10

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19O","label":"DB2 for z\/OS"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"001"}]

Document Information

Modified date:
11 June 2022