Single user mode question.

[Serguei]

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.

[ThanksButNo]

    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?

\:-\

[Serguei]

Post by ThanksButNo

    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.

[David Kerber]

In article <7f89b464-b94a-4784-b71a-
***@v38g2000vbb.googlegroups.com>, ***@cibc.ca
says...

...

Post by Serguei
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.