T
TheMadDBA
Guest
It is very easy to get misleading results with ndisk (and other tools like that). For example: reading small files over and over again will most likely read from the AIX or SAN buffer cache instead of actually hitting the disk. This makes the hardware seem much faster than it really is. There aren't really any magic switches to flip between AIX7 and AIX8. A few things to check.... 0) Does your new LPAR span NUMA zones? This can be a huge problem. 1) Check your Progress startup parameters and DB settings to make sure they are the same. 2) Compare the output of the following commands on both AIX boxes.. looking for differences ioo -a (io related parameters) vmo -a (memory related parameters) lsps -a (paging space) 3) use nmon and iostat to compare what is going on with memory,cpu and disk during your tests (on both systems) 4) use promon to compare what is happening at a database level (on both systems) 5) check the queue_depth settings on all of your disks using lsattr -El hdiskname How big is your database and each AIX LPAR? Is this batch job a single Progress session or a collection of processes?
Continue reading...
Continue reading...