dbTalk Databases Forums  

Single user mode question.

comp.databases.sybase comp.databases.sybase


Discuss Single user mode question. in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Serguei
 
Posts: n/a

Default Single user mode question. - 06-20-2009 , 04:20 PM






Dear Experts,

I inherited a script written long ago and the first line is to check
is the Sybase server in the single user mode or not. I personally
never make this test, but may be I am wrong.

Question: Is it a good practice for the Sybase server to check what
mode is it running?

Regards,
Serguei.

Reply With Quote
  #2  
Old   
ThanksButNo
 
Posts: n/a

Default Re: Single user mode question. - 06-20-2009 , 06:12 PM






On Jun 20, 2:20*pm, Serguei <Serguei.Goumeni... (AT) cibc (DOT) ca> wrote:
Quote:
* * Dear Experts,

I inherited a script written long ago and the first line is to check
is the Sybase server in the single user mode or not. I personally
never make this test, but may be I am wrong.

Question: Is it a good practice for the Sybase server to check what
mode is it running?

Some things an administrator has to do, he has to do without any
risk that some other user might log on and mess things up.

E.g., you might need to re-work the syslogins and sysusers tables
because those have a habit of getting out of sync. You don't
want to do that sort of thing while somebody else is logged in,
and you don't want somebody to log in while you're in the middle
of doing that.

An administrator might want to put some of those kinds of things
into a script to make his life easier. Why wouldn't such a script
check for single-user mode first thing?

\:-\

Reply With Quote
  #3  
Old   
Serguei
 
Posts: n/a

Default Re: Single user mode question. - 06-22-2009 , 07:08 AM



On Jun 20, 7:12*pm, ThanksButNo <no.no.tha... (AT) gmail (DOT) com> wrote:
Quote:
On Jun 20, 2:20*pm, Serguei <Serguei.Goumeni... (AT) cibc (DOT) ca> wrote:

* * Dear Experts,

I inherited a script written long ago and the first line is to check
is the Sybase server in the single user mode or not. I personally
never make this test, but may be I am wrong.

Question: Is it a good practice for the Sybase server to check what
mode is it running?

Some things an administrator has to do, he has to do without any
risk that some other user might log on and mess things up.

E.g., you might need to re-work the syslogins and sysusers tables
because those have a habit of getting out of sync. *You don't
want to do that sort of thing while somebody else is logged in,
and you don't want somebody to log in while you're in the middle
of doing that.

An administrator might want to put some of those kinds of things
into a script to make his life easier. *Why wouldn't such a script
check for single-user mode first thing?

\:-\
Thank you for your reply, but you do not answer my question. I like to
know - is it a good (recommended) practice for a Sybase user to test
which mode the server is running?

Regards,
Serguei.

Reply With Quote
  #4  
Old   
David Kerber
 
Posts: n/a

Default Re: Single user mode question. - 06-22-2009 , 09:50 AM



In article <7f89b464-b94a-4784-b71a-
acaad81087eb (AT) v38g2000vbb (DOT) googlegroups.com>, Serguei.Goumeniouk (AT) cibc (DOT) ca
says...

....

Quote:
Thank you for your reply, but you do not answer my question. I like to
know - is it a good (recommended) practice for a Sybase user to test
which mode the server is running?
Only if it matters to the job at hand. If you need to be an exclusive
user for the script to function, then yes. Otherwise, no.

--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.