IBM Support

IC89672: -901 ERROR MAY OCCUR DURING CREATE TABLE DDL OPERATION AND FODC_APPERR DIRECTORY GENERATED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • -901 error may occur during create table DDL functions, and
    FODC_AppErr directory is generated in db2dump directory. The
    instance is not crashed.
    
    Here is what may be seen in db2diag.log:
    
    2013-01-10-11.17.44.251507-300 I196253782E590      LEVEL: Error
    PID     : 14204                TID  : 46919657187648PROC :
    db2sysc 1
    INSTANCE: nyqxt040             NODE : 001          DB   :
    PHOENIX
    APPHDL  : 1-23556              APPID:
    10.163.214.107.52121.1301101617
    AUTHID  : ECPROD
    EDUID   : 17046                EDUNAME: db2agent (PHOENIX) 1
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging func, probe:0
    MESSAGE : sqlr_obj_type_to_aud_type: Unrecognized object type!
    DATA #1 : Hexdump, 1 bytes
    0x00002AAC557F1D20 : 47
    G
    
    2013-01-10-11.17.44.574120-300 I196254373E590      LEVEL: Error
    PID     : 14204                TID  : 46919657187648PROC :
    db2sysc 1
    INSTANCE: nyqxt040             NODE : 001          DB   :
    PHOENIX
    APPHDL  : 1-23556              APPID:
    10.163.214.107.52121.1301101617
    AUTHID  : ECPROD
    EDUID   : 17046                EDUNAME: db2agent (PHOENIX) 1
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging func, probe:0
    MESSAGE : sqlr_obj_type_to_aud_type: Unrecognized object type!
    DATA #1 : Hexdump, 1 bytes
    0x00002AAC557EBAE0 : 47
    G
    
    .........
    
    2013-01-10-11.18.46.441601-300 I196256146E576      LEVEL: Severe
    
    PID     : 14204                TID  : 46919602661696PROC :
    db2sysc 1
    INSTANCE: nyqxt040             NODE : 001          DB   :
    PHOENIX
    APPHDL  : 1-23456              APPID: *N1.nyqxt040.130110162306
    
    AUTHID  : NYQXT040
    
    EDUID   : 17352                EDUNAME: db2agent (PHOENIX) 1
    
    FUNCTION: DB2 UDB, relation data serv, sqlrr_recreate_ddl,
    probe:200
    MESSAGE : Recreate table DDL failed because the statement is
    empty
    DATA #1 : Hexdump, 4 bytes
    
    0x00002AAC523EB018 : 0000 0000
    ....
    
    
    2013-01-10-11.18.46.490679-300 E196256723E775      LEVEL: Error
    
    PID     : 14204                TID  : 46919602661696PROC :
    db2sysc 1
    INSTANCE: nyqxt040             NODE : 001          DB   :
    PHOENIX
    APPHDL  : 1-23456              APPID: *N1.nyqxt040.130110162306
    
    AUTHID  : NYQXT040
    
    EDUID   : 17352                EDUNAME: db2agent (PHOENIX) 1
    
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:10
    
    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
    
    
    "/var/ibmdb2/nyqxt040/sqllib/db2dump/FODC_AppErr_2013-01-10-
    11.18.46.482904_14204_17352_001/".
    
    
    
    2013-01-10-11.18.46.491861-300 I196259390E885      LEVEL: Severe
    
    PID     : 14204                TID  : 46919602661696PROC :
    db2sysc 1
    INSTANCE: nyqxt040             NODE : 001          DB   :
    PHOENIX
    APPHDL  : 1-23456              APPID: *N1.nyqxt040.130110162306
    
    AUTHID  : NYQXT040
    
    EDUID   : 17352                EDUNAME: db2agent (PHOENIX) 1
    
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:300
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 56
    
     sqlerrmc: Recreate table DDL failed because the statement is
    empty
     sqlerrp : SQLRR0CB
    
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFF06      (6)
    0x00000001
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
    
               (7)      (8)      (9)      (10)        (11)
    
     sqlstate:
    
    
    
    With the call-stacks info from generated FODC_AppErr directory:
    
    0        ossDumpStackTraceEx
    1        OSSTrapFile::dumpEx
    2        sqlo_trce
    3        sqloDumpDiagInfoHandler
    4        send
    5        pthread_kill
    6        sqloDumpEDU
    7        sqldDumpContext
    8        sqlrr_dump_ffdc
    9        sqlzeDumpFFDC
    10       sqlzeSqlCode
    11       sqlrrSqlCode
    12       sqlrr_recreate_ddl
    13       sqlesrvr
    14       sqleMappingFnServer
    15       sqlerKnownProcedure
    16       sqlerCallDL
    17       sqljs_ddm_excsqlstt
    18       sqljsParseRdbAccessed
    19       sqljsParse
    20       sqlnq_qtb
    21       sqlnq_ftb::delchildrels
    22       sqlnq_ftb::drop
    23       sqljsDrdaAsDriver
    24       sqeAgent::RunEDU
    25       sqzEDUObj::EDUDriver
    26       sqlzRunEDU
    27       sqloEDUEntry
    28       __free_stacks
    29       clone
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FP9                                      *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 V9.7 FP9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89672

  • 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-01-21

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

  • 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

  • R970 PSN

       UP

  • R980 PSN

       UP

  • RA10 PSN

       UP

  • RA50 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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 December 2013