IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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
    

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
    

Problem summary

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

Problem conclusion

  • Firstly fixed on DB2 V97 Fixpack 11.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07475

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-03-03

  • Closed date

    2015-10-09

  • Last modified date

    2015-10-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 October 2015