Question on trace parameters

View: New views
4 Messages — Rating Filter:   Alert me  

Question on trace parameters

by tsteinmaurer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

in what scenarios should the following parameters produce log data?

log_blr_requests true
print_blr true
log_dyn_requests true
print_dyn true


Thanks,
Thomas

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: Question on trace parameters

by Vlad Khorsun-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> in what scenarios should the following parameters produce log data?
>
> log_blr_requests true
> print_blr true
> log_dyn_requests true
> print_dyn true

    When some ESQL application will work with database. Try to trace
gsec, for example.

Regards,
Vlad

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: Question on trace parameters

by tsteinmaurer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>> in what scenarios should the following parameters produce log data?
>>
>> log_blr_requests true
>> print_blr true
>> log_dyn_requests true
>> print_dyn true
>
>     When some ESQL application will work with database. Try to trace
> gsec, for example.

Ah, ok! But the BLR stuff above does not have anything to do with e.g.
compiling a SP, trigger, running EXECUTE BLOCK, ...?


Thanks again.

Thomas

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: Question on trace parameters

by Vlad Khorsun-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>>> in what scenarios should the following parameters produce log data?
>>>
>>> log_blr_requests true
>>> print_blr true
>>> log_dyn_requests true
>>> print_dyn true
>>
>>     When some ESQL application will work with database. Try to trace
>> gsec, for example.
>
> Ah, ok! But the BLR stuff above does not have anything to do with e.g.
> compiling a SP, trigger, running EXECUTE BLOCK, ...?

    BLR and DYN is traced only when application used corresponding API.
I.e. used of isc_compile, isc_start_request, isc_start_and_send and isc_ddl
API calls.

    Internal engine's requests are not traced. So you can't trace SP\trigger
compilation. EXECUTE BLOCK execution is usual DSQL call so it will be
traced as any other SQL statement.

Regards,
Vlad

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel