Identifying crucial Db2 data sets
When you are placing your data sets, you need to first consider data sets that are crucial for Db2 to function properly.
Procedure
To identify the crucial Db2 data sets:
Use the I/O reports from the Db2 performance
trace.
If these reports are not available, consider the
following data sets to be most important:
- For transactions
- DSNDB01.SCT02 and its index
- DSNDB01.SPT01 and its index
- DSNDB01.SYSSPUXA and its index
- DSNDB01.SYSSPUXB and its index
- DSNDB01.DBD01 and its index
- DSNDB01.SYSDBDXA and its index
- Indexes on SYSPLANAUTH table
- DSNDB06.SYSTSDBR
- DSNDB06.SYSTSPKA
- DSNDB06.SYSTSPKG
- DSNDB06.SYSTSPKD
- DSNDB06.SYSTSPKL
- DSNDB06.SYSTSPKS
- DSNDB06.SYSTSPKX
- DSNDB06.SYSTSPKY
- DSNDB06.SYSTSPLA
- DSNDB06.SYSTSPLD
- DSNDB06.SYSTSPLN
- DSNDB06.SYSTSPLY
- DSNDB06.SYSTSPVR
- DSNDB06.SYSTSSTM
- Active and archive logs
- Most frequently used user table spaces and indexes
- For queries
- DSNDB01.DBD01 and its index
- DSNDB01.SYSDBDXA and its index
- Indexes on SYSPLANAUTH table
- DSNDB06.SYSTSCOL
- DSNDB06.SYSTSDBR
- DSNDB06.SYSTSFAU
- DSNDB06.SYSTSFLD
- DSNDB06.SYSTSFOR
- DSNDB06.SYSTSKEY
- DSNDB06.SYSTSIPT
- DSNDB06.SYSTSIXR
- DSNDB06.SYSTSIXS
- DSNDB06.SYSTSIXT
- DSNDB06.SYSTSPKA
- DSNDB06.SYSTSPKD
- DSNDB06.SYSTSPKG
- DSNDB06.SYSTSPKL
- DSNDB06.SYSTSPKS
- DSNDB06.SYSTSPKX
- DSNDB06.SYSTSPKY
- DSNDB06.SYSTSPLA
- DSNDB06.SYSTSPLD
- DSNDB06.SYSTSPLN
- DSNDB06.SYSTSPLY
- DSNDB06.SYSTSPVR
- DSNDB06.SYSTSREL
- DSNDB06.SYSTSSTM
- DSNDB06.SYSTSSYN
- DSNDB06.SYSTSTAB
- DSNDB06.SYSTSTAU
- DSNDB06.SYSTSTPT
- DSNDB06.SYSTSTSP
- DSNDB06.SYSTSVEW
- DSNDB06.SYSTSVTR
- DSNDB06.SYSTSVWD
- DSNDB06.SYSTSVWT
- The index on SYSVTREE
- Work file table spaces
- QMF system table data sets
- Most frequently used user table spaces and indexes
These lists do not include other data sets that are less crucial to Db2 performance, such as those that contain program libraries, control blocks, and formats. Those types of data sets have their own design recommendations.