× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



You can change the system value QLOGOUTPUT to *PND. Then they will no
longer go to a spool output automatically. You can query the joblog with
SQL even after the job ends. If you just HAVE to have a spool file version
(like for an IBM case) you can always do a DSPJOBLOG OUTPUT(*PRINT)
JOB(...).
https://www.ibm.com/docs/en/i/7.5?topic=svjo-jobs-system-values-produce-printer-output-job-log
If IBM had started out this way people would wonder why anyone would ever
choose automatically generating spool files. However some people are
resistant to change. Or they have some kludgy setup which does a CPYSPLF
to a holding file for auditing purposes. For a better solution one can
easily use the joblog service to output to an audit file, and even add
columns wanted.

Think of this; let's say you're looking for four consecutive words. Let's
say that the spool file version has two of the words on one line but the
next two are continued on the next line. While there are some people who
thrive on such challenges wouldn't it just be a whole lot easier to
SELECT * FROM TABLE(QSYS2.JOBLOG_INFO('347117/QUSER/QZDASOINIT'))
where upper(message_text) like '%MY FOUR CONSECUTIVE WORDS%'

Does anyone know what version of the OS introduced system value
QLOGOUTPUT? It's been years and years.
SELECT * FROM TABLE(QSYS2.JOBLOG_INFO('347117/QUSER/QZDASOINIT'));

On Sat, Jul 1, 2023 at 9:43 AM tim ken <timk2574@xxxxxxxxx> wrote:

Hi,

Similarly if one has to search the job log of an already completed job or
the job which ended abnormally? Then how to check it using SQL query or any
other way around there please?


Thanks much..


On Fri, 30 Jun 2023 at 17:44, Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

Not only did you reply with DSPJOB instead of DSPJOBLOG but why in the
world would you want to go to a spool file instead of querying the joblog
directly?
If you want to query a DB2 file do you do CPYF FROMFILE(MYLIB/MYFILE)
TOFILE(*PRINT) and then query that spool file or do you query the file
directly?
BTW we changed the system value QLOGOUTPUT over a decade ago to stop
generating spool files of joblogs and leave them in *PND state to ease
querying them and not leave users deleting spool files we needed.
See JOBLOG_INFO() at https://www.ibm.com/support/pages/node/1119123

On Thu, Jun 29, 2023 at 1:24 PM Sizer, Joseph via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

DSPJOB JOB(JOB#/USER/JOBNAME) OUTPUT(*PRINT)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
John Yeung
Sent: Thursday, June 29, 2023 1:21 PM
To: Midrange Systems Technical Discussion <
midrange-l@xxxxxxxxxxxxxxxxxx

Subject: How to search job log of an active job

________________________________
CAUTION: This email originated from outside of the PENCOR network. Do
not
click on any links or open attachments unless the sender is known, and
the
content is verified as safe.
________________________________

Is there a way to search the text of a job log while that job is still
running?

Is there a way to output the job log of an active job to an output
file,
spooled file, or stream file?

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related
questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.