Re: Table modification transaction size problem

} Hello, } } I have a esql-c program that is going to alter a table. } } This is Online database with transactions } } I need to calculate if this alter will hang due to the size } of the transaction being to big. } } I would assume I need to calucate how big the transaction } would be and then calulate how big of a transaction my online } system can handle. } } Has anyone ever done this??? } } Any sugestions?? } } Thanks } } Randy Paries } rtparies@ingr.com We started down this road, then gave up and made our applications which were likely to deal with a large number of rows do it one-by-one. Each transaction is begun and commited for *each row*. This is a little slower but never, ever fills up the logs or locks. It is also not dependent on the output of tbstat/onstat, and it doesn't require any extra insight to understand (in the maintenance phase). You can calculate the transactions if you want to, though. The output of tbstat -k (locks) and tbstat -l (logs), plus the size of the rows you are affecting, plus the overhead of indexes and adjacent keys (depending on the version). All of this is detailed in the OnLine Admin Guide, though where depends (again) on what version. Good luck, __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|