CREATE DATABASE command, DB2 creates a number of documents. These files include log files, configuration information, historical documents and three table spaces. The three table spaces are:
SYSCATSPACE: This is a store directory where DB2 system, DB2 system directory to track all objects associated with metadata.
TEMPSPACE1: DB2 to place the intermediate results of the temporary workspace.
USERSPACE1: By default all user objects (tables and indexes) is located where.
In cataloging the database on the client there are three ways:
Use discovery (discovery) of the automated configuration
Use Access Summary (access profile) automated configuration
Manual configuration
Configuring DB2 client to access remote DB2 database server and another is to use automation to access summary. Access summary contains the client for a DB2 server database cataloging the information needed.
And use the same found in the use of access to the outline, do not need to make DB2 client can connect to the DB2 server communications to provide any detailed information.
There are two access summary:
Server to access the summary is created from the DB2 server. They contain the DB2 server has been cataloging all the instances and databases.
Summary of client access from a client for another client to copy the database has been cataloged and / or client settings (DBM CFG and the CLI / ODBC).
Both outline can be exported from a DB2 system, then import to another DB2 system.
Recommended links:
Longhorn Beta1 only Compatible with two kinds of graphics chips
Resolving quot corrupt registry quot error
SAP And Sybase Hutch Alliance
Expert Audio Video Tools
Registry combat Collection - "OPERATION" Change Collection
Distributors to seize the initiative to prevent being cut off
DAT To 3GP
Computer Education Comparison
Sichuan Instrument flow meters: precision production of personalized quote
"Stubborn" Fujitsu began to Chinese Changing Faces
LiveMotion Font Production: Shadow Word
DivX To Zune
Seasonal - Screen Savers introduction
MTS to AVI
Eight Motivate The Staff More Dynamic Model [1]
Struts framework in the Session object to create AND control
No comments:
Post a Comment