Feeds:
Posts
Comments

Archive for the ‘DB2’ Category

Multiple NULL values in a Unique index in SQL Server/DB2 LUW

Posted in DB2, Oracle, tagged , , , , on May 3, 2008 | Leave a Comment »

By decipherinfosysThis project needed to support having multiple NULL values in the column and still have a UNIQUE constraint. That is allowed by Oracle but not in SQL Server and DB2 LUW. There is a way to make this work in SQL Server and DB2 LUW also but that requires a work-around. Consider this table:
CREATE [...]

Read Full Post »

Compare data between 2 identical tables in DB2

Posted in DB2, Oracle, tagged , , , on May 3, 2008 | Leave a Comment »

User comments for the following queries are highly appreciated..
How does one compare data between 2 identical tables in DB2 ? In Oracle, one can use the minus option which is not there in DB2.

Read Full Post »

To truncate DB2 Table

Posted in DB2, tagged , , , on April 20, 2008 | Leave a Comment »

DB2 Truncate is not as straight forward as Oracle Truncate. If in Oracle you can use “truncate table “…  You may use the below command to truncate table in db2.
alter table schema.table_name activate not logged initially with empty table

Read Full Post »

IBM Database Business Keeps Growing

Posted in DB2, tagged , , , , , , on April 18, 2008 | Leave a Comment »

IBM officials said the company’s database business, bolstered by last year’s releases of DB2 9.5 and IDS 11, enjoyed a solid first quarter of 2008.
With all the talk surrounding IBM’s successful first quarter for 2008, the company’s data server business could get lost in the shuffle. 
But the release of Big Blue’s DB2 9.5 database is [...]

Read Full Post »

DB2 LUW Performance: Table Read I/O and Overflows

Posted in DB2, tagged , , , , , , , on April 10, 2008 | Leave a Comment »

Understanding Table I/O performance is critically important to properly diagnosing the health and efficiency of a database and pinpointing problems. In fact, if I only had just a few minutes to quickly assess a database, I’d look at 3 key measurements…

The Database Synchronous Read Percentage, SRP,
The Database Index Read Efficiency, IREF,
Table I/O measurements:

The average number [...]

Read Full Post »

Tips about DB2 database load

Posted in DB2, tagged , , , , on April 8, 2008 | Leave a Comment »

Requirement : With the DB2 databases on DB2 V8.1.0.12 on a SUSE 9 Linux image. The developers are using RAD and have Apache Derby on their Windows PCs to use for a development database. Need to export all the data from all the tables from two of our databases for them to import into their [...]

Read Full Post »