A brief talk on DB2 Zos-DB2 LUW VS DB2 Zos

DB2 Zostalking about-DB2 LUWVSDB2 Zos

Overview:

you may have DB2 LUW knows a lot, but little is known about DB2 Zos(Big Machine operating system) because IBM 's internal data has always been relatively closed, especially for products we rarely see on the market, such as Zos Operating system, generally in the bank's internal staff and IBM employees will be contacted, the circle is relatively small.

The main comparison of this share DB2 LUW and DB2 for Zoshelp us to quickly understand the architecture of the Big Machine DB2.

DB2 Zos Introduction:

in the Multiple DB2 subsystems can be run simultaneously under the z/OS operating system, with each subsystem corresponding to a set of DB2 address spaces :ssnmmstr , ssnmDBM1,ssnmdist,ssnmspas,ssnmwlm,ssnmirlm, The ssnm is SUBSYSTEM NAME.

a The DB2 subsystem consists of the following three address spaces

DBM1 (DATABASE ADDRESS SPACE ):

provides the address space for the database service, mainly including SQL Process,Buffer manage,Bind.

MSTR (SYSTEM SERVICE ADDRESS SPACE ):

provide the address space of the system service, perform various system related functions,

mainly has Thread Management,Log management,Checkpoint,Trace.

IRLM (INTERNAL RESOURCE LOCK MANAGER ):

provides an address space for internal resource lock management, which is Lock Management.

with DB2 Command "Start DB2" to start these address spaces.

For example: in the production of Sd.da can be seen in : Bb1airlm,bb1amstr,bb1aDBM1

DB2 LUW with the DB2 Zos Comparison:

to be DB2 LUW Architecture, you can see the server's entire NODE(a computer on the network) with two instances INST1 and INST2, each containing two databases ( DB001,DB002) (DB003,DB004), each database contains three tablespace (catalog, Tempspace1, Userspace1). Each database has a database-level configuration file and log file (DB Config, LOGS). The entire instance also has an instance-level configuration file that the client can connect to the server.

to be DB2 for Zos , the entire LPAR(host virtual computer) of the server contains two subsystems (db7g, db8g, equivalent to instances in the distributed platform), each subsystem contains four system databases ( dsndb*), a user database (DB001) with a user table space in the user database. The entire subsystem level has log files and BSDs files. The entire subsystem has a subsystem-level configuration file. Clients can connect to the server via DB2 connect and DDF (distributed Data Facility).

through the ZOS and LUW of the DB2 of different comparisons, you can see that some of the LUW in the table space properties, in the ZOS with the database of properties to replace.

Here's a brief introduction to ZOS A few important databases:

DIRECTORY DATABASE(DSNDB01) consists of a series of tablespace that contain the Control Block required for DB2 normal operation and status information, cannot be used SQL statement to access the DIRECTORY.

It includes the Tablespace are:

DBD01 Database descriptor tablespace, which stores the internal descriptors of all the Databasedefinitions in the DB2 system , the DBD, which is all DB2 The internal description of the object in the.

SCT02 SKELETON CURSOR tablespace, which includes information about the access path of the DBRM, the internal form of the SQL statement of the application, and so on. Whenever Bind is a PLAN,DB2 creates a Skeleton cusor Table in SCT02.

SPT01 SKELETON package tablespaceincludes information about the package's access path, the internal form of the application's SQL statement, and so on. Whenever Bind is a package,DB2 creates a SKELETON package TABLE in SPT01.

SYSUTILX SYSTEM UTILITIES tablespace, each Utility running in DB2, has a recordin Sysutilix that describes the Utility status information, This record is deleted after Utility normal end or termination, but the Utility for an abnormal stop is not deleted when the restart exception stops This record will be used when utiltiy.

Syslgrnx Log RANGE tablespace, record tablespace,

Log RBA values for indexspace and Partition at Open and Close .

DB2 's CATALOG DATABASE(DSNDB06) consists of a series of Table Records of all the definitions defined in DB2 Object , which can be manipulated using an SQL statement. These system tables are named ' SYSIBM. Sys* '.

The DSNDB06 contains the following main contents:

through Data definition Language (DDL) defines all

of the Object

Application Package

Application Plan

all authorized users and their scope of access

Image Copy The name of the Dataset and the volume on which it resides

DSNDB04 is defined when the DB2 subsystem is installed. If the user does not specify a Database when creating a Table or tablespace, the default database-dsndb04 isautomatically specified and its default The Buffer Pool is BP0, and the default Storage Group is Sysdeflt.

In addition, we need to Db2i know something about it. Skilled use of db2i, Basic can solve the simple zos operation and maintenance.

Db2i is an interactive application tool provided by the DB2 system on The 9000 system, in which the user can execute arbitrary SQL statements, automatically generate database table structure definitions, Prepare the user program, precompile the user program,BI ND program or package, execute the user program, execute the DB2 command, run the DB2 utility. db2i is a tool that DB2 developers often use, and here's a brief introduction to some of the features we've often used.

Below is Initial screen of db2i:

the features of each option are:

1 Spufi is used to write SQL statements and run to produce results

2 Dclgen automatic generation of table structures and host language definitions in different languages

3 program Preparati the various parameters needed to prepare the application via multi-layer screen to complete the process

Pre-compile, compile, pre-connect, connect, and execute each step of the sequence

4 Precompi LE Pre-compiles the source program by entering the necessary parameters in the screen

5 BI Nd/rebi Nd/free bind, rebind, or release a schedule or package

6 Run Execute SQL program

7 DB2 COMMANDS execute DB2 command

8 UTI LI TI ES performs other DB2 tool Programs

D db2i DEFAULTS setting global parameters

X EXI T exit

A brief talk on DB2 Zos-DB2 LUW VS DB2 Zos