3566308 - DB6: SQL0902C error reason code 170

Database connection fails with SQL0902C reason code 170.

e.g.

>>> db2 connect to ABC

SQL0902C  A system error occurred. Subsequent SQL statements cannot be
processed. IBM software support reason code: "170".  SQLSTATE=58005 

db2diag.log file:

2025-01-28-00.31.41.387584-300 I3718A1841           LEVEL: Warning
PID     : 49635                TID : 70366693093728 PROC : db2sysc 0
INSTANCE: db2abc              NODE : 000           DB   : ABC    
HOSTNAME: usil544
EDUID   : 41                   EDUNAME: db2logmgr (PPO) 0
FUNCTION: DB2 UDB, oper system services, sqloInitializeVendorProcess, probe:2400
MESSAGE : ZRC=0x870F00AA=-2029059926=SQLO_NPIPE_NO_RESOURCE
          "if the pipe is full and the num_bytes_write"
DATA #1 : String, 32 bytes
Unable to create the stdin pipe.
DATA #2 : String, 58 bytes
/db2/db2abc/sqllib/tmp/DB2VEND.STDIN.0.41.1736919101387555
DATA #3 : String, 0 bytes
Object not dumped: Address: 0x00003FFF85BEBB9C Size: 0 Reason: Zero-length data

Manually creation of the pipe mentioned in db2diag.log failed.

mknod -m 600 /db2/db2abc/sqllib/tmp/DB2VEND.STDIN.0.41.1736919101387555 p
mknod: '/db2/db2abc/sqllib/tmp/DB2VEND.STDIN.0.41.1736919101387555': No space left on device 

• SAP on IBM Db2 for Linux, Unix and Windows
• Log archiving destination is configured with TSM

SQL0902C, 170, pipe, full, create, stdin, stdout , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem