var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sybase uptime
I am new to Sybase world.
Can any one tell me, when my sybase dataserver is up?
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.
You can find the up time of dataserver using select @@boottime
Last edited by aziqmail; 04-08-08 at 02:39.
select crdate from master..sysdatabases where name = 'tempdb'
which will return the boot time, as tempdb is recreated at boot.
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
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.
u can find the server name by executing following commands
on OS prompt
on isql prompt