A fix is available
APAR status
Closed as program error.
Error description
If SQL capture detects a permanent compression dictionary error, ASN0011E with RC 00C90064 and option stopOnError=N capture deletes the table registration from memory without unlinking the table registration. Capture will then issue abend0c4 when it attempts to locate another table in memory.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- non-parallel ASNTDIFF * * 2- SQL capture * * 3- SQL Capture customers. * **************************************************************** * PROBLEM DESCRIPTION: 1- When the spill file (2GB at most) * * is not large enough, the customer will * * get the following message: "asntdiff * * fseek errno: : EDC5027I The position * * specified to fseek() was invalid. * * (errno2=0xC03D0020)". * * 2- ASN0070 when trying to register a * * table with 2 columns that have very * * similar names. The first column is 17 * * characters and the second column is * * the exact same name concatenated with * * an 18th character. This only occurs * * when there is a before image prefix * * specified. * * 3- SQL Capture started specifying * * STOP_ON_ERROR = 'N' terminates with * * ABENDS0C4 after displaying ASN0011E. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Non-parallel ASNTDIFF requires a spill file for storing key values, but the spill file (2GB at most) might be not large enough to hold all the key values. 2- Capture was incorrectly checking for 18 character column names and treating them as if 18 were the maximum column name length. DB2 V7 had maximum column name lengths of 18. 3- SQL Capture stops a source table registration and removes the registration information from its memory if it was started specifying STOP_ON_ERROR = 'N' and the DB2 compression dictionary for the source table no longer exists. SQL Capture terminates with ABENDS0C4 when it references the source table registration information it has removed.
Problem conclusion
1- An ASN message ASN4076E is issued to indicate that the users should split and compare the source and target tables. 2- Capture will correctly load and activate this registration. 3- Modify SQL Capture to fix this problem.
Temporary fix
Comments
APAR Information
APAR number
PM76956
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-11-12
Closed date
2012-12-04
Last modified date
2013-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PM76957 UK83989 UK83990 UK83991 UK83992
Modules/Macros
ASNACMD ASNADMSP ASNAPPLY ASNCAP ASNCCMD ASNCCPWK ASNCDINS ASNMCMD ASNMIG8 ASNMON ASNPLXFY ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP ASNQCAP ASNQCCMD ASNQDEP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF ASNTRC ASN2BASE
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
R910 PSY UK83989
UP12/12/13 P F212
R911 PSY UK83990
UP12/12/14 P F212
R912 PSY UK83991
UP12/12/13 P F212
R913 PSY UK83992
UP12/12/13 P F212
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":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 January 2013