Db2 for z/OS Systemverwaltung 2020 Herbsttagung

• Db2 for z/OS – k-no-w your limits   >> DOWNLOAD <<
• What is Zowe going to do for us?   >> DOWNLOAD <<

Db2 for z/OS – k-no-w your limits

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 MAXPARTITONS 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)
• 3. COPYPOOL
• 4. PBGs & MAXPARTITIONS 5. SEQUENCES and Numeric Primary Key usage 6. Abstract limit of Db2 (DBATs etc.)

What is Zowe going to do for us?

In this presentation I will show how we went from 0 – 100 with ZOWE.

When I logged into the browser interface of Zowe the first time, I was welcomed by a shiny blue desktop with a task bar at the bottom and a menu button like you know from several PC operating systems.

Supposedly, I saw the future of mainframe software development here. Since I had heard rumors that ZOWE was to be announced at the next IDUG, I began looking for Db2 in that pretty new world.

Join me on my journey to my first Db2 z/OS App within the Zowe ecosystem.

• Pre-reqs you have to get right
• Knowledge you must have
• What we did and How we did it
• How it looks today (Tomorrow will be different!)