6.1.1 or below
This error message is not output for 6.3.1 or above.
This error occurs when an ORDER BY, GROUP BY or JOIN is used for disk tables.
The following error description can be viewed with the AltiErr utility:
The temporary tablespace is used when an ORDER BY, GROUP BY or JOIN is executed on a disk table.
The temporary tablespace is a disk tablespace and has the fixed page size of 8K.
However, this error occurs when a record that is bigger than 8K was created while using the temporary tablespace.
Note: If the size of a single page (8K) of the disk tablespace is exceeded, the data length is approximately greater than or equal to 3000 bytes.
1. You can use the hint ‘TEMP_TBS_MEMORY’ to avoid the size limit (8K) of disk temporary tablespaces.
When this hint is used, the temporary area is used in memory instead of disk. Thus, query performance is also improved.
2. Upgrade to 6.3.1 or above. This error does not occur in 6.3.1 or above.
<How to use a hint>