JC Greatest Hits, War Stories, and Best Practices 2019 Part 1

Event Details

JC Greatest Hits, War Stories, and Best Practices 2019 Part 1

Time: January 29, 2019 from 11am to 12:30pm
Location: VIRTUAL WEBCAST - Timezone EST
Website or Map: http://ibm.biz/JCGreatestHits…
Event Type: webcast, db2, john_campbell, @gurudb2, replay, db2z, surekha, 2019, john, campbell
Organized By: Surekha Parekh
Latest Activity: Jan 16

Export to Outlook or iCal (.ics)

Event Description

Title: JC's Greatest Hits, War Stories, and Best Practices 2019 Part 1

Date: 29th January 2019

Register Now http://ibm.biz/JCGreatestHitsPART1

Abstract: This double session introduces and discusses some of most common and/or most important issues based on worldwide customer engagements. There are two main objectives. Firstly, learn recommended best practice. Secondly, learn from the positive and negative experiences from other customer installations. The following topics will be discussed: Running out of basic 6-byte log RBA addressing range; Diagnosing resolving slow-downs and hangs; Hung Db2 threads; New ZSA keyword on HIPER and PE APARs; Insert free space search algorithm; Insert with APPEND; Fast un-clustered insert (Db2 12); Hidden ROWID support to partition; Cost management using CPU capping; Fast REORG with SORTDATA NO RECLUSTER NO; Requirement for increased RID Pool size (Db2 12); Setting initial STATISTICS PROFILE (Db2 12); System parameter REALSTORAGE_MANAGEMENT; Transaction level workload balancing for DRDA traffic; Use of High-Performance DBATs; Overuse of UTS PBG tablespaces and MAXPARTS; Cleaning up after STATCLUS = STANDARD; “MBA lock”; IRLM query requests for package break-in; Db2 maintenance issues with  batch utilities; Running CHECK utilities with SHRLEVEL CHANGE; Local buffer pool allocation – virtual and real memory.

Speaker - John Campbell IBM Distinguished Engineer

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 in terms of systems, database and applications design. He specializes in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.

Comment Wall

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


Db2 Analytics Accelerator Version 7.5 is now Generally Available!

Started by Patricia Zakhar in What's hot ? on Monday. 0 Replies

Now Generally AvailableIBM Db2 Analytics Accelerator Version 7.5! The latest version of the Db2 Analytics Accelerator, which delivers the highly anticipated Integrated Synchronization capability, is now generally available. The Db2 Analytics…Continue

Db2 for z/OS Master class with John Campbell and the SWAT team returns!

Started by Surekha Parekh in What's hot ?. Last reply by carol Goldberg Nov 7. 1 Reply

Db2 for z/OS Master class with John Campbell and the SWAT team returns! June 24-28, 2019 at IBM Hursley near Winchester, UKSeptember 23-27, 2019 at IBM Silicon Valley Lab in San Jose, California…Continue

Tags: Events, MasterClass, JohnCampbell

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service