Designing a main storage database (MSDB)

This topic describes the choices you might need to make in designing an MSDB and proposes guidelines to help you make these choices.

Consider the following list of questions when designing an MSDB database:

• How are virtual storage requirements for the database calculated?
• How are virtual storage requirements for the Fast Path buffer pool calculated?
• What are the storage requirements for the I/O area?
• Should FLD calls or other DL/I calls be used for improved MSDB and DEDB performance?
• How can the difference in resource allocation between an MSDB and a DL/I database be a key to good performance?
• What are the requirements in designing for minimum resource contention in a mixed-mode environment?
• How is the number of MSDB segments loaded into virtual storage controlled?
• What are the auxiliary storage requirements for an MSDB?
• How can an MSDB be checkpointed?