IBM Support

LI74235: DB2 ABENDS WITH SIGNAL 11 WHEN RUNNING REVOKE/GRANT ON ARRAY DATA TYPE CONVERSION FUNCTION.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 may abend with signal 11 when granting or revoking
    privileges for a conversion function associated with an array
    data type.  The conversion functions are created automatically
    when an array data type is created.  Array data types are new to
    DB2 version 9.5.
    
    
    Stack trace from the trap looks like this:
    
    Stack #1             Signal #11        Timestamp
    2009-03-04-20.44.14.935654
    0        ossDumpStackTraceEx
    1        OSSTrapFile::dumpEx
    2        sqlo_trce
    3        sqloEDUCodeTrapHandler
    4        __pthread_enable_asynccancel
    5        sqlnn_dat_TYPTYPE::isGraphicStringType
    6        sqlnn_dat_TYPTYPE::supportsCollation
    7        sqlnq_qur::cleanup_unknown_cpcoll
    8        sqlnq_postParse
    9        sqlnn_cmpl
    10       sqlnn_cmpl
    11       sqlra_compile_var
    12       sqlra_find_var
    13       sqlra_get_var
    14       sqlri_ddl_get_section
    15       sqlri_ddl_common
    16       sqlriddl
    17       sqlriExecThread
    18       sqlriSectInvoke
    19       sqlrr_execute_immediate
    20       sqlrr_execimmd
    21       sqljs_ddm_excsqlimm
    22       sqljsParseRdbAccessed
    23       sqljsParse
    24       destr_detour0.0.52
    25       sqleCreateDb
    26       sqlecrea_agent
    27       sqljsDrdaAsDriver
    28       sqeAgent::RunEDU
    29       sqzEDUObj::EDUDriver
    30       sqlzRunEDU
    31       sqloEDUEntry
    32       start_thread
    33       __clone
    
    
    The steps to reproduce the problem are:
    
    1. db2 "CREATE TYPE NEW_FUNC AS int ARRAY[10]"
    
    2. select specific name for the function NEW_FUN so that it can
    be used to run revoke/grant:
    
    db2 "select specificname from syscat.routines where
    routinename='NEW_FUNC'"
    
    3. db2 "grant execute on specific function <SPECIFIC_NAME> to
    db2inst1"
    
    and you will get the following error:
    
    DB21034E The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command. During SQL processing it
    returned:
    SQL1224N The database manager is not able to accept new
    requests, has
    terminated all requests in progress, or has terminated your
    particular request
    due to an error or a force interrupt. SQLSTATE=55032
    

Local fix

  • No Local Fix
    

Problem summary

  • DB2 ABENDS WITH SIGNAL 11 WHEN RUNNING REVOKE/GRANT ON ARRAY
    DATA TYPE CONVERSION FUNCTION.
    

Problem conclusion

  • FIXED IN DB2 V9.5 FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74235

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-18

  • Closed date

    2009-12-16

  • Last modified date

    2009-12-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 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 December 2009