Peter Hartmann
  • Male
  • Frankfurt
  • Germany
Share

Peter Hartmann's Friends

  • Manuel Gomez Burriel
  • Toine Michielse
  • Christian Daser
  • Calene Janacek
  • Surekha Parekh

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

Peter Hartmann's Blog

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

Function level V12R1M504 and e.g. archive tables

Posted on July 19, 2019 at 9:57 0 Comments

V12R1M504:

With APPLCOMPAT V12R1M504 on e.g. SPUFI or DSNTEP2, one can no longer create segmented or classic partitioned table spaces. See knowledge center for this restriction.

A small marginalia is behind this restriction, if this is combined with another…

Continue

RUNSTATS sampling enhancements

Posted on July 17, 2019 at 10:38 1 Comment

Introduction:

One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.



The challenge is to balance the CPU resources used by RUNSTATS to calculate column cardinalities with high accuracy…

Continue

Retrieval of current DSNZPARM and DSNHDECP settings

Posted on July 16, 2019 at 8:04 6 Comments

History:

With DB2 Version 9.1 for z/OS a new system supplied stored procedure SYSPROC.ADMIN_INFO_SYSPARM was delivered. As the name suggests, this routine can be called to obtain the current settings of the Db2 subsystem parameters (DSNZPARM) and 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

IDUG Db2 Tech Conference coming to San Paulo, Brazil and Mexico City! Register Now

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

For the first time IDUG is hosting two events in Latin America. These seminars will bring together Db2 professionals from around the world for expert-led technical sessions and networking opportunities. This is your chance to connect! …Continue

Tags: Education

MSSQL linked server attaching to DB2 LUW

Started by Mike Jett in Application Development and DB2 on Thursday. 0 Replies

I am trying to create a linked server from MSSQL 2014  to DB2 11.1  I am able to create one linked server and get it to work with one DB.  I have not been able to figure out how to add additional catalogs(DB's).  Is it possible to use just one…Continue

Tags: server, linked

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service