| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT36106 | Status: Closed |
SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN | |
| product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
| Problem 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] | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to product level v11.5.6.0 * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to product level v11.5.6.0 * **************************************************************** | |
| Comment | |
fixed in 11.5.6.0 The customer query will run without generating a -901. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.03.2021 17.06.2021 17.06.2021 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
