DATABASE IS NOT COMING TO ONLINE

[Former Member]

Hi Technology consultants,

ECC6.0 SR3 on AIX6.1 with MaxDB7.6 database. Right now database is not coming to ONLINE.

I checked the logfiles knldiag, knldiag.err, KnlMsg, knltrace,

ERR 12010 DBCRASH Kernel exited exit code 2

ERR 11872 MEMORY Not enough memory for I/O buffer cache wanted:2796544 kB!

And also itried to start database through dbmcli it showing

ERR

-24994,ERR_RTE: Runtime environment error

1,Check knldiag! Kernel exited with '0' before reaching ADMIN state (OS error co

de 11000)

Please help me,

Thanks and Regards,

Prasad

[lbreddemann]

> ERR 11872 MEMORY Not enough memory for I/O buffer cache wanted:2796544 kB!

Hi Prasad,

for one time the error message is really speaking for itself.

Obviously there is not enough memory available to take 2.6 GB Buffer Cache.

Reduce the Buffer Cache size and retry to start the database.

regards,

Lars

[Former Member]

Hi Lars,

Thank for quick reply, right now for Production Server CACHE_SIZE is 349568. but required size is 2796544MB.

I try change the CACHE_SIZE through DBManger here edit option is not there, tell me where i can change.

This is only ABAP stack.

Best Regards,

prasad.

[markus_doehr2]

As which user did you connect?

Markus

[Former Member]

Hi Markus,

I connect through <sid>adm

i tried with user control and superdba.

through dbmcli how to increase CACHE_SIZE, tell me syntax.

plz help me.

Regards,

Prasad

[markus_doehr2]

login as <sid>adm and enter

dbmcli -U c param_directput CACHE_SIZE 350000
dbmcli -U c param_checkall
dbmcli -U c db_offline
dbmcli -U c db_online

Markus