cancel
Showing results for 
Search instead for 
Did you mean: 

sybase iq 16 audit DML statements

Former Member
0 Kudos

Hi everybody, i'm troubleshooting a problem where we cant't make our concurrent operations work even when we have enabled the "blocking" option and the "RLV" for some tables as you can see my post:

We already created a ticket to sap and they said the fix is only available for linux(and we are in windows), so we need to find another solution. I want to test what statements are having conflict , my iqmsg file says the transaction numbers in conflict, but i want to see what statements where executed by that transactions(i mean, we need to audit what statements where run by what transactions). Is there any way to do this? like setting high verbosity in my .iqmsg file or something like that?.

Thank you so much!

Accepted Solutions (0)

Answers (1)

Answers (1)

Gisung
Advisor
Advisor
0 Kudos

Hi,

You can find the sqls that you executed using "-zr" switch in cfg file.

The following information are logged in srvlog file if you specify the -zr switch.

Allowed values

  • SQL – enables logging of the following:
    • START DATABASE statements
    • STOP DATABASE statements
    • STOP SERVER statements
    • Statement preparation and execution
    • EXECUTE IMMEDIATE statement
    • Option settings
    • COMMIT statements
    • ROLLBACK statements
    • PREPARE TO COMMIT operations
    • Connects and disconnects
    • Beginnings of transactions
    • DROP STATEMENT statements
    • Cursor explanations
    • Cursor open, close, and resume
    • Errors

[ex] xxx.cfg

...

-zr SQL

...

Here is an associated reference.

-zr iqsrv16 database server option

SyBooks Online

==

Gi-Sung Jang