Peter Hartmann
  • Male
  • Frankfurt
  • Germany
Share

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

Gift

Peter Hartmann has not received any gifts yet

Give a Gift

 

Peter Hartmann's Page

Latest Activity

HEVERSON RIBEIRO CAMPELO liked Peter Hartmann's blog post Db2 for z/OS support of z15 and z/OS 2.4
Aug 11, 2020
Peter Hartmann posted a blog post

Latest LOAD Likes!

Introduction:Assume the following scenario: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 records for all partitions.The application wants to have in a description column the value “Unassigned” if the record is…See More
Jul 29, 2020
Rüdiger Schmitt liked Peter Hartmann's blog post AUTOBIND - Demystified - 2
Apr 27, 2020
Dragica Smintic liked Peter Hartmann's blog post AUTOBIND – Demystified – 1
Apr 22, 2020
Dragica Smintic liked Peter Hartmann's blog post AUTOBIND – Demystified – 1
Apr 22, 2020
Günther Paschke liked Peter Hartmann's blog post AUTOBIND - Demystified - 2
Apr 22, 2020
Günther Paschke liked Peter Hartmann's blog post AUTOBIND – Demystified – 1
Apr 22, 2020
Peter Hartmann posted a blog post

AUTOBIND - Demystified - 2

Introduction: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 PH15896.…See More
Apr 17, 2020
Peter Hartmann liked Peter Hartmann's blog post Db2 for z/OS support of z15 and z/OS 2.4
Dec 16, 2019
Martin Reiser liked Peter Hartmann's blog post Db2 for z/OS support of z15 and z/OS 2.4
Dec 16, 2019
A blog post by Peter Hartmann was featured

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

Toleration: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.Exploitation:The following key z15 features are exploited by Db2 for z/OS:- Faster SSL/TLS handshake performance on IBM z15 with Crypto Express7S compared to z14 with Crypto Express6S (no change in Db2 required)- System Recovery Boost, especially for the transaction/batch…See More
Dec 16, 2019
Peter Hartmann posted a blog post

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

Toleration: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.Exploitation:The following key z15 features are exploited by Db2 for z/OS:- Faster SSL/TLS handshake performance on IBM z15 with Crypto Express7S compared to z14 with Crypto Express6S (no change in Db2 required)- System Recovery Boost, especially for the transaction/batch…See More
Nov 22, 2019
A blog post by Peter Hartmann was featured

Db2 and JCL 72 characters

Introduction: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 utilities (like RUNSTATS).72 line split:Recursive SQL with common table expression is the solution.Step 1 -…See More
Sep 12, 2019
Rüdiger Schmitt liked Peter Hartmann's blog post AUTOBIND – Demystified – 1
Aug 29, 2019
Peter Hartmann posted a blog post

Db2 and JCL 72 characters

Introduction: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 utilities (like RUNSTATS).72 line split:Recursive SQL with common table expression is the solution.Step 1 -…See More
Aug 28, 2019
Peter Becker liked Peter Hartmann's blog post AUTOBIND – Demystified – 1
Aug 26, 2019

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)?
Yes
Are you a member of a Regional User Group (RUG)? If so, which one?
Germany
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

Introduction:

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

AUTOBIND - Demystified - 2

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

Introduction:

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…

Continue

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

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

Toleration:

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.

Exploitation:

The following…

Continue

Db2 and JCL 72 characters

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

Introduction:

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…

Continue

AUTOBIND – Demystified – 1

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

Introduction:

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

Continue

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: antoine.michielse@ubs.com).

Toine
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.

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

Latest Activity

Diego Cardalliaguet liked Diego Cardalliaguet's event EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021
13 hours ago
An event by Diego Cardalliaguet was featured
Thumbnail

EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021 at Video conference

May 18, 2021 from 10am to 4:15pm
13 hours ago
Diego Cardalliaguet posted an event
Thumbnail

EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021 at Video conference

May 18, 2021 from 10am to 4:15pm
13 hours ago
Diego Cardalliaguet liked Surekha Parekh's blog post Register Now Enterprise Data & AI Virtual Symposium - 27th April 2021
14 hours ago
Diego Cardalliaguet liked Surekha Parekh's event 2021 April 27th Enterprise Data & AI Virtual Symposium
14 hours ago
Udo Brede liked Jim Wankowski's blog post Leveraging your Db2 Skills with Big Data
16 hours ago
long lin posted a discussion
18 hours ago
blon sin posted a discussion
yesterday
A blog post by Surekha Parekh was featured
Tuesday
blon sin liked Jim Wankowski's blog post Leveraging your Db2 Skills with Big Data
Monday
Jonathan Sloan liked Surekha Parekh's event 2021 April 27th Enterprise Data & AI Virtual Symposium
Apr 14
A blog post by Surekha Parekh was featured
Apr 14
2 events by Surekha Parekh were featured
Apr 14
Jim Reed liked Umesh J Mehta's event TRIDEX Db2 for z/OS Q22021 Meeting
Apr 13
An event by Umesh J Mehta was featured

TRIDEX Db2 for z/OS Q22021 Meeting at Virtual Event

May 20, 2021 from 9:30am to 1:15pm
Apr 13
Jim Reed liked Manuel Gomez Burriel's event IDUG Db2 North America Virtual Tech Conference
Apr 12

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

Forum

who opened the scoring from the penalty spot

Started by long lin in What's hot ? 18 hours ago. 0 Replies

fotbollströja barn eget tryck Lionel Messi opened the scoring from the penalty spot, but that was as good as it got for Ronald Koeman's side as Mbappe took over to evoke memories of recent defeats to…Continue

Fact.MR redefines the way

Started by blon sin in What's hot ? yesterday. 0 Replies

New York, April 20, 2021 - The primary reason for the failure of startups is not lack of funding or intense competition. The main reason is "misunderstanding of market demand."Therefore, for start-ups, it is important to thoroughly study the…Continue

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service