SAP Note 1730855 - DB6: Establishing a connection to DB2 is slow, or hanging

Component : DB2 Universal Database for Unix / NT -

Solution : https://service.sap.com/sap/support/notes/1730855 (SAP Service marketplace login required)

Summary :
The note addresses slow startup and command execution issues in an SAP system, pinpointing problems associated with NFS issues on systems using a CLI client installed on NFS-mounted file systems. These systems experience NFS daemon delays impacting file operations necessary for functions like R3trans. Diagnostics involve OS-specific tracing tools to identify stuck system calls related to NFS file operations. Issues particular to DB2 configurations with specific versions and file systems are discussed. Solutions include relocating the CLI client to local file systems and updating or configuring DB2 setups as per new revelations from IBM (APARs).

Key words :
terms db6 db2luw conlic, fix pack level lower, cli driver]/cfgcache/conlic, network-related system call, nfs-mounted file system, cli driver]/cfg/db2dsdriver, system tracing utility, solaris  strace -tt -, relevant system calls, additional connection attribute

Related Notes :

101809DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows
31707DB6: DBSL trace for performance/error analysis