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

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

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

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

Problem conclusion

• First Fixed on DB2 V9.1 Fixpak 5.
  

Temporary fix

Comments

APAR Information

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

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

  LI73231

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSY

     UP