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. V10.2.1 latest APAR and PTF's available
    3. V10 latest APAR and PTF's available
    4. V9  latest APAR and PTF's available
    5. V9 comparable versions with LUW code.
    6. DB2 V10 migration notes for Replication Server
    7. List of Replication Server HIPER APARs
    9. Replication Server PMR and APAR search keywords
    10. Hints and tips
    11. 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 Marsh Weiershausen, mmweiers@us.ibm.com,
    or Jim Stewart, jgstew@us.ibm.com and we can upload the PTF.
    
    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 V10.2.1 APAR/PTF's as of Aug 21, 2015.
    
    Feature                 FMID    PTF      APAR
    V10.2.1 Common base     HAAWA21 UI30287  PI44940
    V10.2.1 Q Capture       JAAWA24 UI30288  PI44940
    V10.2.1 Q Apply         JAAWA25 UI30289  PI44940
    V10.2.1 SQL Replication JAAWA26 UI30290  PI44940
    
    ***********************************************************
    3.
    The most recent V10 APAR/PTF's as of Jun, 2014.
    
    Feature             FMID    PTF      APAR
    V10 Common base     HAAWA10 UI28355  PI40890
    V10 Q Capture       JAAWA11 UI28356  PI40890
    V10 Q Apply         JAAWA12 UI28357  PI40890
    V10 SQL Replication JAAWA13 UI28358  PI40890
    
    
    ***********************************************************
    
    4.
    The most recent V9 APAR/PTFs   As of Mar 03, 2014.
    .
    Please note that V9 of Replication Server for z/OS
    has gone out of support as of September 30, 2014.
    Details on the web at: ibm.biz/BdRVN3
    .
    Feature             FMID    PTF      APAR
    V9 Common base      HAAW910 UI15602  PM98752
    V9 Q Capture        JAAW911 UI15603  PM98752
    V9 Q Apply          JAAW912 UI15604  PM98752
    V9 SQL Replication  JAAW913 UI15605  PM98752
    ***********************************************************
    5.
    Comparable LUW level with APAR/PTF
     Version   APAR      PTF
     9.5     = PK49430 / UK30897
     9.7     = PK85947 / UK49232
     9.7 FP2 = PM08482 / UK59166
    ***********************************************************
    6.
    Addtional information for migration to Db2 Version 10.
    Db2 pre-migration job DSNTIJPA might flag all of the
    ASN* packages because they are bound with DEGREE(ANY).
    Replication Server packages should be rebound when
    migrating to Db2 10.           (Jan 27 2012)
    See APAR PM96954 for HIPER information on upgrading
    Db2 10 from CM to NFM with Replicaiton Server V10.
    Avoid DDL changes during the conversion process unless
    APAR PM96954 is installed.
    ***********************************************************
    7.
    Replication HIPER APARs
    V10
     PM73086 Nov 09, 2012 - SQL capture, remote possibility of
             data loss during retention prune.  Details in APAR.
     PM58699 Mar 26, 2012
     PM96954 April 2014 for customers converting Db2 V10
             from CM to NFM using SQL replication.
             See the APAR Hiper text for details.
    PI14437 - Qcapture restart problem if duplicate LSN's
    are encountered.
    V9
     PM23762 May 07, 2014
     PM58694 Mar 02, 2012
     PM56294 Feb 06, 2012
     PM55656 Jan 20, 2012
     PM22432 Sep 27, 2010
     PM04195 Jan 08, 2010
     PK95565 Sep 30, 2009
     PK84389 Apr 22, 2009
    ***********************************************************
    8.
     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)
    *****************************************************
    10. 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;
    *******************************************************
    11. Recommended DB2 APARs
    
    Updated July 2015.
    PI41630 (PTF UI28315):
    SOME DB2 LOG RECORDS ARE NOT REPLICATED
    
    PI42170 (APARFIX available):
      On DB2 11 data sharing systems, a cancel window exists
      in log write where a log record with LRSN value of
      'FFFFFFFFFBAD'x could be written to the log data set on
      systems that have not converted BSDS datasets to use 10
      byte RBA values.
    Details on PI41640 and PI42170 availble at:
    https://ibm.biz/BdXpXB
    
    This HIPER DB2 APAR affects both V10 and V11 of Db2
    PI21358 - QREP MIGHT RETURN RC00C90064 IF THE DICTIONARY IS
              BUILT BY INSERT ON ANOTHER MEMBER.
    The PTF's are:
    V10 UI23321
    V11 UI23322
    
    Db2 V11 APARs and PTFs recommended for replication.
     PI09978 / UI16673 - DB2 V11 IFI 306 RETURNS AN INVALID
     XID OFFSET IF THE BEGIN-UR LOG RECORD WAS WRITTEN BY A
     V10 DATA SHARING MEMBER
    
     PI36052 / UI26317 - ABEND04E RC00C90101 IN DSNIFDCI
     ERQUAL 5123 AND MSGDSNJ113E GOT BY QREP AFTER A REORG OF
     A COMPRESSED TABLESPACE IN DB2 V11 CM
    
    
    
    
    
    Db2 V10 APARs recommended for replication.
    
     PI36900 / UI25944 - IFI READ ABENDS0C4 PIC04 RC04 IN
     DSNIDLGR OFFSET2F6E DURING LOG RECORD DECOMPRESSION
    
    PM05503 - lifts restrictions for Alter Table Set Data Type
    when table is defined with change data capture.
    
    PM98429 - Compression dictionary enhancements for replication.
    
    PM51663 and PM89162 (HIPER) - keeps data capture bit on during
    reorg of SYSIBM.SYSTABLESPACE, SYSIBM.SYSCOLUMNS, and
    SYSIBM.SYSTABLES
    
    PM90568 - IFI 306 LOG READ DBID/PSID FILTERING SUPPORT
    
    PM61324 (HIPER) - prevent ABEND04E for Qrep when NUMPARTS
    changed to smaller value
    
    PM84298 - Qcapture received RC00C90063 for an unavailable
    dictionary after migrating to Version 10 NFM.
    
    PM84864 (HIPER) - IFI306 READS RETURNS THE WRONG LOG RANGE.
    
    Db2 V11 APARs recommended for replication.
    PI09978  DB2 V11 IFI 306 RETURNS AN INVALID XID OFFSET IF THE
    BEGIN-UR LOG RECORD WAS WRITTEN BY A V10 DATA SHARING
    MEMBER.
    PI36900 IFI READ ABENDS0C4 PIC04 RC04 IN DSNIDLGR OFFSET2F6E
            DURING LOG RECORD DECOMPRESSION WITH RC00E60863
    

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

  • Submitted date

    1999-04-23

  • Closed date

    1999-05-29

  • Last modified date

    2015-08-25

  • 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



Document information


More support for:

z/OS family

Software version:

001

Operating system(s):

MVS

Reference #:

II11809

Modified date:

2015-08-25

Translate my page

Content navigation