This Question is Answered

4 "helpful" answers available (2 pts)
Up to Discussions in OpenEdge
3 Replies Last post: Feb 9, 2010 11:05 AM by Kevin Saunders  
adamk84 Newbie
adamk84
6 posts since
Feb 5, 2010
Currently Being Moderated

Feb 8, 2010 5:09 PM

-zqil & -zqilv Usage Question

Hi,

 

I was wondering where I would need to set these flags in order to use -zqil or -zqilv for some index usage tracing?

 

I recall from a previous post that it must be done on the clientside, but am unsure where I need to set this as I am unfamiliar with how to configure the clientside.

 

Using OpenEdge 10.2A

 

Thanks in advance

 

Adam

Tags: openedge_10.2a
Kevin Saunders Novice
Kevin Saunders
207 posts since
Sep 11, 2007
Currently Being Moderated
Feb 9, 2010 4:26 AM in response to: adamk84
Re: -zqil & -zqilv Usage Question

If your client is windows, you can add them to the parameter file (.pf) referenced in the widows shortcut, or you can just add them to the end of the command after any other parameters.

 

e.g.: C:\Progress\OpenEdge\bin\prowin32.exe -pf myparam.pf -zqilv

 

If the client is *nix, just add them to the .pf or the script that kicks off the client session.

adamk84 Newbie
adamk84
6 posts since
Feb 5, 2010
Currently Being Moderated
Feb 9, 2010 10:29 AM in response to: Kevin Saunders
Re: -zqil & -zqilv Usage Question

Thanks Kevin,

 

One other question related to the output of -zqil.

 

When I look into the db log im trying to decipher what the difference between Compiled Query Resolution Method and Server Query execution Method, see example below:

 

I ABL    16: (6135)   ==Compiled Query Resolution Method: Query No. 251==
| ABL    16: (6157)  INDEX 47 0 0
I ABL    16: (6136)   ==Server Query execution Method Query No. 251==
I ABL    16: (6141)  INDEX 47

 

Based on the above is the Compiled Query just what Progress figures the index will be? and the Server Query the actual one that gets run? also should I see values next to the index in the server query?

 

Thanks

Adam

Kevin Saunders Novice
Kevin Saunders
207 posts since
Sep 11, 2007
Currently Being Moderated
Feb 9, 2010 11:05 AM in response to: adamk84
Re: -zqil & -zqilv Usage Question

I believe that is the case.

 

The values after the index number determine how many components matched the low end how many matched the high end.

 

There is a good explanation of the output in the KB No. 21216

 

Alternatively, being as you are using a modern version of Progress, you can use the client logging option on the client, with the log entry types (-logentrytypes parameter) and QryInfo.. Have a look in the Debugging and Troubleshooting doc here (chapter 6 specifically) for a more thorough explanation.

More Like This

  • Retrieving data ...