• No replies
1 Post

Pinned topic Informix 11.50 fc6 alter fragment make a longtx

‏2014-05-07T02:13:15Z | fragment longtx

HI ,all


i have encounted a serious problem that is when i execute alter frament  add another fragement it crossover 4Gb Logical log dosen't finish,so it was reached the threshold of LONGTX.but sometimes it was very fast almost 1 seconds to finish.


the sql was:

alter fragment on table xxxxhistory add (xx_time>='2014-05-04 00:00:00' and xx_time<'2014-05-14 00:00:00' ) in xxxhis05;

i don't know why is that,it maybe a bug or something?


table's row size about 8k and dbspace using 8k

table count(*) have over 79,000,000 row



pls help me,thanks!



btw:table have 10,00,000 times insert and 500,000 update a day.index have not fragemnt

Updated on 2014-05-07T05:06:00Z at 2014-05-07T05:06:00Z by 2RU9_tang_yi