SQL Codes › SQL Return Codes -1 through -999 › -561 - TTM TOO SMALL, SEE ERROR ACTION

-561 - TTM TOO SMALL, SEE ERROR ACTION

Explanation

You issued an ALTER TABLE statement that involves an operation which requires:

1. Copying the contents of the table to the Temporary Table Manager (TTM),
2. Changing the definition of the table, and then
3. Copying the reformatted rows back to the table.

However, a check is made before this operation begins to see if enough space is available in the TTM, and if the answer is no, this message is generated.

The SQLSTATE that equates to this SQL return code is 57S05.

User Response

You can make the TTM larger, but it can take a long time to perform this operation if there are many rows in the table. Therefore, instead of making the TTM larger consider doing the following:

1. Copy the rows to an external file with the DBUTLTY function EXTRACT,
2. Convert the rows yourself, and then
3. Load them back.

You can still use ALTER TABLE to change the definition of the table, but null load the area first so that there are no rows to copy to the TTM.