Db2 and DFSMS

You can use the DFSMSdfp Storage Management Subsystem (SMS) to manage Db2 disk data sets.

The purpose of DFSMS is to automate as much as possible the management of physical storage by centralizing control, automating tasks, and providing interactive controls for system administrators. DFSMS can reduce user concerns about physical details of performance, space, and device management.

Consult with your storage administrator about using DFSMS for Db2 private data, image copies, and archive logs. Data that is especially performance-sensitive might necessitate more manual control over data set placement.

Table spaces or indexes with data sets larger than 4 GB require DFSMS-managed data sets.

Extended partitioned data sets (PDSE), a feature of DFSMSdfp, are useful for managing stored procedures that run in a stored procedures address space. PDSE enables extent information for the load libraries to be dynamically updated, reducing the need to start and stop the stored procedures address space.