Wisconsin DB2 Users Group (WDUG)

Information

Wisconsin DB2 Users Group (WDUG)

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.

Website: http://wdug.com
Location: Milwaukee, WI
Members: 14
Latest Activity: Oct 30, 2019

WDUG Meeting March 11, 2020

Meeting Agenda – March 11, 2020

Register at: https://www.wdug.com/event-3745744


8:45-  9:15
Registration – Coffee, juice and rolls 

DB2 for z/OS

9:15 - 10:30 Db2 for z/OS and data set encryption (Mark Rader, IBM)

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:30-2:45 Break

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.
Presentation items:
1. DSSIZE or PIECESIZE among other basic simple things
2. Linear Dataset limits (32 for segmented spaces, 254 for LOB)
3. COPYPOOL
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

Speakers:

  • Chris Drexelius

    Chris Drexelius is a Senior Software Engineer at the IBM Silicon Valley Laboratory and product owner for storage and compression for Db2 with BLU Acceleration with deep knowledge in the areas of storage, compression, memory management, indexing, and I/O processing. Db2 with BLU Acceleration is the common database engine technology used in Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS) and Db2 Big SQL. Chris has developed features for dictionary evolution, automatic dictionary creation (ADC), prefetching, and Db2’s XML datatype support.
  • Sanoop Nambiar

    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.

Presentation sessions:
  • 9:15 - 10:30 Unboxing Db2 v11.5
    Db2 v11.5 is now available!! This cutting-edge release continues to add important performance and storage enhancements plus new features that can be leveraged by your next generation applications. Are you interested in learning about these latest and greatest advances plus a peek at future items? If so, please plan to attend this session!
  • 10:30 - 10:45 Break
  • 10:45 - 12:00 What's New with BLU in Db2 11.5
    Db2 with BLU Acceleration provides industry leading performance for analytical applications running complex queries through its advanced column-organized table technology. Db2 11.5 continues to extend the reach of BLU capability to more Db2 features so that its superior performance can be applied to a broader range of applications. Additionally, BLU storage and compression technology has been enhanced to make it more effective and even easier to use. Attend this session to learn how these enhancements can allow BLU to be used for even more applications within your business.
  • 12:00 - 1:15 Lunch - On your own
  • 1:15 - 02:30 Db2 BLU Deep Dive
    Db2 with BLU Acceleration provides industry leading performance for analytical applications running complex queries through its advanced column-organized table technology. This session explores the Db2 BLU architecture and how its features combine to provide easy and effective access to data. We will discuss the core Db2 BLU technology as well as new features included in Db2 11.5 plus future items in the pipeline. Attend this session to learn what Db2 BLU can do for your business.
  • 2:30-2:45 Break
  • 2:45–4:00 Db2 BLU: Maximizing the Potential of Data
    Db2 with BLU Acceleration provides industry leading performance for analytical applications running complex queries through its advanced column-organized table technology. This session will provide you with tips, tricks, and best practices to manage and access your data effectively using Db2 BLU. This includes maximizing compression, minimizing storage space, and increasing performance while populating tables and executing analytical queries. Attend this session to learn how to maximize the effectiveness of Db2 BLU.

Discussion Forum

This group does not have any discussions yet.

Comment Wall

Add a Comment

You need to be a member of Wisconsin DB2 Users Group (WDUG) to add comments!

 
 
 

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service