02a - SQL (EN)

Up and down (EN)

When did our IBM i shut down and last? And how long did it take to go out and turn on? In this article I suggest a simple API and some ready-to-use SQL statements to extract information about the last shutdown and power-up of IBM from the system This information is contained in various "angles" of our operating system (system values, system operator messages, history logs, …). With a few SQL statements we display them all together.
Read more