Thursday, September 16, 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:



Convert .flv To .wmv



Top Web Or Video Cams



windows media player vob



SCREEN Savers Report



Interview with Eastman Kodak Asia Pacific Director of Human Resources is pleased to Ms.



Students this year, real salary levels Jiemi fresh



Mod To Mpg



Using Warm And Intimate Small Music Prompted The Fish That You're Familiar With The Music Fish



Youtube video formats



Jinshan Jinshan Nu Pi typing through repeated fake "Li Gui," poisonous pit Users



My favorite News Servers



Useful Time Of The Class



PHOTOSHOP font effects - waffle words



China has announced measures in the United States blocked WAPI appeal to the international organizat



Audio Speech brief



Alternative workplace quit: to a rival Company to do an undercover intelligence probe



Good Efficacy Is The Man Manao Out



No comments:

Post a Comment