ADM5510E tablespace full in an autoextend tablespace



IBM's flagship relational database management system

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
Riddick
 
Posts: 1
Joined: Tue Sep 13, 2022 1:30 am
Has thanked: 0 time
Been thanked: 0 time

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
engh
 
Posts: 6
Joined: Fri Jul 08, 2022 7:29 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post