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
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…Continue
DB2University.com 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…Continue
Added by Rav Ahuja on January 17, 2011 at 12:58pm — No Comments
Added by Jeffrey P. Hebert on October 19, 2010 at 3:30pm — No Comments
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 Yunfeng Sun on October 17, 2010 at 10:00pm — No Comments
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…
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…Continue
Added by Yunfeng Sun on September 15, 2010 at 4:00am — No Comments
This blog explain the installation of IBM DB2 9.7.2 step by step.The… Continue
Added by Andrea Rodacki on August 24, 2010 at 7:36pm — No Comments
Added by david t on August 20, 2010 at 12:00pm — No Comments
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…Continue
Added by Lohith on July 26, 2010 at 10:00am — No Comments
Added by Rav Ahuja on July 23, 2010 at 4:30pm — No Comments
Added by david t on July 2, 2010 at 1:00pm — No Comments
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…Continue
Added by Radim Kolar on June 20, 2010 at 3:46am — No Comments
Added by david t on May 13, 2010 at 9:30pm — No Comments
Added by Rav Ahuja on May 10, 2010 at 11:30am — No Comments