|
||||||
|
The db2pd command is a relatively new command (released with version 8.2) that will tell you a huge amount of information about your db2 system. I first made myself familiar with it when looking for a way to get the status of HADR without going through a snapshot output. db2pd -db sample -hadr - will tell you all you need [...] Some time ago, I had the requirement to sample data from a table to do validation work. Basically, we wanted to validate syncronized data with a base table, but could not afford to compare every row. We had to come up with a way to ‘sample’ the data. Each table we had to sample had [...] One of the things I find very powerful in my day to day work as a DBA, is the use of inline shell/awk scripts. I use this technique when I need to do the same thing to many objects. I often use it when I want something quick and dirty or create a base script [...] |
Site hosted by:
|
|||||
|
Copyright © 2012 DBMSguy.com - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
