IBM Support

IY97524: JCC CLIENT GETS SQLCODE -964 DURING A NON-ATOMIC MULTI-ROW INPUT REQUEST. IT EXPECTS AN SQLCA FOR EACH ROW, BUT GETS ONLY ONE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • JCC client gets sqlcode -964 (transaction log full) when
    issuing a non-atomic multi-row input request. It expects an
    SQLCA for each row, but gets only one.
    If the APAR fix is not applied, an exception in the JCC
    application may occur.
    The sypmtoms of the exception are similar to the following:
    03-08-2007 14:55:30.507: ExecExceptionIgnore.eventPerformed(0)
    (Chained) Ignoring SQL error: Error Code: -964, SQLState: 57011
    03-08-2007 14:55:30.507: ExecExceptionIgnore.eventPerformed(0)
    Message: Error for batch element #1: DB2 SQL error: SQLCODE:
    -964, SQLSTATE: 57011, SQLERRMC: null
    03-08-2007 14:55:30.507: ExecExceptionIgnore.eventPerformed(0)
    JCC SQLCA:
    SQLCA Information
    sqlcode : -964
    sqlerrmc: null
    sqlerrp : SQLRI039
    sqlerrd : (1) -2062548983 (2) 9 (3) 0
    (4) 0 (5) -1039 (6) 1
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate: 57011
    

Local fix

Problem summary

  • JCC CLIENT GETS SQLCODE -964 DURING A NON-ATOMIC MULTI-ROW INPUT
     REQUEST. IT EXPECTS AN SQLCA FOR EACH ROW, BUT GETS ONLY ONE.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IY97524

  • Reported component name

    DB2 EDE AIX

  • Reported component ID

    5724N7600

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-04-18

  • Closed date

    2008-01-22

  • Last modified date

    2008-01-22

  • 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

    DB2 EDE AIX

  • Fixed component ID

    5724N7600

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 January 2022