PM59430: EXPLORE DB2 TABLE RETURNS A BLANK SCREEN

Rational Asset Analyzer Fix Pack 8 (6.0.0.8) for 6.0
Rational Asset Analyzer Fix Pack 9 (6.0.0.9) for 6.0
Rational Asset Analyzer for System z Fix Pack 8 (6.0.0.8) for 6.0
Rational Asset Analyzer for System z Fix Pack 9 (6.0.0.9) for 6.0
Rational Asset Analyzer Fix Pack 10 (6.0.0.10) for 6.0
Rational Asset Analyzer for System z Fix Pack 10 (6.0.0.10) for 6.0
Rational Asset Analyzer Fix Pack 11 (6.0.0.11) for 6.0
Rational Asset Analyzer for System z Fix Pack 11 (6.0.0.11) for 6.0

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 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