DB2 UDB Architecture and database diagram

DB2 UDB Architecture and database structure.

Figure 1. DB2 UDB Architecture

architecture diagram

DB2 UDB Memory Structure

Package caching-the memory allocated for storing static and dynamic SQL statements.

Buffer pool-the memory allocated for storing data before it is flushed to disk.

Log buffer-The memory that is used to store changes to the database before all changes to it are flushed to the log on disk.

Figure 2. DB2 UDB Database structure

Drive/directory-the drive or directory specified in the CREATE DATABASE command，software architecture diagram.

DB2 Instance name--db2 The name of the instance owner.

The number of partitions for the node0000--database.  architecture diagram 0 represents a database that is not partitioned.

sql00001--the database ID starting at 1.

sqlogdir--the default log directory for the database，aws architecture diagram.

sqlt0000.0--Directory table Space Syscatspace and system architecture diagram.

sqlt0001.0--temporary table space TEMPSPACE1,bubble diagram architecture.

sqlt0002.0--User table Space USERSPACE1, kubernetes  architecture diagram.