For iSeries, when a problem is encountered when running a query through the SQL window in Operations Navigator, sometimes it is difficult to figure out what the issue with your query is based on the information that navigator shows you.
It is possible to get more information about what caused the problem with your query by looking at the joblog through a green screen. However, how do you find the job?
The name of the job that services sql requests on iSeries is QZDASOINIT. Using a wrkjob command on that jobname, find the job that is servicing your query window. Option 1 to select the job, 10 to work with the joblog, F10 and F18 to go to the bottom of the joblog, and you should find more information about the problem with your query.
Tuesday, May 26, 2009
Subscribe to:
Comments (Atom)
