IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
By Patrick Bossman and Paul McWilliams
Automatic binds of plans and packages for applications that run on Db2 for z/OS introduce avoidable risk to online and offline migrations. During and after migration, automatic binds can cause costly problems, including performance regression and even application outages.
However, you can take action before migration to…
New features are being added to the Enhanced 3270 User Interface in each release of OMEGAMON XE for Db2 Performance Expert on z/OS. A continued investment in the 3270 UI provides more synergy and integration with the entire OMEGAMON family of products. One of the most important features introduced for version 5.3.0 is the ability to display Thread History.
In OMEGAMON for Db2, there are two types of history. The Snapshot type of history takes a sample of what is…Continue
Added by Paul Kenney on September 21, 2017 at 17:40 — No Comments
I know many of you have been waiting for this Redbook so the wait is over, this is a very valuable book written by some of the top experts in the industry. Download your copy today and find out how Db2 12 delivers significant business value and helps reduce costs, improves scalability which is critical in today's IT…Continue
Added by Surekha Parekh on September 20, 2017 at 9:31 — No Comments
By Patrick Malone and Paul McWilliams
Db2 for z/OS DBAs who use the LOAD utility in Db2 11 and Db2 12 can reduce the cost and effort of preparing input data sets for the LOAD utility, examining LOAD utility job output, and dealing with discard data sets, by using several new IGNORE options.
DBAs are often aware of records in input data sets that trigger…
Added by Paul McWilliams on September 18, 2017 at 16:00 — No Comments
In Db2 12 for z/OS function level 501, you can write efficient queries to select groups of related values and return each group as a list in a single string value, with optional separators, without writing complex recursive SQL statements. Consider the sample EMP table that is supplied with Db2. You can write a query that calls the…Continue
Added by Paul McWilliams on September 11, 2017 at 9:00 — No Comments
Agenda for the next 11th PDUG conference is ready! DB2 users and the best IBM and CA lab specialists will share their practical knowledge with us in Wroclaw (Poland) on 27-28 September. We plan two workshops on both LUW and z/OS tracks.
Link to Agenda…
Added by Sekowski Pawel on September 7, 2017 at 15:57 — No Comments