IBM Support

IY97297: CHANGE UNIX TABLESPACE CONTAINER PATH PERMISSIONS TO 711

Fixes are available

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Symptom: EACCES errors in the db2diag.log when the Storage
Manager snapshot is run.

This problem impacts tablespace container permissions on UNIX or
Linux platforms only.

Prior to this APAR, UNIX permissions for subdirectories were 700
so that the instance owner only had permissions and this avoided
security concerns.

However, UDFs such as the Storage Manager Snapshot fail with
EACCES (permission denied) when accessing tablespace containers.
This can happen if the fencedID user is not the DB2 instance
owner since the UDFs run fenced under the db2fmp process which
belongs to the fencedID.  As a result, this APAR will change
tablespace container directories to be 711 so that the fencedID
can traverse the directory. This includes subdirectories that
DB2 creates as part of adding containers to a tablespace.

Local fix

  • Manually fix permissions for tablespace containers to 711.

Problem summary

  • see problem description

Problem conclusion

  • first fixed in DB2 LUW v 910 fixpak 5

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IY97297
    • 

  • Reported component name
    DB2 UDB WSE SOL
    • 

  • Reported component ID
    5765F3502
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2007-04-12
    • 

  • Closed date
    2008-07-24
    • 

  • Last modified date
    2008-07-24
    • 





    

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

    
IY97284
    

    • 

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

    
IZ16114
    

    • 



Fix information


    

  • Fixed component name
    DB2 UDB WSE SOL
    • 

  • Fixed component ID
    5765F3502
    • 



Applicable component levels


    

  • R910  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":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            24 July 2008
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback