IBM Support

IC86728: 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 Version 9.7 and Fix Pack 8                    *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC86728

  • 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

    2012-09-21

  • Closed date

    2013-04-22

  • Last modified date

    2013-04-22

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

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

    IC89707

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC86728

Modified date: 22 April 2013