Hi James,


> Please can you suggest a method of keeping the SQL executed from an ABF
> application into some kind of log file.
> The method I am aware of involves setting II_EMBED_SET to printqry, =
> though=20 this only gives out the start and end times of the query, can 
> the disk i/o, etc from tracepoint qe90 be written to a log file too?
> 
> Many Thanks
> James Lister

	[ I'm using C-Shell syntax here ]

	As you said, you can use 	
		setenv II_EMBED_SET "printqry" 

	to write to the screen or use 	
		setenv II_EMBED_SET "printqry; qryfile /home/usr/yuan/xxx"

	to write to a file xxx (include the full path!) or whatever.

	However, II_EMBED_SET doesn't seem to handle trace points or qeps
	to a file (let me know if I'm wrong here!). So you can use ING_SET
	(which is interactive), but you need to log the output. eg:

		script
		setenv ING_SET "set printqry; set qep; set trace point qe90"
		run_application_here
		unsetenv ING_SET
		^D 		(control-D to get out of script)
		vi typescript	(resultant script file)

	This file can take a while to generate because you have to sift through 
	the messages, but it works.

-- 
Regards,
	William

Ingres Q & A

Back to William's Home Page

© William Yuan 2000

Email William