 |
|
| Computers Forum Index » Computer - Databases - Informix » adding rowids to a frag'd table... |
|
Page 1 of 1 |
|
| Author |
Message |
| ... |
 Posted: Tue Nov 03, 2009 6:23 pm |
|
|
|
Guest
|
IDS 10 FC8
HPUX 11
Greetings
I'm in the process of altering a 22 mil row table frag'd across 4 dbspaces
to accomodate connectivity through windoze SSIS which is dependant upon the
rowid. Why...I don't know....is sqeal!
Anyway, I keep running into a long trans. I've dropped all the indexes,
altered the table to raw, locked the table in exclusive to avoid blowing
the locks, and I still run into a long trans. This is a test system I'm
running this on so there is little or no other activity running. There are
approx 120 logs at 100 meg each. I know I'm not filling 50% of the logs.
I'm also not blowing space.
Other than unloading, dropping, recreating the table with rowids, does
anyone have other ideas? or what may be causing the long trans?
Thanks!
========================
Darren Jacobs
Sr Database Analyst
Darren_Jacobs at (no spam) carmax.com
804.747.0422 x3221
======================== |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Tue Nov 24, 2009 8:55 pm
|
|