IBM Support

LI73823: TAKING BACKUP WHILE PERMISSIONS DENIED TO /TMP FOR INSTANCE OWNER MAY CORRUPT SQLSPCS FILE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If users changes permissions for /tmp directory to read only
    for instance
    owner, backup of database will fail with SQL2048 Error and
    corrupt SQLSPCS file. Consequent connect to database will
    result in SQL0980C error.
    Users will not be able to connect to
    database.
    
    Steps to recreate issue :
    ***********************************************************
    1. db2 "create database TEST"
    
    2. db2 connect to TEST
    
    3. As root ,CHANGE permissions ON /tmp [root@lenexa /]# chmod
    000 tmp
     d---------   26 root root         4096 Aug 27 11:40 tmp
    4. db2 backup db TEST
        SQL2048N  An error occurred while accessing object "1".
    Reason code: "6".
    
    5. db2 connect to TEST
        SQL0980C  A disk error occurred.  Subsequent SQL statements
    cannot be processed.  SQLSTATE=58005
    

Local fix

  • This APAR corrupts the SQLSPCS file and only DB2 Technical
    Support can fix it. Customer will need to send the SQLSPCS file
    to Technical support.
    

Problem summary

  • Users affected: All
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73823

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-10-06

  • Closed date

    2009-05-29

  • Last modified date

    2009-06-25

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

    LI73822

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R820 PSY

       UP

  • R910 PSY

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021