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…
What is SMS in mainframe ? -Understanding z/OS Storage Management Subsystem (SMS)
Introduction: The Storage Management Subsystem (SMS) automates the use of storage for data sets. The system is not aware of how much space a dataset will need, where it will be stored(Disk…