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?
 
 
 

Events

Latest Activity

2 events by Surekha Parekh were featured
Jan 12
Surekha Parekh updated an event

Modernize IBM Z Apps for Hybrid Cloud using APIs at webcast

January 11, 2021 all day
Available on-demand now, this webinar will show you how to provide access to curated, proven and high-performance applications by turning your existing IBM Z® assets into security-rich, consumable and managed APIs. You will also learn some key considerations on how to choose among the numerous API and integration solutions available. Click the link to watch:…See More
Jan 11
francisco venegas liked Surekha Parekh's event Db2 12 Exploiting new functions and Migration Planning PART 1
Jan 11
Mark liked Surekha Parekh's video
Dec 17, 2020
Judith Talavera posted an event

Modernize IBM Z Apps for Hybrid Cloud using APIs at webcast

December 16, 2020 to February 16, 2021
Available on-demand now, this webinar will show you how to provide access to curated, proven and high-performance applications by turning your existing IBM Z® assets into security-rich, consumable and managed APIs. You will also learn some key considerations on how to choose among the numerous API and integration solutions available. Click the link to watch:…See More
Dec 17, 2020
An event by Janttu Lindroos was featured

Finland Db2 User Group (FiDUG) Seminar at IBM Finland

December 10, 2020 from 9am to 5pm
More info will be available later on. Stay tuned.See More
Dec 4, 2020
An event by Michael Strelczuk was featured
Thumbnail

MDUG - Michigan Db2 User Group Seminar at Four Points by Sheraton, Novi

December 9, 2020 from 8:15am to 4pm
Check out our MDUG web site for upcoming Seminar details and past Seminar presentations, etc.:http://www.mdug.org/New to MDUG?Please see content underHome About MDUGFor Seminar Reservations, please review the MDUG site content under…See More
Dec 4, 2020
An event by Surekha was featured
Thumbnail

Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the lab at http://ibm.biz/MoTownsend_IBM2020

December 7, 2020 from 11am to 12pm
Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the labIDUG EMEA 2020 Spotlight session Available today on replay  http://ibm.biz/MoTownsend_IBM2020 Db2 12 for z/OS® took Db2 to a new level, by extending the core capabilities and empowering the future. IBM extended the core with new…See More
Dec 4, 2020
Jonathan Sloan posted an event

IBM Z and IBM Cloud Pak for Data - Better Together at Webcast - East Coast U.S. time zone

December 3, 2020 from 11am to 12pm
Register at http://ibm.biz/IBMZandBetterTogetherWoD.IBM Cloud Pak for Data is a fully integrated data and AI platform that modernizes how businesses collect, organize and analyze data and infuse AI throughout their organization. And now IBM has introduced IBM Cloud Pak for Data on IBM Z, a highly secure private cloud for your enterprise data that allows you to adapt, transform and compete more effectively. Join this webcast to learn how IBM…See More
Dec 4, 2020
Surekha posted an event
Thumbnail

Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the lab at http://ibm.biz/MoTownsend_IBM2020

December 7, 2020 from 11am to 12pm
Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the labIDUG EMEA 2020 Spotlight session Available today on replay  http://ibm.biz/MoTownsend_IBM2020 Db2 12 for z/OS® took Db2 to a new level, by extending the core capabilities and empowering the future. IBM extended the core with new…See More
Dec 4, 2020
Dragica Smintic liked Mateja Jankovič's event SQLAdria Virtual Event
Nov 25, 2020
Jonathan Sloan posted an event

IBM Z and IBM Cloud Pak for Data - Better Together at Webcast - East Coast U.S. time zone

December 3, 2020 from 11am to 12pm
Register at http://ibm.biz/IBMZandBetterTogetherWoD.IBM Cloud Pak for Data is a fully integrated data and AI platform that modernizes how businesses collect, organize and analyze data and infuse AI throughout their organization. And now IBM has introduced IBM Cloud Pak for Data on IBM Z, a highly secure private cloud for your enterprise data that allows you to adapt, transform and compete more effectively. Join this webcast to learn how IBM…See More
Nov 23, 2020
Massimo Verzì liked Adrian Collett's group DUGI - Db2 User Group Italia
Nov 20, 2020
Profile Icon via Twitter
Enjoy complimentary visit #IBM Expo at #IDUGDb2 EMEA 2020. Virtual Expo is available 24x7 - check out our compli… https://t.co/pAqtzMLvfm
TwitterNov 19, 2020 · Reply · Retweet
Carol Davis-Mann posted a blog post

DB2 v11.5.4 REST API – Part One Setup and Configuration

By James CockayneEnabling clients to interact via HTTP GET/POST requests the REST API functionality provides clients a lightweight, modern interface to data stored in DB2 databases.  In this series we look at how to get started with the REST API from the DBA’s perspective, starting in part one with how to get the service up and running.…See More
Nov 18, 2020
Roberto S Chirinos liked Surekha's blog post What year was IBM Db2 invented?
Nov 17, 2020

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

Forum

Replaying past database activities

Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17, 2020. 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

Db2 is developer inclusive and preview of Db2 11.5.5

Started by Kip in What's hot ? Nov 4, 2020. 0 Replies

This digital event examines how enterprises can become smarter with a data management system that is developer-inclusive. During this session, participants will get to learn how Db2 integrates with a broad array of programming languages, employs…Continue

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service