DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* See SYSROUTE APARs to see where this APAR is addressed       *
****************************************************************

Rebind the package or re-create the stored procedure.

not known / see Local fix

forerunner  : 
follow-up : IT15433 IT15434 IT15435 

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

24.05.2016
08.05.2017
08.05.2017