1 / 67

DB2

DB2. Session Plan. Precompilation DBRM Binding Application Plan and Package Program preparation summary Demonstration of batch application in different modes Working with CICS. Steps Involved in Program Preparation. Pre-compilation Binding Compilation Linking Execution.

patty
Download Presentation

DB2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DB2

  2. Session Plan • Precompilation • DBRM • Binding • Application Plan and Package • Program preparation summary • Demonstration of batch application in different modes • Working with CICS

  3. Steps Involved in Program Preparation • Pre-compilation • Binding • Compilation • Linking • Execution

  4. Precompilation Involves the following sequence of events. • Syntax checking of SQL statements embedded in the host language. • Checking for datatype matches. • Commenting out the SQL statements and replacing it with equivalent COBOL CALL statements. • Creation of DBRM (Data base Request Module).

  5. DBRM (Data base Request Module) • A DBRM is a module containing SQL statements. • A DBRM is stored as a member of a PDS.

  6. Binding • Converts all the SQL statements to executables • Bind reads SQL statements from DBRM’s and produces a strategy to access data directed by the SQL statements. • Does the following • Checks the syntax SQL statements • Verification of authority on DB2 objects • Optimization of SQL statements to create the application plan

  7. Application Plan • Is the executable form of one or more of one or more DBRMs and application package • Should be generated every time a DBRM is modified. • Application plans are kept in the buffer pool during program execution

  8. Application Package • Is the executable form of a single DBRM. • Is bound to an application plan with related packages. • If any DBRM is altered, then only the corresponding package needs re-binding.

  9. Relationship between DBRM, Package and Plan PLAN PACKAGE PACKAGE PACKAGE DBRM4 DBRM1 DBRM2 DBRM3

  10. Source Program DBRM Modified Source program Packages Plans Load Module Program Preparation Summary Hostvariables copybook DCLGEN Precompile Catalog Tables Plans & packages Info DB Objects Info BIND Bufferpool Compile & Link Execution

  11. Demonstration Program Preparation and Execution

  12. Execution in Foreground Mode

  13. Execution in EDITJCL Mode

  14. Execution in BACKGROUND Mode

More Related