Troubleshooting
Problem
The SQL0659N error might be returned when running a load indicating that a maximum size of a table object has been reached.
Symptom
The db2diag.log can show the following:
2011-10-15-02.45.01.172933+060 I48912883A572 LEVEL: Warning
PID : 12910774 TID : 41181 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-32010 APPID: *LOCAL.db2inst1.123451234500
AUTHID : DB2INST1
EDUID : 41181 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:312
DATA #1 : String, 140 bytes
LOADID: 39658.2011-10-15-02.45.01.047795.0 (8;4)
Starting LOAD phase at 10/15/2011 02:45:01.172728. Table DB2INST1
.TESTTAB
2011-10-15-05.44.15.618137+060 I48913456A528 LEVEL: Error
PID : 12910774 TID : 44775 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-32010 APPID: *LOCAL.db2inst1.123451234500
AUTHID : DB2INST1
EDUID : 44775 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 108 bytes
LOADID: 39658.2011-10-15-02.45.01.047795.0 (8;4)
, -2080112630, 0, Detected in file:sqluDMSort.C, Line:1519
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tables","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","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
Modified date:
30 April 2025
UID
swg21572017