Welcome to the Oracle community forum, and interact with 2 million technical staff. To install a software today, you need to use the Mysql database, create a database in it, and users, I followed the script to execute the database creation script.
After several days, I have completed HADR. Next, let's share it with you.
System Environment:
OS: SUSE 11sp1-64bit
DB: db29.7.0.5
DB2server1: 192.168.5.151 db2inst1
DB2server2: 192.168.5.152 db2inst2
Steps:
Operations on DB2server1:
Db2inst1 @
Master/Slave Parameters:Modified Date:ntpdate asia.pool.ntp.orgMaster/Slave Configuration communication port:Db2h_erpinst1 70000/tcpMain Library configuration:DB2 Update DB CFG for erpdb using Hadr_local_host PrimaryNode-1#本地服务器主机DB2 Update DB CFG
Install the DB2 database in CentOS
System: CentOS 6.4x64
Database: DB2-V10.1
Prepare the environment
Vi/etc/hosts # It is best to change the hosts host name to be the same as the computer name.
Reboot
Yum install libaio-devel
Create accounts and
CentOS 6.4 x64 DB2 Database InstallationSystem: CentOS 6.4 x64Database: db2-v10.1Preparation Environment stepsVi/etc/hosts # modifying the hosts host name is best if it is the same as the computer name. RebootYum Install Libaio Libaio-develfor the
The following articles mainly describe the correct steps for DB2 backup and cross-platform migration. If you are curious about the correct steps for DB2 backup and cross-platform migration, the following articles will unveil its secrets. The
Common parameter modification:DB2 "Update db CFG for BMC using BUFFPAGE 51200"DB2 ' alter Bufferpool IBMDEFAULTBP size 51200 'DB2 "Update db CFG for BMC using LOGSECOND 200"DB2 "Update db CFG for BMC using SORTHEAP 1024"DB2 "Update db CFG for BMC
This article summarizes the common operation commands of DB2 and shares them with you. For friends who use DB2, refer to the following.The DB2 database management client is no longer with the control center since the v9.7 version, but instead uses
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
1. Open the command line window
# Db2cmd
2. Open the Control Center
# Db2cmd db2cc
3. Open the command editor.
Db2cmd db2ce
===== Operation database commands ====
4. Start a database instance# Db2start
5. Stop a database instance# Db2stop
If
Go from DB2 script House: http://www.jb51.net/article/20497.html1. Open the Command Line window#db2cmd2. Open the control center# Db2cmd DB2CC3. Open the Command editorDb2cmd Db2ce===== Operation Database Command =====4. Start the DB
Recently has been doing database optimization this business, found themselves a lot of DB2 commands are forgotten, and even useless, and sometimes become a bottleneck in the efficiency of the work, 工欲善其事, its prerequisite, so did the following
Database migration can be seen as a special software development project. Different from other development projects, the requirements of this project are fixed, and the technical barriers are low. The main task is coding and testing. For database
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
Http://www.jb51.net/list/list_155_1.htm
1. Open the command-line window #db2cmd2. Open the control center# Db2cmd DB2CC3. Open the Command editorDb2cmd Db2ce===== Operation Database Command ===== 4. Start the DB instance#db2start 5. Stop the DB
1. Open the Command Line window#db2cmd2. Open the control center# Db2cmd DB2CC3. Open the Command editorDb2cmd Db2ce===== Operation Database Command =====4. Start the DB instance#db2start5. Stop the DB instance#db2stopIf you cannot stop the database
1. Open the Command Line window#db2cmd2. Open the control center# Db2cmd DB2CC3. Open the Command editorDb2cmd Db2ce===== Operation Database Command =====4. Start the DB instance#db2start5. Stop the DB instance#db2stopIf you cannot stop the database
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.