partition limit

Hi, I have one server that my company use to give support to our clients. The server is using 12.10.FC10 version and we are facing one problem with partition limits. As we use one partition for all database and index also, the problem is that have dbspaces have less than 50% occupied but can´t use that space because the number of partitions is higher than 1048445. My question is, if I define bigger Page size (8K for example) the problem still exists? There is any easy way to alter fragments? I have now more than one hundred databases on this server and I am looking for one quick and some easy solution if it is possible. Thanks for any help, SP

Create new dbspaces, use the -ef / -en options of onspaces (maybe with 5000) and move a few databases (smaller ones to make it quicker) to these new dbspaces. On Fri, Mar 23, 2018 at 3:41 PM, SERGIO PERES <sergio.peres@airc.pt> wrote: > Hi, > > I have one server that my company use to give support to our clients. > The server is using 12.10.FC10 version and we are facing one problem with > partition limits. > As we use one partition for all database and index also, the problem is > that > have dbspaces have less than 50% occupied but can´t use that space because > the > number of partitions is higher than 1048445. > My question is, if I define bigger Page size (8K for example) the problem > still exists? > There is any easy way to alter fragments? > I have now more than one hundred databases on this server and I am looking > for > one quick and some easy solution if it is possible. > > Thanks for any help, > > SP > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

Hi Fernando, There is any easy way to do it? Or do I need to export/import? Thanks, SP