All Blog Posts (267)

PDUG - Polish DB2 User Group becomes the largest DB2 User Group in EMEA on World of DB2

PDUG  -  The Polish DB2 User Group becomes the largest DB2 User Group in EMEA on World of DB2…

Continue

Added by Surekha Parekh on June 13, 2017 at 9:30am — No Comments

Our Journey to DB2 Autonomics

Background

This blog entry describes the journey that we recently took at the Pennsylvania Department of Transportation (PennDOT) to modernize our DB2 utility environment.  Like all journeys, there were twists and turns along the way. But we knew that we had to find a better way of running our DB2 object maintenance utilities that would replace our existing inefficient…

Continue

Added by Perry Shindle on June 9, 2017 at 7:30pm — No Comments

Part III: Backup and Recovery of DB2 Analytics Accelerator data now possible!

Restoring data in an Accelerator

 

This is the third part of “Backup and Recovery of DB2 Analytics Accelerator data now possible”. In this section, we explore how data can be restored from a backup in one or more accelerators.

 

The backup itself is stored on z/OS, because the backup and recovery process for IBM DB2 Analytics Accelerator should be integrated as much as possible into existing backup and recovery processes on DB2 z/OS. A question that often arises…

Continue

Added by Patric Becker on June 7, 2017 at 8:29am — No Comments

Backup and Recovery of DB2 Analytics Accelerator data now possible! Part II

Creating a backup of data stored in an Accelerator

 

This is the second part of “Backup and Recovery of DB2 Analytics Accelerator data now possible!”. In this portion, we cover some of the details of the backup process of data stored in an Accelerator. We will start with two main scenarios and differentiate when a backup of Accelerator data might be needed:

  • Data is loaded into an Accelerator from non-DB2 for z/OS sources and…
Continue

Added by Patric Becker on May 23, 2017 at 6:46am — No Comments

Backup and recovery of DB2 Analytics Accelerator data now possible!

Overview

The IBM DB2 Analytics Accelerator for z/OS provides the ability to gain greater insights and analytics capabilities from their enterprise DB2 data.   The Accelerator allows you to run analytic queries against their existing DB2 data at higher speeds and lower costs than the same queries running natively on IBM DB2 for z/OS. This is great for data that exists…

Continue

Added by Tim Willging on May 16, 2017 at 1:27pm — No Comments

Unable to attend the IDUG DB2 Tech Conference this year?

Join the DB2 for z/OS and LUW Panel Live!

You can still experience the DB2 Panel taking place at conference and ask questions live through Ustream. Register for the live streaming of the DB2 Panel, and engage with esteemed expert panels of IBM strategists and developers, consultants and independent DB2 users remotely!

New this year, we will be hosting the z/OS and LUW Panels in one session — allowing live streaming of both panels!

• When: May 3, 2017 at 4:45 p.m. PST…

Continue

Added by William Shipley on April 24, 2017 at 6:36pm — No Comments

Discover what's new in DB2 for z/OS

Discover how new DB2 for z/OS features can help your enterprise get the most out of its database applications by visiting the DB2 for z/OS What's New web page at http://ibm.biz/db2zos-whatsnew.

This web page highlights key new features and the business value they bring. Today, this web page focuses on several new capabilities that can help you modernize your application development…

Continue

Added by Paul McWilliams on April 20, 2017 at 5:00pm — No Comments

IDUG Chennai 2017 - Thank -you to Ganesh Mahadevan from TCS for an amazing User Presentation about DB2 JSON Capabilities

Did you miss the amazing presentation from Ganesh Mahadevan from Chief Architect from Tata Consulting presenting "Flexing New Age Applications with DB2 JSON Capability"…

Continue

Added by Surekha Parekh on April 19, 2017 at 12:08pm — No Comments

Were you one of the lucky winners of Complimentary IDUG 2017 Conference Pass?

Winners of Complimentary IDUG 2017 Conference Pass?

Thank-you for attending IDUG Chennai and Bengaluru events last month,   we would like to "thank-you" for your loyalty and commitment to DB2, this year we had record attendance with over 550 users attending the IDUG India events.

If you were one of the lucky winners for a complimentary conference pass for one of our upcoming conferences please can…

Continue

Added by Surekha Parekh on April 10, 2017 at 4:10pm — No Comments

Check out the latest DB2 11 LUW e-Book ready for download

Check out the latest DB2 11 LUW e-Book ready for download DB2V11-ebook.pdf…

Continue

Added by Surekha Parekh on April 10, 2017 at 3:45pm — No Comments

How to extend performance advantages of static SQL statements to dynamic SQL to improve availability and reduce costs - Part 2

Overview

This is the second of a two-part series covering Dynamic Plan Stability (DPS) in DB2 12 and how IBM OMEGAMON XE for DB2 Performance Expert/Monitor can help you take advantage of it in both batch and online/real-time monitoring.  Part 2 focuses on real-time monitoring.

Real-time Monitoring (VTAM® Classic Interface)

The VTAM Classic interface offers in-depth monitoring for running threads, system statistics including statement caches, system…

Continue

Added by Matthias Tschaffler on April 3, 2017 at 7:02am — No Comments

How to extend performance advantages of static SQL statements to dynamic SQL to improve availability and reduce costs – Part 1

Overview

 

Dynamic SQL queries and workloads are more susceptible to performance degradation for various reasons. DB2 12 for z/OS introduced dynamic plan stability (DPS) to extend stable, predictable performance behavior for repeating dynamic query workloads. This two-part blog explains DPS in DB2 12 and how IBM OMEGAMON XE for DB2 Performance Expert/Monitor can help you take advantage of the feature in both batch and online monitoring. Part 1 focuses on batch…

Continue

Added by Matthias Tschaffler on March 27, 2017 at 8:20pm — No Comments

Quick Start in accessing DB2 for z/OS from Python applications

Python is one of the most commonly used programming language. Its interactive mode is ideal for prototype development and ad-hoc tasks. There is also a development GUI. Both are free to download or use under open source license. In the following article, I am going to show you how to use Python to connect to DB2 11 for z/OS and perform some basic database operations.…

Continue

Added by Jane Man on March 11, 2017 at 2:00am — No Comments

Node.js Application and DB2 REST services

DB2 for z/OS delivered native REST services support in the end of 2016. I wrote 2 white paper on how to create a DB2 REST service and how to consume this service from a mobile device. I start getting enquiries on how to consume a DB2 REST service from a node.js application. In the following blog, I am going to share my…

Continue

Added by Jane Man on March 5, 2017 at 6:25pm — No Comments

Production DB2 databases in Linux Intel ?

Hi, there's something I'd like to comment with you watching this blog entry: 
See, there's a customer who is seriously considering to migrate its DB2 databases running in z/linux (i.e. linux running under z/VM in IBM mainframes) as well as their DB2 databases on POWER Linux towards Intel based linux servers due to economical reasons. …
Continue

Added by José Raúl Barón Rodríguez on March 1, 2017 at 5:04pm — No Comments

Exploit in-memory computing on DB2 12 for z/OS to realize gains

Previously I outlined the themes and highlights of DB2 12 for z/OS, including some high-level performance expectations. Let’s move on to look at a developing strategy to deliver performance and scalability improvements by the exploitation of large real memory, particularly the use of in-memory data structures optimised for performance.



The two…

Continue

Added by Gareth on February 22, 2017 at 3:00pm — No Comments

DB2 for z/OS - 2017 Webcast Series - REGISTER NOW! 8 TOP WEBCASTS!

2017 DB2 for z/OS Webcast Series – Register for the Series NOW!

We have planned an amazing series of DB2 for z/OS webcasts series for you and to make it easier you only need to register once for all the webcasts !

Register Now using this URL for all webcasts in one…

Continue

Added by Surekha Parekh on February 9, 2017 at 9:08pm — No Comments

IBM Doc Buddy - instant help with product error messages right from your smartphone!

IBM Doc Buddy, a no charge mobile app that enables retrieving support documentation for z products, accelerates the time you spend in resolving problems and improves the total information experience. The app includes DB2 for z/OS messages from V10 to V12. …

Continue

Added by Jialei on January 19, 2017 at 7:59am — No Comments

Taking another look at in-database analytics

Data transformation is a core process in the operation of most business analytics hubs. However, even experienced data professionals can suffer from certain misconceptions about this practice, believing that data must be moved from source platforms to other platforms, often through several intermediary staging and storage systems, to enable transformation for downstream consumption in analytics applications.

But execution of high-performance data transformations on transactional…

Continue

Added by Cuneyt Goksu on January 17, 2017 at 11:14am — 1 Comment

IBM DB2 12 for z/OS is ready for Hybrid Transactional Analytical Processing

IBM DB2 12 for z/OS became generally available on Oct. 21, 2016. It's perhaps sobering to reflect on the fact that DB2 was first announced in 1983 and released in 1985, but its roots—and the roots of all relational databases—go all the way back to mathematician and IBM Fellow Edgar F. Codd's ground-breaking 1970 paper, "A Relational Model of Data for Large Shared Data Banks."



Many major…

Continue

Added by Gareth on January 11, 2017 at 7:00pm — 1 Comment

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

Latest Activity

Profile Icon via Twitter
IBM Unveils New Ways to Use, Develop for #Db2 for greater data control. Check out this press release - https://t.co/0ryMtkHK1t #data #JSON
Twitter1 hour ago · Reply · Retweet
Profile Icon via Twitter
Groupe France Mutuelle moved its mission-critical application to IBM #Db2 and cut costs while boosting performance… https://t.co/t5SWRzilRH
Twitter3 hours ago · Reply · Retweet
Profile Icon via Twitter
RT @scend: The Db2 Developer Community Edition is available now! Use Db2's enterprise capabilities for free! #MySQL #MongoDB https://t.co
Twitter7 hours ago · Reply · Retweet
Maira T. de Melo posted a group
17 hours ago

© 2017   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service