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.

1
Q

System IPL Initialization process begins when

A

The system programmer or operator selects the LOAD function at the Hardware Management Console (HMC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Hardware Management Console (HMC)

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What information supplied to successfully IPL z/OS?

A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

IODF volume

A

Defines the configuration to the system that is selected and used.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Logon CLIST procedure

A
  1. Make DB2 Load Modules available to TSO
  2. Concatenate SDSNCLST to SYSPROC
  3. Make Panels and Messages available to ISPF and TSO
  4. Make skeleton library available to TSO
  5. Make table library available to TSO
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

SYSPROC

A

Pointer to the PDS library where CLISTS are stored.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

CLISTs

A

TSO command scripts; each CLIST executed TSO/E commands in sequence. Essentially batch files for different operations on the mainframe.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Skeleton files

A

Template files containing basic structure, primarily used for generating customized output like JCL scripts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

DB2 cannot start unless the system services address space ssidMSTR is able to allocate the

A

DB2 Boostrap Data Sets and all the active log data sets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What isn’t a requirement for DBM1 to start up but will attempt to do so anyways?

A

Catalog and Directory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A DB2 is composed of the following address spaces:

A
  • 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)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Is MSTR address space mandatory or optional?

A

Mandatory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Is DBM1 address space mandatory or optional?

A

Mandatory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Is IRLM address space mandatory or optional?

A

Mandatory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Is DDF address space mandatory or optional?

A

Optional

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

WLM

A

Workload Manager (component of z/OS)

17
Q

What are the two main DB2 address spaces?

A

MSTR and DBM1

18
Q

What is an important criterion for Db2 to run efficiently?

A

That you provide sufficient region size for each address space

19
Q

Applications are said to run in

A

allied address spaces

20
Q

DBM1 storage areas above the 2 GB includes

A
  • Bufferpools
  • Bufferpool control blocks
  • RID pool
  • Compression dictionaries
  • EDM Pool: DBDs, OBDs
  • Dynamic statement cache
  • Castout buffers
  • Sort pool
21
Q

What address spaces are 31 bit?

22
Q

What address spaces are 64 bit?

A

DBM1, DDF, and IRLM

23
Q

What else is 31 bit?

A

User programs as well as stored procedures.

24
Q

IRLM can manage up to

A

100 million locks

25
NUMLKTS
Maximum number of locks per table space before lock escalation occurs
26
NUMLKUS
Number of locks per user before a resource unavailable occurs
27
MLMT
Parameter for max storage for locks
28
PGPROT
Page protect - specifies whether IRLM loads its modules that reside in common storage into page-protected storage to prevent programs from overlaying the instructions.
29