Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Stop ASA 8 on Netware 6

Posted on 2003-03-04
6
Medium Priority
?
496 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
  • 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Ready to kick start your career in 2018? Add app developer skills to your resume. January’s Course of the Month features Android App Development training with hands-on learning.  Read on to learn why these skills are important.
Why WooCommerce is one of the majorly favored choices when it comes to having an eCommerce store. This article will acquaint you with some reasons that I believe make it one of the best eCommerce platforms available.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

571 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