RE: [Info-ingres] Where to look for more debugging info (Embedded SQL Fortran)?

Hi Jim,

You do not need any privileges for printqry tracing as I described. What
errors did you get?

--
Peter
T: +44 (0)1398 341777
PGale@xxxxxxxxxxxxxxx


-----Original Message-----
From: info-ingres-admin@xxxxxxxxxxxxxxx
[mailto:info-ingres-admin@xxxxxxxxxxxxxxx] On Behalf Of J. F. Cornwall
Sent: 18 May 2006 20:12
To: info-ingres@xxxxxxxxxxxxxxx
Subject: Re: [Info-ingres] Where to look for more debugging info (Embedded
SQL Fortran)?

Peter Gale wrote:

Hi Jim,

From what you are saying it would seem that a rule is firing on the last
DELETE which raises and error and causes the rollback.
You can trace rule and procedure execution using 'set printrules' thus
(assuming korn shell)

export ING_SET='set printqry;set printrules'
export II_EMBED_SET='printtrace;tracefile trace.txt'

then run the program.

The qry trace and rule firings will be in the trace.txt file which will
hopefully allow you to see which rule is causing the problem.

The SQL reference manual explains all the options for tracing with the SET
sql statement. The System Reference Manual explains the use of environment
variables for tracing. Hopefully you have the 2.6 editions but if not you
can download the 2006 documents from
www.ingres.com/products/Prod_Download_Documents.html

Thanks much. I tried the printtrace, but it seems I don't have the
necessary privileges for it. However, talking to our database designer
we thought perhaps there was some agressive optimzing of the query
string being done "under the hood", so I added a COMMIT after each
operation to prevent the UPDATEs froim being optimaized out of
existence. It seems to work now, so our Ops folks are going to build
and install a new production version for further testing.

Thanks again,

Jim



Hope that helps.

--
Peter Gale
Managing Director
Comprehensive Solutions International

T: +44 (0)1398 341777 M: +44 (0)7831 513181
PGale@xxxxxxxxxxxxxxx www.Comp-Soln.co.uk

"Business Savvy. IT Smart" R

_______________________________________________
Info-ingres mailing list
Info-ingres@xxxxxxxxxxxxxxx
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres

.

Relevant Pages

  • Re: What are ORA$AT_OS_OPT_SY_665 like 11g jobs?
    ... There was also a bug long ago where system wide tracing of some sort ... if you are tracing something that has severe performance ... "Although it is possible to enable the SQL ... Trace facility for a session or for an instance, ...
    (comp.databases.oracle.server)
  • Re: What are ORA$AT_OS_OPT_SY_665 like 11g jobs?
    ... It is a production environment and it's ... There was also a bug long ago where system wide tracing of some sort ... Trace facility for a session or for an instance, ... the SQL Trace facility is enabled for a session or for an instance, ...
    (comp.databases.oracle.server)
  • Design question
    ... I am working on a large ASP.NET project that contains about 100 SQL ... Now the customer has asked for some type of data base tracing functionality ... the service provider objects that they need to enable tracing. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Capturing Query Text of Prepared Statements in Profiler
    ... You can enable JDBC tracing on the driver side. ... This will contain the SQL ...
    (microsoft.public.sqlserver.jdbcdriver)