- IBM DB2 9.7 Advanced Administration Cookbook
- Adrian Neagu Robert Pelletier
- 449字
- 2021-08-20 15:33:19
Starting and stopping instances
There are several situations in which an instance must be stopped and started, for example, after you change some parameters that are not dynamic, or after applying a fixpack.
Getting ready
We have, at disposal, a couple of different ways to start or stop an instance. We can use, say, db2start for starting and db2stop for stopping; these commands are available for execution in the command line or from DB2 CLI. We can also start or stop an instance from the Control Center. In Windows, you can also start and stop an instance by starting and stopping the service associated with it.
How to do it...
- The current instance is set by the environment variable
DB2INSTANCEor the global registry variableDB2INSTDEF, in caseDB2INSTANCEis not set. This is applicable mostly for Microsoft Windows platforms where there could be more than one instance per user.- On Microsoft Windows:
C:\Documents and Settings>db2ilist DB2_02 DB2WIN C:\Documents and Settings>set DB2INSTANCE DB2INSTANCE=DB2_02
- Now, if we issue
db2stopordb2start, only instanceDB2_02will be affected.- On our Linux server
nodedb21:[db2inst1@nodedb21 ~]$ echo $DB2INSTANCE db2inst1
- On our Linux server
- On Microsoft Windows:
- As the
db2inst1instance owner, stop instancedb2inst1with thedb2stopcommand, and start it withdb2start:[db2inst1@nodedb21 ~]$ db2stop 06/09/2011 17:55:21 0 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. [db2inst1@nodedb21 ~]$ db2start 06/09/2011 17:55:29 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. - As the multipartitioned instance owner
db2instp, stop instancedb2instpwith thedb2stopcommand, and start it withdb2start:[db2instp@nodedb21 sqllib]$ db2stop 06/09/2011 19:03:47 1 0 SQL1064N DB2STOP processing was successful. 06/09/2011 19:03:48 0 0 SQL1064N DB2STOP processing was successful. 06/09/2011 19:03:49 2 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. [db2instp@nodedb21 sqllib]$ db2start 06/09/2011 19:04:02 1 0 SQL1063N DB2START processing was successful. 06/09/2011 19:04:06 2 0 SQL1063N DB2START processing was successful. 06/09/2011 19:04:06 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. - Using the Control Center, right-click on
db2inst1and issue stop and start.
How it works...
In the process of starting an instance, memory structures are allocated and the instance starts listening for connections on the ports assigned by the SVCENAME database manager configuration parameter. At stop, existing connections are disconnected and memory is deallocated.
There's more...
Other options that can be used to start and stop an instance are the DB2 CLI commands, START DATABASE MANAGER and STOP DATABASE MANAGER. For Windows, we have as alternate option to start or stop the service associated with the instance. To set the instance for automatic start on Linux or Unix, at system boot, you can use the instance-level registry variable DB2AUTOSTART=YES or the db2iauto on <instance name> command.
- 觸·心：DT時(shí)代的大數(shù)據(jù)精準(zhǔn)營(yíng)銷(xiāo)
- Windows Server 2012 Unified Remote Access Planning and Deployment
- Functional Kotlin
- 精通Python設(shè)計(jì)模式（第2版）
- SharePoint Development with the SharePoint Framework
- Building Serverless Applications with Python
- OpenStack Orchestration
- Python忍者秘籍
- Instant PHP Web Scraping
- SQL Server 2008 R2數(shù)據(jù)庫(kù)技術(shù)及應(yīng)用（第3版）
- Instant Zurb Foundation 4
- AI自動(dòng)化測(cè)試：技術(shù)原理、平臺(tái)搭建與工程實(shí)踐
- Yii2 By Example
- Clojure編程樂(lè)趣
- Koa與Node.js開(kāi)發(fā)實(shí)戰(zhàn)