PM75708: New queue request type (07) taking a long time postprocessing relational data base load assets

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Scan step DMHQUEUE hangs in fixpak 6.0.0.9. Upon inspecting the
    scan job, the output shows the long running step is stuck on
    processing queue type "07".
    
    DMH1761I Start processing queue type 07. POSTPROCESS RDB LOAD.
    DMH1762I   Queue type=07 RC=0 for DB2 system id=4_1116952380
    

Local fix

Problem summary

  • The former DB2-SQL reference resolution design assumed the DB2
    catalog scans would not be done very frequently.  To that end,
    updates were made in Fix Pack 9 to introduce a new queue type
    (Postprocess RDB load) that started with clearing the DB2
    foreign keys and recalculating  them.  As a result, a row
    corresponding to this new queue type was inserted for every DB2
    catalog load that was run.  For cases where scanning and loading
    of DB2 catalog data is performed more frequently, sometimes
    daily, and especially under conditions of very large volumes of
    meta data, the postprocessing might never complete.  This forced
    manual removal of queue rows corresponding to this particular
    type in order for postprocessing to be able to continue for Run
    unit building, for example.
    

Problem conclusion

  • The postprocessing approach of zeroing out and recalculating all
    foreign keys emanating from Program SQL references to DB2
    catalog assets has been modified to influence only those assets
    that are impacted when new or changed DB2 catalog assets are
    detected. This, along with introduction of a unique placeholder
    DB2 system per Site, improves postprocessing efficiency and
    foreign key relationship building results.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM75708

  • Reported component name

    RAA FOR SSTEM Z

  • Reported component ID

    5655W5700

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-23

  • Closed date

    2012-11-12

  • Last modified date

    2014-08-04

  • 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

    RAA FOR SSTEM Z

  • Fixed component ID

    5655W5700

Applicable component levels

  • R600 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Asset Analyzer

Software version:

6.0

Reference #:

PM75708

Modified date:

2014-08-04

Translate my page

Machine Translation

Content navigation