All Blog Posts (286)

Boost Performance, Productivity and Cost Savings with IBM's Latest Compilers - Webcast Feb 15th

Join our experts, Ray Jones, Vice President, IBM System z® Software, and Kevin Stoodley, IBM Fellow and CTO for Enterprise Modernization Tools, Compilers and Security, to learn how IBM’s latest compilers, middleware and tools can help you stay on the technology curve. In this complimentary webcast, Ray and Kevin will discuss best practices and approaches to plan and execute a successful compiler migration, alongside CICS®, IMS™ and DB2® upgrades. They will also go over IBM’s strategy for…


Added by melanie steckham on January 31, 2012 at 2:49pm — No Comments

The New Android and iOS UI for Q Replication

This month, IBM released an update to the Q Replication Dashboard.  The most significant enhancement is the addition of a simplified user interface that's designed for web browsers in small touch-screen devices.  I've tried it on both an iPhone 4S running iOS 5.0.1 and a Google…


Added by david t on December 26, 2011 at 9:00pm — No Comments

Accessing Oracle, Netezza, and Microsoft Excel from DB2 z/OS

I regularly see people ask how to access data on UNIX or Windows from apps on IBM's z/OS (mainframe) operating system.  However, I haven't been able to find anything that discusses the options.  Therefore, I'm using this post to provide the basics about one solution - using IBM's InfoSphere Federation Server as an interface.


This solution is for people running DB2 on z/OS.  It's probably best discussed with a simple example and a picture.  So, my example is - let's say you…


Added by david t on December 20, 2011 at 8:14pm — No Comments

Using Q Replication with DB2's HADR

About two years ago, I posted a video showing how to use SQL Replication with HADR.  Lately, I've gotten a bunch of requests to do something similar for Q Replication and HADR.  The good news is that I don't have to :)  there's now a white paper called…


Added by david t on December 15, 2011 at 1:00pm — No Comments

IBM Job Opportunities


In IBM Mexico we are looking for an DB2 Database Administrator. The person in this position will have two to three years of experience and strong technical experience. Please find the full job description for this position on our website:  Job Code ITD-0409585

Added by Jose Luis on December 15, 2011 at 11:34am — No Comments

DataStage migration from 8.0 to 8.1 or 8.5 Activity setps




please find the steps to fallow for datastage migration



DataStage migration from 8.0 to 8.1 or 8.5 Activity



Added by Lohith on December 2, 2011 at 2:44am — No Comments

DataStage migration from DB2 to Oracle or Oracle to DB2-Part1

DataStage migration from DB2 to Oracle or Oracle to DB2-Part1

As time passed most the projects will move to the new environment or will upgrade from the OLD environment based on the project requirement. One the usual thing which happens is Database exchange in the project. I am explaining this from my experience where we had already working DWH with the below structure


Database-DB2(DWH Database)

ETL Tool –DataStage.

Due to new project…


Added by Lohith on November 25, 2011 at 4:46am — 4 Comments

How to start work as DB2 DBA in DWH team without KT-part1

How to start work as DB2 DBA in DWH team without KT-part1

This is as per my knowledge only.

Different kinds of DBA are

1.Unix admin DBA

2.Application DBA


4. Developer DBA

UNIX admin DBA: Unix administrators basically do the SO (Linux/hp/aix) installation and later if the project/company is small they will do the rest of the installation for Database DB2 and also for the applications like…


Added by Lohith on November 24, 2011 at 4:00am — No Comments

DataStage Architecture

DataStage Architecture

This is the info as per my knowladge.

What is the architecture of data stage?

Architecture of DS is client/server architecture.

We have different types of client /server architecture for DataStage starting from the different versions.The latest version is DataStage 8.7



Added by Lohith on November 23, 2011 at 4:05am — No Comments

Cracking the Active/Active Data Warehouse Dilemma

For those of you who weren't at IOD this year, you may be interested to know that some of the presentations are now available on  The one about active-active data warehousing by Dwaine Snow, Linda Snow, and Enzo Cialini, all of IBM, is a good read that doesn't require you have a presenter handy.  It's pdf format can can be viewed or downloaded from the following link:…


Added by david t on November 15, 2011 at 9:30pm — No Comments

Sending emails from DB2

I am sure you all know that you can configure db2 admin server and health monitor to send emails, but how do you send email from within

db2 luw itself. Much like SQLMAIL feature in our friend SQL Server , DB2 now have a mail feature. Starting from DB2 V9.7, there is an additional database configuration called SMTP_SERVER and built in stored procedure …


Added by Raju Pillai on November 15, 2011 at 8:07am — No Comments

A Fast Way to Get Started with Q Replication for DB2 Active-Active Databases


a fast way to get started with MQ for active-active databases. In this post, I show how to set up a Q Replication configuration for active-active databases. It takes advantage of the MQ set up from the previous post. Neither post is very long and you'll probably spend no more than 30 mn on this one.



Added by Cecile Madsen on October 31, 2011 at 4:00pm — 6 Comments

Testing DB2 OLEDB Provider using Microsoft Excel

Testing DB2 OLEDB Provider using Microsoft Excel

 It is well known that from DB2 control center, one can test connectivity using configuration assistant for various providers like OLEDB , CLI , JDBC , ADO…


Added by Prashant N Kulkarni on October 20, 2011 at 1:39am — No Comments

Data Replication and Data Federation (Virtualization) at IOD 2011

As with I did for last year's IOD, I'm providing a consolidated list of sessions for Replication and Federation at this year's IOD as well.  These sessions should be of interest to anyone with data integration needs.  Session descriptions can be found in the on-line IOD agenda for registered participants. Hope…


Added by david t on October 19, 2011 at 12:00pm — No Comments

Give IBM Your Feedback About Mobile Apps

If you use Twitter, you may have seen @Merv's (Merv Adrian's) tweets today about the projected number of tablets to be in use by 2016 and the ratio of mobile-to-PC app projects by 2015.  Those trends are two of…


Added by david t on October 14, 2011 at 6:30pm — No Comments

A Fresh Look at Setting Session Isolation Level

By Sathyaram Sannasi - Confessions of a DB2 Geek

The isolation level determines how data accessed by one application is isolated from the other. In other words, the degree to which rows accessed by an application is available to another.


A description of the isolations level can be found here -…


Added by Laura Hood on October 14, 2011 at 7:13am — 2 Comments

Data Replication and Federation at IOD Past and Present

If you're going to be at this year's IOD conference in Las Vegas, you might be interested in reviewing some of IOD 2010's customer stories for data replication.  I've got links to a couple of them here along with links to some of the IBM presentations for both replication and federation.  You'll hear more stories like these this year.  You'll also be able to see demos in the InfoSphere Demo…


Added by david t on October 13, 2011 at 9:43pm — 1 Comment

A Fast Way to Get Started with Websphere MQ for DB2 Active-Active Databases

at no additional cost. The main reason was to give DB2 a built-in solution for

active-active databases. Since a lot of DB2 people are new to Q Replication, I will show you how easy it is to set up a real-world configuration and give it a…

Added by Cecile Madsen on October 13, 2011 at 7:15pm — No Comments

Active-Active Databases: IBM 5710 vs the Oracle Database Appliance


Last week, had a very good post comparing two new database offerings for SMB - the IBM Smart Analytics System 5710 and the Oracle Database Appliance (ODA).  Naturally, the first thing I looked for was anything comparing options for…


Added by david t on October 6, 2011 at 12:30pm — 1 Comment

IBM Updates its New Data Replication Product

Last month IBM announced a new Data Replication product that bundles its CDC, Q, and SQL Replication technologies.  IBM's intent is to provide all replication enhancements through this new product.  To go along with that direction, IBM just announced an update to the CDC technology in Data Replication.  The new level is Data Replication 10.1.1. I'll list a few highlights in this…


Added by david t on September 19, 2011 at 12:17pm — No Comments

Monthly Archives












Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service