I am monitoring some of our Apache server jobs for messages related to some programming changes I made. However, I am seeing a lot of SQL0204 (file not found) messages that do not tell me which program was attempting to query the file. Here is the message in it's entirety:
When I view message details, the from and to programs are QSQRUN2, procedure CK_DEBUG.
Is there a way to determine which program caused this error without scanning all source for missing table? To be clear, this file does exist, but somehow the library list is not being set properly (or is corrupted). We do not use *JOBD's to drive library lists (unfortunately).
Code:
Message ID . . . . . . : SQL0204 Date sent . . . . . . : 07/23/19 Time sent . . . . . . : 10:56:51 Message . . . . : MYFILE in *LIBL type *FILE not found. Cause . . . . . : MYFILE in *LIBL type *FILE was not found. If the member name is *ALL, the table is not partitioned. If this is an ALTER TABLE statement and the type is *N, a constraint or partition was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, trigger or sequence object was not found. If a function was not found, MYFILE is the service program that contains the function. The function will not be found unless the external name and usage name match exactly. Examine the job log for a message that gives more details on which function name is being searched for and the name that did not match.
Is there a way to determine which program caused this error without scanning all source for missing table? To be clear, this file does exist, but somehow the library list is not being set properly (or is corrupted). We do not use *JOBD's to drive library lists (unfortunately).
Comment