1, open the Command line window
#db2cmd
2, open the control center
# Db2cmd DB2CC
3. Open Command Editor
Db2cmd Db2ce
===== Operations Database Command =====
4, start the database instance
#db2start
5. Stop database instance
#db2stop
If you can't
This article is a detailed summary of DB2 Common operation commands, to share with you. For the use of DB2 friends can refer to the following.
The DB2 database management client does not have a control center since the v9.7 version, but instead
The command-line processor is the DB2 interface, which best embodies the power of DB2, as well as the simplicity and versatility of DB2. The author makes a detailed exposition of it through examples.0 Reviews:Blair Adamache, DB2 technology
Brief introduction
UNIX and Linux users typically check the processes running on their servers to perform problem analysis and to check the resources consumed in the server. This information is useful not only for administrators who perform issues
I feel that the answers to many basic questions can be obtained through the help of DB2, because DB2 itself has very detailed help information after installation, so I think it is necessary to summarize how to get help from the DB2 command syntax!
DB2 supports the following two types of tablespaces:1. System Management Memory table space (Sms-system MANAGED STORAGE)2. Database Management Memory table space (Dms-database MANAGED STORAGE)Comparison of characteristics of SMS and DMS user table
[Posting] DB2 partition features
Data Warehouse scenario overviewLevel: Intermediate
Paul McInerney (paulmci@ca.ibm.com), user-centric design expert, DB2 development, IBM
September 18, 2006
This article introduces the following table design features
Introduction
PHP supports a simple WEB application development and deployment environment. This is one of the reasons why it has been widely used. The native XML functionality of DB2 9 further simplifies the development process. This simplification
TurnRecently in see DB2, read while writing some, write down, although write a mess. For later use.These are all very simple to write. I think it is some simple operation, and some are excerpted from other people's blog specific is to cite which is
Introduction PHP supports Simple Web application development and deployment environments. This is one of the reasons for its widespread application. The Native XML feature of DB2 9 further simplifies the development process. This simplification is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.