In IBM Db2 databases, data is physically stored on disk across multiple files. Each file is divided into fixed-size blocks known as pages, which serve as the smallest unit of data exchange…
Category: DB2
Catalog Tables In DB2
The word catalog signifies a list of items. When DB2 is installed, DB2 creates a set of tables which stores the information about DB2 objects as and when it gets created/updated, like…
Identity Column in DB2
This identifier is a number that is updated sequentially as new records are added. In DB2, this feature will automatically generate the values. The values for an identity column can be generated…
Database Objects in IBM DB2
A database is an organized collection of related objects. Broadly the database objects can be classified as :TablesAliasesSynonymsViewsIndexesTable spacesIndex spacesDatabasesStorage groups. In this post we will see types of tables. In subsequent…