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