Restrict on drop and table is inaccessible

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Arun Srinivasan
    #1

    Restrict on drop and table is inaccessible

    The table became inaccessible due to an error during an insert in 'not
    logged' mode. Now I can't drop it, since it was declared using
    'restrict on drop'.. Pleaseeeeee heklp. It's using 400 GIGS........
    Tags: None
    • Keith
      #2
      Re: Restrict on drop and table is inaccessible

      On Feb 21, 9:44 am, Arun Srinivasan <arunro...@gmai l.comwrote:
      The table became inaccessible due to an error during an insert in 'not
      logged' mode. Now I can't drop it, since it was declared using
      'restrict on drop'.. Pleaseeeeee heklp. It's using 400 GIGS........
      alter table TabName drop restrict on drop

      Keith Ponnapalli
      adv_dba at yahoo dot com
      IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for
      Linux,
      UNIX, and Windows
      INFORMIX Certified Database Administrator

        Comment

        • Arun Srinivasan
          #3
          Re: Restrict on drop and table is inaccessible

          On Feb 21, 10:07 am, Keith <pr...@yahoo.co mwrote:
          On Feb 21, 9:44 am, Arun Srinivasan <arunro...@gmai l.comwrote:
          >
          The table became inaccessible due to an error during an insert in 'not
          logged' mode. Now I can't drop it, since it was declared using
          'restrict on drop'.. Pleaseeeeee heklp. It's using 400 GIGS........
          >
          alter table TabName drop restrict on drop
          >
          Keith Ponnapalli
          adv_dba at yahoo dot com
          IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for
          Linux,
          UNIX, and Windows
          INFORMIX Certified Database Administrator
          Can't do that if table is inaccessible on error during not logged
          mode.....

            Comment

            • Keith
              #4
              Re: Restrict on drop and table is inaccessible

              On Feb 21, 10:30 am, Arun Srinivasan <arunro...@gmai l.comwrote:
              On Feb 21, 10:07 am, Keith <pr...@yahoo.co mwrote:
              >
              On Feb 21, 9:44 am, Arun Srinivasan <arunro...@gmai l.comwrote:
              >
              The table became inaccessible due to an error during an insert in 'not
              logged' mode. Now I can't drop it, since it was declared using
              'restrict on drop'.. Pleaseeeeee heklp. It's using 400 GIGS........
              >
              alter table TabName drop restrict on drop
              >
              Keith Ponnapalli
              adv_dba at yahoo dot com
              IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for
              Linux,
              UNIX, and Windows
              INFORMIX Certified Database Administrator
              >
              Can't do that if table is inaccessible on error during not logged
              mode.....
              oops. You may just have to restore or call IBM to see if they
              magically fix it.

              KP

                Comment

                • Arun Srinivasan
                  #5
                  Re: Restrict on drop and table is inaccessible

                  I am doomed forever. This is a tablespace in prod db without a usefull
                  tbspace backup. This is the 1st time I am disappointed with db2. If
                  IBM has special code that'd make me drop the table, it will be
                  awesome..

                    Comment

                    • Serge Rielau
                      #6
                      Re: Restrict on drop and table is inaccessible

                      Arun Srinivasan wrote:
                      I am doomed forever. This is a tablespace in prod db without a usefull
                      tbspace backup. This is the 1st time I am disappointed with db2. If
                      IBM has special code that'd make me drop the table, it will be
                      awesome..
                      Open a PMR. They can sure fix it. And if you got there in a "legal" way
                      then this would also justify an APAR to provide an out so you're the
                      last one to whom this happens.

                      Cheers
                      Serge

                      --
                      Serge Rielau
                      DB2 Solutions Development
                      IBM Toronto Lab

                        Comment

                        Previous template Next
                        Working...