dbspace will not allow new tables to be created
IDS 11.70.FC1 RHEL 5 We have a server that is erroring out with new table creation, including temporary tables. Many tables will not allow us to insert new data. There is space in the dbspace. We tried to create a table in another dbspace, and it worked; but the primary data dbspace will not. The database is not excessively large, but there does appear to be a table or two that has reached the page limit and will need to be fragmented or moved to another dbspace with a non-default pagesize. My question is, does a dbspace have a page limit as well; or what other situations could cause this? Thanks. Larry > To: ids@iiug.org > From: mpruet@us.ibm.com > Subject: Re: Replicate [34742] > Date: Sat, 28 Feb 2015 09:54:44 -0500 > > You can still use 'cdr check' with a grid environment. > > From: "Jorge Valenzuela" <jorgervt@gmail.com> > To: ids@iiug.org > Date: 02/28/2015 08:51 AM > Subject: Re: Replicate [34741] > Sent by: ids-bounces@iiug.org > > We used the grid in this replication is there a way to validate if all = > the > information its the same on both sides? > > Enviado desde mi iPhone > > > El 27/02/2015, a las 12:59, Art Kagel <art.kagel@gmail.com> escribi=F3= > : > > > > To replicate between different platforms you have to either use > Enterprise > > Replication (ER) or a third party replication system like DbMoto. Bot= > h > > have features that will let you validate the current state of the > > replicates. > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opini= > ons > > and do not reflect on the IIUG, nor any other organization with which= > I > am > > associated either explicitly, implicitly, or by inference. Neither do= > > > those opinions reflect those of other individuals affiliated with any= > > > entity with which I am affiliated nor those of the entities themselve= > s. > > > > On Fri, Feb 27, 2015 at 3:48 PM, Jorge Valenzuela <jorgervt@gmail.com= > > > > wrote: > > > >> Hi, > >> We set up an replication from aix to suse. > >> How can I know if all the data are replicating correctly ? > >> Thanks in advance. > >> > >> Enviado desde mi iPhone > > > ***********************************************************************= > ******** > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --001a113ecaac6d589f0510182415 > > > > > > > ***********************************************************************= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Larry, See this link for some limitations. http://www-01.ibm.com/support/knowledgecenter/#!/SSGU8G_11.70.0/com.ibm.adref.do c/ids_adr_0721.htm Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Monday, March 02, 2015 9:42 AM To: ids@iiug.org Subject: dbspace will not allow new tables to be created [34744] IDS 11.70.FC1 RHEL 5 We have a server that is erroring out with new table creation, including temporary tables. Many tables will not allow us to insert new data. There is space in the dbspace. We tried to create a table in another dbspace, and it worked; but the primary data dbspace will not. The database is not excessively large, but there does appear to be a table or two that has reached the page limit and will need to be fragmented or moved to another dbspace with a non-default pagesize. My question is, does a dbspace have a page limit as well; or what other situations could cause this? Thanks. Larry > To: ids@iiug.org > From: mpruet@us.ibm.com > Subject: Re: Replicate [34742] > Date: Sat, 28 Feb 2015 09:54:44 -0500 > > You can still use 'cdr check' with a grid environment. > > From: "Jorge Valenzuela" <jorgervt@gmail.com> > To: ids@iiug.org > Date: 02/28/2015 08:51 AM > Subject: Re: Replicate [34741] > Sent by: ids-bounces@iiug.org > > We used the grid in this replication is there a way to validate if all > = the information its the same on both sides? > > Enviado desde mi iPhone > > > El 27/02/2015, a las 12:59, Art Kagel <art.kagel@gmail.com> > > escribi=F3= > : > > > > To replicate between different platforms you have to either use > Enterprise > > Replication (ER) or a third party replication system like DbMoto. > > Bot= > h > > have features that will let you validate the current state of the > > replicates. > > > > Art > > > > Art S. Kagel, President and Principal Consultant ASK Database > > Management www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own > > opini= > ons > > and do not reflect on the IIUG, nor any other organization with > > which= > I > am > > associated either explicitly, implicitly, or by inference. Neither > > do= > > > those opinions reflect those of other individuals affiliated with > > any= > > > entity with which I am affiliated nor those of the entities > > themselve= > s. > > > > On Fri, Feb 27, 2015 at 3:48 PM, Jorge Valenzuela > > <jorgervt@gmail.com= > > > > wrote: > > > >> Hi, > >> We set up an replication from aix to suse. > >> How can I know if all the data are replicating correctly ? > >> Thanks in advance. > >> > >> Enviado desde mi iPhone > > > ********************************************************************** > *= > ******** > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --001a113ecaac6d589f0510182415 > > > > > > > ********************************************************************** > *= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ********************************************************************** > *= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.