Reprinted from: http://blog.csdn.net/sunrise918/article/details/5575054These days on the logical primary key, business primary key and composite primary key have some thinking, also searched the related discussion on the net, related discussion can
In the past few days, I have thought about logical primary keys, business primary keys, and composite primary keys. I also searched for some discussions on the Internet. For more
After several days, I have completed HADR. Next, let's share it with you.
OS: SUSE 11sp1-64bit
DB2server1: 192.168.5.151 db2inst1
DB2server2: 192.168.5.152 db2inst2
Operations on DB2server1:
What should I do if an error occurs when setting the db2 primary key? The following describes how to solve the problem of not allowing you to set the db2 primary key. We hope this will help you learn how to set the db2 primary key.
Set empno as the
Transfer from http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0508luojunkai/Original: http://blog.csdn.net/deanza/article/details/8469447Standby is one of the DB2 high availability (Ha,high availability) technologies (and snapshot
In relational databases (Db2,oracle,sybase,informix and SQL Server) the smallest recovery and transaction units are one transaction (transactions), and transactions have acid (atomicity, consistency, isolation, and permanence)
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 view, sequence, constraints, foreign key exercise test. Simple test View of DB2 views, sequences, constraints, and foreign keys: the db2createviewmyview1asselect * fromt1whereempnoDB20000ISQL command is successfully completed. Db2select * from
Through this article, you will learn about DB2Hadr functions and basic operating principles, you can quickly configure an hadr environment through an instance and perform some simple functional tests. Next we will discuss some technical points
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:
and provide relevant evidence. A staff member will contact you within 5 working days.