Troubleshooting
Problem
Customer is performing a command to REORG a table like below: REORG TABLE DB2INST1.EMPLOYEE ALLOW READ ACCESS ...and then receive the following error.... SQL2216N SQL error "-668" occurred while reorganizing a database table or its indexes.
Symptom
SQL2216N SQL error "-668" occurred while reorganizing a database table or its indexes.
The db2diag.log would have an entry similar to below:
2016-07-22-10.17.24.256308-300 E26178635A1106 LEVEL: Error
PID : 7602310 TID : 15167 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : SAMPLE
APPHDL : 0-38674 APPID: *LOCAL.db2inst.160728172241
AUTHID : DB2INST
EDUID : 15177 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateExtent, probe:840
MESSAGE : ADM6044E The DMS table space "TABLESPACE1" (ID "57") 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 an automatic storage database.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tablespaces","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;11.1;9.7;9.8","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
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
More support for:
Db2 for Linux, UNIX and Windows
Software version:
10.1, 10.5, 11.1, 9.7, 9.8
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
549747
Modified date:
01 May 2025
UID
swg21989073
Manage My Notification Subscriptions