Peter Hartmann's Blog (11)

Latest LOAD Likes!


Assume the following scenario:

  1. Application delivers files as LOAD input for a partitioned table space which contains already data. The files have a naming convention, e.g. name.IN01, …IN02 etc., which means records from file IN01 go into partition 01 etc. Unfortunately, some records are not assignable by the application, so there is an extra file named IN99 with…

Added by Peter Hartmann on July 29, 2020 at 13:37 — No Comments

AUTOBIND - Demystified - 2


AUTOBIND is a very useful automation instrument inside the Db2 engine.

Recently there are 2 enhancements in this area. For the first enhancement refer to my blog post.

The second enhancement is described in this blog post and was introduced by…


Added by Peter Hartmann on April 17, 2020 at 7:38 — No Comments

Db2 for z/OS support of z15 and z/OS 2.4


Is maintenance needed in Db2 for z/OS (V11 or V12) for a migration to

- the current hardware z15

- or the current operating system z/OS 2.4 ?

As of today there are no APARs/PTFs needed to tolerate such a migration.


The following…


Added by Peter Hartmann on November 19, 2019 at 7:55 — 2 Comments

Db2 and JCL 72 characters


Sometimes it is useful to generate JCL executable code for //SYSIN via SQL mass operations, e.g. change specific tables from one option to another. If the result row fits into one JCL line with a length of 72, then all is fine. If the line must be split, then the question comes up: How to split?

Here is a solution for commands (like REBIND PACKAGE), SQL (like ALTER TRIGGER) or…


Added by Peter Hartmann on August 28, 2019 at 18:39 — 1 Comment

AUTOBIND – Demystified – 1


AUTOBIND is a very useful automation instrument inside the Db2 engine.

Suppose you change the definition of the table or index and these changes have impact on the dependent package, the static SQL package is marked as invalid,…


Added by Peter Hartmann on August 20, 2019 at 19:29 — No Comments

APPLCOMPAT and Advanced Triggers

If you think you know all about APPLCOMPAT, then please read this!


Advanced triggers introduced in V12 allow SQL PL statements and this opens “SQL only applications” to triggers. There is reduced need to call a stored procedure,…


Added by Peter Hartmann on August 7, 2019 at 11:13 — No Comments

Group Buffer Pool - Changes by PH13045

Level setting:

A Db2 group buffer pool (GBP) consist of two parts:

1) Directory entries

2) Data entries

For each data entry there must be an associated directory entry in the GBP.

A directory entry can exist without a data entry in the…


Added by Peter Hartmann on July 30, 2019 at 12:27 — 2 Comments

Function level V12R1M504 and e.g. archive tables


With APPLCOMPAT V12R1M504 on e.g. SPUFI or DSNTEP2, one can no longer create segmented or classic partitioned table spaces. See knowledge center for this restriction.

A small marginalia is behind this restriction, if this is combined with another…


Added by Peter Hartmann on July 19, 2019 at 9:57 — 1 Comment

RUNSTATS sampling enhancements


One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.

The challenge is to balance the CPU resources used by RUNSTATS to calculate column cardinalities with high accuracy…


Added by Peter Hartmann on July 17, 2019 at 10:38 — 1 Comment

Retrieval of current DSNZPARM and DSNHDECP settings


With DB2 Version 9.1 for z/OS a new system supplied stored procedure SYSPROC.ADMIN_INFO_SYSPARM was delivered. As the name suggests, this routine can be called to obtain the current settings of the Db2 subsystem parameters (DSNZPARM) and the…


Added by Peter Hartmann on July 16, 2019 at 8:04 — 6 Comments

Asynchronous cross-invalidation (XI) for coupling facility (CF) cache structures, e.g. Db2 for z/OS group buffer pools (GBP)

Description of the new feature:

When Db2 in a data sharing environment writes a changed page to the GBP the same page in the buffer pool(s) of the other member(s) must be invalidated to avoid back level data access in this/these member(s). This invalidation is done by the cross invalidation (XI) feature which is a key functionality of data sharing and controlled by coupling facility…


Added by Peter Hartmann on July 12, 2019 at 7:57 — No Comments

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.


Introducing IBM Db2 for z/OS Developer Extension for Microsoft Visual Studio Code

Started by Calene Janacek in Application Development and DB2 Jul 30. 0 Replies

We are excited to announce that the first iteration of IBM Db2 for z/OS Developer Extension is available now as a free downloadable extension in the…Continue

QMF Governor

Started by Maitena Gallastegi Ginea in Application Development and DB2. Last reply by Maitena Gallastegi Ginea Jul 30. 4 Replies

Hi,We are using QMF Governor to limit the QMF queries of users.We have configured correctly and it is working OK. We want to get statistics of those queries canceled by QMF Governor but we are not able to discover where that information is stored.…Continue

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service