When running a staic statement with function call and host
variable, also if the package of the statement is bound as
REOPT ONCE, you may encounter an error as below:
SQL0901N The SQL statement failed because of a non-severe
system error. Subsequent SQL statements can be processed.
(Reason "Unexpected setup for a REOPT statement".)
SQLSTATE=58004
Errors from db2diag.log:
2012-02-22-15.11.33.446568+540 I27710595E574 LEVEL: Error
PID : 14360 TID : 194779277664 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-36110 APPID: *LOCAL.db2inst1.120222061131
AUTHID : db2inst1
EDUID : 1979 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB,access plan manager,sqlra_get_var,probe:1100
DATA #1 : String, 137 bytes
Unexpected setup for a REOPT statement
anchor_id: 962
stmt_uid: 1
env_id: 1
var_id: 12
pseudo_var flag: 1
var asdr: 3200
var_inserted: 1
.....
2012-02-22-15.11.33.447337+540 I27713841E867 LEVEL: Severe
PID : 14360 TID : 194779277664 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-36110 APPID: *LOCAL.db2inst1.120222061131
AUTHID : db2inst1
EDUID : 1979 EDUNAME: db2agent (SAMPLE) 0
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: 38
sqlerrmc: Unexpected setup for a REOPT statement
sqlerrp : SQLRA08D
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFB82 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
The stack tracce:
0 ossDumpStackTraceEx
1 OSSTrapFile::dumpEx
2 OSSTrapFile::dump
3 sqlo_trce
4 sqloDumpDiagInfoHandler
5 __libc_sigaction
6 pthread_kill
7 sqloDumpEDU
8 sqldDumpContext
9 sqlrr_dump_ffdc
10 sqlzeDumpFFDC
11 sqlzeSqlCode
12 sqlrrSqlCode
13 sqlra_get_var
14 sqlrr_process_execute_request
15 sqlrr_execute
16 pvmPackage::executeSection
17 PVM::executeQuery
18 PVM::run
19 pvm_entry
20 sqloInvokeFnArgs
21 sqlriInvokerTrusted
22 sqlricall
23 sqlriSectInvoke
24 sqlrr_process_execute_request
25 sqlrr_execute
26 sqljs_ddm_excsqlstt
27 sqljsParseRdbAccessed
28 sqljsParse
29 sqljsSqlam
30 sqljsDriveRequests
31 sqljsDrdaAsInnerDriver
32 sqljsDrdaAsDriver
33 sqeAgent::RunEDU
34 sqzEDUObj::EDUDriver
35 sqlzRunEDU
36 sqloEDUEntry
37 pthread_create@@GLIBC_2.2.5
38 __clone |
