互联网服务
SQL0901N The SQL statement failed because of a non-severe system error.
db2:9.7.0.5 for luw执行以下语句报错ALTER TABLE DB2INST1.TEST ALTER COLUMN LOCATION SET INLINE LENGTH 1024DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQ...显示全部
db2:9.7.0.5 for luw
执行以下语句报错
ALTER TABLE DB2INST1.TEST ALTER COLUMN LOCATION SET INLINE LENGTH 1024
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "LOB length/LOB inline
length is not allowed to shrink".) SQLSTATE=58004
INLINE_LENGTH 旧值 659 COLNAME INLINE_LENGTH COLTYPE
--------------- ------------- --------
LOCATION 659 STRUCT
DESCRIBE TABLE DB2INST1.TEST
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
ID SYSIBM INTEGER 4 0 No
PREFIX SYSIBM VARCHAR 255 0 No
WORKEQUIPMENT_RDFID SYSIBM VARCHAR 255 0 No
ASSET_TYPE SYSIBM VARCHAR 255 0 Yes
NAME SYSIBM VARCHAR 255 0 Yes
DESCRIPTION SYSIBM VARCHAR 1024 0 Yes
ASSET_TYPE_ID SYSIBM VARCHAR 255 0 Yes
ASSET_TYPE_DESCRIPTION SYSIBM VARCHAR 1024 0 Yes
LOCATION DB2GSE ST_GEOMETRY 0 0 Yes
以下是db2diag.log 信息
2013-04-27-06.31.31.606853+000 I1E1563 LEVEL: Event
PID : 11254 TID : 47825580709536PROC : db2diag
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 152 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL09076"
with level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120629", "IP23421", Fix Pack "6".
DATA #2 : System Info, 440 bytes
System: Linux usrl2-scsb-db03 6 2 x86_64
CPU: total:8 online:8 Cores per socket:4294967295 Threading degree per core:1
Physical Memory(MB): total:16058 free:7963
Virtual Memory(MB): total:32437 free:24342
Swap Memory(MB): total:16379 free:16379
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:16384
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:68719476736 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:256000 semIDs:4096 semNum:256000
semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds) = 0xFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFF
Cur stack size (bytes) = 0x00A00000
Cur core size (bytes) = 0x00000000
Cur memory size (bytes) = 0xFFFFFFFF
nofiles (descriptors) = 0x00005000
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2013-04-27-06.31.31.606702+000 I1565E375 LEVEL: Event
PID : 11254 TID : 47825580709536PROC : db2diag
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdDiagArchiveDiagnosticLog, probe:88
CREATE : DB2DIAG.LOG ARCHIVE : /datahome/db2inst1/sqllib/db2dump/db2diag.log_2013-04-27-06.31.31 : success
IMPACT : Potential
2013-04-27-06.31.40.349172+000 I1941E1607 LEVEL: Severe
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, data management, sqldColumnAlter, probe:255
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 53 bytes
LOB length/LOB inline length is not allowed to shrink
DATA #2 : String, 15 bytes
sqldColumnAlter
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00002B763886C996 pdLog + 0x398
[1] 0x00002B763AF4E7C3 sqlzSetAndLog901 + 0x1FB
[2] 0x00002B76396313BE _Z15sqldColumnAlterP8sqeAgentttttthiP10SQLD_VALUEP12SQLD_COLINFOPciS5_iij + 0x1760
[3] 0x00002B763A9B6073 _Z8sqlrlaltP8sqlrr_cbPhsS1_sS1_sS1_sP8sqlrg_pdP17sqlrl_table_parmsilP18sqlrg_datapartinfo + 0x8B75
[4] 0x00002B7639DF3DAB _Z21sqlnq_alter_table_endP9sqlnq_qtb + 0x1CE9
[5] 0x00002B7639DF7CB6 _Z22sqlnq_alter_table_stmtPP8stknode_i10actiontypePhP3loc + 0xB8
[6] 0x00002B763B11735C _Z12sqlnp_smactnP8sqlnp_cbi + 0x94C
[7] 0x00002B7638BDCB0D _Z12sqlnp_parserP8sqlnp_cb + 0x805
[8] 0x00002B7638BDE376 _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x2BA
[9] 0x00002B7638B587E0 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_cmpl_enviiPP9sqlnq_qur + 0xC06
2013-04-27-06.31.40.355393+000 I3549E615 LEVEL: Error
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, data management, sqldColumnAlter, probe:255
DATA #1 : Hexdump, 12 bytes
0x00002B77BF84E0CC : 9302 0000 9302 0100 0000 0000 ............
DATA #2 : Hexdump, 12 bytes
0x00002B77B78991E0 : 0004 0000 0000 0100 0000 0000 ............
2013-04-27-06.31.40.355570+000 I4165E1039 LEVEL: Severe
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlalt, probe:8173
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 53
sqlerrmc: LOB length/LOB inline length is not allowed to shrink
sqlerrp : SQLD08B
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF01 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2013-04-27-06.31.40.355801+000 E5205E1549 LEVEL: Info (Origin)
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 62 bytes
An unexpected error was detected during statement compilation.
DATA #2 : Boolean, 1 bytes
true
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 53
sqlerrmc: LOB length/LOB inline length is not allowed to shrink
sqlerrp : SQLD08B
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF01 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #8 : Hex integer, 4 bytes
0x00000040
DATA #9 : String, 167 bytes
Compiler error stack for rc = -2113667071:
sqlnn_cmpl[300]
sqlnp_main[250]
sqlnp_parser[510]
sqlnp_smactn[100]
sqlnq_alter_table_stmt[110]
sqlnq_alter_table_end[3300]收起
执行以下语句报错
ALTER TABLE DB2INST1.TEST ALTER COLUMN LOCATION SET INLINE LENGTH 1024
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "LOB length/LOB inline
length is not allowed to shrink".) SQLSTATE=58004
INLINE_LENGTH 旧值 659 COLNAME INLINE_LENGTH COLTYPE
--------------- ------------- --------
LOCATION 659 STRUCT
DESCRIBE TABLE DB2INST1.TEST
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
ID SYSIBM INTEGER 4 0 No
PREFIX SYSIBM VARCHAR 255 0 No
WORKEQUIPMENT_RDFID SYSIBM VARCHAR 255 0 No
ASSET_TYPE SYSIBM VARCHAR 255 0 Yes
NAME SYSIBM VARCHAR 255 0 Yes
DESCRIPTION SYSIBM VARCHAR 1024 0 Yes
ASSET_TYPE_ID SYSIBM VARCHAR 255 0 Yes
ASSET_TYPE_DESCRIPTION SYSIBM VARCHAR 1024 0 Yes
LOCATION DB2GSE ST_GEOMETRY 0 0 Yes
以下是db2diag.log 信息
2013-04-27-06.31.31.606853+000 I1E1563 LEVEL: Event
PID : 11254 TID : 47825580709536PROC : db2diag
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 152 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL09076"
with level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120629", "IP23421", Fix Pack "6".
DATA #2 : System Info, 440 bytes
System: Linux usrl2-scsb-db03 6 2 x86_64
CPU: total:8 online:8 Cores per socket:4294967295 Threading degree per core:1
Physical Memory(MB): total:16058 free:7963
Virtual Memory(MB): total:32437 free:24342
Swap Memory(MB): total:16379 free:16379
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:16384
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:68719476736 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:256000 semIDs:4096 semNum:256000
semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds) = 0xFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFF
Cur stack size (bytes) = 0x00A00000
Cur core size (bytes) = 0x00000000
Cur memory size (bytes) = 0xFFFFFFFF
nofiles (descriptors) = 0x00005000
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2013-04-27-06.31.31.606702+000 I1565E375 LEVEL: Event
PID : 11254 TID : 47825580709536PROC : db2diag
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdDiagArchiveDiagnosticLog, probe:88
CREATE : DB2DIAG.LOG ARCHIVE : /datahome/db2inst1/sqllib/db2dump/db2diag.log_2013-04-27-06.31.31 : success
IMPACT : Potential
2013-04-27-06.31.40.349172+000 I1941E1607 LEVEL: Severe
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, data management, sqldColumnAlter, probe:255
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 53 bytes
LOB length/LOB inline length is not allowed to shrink
DATA #2 : String, 15 bytes
sqldColumnAlter
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00002B763886C996 pdLog + 0x398
[1] 0x00002B763AF4E7C3 sqlzSetAndLog901 + 0x1FB
[2] 0x00002B76396313BE _Z15sqldColumnAlterP8sqeAgentttttthiP10SQLD_VALUEP12SQLD_COLINFOPciS5_iij + 0x1760
[3] 0x00002B763A9B6073 _Z8sqlrlaltP8sqlrr_cbPhsS1_sS1_sS1_sP8sqlrg_pdP17sqlrl_table_parmsilP18sqlrg_datapartinfo + 0x8B75
[4] 0x00002B7639DF3DAB _Z21sqlnq_alter_table_endP9sqlnq_qtb + 0x1CE9
[5] 0x00002B7639DF7CB6 _Z22sqlnq_alter_table_stmtPP8stknode_i10actiontypePhP3loc + 0xB8
[6] 0x00002B763B11735C _Z12sqlnp_smactnP8sqlnp_cbi + 0x94C
[7] 0x00002B7638BDCB0D _Z12sqlnp_parserP8sqlnp_cb + 0x805
[8] 0x00002B7638BDE376 _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x2BA
[9] 0x00002B7638B587E0 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_cmpl_enviiPP9sqlnq_qur + 0xC06
2013-04-27-06.31.40.355393+000 I3549E615 LEVEL: Error
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, data management, sqldColumnAlter, probe:255
DATA #1 : Hexdump, 12 bytes
0x00002B77BF84E0CC : 9302 0000 9302 0100 0000 0000 ............
DATA #2 : Hexdump, 12 bytes
0x00002B77B78991E0 : 0004 0000 0000 0100 0000 0000 ............
2013-04-27-06.31.40.355570+000 I4165E1039 LEVEL: Severe
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlalt, probe:8173
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 53
sqlerrmc: LOB length/LOB inline length is not allowed to shrink
sqlerrp : SQLD08B
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF01 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2013-04-27-06.31.40.355801+000 E5205E1549 LEVEL: Info (Origin)
PID : 4698 TID : 47792496044352PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-10701 APPID: *LOCAL.db2inst1.130427061500
AUTHID : DB2INST1
EDUID : 441 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 62 bytes
An unexpected error was detected during statement compilation.
DATA #2 : Boolean, 1 bytes
true
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 53
sqlerrmc: LOB length/LOB inline length is not allowed to shrink
sqlerrp : SQLD08B
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF01 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #8 : Hex integer, 4 bytes
0x00000040
DATA #9 : String, 167 bytes
Compiler error stack for rc = -2113667071:
sqlnn_cmpl[300]
sqlnp_main[250]
sqlnp_parser[510]
sqlnp_smactn[100]
sqlnq_alter_table_stmt[110]
sqlnq_alter_table_end[3300]收起