IBM Support

LI73231: DB2SET FAILS ON FP3 IF RUN FROM A USER THAT IS NOT THE INSTANCE OWNER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • As a result of some fixes that went into v9 FP3, the behaviour
    of db2set has changed.
    Instead of updating the profile.env registry file directly, it
    will instead create a temporary version of the file to update,
    and then move/replace with the original file. This prevents any
    possibility of corruption of that file.
    
    However, a side affect of this change is that if db2set is being
    run from a user that is not the instance owner but is part of
    the instance admin group, then it will fail with error:
    
    DBI1309E System error.
    Explanation:
    The tool encountered an operating system error.
    
    The reason is because of the sticky bit "t" on the sqllib
    directory where the profile.env is located. That does not allow
    the file move/rename operation to work if you are not the owner
    of the file.
    

Local fix

  • A possible work-around is to "chown" the sqllib/profile.env file
    so that the file owner is the other user that is doing the
    db2set update instead of the instance user owning the file.
    

Problem summary

  • Users Affected:  ALL
    
    Problem Description:
    See "ERROR DESCRIPTION" for more details.
    
    Problem Summary:
    Without this APAR, user will experience the error as described
    in the "ERROR DESCRIPTION" section.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, Fixpack 1 (s080328).
    

Temporary fix

  • n/a
    

Comments

APAR Information

  • APAR number

    LI73231

  • 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-03-20

  • Closed date

    2008-05-04

  • Last modified date

    2008-05-04

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

    LI72592

  • 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

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2008