Information about database objects is collected from DB2 machines and stored as CA SRM objects. You can filter, sort, and query these objects, represent them graphically, and customize the presentation in other ways.
CA SRM reports on the following DB2 objects:
The instance, database manager, is at the top of the DB2 hierarchy. An instance is a complete environment for hosting databases. It has a range of memory and CPU management policies as well as network port numbers for communication. It contains all of the database partitions defined for a given parallel database system. DB2 instances manage data. They control what can be done to the data, and also manage the system resources assigned to it.
A database partition is part of a database that consists of its own data, indexes, configuration files, and transaction logs. A partitioned database is a database with two or more partitions. In this type of database, data is hashed for storage. A database partition is sometimes called a node or a database node.
A database is a collection of relational data in tables, along with the associated indices, triggers, and stored procedures. The tables can be related and queried together. A database can be backed up and restored as a whole. DB2 supports multiple databases within a single instance.
A database partition group, or nodegroup, is a set of one or more database partitions. Tablespaces are assigned to nodegroups. Any given nodegroup can have multiple tablespaces assigned to it.
A database is organized into parts called tablespaces. Tablespaces store tables and also contain indices and catalogs. Tablespaces are named areas where data is located logically.
A container is a physical storage device. It can be identified by a directory name, a device name, or a file name. A container is assigned to a tablespace. A single tablespace can span many containers, but each container can belong to only one tablespace. You can create multiple containers (from one or more tablespaces) on the same physical disk.
The following container limitations apply to partitioned databases:
A relational database represents data as a collection of tables. A table consists of data logically arranged in rows and columns. All of the database and table data are assigned to tablespaces. The data in a table is logically related, and relationships are defined between tables. Data can be viewed and manipulated based on relations.
The DB2 Users table lists the DB2 users found in the CA SRM database. The data displayed in the table is collected by the data collection service. This table contains information about only those users who actually occupy storage on the database.
|
Copyright © 2016 CA Technologies.
All rights reserved.
|
|