dbacockpit Alert

[Former Member]

In the dbacockpit there is an alert that 'The tablespace has almost

reached its max number of objects' for the tablespace 'PH3#POOLD '.

I also executed the below query to check the size .

db2 => select substr(tbspace,1, 20) as tbsppace, tbspaceid,count(*)

from syscat.tables where TBSPPACE = 'PH3#POOLD' group by tbspace,tbspaceid

It shows the below data

PH3#POOLD                   12       47488

[former_member289242 · Accepted solution]

Hello Rachit,

PLease implement SAP note 1629407 and validate the issue.

DBA Cockpit: Runtime error OBJECTS_OBJREF_NOT_ASSIGNED

PH3#POOLD                   12       47488

Above mentioned tablespace is approaching the limit of 51000 objects which triggered the message hence I suggest you to implement the note 1019242 in order to avoid this.

Hopefully this will fix the issue.

Best Regards,
Gunjan