Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC66020 Status: Closed

LOAD FROM CURSOR MIGHT TRAP IF LOADING INTO FEWER COLUMNS THAN TOTAL
NUMBER OF TARGET TABLE COLUMNS

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
This problem can occur during a load from cursor command such as 
 
 
db2 load from C1 of cursor replace into T1(COL1, COL4 ) 
 
If the number of columns specified for the target table is fewer 
than the total number of columns on the target table, the load 
command might trap with stack trace like the following: 
 
... 
sqluCrossCheckColumnCompatibility 
sqluCrossCheckFormatHeader 
sqluCCrossInfo20iProcessFormatHeader 
sqluCCrossInfo11iInitialize 
sqluPerformCatalogTasks 
sqlu_register_table_load 
... 
 
(IBM personnels analyzing the trap for line of code will find 
that it traps on a line referencing 
pTargetCodepages[iTargetArrayOffset] )
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL.                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See the APAR description.                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 UDB version 9.5 fixpack 6.                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 UDB Version 9.5 FixPack 6.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.02.2010
14.05.2010
16.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.