Re: Is there a system a catalog that will check multiple jobs joblog for a specific message id?

Rob,

By adding the library that contains CUSRMSG to my interactive library list, I got rid of the CPF2407 Message file CUSRMSG in *LIBL not found.
I'm not sure why the SQL was complaining about that CUSRMSG file.

Rerunning the SQL, still have the below messages/errors.

Message ID . . . . . . : CPF503E
Date sent . . . . . . : 08/29/18 Time sent . . . . . . : 14:08:51
Message . . . . : User-defined function error on member QSQPTABL.
Cause . . . . . : An error occurred while invoking user-defined function
JOBLOG_INFO in library QSYS2. The error occurred while invoking the
associated external program or service program QDBSSUDF2 in library QSYS,
program entry point or external name QSQJOBLOG, specific name QSQJOBLOG. The
error occurred on member QSQPTABL file QSQPTABL in library QSYS2. The error
code is 1. The error codes and their meanings follow:
1 -- The external program or service program returned SQLSTATE 42704. The
text message returned from the program is: JOB 776228/QUSER/QZLSFILE NOT
FOUND .

Message ID . . . . . . : CPF5104
Date sent . . . . . . : 08/29/18 Time sent . . . . . . : 14:08:51
Message . . . . : Cancel reply received for message CPF503E.
Cause . . . . . : Either a cancel reply was received from the operator or
the program, or the system used a default reply. The cancel reply was
received for message CPF503E in file QSQPTABL in library QSYS2 with device
or member QSQPTABL.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steinmetz, Paul
Sent: Wednesday, August 29, 2018 11:35 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Is there a system a catalog that will check multiple jobs joblog for a specific message id?

Rob,

Sorry, misunderstood.
Yes, CPF2407 Message file CUSRMSG in *LIBL not found.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Wednesday, August 29, 2018 11:32 AM
To: Midrange Systems Technical Discussion
Subject: RE: Is there a system a catalog that will check multiple jobs joblog for a specific message id?

No the message is NOT KTA0203 in message file RXS/RXSMSGF.
The message I asked about was in YOUR joblog: Message file CUSRMSG in
*LIBL not found. Is the message file message CPF2407?

I am trying the same SQL. The only difference is that I monitored it for
a different user message. One that I created in an interactive session
joblog. This will not be in the library list of my Run SQL Scripts job.
...
...
...
Ran fine.

Product ID/PTF ID . . . . . . . . . . : 5770SS1 SI67249
Release . . . . . . . . . . . . . . . : V7R3M0
On order . . . . . . . . . . . . . . . : No
PTF save file . . . . . . . . . . . . : No
PTF status . . . . . . . . . . . . . . : Temporarily applied


PTF Group Level Status
SF99703 10 Installed


I remember seeing this CUSRMSG somewhere but I cannot remember where.
You might have to open a ticket.


Rob Berendt