IBM Support

PI11281: WMQ CSQ5009E CSQ5LIST SQL ERROR FOR TABLE CSQ.OBJ_B_QUEUE, CODE=-501 STATE=24501

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You are running IBM WebSphere MQ for z/OS V7.0.1.  You received
    the following message in the Master joblog.
    CSQ5009E CSQ5LIST SQL error for table CSQ.OBJ_B_QUEUE,
    code=-501 state=24501, data=-315 00000000 00000000
    00000000 00000000
    .
    DB2 SQL-Error: -501
    SQLState: 24501
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of WebSphere MQ for z/OS Version 7 *
    *                 Release 0 Modification 1 and Release 1       *
    *                 Modification 0.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: CSQ5009E message shows SQL error code   *
    *                      -501 on a SQL CLOSE or SQL FETCH call   *
    *                      in CSQ5ALOB.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An EXEC SQL OPEN cursor has been issued from CSQ5ALOB as part of
    a check to see if any new shared queues have been defined. If
    the SQL OPEN fails to open the cursor, the module tries to
    recover from this error. An attempt is made to close the cursor,
    but this fails with error code -501 because the cursor is not
    open.
    

Problem conclusion

  • CSQ5ALOB has been changed to not attempt SQL FETCH or CLOSE
    calls if the SQL OPEN call failed to open the object.
    010Y
    100Y
    CSQ5ALOB
    CSQ5L701
    CSQ5L710
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI11281

  • Reported component name

    WMQ Z/OS V7

  • Reported component ID

    5655R3600

  • Reported release

    010

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-02-07

  • Closed date

    2014-05-15

  • Last modified date

    2014-07-01

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

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

    UI18011 UI18012

Modules/Macros

  • CSQ5ALOB CSQ5L701 CSQ5L710
    

Fix information

  • Fixed component name

    WMQ Z/OS V7

  • Fixed component ID

    5655R3600

Applicable component levels

  • R010 PSY UI18011

       UP14/06/27 P F406

  • R100 PSY UI18012

       UP14/06/27 P F406

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 July 2014