Hello I have a big trouble

please help me!


I had a data base with your tablespaces in a diferent filesystem.
the database was dropped but not the tablespaces, they already exist,
how I can access to data or restore the database from these containers?

I don't have any backup.

I have the original script to create the database.
after create db, I replace the new containers with the old containers,
and then startup the engine.
when try to connect to database i have a message:
SQL0293N Error accessing a table space container. SQLSTATE=57048

the containers are DMS. the script for db creation is a follows:
create database prueba catalog tablespace managed by database using (file '/cluster/nfs/db2/catalogtbs' 25600) user tablespace managed by database using (file '/cluster/nfs/db2/usertbs' 524288) temporary tablespace managed by database using (file '/cluster/nfs/db2/temptbs' 128000)

regards

Diego

What OS and what version of DB2 are you running?

I'm not following 100%...

So you had a database, it had some DMS containers.

You dropped the database, but managed to somehow keep the tablespace containers?

Now you want to access the data in those containers?

Is that correct?

You *really* are not in a good place if this is true, the only supported way would be a restore. If you don't have a backup, there *may* be something you can do with db2dart, but I wouldn't hold my breath... do you have the catalog tablespace???

Call support...

DB2 Version is 8.1 (without fixpacks)
and OS is Red Hat AS 2.1

the DB was dropped, but i have a backup of all tablespace files:
catalog, user and temp, the issue is how access to data thas is there

There are some things that I am adding that helps you to understand.

1. You must have tablespace level backup.Individual containers are useless,
may be IBM technical support or some other utility that will help you.

2. It is almost impossible to create a database from tablespace level backup.Its what IBM documentation said , but may be some one has done little arm twisting to make it that happen.

regards,

mujeeb

I don't think he has a tablespace level db2 backup, just the raw containers.

Frustrating - you know the data is in there, formatted properly, sitting on pages, but without the database files themselves I think it's hopeless. I think if you call the lab they may be able to help you, but there's nothing exposed to end users that can recover the data. It would likely be billable time, too, since you've exhausted all supported means of recovering a database.