Re: Table modification transaction size problem

onlinedbc@cix.compulink.co.uk ("Malcolm Weallans") wrote: >I show people how to do this on my OnLine Administration courses. >Interested? >> 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 >> > > >Malcolm Weallans >Online Database Consultancy >Phone 0628-72154 >Fax 0628-37463 >CIX - onlinedbc This is a forum for FREE exchange of information. I appreciate you trting to make a living but this person has a valid question and does not deserve a sales pitch as an answer, The answer is: 1) Switch the database to NO LOGGING. (You can do this easily through tbmonitor or from the command line). 2) Perform the ALTER statements, which, by the way, run faster because there is less I/O writting logs to disks). 3) Take database off-line. 4) Temporariy change the Tape Backup device setting to "/dev/null" (OPTIONAL) ( This makes the next mandatory step very fast ). 5) Perform a level 0 archive. 6) Restore the database back to it previous LOGGING Option (I think Unbuffered is best). 7) Restore the Tape device back to proper setting, if step 4 was done. 8) Bring the database back on-line. You may choose to do a real tape archive in step 5. All the better. -------------------------------------------------------- Rob McAllister rmcall@on-ramp.ior.com Spokane, WA "On all good programmers a little core must dump"