IBM Support

IT29744: SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 -901 error:
    
    2019-06-19-14.54.17.509737-240 E60195A1779          LEVEL: Info
    (Origin)
    PID     : 41156616             TID : 10443          PROC :
    db2sysc
    INSTANCE: db3inst1               NODE : 000           DB   :
    SAMPLE
    APPHDL  : 0-76                 APPID: *LOCAL.test.190619184844
    AUTHID  : DB2INST1               HOSTNAME: TEST
    EDUID   : 10443                EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
    MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
              "unexpected error but state is OK"
    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: 20
    sqlerrmc: no tree to be copied
    sqlerrp : SQLNQ07A
    sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0xFFFFFF9C      (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, 141 bytes
    select * from SAMPLE.TEST for system_time between '0001-01-01
    00:00:00.000000000' and '9999-12-30 00:00:00.000000000' where ID
    = 1
    DATA #10: String, 294 bytes
    Compiler error stack for rc = -2144272209:
    sqlnn_cmpl[370]
    sqlnr_exe[200]
    sqlnr_rcc[100]
    sqlnr_seq[100]
    sqlnr_comp[110]
    sqlnr_prep1_action[100]
    sqlnr_qrwprep_phase1[1190]
    sqlnr_ua_prove_disjoint[3080]
    sqlnr_ua_create_PICK_pred[1020]
    sqlnq_pid::sqlnq_pid_copy[100]
    sqlnq_interval::checkEachD[5]
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * See Error Description                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First fixed in v11.1 m4 fp 7                                 *
    ****************************************************************
    

Problem conclusion

  • First fixed in v11.1 m4 fp 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29744

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

  • Closed date

    2022-04-18

  • Last modified date

    2022-04-18

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

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

    IT36106

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSY

       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