Re: Help! Ontape running very slow.

yes, that was suggested to me by informix support. i will have to try it on our test systems to see how long it will take. how do you check to see what page a row is on? ty -- Ty O'Kelly DBA tokelly@maxor.invalid.com 806-324-5521 Rob Wilson wrote: > For those interested, the workaround is to run a harmless update on the table > like: > > update table tab1 set col1 = col1; > > for every table before you back it up. This may or may not be a valid > workaround (depends how long it takes to update all your tables). > > Of course if you wanted to get real fancy you could write something that > only updates one row on every used page, that would probably run faster. > -- > Rob Wilson > rwilson@ntsource.com