IBM Support

Apply fails with ASN1053E during execution of ASNLOAD

Troubleshooting


Problem

When full refreshing target tables with asnload, Apply program may fail with either one of these two symptoms: 1. Apply fails during execution of ASNLOAD with message similar to this ASN1053E APPLY "APP1" : "WorkerThread". The execution of the ASNLOAD exit routine failed. The return code is "110". The return code can also be "11" or "-1073741819" or "-1073741571" 2. ASNLOAD program crashes with SIGSEGV This is a problem when using DB2 V9.5 Fix Pack 10, DB2 V9.7 FP7 and FP8, DB2 V10.1 FP2 and FP4, and DB2 V10.5 FP3-FP6

Cause

When ASNLOAD loads a member that contains a column with COL_TYPE=C or COL_TYPE=F, an uninitialized pointer causes unexpected failures.

Resolving The Problem


This defect will be fixed in upcoming DB2 V9.5, V9.7, V10.1 and V10.5 fix packs.

Workaround for DB2 V9.5, V9.7, V10.1:
Copy ASNLOAD from the same version but from an older fix pack that doesn't contain the bug into
new fix pack.

The detailed steps are:

1. Stop the Apply program, if it is not already stopped
2. Do one of these steps depending on your platform:

  • For Linux and UNIX, copy ASNLOAD.bnd from sqllib/bnd
  • For Windows, copy ASNLOAD.bnd from sqllib\bnd
3. Do one of these steps depending on your platform:
  • For Linux and UNIX, copy ASNLOAD from sqllib/bin
  • For Windows, copy ASNLOAD.exe from sqllib\bin
4. Restart the Apply program

If you don't have access to a good version of ASNLOAD and/or you cannot go back to older fix packs that do not contain the problem, then call IBM Support to request a special build.

For DB2 V10.5, install fixpack 7

[{"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"SQL Apply","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.5.0;10.1.0;10.5;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21635836