Paul McWilliams's Posts (28)

Sort by

Db2 for z/OS Development is offering a week-long Db2 for z/OS Master Class, led by Distinguished Engineer, John Campbell, for experienced Db2 for z/OS System Engineers and Database Administrators. During this class, he will discuss the most common issues related to continuous availability and speed of recovery in Db2 for z/OS environments, and will share proven best practices to exploit the full power of Db2 for z/OS and IBM Z mainframes. He will also provide a deep dive on how to monitor and tune Db2 for z/OS system and transaction performance using Db2 Statistics and Accounting traces.

This is a CLIENT-ONLY course and client participation is BY INVITATION only.

There will only be two offerings of the Db2 for z/OS Advanced Class in 2022 and seating is very limited. 

  • Monday, June 20, 2022, (9:00 am) to Friday, June 24, 2022, (2:30 pm) British Standard Time (BST) 
  • Monday, September 19, 2022, (9:00 am) to Friday, September 23, 2022 (2:30 pm) Pacific Time (PT)

 

For more details and to register, see https://ibm.biz/db2zos-master-class-2022

Read more…

Db2 for z/OS Development is again offering a week-long virtual Db2 for z/OS Master Class,led by Distinguished Engineer,John Campbell, for experienced Db2 for z/OS System Engineers and Database Administrators. This is a fee based class costing US$2500 per person.

During this class, John will discuss the most common issues related to continuous availability and speed of recovery in Db2 for z/OS environments, and will share proven best practices to exploit the full power of Db2 for z/OS and IBM Z mainframes. He will also provide a deep dive on how to monitor and tune Db2 for z/OS system and transaction performance using Db2 Statistics and Accounting traces. For more details about the agenda of the class, please refer to the Curriculum section below.

This is a CLIENT-ONLY course and client participation is BY INVITATION only.

Clients who take part in this virtual online Master Class will benefit from:

  • Small virtual class size - for a more intimate learning experience
  • Virtual interactions with the Db2 for z/OS Development SWAT team- opportunity to partner with SWAT team members for personal mentoring
  • Networking- opportunity to build lasting relationships with other clients who understand the power of Db2 for z/OS

There will only be two offerings of the Db2 for z/OS Master Class in 2021.

If you are a client who is interested in participating in this class, please fill in and submit the application form.

Alternatively, if you are an IBMer and you have a client who is interested in signing up for the class, you can fill in and submit the application form on their behalf (one form per company).

Online Course Dates

  • Monday, June 21, 2021, (9 am) to Friday, June 25, 2021, (2:30 pm) BST
  • Monday, September 27, 2021, (8:30 am) to Friday, October 1, 2021 (2:30 pm) EST

Application Submission Deadline

Applications for the online class will be reviewed and acceptance notices will be emailed. A registration link with payment instructions will be included in the invitation. If you have any questions, please contact Dorothy Lin (dclin@us.ibm.com)

Last day to submit an application and register is two weeks prior to class start.

Meeting Link

Online class details and links will be emailed a week prior to class start.

Requirements

Client participants must have at least 1 of the following (or equivalent experience level):

  • IBM Certified System Administrator - Db2 for z/OS
  • IBM Certified Database Administrator - Db2 for z/OS

Cost

  • $2,500 USD per client participant
  • A registration link with payment instructions will be included in the invitation.

Application Form

Click here to submit the application: Db2 for z/OS Master Class Application Form

Curriculum

Module I - Continuous Availability

  • Continuous availability vs. Fast failover
  • Coupling Facility structure duplexing
  • Automated restart
  • Multiple Db2 data sharing groups
  • Multi-site data sharing group and extended distance
  • Preventative software maintenance
  • Application considerations

Module II - Special Considerations for WLM, CICS and DDF

  • WLM policy
  • CICS/Db2 interface
  • Distributed access to Db2 for z/OS

Module III - Speed of Recovery

  • Disaster Recovery
  • Db2 log-based recovery

Module IV - System Performance Monitoring and Optimization using the Db2 Statistics Traces

  • Data collection
  • Db2 system address space CPU time
  • EDM pools
  • Dataset
  • open/close
  • Log activity
  • Lock/latch
  • Memory management
  • Buffer pools
  • Data sharing performance
  • RDS sort
  • DDF activity
  • Miscellaneous

Module V - Understanding Db2 for z/OS Accounting Information

  • Data collection
  • Where is a Db2 transaction spending its time?
  • Most common reasons for large suspension times
  • Additional accounting info

Instructor Profiles

John Campbell is an IBM Distinguished Engineer reporting to the Vice President of zAnalytics Development at the IBM Silicon Valley Lab and is the technical leader of the world wide Db2 for z/OS Development SWAT Team. He has extensive experience of Db2 for z/OS 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.

Michal Bialecki is a member of the DB2 z/OS Development SWAT team where he supports and advocates for customers across various industries and geographies. Prior to joining IBM, Michal worked for four years as a system / application DBA for a Social Security government customer in Poland where he assisted other customers with DB2 z/OS. For the last 15 years, Michal worked for the Db2 for z/OS organization in support & development at IBM Silicon Valley Lab (SVL). He is a former speaker at IDUG EMEA conference - Berlin 2012/ Barcelona 2013 / Dublin 2015 / Insight 2015 / Lisbona 2017/ Malta 2018/ Rotterdamm 2019 and also a few DB2 user run events (csDUG, GSEfr) and webcasts. Michal is an IBM SVL representative and frequent speaker at Poland DB2 User Group.

Adrian Burke is an Open Group Master Certified IT Specialist and member of the Db2 for z/OS Development SWAT team. In this role as a technical advocate for Db2 for z/OS, Adrian conducts consulting and educational workshops, Db2 health checks, and availability studies for Db2 for z/OS customers. In his previous role as a Db2 Advisor in the Western U.S. Adrian supported numerous Db2 for z/OS customers from a technical sales perspective, delivering migration and performance workshops as well as consulting and education. He has spoken at numerous regional user group meetings as well as IDUG in the past few years. He is also the author of an IBM Redbook dealing with Db2 system and application performance.

Anthony Ciabattoni has over 25 years of professional Db2 for z/OS experience with expertise in high available 24/7 high transaction rate data sharing environments. He has a strong knowledge base in Db2 data sharing, Db2 system performance as well as high available systems. His experience covers DBA experience, Db2 system experience and experience in architecting a well tuned Db2 environment. Prior to joining the Db2 for z/OS Development SWAT team, Anthony was a Db2 Technical Advisor in the Db2 Tools Development lab and a Db2 Information Champion. He also spent many years as a high-end customer participating in the Db2 engine Customer Advisory Council. 

Read more…

By Dorothy Lin and Paul McWilliams.

Db2 for z/OS development is now offering two Db2 for z/OS Advanced Class sessions for 2020—previously scheduled  at IBM Hursely and IBM Silicon Valley Laboratory—as virtual courses. Update: Due to the impact of the global pandemic and resulting travel restrictions, the cost for this course is reduced to $2000.

As before, the invitation-only virtual Db2 Advanced Class sessions are
led by IBM Distinguished Engineer John Campbell, for clients who are advanced Db2 for z/OS system or database administrators with the following certifications or equivalent experience:
  • IBM Certified System Administrator - Db2 for z/OS
  • IBM Certified Database Administrator - Db2 for z/OS

John will share proven best practices to exploit the full power of Db2 for z/OS and IBM Z mainframes, and he will provide a deep dive on how to monitor and tune Db2 for z/OS system and transaction performance using Db2 Statistics and Accounting traces. For more details of the subjects covered in the course, see the curriculum section below.

Clients who take part in this Db2 Advanced Class will be able to participate in the following:

  • Small virtual class size - for a more intimate learning experience
  • Virtual interactions with the Db2 for z/OS Development SWAT team - partner with SWAT team members in smaller, personal groups
  • Networking - build lasting relationships with other clients who understand the power of Db2 for z/OS

Schedule: Just two sessions are offered for 2020:

  • Monday, June 22, 2020, (9 am GMT+1) to Friday, June 26, 2020, (2:30 pm)
  • Monday, September 28, 2020, (8:30 am GMT-7) to Friday, October 2, 2020 (2:30 pm)

Cost: $2000 USD per client participant

If you are a client who is interested in attending this class, fill in and submit the application form. Applications will be reviewed and acceptance notices will be emailed. A registration link with payment instructions will be included in the invitation.

For more details and the full curriculum list, see our Db2 for z/OS News from the Lab blog entry.


To always get the latest news about Db2 for z/OS from the IBM lab, sign in and subscribe at: http://ibm.biz/db2znews-subscribe

Read more…
Update: Due to the global pandemic and resulting travel restrictions, this course is now offered as a virtual online course, and the cost to attend is also reduced to $2000. For more information, see the blog entry.

The invitation-only virtual DB2 Advanced Class sessions are led by IBM Distinguished Engineer John Campbell, for clients who are advanced Db2 for z/OS system or database administrators with the following certifications or equivalent experience:
  • IBM Certified System Administrator - Db2 for z/OS
  • IBM Certified Database Administrator - Db2 for z/OS

John will share proven best practices to exploit the full power of Db2 for z/OS and IBM Z mainframes, and he will provide a deep dive on how to monitor and tune Db2 for z/OS system and transaction performance using Db2 Statistics and Accounting traces. For more details of the subjects covered in the course, see the curriculum section below.

Clients who take part in this Advanced Class will be able to participate in the following:

  • Small virtual class size - for a more intimate learning experience
  • Virtual interactions with the Db2 for z/OS Development SWAT team - partner with SWAT team members in smaller, personal groups
  • Networking - build lasting relationships with other clients who understand the power of Db2 for z/OS

Just two sessions are offered for 2020:

  • Monday, June 22, 2020, (9 am GMT+1) to Friday, June 26, 2020, (2:30 pm)
  • Monday, September 28, 2020, (8:30 am GMT-7) to Friday, October 2, 2020 (2:30 pm)

For details, see our new blog entry: Virtual Db2 for z/OS Advanced Classes now offered for 2020


To always get the latest news about Db2 for z/OS from the IBM lab, sign in and subscribe at: http://ibm.biz/db2znews-subscribe


Read more…

Perhaps you've seen news about the sunset of the IBM developerWorks community platform at the end of 2019. I am happy that I can now share how you can continue following the latest news from the IBM experts who design, build, test, and support Db2 for z/OS, here in the new Db2 for z/OS Community.

Don't miss any Db2 for z/OS News from the Lab blog entries. Join the new community and subscribe today! For the full story, see: http://ibm.biz/db2znews-moved

Read more…

In Db2 12, you can transfer the ownership of database and system objects online if you are the owner of the object or have SECADM authority. You can use TRANSFER OWNERSHIP statements to transfer ownership of an objects to another authorization ID or a role, without any application changes.

For the full story on this new SQL capability, see the new Db2 12 GA feature series post, Transferring ownership of Db2 objects by Gayathiri Chandran, over in the Db2 News from the Lab blog.


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @DB2zLabNews

Read more…

Announcing Db2 12 function level 505!

We're proud to announce that Db2 12 for z/OS function level 505 becomes available for activation when you apply APAR PH09191. Function level 505 introduces the following new capabilities in Db2 12 for z/OS.

  • Improved Hybrid Transactional Analytical Processing performance
  • Rebind phase-in for packages being used for execution
  • New built-in functions for encryption and decryption using key labels
  • Improved support of the DECFLOAT data type
  • Improved RUNSTATS performance with automatic page sampling by default
  • Temporal and archive transparency support for WHEN clause on triggers

For the full story, see "Announcing Db2 12 function level 505!" over in the Db2 for z/OS News from the Lab blog.


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews
Read more…

Partition-by-range (PBR) table spaces with relative page numbers (RPN) in Db2 12 for z/OS improve the usability, manageability, scalability, and availability for the largest tables in Db2 environments.


Read the full story in the Db2 for z/OS News from the Lab blog:
http://ibm.biz/BdzPr4


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews

Read more…

In Db2 12, APAR PH08482 simplifies the process of activating new function levels without impacting existing JDBC, CLI, and .net applications, and it possibly reduces the coordination effort required between Db2 administrators and application programmers, for activating new application compatibility (APPLCOMPAT) levels. With this APAR applied, Db2 12 assumes that the IBM Data Server Drivers at the following levels or higher fully support all new SQL capabilities:

  • IBM Data Server Driver for JDBC and SQLJ Versions 3.72 and 4.22, or later
  • IBM Data Server Driver for ODBC and CLI Version 11.1 Modification 2 Fix Pack 1 or later
  • Db2 for Linux, UNIX, and Windows, Version 11.1 Modification 2 Fix Pack 2, or later


Read the full story over in the Db2 News from the Lab blog: https://ibm.biz/Bdzjf4


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews


Read more…

By Sueli Almeida and Paul McWilliams.

We recently published a sample Db2 software services template. As a service provider, you can use it to create services (DBaaS) to rapidly provision from scratch one or multiple standalone Db2 subsystems. You can also later deprovision the provisioned Db2 subsystems, in IBM Cloud Provisioning and Management for z/OS.


The sample Db2 software services template is intended for service providers, who configure and make the Db2 system provisioning services available to the consumers of the service in their shops.


The sample template provisions non-data-sharing Db2 12 for z/OS subsystem instances in a “typical Db2 configuration.” For more information, about the configuration of the provisioned subsystems, see "About the sample Db2 software service template".
 
For a detailed instructions, and to download the sample Db2 software services template, see the GitHub repository: Db2ZTools/DevOps/Db2SystemServices/Db2ProvisionSystemNonDS/

Sueli Almeida is Db2 for z/OS DevOps and Cloud Provisioning Technical Leader and Paul McWilliams is an Information Developer for Db2 for z/OS documentation.


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews
Read more…

Announcing Db2 12 function level 504

We're proud to announce Db2 12 function level 504!

Function level 504 (activation enabled by APAR PH07672) introduces the following new capabilities in Db2 12 for z/OS:

  • IBM z14 Huffman compression
  • Prevent the creation of new deprecated objects
  • New support for built-in functions by pass-through to IBM Db2 Analytics Accelerator
  • New SQL syntax alternatives for certain special registers and NULL predicates

For more about these new capabilities in Db2 12, see Announcing Db2 12 function level 504!

For more information about the new capability to prevent new deprecated objects, see the Q&A with IBM Distinguished Engineer Chris Crone in You can prevent the creation of new deprecated objects in Db2 12 function level 504.


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @DB2zLabNews

Read more…

Got millennials?

It can be challenging to train a new generation of Db2 for z/OS users whose model of learning no longer includes days of reading long “manuals.” But they have energy, enthusiasm and lots of new ideas that you want to foster. Why not try teaching them with short videos?

Check out this Db2 Utilities video, specifically aimed at orienting someone who is new to Db2 for z/OS and knows little or nothing about Db2 Utilities.

We’d like your feedback! Are these kinds of videos useful? What topics do you want to see covered for the upcoming generation of DB2 for z/OS programmers and administrators? Or for those that have been using Db2 for z/OS for years?

Keep in mind that these videos are not long in-depth conference presentations. They are meant to be short focused topics that can be covered in 5 minutes or less. Think “How do I use SPUFI?” or “What is data sharing?” or “How does this new utility option work?”

Please send your comments to db2zinfo@us.ibm.com. We’d love to hear from you!!

 


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews
Read more…

Db2 for z/OS APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11. The new message reminds you to convert pagesets to the extended 10-byte RBA or LRSN format, to avoid outages that might occur if Db2 reaches the 6-byte logging limit. Read the full story.


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @DB2zLabNews

Read more…

Version 6 of the SQL Reference for Cross-platform Development  is available now! 

Developers who build applications that must be portable across the IBM Db2 family of database products can use the SQL Reference for Cross-platform Development to ensure the portability of the SQL in their applications.  It describes the common set of SQL language features that are supported across all platforms by the Db2 family. 

For the full story, see: https://ibm.biz/BdYg7n


Always get the latest news about  Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews

Read more…

 

For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out the blog posts:

For the full details, see IBM Knowledge Center:


Always get the latest news about  Db2 for z/OS from the IBM lab! How to subscribe
Follow us on Twitter: @DB2zLabNews

Read more…

Back in Version 9, Db2 for z/OS introduced minimal support for MERGE statementst, only providing an upsert capability with limited functionality. Db2 12 for z/OS enhances MERGE statements to be consistent with the SQL 2016 Core standard, as well as compatible with the Db2 family.

For the full story, see Enhanced SQL MERGE - a Db2 12 greatest hit with John Campbell.


Always get the latest news about  Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @DB2zLabNews

Read more…

Db2 for z/OS Master Classes

The first Db2 for z/OS Master Class to be hosted by IBM Europe was recently held at IBM Hursley. The next invitation-only session at IBM Silicon Valley Laboratory is already full, but future session are planned.  For the full story, see Db2 for z/OS Master Classes.


Always get the latest news about  Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @DB2zLabNews

Read more…

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in New SQL pagination syntax - a Db2 12 greatest hit with John Campbell.


Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @Db2World and @DB2zLabNews

Read more…