Results 1 to 2 of 2

Thread: Auditing

  1. #1
    Join Date
    Feb 2004

    Unanswered: Auditing

    Hello everybody,

    I looked at the documented sybase's procedure for archiving sysaudits_01. The procedure tries to avoid bcp out from this system table and instead it copies the data to another table using select into then bcp out from this new table.

    Now, Is there any problem if I bcp out from sysaudits_01 directly? If this will take place at 1:00 am where there is not a lot of activities what is the problem?

    Thanks a lot

  2. #2
    Join Date
    Nov 2002
    The bcp out will apply a shared lock in the sysaudit_01 table and avoid any exclusive lock => it can theoritically and temporary block the audit process

Posting Permissions

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