Peter Hartmann
  • Male
  • Frankfurt
  • Germany

Peter Hartmann's Friends

  • Thomas Singer
  • Fabian Russell
  • Karthik
  • Bruno Affonso Lunardi
  • Kim Olsen
  • Michael Childs
  • Sudheer Krishna
  • Mike Jett
  • Aymeric Affouard
  • Khadija Souissi
  • Christer Johansson
  • Norbert Jenninger
  • Manuel Gomez Burriel
  • Mark Rader
  • Toine Michielse

Gifts Received


Peter Hartmann has not received any gifts yet

Give a Gift


Peter Hartmann's Page

Profile Information

Why join "The World of DB2"?
Looking for "one stop shopping" for information, Looking for education, Looking for networking opportunities, Looking for news blogs and podcasts, Looking for information on local user groups
What information or education would be useful to you?
High Availability and Disaster Recovery
Are you a member of IDUG (International DB2 User Group)?
Are you a member of a Regional User Group (RUG)? If so, which one?
What best describes your job role?
IBM Employee / Business Partner, Systems Programming

IBM Impressum

IBM Impressum:

"views are my own"

Peter Hartmann's Blog

Latest LOAD Likes!

Posted on July 29, 2020 at 13:37 0 Comments


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…

AUTOBIND - Demystified - 2

Posted on April 17, 2020 at 7:38 0 Comments


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…


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

Posted on November 19, 2019 at 7:55 2 Comments


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…


Db2 and JCL 72 characters

Posted on August 28, 2019 at 18:39 1 Comment


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…


AUTOBIND – Demystified – 1

Posted on August 20, 2019 at 19:29 0 Comments


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


Comment Wall (3 comments)

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

At 8:43 on July 16, 2009, Toine Michielse said…
Hi Peter,

Ich arbeite im Moment noch bei UBS ( DB2 z/OS infrastructure consulting). (email:

At 8:15 on July 16, 2009, Toine Michielse said…
Hi Peter,

Wie geht's dir. Hoffe du weiss noch wer ich bin. Wir haben uns einige malen bei DB getroffen.

Toine Michielse
At 8:58 on June 12, 2009, Christian Daser said…
wo ist dein bild?

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


Complimentary IDUG EMEA 2020 Expo Pass for World of Db2 Members

Started by Surekha in What's hot ? on Wednesday. 0 Replies

Complimentary IDUG EMEA 2020 EXPO Pass We are offering a complimentary IDUG EMEA 2020 Expo Pass for Db2 users to visit the IBM Expo at the IDUG EMEA 2020 Conference. Basically this means that IDUG have opened the IBM Expo for non IDUG registered…Continue

Tags: Db2z, LUW, Db2, IDUG

Replaying past database activities

Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17. 1 Reply

I would need to know who modified table data on a certain day.I do have my backups and database logs available.DB2audit was however not activated at this point.How would i  be able to access this information?Continue

Tags: #DataAccess

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service