IZ55682: THE NON-ROOT INSTALLFIXPACK FAILS WHEN THE ENABLE_OS_AUTHENTICATION=YES IS ENABLED USING THE DB2RFE SCRIPT

DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• If we enable OS Authentication variable
  ENABLE_OS_AUTHENTICATION=YES by db2rfe as a root user, db2ckpw
  file will be owned by root. So the non-root installfixpak fails
  with the error:
  
  db2chglibpath: Unable to open file for write:
  /home/db2nrusr/sqllib/security/db2ckpw': error: 13(Permission
  denied)
  

Local fix

• (1)  As non-root user, move the file "db2ckpw" to some tmp
  
  location:
  mv ~/sqllib/security/db2ckpw ~/
  
  (2)  As non-root user, re-run the installFixPack command as
  before, but add the "-f level" option:
  
  ./installFixPack -b /home/db2nrusr/sqllib -f level
  
  (3)  As root user, re-run the same db2rfe command as before
  with the same db2rfe.cfg file used
  cd /export/home/nonroot/sqllib/instance
  
   ./db2rfe -f db2rfe.cfg
  
  with INSTANCENAME=<non-root user>
  
  
  ENABLE_OS_AUTHENTICATION=YES
  
  At this point, we should be able to run db2start as non-root
  instance.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users prior to DB2V95 FP6                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * THE NON-ROOT INSTALLFIXPACK FAILS WHEN                       *
  * THEENABLE_OS_AUTHENTICATION=YES IS ENABLED USING THE         *
  * DB2RFESCRIPT                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * upgrade to DB2 V95 FP6                                       *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 V95 FP6
  

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:

  IC68634 IC68635

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R950 PSY

     UP