Topic
  • No replies
2RU9_tang_yi
2RU9_tang_yi
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