Tag: Partition

Partition in db2-z-os,

SIZE Partition in db2-12,

Maximum SIZE, Partition SIZE Limit,

Partition and tablespace in DB2-z-os, Space Management in DB2 12

Saint Louis Db2 Users Group – March 2020

Meet us at the STLDUG – Saint Louis Db2 Users Group, MO, USA – March 11, 2020 and attend our presentation:

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.

Tagged with: , ,

2019-12 Fun with Db2 12 PBR RPN

Avoid runing out of extent during partition in production with the recently enhanced SAX – Space AssuranceExpert thanks to the new PBR – RPN for Db2 12

Tagged with: , , , ,

2018-01 Db2 GETPAGES by Insert

  Troubleshooting on site : how a simple Db2 SQL INSERT statement causes a high GETPAGES rate and how to fix it. One shop I visit had an interesting problem the other day.  I thought I would share it with

Tagged with: , ,

2017-02 Why SIZE still matters in Db2 12

What has changed for space management in Db2 12? How to avoid SIZE limits in Db2 12 like in previous Db2 Releases? How to monitor the maximum possible SIZE of table and index spaces and table and index partitions? SIZE in Db2

Tagged with: , , , , ,