IBM Support

Slow connection when connecting from a DB2 Windows client.

Technote (FAQ)


Question

When connecting from a DB2 Windows client with an ID which does not exist in the Windows client or the Windows client’s domain, the connection may take a long time.

Cause

By default, a DB2 Windows client would authenticate an ID. If the ID does not exist, the domain will be queried and also its trusted domains. It could take a long time query all trusted domains.

Answer

Cataloging database as authentication set to server stops DB2 Windows client to authenticate. The following is the command to catalog a database as authentication set to server.

db2 catalog db <database name> at node <node name> authentication server

Related information

cataloging database

Document information

More support for: DB2 for Linux, UNIX and Windows
Connectivity - Other

Software version: 9.1, 9.5, 9.7, 9.8, 10.1, 10.5, 11.1

Operating system(s): Windows

Software edition: Enterprise Server, Express, Personal, Personal Developer's, Workgroup Server

Reference #: 1450945

Modified date: 27 October 2010