?
Solved

Stop ASA 8 on Netware 6

Posted on 2003-03-04
6
Medium Priority
?
495 Views
Last Modified: 2012-06-21
I want to use "unload dbsrv8" in a script but, if there is a connected user, it will prompt me for Y or N.
I want something like STOP ENGINE UNCONDITIONALLY in sql.
0
Comment
Question by:magotici
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 4

Expert Comment

by:gletiecq
ID: 8073733
Use dbstop -y and supply the appropriate connection parameters.  If you need to see what the command parameters are for this, run "dbstop -?" in windows, or "dbstop --help" in linux/unix.

Hope this helps.

Greg
0
 

Author Comment

by:magotici
ID: 8073795
How to run dbstop on a Netware 6 server?
0
 
LVL 4

Expert Comment

by:gletiecq
ID: 8073969
You run dbstop from any machine on the network.  As long as you use the DBA login, you can shut down the database.  

If you have a SQL session open, you can issue the following SQL command if you have DBA authority:

STOP ENGINE server_name UNCONDITIONALLY

You can also shut down a particular database with STOP DATABASE database_name ON server_name UNCONDITIONALLY.

Does this help?

Greg
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

Author Comment

by:magotici
ID: 8074047
My db server engine runs on a Netware 6 cluster solution. Some times I have to move the db engine from a resource to another but, for that I have to write a Novell script to unload the db engine. I used "unload dbsrv8" but if there are users connected to the database it will ask you for a decision: continue or not. That means somebody has to be there to press y or n. All of these are happening on Novell's console, so I can't run dbstop or other exe. I'd like to do that automatically on the Novell server.
0
 
LVL 4

Accepted Solution

by:
gletiecq earned 160 total points
ID: 8074168
Well, the behavior for an ASA8 engine is to issue a warning if you try to bring it down via the OS while users are connected.  There really isn't any way around that.

The intent here is to have administrators use the tools provided in the distribution to manage the databases, since you have a lot more control over what's going on that way.  Now those tools can be pretty powerful and do what you want, although they may not integrate too seamlessly into the NetWare console.

If you can manage this from another console, you can use DBSTOP, you can run an ISQL session that will bring the server down on one machine and you can bring up a server on another machine.  In order to ensure consistency, you really may want to do that.

I'd create a batch file (or a SQL file, either way works) that would run a backup on the server to be brought down and copy that backup file to the other server that is to be brought up.  Alternatively, just bring down server 1, copy all .db and log files to server 2, and bring server 2 up.  That way, if users try to connect to the database without specifying the server, they'll connect to either server1 or server 2, whichever happens to be the one running, and the data is ensured to be consistent between the two.

Sorry there isn't a configuration switch that is the equivalent of "Don't complain if the OS tries to shut me down and I still have users connected".

Greg
0
 

Expert Comment

by:SpideyMod
ID: 8116649
A request has been made to lower the points to 40 from 85 so that points can be awarded to GLETIECQ for effort.  I have lowered the points.

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a fine trick which I've found useful many times, when you just don't want to accidentally run a batch script or the commands needs administrator rights.
We are witnesses that everyone is saying that our children shouldn't "play" with a technology because it is dangerous. This article is going to prove that they are wrong.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question