IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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:

    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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021