1 / 22

System Performance at BNP Paribas Fortis

System Performance at BNP Paribas Fortis. GSE DB2 17 March 2016. Eddy Tiels. Contents. Introduction Performance Warehouse SSD . Introduction. Introduction. Software used DB2 V10 (DEV and TEST in V11) BMC Tools V11 BMC Mainview used for Performance Warehouse IBM Utilities V10.

jille
Download Presentation

System Performance at BNP Paribas Fortis

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. System Performance atBNP Paribas Fortis GSE DB2 17 March 2016 • Eddy Tiels

  2. Contents • Introduction • Performance Warehouse • SSD DB2 maintenance

  3. Introduction DB2 maintenance

  4. Introduction Software used • DB2 V10 (DEV and TEST in V11) • BMC Tools V11 • BMC Mainview used for Performance Warehouse • IBM Utilities V10 DB2 maintenance

  5. Performance Warehouse • The SMF records are loaded by plex • PLXC – daily about 850.000 (multiple subsystems) • PLXB – daily about 10.000.000 • PLXA – daily about 400.000.000 • All volume data is summarized by hour • Data retention • Kept for at least 100 days • Package information is kept 150 days • Plan data is kept for 200 days DB2 maintenance

  6. Performance Warehouse DB2 statistics tables • DMRSTAT - statistics table, Not summarized • DMRSTDF - DDF statistics table, SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION) • DMRSTADT - storage address space statistics table , Not summarized • DMRSTSDT - system storage statistics table , Not summarized • DMRSBSUM - buffer statistics summary table SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION,BPNAME) • DMRSDSUM - DDF statistics summary table SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION,DDFLOCATION) • DMRSTSUM - summary statistics table SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION) DB2 maintenance

  7. Performance Warehouse DB2 accounting tables • DMRACSUM - accounting SUMMKEY=(LOCATION,SUBSYSTEM,PLANNAME) • DMRABSUM - accounting buffer SUMMKEY=(LOCATION,SUBSYSTEM,PLANNAME,BPNAME) • DMRADSUM - DDF accounting SUMMKEY=(LOCATION,SUBSYSTEM,PLANNAME,AUTHID,DDFLOCATION) • DMRAPSUM - package accounting SUMMKEY=(LOCATION,SUBSYSTEM,PROGRAMNAME) DB2 maintenance

  8. Performance Warehouse DB2 volumes DB2 maintenance

  9. SSD • Definition Solid-state drives consist of Flash memory mainly known from it’s use in memory cards and USB flash drives. They don’t have moving parts, consume less energy and have better performance for random accesses then hard disk drives, but they are more expensive • DS8870 hardware is used at BNP • Automatic tiering is done between 3 levels • SSD 27 Tb • 300 GB disks at 15000 RPM 100 Tb • 1200 GB disks at 10000 RPM 303 Tb DB2 maintenance

  10. SSD • Overall response - BEFORE DB2 maintenance

  11. SSD • Overall response - AFTER DB2 maintenance

  12. SSD • Tablespace info from RTS DB2 maintenance

  13. SSD • Index info from RTS DB2 maintenance

  14. SSD • Space info from RTS DB2 maintenance

  15. SSD • TS and IX datasets DB2 maintenance

  16. SSD • TS and IX datasets DB2 maintenance

  17. SSD • DB2 information on DRIVETYPE in RTS • SYSIBM.SYSTABLESPACESTATS • SYSIBM.SYSINDEXSPACESTATS HDD Hard Disk Drive SSD Solid State Drive For multi-volume data sets, the drive type is set to SSD if any volume is SSD. For multi-piece linear page sets, the drive type of the first data set is used. • DB2 APAR PI35321 This APAR delivers DB2 for z/OS REORG utility support for directive data placement enhancement introduced by DS8870 microcode level R7.4 using Easy Tier Application API. DB2 maintenance

  18. SSD • Overall transaction response time (SU=1/10000) DB2 maintenance

  19. SSD • Overall transaction response time (SU=1/10000) DB2 maintenance

  20. SSD • High used transactions response time • Before • After • Current DB2 maintenance

  21. SSD • Questions I have • How is DB2 defining SSD/HDD • With Easy Tiering the complete dataset is not necessarily on the same Tier • How can you monitor and is it necessary DB2 maintenance

  22. Questions ?

More Related