DB2 FOR LUW / DB2FORLUW / 950 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* The users are running Federation Server earlier than v95     * 
* fp10.                                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Federation Server v95fp10 or later.               * 
****************************************************************

Rebind the package of the statement with REOPT option of "NONE".

The problem is firstly fixed on v95fp10.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

14.03.2012
28.08.2012
28.08.2012

9.5.FP10