Fixes are available
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 number
LI73415
Reported component name
DB2 UDE ESE LIN
Reported component ID
5765F4104
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-05-09
Closed date
2008-06-23
Last modified date
2008-06-23
APAR is sysrouted FROM one or more of the following:
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
Document Information
Modified date:
15 October 2021