January 2010 Blog Posts (10)

Eu posso ter campos GUID no DB2

Comecei a utilizar o DB2 a pouco tempo e gostaria de saber se existe um tipo de campo GUID ou similar no banco.

Added by Rodrigo Mendes Guedinho on January 28, 2010 at 9:06pm — 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

2009's 10 Most Popular Replication Features for DB2

While preparing for what's likely to be coming my way in 2010, I thought about the topics I spent the most time on in 2009. I eventually wound up with a list of 10 that I felt were the most popular with the sales teams and customers I worked with. I thought I had a pretty good list :) so I emailed it to my collegues to get their impression. Naturally, everyone had at least a slightly different list and, when there was overlap, everyone wanted a slightly different order. Go… Continue

Added by david t on January 17, 2010 at 10:00pm — 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

Convert the tablespace from normal to large


Today I faced the following problem:

db2 "alter tablespace 12csdx resize (all 19067605)"

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL1139N The total size of the table space is too big. SQLSTATE=54047

There are to option which you can take:

1. review the data stored in the tablespace,

2. convert the… Continue

Added by Paweł Myrczek on January 14, 2010 at 6:18am — 1 Comment

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

Replicating Changed Data From DB2 to PostgreSQL

In my previous post, I showed how federated database technology can make PostgreSQL tables appear as though they're DB2 tables to DB2 users. Naturally, one of the first follow-on questions I get about this is, if these look like DB2 tables, can they be used with DB2's built-in change data capture technology called SQL… Continue

Added by david t on January 11, 2010 at 1:49pm — No Comments

Federating DB2 and PostgreSQL

In its 9.7 release, InfoSphere Federation Server added a "JDBC wrapper." This is an interface that lets the Federation Server access a database through that database's JDBC driver. Someone asked me if I thought PostgreSQL could be accessed this way and then federated with DB2.… Continue

Added by david t on January 7, 2010 at 8:00pm — 4 Comments

Monthly Archives













Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service