Thanks to every one who participated in the beta testing of the diag tool (http://db2tutorial.net/beta-testers-needed-db2-diaglog-monitor-tool/).. Special thanks to Paul, Manoj , Raf , Rajesh , Alex

Thanks to DB2 expert Serge Rielau for liking the tool

 

 

Below are the results (tested on multiple servers):

 

 

 


We are working on few improvements and more people are invited for the testing.. Please send the following details to db2tutorialnet@gmail.com :

 

Name:

Email:

Contact number:

 

 

{ 0 comments }

 

Earlier we discussed about diaglog and its importance. We also designed an excel utility(http://db2tutorial.net/excel-sheet-to-monitor-your-diaglog-try-it-today/)

Now we are coming up with a GUI tool that monitors diaglog for all your servers. All the data is cached locally and it gives a monthly,weekly and daily overview of errors across all your servers. So you have diag report for all your servers in one place. It is still in testing phase and we need few volunteers to validate the functionality and suggest any improvements.

Please send the following information to our email db2tutorialnet@gmail.com. We will be contacting you shortly

Name:

Email:

Contact number:


Few screenshots

 

 

{ 0 comments }

Backup validation – Are you doing it right ?

May 12, 2013

Backup and Recovery is the most important task for any DBA.  As a DBA we have to ensure that all our backups are running successfully and reaching netbackup/TSM . Below are some of the common scenarios we face : Make sure that you validate all your critical databases so that you can have a good [...]

Read the full article →

Split mirror and db2relocatedb – powerful db2 recovery options

April 12, 2013

All of us are familiar with backup/restore commands  and this is the most widely used method for db2 backup and recovery. But there are other ways you can use to backup and recover your data. 1)Advanced Copy Services(ACS) 2)Split mirror 3)db2relocatedb Let me explain my experience with these utilities. We had a 4TB database and [...]

Read the full article →

db2 wallpapers- db cfg parameter listing

December 28, 2012

DBM_cfg_print_URL DB_cfg_print_URL These charts will provide the following information :

Read the full article →

Virtualization basics – zlinux and P series

November 15, 2012

Virtualization is the process of creating virtual version of a device or a resource. Virtualization can occur at different levels: Server virtualization Storage virtualization OS level virtualization Network virtualization Application virtualization In this article we are going to discuss on zlinux and AIX P series. Below are the common terms you hear when someone talks [...]

Read the full article →

Google searches for db2 terms & DBA job trends

May 14, 2012

Have you ever wondered about the popular db2 terms on Google.. How many people are searching for a word like ‘db2 compression’ ? How many people are interested in the ‘Purescale’ technology ? Below are some of the popular terms on Google search. To get the entire data please visit www.google.com/adwords and search for “db2″ [...]

Read the full article →

Interview with db2 9.7 advanced admin book author

February 1, 2012

Adrian Neagu and Robert Pelletier authored a db2 9.7 book which is scheduled to release in March 2012. Below is the Amazon link and you may preorder it now.. I am in the technical review board for this book and I found the content interesting , especially the code snippets for DBA tasks About the [...]

Read the full article →

db2 wallpapers- dbm cfg parameter listing

January 27, 2012

Below is the chart that you should pin to your cubes: It depicts: You can print the chart by going to the below URL DBM_cfg_print_URL

Read the full article →

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 →