Saturday, October 23, 2010

DB2 basics



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:



RMVB to MP4



Review Converters And Optimizers



Serial ATA and SCSI rematch



MKV to MP4



About Password Psychology



ODF and OOXM



Computer fraud, although he is alleged to have bought



JSP variable in the scope of the specification



comments System Utilities



Acer executives BOASTED that Dell no longer pose a threat to Acer



Fun Chinese Version Of Firefox Mode Conversion Work Great Transfiguration Entertainment



Wholesale Kingsun V602a Wifi Phone Java Bluetooth



Semiconductor India vied with New Deal



New Wang Zhidong: Eliminating "Sina label"



3G2 to MOV



No comments:

Post a Comment