On 10.5 fp9 (db2_v105fp9_aix64_s161123) -> 11.1 fp1
(db2_v111m1fp1_aix64_s1611241300) , if the ADC was created
already on 10.5 fp9, it hit -901 whenever there were alter and
add column in the same statement. If standalone with only one
clause, it ran successful.
alter table POPS.CUSTOMER_GRP alter column CUST_GRP_NAME SET
DATA TYPE VARCHAR(160) add column new_col3 integer
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 or command failed because of a
database system
error. (Reason "Can only inplace update the head rec of a
multi-page record".)
SQLSTATE=58004
db2diag.log:
2016-11-25-23.57.53.209655-300 I926705A5609 LEVEL: Error
PID : 27328630 TID : 40873 PROC :
db2sysc
INSTANCE: svtdbm5 NODE : 000 DB : BLUDB
APPHDL : 0-1244 APPID:
*LOCAL.svtdbm5.161126045749
AUTHID : SVTDBM5 HOSTNAME: svtreg4
EDUID : 40873 EDUNAME: db2agent (BLUDB)
FUNCTION: DB2 UDB, CDE Data,
DatabaseMetaWriter::updateColumnDictionaryVersionHeaderRecord,
probe:1417
RETCODE : 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: 59
sqlerrmc: Can only inplace update the head rec of a multi-page
record
sqlerrp : SQLD36C
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFC3B (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #2 : String, 190 bytes
DatabaseMetaWriter.cpp:1417(ibm_cde::data::DatabaseMetaWriter::u
pdateColumnDictionaryVersionHeaderRecord(DatabaseTableAccessor
&, size_t, ColumnDictionaryVersionID, SQLD_RID6UA &, Uint32 &))
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000002F7FDFF4
generateErrorUsingZRc__Q3_7ibm_cde8services13BaseExceptionFCUii
+ 0x5D4
[1] 0x090000002FFC4B58
__ct__Q3_7ibm_cde8services17DB2ErrorExceptionFPCcUlT1CUiCiT1 +
0x58
[2] 0x0900000030BF8F04
updateColumnDictionaryVersionHeaderRecord__Q3_7ibm_cde4data18Dat
abaseMetaWriterFRQ3_7ibm_cde4data21DatabaseTableAccessorUlUcR11
+ 0x584
[3] 0x0900000030BF70A0
writeDeltaTableMetadata__Q3_7ibm_cde4data18DatabaseMetaWriterFRQ
3_7ibm_cde4data21DatabaseTableAccessorR11SQLD_RID6UAPQ2_3std6ve
+ 0xA40
[4] 0x0900000030BF5BD0
writeTableMetadata__Q3_7ibm_cde4data18DatabaseMetaWriterFRQ3_7ib
m_cde4data21DatabaseTableAccessorR11SQLD_RID6UAT2PQ2_3std6vecto
+ 0x390
[5] 0x09000000303F54D4
writeTableMetadata__Q3_7ibm_cde4data21DatabaseTableAccessorFUl +
0x694
[6] 0x09000000303B8594
createEvolvedColumnDictionaryVersionsForAddedBasetableColumns__Q
3_7ibm_cde4data5TableFPQ3_7ibm_cde4data13TableAccessorUlRCQ2_3s
+ 0x614
[7] 0x0900000034227DEC
appendColsToDictionaries__Q3_7ibm_cde4data10TableAlterFRCQ3_7ibm
_cde4data10AddColInfo + 0x10C
[8] 0x0900000034222F6C
refreshForNewSchema__Q3_7ibm_cde4data10TableAlterFRCQ3_7ibm_cde4
data10AddColInfo + 0x8C
[9] 0x09000000342227A8
addAndMaterializeNewColumnsForTable__Q3_7ibm_cde4data10TableAlte
rFRQ3_7ibm_cde4data10AddColInfo + 0xC8
[10] 0x090000003421EF58
addColumns__Q3_7ibm_cde4data10TableAlterFiP10SQLD_FIELDP12SQLD_C
OLINFOP8sqlrg_cdP21sqlrg_cdedictphysattrT5Ulb + 0x398
[11] 0x09000000341FCA68
addColumns__Q3_7ibm_cde4data11TableActionFP8sqeAgentUsT2PUciT4N2
5P10SQLD_FIELDP12SQLD_COLINFOP8sqlrg_cdT5P21sqlrg_cdedictphysat
+ 0x208
[12] 0x090000003426EAF4
addColumns__Q3_7ibm_cde4data23cdeTableActionInterfaceFP8sqeAgent
UsT2PUciT4N25P10SQLD_FIELDP12SQLD_COLINFOP8sqlrg_cdT5P21sqlrg_c
+ 0x114
[13] 0x090000002020AA64
sqlrlalt__FP8sqlrr_cbPUcsT2T3T2T3T2T3P8sqlrg_pdP17sqlrl_table_pa
rmsilP18sqlrg_datapartinfoPbbP9sqlnq_ftbT16_ + 0x9044
[14] 0x09000000214F9B10 sqlnq_alter_table_end__FP9sqlnq_qtb +
0x3A90
[15] 0x090000002150F760
sqlnq_alter_table_stmt__FPP8stknode_i10actiontypePUcP3loc +
0x1C0
[16] 0x09000000220DC964 sqlnp_smactn__FP8sqlnp_cbi + 0x424
[17] 0x09000000220D4F40 sqlnp_parser__FP8sqlnp_cb + 0xAC0
[18] 0x09000000220A9B68
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xDA8
[19] 0x090000002202DC34
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x8194
[20] 0x0900000022025A28
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x28
[21] 0x090000001F3561DC
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0xBDC
[22] 0x090000001E28C4FC
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P1
+ 0xA5C
[23] 0x090000001F348814 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 +
0xBF4
[24] 0x09000000221B30D0 sqlri_ddl_get_section__FP8sqlrr_cb +
0x90
[25] 0x09000000221B261C sqlri_ddl_common__FP8sqlrr_cb + 0xE9C
[26] 0x09000000221B162C sqlriddl__FP8sqlrr_cb + 0x2C
[27] 0x090000001EFE74F8
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5F8
[28] 0x0900000020BF6364 sqlrr_execute_immediate__FP8sqlrr_cbi
+ 0x2664
[29] 0x090000001EAA94DC
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x87C
[30] 0x0900000023EB1D60
sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject + 0x1220
[31] 0x0900000023E2E448
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x268
[32] 0x0900000023E314D0
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2250
[33] 0x0900000023DFD94C
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC
[34] 0x0900000023E06414
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
[35] 0x0900000023DFB9F0
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
[36] 0x0900000023DF8E34
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x334
[37] 0x090000001D204CA0 RunEDU__8sqeAgentFv + 0xB60
[38] 0x090000001D1E77A0 EDUDriver__9sqzEDUObjFv + 0x2E0
[39] 0x090000001D0D7714 sqloEDUEntry + 0x374
[40] 0x0900000000519E10 _pthread_body + 0xF0
[41] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2016-11-25-23.57.53.210457-300 I932315A1073 LEVEL:
Severe
PID : 27328630 TID : 40873 PROC :
db2sysc
INSTANCE: svtdbm5 NODE : 000 DB : BLUDB
APPHDL : 0-1244 APPID:
*LOCAL.svtdbm5.161126045749
AUTHID : SVTDBM5 HOSTNAME: svtreg4
EDUID : 40873 EDUNAME: db2agent (BLUDB)
FUNCTION: DB2 UDB, catalog services, sqlrlalt, probe:11444
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: 59
sqlerrmc: Can only inplace update the head rec of a multi-page
record
sqlerrp : SQLD36C
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFC3B (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2016-11-25-23.57.53.210981-300 E933389A1732 LEVEL: Info
(Origin)
PID : 27328630 TID : 40873 PROC :
db2sysc
INSTANCE: svtdbm5 NODE : 000 DB : BLUDB
APPHDL : 0-1244 APPID:
*LOCAL.svtdbm5.161126045749
AUTHID : SVTDBM5 HOSTNAME: svtreg4
EDUID : 40873 EDUNAME: db2agent (BLUDB)
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: 59
sqlerrmc: Can only inplace update the head rec of a multi-page
record
sqlerrp : SQLD36C
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFC3B (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 with size, 111 bytes
alter table POPS.CUSTOMER_GRP alter column CUST_GRP_NAME SET
DATA TYPE VARCHAR(160) add column new_col3 integer
DATA #10: String, 167 bytes
Compiler error stack for rc = -2113667071:
sqlnn_cmpl[300]
sqlnp_main[250]
sqlnp_parser[510]
sqlnp_smactn[180]
sqlnq_alter_table_stmt[110]
sqlnq_alter_table_end[3300]
Thanks, |
