DB2 10 on Windows - Shutdown best practice

rob herman

DB2 10 on Windows - Shutdown best practice

What is the cleanest method, or process for shutting down DB2 10 on Windows.

Steps you recommend.

For instance, for a virtual move or Windows patch reboot we would first need to stop DB2 before reboot.

Jan Moeyersons

RE: DB2 10 on Windows - Shutdown best practice
(in response to rob herman)

I would say: just let Windows stop the service. I do take it you are running DB2 as a Windows service... 

Windows, in its regular shutdown procedure, will send a stop command to the service and that should be enough to bring DB2 down gracefully. 

If you want to stop DB2 without stopping Windows, you can use the same approach: run the NET STOP DB2 command (or use the GUI to stop the service). Or you can run the DB2STOP command, which has the same net effect.

This is what we do and it works fine. Never had a problem with that.

Don't know about the virtual move, but rumour has it that should be completely transparent and you don't actually have to stop/restart anything. Depends on you hypervisor, of course.

Cheers,

Jantje.


In Reply to rob herman:

What is the cleanest method, or process for shutting down DB2 10 on Windows.

Steps you recommend.

For instance, for a virtual move or Windows patch reboot we would first need to stop DB2 before reboot.