DB2 FOR LUW / DB2FORLUW / 970 - DB2

This may be due to a view not getting reference correctly 
by the table and CREATE PROCEDURE.  Follow message maybe seen: 
 
2013-01-15-11.19.13.428039-300 E487192757E1841     LEVEL: Info 
(Origin) 
PID     : 31132                TID  : 46921213274432PROC : 
db2sysc 1 
INSTANCE: testinst             NODE : 001          DB   : SAMPLE 
APPHDL  : 1-42831              APPID: <removed> 
AUTHID  : MSDB2 
EDUID   : 473178               EDUNAME: db2agent (ATHENA) 1 
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 
MESSAGE : ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND 
          "Could not find an internal object required to process 
the command" 
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 : SQLCAL    sqlcabc: 136   sqlcode: -901   sqlerrml: 52 
 sqlerrmc: No column information found in the packed descriptor

**************************************************************** 
* USERS AFFECTED:                                              * 
* -901 WITH  "NO COLUMN INFORMATION FOUND IN THE PACKED        * 
* DESCRIPTOR" ON CREATE PROCEDURE                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First fixed in fix pack 9 of v9.7                            * 
****************************************************************

Drop and recreate the view, to find the effected view use 
db2look.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in fix pack 9 of v9.7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC90722 IC96428 IC96698 
follow-up : 

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

25.02.2013
08.01.2014
08.01.2014

9.0.,
9.7.