IBM Support

IC89707: IN AN EEE MULTI-PARITION ENVIROMENT, THE TEMP FILE "DB2LOOK_DUMP FILE" DOESN'T GET DELETED AFTER EXECUTION OF DB2LOOK COMMAND

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When DB2LOOK with option '-l' is run in an EEE environment with
    multiple physical partitions, it will create a temp file
    "DB2LOOK_DUMPFILE" under <sqllib>/tmp/ directory with
    "-rw-r-----" permissions. This file is not deleted at the end of
    the execution and also block other users trying to execute the
    db2look command with '-l' option.
    
    Example:
    
    1. User A executes db2look as below:
    db2look -d SAMPLE -a -l
    
    2. User B tries to run db2look command and it will fail with the
    following permission error:
    
    db2look -d SAMPLE -a -l
    -- Generate statistics for all creators
    -- This CLP file was created using DB2LOOK Version "9.7"
    -- Timestamp: Thu 20 Sep 2012 02:36:26 PM EDT
    -- Database Name: SAMPLE
    -- Database Manager Version: DB2/LINUXX8664 Version 9.7.5
    -- Database Codepage: 1208
    .
    .
    sh: /home/hotel54/sqllib/tmp/db2look_dumpfile: Permission denied
    

Local fix

  • Log in with the same user and remove the "DB2LOOK_DUMPFILE"
    manually.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 LUW version v10.1 fixPack 3                   *
    ****************************************************************
    

Problem conclusion

  • Upgrade to DB2 LUW version v10.1 fixPack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89707

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-22

  • Closed date

    2013-11-12

  • Last modified date

    2013-11-12

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

    IC86728

  • 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

  • RA10 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.1

Reference #: IC89707

Modified date: 12 November 2013