DB02 --> Space -> Tables--> Does not give any data

[Former Member]

hi,

We have SAP EHP 1 for SAP NetWeaver 7.0.

When we go to DB02 > Space -> Tables> Select * and click OK, we dont get any tables listed

We are having DB2 9.5 Database

Please let me know if you had any similar issue.

We referred to a note, that 1508792, but that is related to Oracle database.

[Former Member · Accepted solution]

Hello,

Please ensure that you have the Reorgchk job scheduled correctly as per note 860724. Check also note 1309424 which contains known problems/fixes for you your release with respect to the dbacockpit. In general, it is advisable to ensure that you are on the latest available basis support package, as it is this SP which generally deliver corrections for any problems in the dbacockpit.

After reorgchk_all is scheduled (and other old jobs are removed) wait until after this job has ran, then check the entries again, all should be updated.

Regards,

Paul

[former_member196032 · Accepted solution]

also schedule the job SAP_COLLECTOR_FOR_PERFMONITOR in client 000 I don't know the note number of the top of my head, but you can search for RSCOLL00

set it up to run hourly