From: morch on 30 Jan 2007 13:10 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 1 Feb 2007 06:43 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 1 Feb 2007 13:01 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 13 Feb 2007 13:47 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 16 Feb 2007 17:28
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 |