John Campbell

Speaker Details


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 specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications. 

Past presentation
29 maj 2019
10:00 - 11:00
European SQLAdria Seminar – Šibenik 2019 Db2 for z/OS Trends and Directions

This session will cover recent announcements and latest news on Db2 12 for z/OS, as well as cover future product road map and investment areas. 

28 maj 2019
09:00 - 10:00
European SQLAdria Seminar – Šibenik 2019 Insight Into Db2 for z/OS Key Performance Metrics and How To Use Them

27 maj 2019
09:30 - 11:30
European SQLAdria Seminar – Šibenik 2019 JC Greatest Hits, War Stories, and Best Practices 2019 for Db2 for z/OS

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. Seconely, 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. 

13 april 2012
13:00 - 14:00
SQLAdria Seminar - Ljubljana 2012 V10 Virtual and Real Storage Management?

No description

13 april 2012
12:15 - 13:00
SQLAdria Seminar - Ljubljana 2012 Advanced Backup and Recovery using Flashcopy?

No description

13 april 2012
10:00 - 11:00
SQLAdria Seminar - Ljubljana 2012 Gain insight into V9 and V10 Performance and save costs?

No description

13 april 2012
09:15 - 10:00
SQLAdria Seminar - Ljubljana 2012 V10 Migration Planning and Experiences?

No description.




SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2024

VODICE -  10th - 13th June 2024