Symptom
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
Read more...
Environment
- SAP on IBM Db2 for Linux, Unix and Windows
- Log archiving destination is configured with TSM
Keywords
SQL0902C, 170, pipe, full, create, stdin, stdout , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.