Admin mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vntapia - 23 Jan 2007 23:10 GMT

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.

Reply to this Message

Joachim Klassen - 24 Jan 2007 13:39 GMT

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

Reply to this Message

vntapia - 24 Jan 2007 16:28 GMT

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?

> > 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
[quoted text clipped - 10 lines]
> HTH
> Joachim

Reply to this Message

vntapia - 24 Jan 2007 17:20 GMT

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

> I can not set parameter INDEXREC because requires a database
> connection, and db2dart /MI requires tablespace id and index object id,
[quoted text clipped - 14 lines]
> > HTH
> > Joachim- Hide quoted text -- Show quoted text -

Reply to this Message

Gert van der Kooij - 24 Jan 2007 17:42 GMT

> I can change parameter INDEXREC and set to ACCESS, but I cannot even
> connect to db
>
> > 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?

Reply to this Message