IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
The Wisconsin DB2 Users’ Group meets triannually (March, June, & September) at various locations in the vicinity of Milwaukee, Wisconsin.
WDUG is a non-profit organization run by users of the IBM DB2 family of products to promote education and foster communication of DB2 related information to local IT Professionals. All meeting presentations are technical in nature.
Register at: https://www.wdug.com/event-3745744
Registration – Coffee, juice and rolls
DB2 for z/OS
Db2 for z/OS supports data set encryption as part of pervasive encryption on the Z platform. This session discusses the Db2 changes and the roles that participate in encrypting sensitive data. Included in this discussion are the new Db2 features that allow Db2 staff to specify key labels for encryption, as well as positioning data set encryption relative to other options for encrypting Db2 data.
Mark Rader is a Db2 for z/OS specialist in the IBM Washington Systems Center. He has over 36 years of technical experience with IBM, primarily with Db2 for z/OS. He has led many Db2 data sharing implementations and has presented a variety of topics at conferences, including IDUG, SHARE, IBM Technical University and at regional Db2 user group meetings. He has worked closely with Db2 development in delivering the Early Support Programs for Db2 10, Db2 11, and Db2 12. He is an author of redbooks on Parallel Sysplex application considerations, Db2 data sharing, and Db2 for z/OS distributed function.
10:30 - 10:45 Break
10:45 - 12:00 Db2 12: How do I keep up with this stuff ?? (Michael Cotignola, BMC)
We’ll take a quick look at the usual suspects:
Reliability, Availability, Scalability, Security
But… we can’t forget about:
Analytics, Autonomics, Cloud, Mobile, Machine Learning…
12:00 - 1:15 Lunch - On your own
1:15 – 2:30 How Can Db2 DBAs Get Agile ? (Frank Rhodes, BMC)
In this session, Frank will cover:
Understand the need for Db2 for z/OS DBAs to participate in agile deployment of applications.
Discuss how to automate and speed up the process of validating SQL changes before they are promoted to production.
Discuss the issues around schema changes associated with application deployments.
Understand why the communication of outage and impact information is so important.
Discuss the importance of test provisioning for Db2 for z/OS in a DevOps environment.
Frank Rhodes started with BMC Software in 1995. In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products, like BMC AMI DevOps for Db2.
Prior to BMC, Frank worked as a Systems Programmer for IBM in support of NASA JSC’s administrative processors. He supported installation and maintenance of MVS products and oversaw implementing Automated Operation for IBM’s internal systems as well as NASA’s systems.
2:45 - 4:00 Know your limits! (Ulf Heinrich, SEGUS)
In this presentation I will show and explain the current number of limits within Db2 on z/OS starting with relatively basic simple things like DSSIZE or PIECESIZE. Moving on to Linear Dataset limits (32 for Segmented spaces, 254 for LOB ) we then will have a quick look at how the COPYPOOL is looking before diving off to the world of PBGs where you must be aware of MAXPARTIONS among other things. Then we will review SEQUENCES and Numeric Primary Key usage before finally delving into the abstract limit of Db2 within the Db2 engine including DBATs etc.
1. DSSIZE or PIECESIZE among other basic simple things
2. Linear Dataset limits (32 for segmented spaces, 254 for LOB)
4. PBGs & MAXPARTITIONS
5. SEQUENCES and Numeric Primary Key usage
6. Abstract limit of Db2 (DBATs etc.)
Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24x7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real world recovery pressure. His activities cover EMEA, as well as North America through SE’s U.S.
subsidiary, SEGUS Inc. As a member of SE’s Request Board he’s working closely with customers and the development labs.
DB2 for LUW
Sanoop Nambiar is an advisory software engineer at the IBM Silicon Valley Laboratory and one of the technical leaders for Db2 with BLU Acceleration with deep knowledge in the areas of storage, compression, and memory management. Db2 with BLU Acceleration is the common database engine technology used in Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 Warehouse on Cloud, and IBM Integrated Analytics System (IIAS). Sanoop has developed features for page-based string compression, reorg table reclaim extents, and dictionary eviction to reduce memory consumption.
This group does not have any discussions yet.
Add a Comment