Auditing cmdtext 
Author Message
 Auditing cmdtext

We have a 3rd party java program using JDBC to access an ASE (11.9/12.0)
server. I wanted to take a look at the queries that were generated
(because of poor performace), so I enabled cmdtext auditing for the
user executing the queries.

When I take a look at the cmdtext, I get queries like :






Does anyone know where these parameters come from and why there
declaration isn't seen in the sysaudits_0x tables ?

Thanks,
Luc.



Mon, 21 Apr 2003 21:26:26 GMT
 Auditing cmdtext


Quote:
> We have a 3rd party java program using JDBC to access an ASE
(11.9/12.0)
> server. I wanted to take a look at the queries that were generated
> (because of poor performace), so I enabled cmdtext auditing for the
> user executing the queries.

> When I take a look at the cmdtext, I get queries like :


TOKEN


AND



> Does anyone know where these parameters come from and why there
> declaration isn't seen in the sysaudits_0x tables ?

You sometimes see queries like this generated by applications using
embedded SQL and "special" things like; these queries don't work

aren't really variables, but parameters of the "temporary stored
procedure" (a.k.a. as light-weight procedure) which is created around
these queries. You don't see this happen, and you cannot do this
manually yourself either. I believe a kind o client cursor is used by
the client application to retrieve the result set at the client side.

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11


WWW  http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------



Tue, 22 Apr 2003 05:51:26 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. cmdtext Auditing

2. Exclude sp_password from cmdtext

3. Audit Login - Audit Logout problem

4. Profiler: Audit Logout, Audit Login

5. Generic auditing auditing code

6. Auditing: Monitoring the audit queue

7. Audit-trails, audit-server

8. audit.1 & audit.2 Full Error

9. audit.1 audit.2 files

10. How to "audit" without auditing ?

11. auditing database

12. SQL Password Auditing Tool


 
Powered by phpBB® Forum Software