by Vikram Khatri | Nov 21, 2006
When should you create detailed distribution statistics on indexes in DB2? DB2 9 auto runstat uses following syntax for generating statistics for your table. runstats on table t1 with distribution and sampled detailed indexes all Please note that it is using...
by Vikram Khatri | Nov 21, 2006
Generally, DBAs ask the equivalent of Oracle’s bitmap indexes in DB2. DB2 optimizer takes away the burden of creating / maintaining bitmap indexes as it creates them on the fly when it needs them. How do you know if DB2 optimize is using bitmap index or not?...
by Vikram Khatri | Nov 20, 2006
In DB2 on z/OS, you can deny lock escalation (Allow row level locks to be acquired until resources are consumed and not escalate locks from row level to a table level) by setting LOCKMAX=0 in CREATE or ALTER table space. Can you do same thing on DB2 on distributed...
by Vikram Khatri | Nov 20, 2006
David Marvin explains the difference between Connection Pooling and Connection Concentrator as follows: Connection pooling is the methodology to place a connection for later re-use after an application has disconnected (no longer requires the connection). The next...
by Vikram Khatri | Nov 20, 2006
Igor Nikiforov has contributed various string manipulation functions for DB2 using SQL PL. You may see this link for the original article. You may download the script from this link. The following string manipulation functions are included in above script. AT():...
by Vikram Khatri | Nov 9, 2006
IBM was little late in the relational database business on Linux, Unix and Windows platforms compared to the Oracle even though IBM was the inventor of RDBMS. With new release of DB2 9, IBM has taken the lead in innovations in relational database with the introduction...
by Vikram Khatri | Nov 9, 2006
Are you new to DB2? Are you making a transition from either Oracle, Sybase or SQL Server? Are you trying to learn DB2 to make your resume look better? One of the immediate challenge for you to is to learn new stored procedure (SQL PL) language quickly. But if you have...
by Vikram Khatri | Nov 8, 2006
Whenever you update statistics in your tables or modify any of following configuration parameters or bind options, you need to rebind the packages for updating the new access paths of the SQLs. Configuration Parameters that affect execution of SQL queries AVG_APPLS...
by Vikram Khatri | Nov 7, 2006
DB2 9 is a feature packed database with performance features, pureXML, high availability etc. As a DBA, you might want to know which features are being used in your database so that you are not caught with surprise. Run the attached script in your database to find out...
by Vikram Khatri | Nov 6, 2006
DB2 9 provides a brand new schema SYSIBMADM with many new views in it. This is nothing new as same capability was available through SQL Table functions but this is more elegant. If you worked with Oracle and liked its v$ views so this is very much similar to v$ views...
by Vikram Khatri | Nov 6, 2006
In my opinion, the quickest and easiest way to learn DB2 is through its control center. Over the number of years, Control Center has come a long way and it provides an easy way to learn DB2. I do not want to invite a flame war on my personal view about the Control...
by Vikram Khatri | Nov 6, 2006
As an ISV, you might want to protect your intellectual capital of DB2 Stored Procedures that you created for your product. You might not want your end-users to see how you coded your DB2 stored procedures. These are the steps that you have to take to hide the SQL PL...
by Vikram Khatri | Oct 6, 2006
My database of choice is db2 and this site is an attempt to db2ude others in this technology by sharing information, tips and techniques. Why name db2ude? Once upon a time, I was giving presentation on db2 to a customer and afterwards, one of my colleague commented...
by Vikram Khatri | Feb 3, 2004
Welcome to my 20th century Social Media Page. I chose not to be on Face Book or Google + or Tweeter or any other social media except Linked In. Sometime, I feel that I am the odd man out by not being on the social media but so far I am able to live without these. I...
