Skip to Content
avatar image
Former Member

log for dabase operations (insert, update)

Hello,

Is there any log in ASE 15.7 where all operations against the user database such as insert,delete update are registred?

I'm looking for something like 'binary-log' in MySql where all operations that modify data in a database are saved in a log.

Does it exist in Sybase?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 10, 2017 at 11:49 AM

    Three things come to mind:

    1) ASE's transaction log, which is stored in the syslogs table in each database (though most of the content is hidden from SELECT). You can examine the content using the largely undocumented DBCC LOG command. In the simplest form:

    use mydatabase
    go
    set switch on 3604
    go
    dbcc log()
    go

    2) There is the monitoring table master..monSysSQLtext. This has to be configured, and consists of a "pipe" of the most recent SQL commands that were run. The size of the pipe is configurable, but the contents only go back so far.

    3) You can configure auditing of "cmdtext" for a more permanent record of SQL commands that were run.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2017 at 12:28 PM

    thank you for your answer

    Add comment
    10|10000 characters needed characters exceeded