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 @
Brief introductionWhen it comes to ensuring that enterprise applications built with IBM DB2 (DB2 certified DB2 Training) ®universal Database "(DB2 UDB) and borland® tools (such as Delphi, C++builder, or Kylix) have the best performance, programmers
Common DB2 commands
Common DB2 commandsI. Basics1. db2 connect to -- connect to the local database nameDb2 connect to user using -- connect to the remote database2. db2 force application all -- force all applications to disconnect the database3.
DB2 Common CommandsFirst, the basic article1. DB2 Connect to --Connect to local database nameDB2 Connect to user Using --connect to the remote database2. DB2 force application All--forcing all applications to disconnect from the database3. DB2
[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
with definition and usage-------Part of the content is reproduced and processed by finishing---------------------1.with Understanding and basic usage the WITH statement, in addition to those who first heard of the WITH statement, most people think
The difference between DB2 and Oracle
1, DB2 access to the first 10 lines of data and Oracle Difference
DB2:
SELECT * FROM Test fetch a
Oracle:
SELECT * FROM Test where rownumQuery statement
DB2: Do not provide stealth conversion
SELECT * from
The db2 tutorial is: Daily maintenance Summary of IBM DB2 (6 ). 91. How to Create a summary table of DB2?
The overview table function of DB2 is similar to the materialized view of ORACLE!
Syntax:
CREATESUMMARYTABLETABLE_NAMEAS (FULLSELECT )...
For
The db2 tutorial is: Daily maintenance Summary of IBM DB2 (6 ). 91. How to Create a summary table of DB2?The overview table function of DB2 is similar to the materialized view of ORACLE!Syntax:CREATESUMMARYTABLETABLE_NAMEAS (FULLSELECT )...For
# Directly Delete the table if [quot; $ DEL_VALUEquot; quot;-quot;] thendelete_tab_data 'db2-txq
# Directly Delete the table if [quot; $ DEL_VALUEquot; = quot;-quot;] then delete_tab_data = 'db2-tx q
Because the data in many large tables 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.