Troubleshooting
Problem
The "create tablespace" command is use to create a temporary tablespace. The command fails with the SQL0194N error.
Symptom
An example of the command used follows :
db2 "create system temporary tablespace lgtmptsp pagesize 32k bufferpool largebufpool1"
The command fails with below errors :
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0294N The container is already in use. SQLSTATE=42730
Cause
The old container still exist
Environment
Tivoli Storage Manager Server
Resolving The Problem
Follow the steps below to resolve this error.
- Run the "db2 list tablespaces show detail" command to ensure the tablespace does not exist. In this case the LGTMPSP tablespace.
- After verifying that the LGTMPSP tablespace does not exist, reset db2 and redo the connection before attempting the recreate. Run the following commands :
db2stop force
ipclean
db2start
db2 connect to tsmdb1 - Re-run the create comnmand, i.e,
db2 "create system temporary tablespace lgtmptsp pagesize 32k bufferpool largebufpool1"
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21694223