Db Error

[Former Member]

Hello ,

when i am trying to restart the data base it throughthe folowing error,

i gave the command like that

dbmcli -d SSD -u control,xxxxxx db_state

OK

State

ADMIN

db_warm output

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

20013,Admin command cannot enter critical state 'Redo'

6,Restart, Error code 6561 "dbm_command_not_possible"

after that i am not able to make it up into online through SQl manager as well commads also.

It is very urgent please some one help me

your help would be appreciated

Regards,

Sankar.G

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

20013,Admin command cannot enter critical state 'Redo'

6,Restart, Error code 6561 "dbm_command_not_possible"

[former_member229109]

Hello Sankar.G,

Please check the knldiag.err & dbm.prt files located in the database Rundirectory on the database server.

< dbmcli -d SSD -u control,xxxxxx param_directget RUNDIRECTORY >

From the information you provided, it's looking that the database was crashed or stopped incorrectly < for example, you didn't shut down the database before you reboot the server ...>. You could check it in the database log files.

After that you restarted the database in online mode, but database need some time to redo log entries.

Therefore the database is in 'ADMIN' mode & 'REDO' log entries is running at the time

when you tried to run the 'db_warm' command again.

Please run the following commands on the database server:

x_cons SSD show active

x_cons SSD sh io

< wait 1-2 min & repeat the recommended commands >

If the status was not changed, please update the thread with knldiag file, as recommended by Lars.

Also please update with output of the commands:

xinstinfo SSD

dbmcli -d SSD -u control,xxxxxx show active

dbmcli -d SSD -u control,xxxxxx dbm_version

PS:: Run 'x_cons <DB-name> help' or see the documentation about x_cons - database Utilities tool at http://maxdb.sap.com/currentdoc/default.htm

If you are SAP customer, please see more info in the SAP note : 869267 FAQ: MaxDB LOG area

Thank you and best regards, Natalia Khlopina

[lbreddemann]

Hi Sankar,

what about the knldial-file?

Please give us a chance to help you

KR Lars