SAPDB -9041 BD Index

[Former Member]

Hi there everyone,

I have the following error :

SAPDB -9041 BD Index not accessible.

What is the cause for the exception?

After reading through some documentation on the net, i came to know that indexes get corrupted if there isnt a normal shutdown.

How can i recreate indexes using <b>dbmcli.exe</b>?

I am not a database administrator. Please help me out.

Thanks

chan

[markus_doehr2]

The reason is, that the index is corrupt.

Which database version do you use (dbmcli db_enum) and so you know the statement causing this error?

--

Markus

[Former Member]

Hi Markus,

I am an ABAP and XI Consultant. I have no idea about the database.

When I am importing a few software component versions in Integration Repository, i get this error.

How should i find out the version of the database?

Chan

[markus_doehr2]

as I said:

- logon as user <SID>adm

- open a cmd.exe

- "dbmcli.exe db_enum"

There you will get the database version.

The problem is, that one Index is corrupt and you will need to repair it. Without any database knowledge it's pretty cumbersome to explain.

I suggest opening an OSS call, the support can fix that.

--

Markus

[former_member229109]

Hello Chan,

**-> You could review the answer on the question:

"18. What are BAD indexes, how do they come about, and how can I

eliminate them?"

In the SAP note 928037 FAQ: MaxDB Indexes

Please also review the note::

940420 FAQ: Database structure check (VERIFY)

**-> To find the database version please run TA /ndb59 ->

databaseAssistent < /ndb50 or /ndb50n > -> Properties

Or using dbmcli tool as <SID>adm user on the database server

dbmcli -U c show version

< the database need to be in ADMIN or ONLINE mode to get

information with 'show version' command >

dbmcli -U c dbm_version

< dbmcli -d <DB-Name> -u control,<control> dbm_version >

< xinstinfo <DB-name> >

**-> See the SAP note 767598 Available documentation. Go to the link specified

for your database version. As SAP customer, you could see the SAP

documentation, for example, at

http://help.sap.com/saphelp_nw04s/helpdata/en/07/595f51b1889b478869e338198171b5/frameset.htm

Glossary ->Index -> < review the information >

-> check at Database Manager CLI: sql_recreateindex

< if you would like to use the dbmcli tool >

• -> As SAP customer welcome to SAP MAXDB support help. Please create the

ticket to the component 'BC-DB-SDB', if you are not able to solve the MAXDB

issue by yourself.

Thank you and best regards, Natalia Khlopina