home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC90457 Status: Geschlossen

-901 WITH "NO COLUMN INFORMATION FOUND IN THE PACKED DESCRIPTOR"
ON CREATE PROCEDURE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* 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                            * 
****************************************************************
Local-Fix:
Drop and recreate the view, to find the effected view use 
db2look.
verfügbare FixPacks:
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

Lösung
First fixed in fix pack 9 of v9.7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC90722 IC96428 IC96698 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.02.2013
08.01.2014
08.01.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.0.,
9.7.
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList