|
In pre-v5r1 of the CAE ODBC dirver, it is tricky to find the QZDASOINIT job to run STRDBG over. The latest driver has a setting to STRDBG on the connection, as well as logging, IIRC. Other suggestions of using OpsNav SQL Statement Processor or QMQRY are good. It's harder to use RUNQRY, since you need to fit your SQL statement into the various entries of Query/400 (IMO) At 02:12 PM 8/29/02 -0400, you wrote:
>Ok, so if the RSP column is all 0.X >it isn't that big of a deal?
-snip-
The new question "I was just curious if this time of response was normal for the type of situation." is a bit different. Here, Walden's advice is good: Create an index that supports your query. You can find out what indexes to create by STRDBG UPDPROD(*YES), STRSQL, paste in the query, exit STRSQL, ENDDBG and look at the job log.
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
