Re: API to tell me how long the system or LPAR has been "up" since the last IPL

Expanding on Robs Solution and maybe answering Mark's original question

select
timestampdiff(2, char(current timestamp - job_entered_system_time)) as seconds_since_IPL
,timestampdiff(4, char(current timestamp - job_entered_system_time)) as minutes_since_IPL
,timestampdiff(8, char(current timestamp - job_entered_system_time)) as hours_since_IPL
,timestampdiff(16, char(current timestamp - job_entered_system_time)) as days_since_IPL
,timestampdiff(32, char(current timestamp - job_entered_system_time)) as weeks_since_IPL
,current timestamp as Time_now
,job_entered_system_time
from table(qsys2.active_job_info(JOB_NAME_FILTER => 'SCPF',DETAILED_INFO => 'ALL')) B ;

1 : Fractions of a second
2 : Seconds
4 : Minutes
8 : Hours
16 : Days
32 : Weeks
64 : Months
128 : Quarters of a year
256 : Years



Bryan


Rob Berendt wrote on 2/20/2020 4:00 PM:

select job_name, job_active_time, job_entered_system_time
from table(qsys2.active_job_info(
RESET_STATISTICS => 'NO',
SUBSYSTEM_LIST_FILTER => '' ,
JOB_NAME_FILTER => 'SCPF',
CURRENT_USER_LIST_FILTER => '',
DETAILED_INFO => 'ALL'
)) B

Rob Berendt