Running db2dart in a db2 with dpf ( aka EEE ) environment

by bitznbitez

The documentation I found from IBM for db2 9.5 LUW on the db2dart command was not clear about what happens when you run it in a partitioned database environment.   Tonight I had a need to run it on a 40 partition tens of terabyte range database.

The behavior that I observed is that db2dart only inspects the partition it is connected to when you invoke it.  I also observed it did not use a lot of resources.  So I ran it in parallel on all 40 data partitions at once.

I post this in case anyone else is pondering db2dart in a partitioned database environment….

Advertisements