Loading Events

« All Events

  • This event has passed.

Tridex March 2020 – CANCELED

19. March 2020

TRIDEX – Tri-State Db2 Technology Exchange in New York, NY, USA

DUE TO THE CORONA VIRUS (COVID-19), THE TRIDEX MEETINGS 2020 HAVE BEEN CANCELED UNTIL JUNE 2020  – Next TRIDEX meetings on June 4th and June 18th.

SEGUS & SOFTWARE ENGINEERING present:

Db2 for z/OS Know 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.)


Our Space AssuranceExpert for Db2 z/OS monitors (critical) Db2 limitations in real-time


Speaker biography

Roy Boxwell has more than 34 years of experience in MVS, OS/390, and z/OS environments – 31 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real time database maintenance solutions. He is also an active participant, speaker and contributor on the IDUG Db2 Listserv and sends out a monthly Db2 z/OS Newsletter.

Details

Date:
19. March 2020
Event Categories:
,
Website:
https://www.tridex.org/event/tridex-db2-zos-march-2020/

Venue

IBM New York
590 Madison Ave, Room 1219, 12th Floor
New York, NY 10022