A fix is available
APAR status
Closed as program error.
Error description
SQL and Q capture can fail to start and issues error ASN0661E if this query returns rows: SELECT DISTINCT TBNAME FROM SYSIBM.SYSFIELDS FOR FETCH ONLY -- The Select checks for the presence of field procs. If any field procs are found, even if the tables are not being replicated, Capture will fail with ASN0661E. -- Capture data may be lost if it is unable to allocate memory for a row.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- Q Apply * * 2- All Capture customers that have one or * * more field procs defined on tables in the * * DB2 system catalog. * * 3- Capture may experience data loss if it * * cannot allocate memory for a row * **************************************************************** * PROBLEM DESCRIPTION: 1- Q Apply does not ensure that * * graphic column data in * * IBMQREP_EXCEPTIONS TEXT includes * * shift-in / shift-out bytes as needed * * for certain CCSIDs. * * 2- DB2 abends Capture with CODE: 004E * * REASON CODE: 00E7000C after Capture * * attempts to query SYSIBM.SYSFIELDS * * using an invalid SQLDA. * * 3- Capture may have data loss if it is * * unable to allocate memory for a row * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Q Apply is not ensuring Shift-in/Shift-out bytes do get added for graphic data in IBMQREP_EXCEPTIONS text for certain CCSIDs that need them. IBMQREP_EXCEPTIONS Text is not pure DBCS so needs SI/SO bytes for embedded graphic data for certain CCSIDs like 1390. 2- DB2 abends Capture with CODE: 004E REASON CODE: 00E7000C after Capture attempts to query SISIBM.SYSFIELDS using an invalid SQLDA. 3- Capture may experience data loss if it is unable to allocate memory for a row
Problem conclusion
1- The problem is fixed. 2- Capture has been modified to query SYSIBM.SYSFIELDS using an invalid SQLDA. 3- The problem is fixed.
Temporary fix
Comments
APAR Information
APAR number
PI59985
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
A21
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-03-30
Closed date
2016-04-25
Last modified date
2016-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI37304 UI37305 UI37306 UI37307
Modules/Macros
ASNAAPP ASNACMD ASNACMP ASNADMSP ASNAFET ASNAISO ASNAPPLY ASNAWPN ASNCAP ASNCCMD ASNMCMD ASNMON ASNQACMD ASNQAPAG ASNQAPP ASNQAROW ASNQBRWZ ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQMFMT ASNQSPIL ASNQXFMT ASNRBASE ASNSQLCZ ASNTDIFF ASNTDSP ASNTRC ASN2BASE ASN2SQLZ
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RA21 PSY UI37304
UP16/05/05 P F605 «
RA24 PSY UI37305
UP16/05/05 P F605 «
RA25 PSY UI37306
UP16/05/05 P F605 «
RA26 PSY UI37307
UP16/05/05 P F605 «
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A21","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 June 2016