ChannelDB2

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…

Continue

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…

Continue

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…

Continue

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…

Continue

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

IBM Job Opportunities

Hi:

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

DataStage migration from 8.0 to 8.1 or 8.5 Activity setps

 

Hi

 

please find the steps to fallow for datastage migration

 

SNO

DataStage migration from 8.0 to 8.1 or 8.5 Activity

 …

Continue

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

OS-AIX

Database-DB2(DWH Database)

ETL Tool –DataStage.

Due to new project…

Continue

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

3.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

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

http://www-01.ibm.com/support/docview.wss?uid=swg27008803

1.…

Continue

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 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

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 …

Continue

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.



The…

Continue

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…

Continue

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…

Continue

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…

Continue

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 -…

Continue

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…

Continue

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…
Continue

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, 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

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…

Continue

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

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service