Category: Db2 space issue

Space monitoring & Space management

Different Db2 space limiting factors are reviewed in this blog issues. Found out explanations and tips to avoid being out of extent :

  • Table/tablespace definition
  • Index/indexspace definition
  • Allocated space
  • Overall space available
  • Number of space extents
  • Minimum number of partitions
  • Sequences
  • Identity columns
  • DOCIDs
  • Numeric Primary Keys

2019-09 A DBA has got to know his limitations

Know the most important Space limitations in Db2 and how to check them to avoid being out of extent thanks to a real-time space monitor small tool

Tagged with: , ,

Machine Learning for Db2 z/OS: Artificial Intelligence – Hype or Reality?

Machine learning for db2 review, now that the Db2 Optimizer has gone all Artificial Intelligent (AI).

Tagged with: ,

2018-11 db2 Numeric Primary Keys: Space, the final frontier?

What do Db2 numeric Primary Keys have to do with space management ?
SMALLINT – INTEGER – DECIMAL – BIGINT…
How to find out which sequences are nearing their physical limit ?

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: , , , , ,

2016-10 Discovering hidden recovery problems in the SYSLGRNX

A query to read the SYSLGRNX This month I want to have a look inside the SYSLGRNX – Not just for fun but actually to see if I, and you, have a serious RECOVER problem. The Problem began with too

Tagged with: , , , , ,

2016-09 Solving SEQUENCE or space problems in Db2

What do you do if your critical production tablespace reaches its maximum of 32 datasets on a Saturday? Could you actually get the REORG through before prime time starts on Monday morning? I have recently been involved with trialing and

Tagged with: , , , , , ,