IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
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
If you think you know all about APPLCOMPAT, then please read this!
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
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
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…
Added by Peter Hartmann on July 19, 2019 at 9:57 — 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…
In Db2 12, you can transfer the ownership of database and system objects online if you are the owner of the object or have SECADM authority. You can use TRANSFER OWNERSHIP statements to transfer ownership of an objects to another authorization ID or a role, without any application changes.
For the full story on this new SQL capability, see the new Db2 12 GA feature series post, Transferring ownership of Db2…Continue
Added by Paul McWilliams on July 12, 2019 at 22:38 — No Comments
Description of the new feature:
When Db2 in a data sharing environment writes a changed page to the GBP the same page in the buffer pool(s) of the other member(s) must be invalidated to avoid back level data access in this/these member(s). This invalidation is done by the cross invalidation (XI) feature which is a key functionality of data sharing and controlled by coupling facility…Continue
Added by Peter Hartmann on July 12, 2019 at 7:57 — No Comments
We're proud to announce that Db2 12 for z/OS function level 505 becomes available for activation when you apply…Continue
Added by Paul McWilliams on June 26, 2019 at 18:41 — No Comments
Partition-by-range (PBR) table spaces with relative page numbers (RPN) in Db2 12 for z/OS improve the usability, manageability, scalability, and availability for the largest tables in Db2 environments.
Read the full story in the Db2 for z/OS News from the Lab blog:
Added by Paul McWilliams on June 12, 2019 at 19:30 — No Comments
IDUG are pleased to once again invite all Db2 Regional User Group (RUG) leaders attending the IDUG conference in Charlotte to join us for a RUG Leaders Luncheon on Tuesday, June 4, 2019, 11:40 AM - 12:40 PM, Craft City Social Club, Charlotte Sheraton.
This is a chance to connect with fellow Db2 RUG leaders while you learn about news and updates from IDUG and IBM.
The objectives of this session…Continue
IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery
An IBM Redpaper publication
Published: May 14, 2019 ISBN: 073845768x
Explore online at: http://www.redbooks.ibm.com/abstracts/redp5536.html?Open
Added by Patricia Zakhar on May 22, 2019 at 14:47 — No Comments
In Db2 12, APAR PH08482 simplifies the process of activating new function levels without impacting existing JDBC, CLI, and .net applications, and it possibly reduces the coordination effort required between Db2 administrators and application programmers, for activating new application…Continue
Added by Paul McWilliams on May 9, 2019 at 23:32 — No Comments
Added by Katie Higgs on April 25, 2019 at 15:23 — No Comments
Added by TATJANA BELE on April 13, 2019 at 13:35 — No Comments
Added by Surekha Parekh on April 9, 2019 at 14:29 — No Comments
We recently published a sample Db2 software services template. As a service provider, you can use it to create services (DBaaS) to rapidly provision from scratch one or multiple standalone Db2…Continue
Added by Paul McWilliams on April 2, 2019 at 22:32 — No Comments
Get some valuable insights on the uses and benefits of insert algorithm 2, including how-to information for monitoring and troubleshooting this performance feature.
Read the full story here: https://ibm.biz/Bd2U94
Added by Eric Radzinski on March 26, 2019 at 0:22 — No Comments
Db2 for z/OS APAR PH02052 provides some significant enhancements to Insert Algorithm 2, which was introduced in Db2z 12 to provide faster INSERT throughput for unclustered INSERTs on universal table space objects that use the MEMBER CLUSTER option.
Read the full story here: https://ibm.biz/Bd2wDL
Always get the latest…Continue
Added by Eric Radzinski on March 13, 2019 at 19:51 — No Comments
Added by Paul McWilliams on March 6, 2019 at 18:26 — No Comments