IBM Support

JR48300: SQL APPLY FAILS WITH ASN1021E DURING READING SPILL FILES FOR SUBSCRIPTIONS WITH UDB V10 SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL APPLY fails with ASN1021E during reading spill files for
    subscriptions with UDB v10 server.
    

Local fix

Problem summary

  • For v10 CD table, the LSN fields were migrated
    from CHAR(10) to VARCHAR(16), pre-v10 Apply did
    not recognize this change and didn't not
    retrieve the correct LSN value from spill files
    when the subscription was processed in the
    source transactional order .
    

Problem conclusion

  • Change Apply to recognize the v10 source
    server, and reads the correct LSN value from
    spill files for transactional mode
    processing.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR48300

  • Reported component name

    REPLICATION SER

  • Reported component ID

    5724N9800

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-30

  • Closed date

    2013-10-30

  • Last modified date

    2013-10-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    REPLICATION SER

  • Fixed component ID

    5724N9800

Applicable component levels

  • R970 PSY

       UP

[{"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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 October 2013