Re: dbspace will not allow new tables to be cr....
Hi,
In 11.70 you have a maximum number of partitions per dbspace:
4K page size: 1048445
2K page size: 1048314 (based on 4-bit bitmaps)
http://www-01.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.adref.doc/i
ds_adr_0722.htm
Perhaps is in these limit you are hitting on.
What is the result of the query below?
SELECT COUNT(*)
FROM sysmaster:sysptnhdr
DBINFO('dbspace', partnum) = '<DBSPACE>';
If you try to create a new table in the dbspace what is the error given?
You mention you are getting errors inserting rows also, what is the error?
Keen regards,
On Mon, 2 Mar 2015 at 16:04 LARRY SORENSEN <lsorensen25@msn.com> wrote:
> Thank you. That is valuable information on the tables. My issue appears to
> extend beyound specific tables and affects the entire dbspace. Even though
> there is available space in the dbspace (free chunks), we can't create new
> tables.
>
> Larry
>
> > To: ids@iiug.org
> > From: ddmueller@intercall.com
> > Subject: RE: dbspace will not allow new tables to be cr.... [34745]
> > Date: Mon, 2 Mar 2015 09:53:21 -0500
> >
> > Larry,
> >
> > See this link for some limitations.
> >
> >
> >
> http://www-01.ibm.com/support/knowledgecenter/#!/SSGU8G_11.
> 70.0/com.ibm.adref.doc/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.
> >
> >
> >
> ************************************************************
> *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c38e6650491105105140cb
The result to the query was:
Database selected.
(count(*))
836820
> To: ids@iiug.org
> From: ricardoaireshenriques@gmail.com
> Subject: Re: dbspace will not allow new tables to be cr.... [34748]
> Date: Mon, 2 Mar 2015 12:07:33 -0500
>
> Hi,
>
> In 11.70 you have a maximum number of partitions per dbspace:
> 4K page size: 1048445
> 2K page size: 1048314 (based on 4-bit bitmaps)
>
>
>
http://www-01.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.adref.doc/i
ds_adr_0722.htm
>
> Perhaps is in these limit you are hitting on.
>
> What is the result of the query below?
> SELECT COUNT(*)
> FROM sysmaster:sysptnhdr
> DBINFO('dbspace', partnum) = '<DBSPACE>';>
> If you try to create a new table in the dbspace what is the error given?
>
> You mention you are getting errors inserting rows also, what is the error?
>
> Keen regards,
>
> On Mon, 2 Mar 2015 at 16:04 LARRY SORENSEN <lsorensen25@msn.com> wrote:
>
> > Thank you. That is valuable information on the tables. My issue appears to
> > extend beyound specific tables and affects the entire dbspace. Even though
> > there is available space in the dbspace (free chunks), we can't create new
> > tables.
> >
> > Larry
> >
> > > To: ids@iiug.org
> > > From: ddmueller@intercall.com
> > > Subject: RE: dbspace will not allow new tables to be cr.... [34745]
> > > Date: Mon, 2 Mar 2015 09:53:21 -0500
> > >
> > > Larry,
> > >
> > > See this link for some limitations.
> > >
> > >
> > >
> > http://www-01.ibm.com/support/knowledgecenter/#!/SSGU8G_11.
> > 70.0/com.ibm.adref.doc/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.
> > >
> > >
> > >
> > ************************************************************
> > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c38e6650491105105140cb
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
What error do you get when you try to create a table?
David.
> On 03 March 2015 at 00:45 LARRY SORENSEN <lsorensen25@msn.com> wrote:
>
>
> The result to the query was:
>
> Database selected.
>
> (count(*))
>
> 836820
>
> > To: ids@iiug.org
> > From: ricardoaireshenriques@gmail.com
> > Subject: Re: dbspace will not allow new tables to be cr.... [34748]
> > Date: Mon, 2 Mar 2015 12:07:33 -0500
> >
> > Hi,
> >
> > In 11.70 you have a maximum number of partitions per dbspace:
> > 4K page size: 1048445
> > 2K page size: 1048314 (based on 4-bit bitmaps)
> >
> >
> >
>
http://www-01.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.adref.doc/i
ds_adr_0722.htm
> >
> > Perhaps is in these limit you are hitting on.
> >
> > What is the result of the query below?
> > SELECT COUNT(*)
> > FROM sysmaster:sysptnhdr
> > DBINFO('dbspace', partnum) = '<DBSPACE>';> >
> > If you try to create a new table in the dbspace what is the error given?
> >
> > You mention you are getting errors inserting rows also, what is the error?
> >
> > Keen regards,
> >
> > On Mon, 2 Mar 2015 at 16:04 LARRY SORENSEN <lsorensen25@msn.com> wrote:
> >
> > > Thank you. That is valuable information on the tables. My issue appears
to
> > > extend beyound specific tables and affects the entire dbspace. Even
though
> > > there is available space in the dbspace (free chunks), we can't create
new
> > > tables.
> > >
> > > Larry
> > >
> > > > To: ids@iiug.org
> > > > From: ddmueller@intercall.com
> > > > Subject: RE: dbspace will not allow new tables to be cr.... [34745]
> > > > Date: Mon, 2 Mar 2015 09:53:21 -0500
> > > >
> > > > Larry,
> > > >
> > > > See this link for some limitations.
> > > >
> > > >
> > > >
> > > http://www-01.ibm.com/support/knowledgecenter/#!/SSGU8G_11.
> > > 70.0/com.ibm.adref.doc/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.
> > > >
> > > >
> > > >
> > > ************************************************************
> > > *******************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
>
Check your rootdbs to make sure you're reserved pages aren't full and can't be extended. Prior to 10 I believe, the reserved pages must fit in chunk 1. Past that, when more reserved pages are needed they can be allocated in any rootdbs chunk. If your rootdbs is full and we can't allocate more reserved pages (for upating info such as chunks, dspace info, etc) then new creation of dbspaces will fail. Although now that I think about it, you said table creation was failing, so this is a long shot. Worth leaving on the thread though I think. Mark Scranton www.markscranton.com The Mark Scranton Group mark@markscranton.com