× 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.


  1.  Home
  2. RPG400-L
  3. February 2007

RE: I need faster SQL

My bad...

Rob said:

Here's the trick - do NOT specify a program on STRDBG.  Just simply type
in STRDBG UPDPROD(*YES) When it is done running, then look at the
joblog.

Kim said:

I just tried that and didn't get a job log.  Our shop's default for
submitted jobs is LOG(4 0 *NOLIST) LOGCLPGM(*NO).  I changed the job's
parameters to LOG(4 0 *MSG) LOGCLPGM(*YES) and got a job log, but did
not get any details regarding the SQL process.  Perhaps the tip
suggested is for interactive jobs only? 

Kin says:

I had to STRSRVPGM before starting STRDBG UPDPROD(*YES).  I should have
realized that for a batch job. My bad.

Now I have a job log that is 173 pages long.  And it looks like I am
getting a (SQL7913 Message: ODP deleted.) for every invocation of
$Allocate.  Does that sound right?

As an Amazon Associate we earn from qualifying purchases.

This thread ...
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.