Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    19

    Unhappy Unanswered: how can i find Sybase ASE non logged operations

    Hi,

    Every 2 hours I create a transaction logdump of our production database. If some user does a non-logged operation my dump transaction fails. My program will then launch a dump database.

    However,
    Is there a way (..probably not) to find out who's doing non logged operations on my database ?

    Can I audit for this ? Is there a magical dbcc command (dbcc show_unlogged) to find this.

    I cannot de-activate 'select into/bulkcopy' because slow bcp's are needed.

    best regards,
    Toon Eysakkers
    Last edited by babambites; 01-25-04 at 06:14.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    I don't think there are any/many non-logged operations. Some minimally logged, yes.

    One of these is SELECT INTO, so spank people if they run that.
    Thanks,

    Matt

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    I'm pretty sure it is dbcc dbinfo. I don't know the internals, what each of them mean. Perhaps check with Sybase Support or Checkout Rob Verschoor's ASE Ref Manual
    http://www.sypron.nl/qr/

  4. #4
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    19

    Wink

    Hi,

    I have found how to see if you can do a dump transaction
    More info by Sybase

    http://info.sybase.com/resolution/de...umber=10876829


    Resolution:
    Use this select statement to test whether you can dump the log.


    declare @x int, @y int
    select @x = 4 & convert (binary(4),substring(keys1,127,4))
    from sysindexes where id = 8
    select @y = 8 & convert (binary(4),substring(keys1,127,4))
    from sysindexes where id = 8
    if (@x = 4) or (@y = 8) print "cannot dump logs" else print "log dump permitted"
    go


    However I would still like to know who messed up my database. I can't use auditing because I will loose to much performance

    If you know something let me know,
    best regards,
    Toon Eysakkers

  5. #5
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97

    Re: how can i find Sybase ASE non logged operations

    Originally posted by babambites
    However,
    Is there a way (..probably not) to find out who's doing non logged operations on my database ?

    Can I audit for this ? Is there a magical dbcc command (dbcc show_unlogged) to find this.

    I cannot de-activate 'select into/bulkcopy' because slow bcp's are needed.

    best regards,
    Toon Eysakkers
    You can unset 'select into/bulkcopy' if every bcp
    being run is slow. And, if one is fast, then it is
    the culprint, as fast bcp is a minimally logged
    operation which prevents further dump trans
    to file. Only fast bcp is prevented by unsetting
    'select into/bulkcopy'.

    My suggestion is to unset 'select into/bulkcopy'
    and open every "channel" you have with
    users until you hear about one getting an error
    due to 'select into/bulkcopy' (4806, 11919,
    maybe others).

    Regards,
    Mariano Corral

  6. #6
    Join Date
    Nov 2003
    Posts
    10

    Re: how can i find Sybase ASE non logged operations

    Hi,

    I too have similar problem.

    dump tran sometimes fails with message indicating that a non logged operation is performed.

    However, unlike your case, select into/bulk copy is diabled for this database.

    But still it indicates that non logged operation is done ?

    Can anyone tell me what else could be the non logged operation that could have been done without select into/buk copy option enabled ?
    Is there anyway for me to audit or check who/what has been done in this database ?

    Thanks,
    Ravi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •