Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2004
    Posts
    10

    Unanswered: container invalid

    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

  2. #2
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Question

    What OS and what version of DB2 are you running?

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by dcazares
    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
    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...
    --
    Jonathan Petruk
    DB2 Database Consultant

  4. #4
    Join Date
    Jun 2004
    Posts
    10
    DB2 Version is 8.1 (without fixpacks)
    and OS is Red Hat AS 2.1

  5. #5
    Join Date
    Jun 2004
    Posts
    10
    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

  6. #6
    Join Date
    Mar 2004
    Posts
    448
    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

  7. #7
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by bmujeeb
    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.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •