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:


Review Converters And Optimizers

Serial ATA and SCSI rematch

MKV to MP4

About Password Psychology


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