|
Problem IT15434
|
Status: Closed |
A STATIC SQL SELECT QUERY CAN RETURN -901 AFTER ALTER ADD COLUMN IS PERFORMED ON A REFERENCED TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
SQL0901 error may be returned when executing a static select
statement which uses the '*' operator after adding some
new columns to the reference table(s).
The problem could be hit using the following:
1. Create stored procedure with static SQL query which includes
a "select '*'" from the results of a join on multiple tables.
2. Alter 'add column' on the left table in the join.
3. Call the stored procedure to execute the static statement.
db2diag.log messages look like the following:
2016-04-21-09.52.27.400576+480 I65277756E842 LEVEL: Severe
PID : 29400 TID : 140698141583104PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-21993 APPID: GAF2404F.F8BE
AUTHID : db2inst1
EDUID : 1445 EDUNAME: db2agent (db2inst1)
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: 26
sqlerrmc: Describe: Invalid svar len
sqlerrp : SQLRA003
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFDA8 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
The stack dump generated from this error could look as follows:
1 OSSTrapFile::dumpEx
2 sqlo_trce
3 sqloDumpDiagInfoHandler
4 raise
5 pthread_kill
6 sqloDumpEDU
7 sqldDumpContext
8 sqlrr_dump_ffdc
9 sqlzeDumpFFDC
10 sqlzeSqlCode
11 sqlrrSqlCode
12 sqlraFixupSqlDD
13 sqlra_describe_static
14 sqlraDescribeOutput
15 sqlrr_open
16 csmOpen
17 pvmPackage::openCursor
18 pvmPackage::executeSection
19 PVM::executeQuery
20 PVM::run
21 pvm_entry
22 sqloInvokeFnArgs
23 sqlriInvokerTrusted
24 sqlricall
25 sqlriSectInvoke
26 sqlrr_process_execute_request
27 sqlrr_execute
28 sqljs_ddm_excsqlstt
29 sqljsParseRdbAccessed
30 sqljsParse
31 sqljsSqlam |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
Rebind the package or re-create the stored procedure. |
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.05.2016
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
