Monday, 12 February 2018

DSNDBM1

  
  •     Database service address space / ReadIN-writeIN / Physical component
  •     Database services which is responsible for managing Physical structure of DB.
  •     Handles SQL related queries
  •     Core logic of DB2
  •     Update SYSLGRNX/Interaction with coupling facility 
   


Buffer Spool management
  • *  Relational Data system (RDS)
  • *  Data Manager (DM)
  • *  Buffer Manager (BM)

Relational Data System
o   SQL Compiler (compiles all SQL)
o   Runtime Executor
o   Catalog services
o   Manages Objects


Data Manager
o   DB2 Engine
o   Makes requests to get/create/alter data
o   Invokes buffer manager
o   Interface with IRLM


Buffer Manager
o   Access Physical data for data manager / Index Manager
o   Searches for page in Buffer spool , if there is no page then VSAM media manager to return from DASD



No comments:

Post a Comment