I cannot start a db in db2 v7.2 on aix 4.3.3, this database (sid22006)
has damaged a index, i want to start the db in admin mode or
maintenance mode to be able to delete the damaged index


No puedo levantar una base de datos en db2 v7.2 sobre aix 4.3.3, esta
base tiene dañados unos indices, deseo entrar a la base en mode de
mantenimiento o administrativo para poder borrar los inidices dañados
y a asi levantar la base.

On 24 Jan., 00:10, "vntapia" <vnta...@hotmail.com> wrote:
> I cannot start a db in db2 v7.2 on aix 4.3.3, this database (sid22006)
> has damaged a index, i want to start the db in admin mode or
> maintenance mode to be able to delete the damaged index
>
> No puedo levantar una base de datos en db2 v7.2 sobre aix 4.3.3, esta
> base tiene dañados unos indices, deseo entrar a la base en mode de
> mantenimiento o administrativo para poder borrar los inidices dañados
> y a asi levantar la base.

Have a look at the INDEXREC DB CFG parameter. Set it to ACCESS, then
you should be able to connect to your database and drop the index. Also
db2dart with /MI option might be useful. Just type db2dart in a shell
to see the syntax

HTH
Joachim

I can not set parameter INDEXREC because requires a database
connection, and db2dart /MI requires tablespace id and index object id,
how to I know this id's?


On 24 ene, 08:39, "Joachim Klassen" <JoKlas...@email.com> wrote:
> On 24 Jan., 00:10, "vntapia" <vnta...@hotmail.com> wrote:
>
> > I cannot start a db in db2 v7.2 on aix 4.3.3, this database (sid22006)
> > has damaged a index, i want to start the db in admin mode or
> > maintenance mode to be able to delete the damaged index
>
> > No puedo levantar una base de datos en db2 v7.2 sobre aix 4.3.3, esta
> > base tiene dañados unos indices, deseo entrar a la base en mode de
> > mantenimiento o administrativo para poder borrar los inidices dañados
> > y a asi levantar la base.Have a look at the INDEXREC DB CFG parameter. Set it to ACCESS, then
> you should be able to connect to your database and drop the index. Also
> db2dart with /MI option might be useful. Just type db2dart in a shell
> to see the syntax
>
> HTH
> Joachim

I can change parameter INDEXREC and set to ACCESS, but I cannot even
connect to db



On Jan 24, 11:28 am, "vntapia" <vnta...@hotmail.com> wrote:
> I can not set parameter INDEXREC because requires a database
> connection, and db2dart /MI requires tablespace id and index object id,
> how to I know this id's?
>
> On 24 ene, 08:39, "Joachim Klassen" <JoKlas...@email.com> wrote:
>
>
>
> > On 24 Jan., 00:10, "vntapia" <vnta...@hotmail.com> wrote:
>
> > > I cannot start a db in db2 v7.2 on aix 4.3.3, this database (sid22006)
> > > has damaged a index, i want to start the db in admin mode or
> > > maintenance mode to be able to delete the damaged index
>
> > > No puedo levantar una base de datos en db2 v7.2 sobre aix 4.3.3, esta
> > > base tiene dañados unos indices, deseo entrar a la base en mode de
> > > mantenimiento o administrativo para poder borrar los inidices dañados
> > > y a asi levantar la base.Have a look at the INDEXREC DB CFG parameter.. Set it to ACCESS, then
> > you should be able to connect to your database and drop the index. Also
> > db2dart with /MI option might be useful. Just type db2dart in a shell
> > to see the syntax
>
> > HTH
> > Joachim- Hide quoted text -- Show quoted text -

In article <1169659236.193673.74380@l53g2000cwa.googlegroups. com>,
vntapia@hotmail.com says...
> I can change parameter INDEXREC and set to ACCESS, but I cannot even
> connect to db
>
>
>
> On Jan 24, 11:28 am, "vntapia" <vnta...@hotmail.com> wrote:
> > I can not set parameter INDEXREC because requires a database
> > connection, and db2dart /MI requires tablespace id and index object id,
> > how to I know this id's?
> >

Maye you can find them in error messages in the db2diag.log?