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 IT07475 Status: Closed

DB2LOOK MAY TRAP WHEN EXTRACTING DDL FOR GLOBAL VARIABLES MIGRATED FROM
VERSION 9.5

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
A database upgraded from version 9.5 will not contain the DDL 
text for global variables as part of their descriptors. When 
db2look is run to extract the DDL for these variables it may 
trap or simply not produce any output for them. 
 
e.g. 
$ db2look -d sample -a -e -x -o db2look.out 
-- Generate statistics for all creators 
-- Creator ID is ignored 
-- Creating DDL for table(s) 
-- Output is sent to file: db2look.out 
Segmentation Fault - core dumped 
 
From the stack from the core dump will be something similar to: 
 
strlen 
_ndoprnt 
_fprintf 
create_variable_ddl 
create_ddl 
main
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* The users running db2look.                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 Fixpack 11.                               * 
****************************************************************
Local Fix:
Drop and recreate the global variables. If the definitions are 
not known, you can fabricate new CREATE statements from the 
information in the packed descriptor displayed by db2cat: 
db2cat -d <dbname> -s <schema> -n <variable name> -p variable -t
Solution
Firstly fixed on DB2 V97 Fixpack 11.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.03.2015
09.10.2015
09.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList