C:/Documents and Settings/New> DB2 catalog TCPIP node N11 remote XXX. XX ServEr 50000The db20000i catalog TCPIP node command is successfully completed.Db21056w takes effect only after directory cache is refreshed.
C:/Documents and Settings/New> DB2
Introduction: In the DB2 databaseIsCatalogThis word is hard to understand. Specifically, cataloguing includes cataloguing nodes and cataloguing databases. If you want to understand the cataloguing, let me briefly introduce the architecture of the DB2
Guidance:InDB2 databaseWe often encounterCatalogMany people are not very familiar with this word, and catalog is difficult to understand. Specifically, cataloguing includes cataloguing nodes and cataloguing databases. If you want to understand the
This time, our DB2 is deployed on Windows. Windows has a client that is called a graphical interface. But it does not seem to work well, we have some problems, let's solve it.
First, add a database instance:
Instances of DB2 are independent of each
First, add a database instance:
Instances of DB2 are independent of each other, and instances can be considered as containers for databases. When the default DB2 is installed, it builds an instance named DB2. We need to create a new one, and
Problem: There are two instances on the same node, and there are two ways to access a database in another instance under one of these instances:1. using Catalog Local node , in one instance, another instance is cataloged directly, in which the
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
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.
C:/Documents and SETTINGS/NEW>DB2 Catalog tcpip node N11 remote xxx.xxx.xxx.xx ServER 50000db20000i CATALOG TCPIP NODE command completed successfully.db21056w directory changes will only take effect if the directory cache is refreshed.
C:/Documents
DB2 command Overview
View the local node directoryDB2
Li
St node directory
View the system database directoryDB2
Li
St database directory
When you access
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.