August 2016 Blog Posts (7)

DB2utor- Greater Memory Already Making a Great Impact

This post discussed the benefits of memory being used to save on CPU

Added by Troy Coleman on August 31, 2016 at 18:43 — No Comments

Share your knowledge at IDUG EMEA 2016 - Learn More about IDUG Mentor Program

The IDUG Mentor Program gives IDUG members the opportunity to pass

on the valuable skills they have learned over the years to fellow DB2 professionals.

If you wish to motivate a brand…


Added by Mateja Jankovič on August 26, 2016 at 14:29 — No Comments

Open Source Programs Spark Innovation in z Analytics

Integrating Spark, DB2 and BigInsights Allows Users to Leverage them Effectively


The availability of IBM z/OS Platform for Apache Spark and its positioning within z Analytics with DB2 for z/OS and the IBM DB2 Analytics Accelerator is a topic of interest to IBM’s customers. The IBM Open Platform (IOP) with Apache Spark, Apache Hadoop and IBM BigInsights on the distributed platform are further enriching the value proposition for z Systems analytics.…


Added by Eberhard Hechler on August 26, 2016 at 11:23 — No Comments

Ensure you have a simple base of statistics before exploiting the Optimizer’s externalization of missing statistics in DB2 11 for z/OS

I recently wrote about the most common mistakes that are made with respect to RUNSTATS collection in DB2 for z/OS. [[LINK: ]] The responses were positive, but looking into this further, I see that these mistakes are being made more frequently…


Added by Terry Purcell on August 16, 2016 at 21:02 — No Comments

Data Studio Tools Included in Data Server Manager 2.1

Hard work with lots of new features in DSM 2.1 supporting DB2 for z/OS.

Added by Troy Coleman on August 9, 2016 at 17:30 — No Comments

IBM DB2: Taking the Best Data Server on a Transformational Journey

Business transformation and agility are critical in today’s fast moving world. Clients demand insights faster, more often, and with greater accuracy based on up-to-the-second transactional data that is frequently housed in mainframe systems. The dependency on technology and the rate at which information is created and consumed continues growing exponentially. Applications have to rapidly adapt to take account of the dynamic digital business models and environments. All this drives the need…


Added by Jeff Josten on August 3, 2016 at 23:00 — 1 Comment

Controlling DDF Threads using Profiles

Controlling DDF Threads using Profiles #DB2z

Added by Troy Coleman on August 3, 2016 at 2:09 — No Comments

Monthly Archives













Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.


Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Douglas J. Partch, Jr. Jan 6. 1 Reply

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

Db2 Analytics Accelerator Version 7.5 is now Generally Available!

Started by Patricia Zakhar in What's hot ? Dec 9, 2019. 0 Replies

Now Generally AvailableIBM Db2 Analytics Accelerator Version 7.5! The latest version of the Db2 Analytics Accelerator, which delivers the highly anticipated Integrated Synchronization capability, is now generally available. The Db2 Analytics…Continue

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service