Troubleshooting
Problem
We were unble to start IBM FileNet Content Engine (CE), and it threw a database error.
Symptom
When running test connection in the Websphere, it throws the following error:
The test connection operation failed for data source FNGCDDS on server server1 at node [] with the following exception: java.sql.SQLException:DB2 SQL Error: SQLCODE=-290,SQLSTATE=55039,SQLERRMC=null,DRIVER=3.57.82DSRA0010E:SQL State=55039,Error Code=-290
...
Run the following DB2 command, and encountered an error:
db2 => connect to gcddb
SQL0290N Table space access is not allowed. SQLSTATE=55039
Cause
The containers (files) for the temporary tablespaces were accidentally removed. In this case, DB2 could not find the containers for the temporary tablespaces, and the tablespaces would get error, which is the root cause of this issue. In fact, DB2 does not delete containers automatically, neither does the FileNet application since it is built on top of the DB2, so the accidental deletion of the container are outside the control of DB2.
Environment
IBM DB2 9.7
Diagnosing The Problem
Check the file system, and confirm if the files for the temporary tablespaces were still there.
Resolving The Problem
You can engage DB2 DBA or IBM DB2 support team to assist for a procedure to recreate the containers for the temporary tablespaces.
Was this topic helpful?
Document Information
More support for:
FileNet P8 Platform
Software version:
5.1
Operating system(s):
AIX
Document number:
215721
Modified date:
17 June 2018
UID
swg21621352