DB2 - Problem description
Problem IC72728 | Status: Closed |
THE PORT NUMBER FOR SSL_SVCENAME IN THE SERVICE FILE IS USED FOR SVCENAME. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
When DB2 instance is configured for SSL and both SSL_SVCENAME and SVCENAME is configured the db2 server take the port number for SSL_SVCENAME in the service file is used for SVCENAME. You may get error message like below. Take note that it's mentioning SVCENAME but showing the port number for SSL_SVCENAME 2010-10-22-14.33.27.461788+120 E49703A733 LEVEL: Error PID : 606322 TID : 258 PROC : db2sysc INSTANCE: dbtesting NODE : 000 EDUID : 258 EDUNAME: db2sysc FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, probe:46 MESSAGE : ADM7007E The SVCENAME DBM configuration parameter, "51089", is configured with a port or a service name. When it is configured with a service name, the TCP/IP services files is used to map the service name to a port number. The port specified in this field is being used by another process. Resolve this problem by either deleting the process using the port or use another port. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Some users that use both SSL and SSL_SVCENAME and uses the * * service name. * **************************************************************** * PROBLEM DESCRIPTION: * * When DB2 instance is configured for SSL and both * * SSL_SVCENAME * * and SVCENAME is configured the db2 server take the port * * number * * for SSL_SVCENAME in the service file is used for SVCENAME. * * * * * * * * You may get error message like below. Take note that it's * * * * mentioning SVCENAME but showing the port number for * * SSL_SVCENAME * * * * * * 2010-10-22-14.33.27.461788+120 E49703A733 LEVEL: * * Error * * PID : 606322 TID : 258 PROC : * * db2sysc * * INSTANCE: dbtesting NODE : 000 * * * * EDUID : 258 EDUNAME: db2sysc * * * * FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, * * * * probe:46 * * * * MESSAGE : ADM7007E The SVCENAME DBM configuration * * parameter, * * "51089", is configured with a port or a service name. When * * it is * * configured with a service name, the TCP/IP services files is * * used to * * map the service name to a port number. The port specified * * in this * * field is being used by another process. Resolve this * * problem by * * either deleting the process using the port or use another * * port. * **************************************************************** * RECOMMENDATION: * * Fixed in DB2 v9.7 fix pack 4 and in later versions. * * Work Around: Put in portnumber instead of servicename for * * SVCENAME in the DB2 database manager configuration. * **************************************************************** | |
Local Fix: | |
Put in portnumber instead of servicename for SVCENAME in the DB2 database manager configuration. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Fixed in DB2 v9.7 fix pack 4. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC72801 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.11.2010 27.05.2011 27.05.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |