WebSphere Issues

28/09/2010

SQL5043N Support for one or more communications protocols failed to start successfully

Filed under: DB2, Linux, TDS — Ishtiaque @ 8:35 am

After configuring Tivoli Directory Server databases some time we get following exception in:

/home/idsinst/sqllib/db2dump/db2diag.log

/home/idsinst/sqllib/log/db2start.log

SQL5043N  Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.

1. In order to resolve the above error enter following two lines in /etc/services file:

idsinstsvcids    3737/tcp
idsinstsvcidsi    3766/tcp

2. Run following commands to view and update SVCENAME parameter of idsinst instance:

-> db2 get dbm cfg | grep SVC

If it’s not set to idsinstsvcids, then run the following command to set it:

-> db2 update dbm cfg using SVCENAME idsinstsvcids

3. Verify TDS db alias node LDAPDB2N using correct service name i.e idsinstsvcids:

-> db2 list node directory

If LDAPDB2N node is not using idsinstsvcids service name, then un-catalog it and re-catalog it with correct service name.

-> db2 uncatalog node LDAPDB2N

Note: If you get the error SQL1326N The file or directory “” cannot be accesse, while running above command.

Then update the Group access (i.e Read and Write) for the files sqlnodir and sqlnobak inside the directory /home/idsinst/sqllib/sqlnodir/ from db2grp1 to idsldap OR dbsysadm (which ever group  idsinst is member of)

-> db2 catalog tcpip node LDAPDB2N remote localhost server idsinstsvcids

Node: After this step you might have to delete and recreate the itds db.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: