August 2019 Blog Posts (4)

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…

Continue

Added by Peter Hartmann on August 28, 2019 at 18:39 — 1 Comment

AUTOBIND – Demystified – 1

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

Added by Peter Hartmann on August 20, 2019 at 19:29 — No Comments

IDUG Db2 Seminars in Sao Paulo (Brazil) and México DF (México)

When I joined IDUG as a volunteer a few years ago I was surprised that IDUG were not providing any Db2 education in Latin Amercia. The majority of the events and user group activities were concentrated  in North America, Europe and Australia.

As a naive Spanish speaker I had a vision to extend IDUG into Latin Amercia. I am please to inform you that IDUG are hosting two events in Latin Amercia this…

Continue

Added by Manuel Gomez Burriel on August 17, 2019 at 18:08 — No Comments

APPLCOMPAT and Advanced Triggers

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

Added by Peter Hartmann on August 7, 2019 at 11:13 — No Comments

Monthly Archives

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Latest Activity

William Shipley liked Surekha Parekh's blog post Live Db2 12 Client Panel 30th June 2021 - Sign Up today!
yesterday
A blog post by Surekha Parekh was featured
Tuesday
Daniel Luksetich posted a blog post
Monday
Gulfem Ogutgen liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Monday
Gulfem Ogutgen liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
edmundo nascimento liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
Michael Tiefenbacher posted an event
Thumbnail

30. DeDUG User Group Meeting at virtual

September 24, 2021 from 9am to 1:30pm
Monday
Earl Dugan posted an event

Virtual New England DB2 User's Group Thursday, June 24th, 2021. at Virtual Meeting

June 24, 2021 from 9am to 12pm
Monday
Willy Unger liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Saturday
carol goldberg liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
Adrian Collett liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
ONLO posted a discussion
Jun 16
GABRIEL FAJARDO liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 15
Pedro Diaz liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 14
An event by Surekha Parekh was featured
Thumbnail

Interactive Db2 12 Client Panel with John Campbell IBM DE at https://ibm.biz/Db212ClientPanel

June 29, 2021 from 11am to 12:30pm
Jun 14
Carol Davis-Mann posted a blog post
Jun 11

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