IBM Support

PM69441: ABEND04E RC00E2001F DSNXRTSC DSNSVBK AT X'0744' OFFSET0744

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • ABEND04E RC00E2001F DSNXRTSC.DSNSVBK + 0744 and CSA becomes
    exhausted.  The issue is due to a storage leak for SQLCA and
    other control blocks.
    Lock  Manager Global Subpool is the pool affected in the
    MSTR address space.
    Keyword DB2STGLK/K SYSPLEX SQLSYSPLEXP
    This APAR will be closed as a SUGGESTION.
    

Local fix

  • Since the issue happens only with sysplex query parallelism,
    you can disable sysplex query parallelism or parallelism in
    general, by specifying CURRENT DEGREE(1)
    Alternatively, instead of disabling all of parallelism, you
    can turn off the COORDINATOR and ASSIST zparms to disable
    CP query parallelism.
    

Problem summary

Problem conclusion

Temporary fix

Comments

  • For a user to encounter this scenario, a large number of
    parallel sysplex threads (in the thousands) must be suspended in
    IRLM (CSECT DSNTLSUS) and all of these threads must be cancelled
    at the same time.  This scenario is extremely unlikely and does
    not justify the risk of shipping a fix in the service stream.
    
    The fix described is accepted as a requirement for a future
    change in the product design.
    
    Defect d162086 has been opened to track this problem.
    

APAR Information

  • APAR number

    PM69441

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED SUG

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-23

  • Closed date

    2012-09-11

  • Last modified date

    2012-09-11

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 September 2012