Restrict on drop and table is inaccessible

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arun Srinivasan - 21 Feb 2008 15:44 GMT

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........

Reply to this Message

Keith - 21 Feb 2008 16:07 GMT

> 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

Reply to this Message

Arun Srinivasan - 21 Feb 2008 16:30 GMT

> > 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
[quoted text clipped - 8 lines]
> UNIX, and Windows
> INFORMIX Certified Database Administrator

Can't do that if table is inaccessible on error during not logged
mode.....

Reply to this Message

Keith - 21 Feb 2008 19:59 GMT

> > > 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
[quoted text clipped - 11 lines]
> 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

Reply to this Message

Arun Srinivasan - 22 Feb 2008 15:57 GMT

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..

Reply to this Message

Serge Rielau - 22 Feb 2008 23:16 GMT

> 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

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Arun Srinivasan - 25 Feb 2008 22:51 GMT

> > 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
[quoted text clipped - 12 lines]
> DB2 Solutions Development
> IBM Toronto Lab

We did, and the IBM guy gave us the db2dart with 'db
password' (regenerated always), that put the table in 'drop pending'
state,and was able to fix this. IBM said that the security issue dont
allow an APAR for this, anyways, I have my space back..

Happier,
Arun

Reply to this Message