LI73415: DB2 CLP fails with DB21018E in DPF environments on Linux due to conflicts on shared sqllib/tmp directory

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

• On Linux, the DB2 command line processor (CLP) uses named pipes
  to communicate between a front-end process ("db2") and a
  back-end process ("db2bp").
  In DPF environments, $INSTHOME/sqllib/tmp directory is shared by
  the partitions, the named pipe file based on the pid may
  conflict.
  
  db2diag.log might have the following entries.
  
  2007-05-03-09.01.53.681927+540 E4014137G375       LEVEL: Error
  (OS)
  PID     : 9071                 TID  : 3054301312  PROC : db2
  INSTANCE: db2inst1             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqloMLNique, probe:7
  CALLED  : OS, -, chmod                            OSERR: EPERM
  (1)
  DATA #1 : String, 34 bytes
  /home/db2inst1/sqllib/tmp/O339071A
  
  2007-05-03-09.01.53.683040+540 E4014513G378       LEVEL: Error
  (OS)
  PID     : 9071                 TID  : 3054301312  PROC : db2
  INSTANCE: db2inst1             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqloMLNique, probe:10
  CALLED  : OS, -, open                             OSERR: EACCES
  (13)
  DATA #1 : String, 34 bytes
  /home/db2inst1/sqllib/tmp/O339071A
  
  2007-05-03-09.01.53.683391+540 E4014892G301       LEVEL: Warning
  (OS)
  PID     : 9071                 TID  : 3054301312  PROC : db2
  INSTANCE: db2inst1             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:60
  CALLED  : OS, -, unspecified_system_function      OSERR: EBADF
  (9)
  
  2007-05-03-09.01.53.683593+540 I4015194G573       LEVEL: Error
  PID     : 9071                 TID  : 3054301312  PROC : db2
  INSTANCE: db2inst1             NODE : 000
  FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:200
  MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
            DIA8411C A file "" could not be found.
  

Local fix

• Create symbolic link to /tmp.
    $ rm ~/sqllib/tmp
    $ ln -s /tmp ~/sqllib
  

Problem summary

• Users affected: Linux Users with DPF environment.
  

Problem conclusion

• Problem was first fixed in Version 9.1 Fix Pack 5 (s080512).
  

Temporary fix

Comments

APAR Information

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

  LI72406

• 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

• R910 PSN

     UP