Featured Blog Posts (59)

Thoughts on reading Willie's recent "Do We Need More DB2 Reference Materials?" post


A week ago, I encountered a very frustrated analyst/colleague, who was having trouble absorbing enough knowledge of DB2 to understand why the changes she'd asked me for weren't working.  I tried to explain what was going on, and I think we reached a meeting of the minds, but one thing she said as she was leaving struck me (and I'm sorry I can't remember an exact quote!); she really wanted to learn enough about DB2 that the answers to mildly technical questions like this were no…


Added by Phil Sevetson on May 16, 2011 at 1:00pm — No Comments

How to add IDENTITY column to existing table

Every DB2 admin discovers sooner or later that DB2 can not add identity column to existing table easily. Following statements fails due to syntax error: alter table public.clicks add column id integer generated always as identity


But i have good news for everyone. It can be still done, but it requires more steps.


1. Add not null integer column

You need to provide default value for it otherwise db2 will refuse it to make not…


Added by Radim Kolar on March 31, 2011 at 3:00pm — 2 Comments

Learning Databases has become a lot easier with was recently launched as beta to simplify learning database concepts and acquiring DB2 skills. DB2 U currently features several free courses that you can take online at your own pace with aids such as videos, books, hands-on exercises and more. Courses available include: SQL Fundamentals, DB2 Essential Training, etc.


To learn more, watch the…


Added by Rav Ahuja on January 17, 2011 at 12:58pm — No Comments

What software application gets hacked the most?

Oracle's Java framework has surpassed Adobe applications as the most
attacked software package, according to a Microsoft researcher who
warned she was seeing “an unprecedented wave of Java exploitation.”

Folks ought to consider DB2 more.

Added by Jeffrey P. Hebert on October 19, 2010 at 3:30pm — No 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

Create nickname to DB2/i table with number(38,0) column fails with SQL0901N error


DATASD3 is cataloged DB2/i (DB2 AS400) database.

db2 connect to DATASD3 user user1 using PASSWORD

Database Connection Information…

Added by Yunfeng Sun on October 17, 2010 at 10:00pm — No Comments

Oracle database crashes JPMorgan Chase web site

Last week, over 16 million customers of America’s second largest bank were unable to access their accounts or process online payments for a good part of the week. Angry customers, hit by late charges for

scheduled payments that didn’t go out, are venting their frustrations on


The site first went down Monday and came back up after a 24 hour

complete blackout but many customers say connectivity was…


Added by Jeffrey Hebert on September 20, 2010 at 3:01pm — 1 Comment

Questions about Federation in DPF environment


We are installing federation server on a 40 node DPF (MPP) database.

1. Do I have to install federation on all of the nodes or just the coordinating node.

2. Do I need wrappers, servers, user mappings and nicknames on all of the nodes or just the coordinator node.


1. Please install federation on all of the nodes because in a DPF(MPP) system, any partition could be potentially a…


Added by Yunfeng Sun on September 15, 2010 at 4:00am — No Comments

Guide on Installation of DB2 9.7.2 Steps

Hello Readers,

This is for those who are new to DB2 9 or DB2 9.7.2 Beginners.

This blog explain the installation of IBM DB2 9.7.2 step by step.

The… Continue

Added by Rakesh Tiwari on September 11, 2010 at 9:00am — 4 Comments

Disaster Recovery, High Availability, and Continuous Availability - What's the Difference?

Last month I posted a video that gave a brief overview of how data replication is used for continuous availability. I then got ask why I used the term continuous availability instead of high availability or disaster recovery. "What's the difference?" Well, while these solutions have a lot of overlap and can usually be built from some of the same components, they can have different objectives. Different objects can…

Added by david t on September 7, 2010 at 12:30am — 1 Comment

Job internship opportunities at the IBM Toronto Lab (Canada)

This August, Henrique Copelli Zambon, a student from the University of Sao Paulo in Brazil started his 16-month internship with the DB2 Competitive team at the IBM Toronto Lab in Canada. Henrique was selected from hundreds of students who applied. Henrique will be working on cool projects that use mobile technologies (iPhone, Android), Web services, and Cloud technologies; all of them in conjunction with… Continue

Added by Andrea Rodacki on August 24, 2010 at 7:36pm — No Comments

Data Replication for the IBM Smart Analytics System 7700

Someday after you get through reading the outstanding highlights in this week's announcement of the 7700, you may want to know what your replication options are. The answer is pretty much the same as it is for the 7600. I'll use this post to give you a…

Added by david t on August 20, 2010 at 12:00pm — No Comments

Free Database now Slimmer!

A slimmer / lighter, option of the free database, DB2 Express-C was recently made available. This is good news for many who just want to use the core database features and not have to wait to download extra features they are not going to use. Those with not so good bandwidth are going to… Continue

Added by Rav Ahuja on August 6, 2010 at 2:19pm — 1 Comment

Data warehouse management

Data warehouse management

Data warehouse is a Process of collection data from different sources and loading the data in one place to get the once…


Added by Lohith on July 26, 2010 at 10:00am — No Comments

Want a free Data Studio book?

IBM Data Studio if you don't know is a free tool for administering and developing server side / app routines for DB2 (both LUW and z/OS). [Of course there is a lot more to it but I assume you get the concept.] Over time it will replace the DB2 Control Center. So if you're new to DB2 or have been using the Control Center, it is a good idea to get yourself familiar with Data Studio. And an easy way to do that is to attend this webinar on Tuesday Jul 27, at 11:30-1 PM Eastern. You can …


Added by Rav Ahuja on July 23, 2010 at 4:30pm — No Comments

Data Replication for the IBM Smart Analytics System 5600 and 7600

With more companies looking into the IBM Smart Analytics Systems, one obvious question people ask is - what are my replication options? The answer is simple, but not easy to find. I'm going to use this post to provide one for the 5600 and 7600.

Both of these systems are built on a base…

Added by david t on July 2, 2010 at 1:00pm — No Comments

DB2 Express pricing

DB2 Express

Is entry level database server. It is limited to max 4 cpu cores or 200 PVU and 4 GB RAM. Capacity sub licensing is allowed, you can split server by virtualization technology and install multiple copies of DB2 Express on it.

DB2 can be licensed per server, PVU or FTL. Licensing per PVU is oldest licensing type, every CPU core has some PVU value assigned. Most…


Added by Radim Kolar on June 20, 2010 at 3:46am — No Comments

A Fast Way to Get Started with DB2 Federation

However, even with it available many different ways, I regularly meet people who know little about it and are under the impression that it's difficult to learn. It's not :) That got me thinking about the fastest way to get started with it. Personally, I think it's best to set up a simple scenario and go from there. That's what I'm going to show in this post. It should take about 15 minutes max. You can then extend your scenario using the documentation in…

Added by david t on May 13, 2010 at 9:30pm — No Comments

iPad, Wifi HD TV and honorarium? What the heck is an honorarium?

A sticky on the DB2 Express-C forum reads:

Provide your input on DB2! Honorarium for completing survey

I had heard of honorary degrees and aquariums but what the heck is an honorarium? I didn't think they meant an honorary aquarium (not even sure what that is) so I decided to look it up and the first hit wikipedia described it as "an ex gratia… Continue

Added by Rav Ahuja on May 10, 2010 at 11:30am — No Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service