ADM5510E tablespace full in an autoextend tablespace

IBM's flagship relational database management system
Riddick
Posts: 1
Joined: Tue Sep 13, 2022 1:30 am
Skillset: db2
Referer: google

ADM5510E tablespace full in an autoextend tablespace

Postby Riddick » Tue Sep 13, 2022 1:44 am

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

engh
Posts: 17
Joined: Fri Jul 08, 2022 7:29 pm
Skillset: leblesmoutilabiskouti
Referer: leblesmoutilabiskouti

Re: ADM5510E tablespace full in an autoextend tablespace

Postby engh » Wed Sep 21, 2022 2:29 pm

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