"SQL2071N An error occurred while accessing the shared library "C:\PROGRA~1\IBM\SQLLIB\bin\db2tsm.dll"" trying to connect to database
Customer has restored copy of a DB2 database (from a backup) onto a new DB2 server. User has created a new database connection (to point to this new database copy).
Afterwards, user launches 'Controller Configuration', opens 'Database Connections' and selects a database. User clicks green 'tick' to test the connection. An error appears.
Error using Database Conversion:
SQL2071N An error occurred while accessing the shared library "C:\PROGRA~1\IBM\SQLLIB\bin\db2tsm.dll". Reason code: "1".
Backup was performed from a source DB2 server which uses Tivoli Storage Manager to archive its logs.
Diagnosing the problem
Run the following command to find out the current state of the database:
db2 get db cfg for ccr
TIP: Replace 'ccr' with the name of your database.
db2 rollforward db ccr complete
You will get the following message:
|SQL2071N An error occurred while accessing the shared library
"C:\PROGRA~1\IBM\SQLLIB\bin\db2tsm.dll". Reason code: "1".
This confirms that those TSM logs are the culprit.
Resolving the problem
Update the database to use 'DISK' (rather than TSM) logs.
Run the following command:
db2 update db cfg for <DBNAME> using LOGARCHMETH1 DISK:<Disk Path>
db2 update db cfg for CCR using LOGARCHMETH1 DISK:D:
Translate this page: