Skip to Content
avatar image
Former Member

sybase iq 16 audit DML statements

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 27, 2015 at 06:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded