WebSphere Issues

09/08/2010

Error code -1 from function: SQLConnect ldapdb2b

Filed under: DB2, TDS — Ishtiaque @ 12:28 pm

In/home/idsinst/idsslapd-idsinst/logs/db2cli.log file following errors logged:

SQL1652N File I/O error occured.

SQL1031N The database directory can’t be found on the indicated file system. SQLSTATE=58031

You get this kind of error when there are more than one database instances created on your machine and TDS database instance is not default  one.

You can view the list of database instances by running the command db2ilist with db2 admin user.

If your TDS instance is not listed at top you will get above errors while running the TDS instance or modifying any config changes in it’s database.

Usually we start the TDS instance with root not with idsinst user which is admin of TDS and it’s db2 instance. So when you will start the TDS instance usually with root it tries to locate it’s database i.e IDSDB in default instance say db2inst1.  So we need to define a variable DB2INSTANCE in either root profile or /etc/profile file so that TDS instance can locate correct db2 profile.

Add following line in /etc/profile and then run the command source /etc/profile to update the changes.

DB2INSTANCE=idsinst; export DB2INSTANCE

OR

export DB2INSTANCE=idsinst

/opt/ibm/ldap/V6.1/sbin/ibmslapd

References:

1. http://www-01.ibm.com/support/docview.wss?uid=swg21431185

2. http://www-01.ibm.com/support/docview.wss?rs=767&uid=swg21314966

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: