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

A blog post by Surekha Parekh was featured

Hot off the Press! Installing and Configuring IBM Db2 AI for z/OS Version 1.4 An IBM Redpaper publication

Check out this new "Complimentary" Db2 AI for z/OS Version 1.4 Red paper Installation and ConfigurationLearn MoreAbstractArtificial intelligence (AI) enables computers and machines to mimic the perception, learning, problem-solving, and decision-making capabilities of the human mind. AI development is made possible by the availability of large amounts of data and the corresponding development and wide availability of computer systems that can process all that data faster and more accurately than humans can.What happens if you infuse AI with a world-class database management system, such as IBM Db2®? IBM® has done just that with Db2 AI for z/OS (Db2ZAI).Db2ZAI is built to infuse AI and data science to assist businesses in the use of AI to develop applications more easily. With Db2ZAI, the…See More
19 hours ago
Jim Reed updated an event
Thumbnail

Build simple to multifaceted dashboards in QMF for Workstation at Online

July 22, 2021 from 8am to 9am
Today businesses need real time visual dashboards and reports across all their data, including hard to reach data across IBM Z non-relational data sources. QMF for Workstation makes visualizing virtually any data a reality, including IMS, VSAM, Adabas, IDMS and DB2 for z/OS data sources.This session will showcase and demo QMF’s dashboard/application building interface in QMF for Workstation from simple to multifaceted.See More
Jul 21
Carol Davis-Mann posted a blog post

Management Overview: DB2 Continuous Delivery Function Level Upgrades

By Julian StuhlerBackgroundWith the advent of DB2 12 for z/OS, IBM has moved to a more agile approach for delivering new function to DB2 customers, known as “continuous delivery”. Major new releases of DB2 will now happen more rarely, with smaller packets of new functionality being delivered via the routine product maintenance process. This allows IBM to develop and release new features much more frequently, thereby reducing “time to value” – a familiar DevOps message.To allow DB2 customers to absorb this new function in a flexible and efficient way, IBM has also delivered a comprehensive set of capabilities that allow the “function level” of the overall DB2 system to be easily progressed while insulating individual applications from the impact of any changes via the “application compatibility level” set for each program.Read Julian Stuhler's article…See More
Jul 14
Jim Reed posted an event
Thumbnail

Build simple to multifaceted dashboards in QMF for Workstation at Online

July 20, 2021 from 8am to 9am
Today businesses need real time visual dashboards and reports across all their data, including hard to reach data across IBM Z non-relational data sources. QMF for Workstation makes visualizing virtually any data a reality, including IMS, VSAM, Adabas, IDMS and DB2 for z/OS data sources.This session will showcase and demo QMF’s dashboard/application building interface in QMF for Workstation from simple to multifaceted.See More
Jul 14
A video by Surekha Parekh was featured

Db2 AI for z/OS Version 1.4

IBM Db2 AI for z/OS version 1.4 is a powerhouse of enhancements! Db2 AI for z/OS infuses more AI into your Db2 environment, making it operate smarter and mor...
Jul 5
A blog post by Daniel Luksetich was featured

Db2 for z/OS and JSON

I wrote a very short story about using the JSON/SQL support in Db2 for z/OS. I also wrote an introduction to JSON support in Db2 for z/OS article for IDUG.The story and link to the IDUG article is here:https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/This is a direct link to the IDUG article, but you need an IDUG login account (which is free).https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/See More
Jun 30
Daniel Luksetich posted a blog post

Db2 for z/OS and JSON

I wrote a very short story about using the JSON/SQL support in Db2 for z/OS. I also wrote an introduction to JSON support in Db2 for z/OS article for IDUG.The story and link to the IDUG article is here:https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/This is a direct link to the IDUG article, but you need an IDUG login account (which is free).https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/See More
Jun 30
William Shipley liked Surekha Parekh's blog post Live Db2 12 Client Panel 30th June 2021 - Sign Up today!
Jun 23
A blog post by Surekha Parekh was featured

Live Db2 12 Client Panel 30th June 2021 - Sign Up today!

Live Db2 12 Client Panel 30th June 2021 - Sign Up today!HURRY SIGN UP TIME IS HURRYING OUTSummaryDb2 for z/OS is the strategic enterprise database that has evolved and adapted to meet client needs for over 35 years. John Campbell IBM Distinguished Engineer has been one of key developers from IBM Silicon Valley Lab that has been extremely influential in driving some of the innovation around the core strengths and business value of Db2 for z/OS.We are bringing together some of our Db2 for z/OS clients so that they can share some of their "use cases" and experiences around Db2 12 upgrade journey and discuss how they are exploiting, planning to exploit the new technology to leverage  their Db2 for z/OS data to…See More
Jun 22
Daniel Luksetich posted a blog post

Traditional Db2 Development and Modern Database Development

This article is the first of a four-part series addressing Db2 for z/OS and modern development utilizing a Agile methodology and DevOps processes. In this article we define traditional versus modern development and how Db2 for z/OS, while remaining the premier database for high volume system of record applications, might be left behind when it comes to best practices involving innovation. Did you notice that “Db2” follows “Traditional” in the title of this article, but “Database” follows “Modern”? It is my opinion that Db2 for z/OS is not the first database that comes to mind when considering a DevOps development methodology. However, there is no reason why it shouldn’t be!The first thing we need to do is to identify what we mean by traditional versus modern development. In this series of articles, we will be speaking specifically of the waterfall methodology versus an Agile methodology and DevOps practices.To read the entire article please follow this link:…See More
Jun 21
Gulfem Ogutgen liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Jun 21
Gulfem Ogutgen liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 21

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

Forum

ADM10501W - Health indicator "Database Automatic Storage Utilization"

Started by ONLO in Application Development and DB2 Jun 16. 0 Replies

AIX Version 6.1DB2 10.5.6Hi every body,I got the above error:MESSAGE : ADM10501W Health indicator "Database Automatic Storage Utilization" ("db.auto_storage_util") breached the "upper" warning threshold of "80 %" with value "88 %" on "database"…Continue

DB2 Future

Started by Peter E Saxe in Application Development and DB2 May 20. 0 Replies

Has anyone ever submitted ideas of new functions in DBMS software like DB2?   have an idea for a future enhancement to DB2 that I would like to see.  Is this discussion area a good place to discuss this ?  Thanks.Continue

Tags: Enhancements, Future, DB2

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service