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

    Question Unanswered: How to display uptime (not from errorlog)

    Hi,

    Is there a command that I can use when ASE has been started ?
    I know, I can find this information in the errorlog and in 12.5 it is @@boottime (undocumented 12.5)

    What is the command in older versions ?
    Currently I'm testing sybase monitoring software from quest and it displays 'up since' and it doesn't monitor a logfile


    Best regards,

    Toon

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    1> select name, crdate from sysdatabases
    2> where name = "tempdb"
    3> go
    name crdate
    ------------------------------ --------------------------
    tempdb Feb 10 2004 20:02PM

    (1 row affected)

    Reasonably accurate to a few secs after the master recovery.

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

    Smile

    Originally posted by willy_and_the_ci
    1> select name, crdate from sysdatabases
    2> where name = "tempdb"
    3> go
    name crdate
    ------------------------------ --------------------------
    tempdb Feb 10 2004 20:02PM

    (1 row affected)

    Reasonably accurate to a few secs after the master recovery.
    That's true, tempdb is always recreated after a reboot.
    Thank you for time & information

    Best Regards,

    Toon

Posting Permissions

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