All Blog Posts (262)

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

Comparing DB2 12 Function Levels M100 and M500

DB2utor Post: Comparing DB2 12 Function Levels M100 and M500

http://bit.ly/2hPjY2j

Added by Troy Coleman on January 4, 2017 at 2:56am — No Comments

Comparing DB2 12 Function Levels M100 and M500

DB2utor Post - http://bit.ly/2hPjY2j

Added by Troy Coleman on January 4, 2017 at 2:53am — No Comments

Machine Learning using DB2 for z/OS data

Using machine learning features in Spark and an easy to follow example, learn how you can build/train/test a machine learning model using data from DB2 for z/OS.

Machine Learning using DB2 for z/OS data and Spark Part 1…

Continue

Added by Jane Man on January 2, 2017 at 6:00am — No Comments

Monitoring Index Cleanup Threads

Monitoring Index Cleanup Threads
http://bit.ly/2gRqtPR

Added by Troy Coleman on December 16, 2016 at 4:38am — No Comments

Read how DB2 12 delivers key innovations faster and cheaper - New IBM Redbook launched!

DB2 12 Technical Overview Redbook     - Available for download

http://ibm.biz/DB212REDBOOK

Check out the video https://youtu.be/GlPDZcdDwkw…

Continue

Added by IBMDB2 on December 15, 2016 at 12:17pm — No Comments

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

© 2017   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service