IBM DB2 error SQL5005C during server startup.

Upon windows server hosting DB2 reboot you will get an error message “SQL5005C”. This actually refers to “The operation failed because the database manager failed to access either the database manager configuration file or the database configuration file.” This is due to DB2 database utility (such as db2start, db2icrt, restore, or many others) requires that the database manager write to or read from either the database manager configuration file or the database configuration file, and the database manager was unable to access the configuration file.

This is fixed by performing the below steps:

1. Log in to the machine as system administrator.
2. Remove the db2systray by performing the following steps:
a. Windows Start –> All Programs –> IBM DB2 –> Command Line Tools –> Command Window Administrator.
b. db2systray -clean
3. Log off and log in to the machine.

Thanks,
WintelAdmin

HP ILO Power and Reset CLI commands

You can also SSH into the ILO and examine the command-line options. After Connecting to ILO using Putty. “power help” will list the options available.

power on – Turn the server on
power off – Turn the server off
power reset – Reset the server

If the ILO is not connecting you may need to reset the ILO. In order to reset the ILO, you should have Lights-Out Online Configuration Utility installed on server. You can reset the ILO using the command listed below

hponcfg /reset or hponcfg /

If you have GUI installed,

1. Open
2. click on “Summary”
3. Select “Reset ILO/Set to factory default”
4. Click on “Reset” available under “Reset ILO firmware”.

On successful reset you will get a pop-up “Successful execution”.

Thanks,
WintelAdmin