IBM Support

IT18637: [POST11M1FP1GASAP_CANDIDATE]-901 CAN ONLY INPLACE UPDATE THE HEAD REC OF A MULTI-PAGE RECORD, DATABASEMETAWRITER.CPP:1417

Subscribe

You can track all active APARs for this component.

 

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: 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,
    

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

    2017-05-01

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
29 June 2020