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…Continue
Added by melanie steckham on January 31, 2012 at 2:49pm — No Comments
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…Continue
Added by david t on December 26, 2011 at 9:00pm — No Comments
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…Continue
Added by david t on December 20, 2011 at 8:14pm — No Comments
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…Continue
Added by david t on December 15, 2011 at 1:00pm — No Comments
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: http://www.ibm.com/mx/employment/ Job Code ITD-0409585
Added by Jose Luis on December 15, 2011 at 11:34am — No Comments
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
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
ETL Tool –DataStage.
Due to new project…Continue
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
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…Continue
Added by Lohith on November 24, 2011 at 4:00am — No Comments
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
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 ibm.com. 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:…Continue
Added by david t on November 15, 2011 at 9:30pm — No Comments
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
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…Continue
Added by Prashant N Kulkarni on October 20, 2011 at 1:39am — No Comments
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…Continue
Added by david t on October 19, 2011 at 12:00pm — No Comments
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…Continue
Added by david t on October 14, 2011 at 6:30pm — No Comments
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 -…Continue
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 Cecile Madsen on October 13, 2011 at 7:15pm — No Comments
Last week, smarterquestions.org 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…Continue
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…Continue
Added by david t on September 19, 2011 at 12:17pm — No Comments