Original Message:
Sent: Thu June 27, 2024 11:33 AM
From: Virgile VATIN
Subject: SYSTOOLS.ENDED_JOB_INFO() return ++++++++++++ Value
Thank you Robert,
I will do that.
Regards
------------------------------
Virgile VATIN
Original Message:
Sent: Thu June 27, 2024 10:07 AM
From: Robert Berendt
Subject: SYSTOOLS.ENDED_JOB_INFO() return ++++++++++++ Value
At one time you used to be able to search PTF cover letters. There's still a site for this but it really no longer works. I tried to submit feedback on it today but it seems non responsive. Other IBM sites are having issues too so... But here is the ptf cover letter site. https://www.ibm.com/support/pages/access-ptf-cover-letters I really tried to find a PTF which matches the issue but the search is upsetting me and I've got "real" work to do.
Today I am actually updating our sandbox P10. I am putting the latest TR, cume, firmware and vios updates on.
In summary: If you can put on PTF's I would strongly recommend you do so. If you still have the issue, open a case with IBM.
------------------------------
Robert Berendt IBMChampion
Original Message:
Sent: Thu June 27, 2024 09:15 AM
From: Virgile VATIN
Subject: SYSTOOLS.ENDED_JOB_INFO() return ++++++++++++ Value
Hi Robert,
I try with the clause "where JOB_ENTERED_SYSTEM_TIME is null". The query failed with error 6
SQL status : 22023
Provider code: -802 Message: [SQL0802] Data conversion or mapping error
Error 6 which mean Incorrect numeric data
I've look at a job with the two CPF1124 & CPF1164 in dsplog, the same i've the columms with ++++++++++++ and only ++++++++++++ no other characters for all job.
------------------------------
Virgile VATIN
Original Message:
Sent: Wed June 26, 2024 10:19 AM
From: Robert Berendt
Subject: SYSTOOLS.ENDED_JOB_INFO() return ++++++++++++ Value
Well, if you do a
... where JOB_ENTERED_SYSTEM_TIME is null
does that only shows the rows with plus signs or is there a mix?
I would think this function would have to match the CPF1164 message with it's matching CPF1124 message like the following:
CPF1124: Job 146476/QSYS/QYMEARCPMA started on 06/26/24 at 00:00:02 in subsystem QSYSWRK in QSYS. Job entered system on 06/26/24 at 00:00:02.
CPF1164: Job 146476/QSYS/QYMEARCPMA ended on 06/26/24 at 00:00:03; .146 seconds used; end code 0
And if the job has been running longer than your purge interval on your history log, then I can see how those columns would be null.
GO CLEANUP
- Change cleanup options
System journals and system logs . . . . . . . . 30
------------------------------
Robert Berendt IBMChampion
Original Message:
Sent: Wed June 26, 2024 06:21 AM
From: Virgile VATIN
Subject: SYSTOOLS.ENDED_JOB_INFO() return ++++++++++++ Value
Hi,
I try to use the table SYSTOOLS.ENDED_JOB_INFO(), I have find an exemple in ACS in run sql query tool.
When I run the sql example statements the columns name JOB_ENTERED_SYSTEM_TIME and JOB_ACTIVE_TIME return "+++++++++++++++" value.
From IBM theses Columns return the null value if the value is not available. Does the +++++++++++++++ is a null value or is this a bug ?
Regards
------------------------------
Virgile VATIN
------------------------------