IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 January 2020