From: morch on
Hello,

I have an oddity on a production database. I get the following from
the DB CFG :

Backup pending = NO

Database is consistent = NO
Rollforward pending = TABLESPACE
Restore pending = NO

but no tablespaces are in a state other than 0 when I do a list
tablespaces show detail. ?????

How can I find out which tablespace is in conflict?

Mairhtin O'Feannag

aka mairhtin at mairhtin dot com

From: vijay.db on
On Jan 30, 11:10 pm, "morch" <f...(a)mairhtin.com> wrote:
> Hello,
>
> I have an oddity on a production database. I get the following from
> the DB CFG :
>
> Backup pending = NO
>
> Database is consistent = NO
> Rollforward pending = TABLESPACE
> Restore pending = NO
>
> but no tablespaces are in a state other than 0 when I do a list
> tablespaces show detail. ?????
>
> How can I find out which tablespace is in conflict?
>
> Mairhtin O'Feannag
>
> aka mairhtin at mairhtin dot com

Hi,

Kindly ensure whether your SYSCAT tablespace is in Consistent state..

it's
vj-dba

From: morch on
All tablespaces are state 0. Including syscat :

=> db2 list tablespaces show detail | grep State
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000
State = 0x0000


On Feb 1, 3:43 am, vijay...(a)gmail.com wrote:
> On Jan 30, 11:10 pm, "morch" <f...(a)mairhtin.com> wrote:
>
>
>
> > Hello,
>
> > I have an oddity on a production database. I get the following from
> > the DB CFG :
>
> > Backup pending = NO
>
> > Database is consistent = NO
> > Rollforward pending = TABLESPACE
> > Restore pending = NO
>
> > but no tablespaces are in a state other than 0 when I do a list
> > tablespaces show detail. ?????
>
> > How can I find out which tablespace is in conflict?
>
> > Mairhtin O'Feannag
>
> > aka mairhtin at mairhtin dot com
>
> Hi,
>
> Kindly ensure whether your SYSCAT tablespace is in Consistent state..
>
> it's
> vj-dba


From: morch on
Anyone? Anyone?

Mairhtin


On Jan 30, 10:10 am, "morch" <f...(a)mairhtin.com> wrote:
> Hello,
>
> I have an oddity on a production database. I get the following from
> the DB CFG :
>
> Backup pending = NO
>
> Database is consistent = NO
> Rollforward pending = TABLESPACE
> Restore pending = NO
>
> but no tablespaces are in a state other than 0 when I do a list
> tablespaces show detail. ?????
>
> How can I find out which tablespace is in conflict?
>
> Mairhtin O'Feannag
>
> aka mairhtin at mairhtin dot com


From: morch on
C'MON... SOMEONE must have an answer to this. :) Please!!

Mairhtin



On Jan 30, 10:10 am, "morch" <f...(a)mairhtin.com> wrote:
> Hello,
>
> I have an oddity on a production database. I get the following from
> the DB CFG :
>
> Backup pending = NO
>
> Database is consistent = NO
> Rollforward pending = TABLESPACE
> Restore pending = NO
>
> but no tablespaces are in a state other than 0 when I do a list
> tablespaces show detail. ?????
>
> How can I find out which tablespace is in conflict?
>
> Mairhtin O'Feannag
>
> aka mairhtin at mairhtin dot com