DB2 Tablespace has no space SQLcode -960 SQLState=57011
0
votes
2
answers
271
views
Our application is inserting and updating records into a DB2 database. It's been running for about 3 years, and we encountered an error SQLcode -960 SQLState=57011 SQLERRMC=IS_SMALL_TS
The tablespace details are as follows:
Tablespace ID = 5
Name = IS_SMALL_TS
Tуре =- Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 894976
Number of useable pages = 894972
Number of used pages = 893844
Number of free pages =1128
High water mark (pages) =893844
Page size (bytes) =16384
Extent size (pages) =4
Prefetch size (pages) =4
Number of containers =1
The Db2level info is as follows:
D: \IBM\SQLLIB\BIN>db2level
DB21085I
This instance or install (instance name, where applicable: "DB2")
uses "64" bits and DB2 code release "SQL11014" with level identifier
0205010F.
Informational tokens are "DB2 v11.1.4050.859", "51911120160",
DYN1911120100WIN64 , and Fix Pack "5".
Product is installed at "D:\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".
We read through IBM Manual and tried a few thing including Alter tablespace IS_SMALL_IS increase 30 percent but don't see any changes. What can we do?
Asked by Effendi Baba
(11 rep)
Jun 10, 2024, 08:49 AM
Last activity: Jul 16, 2024, 08:49 AM
Last activity: Jul 16, 2024, 08:49 AM