IBM Mainframe Forum

Hello
I have an N2 level on db2, and i had some trouble understanding an erreor message.

we hd the following error on our db2 diag file,

2022-09-08-15.39.54.974797+120 E2466871A550 LEVEL: Error PID : 8192090 TID : 8012 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : XXXX : 0-45827 APPID: 10.11.0.218.54984.220908102500 AUTHID : XXXX EDUID : 8012 EDUNAME: db2agent (XXXX) FUNCTION: DB2 UDB, data management, sqldInsertRow, probe:1 MESSAGE : ADM5510E The table space "USERSPACE1" (ID "2") is full. There is no more room in the internal object table of this table space.

I checked our tablespace and it is in autoextend with unlimited size, and there is plenty of space in the filesystem.

Could anyone please point me toward the probleme, why db2 says tablespace is full ?

Many thanks in advance

Possibly you have reached the limit of the number of Z/OS extents

See here :
https://www.ibm.com/docs/en/zos/2.3.0?topic=sets-using-vsam-extents