- IBM DB2 9.7 Advanced Administration Cookbook
- Adrian Neagu Robert Pelletier
- 304字
- 2021-08-20 15:33:20
Dropping instances
There could be situations when it is necessary to drop an instance. An instance might be dropped by using the db2idrop command.
Getting ready
In this recipe, we will drop the instance db2inst2, created previously.
How to do it...
- The command for dropping an instance is
db2idrop. You have to be userrootto drop an instance. First, we need to ensure that the instance is not active. If the instance has active connections and it is active, thedb2idropcommand fails. - Stop the instance by force:
[db2inst2@nodedb21 ~]$ db2stop force 07/12/2011 16:38:27 0 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. [db2inst2@nodedb21 ~]$ - As the user
root, issue the following command to dropdb2inst2:
[root@nodedb21 ~]# /opt/ibm/db2/V9.7/instance/db2idrop db2inst2 DBI1070I Program db2idrop completed successfully.
How it works...
On Linux and Unix, db2idrop actually deletes the sqllib directory from the instance owner home. Therefore, it is recommended to save anything you have placed in this directory such as UDFs or external programs.
On Windows, db2idrop removes the service associated with the instance.
There's more…
As a best practice, before the instance is dropped, it is recommended to save the information related to that instance in a server profile file. In case you plan to recreate the instance and configure it as before, you can simply import the server profile after the instance is created again.
To export the instance profile, use Control Center | Tools | Configuration assistant | Export profile | Customize.
In the Export tab, you have plenty of options to export; choose anything you consider worth being saved.
- Java異步編程實(shí)戰(zhàn)
- C/C++算法從菜鳥(niǎo)到達(dá)人
- BeagleBone Media Center
- Mastering Web Application Development with AngularJS
- Java程序設(shè)計(jì)與項(xiàng)目案例教程
- Android Game Programming by Example
- ASP.NET開(kāi)發(fā)寶典
- 從零開(kāi)始學(xué)Python大數(shù)據(jù)與量化交易
- Java程序設(shè)計(jì)
- Mastering JavaScript Promises
- Serverless工程實(shí)踐：從入門(mén)到進(jìn)階
- Learning NHibernate 4
- MATLAB計(jì)算機(jī)視覺(jué)實(shí)戰(zhàn)
- MATLAB從入門(mén)到精通
- Natural Language Processing with Java Cookbook