doyouDB2.com

DB2 LUW - Tips and Tricks

Taming the wild cards - REOPT

Tuesday, 26 August 2008 11:44 A lazy dba

Any DBA who has worked on solving performance issues would know about the problems parameter markers and host variables create during query optimization. If you use parameter markers, the query is not compiled every time it is executed, but you end up with a sub-optimal plan since db2 does not know the values that will be passed at query run time.

There is a way out of this situation.

Write comment (0 Comments)

Geolocation and Geopolitics of (doyou)DB2 users

Tuesday, 19 August 2008 14:51 A lazy dba

The google analytics report of doyoudb2.com paints a very interesting picture of worldwide db2 users.

While it would not be exactly accurate to extrapolate the geolocation of doyoudb2.com visitors to represent actual db2 users around the world (due to various reasons), I am doing it just for fun. However, the google analytics site visitor statistics do give a fairly approximate idea of countries where most db2 users reside, and also tell about the global reach of db2.

Write comment (0 Comments)

DB2 CLI driver (for SAP DB2 DBAs only)

Tuesday, 12 August 2008 14:17 A lazy dba

If you are a DB2 DBA supporting SAP and your SAP system is BASIS 7.0 SR2 or lower, then you would have a "db2 runtime client" installed locally on each and every SAP application server. This means that you also have a db2 instance and a OS user on each application server.

This kind of configuration adds a lot to your maintenance work. Whenever you do a fixpack upgrade, you have got to apply the fixpack on all the application server (not forgetting a failvoer server or two - which incidentally many forget). Further you have to maintain all those db2instances and the OS users on the application servers.

Write comment (0 Comments)

Restoring a v8 backup into a v9 database

Monday, 04 August 2008 02:25 Ajay Jain

Here is a tip from db2 expert Ajay Jain on how to restore a db2 v8 database into a db2 v9 instance.

If you are also working for a client like me, where migrating production system(s) to latest version(V9) takes months even after you migrated the QA/DEV/other boxes, then I assume, you may face a situation when there is a need to restore v8 prod copy into one of the v9 migrated QA/DEV/other DB2 instance/db.

Here are two ways in which you can achieve this:

Write comment (1 Comment)

How to remove duplicate rows/date from a table

Thursday, 31 July 2008 14:22 A lazy dba

Recently a colleague asked me for a quick way to delete duplicate data from a big table. The problem my colleague faced was that he had to create a new unique index on a table with over million records. There were many duplicates records in the table with respect to this new index and hence his create index command failed.

The quickest and the easiest way I could think was to do the following:

Write comment (2 Comments)

DB2DART – Extract data from a Corrupted Table

Tuesday, 29 July 2008 10:51 Vijay Budde

This tip has been submitted by Vijay Budde. Mr. Budde is a long time db2 expert and enjoys tuning db2 databases for optimal performance.

If a table in the database gets corrupted because of any reason (say a hardware problem), attempts to access the table through SQL may not work and db2 might drop all the connections to the database and even mark the database as BAD.

Write comment (0 Comments)

DB2@25

Friday, 25 July 2008 10:23 A lazy dba

DB2 has journeyed long way from being the first Relational Database to one which can support XML data and queries and web 2.0 applications.

DB2 turned 25 on June 07, 2008.

Join in celebrating the silver anniversary of DB2. Here is the link to a DB2 birthday page http://www.bulldogsolutions.net/IBMims/IBN_DB2_Birthday/index.aspx?bdls=15792

Write comment (0 Comments)

ROLLFORWARD to END OF BACKUP - Finally!

Thursday, 24 July 2008 10:44 A lazy dba

I always hated DB2 for the way it had structured the rollforward to work post restore from an online backup. Most of the times, while restoring to a target database on a different system, I just wanted to rollforward my database till the end of backup and would have liked a single straightforward command. But until v9.5 arrived, I had to use a roundabout way to accomplish this feat.

Prior to v9.5, to find the minimum recovery time of the database backup, I had to issue a the following command:

Write comment (0 Comments)

More Articles...

«
Start
Prev
1
2
3
4
Next
End
»

Page 1 of 4

	Re:Upgrading to db2 v9.5 on SAP ERP (Netweaver)	2008/08/25 14:31 by jersing
	Upgrading to db2 v9.5 on SAP ERP (Netweaver)	2008/08/25 14:12 by zero
	Re:Strange issues with remote shell (rsh)	2008/08/22 16:37 by zero
	Strange issues with remote shell (rsh)	2008/08/22 14:03 by jersing
	Re:Welcome to the Forums	2008/08/22 13:58 by jersing
	Re:SQL5043N	2008/07/21 15:21 by db2admin
	Re:SQL5043N	2008/07/21 15:07 by zero

doyoudb2

Taming the wild cards - REOPT

Geolocation and Geopolitics of (doyou)DB2 users

DB2 CLI driver (for SAP DB2 DBAs only)

Recommended reading lists

Restoring a v8 backup into a v9 database

How to remove duplicate rows/date from a table

DB2DART – Extract data from a Corrupted Table

DB2@25

ROLLFORWARD to END OF BACKUP - Finally!

Search Site

Main Menu

Subscribe

Categories

Sign In/Register

Add to Google

Got a DB2 Tip/Trick?

DB2 Forum - Latest Posts

Most Popular

DB2 Poll