Basic architecture and fundamental mechanisms Flashcards
This lesson is an overview of DB2 architecture and fundamental DB2 processes that will be explored in more depth later.
System IPL Initialization process begins when
The system programmer or operator selects the LOAD function at the Hardware Management Console (HMC)
Hardware Management Console (HMC)
Hardware appliance that you can use to configure and control one or more managed systems. Used to create LPARs and activate Capacity Upgrade on Demand.
What information supplied to successfully IPL z/OS?
- Device address of the IPL volume
- LOADxx member that contains pointers to the system parms
- The IODF dataset that contains the configuration information.
- Device address of the IODF volume
IODF volume
Defines the configuration to the system that is selected and used.
Logon CLIST procedure
- Make DB2 Load Modules available to TSO
- Concatenate SDSNCLST to SYSPROC
- Make Panels and Messages available to ISPF and TSO
- Make skeleton library available to TSO
- Make table library available to TSO
SYSPROC
Pointer to the PDS library where CLISTS are stored.
CLISTs
TSO command scripts; each CLIST executed TSO/E commands in sequence. Essentially batch files for different operations on the mainframe.
Skeleton files
Template files containing basic structure, primarily used for generating customized output like JCL scripts.
DB2 cannot start unless the system services address space ssidMSTR is able to allocate the
DB2 Boostrap Data Sets and all the active log data sets.
What isn’t a requirement for DBM1 to start up but will attempt to do so anyways?
Catalog and Directory
A DB2 is composed of the following address spaces:
- MSTR (System Services)
- DBM1 (Database Services)
- IRLM (Internal Resource Lock)
- DDF (Distributed Data Facility) or DIST
- One or more WLM-established Stored Procedure address spaces
- Administrative Task Scheduler (ADMT)
Is MSTR address space mandatory or optional?
Mandatory
Is DBM1 address space mandatory or optional?
Mandatory
Is IRLM address space mandatory or optional?
Mandatory
Is DDF address space mandatory or optional?
Optional
WLM
Workload Manager (component of z/OS)
What are the two main DB2 address spaces?
MSTR and DBM1
What is an important criterion for Db2 to run efficiently?
That you provide sufficient region size for each address space
Applications are said to run in
allied address spaces
DBM1 storage areas above the 2 GB includes
- Bufferpools
- Bufferpool control blocks
- RID pool
- Compression dictionaries
- EDM Pool: DBDs, OBDs
- Dynamic statement cache
- Castout buffers
- Sort pool
What address spaces are 31 bit?
Only MSTR
What address spaces are 64 bit?
DBM1, DDF, and IRLM
What else is 31 bit?
User programs as well as stored procedures.
IRLM can manage up to
100 million locks