IBM Support

DB2 Text Search connection failure on AIX

Flashes (Alerts)


Abstract

All DB2 Text Search adminstration commands and searches fail with the following error on AIX platform though the port is available and listening:

SQL20427N  An error occurred during a text search administration         
procedure or command. The error message is "CIE00756 Connect failed on   
host named "localhost" and port "50104". ". SQLSTATE=38H14  

Content

The db2diag.log contains the following messages:

2012-12-13-16.46.33.412854+060 I1446139149A440    LEVEL: Severe          
PID     : 4980778              TID  : 16496       PROC : db2sysc         
INSTANCE: db2inst5             NODE : 000         DB   : MYDB1          
EDUID   : 16496                EDUNAME: db2agent (MYDB1)                 
FUNCTION: DB2 UDB, Text Search, CieError::makeDiagnosticMessage, probe:1
MESSAGE : CIE reason                                                     
DATA #1 : Hexdump, 4 bytes                                               
0x0000000113852AD8 : 0000 02F4                                  ....     
                                                                         
2012-12-13-16.46.33.413067+060 I1446139590A449    LEVEL: Severe          
PID     : 4980778              TID  : 16496       PROC : db2sysc         
INSTANCE: db2inst5             NODE : 000         DB   : MYDB1          
EDUID   : 16496                EDUNAME: db2agent (MYDB1)                 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary         
logging fu, probe:0                                                      
MESSAGE : Message                                                        
DATA #1 : String, 68 bytes                                               
CIE00756 Connect failed on host named "localhost" and port "50104".
 

This has been identified as product defect with APAR:IC92838 ( V9.7) and IC92910 (V10.1). The upcoming fix packs will be included with the APAR fix. A support request should be opened to obtain a special build for the APAR if it is not possible to wait until the release of official fix pack.

Note: This problem is noticed only on AIX platform

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","Platform":[{"code":"PF002","label":"AIX"}],"Version":"9.7;10.1;10.5","Edition":"Advanced Enterprise Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 December 2022

UID

swg21642268