IBM Support

IT29646: 'ALTER TABLE ALTER COLUMN SET DATA TYPE' MAY CRASH THE INSTANCE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 instance may crash while running 'ALTER TABLE ALTER COLUMN
    SET DATA TYPE'.
    
    db2diag.log
    
    2019-02-05-14.14.51.936032+330 I14859058525A942 LEVEL: Severe
    PID : 3211652 TID : 160198 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-45123 APPID: *LOCAL.db2inst1.190205084324
    AUTHID : DB2INST1 HOSTNAME: XXXX
    EDUID : 160198 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : RDS UCINTFC: pStatementText =
    DATA #1 : Hexdump, 77 bytes
    0x000000013F4D5020 : 414C 5445 5220 5441 424C 4520 4C44 494C
    ALTER TABLE DB2IN
    0x000000013F4D5030 : 4C4D 5353 4249 2E4C 524D 5F54 5820 414C
    ST1.EMPOLYEE AL
    0x000000013F4D5040 : 5445 5220 434F 4C55 4D4E 2052 4547 5F43 TER
    COLUMN SERIAL_ID
    0x000000013F4D5050 : 4F44 4520 5345 5420 4441 5441 2054 5950 ODE
    SET DATA TYP
    0x000000013F4D5060 : 4520 2044 4543 494D 414C 2837 29 E
    DECIMAL(7)
    
    2019-02-05-14.14.53.532725+330 E14859064517A804 LEVEL: Error
    PID : 3211652 TID : 160198 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-45123 APPID: *LOCAL.db2inst1.190205084324
    AUTHID : DB2INST1 HOSTNAME: XXXX
    EDUID : 160198 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:30
    MESSAGE : ADM14005E The following error occurred: "AppErr".
    First Occurrence
    Data Capture (FODC) has been invoked in the following mode:
    "Automatic". Diagnostic information has been recorded in the
    directory named
    "/FODC_PATH/FODC_AppErr_2019-02-05-14.14.53.530903_321
    1652_160198_000/".
    ```
    
    
    The FODC stacktrace shows :
    
    ```
    <Header>
    DB2 build information: DB2 v10.5.0.10 s180615 SQL1005A
    timestamp: 2019-02-05-14.14.53.540843
    instance name: db2inst1.000
    EDU name : db2agent (SAMPLE) 0 [-]
    EDU ID : 160198
    Signal #31
    uname: S:AIX R:1 V:7 M:XXXXXXXXX N:XXXX
    process id: 3211652
    parent process id: 3605732
    thread id : 160198 (0x271C6)
    kthread id : 78054573
    </Header>
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x0900000000583F94 pthread_kill + 0xD4
    0x0900000010B2EEF0 sqloDumpEDU + 0xC4
    0x0900000010B51854 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
    0x110
    0x090000000EC9D7CC sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x958
    0x090000000EC9CCFC sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28
    0x090000000F58350C
    sqlzeMapZrc__FP8sqeAgentUiUlT2P5sqlcaiPC12sqlzeContextb + 0x20
    0x09000000129FE80C
    sqlrlalt__FP8sqlrr_cbPUcsT2T3T2T3T2T3P8sqlrg_pdP17sqlrl_table_pa
    rmsilP18sqlrg_datapartinfoPbbP9sqlnq_ftbT16_ + 0x20EC
    0x0900000012A4CF18 sqlnq_alter_table_end__FP9sqlnq_qtb + 0x3FD8
    0x0900000012A6187C
    sqlnq_alter_table_stmt__FPP8stknode_i10actiontypePUcP3loc +
    0x1DC
    0x090000000EA5C70C sqlnp_parser__FP8sqlnp_cb + 0x1A4
    0x090000000EA4CDBC sqlnp_parser__FP8sqlnp_cb + 0x51C
    0x090000000EC56D60
    sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x270
    0x090000000E6FC5FC
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sqlnq_qur + 0x4ED4
    0x090000000F538330
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_env + 0x3C
    0x090000000F53C7B0
    sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
    LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0x860
    0x090000000DF0ABC0
    sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
    T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
    SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x116C
    0x090000000DF10278 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x22B4
    0x090000000DEFA0FC sqlri_ddl_common__FP8sqlrr_cb + 0xD64
    0x090000000DEF9680 sqlri_ddl_common__FP8sqlrr_cb + 0x2E8
    0x090000000DEF927C sqlriddl__FP8sqlrr_cb + 0x34
    0x090000000EFE1C7C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0xA0
    0x090000000DEFD070
    sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x11E8
    0x090000000DEFBF74
    sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0xEC
    0x090000000F699374
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0xBA90
    0x090000000F663880 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
    + 0x694
    0x090000000F663880 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
    + 0x694
    0x090000000F663478 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
    + 0x28C
    0x090000001050AA54
    @72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
    0x090000001050B570
    @72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5FC
    0x090000000FF6C15C RunEDU__8sqeAgentFv + 0x4E144
    0x090000000FF79E74 RunEDU__8sqeAgentFv + 0x128
    0x090000000E9D4E14 EDUDriver__9sqzEDUObjFv + 0x134
    0x090000000E625154 sqloEDUEntry + 0x394
    </StackTrace>
    ```
    

Local fix

  • Perform REORG on table if it is in reorg pending state. And
    rerun ALTER TABLE ALTER COLUMN statement.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29646

  • 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

    2019-07-08

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

  • 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