home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT02726 Status: Closed

USE OF UNDEFINED ARRAY() FUNCTION CAUSES A TRAP IN DB2 ENGN

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When undefined ARRAY() function is used in select list, a trap 
occurs in DB2 engn. 
 
Repo: 
db2 "create table b (c1 int)" 
 
DB20000I  The SQL command completed successfully. 
 
db2 "select array(c1) from b" 
 
SQL1224N  The database manager is not able to accept new 
requests, has terminated all requests in progress, or has 
terminated the specified request because of an error or a forced 
interrupt.  SQLSTATE=55032
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply V97 Fix Pack 10                                        * 
****************************************************************
Local Fix:
Do not use undefined ARRAY() function name.
Solution
First Fixed in DB2 V97 Fix Pack 10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.06.2014
11.11.2014
11.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList