Session 4: Saving CPU: Using thread reuse and BIND option RELEASE DEALLOCATE- TECHNICAL ROADSHOW

Event Details

Session 4:  Saving CPU: Using thread reuse and BIND option RELEASE DEALLOCATE- TECHNICAL ROADSHOW

Time: July 22, 2020 from 11am to 12pm
Location: Virtual Event
Website or Map: http://ibm.biz/Db212Technical…
Event Type: technical, road, show
Organized By: Surekha Parekh
Latest Activity: Jun 25

Export to Outlook or iCal (.ics)

Event Description

 

REGISTER NOW

Join John Campbell live, this will be an interactive session. John will be live on camera

 

Session 4:  Saving CPU: Using thread reuse and BIND option RELEASE DEALLOCATE

Abstract: Many installations are still missing out on opportunities to trade additional memory usage to reduce CPU resource consumption by designing for efficient thread reuse and combining this with packages bound with RELEASE(DEALLOCATE). This session will: describe what is thread reuse, which application processes to target, how to design for thread reuse, where to see the benefits, how the use of BIND option RELEASE(DEALLOCATE) can help when coupled with thread reuse, how to select which packages, limitations and considerations.

Comment Wall

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Change tracking on DB2 version 11.0 on Z/os

Started by Rakesh in Application Development and DB2 yesterday. 0 Replies

Hi All,I am from the solution team, we have a requirement to track the changes(UPDATE & INSERT) in a particular column from different tables. Can this be achieved on DB2 Z/os ?? If yes, please advise.I have been exploring triggers on DB2 but…Continue

Tags: tracking, change

Creating a function in DB2

Started by Jacob Ruchotzke in What's hot ? Jun 18. 0 Replies

With the help of our IT guy i have sort of gotten an example of how to create a function in our system. Can anyone help me with this? Please see the attached SQL file.Thanks in advanceContinue

Tags: function

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service