Results 1 to 8 of 8

Thread: sybase uptime

  1. #1
    Join Date
    Mar 2008
    Posts
    22

    Unanswered: sybase uptime

    Hi,

    I am new to Sybase world.

    Can any one tell me, when my sybase dataserver is up?



    Regards
    Riyaz

  2. #2
    Join Date
    Feb 2008
    Posts
    27
    Hi sri,

    you can chech this from OS level useing ps -ef | grep dataserver or from install dir showsrever it will show u the time .
    And if ur dataserver is not up ur not able to logon the serever.

  3. #3
    Join Date
    Apr 2008
    Location
    India
    Posts
    3
    You can find the up time of dataserver using select @@boottime
    Last edited by aziqmail; 04-08-08 at 03:39.

  4. #4
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Or

    select crdate from master..sysdatabases where name = 'tempdb'

    which will return the boot time, as tempdb is recreated at boot.

    Michael

  5. #5
    Join Date
    Nov 2007
    Posts
    7

    how t0 check whether sybase is running

    hope you understood how to check on the UNIX/solaris amchines, now...If you are starting on windows then in the 'services.msc' you can see whether the server is UP or not.

    another ways is to check the logfile ofcourse

  6. #6
    Join Date
    Mar 2008
    Posts
    22
    Thanks,

    When I used showserver it shows following to me. It don't show me the dataserver name.How to correct it.

    sybase 3674 3669 0 09:04:14 ? 0:30 /opt/sybase/ASE-12_5/bin/dataserver -ONLINE:1,0,0xffffffffe8841
    sybase 3958 3957 0 09:18:18 ? 0:26 /sybase125/ASE-12_5/bin/dataserver -ONLINE:1,0,0xffffffffe88417

    But when I login with isql with dataserver name it is working for me.

    Thanks
    RIYAZ

  7. #7
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    ps -ef |grep "[R]UN"

  8. #8
    Join Date
    Mar 2008
    Posts
    96
    hi
    u can find the server name by executing following commands
    on OS prompt
    echo $DSQUERY
    on isql prompt
    select @@servername

Posting Permissions

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