PM59430: EXPLORE DB2 TABLE RETURNS A BLANK SCREEN

Fixes are available

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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
29 June 2020

Tips

PM59430: EXPLORE DB2 TABLE RETURNS A BLANK SCREEN

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

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

Fixed component ID

Applicable component levels

Document Information

Share your feedback

Need support?