Excel sheet to monitor your diaglog – Try it today

November 11, 2011

Monitoring diaglog is a typical daily DBA chore. But sometimes it is tedious to go through the volume of data in the diaglog .  As mentioned in my previous blog post Monitoring diaglog , there are different ways to keep track of diaglog We have come up with an excel sheet that will automatically generate [...]

Read the full article →

db2diag and db2dart – 2 life saver utilities

September 13, 2011

Monitoring diagnostic log is very important task in a DBA`s daily life. When you compare this with onset of a chronic disease like heart attack or cancer you find that they are analogies. For these chronic diseases you will see symptoms like pain, weight loss and other related symptoms before the disease actually reaches serious stage. [...]

Read the full article →

LDAP and DB2 – The Complete Guide

August 4, 2011

What is LDAP? LDAP stands for Lightweight Directory Access Protocol. It is a client server access protocol to access the information directory. This directory can store information like userids, email ids and so on. In db2 you can set LDAP using 2 methods • Plugin method • Transparent LDAP Two Methods :   PLUGIN METHOD: [...]

Read the full article →

Four tips for you

July 21, 2011

  DETECTING LOCK WAITS ————————————                   UNUSED INDEXES —————————–               LINUX ALIASES ————————-               PRUNING HISTORY —————————–              

Read the full article →

checklists are handy sometimes

November 4, 2010

table { font-size: 10pt;} As a DBA one of the common task is setting up new database(s) for a new application. So when the application is built from scratch you will be involved in the full life cycle of the project. Do you have a handy checklist to validate the configurations for the new databases. [...]

Read the full article →

Shared memory issue::shared memory segments can not be allocated

February 16, 2010

SQL1084C Shared memory segments cannot be allocated Have you seen above message anytime? It is annoying when you see this message.Basically first thing you can try is changing instance_memory and database_memory Important kernel parameters to be considered here are shmmax and shmall.Shmmax is the maximum size of a shared memory segment and shmall is the [...]

Read the full article →

Db2 purescale and Oracle RAC

October 23, 2009

IBM announced a new technology called Purescale recently.It is basically a technology that excels in horizontal scalability. So what is horizontal scalability??How is it different from vertical scalability?? Horizontal scalability is the ability to add capacity by adding nodes to the cluster whereas vertical stability is the ability to increase capacity by adding extra resources [...]

Read the full article →

Basic db2 federation setup

October 13, 2009

Db2 federation can be used to retrieve information from non-db2 sources like oracle,sql server.It also can be used with db2 datasources.Setting up federation can be confusing at times.Below is the basic procedure that can be used to setup federated system: 1)Enable federation: Federation can be enabled by running the following command update dbm cfg using [...]

Read the full article →

HADR performance – part 1

October 5, 2009

HADR stands for high availability disaster recovery .This solution is used for disaster recovery purpose on db2 udb databases.HADR should be configured properly inorder to have optimal performance: 1)HADR synchronization mode:HADR can be run in 3 different modes SYNC,NEARSYNC,ASYNC.SYNC mode gives the best protection to data.In this mode primary has to wait until the changes [...]

Read the full article →

Alter table not logged initially

September 23, 2009

Here is a little code that descripts the usage of “alter table not logged initially” db2 “connect to SAMPLE”; DB2CMD1=”alter table SAMPLE.employee activate not logged initially” DB2CMD2=”INSERT INTO SAMPLE.employee values(,,,,,,,,,,)”DB2CMD3=”commit” db2 +c -tv “${DB2CMD1}”; db2 “${DB2CMD2}”; db2 “${DB2CMD3}”;

Read the full article →