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