1 / 10

DB2 V8 Bufferpool Pagefixing

DB2 V8 Bufferpool Pagefixing. For saving money in software fees. Talking about z /OS pages. Page is a set of contiguous 4K virtual addresses aligned at 4K boundary. Do you know that now we have 1M pages?Pages are virtually located in address spaces.

akamu
Download Presentation

DB2 V8 Bufferpool Pagefixing

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 V8 Bufferpool Pagefixing For saving money in software fees.

  2. Talking about z/OS pages • Page is a set of contiguous 4K virtual addresses aligned at 4K boundary. Do you know that now we have 1M pages?Pages are virtually located in address spaces. • A page is created through the Virtual Storage Management functions: GETMAIN and IEARV64. • Parameters define the AS locality of the new born page: • AS private area below the line • AS private area above the line • AS private area above the bar • A page also can be located in Dataspaces and Hiperspaces

  3. GETMAIN Macro GETMAIN LC,LA=length addr,A=addr LU,LA=length addr,A=addr VC,LA=length addr,A=addr VU,LA=length addr,A=addr EC,LV=length value,A=addr EU,LV=length value,A=addr VRU,LV=(maximum length value, minimum length value) SP=subpool nmbr

  4. IEARV64 Macro IARV64 REQUEST=GETSTOR ,COND=NO ,COND=YES ,SEGMENTS=segments ,FPROT=YES ,FPROT=NO ,SVCDUMPRGN=YES ,SVCDUMPRGN=NO

  5. What is Pagefixing • Physically the contents of a page may reside in a central storage 4KB frame or in 4KB slot in a page data set (see STOR and STORF MN III RMF reports). • Fixing a page means that this page is not available to be stolen from a frame to a slot. There is a noticeable CPU cycles for fixing the page. • Why do we need to page fixing? • Integrity in general, an example could be I/O buffer fixing

  6. DB2 Bufferpools DB2 Bufferpool is a set of same size I/O buffers in virtual storage. Each buffer contains a DB2 page. The full Bufferpool is contained in z/OS pages (confuse?). DB2 Bufferpools are used to avoid I/O operations in random accesses and to make them more efficient for sequential access. DB2 Bufferpool can be located in the three private areas in an AS or Dataspaces or Hiperspaces (not recommended). Buffers from the Bufferpool must be fixed before any I/O operation and free after the I/O operation end. Those functions consumes lots of CPU cycles.

  7. Fixing DB2 V8 Bufferpools • The idea here is to trade CPU cycles by central storage frames keeping DB2 buffers in some specific Bufferpools be permanently fixed. • We expected more than 20% DB2 CPU time savings impacting hardware saves and software saves (less MSUs/H). • It is strongly recommended after taking this option to track central storage performance indicators as: Highest UIC, Page Fault Rate, Available Queue size. Also it is recommended to increase the number of available slots.

More Related