Skip to content

Instantly share code, notes, and snippets.

@bdietz400

bdietz400/When was the Last IPL

Created July 26, 2021 14:37
Show Gist options
  • Save bdietz400/4dd7a36055c44f2b1d2ef0d938491687 to your computer and use it in GitHub Desktop.
Save bdietz400/4dd7a36055c44f2b1d2ef0d938491687 to your computer and use it in GitHub Desktop.
Download ZIP
Last_IPL
Raw
When was the Last IPL
-- description: LAST_IPL.sql
-- Analogus to the CL I created years ago:
-- that calls API QUSRJOBi against job 000000/QSYS/SCPF using format JOBi0400
SELECT Job_Entered_System_Time AS Last_Ipl
FROM TABLE(Qsys2.Job_Info(Job_Status_Filter => '*ACTIVE', Job_User_Filter => 'QSYS')) X
WHERE Job_Name = '000000/QSYS/SCPF' ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment