Troubleshooting
Problem
Errors seen creating tables in bigsql (local or hadoop tables)
"SYSCATSPACE".. SQLCODE=-289, SQLSTATE=57011, DRIVER=4.23.42
Symptom
In the db2diag log file you would see entries as follows:
2020-01-21-09.11.45.662667+060 E34721710E759 LEVEL: Warning
PID : 21526 TID : 140161602021120 PROC : db2sysc 0
INSTANCE: bigsql NODE : 000 DB : BIGSQL
APPHDL : 0-55839 APPID: *N0.DB2.200126021944
UOWID : 214 ACTID: 24
AUTHID : BIGSQL HOSTNAME: hostname
EDUID : 57286 EDUNAME: db2agntp (BIGSQL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbPrepareToGrowLastRange, probe:160
MESSAGE : ADM6099W Table space "SYSCATSPACE" (ID "0") has reached the maxiumum
size ("549755813888" bytes) for a tablespace of this type and page
size. To add more storage to the database, add a new table space.2020-01-21-09.11.45.664500+060 E34722470E1222 LEVEL: Error
PID : 21526 TID : 140161602021120 PROC : db2sysc 0
INSTANCE: bigsql NODE : 000 DB : BIGSQL
APPHDL : 0-55839 APPID: *N0.DB2.200126021944
UOWID : 214 ACTID: 24
AUTHID : BIGSQL HOSTNAME: hostname
EDUID : 57286 EDUNAME: db2agntp (BIGSQL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateExtent, probe:982
MESSAGE : ADM6044E The DMS table space "SYSCATSPACE" (ID "0") is full. If
this is an autoresize or automatic storage DMS tablespace, the
maximum table space size may have been reached or the existing
containers or storage paths cannot grow any more. Additional space
can be added to the table space by either adding new containers or
extending existing ones using the ALTER TABLESPACE SQL statement. If
this is an autoresize or automatic storage DMS table space,
additional space can be added by adding containers to an autoresize
table space or by adding new storage paths to the storage group it is
using.Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All versions","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 April 2021
UID
ibm11283848