Close X

Total Recall: Exploiting In-Memory Features in DB2 12 for z/OS


Presentation

"IBM has steadily expanded the in-memory capabilities of DB2 in recent releases, to the extent that DB2 12 for z/OS is now officially recognised by Gartner as a bona fide “In Memory Database”. This presentation provides an overview of the ways in which DB2 is evolving to exploit more real memory, reduce CPU and deliver improved price/performance, with a specific emphasis on exploiting new DB2 12 in-memory features such as contiguous buffer pools and Fast Traverse Blocks (FTBs).
Objectives:
• Provide an overview of IBM's increasing use of in-memory techniques to boost DB2 application performance and scalability.
• Describe the technical implementation of the two major in-memory DB2 12 for z/OS in-memory features: contiguous buffer pools and Fast Traverse Blocks (FTBs).
• Provide some practical guidelines and best practices for configuring and using DB2 12 in-memory features.

 

(IB)

Stream: DB2
Room: Nurburgring
Time: 12:00 - 13:00

Attachments

GSE 2017 Session IB Total Recall Expoiting DB2 12 for zOS In Memory Features.pdf

Speakers


  • Julian Stuhler at Triton Consulting
  • Julian is a highly experienced DB2 consultant with over 30 years relational database experience working with a number of clients within the insurance, telecommunications, banking, and manufacturing sectors. In that time he has gained a significant amount of practical knowledge in many aspects of IBM's Information Management products, including experience in application programming, database administration, technical architecture, performance tuning and systems programming. He has also managed large database support teams, DBA teams and systems programming teams. More recently, he has specialised in supporting large-scale implementations of SAP on DB2 for z/OS. Julian possesses excellent communication skills and regularly makes technical presentations to major DB2 events both in the UK and abroad, winning the Best Overall Speaker award at the 2000 International DB2 User Group meeting. He is also an IBM Gold Consultant, an IBM Red Book author, and IBM Data Champion and a regular instructor for IBM education classes throughout Europe. He is also a past President of IDUG (International DB2 User Group).


    Email: julian.stuhler@triton.co.uk

  • Julian Stuhler at Triton Consulting
  • Julian is a highly experienced DB2 consultant with over 30 years relational database experience working with a number of clients within the insurance, telecommunications, banking, and manufacturing sectors. In that time he has gained a significant amount of practical knowledge in many aspects of IBM's Information Management products, including experience in application programming, database administration, technical architecture, performance tuning and systems programming. He has also managed large database support teams, DBA teams and systems programming teams. More recently, he has specialised in supporting large-scale implementations of SAP on DB2 for z/OS. Julian possesses excellent communication skills and regularly makes technical presentations to major DB2 events both in the UK and abroad, winning the Best Overall Speaker award at the 2000 International DB2 User Group meeting. He is also an IBM Gold Consultant, an IBM Red Book author, and IBM Data Champion and a regular instructor for IBM education classes throughout Europe. He is also a past President of IDUG (International DB2 User Group).


    Email: julian.stuhler@triton.co.uk

    Feedback

    Click here to give some Feedback so we can make it even better next year!