Skip to Content

ASE 15.5 can we get bigdatetime in system table sysaudits_xx

Greetings all

In ASE 15.5 : is there a way to convert the datetime column "eventtime" into bigdatetime in sysaudits_xx tables ?

bigdatetime data type was introduced in ASE 15.5. It needs the same 8-byte storage as a datetime data type.

System tables with datetime column are mostly using the normal date time with 1 to 3 ms accuracy.

I am doing login/logout connection monitoring with SAP/Sybase auditing.

And it will help to know connections pressure as precisely as possible.

Avinash


As note/feedback for SAP/Sybase documentation/manuals

In the reference manual for system tables, systypes still does NOT show bigdatetime

SAP Adaptive Server Enterprise 16.0 > Reference Manual: Tables 16.0 > System Tables

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 16, 2015 at 06:09 PM

    Thanks Jeroen and Bret for your respective inputs.

    I will close this thread as answered though I do not see a near term solution.

    Thanks again

    Avinash

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 16, 2015 at 07:48 AM

    Changing system tables is not a good idea, that's asking for trouble.

    If 3ms accuracy is not good enough because of the amount of logins, then I guess auditing will be pretty overloaded and a huge bottleneck for just logging the login/logout activity

    And just changing the datatype in the audit tables is probably not sufficient anyway, because the auditing system is most likely inserting the eventtime as datetime. The insert will go fine, but you just get an implicit converted value from datetime to bigdatetime

    Add a comment
    10|10000 characters needed characters exceeded

    • This would only be possible in a future version.


      In general we are reluctant to make such changes without a strong need for it as it breaks backward-compatibility (i.e. existing applications that expect the column to be a datetime may break if the column is changed to be a bigdatetime). So this sort of change is only likely to be made as part of a major version upgrade.

      -bret

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.