Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2011
    Posts
    16

    Question Unanswered: Tables are missing

    Yesterday I had 70 tables in my database...Now I checked there are only 26 tables ??
    Tables are not dropped i have checked

    db2 "list history dropped table all for db qfidb"

    List History File for qfidb

    Number of matching file entries = 0

    and tablespaces are also there.
    Kindly help


    Ashish

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS?

    Do you have DROPPED TABLE RECOVERY turned on for the tablespaces?

    Andy

  3. #3
    Join Date
    Sep 2011
    Posts
    16
    Its 9.1 On AIX 6.1

    Yes DROPPED TABLE RECOVERY turned on for the tablespaces


    Ashish

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the output of: "select tbspace,drop_recovery from syscat.tablespaces"?

    Andy

  5. #5
    Join Date
    Sep 2011
    Posts
    16
    bash-3.2$ db2 "select substr(tbspace,1,15),drop_recovery from syscat.tablespaces"

    1 DROP_RECOVERY
    --------------- -------------
    SYSCATSPACE N
    TEMPSPACE1 N
    USERSPACE1 Y
    TBSPACE1 Y
    TBSPACE2 Y
    TBSPACE3 Y
    TBSPACE4 Y
    TBSPACE5 Y
    TBSPACE6 Y
    TBSPACE7 Y
    TBSPACE8 Y
    TBSPACE9 Y
    TBSPACE10 Y
    TBSPACE11 Y
    TBSPACE12 Y
    TBSPACE13 Y
    SYSTOOLSPACE Y
    SYSTOOLSTMPSPAC N

    18 record(s) selected.


    Ashish

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Which tablespaces were the tables in?

    Andy

Posting Permissions

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