sysmaster systabauth space issue
User encountered error 312 (Cannot update system catalog systabauth) with error 131 (no free disk space) while adding indexes, despite rootspace having plenty of free space. Art Kagel explained that systabauth exists in every database's catalog (not just sysmaster), so the error likely meant that specific database's catalog dataspace ran out of space, or systabauth had too many extents. No explicit resolution provided.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IBM Informix Dynamic Server Version 9.40.HC5 - yes I know its not supported
HP-UX wdcuast5 B.11.11 U
while adding indexes to table ran out of space in dataspace - straight forward
enough to fix.
However I dont understand why I see the following error
Near character position 44
312: Cannot update system catalog (systabauth).
131: ISAM error: no free disk space
Error in line 1Near character position 30
I dont understand why I see this message when the systabauth is in the
sysmaster dataabse which is in the rootspace which has plenty of room.
Chunk Pathname Size Used Free
/opt/informix/chunks/response/root_response 32000 13196 18804
/opt/informix/chunks/response/root_response_temp 50000 6740 43260
does anyone have an answer please
Actually, systabauth is a database catalog table and one exists in every
database, so it just maybe the the database catalog for this database is in
the dataspace that ran out of free pages. It is also possible that the
systabauth table in this database has too many extents.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, 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 themselves.
On Tue, Apr 5, 2011 at 6:39 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote:
> IBM Informix Dynamic Server Version 9.40.HC5 - yes I know its not supported
> HP-UX wdcuast5 B.11.11 U
>
> while adding indexes to table ran out of space in dataspace - straight
> forward
> enough to fix.
> However I dont understand why I see the following error
> Near character position 44
> 312: Cannot update system catalog (systabauth).
> 131: ISAM error: no free disk space
> Error in line 1> Near character position 30
>
> I dont understand why I see this message when the systabauth is in the
> sysmaster dataabse which is in the rootspace which has plenty of room.
> Chunk Pathname Size Used Free
> /opt/informix/chunks/response/root_response 32000 13196 18804
> /opt/informix/chunks/response/root_response_temp 50000 6740 43260
> does anyone have an answer please
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf307abcf9ef594204a0349512
thanks for that if I do
dbschema -d test0111 -t systabauth i cant see the tableNo table or view systabauth.
If I do dbaccess - table info systabauth
I can see the table , why is this
Because dbschema is trained not to report on the structure of the system catalog. Maybe you could use Art's MySchema instead?
And because DB-Access isn't quite as unhelpful as DB-Schema.
-=JL=-
------Original Message------
From: KARL OLIVER
Sender: ids-bounces@iiug.org
To: ids@iiug.org
ReplyTo: ids@iiug.org
Subject: Re: sysmaster systabauth space issue [23344]
Sent: Apr 5, 2011 18:21
thanks for that if I do
dbschema -d test0111 -t systabauth i cant see the table No table or view systabauth.
If I do dbaccess - table info systabauth
I can see the table , why is this
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Sent from my BlackBerry® smartphone, powered by CREDO Mobile.
Because dbschema will not print out schema for system catalog tables. You
will get the same result for dbschema -d test0111 -t systables
My myschema utility will print out systabauth and other catalog tables if
you explicitely as for them.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, 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 themselves.
On Tue, Apr 5, 2011 at 9:21 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote:
> thanks for that if I do
> dbschema -d test0111 -t systabauth i cant see the table> No table or view systabauth.
>
> If I do dbaccess - table info systabauth
> I can see the table , why is this
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3071c9dc793e3804a035f4ca
I bet you say that to all the girls!
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, 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 themselves.
On Tue, Apr 5, 2011 at 9:26 PM, jonathan.leffler@gmail.com <
jonathan.leffler@gmail.com> wrote:
>
> Because dbschema is trained not to report on the structure of the system catalog. Maybe you could use Art's MySchema instead?
>
> And because DB-Access isn't quite as unhelpful as DB-Schema.
>
> -=JL=-
>
> ------Original Message------
> From: KARL OLIVER
> Sender: ids-bounces@iiug.org
> To: ids@iiug.org
> ReplyTo: ids@iiug.org
> Subject: Re: sysmaster systabauth space issue [23344]
> Sent: Apr 5, 2011 18:21
>
> thanks for that if I do
> dbschema -d test0111 -t systabauth i cant see the table > No table or view systabauth.
>
> If I do dbaccess - table info systabauth
> I can see the table , why is this
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> Sent from my BlackBerry® smartphone, powered by CREDO Mobile.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec53f91dd06676404a035f6ed
On Tue, Apr 5, 2011 at 18:26, jonathan.leffler@gmail.com <
jonathan.leffler@gmail.com> wrote:
>
> Because dbschema is trained not to report on the structure of the system catalog. Maybe you could use Art's MySchema instead?
>
> And because DB-Access isn't quite as unhelpful as DB-Schema.
>
> -=JL=-
>
> ------Original Message------
> From: KARL OLIVER
> Sender: ids-bounces@iiug.org
> To: ids@iiug.org
> ReplyTo: ids@iiug.org
> Subject: Re: sysmaster systabauth space issue [23344]
> Sent: Apr 5, 2011 18:21
>
> thanks for that if I do
> dbschema -d test0111 -t systabauth i cant see the table > No table or view systabauth.
>
> If I do dbaccess - table info systabauth
> I can see the table , why is this
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> Sent from my BlackBerry® smartphone, powered by CREDO Mobile.
>
And as anyone who can read Base-64 text can see, what I said was a response
to Karl's email asking:
thanks for that if I do
> dbschema -d test0111 -t systabauth i cant see the table> No table or view systabauth.
>
> If I do dbaccess - table info systabauth
> I can see the table , why is this
>
Because dbschema is trained not to report on the structure of the system
catalog. Maybe you could use Art's MySchema instead?
And because DB-Access isn't quite as unhelpful as DB-Sche ma.
-=JL=-
Now to find out what mail setting isn't correct where... :(
--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
--000e0cd2deb4d27e4d04a0361d0d
thanks for information chaps