IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
The vast majority of Fortune 500 companies hold large amounts of critical business data on the mainframe. Much of this may be stored in relational structures on Db2 for z/OS. However, there is also a wealth of data stored on non-relational mainframe data sources such as Adabas, IMS, IDMS, VSAM, and flat files. Take as an example a bank ATM application, or airline reservation system which may be IMS based. IMS being a hierarchical vs.…Continue
Added by Jim Wankowski on February 4, 2020 at 16:00 — No Comments
After publishing a few blogs on Db2 for zOS REST service, I start getting questions on how to create/invoke a REST service to call a SQLPL. In the following article, I am going to show you how to create and invoke such service.…Continue
Added by Jane Man on January 15, 2020 at 18:31 — No Comments
Added by Paul McWilliams on January 23, 2020 at 19:30 — No Comments
Live Db2 12 Migration Planning Webcast followed by Customer Q&A Panel
Guest Speakers:- Ute Kleyensteuber - Commerzbank and Howard Paxton - HSBC
Dates: 26th & 27th February 2020
Remember IBM has announced…
Added by Surekha Parekh on February 1, 2020 at 14:52 — No Comments
Added by Surekha Parekh on January 13, 2020 at 16:22 — No Comments
Added by Zeljen Stanic on January 13, 2020 at 16:17 — No Comments
Dear Db2 User Group leaders and extended community
If you manage or are involved with Db2 User Groups or Db2 for z/OS event planning, IBM are working on our 2020 plans and speaker support.
Please can you add your 2020 Db2 User Group events on the World of Db2 so that we can review your requirements and plan in advance speaker support. In collaboration with IDUG Db2 User Community we will also offer User Groups a complimentary IDUG Conference Pass for you to…Continue
Added by Surekha Parekh on December 16, 2019 at 15:03 — No Comments
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.
Perhaps you've seen news about the sunset of the IBM developerWorks community platform at the end of 2019. I am happy that I can now share how you can continue following the latest news from the IBM experts who design, build, test, and support Db2 for z/OS, here in the new Db2 for z/OS Community.
Don't miss any Db2 for z/OS News from the Lab blog entries. Join the new community and subscribe today! For the full story, see:…Continue
Added by Paul McWilliams on December 11, 2019 at 23:49 — No Comments
LAST Db2 for z/OS webcast series in 2019 by John Campbell! REGISTER NOW!
Title: Strategies of Managing Universal Table Spaces (UTS) for Optimal Performance
PART 1. Date: Tuesday, November 12, 2019
PART 2 REGISTER NOW Wednesday November 13th 2019…Continue
Added by Surekha Parekh on November 1, 2019 at 12:02 — No Comments
Added by Jim Wankowski on September 5, 2019 at 15:18 — No Comments
Added by Surekha Parekh on September 24, 2019 at 13:30 — No Comments
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 Guillaume ARNOULD on September 9, 2019 at 8:20 — No Comments
This blog is part of a blog series around Analytics on IBM Z and has been created by
Added by Khadija Souissi on September 10, 2019 at 8:43 — No Comments
Added by Leif Pedersen on September 9, 2019 at 8:15 — No Comments
The idea of the traditional data center being centered on relational database technology is quickly evolving. Many new data sources exist today that did not exist as little as 5 years ago. Devices such as active machine sensors on machinery, autos and aircraft, medical sensors, RFIDs as well as social media, and web click through activity are creating tremendous volumes of mostly unstructured data which cannot be…Continue
Added by Jim Wankowski on September 4, 2019 at 19:30 — No Comments
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
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
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…