DBSPACE Problem.

Hi , I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) showing disabled. Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. Actual size of chunk used for dbase5 is 2044 Mb but its not showing the correct size. Pl find the online.log output and onstat -d output. Pl suggest me , how can remove dbase5 and bring up informix server in multiusermode. Note: I don't have backup PInformix Dynamic Server Version 7.30.UC8 -- Quiescent (CKPT REQ) -- Up 18:16: 06 -- 48296 Kbytes Blocked:CKPT Chunks address chk/dbs offset size free bpages flags pathname c2c4f158 1 1 1 1 N informix rootdbs7 c2c4f998 2 1 2 1 N informix dbase1 c2c4fa58 3 2001 13 1 N T informix tmpspace71 c2c4fb18 4 1 3 1 N informix dbase2 c2c4fbd8 5 1 4 1 N informix dbase3 c2c4fc98 6 1 5 1 N informix dbase4 c2c4fd58 7 5 6 1 ND informix dbase5 c2c4fe18 12 1 12 1 N informix logspace61 8 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname c2c4f218 1 1 0 1024000 146769 PO- /dev/vg03/rifx7rootdbs c2c4f378 2 2 0 1024000 466036 PO- /dev/vg04/rchk41 c2c4f458 3 4 0 1000000 973853 PO- /dev/vg05/rchk51 c2c4f538 4 5 0 250000 235273 PO- /dev/vg08/rchk81 c2c4f618 5 6 0 250000 236656 PO- /dev/vg09/rchk91 c2c4f6f8 6 7 0 1022 0 PD- /dev/vg04/rchk45 c2c4f7d8 12 12 0 524288 12235 PO- /dev/vg06/rlog61 c2c4f8b8 13 3 0 524288 524235 PO- /dev/vg07/rtmpchk71 Regards, Basaiah Basaiah Hiremath Infosys Technologies Ltd. Pune

In article <7tp3s9$10c$1@news.xmission.com>, BASAIAH <basaiah@itlinfosys.com> writes > >Hi , > >I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) >showing disabled. >Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. > Talk to Informix support.. maybe they can help... -- David Williams

BASAIAH <basaiah@itlinfosys.com> wrote in message news:7tp3s9$10c$1@news.xmission.com... > > Hi , > > I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) > showing disabled. > Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. > > Actual size of chunk used for dbase5 is 2044 Mb but its not showing the > correct size. > Pl find the online.log output and onstat -d output. Can't find online.log - if you want help it's needed. Have you seen assertions because of corrupted pages in this chunk ? > > Pl suggest me , how can remove dbase5 and bring up informix server in > multiusermode. Some tricks ... But your log is needed. > > Note: I don't have backup Poor. > > PInformix Dynamic Server Version 7.30.UC8 -- Quiescent (CKPT REQ) -- Up > 18:16: > 06 -- 48296 Kbytes > > Blocked:CKPT > Chunks > > address chk/dbs offset size free bpages flags pathname > > c2c4f158 1 1 1 1 N informix rootdbs7 > > c2c4f998 2 1 2 1 N informix dbase1 > > c2c4fa58 3 2001 13 1 N T informix tmpspace71 > > c2c4fb18 4 1 3 1 N informix dbase2 > > c2c4fbd8 5 1 4 1 N informix dbase3 > > c2c4fc98 6 1 5 1 N informix dbase4 > > c2c4fd58 7 5 6 1 ND informix dbase5 > > c2c4fe18 12 1 12 1 N informix logspace61 > > 8 active, 2047 maximum > > Chunks > > address chk/dbs offset size free bpages flags pathname > > c2c4f218 1 1 0 1024000 146769 PO- > /dev/vg03/rifx7rootdbs > > c2c4f378 2 2 0 1024000 466036 PO- /dev/vg04/rchk41 > > c2c4f458 3 4 0 1000000 973853 PO- /dev/vg05/rchk51 > > c2c4f538 4 5 0 250000 235273 PO- /dev/vg08/rchk81 > > c2c4f618 5 6 0 250000 236656 PO- /dev/vg09/rchk91 > > c2c4f6f8 6 7 0 1022 0 PD- /dev/vg04/rchk45 > > c2c4f7d8 12 12 0 524288 12235 PO- /dev/vg06/rlog61 > > c2c4f8b8 13 3 0 524288 524235 PO- > /dev/vg07/rtmpchk71 > > > > Regards, > Basaiah > > > Basaiah Hiremath > Infosys Technologies Ltd. > Pune > > > >