Error code -1 from function: SQLConnect ldapdb2b

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

About Ishtiaque

I am IBM Certified Infrastructure Systems Architect, TOGAF 9 Certified, ITIL V3 Foundation certified and Oracle Certified Export in Java Web Component Developer with over 10 years of support and development experience in IBM middleware software and Java. Additionally, have a sound grip in databases, Linux and OpenStack administration. I hold the following certifications: IBM Certified Infrastructure Systems Architect TOGAF 9 Certified Oracle Certified Expert, Java EE6 Web Component Developer Oracle Certified Professional – Java 6 Programmer ITIL v3 Foundation Certified IBM Certified Solution Architect – Cloud Computing Infrastructure V1 IBM Certified System Administrator – WebSphere Portal V8, V7, V6.1, V6 IBM Certified System Administrator – WebSphere Application Server V7, V6.1 IBM Certified System Administrator – AIX V7 IBM Certified System Administrator – WebSphere MQ V7 IBM Certified Deployment Professional – Business Process Manager Advanced V7.5 IBM Certified Solution Advisor – Cloud Computing Architecture V3 IBM Certified Solution Developer – WebSphere Portal V5.1
This entry was posted in DB2, TDS. Bookmark the permalink.

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