Rootdbs is Full
After upgrading from IDS 9.40 to 11.50.FC3, the user saw repeated "DBspace rootdbs is full" warnings plus SCHAPI errors (-229, -131, -271) from the scheduler; adding a 130MB chunk didn't help as rootdbs refilled when update statistics ran. Art Kagel first asked whether temp dbspaces existed/were in DBSPACETEMP (they were), and the poster found the sysadmin database in rootdbs was growing hugely. Suggested remedies: move sysadmin to its own dbspace, or identify and disable the scheduler sensors (e.g. persistent SQL history / auto update stats) filling rootdbs; an IBM technote link was posted. No confirmation of the outcome appears in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi to ALL
First of all I would like to inform you that we are running IBM Informix
Dynamic Server Version 11.50.FC3
and we have perform last week a migration from IBM Informix Dynamic Server
Version 9.40 FC6 .
Since the migration we get the following message:
WARNING: DBspace rootdbs is full.
In the onconfig file the root size was:
ROOTSIZE 63000
So we add another chunck of 130MB for rootdbs and when we run update
statistics on the databases the message
appears again and the rootdbs filed up again
Chunks
address chunk/dbs offset size free
bpages flags pathname
70000002066f1c0 1 1 2 15750 13
PO-B /eoyIDS/rootdbs_chk01
700000021540028 10 1 1 32500 1
PO-B /eoyIDS/rootdbs_chk02
Onstat -m
1:19:54 SCHAPI: Started dbScheduler thread.
1:19:54 Booting Language <spl> from module <>
1:19:54 Loading Module <SPLNULL>
1:19:54 WARNING: DBspace rootdbs is full
--> ??????????????????????
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Started 2 dbWorker threads.
1:19:54 SCHAPI: Error -271 Could not insert new row into the table.
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
1:24:54 SCHAPI: Re-starting 1 dbWorker threads.
1:24:54 SCHAPI: Started 1 dbWorker threads.
1:25:21 Checkpoint Completed: duration was 0 seconds.
1:25:21 Mon Jun 15 - loguniq 593, logpos 0x1d17018, timestamp: 0x68e418d8
Interval: 780
Regards
Cooperative Computer Society (S.E.M) Ltd
1306 Nicosia
P.O.B. 25037 CY
Tel: +357 22 673 901
Fax: +357 22 672 774
Achilleas Achilleos
Official A
OS and Databases Management
AchilleasAchilleos@semltd.com.cy
--Boundary_(ID_fBfrAmApftnaedbggOUH2w)
Do you have temp dbspaces allocated? Are theu listed in the DBSPACETEMP en=
vironment variable? It looks like your instance is using the rootdbs dbspa=
ce for sorting which is a bad thing and can only happen if it has no temp d=
bspaces to use or doesn't know that there are temp dbspaces.
Art S. Kagel=20
-----Original Message-----
From: Achilleas Achilleos <AchilleasAchilleos@semltd.com.cy>
Sent: Monday, June 15, 2009 4:54 AM
To: ids@iiug.org
Subject: Rootdbs is Full [16019]
Hi to ALL=20
First of all I would like to inform you that we are running IBM Informix=20
Dynamic Server Version 11.50.FC3=20
and we have perform last week a migration from IBM Informix Dynamic Server=
=20
Version 9.40 FC6 .=20
Since the migration we get the following message:=20
WARNING: DBspace rootdbs is full.=20
In the onconfig file the root size was:=20
ROOTSIZE 63000=20
So we add another chunck of 130MB for rootdbs and when we run update=20
statistics on the databases the message=20
appears again and the rootdbs filed up again=20
Chunks=20
address chunk/dbs offset size free=20
bpages flags pathname=20
70000002066f1c0 1 1 2 15750 13=20
PO-B /eoyIDS/rootdbs_chk01=20
700000021540028 10 1 1 32500 1=20
PO-B /eoyIDS/rootdbs_chk02=20
Onstat -m=20
1:19:54 SCHAPI: Started dbScheduler thread.=20
1:19:54 Booting Language <spl> from module <>=20
1:19:54 Loading Module <SPLNULL>=20
1:19:54 WARNING: DBspace rootdbs is full=20
--> ??????????????????????=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Started 2 dbWorker threads.=20
1:19:54 SCHAPI: Error -271 Could not insert new row into the table.=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
1:24:54 SCHAPI: Re-starting 1 dbWorker threads.=20
1:24:54 SCHAPI: Started 1 dbWorker threads.=20
1:25:21 Checkpoint Completed: duration was 0 seconds.=20
1:25:21 Mon Jun 15 - loguniq 593, logpos 0x1d17018, timestamp: 0x68e418d8=20
Interval: 780=20
Regards=20
Cooperative Computer Society (S.E.M) Ltd=20
1306 Nicosia=20
P.O.B. 25037 CY=20
Tel: +357 22 673 901=20
Fax: +357 22 672 774=20
Achilleas Achilleos=20
Official A=20
OS and Databases Management=20
AchilleasAchilleos@semltd.com.cy=20
--Boundary_(ID_fBfrAmApftnaedbggOUH2w)=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Hi Art,
Yes I have temp dbspaces
DBSPACETEMP tempdbs1,tempdbs2,tempdbs3
It seems that sysadmin database keeps a lot of records and this database is
located in rootdbs.
Keep in mind that we have around 120 databases in one DBSpace and we start
getting this message when we start running update statistics on those
databases.
Is there a way to shrink sysadmin database in because now we get some more
messages like after we restart the instance:
12:28:25 On-Line Mode
12:28:26 SCHAPI: Started dbScheduler thread.
12:28:26 Booting Language <spl> from module <>
12:28:26 Loading Module <SPLNULL>
12:28:26 WARNING: DBspace rootdbs is full
12:28:26 SCHAPI: Error -229 Could not open or create a temporary file.
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.
12:28:26 SCHAPI: Error -131 ISAM error: no free disk space
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.
12:28:26 SCHAPI: Error -229 Could not open or create a temporary file.
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.
12:28:26 SCHAPI: Error -131 ISAM error: no free disk space
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.
12:28:26 SCHAPI: Started 2 dbWorker threads.
12:28:27 SCHAPI: Error -271 Could not insert new row into the table.
12:28:27 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
12:28:27 SCHAPI: Error -131 ISAM error: no free disk space
12:28:27 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
12:33:26 SCHAPI: Re-starting 1 dbWorker threads.
12:33:26 SCHAPI: Started 1 dbWorker threads.
12:33:53 Checkpoint Completed: duration was 0 seconds.
12:33:53 Mon Jun 15 - loguniq 595, logpos 0x4072018, timestamp: 0x68fa02e4
Interval: 790
Regards
Cooperative Computer Society (S.E.M) Ltd
1306 Nicosia
P.O.B. 25037 CY
Tel: +357 22 673 901
Fax: +357 22 672 774
Achilleas Achilleos
Official A
OS and Databases Management
AchilleasAchilleos@semltd.com.cy
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art S.
Kagel
Sent: Monday, June 15, 2009 12:24 PM
To: ids@iiug.org
Subject: RE: Rootdbs is Full [16020]
Do you have temp dbspaces allocated? Are theu listed in the DBSPACETEMP en=
vironment variable? It looks like your instance is using the rootdbs dbspa=
ce for sorting which is a bad thing and can only happen if it has no temp d=
bspaces to use or doesn't know that there are temp dbspaces.
Art S. Kagel=20
-----Original Message-----
From: Achilleas Achilleos <AchilleasAchilleos@semltd.com.cy>
Sent: Monday, June 15, 2009 4:54 AM
To: ids@iiug.org
Subject: Rootdbs is Full [16019]
Hi to ALL=20
First of all I would like to inform you that we are running IBM Informix=20
Dynamic Server Version 11.50.FC3=20
and we have perform last week a migration from IBM Informix Dynamic Server=
=20
Version 9.40 FC6 .=20
Since the migration we get the following message:=20
WARNING: DBspace rootdbs is full.=20
In the onconfig file the root size was:=20
ROOTSIZE 63000=20
So we add another chunck of 130MB for rootdbs and when we run update=20
statistics on the databases the message=20
appears again and the rootdbs filed up again=20
Chunks=20
address chunk/dbs offset size free=20
bpages flags pathname=20
70000002066f1c0 1 1 2 15750 13=20
PO-B /eoyIDS/rootdbs_chk01=20
700000021540028 10 1 1 32500 1=20
PO-B /eoyIDS/rootdbs_chk02=20
Onstat -m=20
1:19:54 SCHAPI: Started dbScheduler thread.=20
1:19:54 Booting Language <spl> from module <>=20
1:19:54 Loading Module <SPLNULL>=20
1:19:54 WARNING: DBspace rootdbs is full=20
--> ??????????????????????=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=20
1:19:54 SCHAPI: Started 2 dbWorker threads.=20
1:19:54 SCHAPI: Error -271 Could not insert new row into the table.=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
1:24:54 SCHAPI: Re-starting 1 dbWorker threads.=20
1:24:54 SCHAPI: Started 1 dbWorker threads.=20
1:25:21 Checkpoint Completed: duration was 0 seconds.=20
1:25:21 Mon Jun 15 - loguniq 593, logpos 0x1d17018, timestamp: 0x68e418d8=20
Interval: 780=20
Regards=20
Cooperative Computer Society (S.E.M) Ltd=20
1306 Nicosia=20
P.O.B. 25037 CY=20
Tel: +357 22 673 901=20
Fax: +357 22 672 774=20
Achilleas Achilleos=20
Official A=20
OS and Databases Management=20
AchilleasAchilleos@semltd.com.cy=20
--Boundary_(ID_fBfrAmApftnaedbggOUH2w)=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
You can move sysadmin to another dedicated dbspace (search the forum, someo=
ne posted instructions for doing that a few weeks ago) or you can find the =
scheduler sensors that are filling rootdb and disable them (I posted instru=
ctions for doing that last week).
Possibly you have configured persistent SQL history or the auto update stat=
s is doing it
Art S. Kagel
-----Original Message-----
From: Achilleas Achilleos <AchilleasAchilleos@semltd.com.cy>
Sent: Monday, June 15, 2009 5:51 AM
To: ids@iiug.org
Subject: RE: Rootdbs is Full [16021]
Hi Art,=20
Yes I have temp dbspaces=20
DBSPACETEMP tempdbs1,tempdbs2,tempdbs3=20
It seems that sysadmin database keeps a lot of records and this database is=
=20
located in rootdbs.=20
Keep in mind that we have around 120 databases in one DBSpace and we start=
=20
getting this message when we start running update statistics on those=20
databases.=20
Is there a way to shrink sysadmin database in because now we get some more=
=20
messages like after we restart the instance:=20
12:28:25 On-Line Mode=20
12:28:26 SCHAPI: Started dbScheduler thread.=20
12:28:26 Booting Language <spl> from module <>=20
12:28:26 Loading Module <SPLNULL>=20
12:28:26 WARNING: DBspace rootdbs is full=20
12:28:26 SCHAPI: Error -229 Could not open or create a temporary file.=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Error -131 ISAM error: no free disk space=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Error -229 Could not open or create a temporary file.=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Error -131 ISAM error: no free disk space=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Started 2 dbWorker threads.=20
12:28:27 SCHAPI: Error -271 Could not insert new row into the table.=20
12:28:27 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
12:28:27 SCHAPI: Error -131 ISAM error: no free disk space=20
12:28:27 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
12:33:26 SCHAPI: Re-starting 1 dbWorker threads.=20
12:33:26 SCHAPI: Started 1 dbWorker threads.=20
12:33:53 Checkpoint Completed: duration was 0 seconds.=20
12:33:53 Mon Jun 15 - loguniq 595, logpos 0x4072018, timestamp: 0x68fa02e4=
=20
Interval: 790=20
Regards=20
Cooperative Computer Society (S.E.M) Ltd=20
1306 Nicosia=20
P.O.B. 25037 CY=20
Tel: +357 22 673 901=20
Fax: +357 22 672 774=20
Achilleas Achilleos=20
Official A=20
OS and Databases Management=20
AchilleasAchilleos@semltd.com.cy=20
-----Original Message-----=20
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art S=
.=20
Kagel=20
Sent: Monday, June 15, 2009 12:24 PM=20
To: ids@iiug.org=20
Subject: RE: Rootdbs is Full [16020]=20
Do you have temp dbspaces allocated? Are theu listed in the DBSPACETEMP en=
=3D=20
vironment variable? It looks like your instance is using the rootdbs dbspa=
=3D=20
ce for sorting which is a bad thing and can only happen if it has no temp d=
=3D=20
bspaces to use or doesn't know that there are temp dbspaces.=20
Art S. Kagel=3D20=20
-----Original Message-----=20
From: Achilleas Achilleos <AchilleasAchilleos@semltd.com.cy>=20
Sent: Monday, June 15, 2009 4:54 AM=20
To: ids@iiug.org=20
Subject: Rootdbs is Full [16019]=20
Hi to ALL=3D20=20
First of all I would like to inform you that we are running IBM Informix=3D=
20=20
Dynamic Server Version 11.50.FC3=3D20=20
and we have perform last week a migration from IBM Informix Dynamic Server=
=3D=20
=3D20=20
Version 9.40 FC6 .=3D20=20
Since the migration we get the following message:=3D20=20
WARNING: DBspace rootdbs is full.=3D20=20
In the onconfig file the root size was:=3D20=20
ROOTSIZE 63000=3D20=20
So we add another chunck of 130MB for rootdbs and when we run update=3D20=20
statistics on the databases the message=3D20=20
appears again and the rootdbs filed up again=3D20=20
Chunks=3D20=20
address chunk/dbs offset size free=3D20=20
bpages flags pathname=3D20=20
70000002066f1c0 1 1 2 15750 13=3D20=20
PO-B /eoyIDS/rootdbs_chk01=3D20=20
700000021540028 10 1 1 32500 1=3D20=20
PO-B /eoyIDS/rootdbs_chk02=3D20=20
Onstat -m=3D20=20
1:19:54 SCHAPI: Started dbScheduler thread.=3D20=20
1:19:54 Booting Language <spl> from module <>=3D20=20
1:19:54 Loading Module <SPLNULL>=3D20=20
1:19:54 WARNING: DBspace rootdbs is full=3D20=20
--> ??????????????????????=3D20=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=3D20=
=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=3D20=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=3D20=
=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=3D20=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Started 2 dbWorker threads.=3D20=20
1:19:54 SCHAPI: Error -271 Could not insert new row into the table.=3D20=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=3D2=
0=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=3D20=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=3D2=
0=20
1:24:54 SCHAPI: Re-starting 1 dbWorker threads.=3D20=20
1:24:54 SCHAPI: Started 1 dbWorker threads.=3D20=20
1:25:21 Checkpoint Completed: duration was 0 seconds.=3D20=20
1:25:21 Mon Jun 15 - loguniq 593, logpos 0x1d17018, timestamp: 0x68e418d8=
=3D20=20
Interval: 780=3D20=20
Regards=3D20=20
Cooperative Computer Society (S.E.M) Ltd=3D20=20
1306 Nicosia=3D20=20
P.O.B. 25037 CY=3D20=20
Tel: +357 22 673 901=3D20=20
Fax: +357 22 672 774=3D20=20
Achilleas Achilleos=3D20=20
Official A=3D20=20
OS and Databases Management=3D20=20
AchilleasAchilleos@semltd.com.cy=3D20=20
--Boundary_(ID_fBfrAmApftnaedbggOUH2w)=3D20=20
***************************************************************************=
=3D=20
****=3D20=20
Forum Note: Use "Reply" to post a response in the discussion forum.=3D20=20
***************************************************************************=
*=20
***=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Is your temp space going to rootdbs?
j.
Sane ego te vocavi. Forsitan capedictum tuum desit.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
Achilleas Achilleos
Sent: Monday, June 15, 2009 4:55 AM
To: ids@iiug.org
Subject: Rootdbs is Full [16019]
Hi to ALL
First of all I would like to inform you that we are running IBM Informix
Dynamic Server Version 11.50.FC3
and we have perform last week a migration from IBM Informix Dynamic Server
Version 9.40 FC6 .
Since the migration we get the following message:
WARNING: DBspace rootdbs is full.
In the onconfig file the root size was:
ROOTSIZE 63000
So we add another chunck of 130MB for rootdbs and when we run update
statistics on the databases the message
appears again and the rootdbs filed up again
Chunks
address chunk/dbs offset size free
bpages flags pathname
70000002066f1c0 1 1 2 15750 13
PO-B /eoyIDS/rootdbs_chk01
700000021540028 10 1 1 32500 1
PO-B /eoyIDS/rootdbs_chk02
Onstat -m
1:19:54 SCHAPI: Started dbScheduler thread.
1:19:54 Booting Language <spl> from module <>
1:19:54 Loading Module <SPLNULL>
1:19:54 WARNING: DBspace rootdbs is full
--> ??????????????????????
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.
1:19:54 SCHAPI: Started 2 dbWorker threads.
1:19:54 SCHAPI: Error -271 Could not insert new row into the table.
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
1:24:54 SCHAPI: Re-starting 1 dbWorker threads.
1:24:54 SCHAPI: Started 1 dbWorker threads.
1:25:21 Checkpoint Completed: duration was 0 seconds.
1:25:21 Mon Jun 15 - loguniq 593, logpos 0x1d17018, timestamp: 0x68e418d8
Interval: 780
Regards
Cooperative Computer Society (S.E.M) Ltd
1306 Nicosia
P.O.B. 25037 CY
Tel: +357 22 673 901
Fax: +357 22 672 774
Achilleas Achilleos
Official A
OS and Databases Management
AchilleasAchilleos@semltd.com.cy
--Boundary_(ID_fBfrAmApftnaedbggOUH2w)
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
http://www-01.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=SSZ2HS&c
ontext=SSP6X2&context=SSVHPS&context=SSHPYE&q1=sysadmin&uid=swg21266296&loc=en_U
S&cs=utf-8&lang=en
--- Em seg, 15/6/09, Art S. Kagel <art.kagel@gmail.com> escreveu:
De: Art S. Kagel <art.kagel@gmail.com>
Assunto: RE: Rootdbs is Full [16022]
Para: ids@iiug.org
Data: Segunda-feira, 15 de Junho de 2009, 6:59
You can move sysadmin to another dedicated dbspace (search the forum, someo=
ne posted instructions for doing that a few weeks ago) or you can find the =
scheduler sensors that are filling rootdb and disable them (I posted instru=
ctions for doing that last week).
Possibly you have configured persistent SQL history or the auto update stat=
s is doing it
Art S. Kagel
-----Original Message-----
From: Achilleas Achilleos <AchilleasAchilleos@semltd.com.cy>
Sent: Monday, June 15, 2009 5:51 AM
To: ids@iiug.org
Subject: RE: Rootdbs is Full [16021]
Hi Art,=20
Yes I have temp dbspaces=20
DBSPACETEMP tempdbs1,tempdbs2,tempdbs3=20
It seems that sysadmin database keeps a lot of records and this database is=
=20
located in rootdbs.=20
Keep in mind that we have around 120 databases in one DBSpace and we start=
=20
getting this message when we start running update statistics on those=20
databases.=20
Is there a way to shrink sysadmin database in because now we get some more=
=20
messages like after we restart the instance:=20
12:28:25 On-Line Mode=20
12:28:26 SCHAPI: Started dbScheduler thread.=20
12:28:26 Booting Language <spl> from module <>=20
12:28:26 Loading Module <SPLNULL>=20
12:28:26 WARNING: DBspace rootdbs is full=20
12:28:26 SCHAPI: Error -229 Could not open or create a temporary file.=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Error -131 ISAM error: no free disk space=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Error -229 Could not open or create a temporary file.=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Error -131 ISAM error: no free disk space=20
12:28:26 SCHAPI: Type: , Name: NULL, Location: NULL.=20
12:28:26 SCHAPI: Started 2 dbWorker threads.=20
12:28:27 SCHAPI: Error -271 Could not insert new row into the table.=20
12:28:27 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
12:28:27 SCHAPI: Error -131 ISAM error: no free disk space=20
12:28:27 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=20
12:33:26 SCHAPI: Re-starting 1 dbWorker threads.=20
12:33:26 SCHAPI: Started 1 dbWorker threads.=20
12:33:53 Checkpoint Completed: duration was 0 seconds.=20
12:33:53 Mon Jun 15 - loguniq 595, logpos 0x4072018, timestamp: 0x68fa02e4=
=20
Interval: 790=20
Regards=20
Cooperative Computer Society (S.E.M) Ltd=20
1306 Nicosia=20
P.O.B. 25037 CY=20
Tel: +357 22 673 901=20
Fax: +357 22 672 774=20
Achilleas Achilleos=20
Official A=20
OS and Databases Management=20
AchilleasAchilleos@semltd.com.cy=20
-----Original Message-----=20
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art S=
..=20
Kagel=20
Sent: Monday, June 15, 2009 12:24 PM=20
To: ids@iiug.org=20
Subject: RE: Rootdbs is Full [16020]=20
Do you have temp dbspaces allocated? Are theu listed in the DBSPACETEMP en=
=3D=20
vironment variable? It looks like your instance is using the rootdbs dbspa=
=3D=20
ce for sorting which is a bad thing and can only happen if it has no temp d=
=3D=20
bspaces to use or doesn't know that there are temp dbspaces.=20
Art S. Kagel=3D20=20
-----Original Message-----=20
From: Achilleas Achilleos <AchilleasAchilleos@semltd.com.cy>=20
Sent: Monday, June 15, 2009 4:54 AM=20
To: ids@iiug.org=20
Subject: Rootdbs is Full [16019]=20
Hi to ALL=3D20=20
First of all I would like to inform you that we are running IBM Informix=3D=
20=20
Dynamic Server Version 11.50.FC3=3D20=20
and we have perform last week a migration from IBM Informix Dynamic Server=
=3D=20
=3D20=20
Version 9.40 FC6 .=3D20=20
Since the migration we get the following message:=3D20=20
WARNING: DBspace rootdbs is full.=3D20=20
In the onconfig file the root size was:=3D20=20
ROOTSIZE 63000=3D20=20
So we add another chunck of 130MB for rootdbs and when we run update=3D20=20
statistics on the databases the message=3D20=20
appears again and the rootdbs filed up again=3D20=20
Chunks=3D20=20
address chunk/dbs offset size free=3D20=20
bpages flags pathname=3D20=20
70000002066f1c0 1 1 2 15750 13=3D20=20
PO-B /eoyIDS/rootdbs_chk01=3D20=20
700000021540028 10 1 1 32500 1=3D20=20
PO-B /eoyIDS/rootdbs_chk02=3D20=20
Onstat -m=3D20=20
1:19:54 SCHAPI: Started dbScheduler thread.=3D20=20
1:19:54 Booting Language <spl> from module <>=3D20=20
1:19:54 Loading Module <SPLNULL>=3D20=20
1:19:54 WARNING: DBspace rootdbs is full=3D20=20
--> ??????????????????????=3D20=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=3D20=
=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=3D20=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Error -229 Could not open or create a temporary file.=3D20=
=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=3D20=20
1:19:54 SCHAPI: Type: , Name: NULL, Location: NULL.=3D20=20
1:19:54 SCHAPI: Started 2 dbWorker threads.=3D20=20
1:19:54 SCHAPI: Error -271 Could not insert new row into the table.=3D20=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=3D2=
0=20
1:19:54 SCHAPI: Error -131 ISAM error: no free disk space=3D20=20
1:19:54 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.=3D2=
0=20
1:24:54 SCHAPI: Re-starting 1 dbWorker threads.=3D20=20
1:24:54 SCHAPI: Started 1 dbWorker threads.=3D20=20
1:25:21 Checkpoint Completed: duration was 0 seconds.=3D20=20
1:25:21 Mon Jun 15 - loguniq 593, logpos 0x1d17018, timestamp: 0x68e418d8=
=3D20=20
Interval: 780=3D20=20
Regards=3D20=20
Cooperative Computer Society (S.E.M) Ltd=3D20=20
1306 Nicosia=3D20=20
P.O.B. 25037 CY=3D20=20
Tel: +357 22 673 901=3D20=20
Fax: +357 22 672 774=3D20=20
Achilleas Achilleos=3D20=20
Official A=3D20=20
OS and Databases Management=3D20=20
AchilleasAchilleos@semltd.com.cy=3D20=20
--Boundary_(ID_fBfrAmApftnaedbggOUH2w)=3D20=20
***************************************************************************=
=3D=20
****=3D20=20
Forum Note: Use "Reply" to post a response in the discussion forum.=3D20=20
***************************************************************************=
*=20
***=20
Fo