Fixes are available
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
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: db2inst5 NODE : 000 DB : BLUDB APPHDL : 0-1244 APPID: *LOCAL.db2inst5.161126045749 AUTHID : db2inst5 HOSTNAME: myhost4 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: db2inst5 NODE : 000 DB : BLUDB APPHDL : 0-1244 APPID: *LOCAL.db2inst5.161126045749 AUTHID : db2inst5 HOSTNAME: myhost4 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: db2inst5 NODE : 000 DB : BLUDB APPHDL : 0-1244 APPID: *LOCAL.db2inst5.161126045749 AUTHID : db2inst5 HOSTNAME: myhost4 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,
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Mod1 Fix Pack 1 iFix001 * ****************************************************************
Problem conclusion
First fixed in DB2 11.1 Mod1 Fix Pack 1 iFix001
Temporary fix
Comments
APAR Information
APAR number
IT18637
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-03
Closed date
2017-05-01
Last modified date
2022-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022