IBM Support

IC75336: INSPECT FILE NOT REMOVED WHILE USING ADMIN_MOVE_TABLE UTILITY, E RROR IS WRITTEN INDB2DIAG EACCES (13) "PERMISSION DENIED"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In Version V9.5 the inspect file are not removed  for
    DB2INSPECT_ACT_ROWCMPEST_TBL action by default, which affects
    both CLP and other applications.
    In Version V9.7 While using Admin_Move_Table utility following
    error are written
    in db2diag file. These error are related to db2fmp process.
    
       PID     : 1241310              TID  : 772         PROC :
    db2fmp (C) 0
        INSTANCE: db2inst2             NODE : 000
        EDUID   : 772                  EDUNAME: db2fmp (C) 0
        FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
        MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access
    Denied"
                  DIA8701C Access denied for resource "", operating
    system return code
                  was "".
        CALLED  : OS, -, open
        OSERR   : EACCES (13) "Permission denied"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * prior v9.7 fp4                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ADMIN_MOVE_TABLE error                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade                                                      *
    ****************************************************************
    

Problem conclusion

  • v9.7 fp 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75336

  • 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

    2011-03-28

  • Closed date

    2011-12-20

  • Last modified date

    2011-12-20

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

    IC75190

  • 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



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC75336

Modified date: 20 December 2011