DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* The users running db2look.                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 Fixpack 11.                               * 
****************************************************************

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

Firstly fixed on DB2 V97 Fixpack 11.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.03.2015
09.10.2015
09.10.2015

9.7.FP11