IBM Support

IC95631: DATABASE CRASHES WHEN ATTEMPTING A DROP COMMAND THAT CONTAINS "NULLS"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • For example, when attempting to drop a schema containing special
    characters or a table containing spaces,
    the database can crash and the following can appear in the
    db2diag.log:
    
    2012-08-23-09.56.31.086951-300 E9434658E1679       LEVEL: Info
    (Origin)
    PID     : 36889                TID  : 140713350129408PROC :
    db2sysc 0
    INSTANCE: DB2INST1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-20781              APPID:
    172.32.1.79.2536.120823145630
    AUTHID  : DB2INST1
    EDUID   : 4646                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
    MESSAGE : ZRC=0x8704002F=-2029780945=SQLD_PARM "PARAMETER ERROR"
    DIA8544C An invalid data type was encountered, the value was "".
    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: -902   sqlerrml: 2
     sqlerrmc: 47
     sqlerrp : SQLRC06B
     sqlerrd : (1) 0x8704002F      (2) 0x0000002F      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000000Page 29 of 120
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    DATA #8 : Hex integer, 4 bytes
    0x04000040
    DATA #9 : String, 371 bytes
    Compiler error stack for rc = -2029780945:
    sqlnn_cmpl[300]
    sqlnp_main[250]
    sqlnp_parser[510]
    sqlnp_smactn[100]
    sqlnq_drop_db_object[430]
    sqlnq_table_old[110]
    sqlnq_handle_from_table_re[10]
    sqlnq_handle_table_ref[5]
    sqlnq_handle_named_ref[110]
    sqlnq_handle_named_ref[110]
    sqlnq_handle_named_ref[120]
    sqlnq_handle_qtb_extref_re[20]
    sqlnq_cat_look[170]
    sqlnq_cat_look2[120]
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 9                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95631

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-30

  • Closed date

    2013-12-30

  • Last modified date

    2013-12-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC98167 IC98171

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC95631

Modified date: 30 December 2013