IBM Support

PM20288: CALL TO STORED PROCEDURE IN DB2 V9.1 FAILS WITH SQLSTATE=22 ERRLOC=2:50:2 WITH WTX 8.2.0.4 IF3.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Client observes the following errors in the audit log and
    database trace file when running stored procedure with DB2 on
    z/OS using ODBC adapter:
    
    DB GET failed: error -1009, Failed to execute the SQL statement
    DB GET failed: error -1009,  8r
    DB GET failed: error -13, No error text found
    DB GET failed: error -13, No error text found
    DB GET failed: error -13, No error text found
    Burst 1 : elapsed CPU time 0.16 seconds
      Objects found in burst: 41
      Objects built in burst: 2
      Total objects found: 41
      Total objects built: 2
    
    SYSPRINT (DBL log):
    
    Error in SQLExecute
    Message: {DB2 FOR OS/390}{ODBC DRIVER}  SQLSTATE=22005
    ERRLOC=2:50:2
    SQL State: 22005
    Error in SQLExecute
    Message: {DB2 FOR OS/390}{ODBC DRIVER}  SQLSTATE=22005
    ERRLOC=2:50:2
    SQL State: 22005
    

Local fix

  • WTXCQ - WTX00034871
    CH / CH
    Circumvention: None
    

Problem summary

  • Users Affected:
    WebSphere Transformation Extender z/OS batch command server
    users using ODBC to call a stored procedure.
    
    Problem Description:
    The DB2 API function SQPProcedureColumns does not return
    parameters in the same order as on any other platform.
    
    Platforms Affected:
    OS_Batch(32 BITS)
    

Problem conclusion

  • Code added to sort parameters in parameter order.
    
    Delivered in:
    8.2.0.5, 8.3.0.3
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM20288

  • Reported component name

    WTX COMMAND SER

  • Reported component ID

    5655R9501

  • Reported release

    821

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2010-08-11

  • Closed date

    2010-08-25

  • Last modified date

    2010-09-23

  • 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

    WTX COMMAND SER

  • Fixed component ID

    5655R9501

Applicable component levels

  • R821 PSY

       UP

  • R831 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.2","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
23 September 2010