Featured Blog Posts (59)

IBM POWER7 blades are here

Before some time IBM announced its new POWER7 processor and some new System p servers with that processor. POWER7 is huge improvement in processor technology and it is undisputed benchmark leader which is quite standard for any new POWER processor…


Added by Radim Kolar on April 19, 2010 at 1:33am — No Comments

DB2 DAS problem and also DB2 Memory problem solved Successfully

This is an article regarding the 2 problems mixed DB2 DAS problem and also the Memory problem

Initially I got the problem in db2diag.log file that…


Added by Lohith on April 11, 2010 at 6:30am — No Comments

Compare the Rows of Two Tables

You can search the web and find all sorts of SQL query techniques to do this. Therefore, I'm not going to cover those here. Instead, I'm going to focus on two commands built into DB2 and InfoSphere Warehouse. One command compares the contents of two tables (or two query results) and then saves a list of rows that are different between the two. The other command 'repairs' one of the two tables by modifying it based on the differences listed by the first…

Added by david t on April 2, 2010 at 12:30am — 4 Comments

How well DB2 Express C scale?

If you ask your IBM sales rep: How much DB2 Express C scale? Do you have any benchmarks? Then answer probably will be: We don't have benchmarks, but probably not much.

I was interested how much is not much. It is true that there are no benchmarks for DB2 Express C - but better to say there are no benchmarks for any DB2 edition other then…


Added by Radim Kolar on March 15, 2010 at 4:32pm — No Comments

Porting LIMIT and OFFSET SELECT clauses to DB2

Opensource databases such as MySQL and PostgreSQL supports non standard SELECT extension for limiting number of returned rows from query. You can see description in PostgreSQL manual. Look for keywords LIMIT and OFFSET. LIMIT specifies the maximum number of rows to return, while OFFSET specifies the number of rows to skip before starting to return…


Added by Radim Kolar on February 28, 2010 at 11:30am — 2 Comments

Transforming Data as You Replicate

When replicating data, a very common requirement is to modify or 'transform' changed data before it reaches its final destination. Two simple examples:

-- Combine two columns of source data into a single value for a column at the target.

-- Change a numeric code at the source into a descriptive string for the target.

Many other transformations are possible, including those… Continue

Added by david t on March 8, 2010 at 1:15pm — No Comments

Client Optimization vs. pureQuery API

You may have heard about several different capabilites available with pureQuery such as Client Optimization, Annotated Method and In-Line. Some questions that I have had about these options would include what is the difference between these methods and where do I use each? I wanted to just quickly write a few paragraphs to answer these two primary questions.

In answer to the first question, both Annotated Method and In-Line are part of the pureQuery API. Annotated Method uses…


Added by Dan Galvin on February 10, 2010 at 4:18pm — 1 Comment

Distributing Data to a Large Number of DB2 Servers

Once you get past the simple case of copying changed data from one system to another, the next most common replication solution is data distribution. In this scenario, you distribute data from a central database to two or more databases, maybe even 100's, that are likely remote. An example is sending changes from a corporate headquarters to branch offices or retail locations. You may only need the data to flow one way - from a central database to others. Or, you may also need some data to…


Added by david t on February 15, 2010 at 4:00pm — No Comments

Datawarehouse project working with DB2,Datastage 7.5,IBM AIX and crystal report


I am working on this data warehouse project from past 4.5 yr. starting from initial hardware invoice process to aix OS installation and mount point creation, DB2 installation, datastage installation, datastage configuration for Oracle, SQL and DB2 database and finally crystal report generation.

Let me explain how the DWH(Datawarehosue) process works.

General work flow.

S1(oracle)---------------------ETL(Datastage)---DWH(DB2 database)--Crystal report… Continue

Added by Lohith on February 1, 2010 at 8:00am — 1 Comment


Mahesh Kumar Joshi

Govt. Engineering College Bikaner (Quarterly Report)

DB2 in India: ECB DB2 User Group I am a student of B.Tech in Information Technology from Govt. Engineering College Bikaner India. I became the first DB2 Student ambassador at Rajasthan Technical University India in JUN 2009, and I found ECB DB2 User Group in Campus & group is organizing Presentations, Screenshots & Workshop on DB2 & other IBM Tools & Technologies… Continue

Added by Mahesh Kumar Joshi on December 25, 2009 at 1:30pm — No Comments

A Fast Way to Get Started with Cache Tables (Distributed Caching)

I often get asked if it's easy to set up IBM cache tables and whether they can be set up with scripts instead of a GUI  The answer I give is yes to both questions.  Cache tables, a form of distributed caching, are very easy to set up and you can do it with scripts. The challenges are that (1) IBM's documentation could be better and (2) a good sample is needed. I'm hoping a few pictures, a little text, and a small sample are all that's needed to improve the situation…


Added by david t on February 5, 2010 at 9:00pm — No Comments

IBM P series shutdown process for DB2,Datastage,Essbase and hyperion application in IBM DS4300 storage

IBM Pseris shutdown process

I was working as DB2 DBA ,Unix admin for the DWH project in my previous company. Some of the real time experience and problems which I faced in this project and how I came up with the solution.

Let me explain

We had IBM Pseries 570 with DS3400 storage


1. DB2 Server -- ---AIX 5.3

2. ESSBase Server-- ---AIX 5.3

3. ETL Server-- ---AIX5.2

4. Analyzer (hyperion)--… Continue

Added by Lohith on February 3, 2010 at 5:52am — No Comments

Upgrading DB2 Express 9.5.4 to DB2 Express C 9.7.1

Another DB2 upgrade mini-guide. I was asked to upgrade DB2 Express 9.5.4 to DB2 Express 9.7. Reason for this was that old DB2 Express 9.5.4 was 90-day demo version and demo key expired. Upgrading DB2 will generate new 90-day key and allows to use DB2 for some more time which would be enough for finishing application development. It was small VMware DB2 instance with 1GB ram for using during application development.

I pointed that installation of DB2 Express C will be better because it…


Added by Radim Kolar on January 28, 2010 at 4:28pm — No Comments

Federating DB2 and IMS

At last year's

IOD conference, I learned more about two recently announced JDBC tools that had piqued my curiousity: -

InfoSphere Federation Server 9.7's "JDBC wrapper" - …


Added by david t on January 24, 2010 at 9:30pm — No Comments

Oracle 11.1g vs DB2 9.7 Compression

During searching for some good case studies about deployment DB2 compression in data warehouse environments, Google find

following document on Oracle website. It is description how compression works in Oracle 11g.

While this document have some minor errors inside (for example Gzip does not use block compression) i was quite surprised by presented Oracle compression ratio claimed. I could not… Continue

Added by Radim Kolar on January 23, 2010 at 9:41am — No Comments

backup scripts

I was looking for some materials how to prepare the backup for db2.

I found few interesting pages:

An Introduction to DB2 UDB Scripting on Windows

Automated DB2 backups using a script at

Added by Paweł Myrczek on January 14, 2010 at 6:38am — No Comments

IOD Virtual Track for DB2

So, what's this virtual track all about?

As moderator for one of the tracks (DB2 LUW) at the Information On Demand conference, I know first hand how many great session proposals we get. So many, in fact, that we cannot squeeze them all into Mandalay Bay's 1.7 million square feet of meeting space. I thought about reserving Mandalay Bay for, say, another month or so, but few people could stay for that long.

Then the light bulb went on; an internet-based "virtual" track is… Continue

Added by Bob Sawyer on January 13, 2010 at 7:00pm — No Comments

Updating DB2 Express C linux installation to 9.7.1

Yesterday, DB2 Express C 9.7.1 was released. I have one non root db2 9.7.0 copy floating around and wanted to update it. Non root db2 installations are very convenient for casual testing. They can be installed quickly by regular user and you do not need to seek assistance of unix administrator.

Updating DB2 Express C linux installations with standard db2 install program is not possible - you have to do reinstall because unix db2 installer do not have ability to do updates like ms…


Added by Radim Kolar on December 2, 2009 at 11:00am — No Comments

DB2 Express C 9.7 licensing changes

Licensing for DB2 Express C changed in 9.7 version a bit. DB2 Express C is still free to use and distribute, but DB2 Express C FTL - Fixed Term License is no more. FTL licensing option was moved to regular DB2 Express Edition.

This is good move because people sometimes criticised that DB2 Express FTL have more issues than regular express version. Also it will make easier sw maintenance for IBM because they can now concentrate on 3 DB2 Editions (Express, Workgroup, Enterprise). DB2…


Added by Radim Kolar on November 29, 2009 at 11:45am — 1 Comment

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service