PM59430: EXPLORE DB2 TABLE RETURNS A BLANK SCREEN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When user performs 'Explore MVS Assets' and clicks the link for
    DB2 tables, RAA returns a blank screen with no matching data
    
    In the WebSphere Application Server joblog, the following
    message was observed: com.ibm.dmh.db.SQLRuntimeException: Query
    .SELECT count(*) FROM マ(SCHEMA).dmh_db2_subsystem GROUP BY name
    HAVING count(*) > 1
    

Local fix

Problem summary

  • Attempt to use browser interface Explore option for DB2 table,
    column or stored procedure assets returns a blank page, and WAS
    log reports exception:
        com.ibm.dmh.db.SQLRuntimeException: Query . SELECT count(*)
    FROM $(SCHEMA).dmh_db2_subsystem GROUP BY name HAVING count(*) >
    1 was supposed to return 1 row, but returned x rows.
    

Problem conclusion

  • Incorrect query for counting the number of duplicate named DB2
    subsystems has been corrected.
    

Temporary fix

  • Apply RAA 6.0.0.8 Fixpak
    

Comments

APAR Information

  • APAR number

    PM59430

  • 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-03-01

  • Closed date

    2012-04-16

  • Last modified date

    2013-02-07

  • 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 #:

PM59430

Modified date:

2013-02-07

Translate my page

Machine Translation

Content navigation