Discussion:
Query tool
(too old to reply)
erich
2004-06-10 11:17:56 UTC
Permalink
Hi
Does anybody know of a tool or method that I can extract the file/s
being used in a query without going into the query. The problem is we
are making structural changes to our database and have thousand of
queries on the system which we do not want to go into individually.
Thanx in advance
erich
2004-06-10 11:42:26 UTC
Permalink
Post by erich
Hi
Does anybody know of a tool or method that I can extract the file/s
being used in a query without going into the query. The problem is we
are making structural changes to our database and have thousand of
queries on the system which we do not want to go into individually.
Thanx in advance
erich
You can use RTVQMQRY & specify ALWQRYDFN(*YES) to get the appropriate SQL
into a member - one for each query. Then all you have to do is parse this
SQL to extract the filenames involved :-)
--
Jonathan Bailey.
gb
2004-06-10 12:02:30 UTC
Permalink
There is a utility caller RTVQRYF which extracts the input (& output files)
used by a query. You can use it to extract all the files used by all the
queries on your system and then process the output to find the queries to
redefine (I know, I have written such a utility - but I don't have access to
it at the moment...).

It can be found at
http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=view
article&CO_ContentID=9925&channel=art&PageView=Search

You will however need to be a subscriber to news3x/400 (or whatever its
called these days) to get to the article and the code ($29 per annum)...
Sorry, can't help you there...

GB
Post by erich
Hi
Does anybody know of a tool or method that I can extract the file/s
being used in a query without going into the query. The problem is we
are making structural changes to our database and have thousand of
queries on the system which we do not want to go into individually.
Thanx in advance
erich
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07/06/2004
gb
2004-06-10 12:03:55 UTC
Permalink
Oops, you will have to cut & paste the two bits of the link together to get
it working...
http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=view
article&CO_ContentID=9925&channel=art&PageView=Search

GB
Post by gb
There is a utility caller RTVQRYF which extracts the input (& output files)
used by a query. You can use it to extract all the files used by all the
queries on your system and then process the output to find the queries to
redefine (I know, I have written such a utility - but I don't have access to
it at the moment...).
It can be found at
http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=view
Post by gb
article&CO_ContentID=9925&channel=art&PageView=Search
You will however need to be a subscriber to news3x/400 (or whatever its
called these days) to get to the article and the code ($29 per annum)...
Sorry, can't help you there...
GB
Post by erich
Hi
Does anybody know of a tool or method that I can extract the file/s
being used in a query without going into the query. The problem is we
are making structural changes to our database and have thousand of
queries on the system which we do not want to go into individually.
Thanx in advance
erich
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07/06/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07/06/2004
Andi Goering
2004-06-11 10:21:35 UTC
Permalink
Erich,

you may have a look to our (commercial) tool QueryOptimizer
at http://www.goering.de

Best Regards

Andreas Goering
GOERING iSeries Solutions
Post by erich
Hi
Does anybody know of a tool or method that I can extract the file/s
being used in a query without going into the query. The problem is we
are making structural changes to our database and have thousand of
queries on the system which we do not want to go into individually.
Thanx in advance
erich
PAUL RAULERSON
2004-06-11 11:50:58 UTC
Permalink
I'm not sure exactly what you mean by 'without going into the query', but it
sort of sounds like you want
to run EXPLAINs on the queries. Indeed, you should be doing that *anyway*,
regardless of how well
tuned the iSeries machines are for database use. ;)

Here is a basic link to an IBM page that talks about Visual Explains and so
forth.

http://eservercomputing.com/iseries/articles/index.asp?id=300

-Paul
Post by Andi Goering
Erich,
you may have a look to our (commercial) tool QueryOptimizer
at http://www.goering.de
Best Regards
Andreas Goering
GOERING iSeries Solutions
Post by erich
Hi
Does anybody know of a tool or method that I can extract the file/s
being used in a query without going into the query. The problem is we
are making structural changes to our database and have thousand of
queries on the system which we do not want to go into individually.
Thanx in advance
erich
Loading...