Understand what happens during Restart into Admin and Online mode
There is a new section in SCN which explains in detail what happens during the restart of a SAP MaxDB database based on Version 7.9 into admin and online mode.
Checking this section you will understand the information in KnlMsg file related to the restart.
Starting the database into Admin mode starts the so called Runtime environment first, reading parameters, creating the kernel process structure ….
This section in KnlMsg is never overwritten. This section is used to find out which was the parameter setting the database was started with, the memory configuration, the Kernel OS limits, …..
The section start into Admin mode ends with the message ServerDB is ready.
After the database is in admin mode the restart goes on – Attaching the volumes, restart the file directory, doing the Redo undo …..
This section in the KnlMsg end with the message Kernel state: ‘ONLINE’ reached.
This section will be overwritten with connect, status and error messages while the database is in online mode.
This information about the restart can help to find the reason for failing restarts.
Helpful here as well is the recommended Expert Session 18 about SAP MaxDB Architecture. (Link available in the section)