Db2 for z/OS Buffer Pools
This address space is where the buffers reside.
What is DBM1?
This stand-alone utility prints the
log map.
What is DSNJU004?
This SMF record type records information about Db2 subsystem behavior.
What is the SMF 100?
This is the only V13 function level where you can fallback to V12.
What is FL 100 (V13R1M100)?
Db2 for z/OS customers implement data sharing primarily for this reason
What is availability?
This is the required PG FIX setting for buffer pools allocated in 1M or 2G frames.
What is PGFIX = YES?
This command helps monitor one or more utility jobs.
What is DISPLAY UTILITY?
These in-memory structures serve as caches for non-leaf index pages and improve performance by reducing GETPAGE operations.
What are index fast traverse blocks (FTBs)?
This is the first FL of V13 with catalog changes.
What is FL 501?
This is the maximum number of members in a Db2 data sharing group.
What is 32?
This is the maximum possible size of a buffer pool.
What is 1TB?
This utility was enabled for ziip processing in late 2024.
What is the COPY utility?
This technology can reduce I/O latency, speed up Db2 for z/OS transaction processing, and improve active log throughput.
What is zHyperLink?
Packages last bound or re-bound before this Db2 version will not execute in V 13.
What is Db2 11?
These LPARs serve as high speed memory to allow Db2 for z/OS members to share information.
What are coupling facilities?
CF LPARs can run just about anywhere, including under VM.
Db2 can have this many buffer pools.
What is 80?
These are the catalog tables that were introduced in V13 to manage utility and object history.
What are SYSIBM.SYSUTILITIES and SYSIBM.SYSOBJEVENTS?
This performance feature in v12 was subject to a red alert at GA and will soon be ready for prime time.
What is insert algorithm 2? (IAG2)
This tool helps automate the process of installing or migrating to Db2 13 using workflows.
What is z/OSMF?
The size of this Db2 coupling facility resource is always a power of 2
What is the lock entry table? (or lock table or hash table)?
This performance feature addresses cross invalidations driven by PSUEDO CLOSE.
What is refresh prefetch?
(ALTER BPOOL REFPF = YES)
This option lets you choose the level of access you have to your data during reorganization.
What is SHRLEVEL?
(i.e. SHRLEVEL NONE, REFERENCE, CHANGE, etc.)
Db2 uses this method to track index changes to determine if a requested index entry is on the same leaf page as the previous request.
What is index lookaside?
This is how many catalog tables are changed when you first run CATMAINT to move to V13.
What is 0?
Is this a trick question?
This LBACKOUT setting speeds Db2 start in an LPAR failure scenario.
Hint: Anthony’s SWAT Tales
What is LIGHTAUTO?