Hi,

I am new to Sybase world.

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



Regards
Riyaz

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.

You can find the up time of dataserver using select @@boottime

Or

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

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

Michael

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

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

ps -ef |grep "[R]UN"

hi
u can find the server name by executing following commands
on OS prompt
echo $DSQUERY
on isql prompt
select @@servername