Maximum number of objects in tablespace

[Former Member]

Hello everybody,

I've got message in DBACOCKPIT/Alerts/Alert Monitor about number of objects in tablespace.

My question is how to check how many objects are already in tablespace?.

I have found in DB2 docs that *Max # of table 'objects' in a DMS tablespace: 51000.*

I want to prevent situation described in note 1019242.

Regards

Michal

[Former Member · Accepted solution]

I've found proper SQL. To others with the same problem below correct SQL query:

  select tbspace, count(*) from syscat.tables group by tbspace