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

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

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

APPLCOMPAT and Advanced Triggers

Posted on August 7, 2019 at 11:13 0 Comments

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

Introduction:

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

Continue

Group Buffer Pool - Changes by PH13045

Posted on July 30, 2019 at 12:27 2 Comments

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…

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?
 
 
 

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

Forum

z/OS DB2 V11 to V12 and CICS?

Started by Tom Burkholder in What's hot ? yesterday. 0 Replies

Hello DB2 users...I apologize in advance if this is not the place to post this question; however, I thought I would sign up and give it a try.  My background is with systems support and middleware (z/OS, MQ, WebSphere, distributed DB2 jdbc configs)…Continue

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Douglas J. Partch, Jr. Jan 6. 1 Reply

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service