IBM Support

IT36259: SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERRAND SQL0901N

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When there is an interrupt detected while retrieving the packed
    descriptor from sysservers, Db2 will treat this as a serious
    error and raises SQL0901N and produces a FODC_AppErr directory.
    Interrupts should be handled more gracefully in this case by
    returning SQL0952N to the applications instead.
    
    Symptoms of this in db2diag.log will be a FODC_AppErr dump and
    "sqlcode: -901" error raised showing an interrupt (DIA8003C)
    with a sqlnq_sat::sqlnq_sat[140] on stack:
    
    
    2021-03-08-09.08.57.088661+060 E38310805A836        LEVEL: Error
    PID     : 10551810             TID : 1071819        PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    APPHDL  : 0-54972              APPID:
    X.X.X.X.47005.210721071024
    AUTHID  : DB2INST1              HOSTNAME: myhost1
    EDUID   : 1071819              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
    
    "/home/db2inst1/sqllib/db2dump/DIAG0000/FODC_AppErr_2021-03-08-0
    9.08.
              57.080192_10551810_1071819_000/".
    
    ...
    
    2021-03-08-09.09.04.766423+060 E38397779A2177       LEVEL: Info
    (Origin)
    PID     : 10551810             TID : 1071819        PROC :
    db2sysc 0
    NSTANCE: db2inst1             NODE : 000           DB   : SAMPLE
    APPHDL  : 0-54972              APPID:
    X.X.X.X.47005.210721071024
    AUTHID  : DB2INST1              HOSTNAME: myhost1
    EDUID   : 1071819              EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
    MESSAGE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT
    DETECTED"
              DIA8003C The interrupt  has been received.
    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: -901   sqlerrml: 25
    
     sqlerrmc: error getting server info
     sqlerrp : SQLNQ565
     sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFF74      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
    
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    DATA #8 : Hex integer, 4 bytes
    0x00000040
    DATA #9 : String with size, 404 bytes
    SELECT * FROM MYTABLE A WHERE A.DAT_RIP BETWEEN '2021-01-01' AND
    '2021-12-31'
    DATA #10: String, 365 bytes
    Compiler error stack for rc = -2147221501:
    sqlnn_cmpl[300]
    sqlnp_main[250]
    sqlnp_parser[330]
    sqlnp_smactn[180]
    sqlnq_sem[420]
    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[600]
    sqlnq_sat::sqlnq_sat[140]
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Customers may see -901 error instead of -952                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7 version.                                 *
    ****************************************************************
    

Problem conclusion

  • 11.1.4.7 containing this fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT36259

  • 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

    2021-03-17

  • Closed date

    2022-04-16

  • Last modified date

    2022-04-16

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

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

    IT39334

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

  • RB50 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