ISAM 136: no more extents

HI! I have a table wich by now is not fragmented that already reached the limit of 17M pages and are giving me the "isam 136" error message. This table have aprox. 17 hundreds of millions records, in a production environment. Can I do a fragmentation without unload and reload? How?, just making apropiated "alter table"? Do i need rename it and deal with programs? In nearly two months this data will be migrated to another plataform. I have 9.40 IDS runnig on AIX. thanks in advance. Fernando

Yes you can do this without unloading using the ALTER FRAGMENT ... INIT ... statement. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Oct 30, 2009 at 1:27 AM, FERNANDO PAEZ BECKER < fpaezbecker@hotmail.com> wrote: > HI! > I have a table wich by now is not fragmented that already reached the limit > of > 17M pages and are giving me the "isam 136" error message. This table have > aprox. 17 hundreds of millions records, in a production environment. Can I > do > a fragmentation without unload and reload? How?, just making apropiated > "alter > table"? Do i need rename it and deal with programs? > > In nearly two months this data will be migrated to another plataform. > > I have 9.40 IDS runnig on AIX. > > thanks in advance. > > Fernando > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174028da16f58b047727fe3c