IDS Forum

Re: rootdbs full for IDS 9.3

Posted By: Michael Lowe
Date: Wednesday, 29 January 2003, at 4:28 p.m.

In Response To: rootdbs full for IDS 9.3 (Rahn Payne)

Rahn;

Onbar is likely failing because there's no room to add space to the
sysutils database.
You are partially correct when you talk about the rootdbs size, but what's
actually true is that you cannot change the size of the initial chunk (or
any chunk, for that matter) once it's been created.
The simplest solution would be to just add another chunk to the root
dbspace.
There are still some conditions to be aware of, but which may or may not be
a factor in your case. The specific one I'm referring to is that all the
system Reserved Pages and Extended Reserved Pages must fit into the initial
chunk of the root dbspace. This becomes a factor when you're trying to add
chunks and dbspaces to a large system with a very small initial root chunk
(yours is pretty small) and there isn't enough room in that initial chunk
to add Extended Reserved Pages.
That doesn't seem to be your problem here, though, so the simplest thing
would be to just add another chunk.
Everything else that I'm aware of that lives in the root dbspace can live
in any chunk of the root dbspace, so the concern's only if you're going to
be adding lots more dbspaces and chunks.

HTH...
Mike
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Mike Lowe
Certified Consulting Education Specialist
Data Management Solutions
IBM Software Group
Tel: 303-773-5216 Tie Line: 565-5216
e-Fax: 413-674-2415
mlowe0@us.ibm.com
WWW: ibm.com/software/data




Hey all,

I'm running IDS 9.3 and am getting the following message in my =
bar_act.log:

2003-01-29 08:37:24 31598 37464 SQL -271 Could not insert new row =
into the table.
2003-01-29 08:37:24 31598 37464 ISAM -131 ISAM error: no free disk =
space

My onstat -d looks like this:

address chk/dbs offset size free bpages flags pathname
400ff918 1 1 0 7500 7 PO- =
/data01/root_rmgr
4015da98 2 2 0 7500 6991 PO- =
/appl/tmp/tmp1_rmgr
4015dc08 3 3 0 125000 0 PO- =
/data01/dbs01_rmgr
4015dd78 4 4 0 125000 1 PO- =
/data02/dbs02_rmgr
400ffac0 5 5 0 2500 197 PO- =
/data01/phys_rmgr
400ffc30 6 6 0 7500 6959 PO- =
/data01/tmp2_rmgr
400ffda0 7 7 0 7500 6951 PO- =
/data02/tmp3_rmgr
4014e030 8 8 0 500 47 PO- =
/data01/logic1_rmgr
4014e1a0 9 9 0 500 47 PO- =
/data01/logic2_rmgr
4014e310 10 10 0 500 47 PO- =
/data01/logic3_rmgr
4014e480 11 11 0 500 47 PO- =
/data01/logic4_rmgr
4014e5f0 12 12 0 500 47 PO- =
/data01/logic5_rmgr
4014e760 13 13 0 500 47 PO- =
/data02/logic6_rmgr
4014e8d0 14 14 0 500 47 PO- =
/data02/logic7_rmgr
4014ea40 15 15 0 500 47 PO- =
/data02/logic8_rmgr
4014ebb0 16 16 0 500 47 PO- =
/data02/logic9_rmgr
4014ed20 17 17 0 500 47 PO- =
/data02/logic10_rmgr
4014ee90 18 3 125000 250000 313 PO- =
/data01/dbs01_rmgr
40731018 19 4 125000 250000 30745 PO- =
/data02/dbs02_rmgr
40731188 20 3 375000 100000 91805 PO- =
/data01/dbs01_rmgr
407312f8 21 4 375000 100000 99997 PO- =
/data02/dbs02_rmgr

I suspect that it is the root_rmgr (rootdbs) that is too full to be =
written to. Does anyone know how space can be restored to rootdbs? =
According to the manuals and training, rootdbs is set once (at about =
30MB), can't be increased, and I didn't know it would fill up! I have =
been very careful not to create tables in rootdbs. I think it has just =
slowly filled.

Thanks for any suggestions!

Rahn

Rahn Payne
Rehab Manager, Inc.
email: rpayne@rehabmgr.com

Messages In This Thread

• rootdbs full for IDS 9.3
  Rahn Payne -- Wednesday, 29 January 2003, at 11:01 a.m.
  • Re: rootdbs full for IDS 9.3
    Mark Scranton -- Wednesday, 29 January 2003, at 11:41 a.m.
    • Re: rootdbs full for IDS 9.3
      Rajib Sarkar -- Wednesday, 29 January 2003, at 12:42 p.m.
    • Re: rootdbs full for IDS 9.3
      Peter J Diaz de Leon -- Wednesday, 29 January 2003, at 12:57 p.m.
      • Re: rootdbs full for IDS 9.3
        Rahn Payne -- Wednesday, 29 January 2003, at 4:07 p.m.
  • RE: rootdbs full for IDS 9.3
    Palmer, George -- Wednesday, 29 January 2003, at 12:38 p.m.
  • Re: rootdbs full for IDS 9.3
    Ali Kemal BAKIR -- Wednesday, 29 January 2003, at 12:46 p.m.
  • Re: rootdbs full for IDS 9.3
    Michael Lowe -- Wednesday, 29 January 2003, at 4:28 p.m.
  • Re: rootdbs full for IDS 9.3
    MALCOLM WEALLANS -- Thursday, 30 January 2003, at 6:24 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.