how to enable dbspace

How to enable dbspace? dbspace3 be disble from I/O error. Now disks were replace already. N740-Informix > onstat -d Informix Dynamic Server Version 9.30.HC3 -- On-Line -- Up 03:03:32 -- 367852 Kbytes Dbspaces address number flags fchunk nchunks flags owner name e06d97e8 1 0x1001 1 1 N informix rootdbs_psc e0de2748 2 0x2001 41 2 N T informix tempdbs e0de2898 3 0x1 3 1 N informix logicaldbs e0de29e8 4 0x1 4 9 N informix dbspace1 e0de2b38 5 0x1 6 51 N informix dbspace2 e0de2c88 6 0x5 73 62 ND informix dbspace3 e0de2dd8 7 0x1 75 1 N informix psc_tmp1 e0de3018 8 0x11 12 1 N B informix blobspace1 e0de3168 9 0x1 13 1 N informix index1 e0de32b8 10 0x1 64 1 N informix dptraining1 10 active, 2047 maximum Note: For BLOB chunks, the number of free pages shown is out of date. Run 'onstat -d update' for current stats. Chunks address chk/dbs offset size free bpages flags pathname e06d9938 1 1 0 25000 21014 PO- /home/informix/psck5701/dpchk01 e0dd2a98 2 5 0 1024000 127235 PO- /home/informix/psck5701/dpchk02 e0dd2c08 3 3 0 1000000 129947 PO- /home/informix/psck5701/dpchk03 e0dd2d78 4 4 0 1000000 272 PO- /home/informix/psck5701/dpchk06 e0dd3018 5 4 0 1000000 432 PO- /home/informix/psck5701/dpchk07 e0dd3188 6 5 0 1000000 4972 PO- /home/informix/psck5701/dpchk11 e0dd32f8 7 5 0 1000000 14662 PO- /home/informix/psck5701/dpchk12 e0dd3468 8 5 0 1024000 26702 PO- /home/informix/psck5701/dpchk16 e0dd35d8 9 5 0 1024000 15113 PO- /home/informix/psck5701/dpchk17 e0dd3748 10 5 0 1024000 9114 PO- /home/informix/psck5701/dpchk35 e0dd38b8 11 5 0 1024000 4435 PO- /home/informix/psck5701/dpchk38 e0dd3a28 12 8 0 1000000 ~200 200 POB /home/informix/psck5701/dpchk39 e0dd3b98 13 9 0 1000000 999569 PO- /home/informix/psck5701/dpchk36 e0dd3d08 14 5 0 1024000 540541 PO- /home/informix/psck5701/dpchk18 e0dd3e78 15 5 0 1024000 349453 PO- /home/informix/psck5701/dpchk21 e0dd4018 16 4 0 1000000 309 PO- /home/informix/psck5701/dpchk08 e0dd4188 17 4 0 1000000 128 PO- /home/informix/psck5701/dpchk09 e0dd42f8 18 5 0 1024000 220856 PO- /home/informix/psck5701/dpchk26 e0dd4468 19 5 0 1000000 8955 PO- /home/informix/psck5701/dpchk13 e0dd45d8 20 5 0 1000000 9520 PO- /home/informix/psck5701/dpchk14 e0dd4748 21 6 0 1024000 0 PD- /backup/INFORMIX/data33.dat e0dd48b8 22 6 0 1024000 0 PD- /backup/INFORMIX/data34.dat e0dd4a28 23 5 0 1024000 12180 PO- /home/informix/psck5701/dpchk20 e0dd4b98 24 5 0 1024000 13568 PO- /home/informix/psck5701/dpchk22 e0dd4d08 25 6 0 1024000 0 PD- /backup/INFORMIX/data35.dat e0dd4e78 26 6 0 1024000 0 PD- /backup/INFORMIX/data36.dat e0dd5018 27 5 0 1024000 12370 PO- /home/informix/psck5701/dpchk24 e0dd5188 28 4 0 1024000 153 PO- /home/informix/psck5701/dpchk25 e0dd52f8 29 5 0 1000000 21095 PO- /home/informix/psck5701/dpchk41 e0dd5468 30 5 0 1024000 12484 PO- /home/informix/psck5701/dpchk31 e0dd55d8 31 5 0 1024000 7515 PO- /home/informix/psck5701/dpchk32 e0dd5748 32 6 0 1024000 0 PD- /backup/INFORMIX/data37.dat e0dd58b8 33 6 0 1024000 0 PD- /backup/INFORMIX/data38.dat e0dd5a28 34 5 0 1000000 26838 PO- /home/informix/psck5701/dpchk15 e0dd5b98 35 5 0 1000000 21645 PO- /home/informix/psck5701/dpchk23 e0dd5d08 36 6 0 1024000 0 PD- /backup/INFORMIX/data39.dat e0dd5e78 37 6 0 1024000 0 PD- /backup/INFORMIX/data40.dat e0dd6018 38 5 0 1024000 283225 PO- /home/informix/psck5701/dpchk33 e0dd6188 39 5 0 1024000 434343 PO- /home/informix/psck5701/dpchk37 e0dd62f8 40 5 0 1024000 1007685 PO- /home/informix/psck5701/dpchk40 e0dd6468 41 2 0 50000 49947 PO- /home/informix/psck5701/dpchk04 e0dd65d8 42 5 0 1024000 560387 PO- /home/informix/psck5701/dpchk42 e0dd6748 43 6 0 1024000 0 PD- /backup/INFORMIX/data41.dat e0dd68b8 44 6 0 1024000 0 PD- /backup/INFORMIX/data42.dat e0dd6a28 45 5 0 1024000 11935 PO- /home/informix/psck5701/dpchk47 e0dd6b98 46 6 0 1024000 0 PD- /backup/INFORMIX/data43.dat e0dd6d08 47 6 0 1024000 0 PD- /backup/INFORMIX/data44.dat e0dd6e78 48 6 0 1024000 0 PD- /backup/INFORMIX/data45.dat e0dd7018 49 6 0 1024000 0 PD- /backup/INFORMIX/data46.dat e0dd7188 50 5 0 512000 2293 PO- /home/informix/psck5701/dpchk52 e0dd72f8 51 6 0 1024000 0 PD- /backup/INFORMIX/data47.dat e0dd7468 52 6 0 1024000 0 PD- /backup/INFORMIX/data48.dat e0dd75d8 53 6 0 1024000 0 PD- /backup/INFORMIX/data49.dat e0dd7748 54 5 0 512000 5232 PO- /home/informix/psck5701/dpchk56 e0dd78b8 55 5 0 512000 3648 PO- /home/informix/psck5701/dpchk57 e0dd7a28 56 6 0 1024000 0 PD- /backup/INFORMIX/data50.dat e0dd7b98 57 6 0 1024000 0 PD- /backup/INFORMIX/data51.dat e0dd7d08 58 6 0 1024000 0 PD- /backup/INFORMIX/data52.dat e0dd7e78 59 6 0 1024000 0 PD- /backup/INFORMIX/data53.dat e0dd8018 60 6 0 1024000 0 PD- /backup/INFORMIX/data54.dat e0dd8188 61 5 0 1024000 1012 PO- /home/informix/psck5701/dpchk62 e0dd82f8 62 5 0 1024000 8886 PO- /home/informix/psck5701/dpchk63 e0dd8468 63 6 0 1024000 0 PD- /backup/INFORMIX/data55.dat e0dd85d8 64 10 0 1024000 783683 PO- /home/informix/psck5701/dpchk64 e0dd8748 65 5 0 1024000 342365 PO- /backup/INFORMIX/data56.dat e0dd88b8 66 6 0 1024000 0 PD- /backup/INFORMIX/data57.dat e0dd8a28 67 5 0 1024000 541245 PO- /home/informix/psck5701/dpchk05 e0dd8b98 68 5 0 1024000 462653 PO- /home/informix/psck5701/dpchk10 e0dd8d08 69 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk19 e0dd8e78 70 4 0 1024000 1 PO- /home/informix/psck5701/dpchk43 e0dd9018 71 4 0 1024000 0 PO- /home/informix/psck5701/dpchk34 e0dd9188 72 2 512001 500000 499997 PO- /home/informix/psck5701/dpchk52 e0dd92f8 73 6 0 1024000 0 PD- /backup/INFORMIX/data1.dat e0dd9468 74 6 0 1024000 0 PD- /backup/INFORMIX/data2.dat e0dd95d8 75 7 0 400000 380417 PO- /home/informix/psck5701/dpchk67 e0dd9748 76 6 0 1024000 0 PD- /backup/INFORMIX/data3.dat e0dd98b8 77 6 0 1024000 0 PD- /backup/INFORMIX/data4.dat e0dd9a28 78 6 0 1024000 0 PD- /backup/INFORMIX/data5.dat e0dd9b98 79 6 0 1024000 0 PD- /backup/INFORMIX/data6.dat e0dd9d08 80 6 0 1024000 0 PD- /backup/INFORMIX/data7.dat e0dd9e78 81 6 0 1024000 0 PD- /backup/INFORMIX/data8.dat e0dda018 82 6 0 1024000 0 PD- /backup/INFORMIX/data9.dat e0dda188 83 6 0 1024000 0 PD- /backup/INFORMIX/data10.dat e0dda2f8 84 6 0 1024000 0 PD- /backup/INFORMIX/data11.dat e0dda468 85 6 0 1024000 0 PD- /backup/INFORMIX/data12.dat e0dda5d8 86 6 0 1024000 0 PD- /backup/INFORMIX/data13.dat e0dda748 87 6 0 1024000 0 PD- /backup/INFORMIX/data14.dat e0dda8b8 88 6 0 1024000 0 PD- /backup/INFORMIX/data15.dat e0ddaa28 89 6 0 1024000 0 PD- /backup/INFORMIX/data16.dat e0ddab98 90 6 0 1024000 0 PD- /backup/INFORMIX/data17.dat e0ddad08 91 6 0 1024000 0 PD- /backup/INFORMIX/data18.dat e0ddae78 92 6 0 1024000 0 PD- /backup/INFORMIX/data19.dat e0ddb018 93 6 0 1024000 0 PD- /backup/INFORMIX/data20.dat e0ddb188 94 6 0 1024000 0 PD- /backup/INFORMIX/data21.dat e0ddb2f8 95 6 0 1024000 0 PD- /backup/INFORMIX/data22.dat e0ddb468 96 6 0 1024000 0 PD- /backup/INFORMIX/data23.dat e0ddb5d8 97 6 0 1024000 0 PD- /backup/INFORMIX/data24.dat e0ddb748 98 6 0 1024000 0 PD- /backup/INFORMIX/data25.dat e0ddb8b8 99 6 0 1024000 0 PD- /backup/INFORMIX/data26.dat e0ddba28 100 6 0 1024000 0 PD- /backup/INFORMIX/data27.dat e0ddbb98 101 6 0 1024000 0 PD- /backup/INFORMIX/data28.dat e0ddbd08 102 6 0 1024000 0 PD- /backup/INFORMIX/data29.dat e0ddbe78 103 6 0 1024000 0 PD- /backup/INFORMIX/data30.dat e0ddc018 104 6 0 1024000 0 PD

Hi, Did you restore the down spaces using onbar ? If not, you cannot bring the chunk online, cause the data is missing (disks are replaced, as you said). If you do not have a onbar backup for the missing dbspaces, you cannot bring the chunks back online. In case you have an ontape backup, the only choice I know of is to restore the entire system from the last backup where the missing chunks were active. After the cold-restore, you have to restore the logs from you (hopefully existing) log-Backup. Looking at the amount of data which is stored there, this might be a long operation, depending on your backup mechanisms. To prevent such a problem in the future, consider to do mirroring either on Informix level or OS level. Hope this helps, Marcus -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of CHANATIP LA.... Sent: Friday, May 05, 2006 10:03 AM To: ids@iiug.org Subject: how to enable dbspace [6668] How to enable dbspace? dbspace3 be disble from I/O error. Now disks were replace already. N740-Informix > onstat -d Informix Dynamic Server Version 9.30.HC3 -- On-Line -- Up 03:03:32 -- 367852 Kbytes Dbspaces address number flags fchunk nchunks flags owner name e06d97e8 1 0x1001 1 1 N informix rootdbs_psc e0de2748 2 0x2001 41 2 N T informix tempdbs e0de2898 3 0x1 3 1 N informix logicaldbs e0de29e8 4 0x1 4 9 N informix dbspace1 e0de2b38 5 0x1 6 51 N informix dbspace2 e0de2c88 6 0x5 73 62 ND informix dbspace3 e0de2dd8 7 0x1 75 1 N informix psc_tmp1 e0de3018 8 0x11 12 1 N B informix blobspace1 e0de3168 9 0x1 13 1 N informix index1 e0de32b8 10 0x1 64 1 N informix dptraining1 10 active, 2047 maximum Note: For BLOB chunks, the number of free pages shown is out of date. Run 'onstat -d update' for current stats. Chunks address chk/dbs offset size free bpages flags pathname e06d9938 1 1 0 25000 21014 PO- /home/informix/psck5701/dpchk01 e0dd2a98 2 5 0 1024000 127235 PO- /home/informix/psck5701/dpchk02 e0dd2c08 3 3 0 1000000 129947 PO- /home/informix/psck5701/dpchk03 e0dd2d78 4 4 0 1000000 272 PO- /home/informix/psck5701/dpchk06 e0dd3018 5 4 0 1000000 432 PO- /home/informix/psck5701/dpchk07 e0dd3188 6 5 0 1000000 4972 PO- /home/informix/psck5701/dpchk11 e0dd32f8 7 5 0 1000000 14662 PO- /home/informix/psck5701/dpchk12 e0dd3468 8 5 0 1024000 26702 PO- /home/informix/psck5701/dpchk16 e0dd35d8 9 5 0 1024000 15113 PO- /home/informix/psck5701/dpchk17 e0dd3748 10 5 0 1024000 9114 PO- /home/informix/psck5701/dpchk35 e0dd38b8 11 5 0 1024000 4435 PO- /home/informix/psck5701/dpchk38 e0dd3a28 12 8 0 1000000 ~200 200 POB /home/informix/psck5701/dpchk39 e0dd3b98 13 9 0 1000000 999569 PO- /home/informix/psck5701/dpchk36 e0dd3d08 14 5 0 1024000 540541 PO- /home/informix/psck5701/dpchk18 e0dd3e78 15 5 0 1024000 349453 PO- /home/informix/psck5701/dpchk21 e0dd4018 16 4 0 1000000 309 PO- /home/informix/psck5701/dpchk08 e0dd4188 17 4 0 1000000 128 PO- /home/informix/psck5701/dpchk09 e0dd42f8 18 5 0 1024000 220856 PO- /home/informix/psck5701/dpchk26 e0dd4468 19 5 0 1000000 8955 PO- /home/informix/psck5701/dpchk13 e0dd45d8 20 5 0 1000000 9520 PO- /home/informix/psck5701/dpchk14 e0dd4748 21 6 0 1024000 0 PD- /backup/INFORMIX/data33.dat e0dd48b8 22 6 0 1024000 0 PD- /backup/INFORMIX/data34.dat e0dd4a28 23 5 0 1024000 12180 PO- /home/informix/psck5701/dpchk20 e0dd4b98 24 5 0 1024000 13568 PO- /home/informix/psck5701/dpchk22 e0dd4d08 25 6 0 1024000 0 PD- /backup/INFORMIX/data35.dat e0dd4e78 26 6 0 1024000 0 PD- /backup/INFORMIX/data36.dat e0dd5018 27 5 0 1024000 12370 PO- /home/informix/psck5701/dpchk24 e0dd5188 28 4 0 1024000 153 PO- /home/informix/psck5701/dpchk25 e0dd52f8 29 5 0 1000000 21095 PO- /home/informix/psck5701/dpchk41 e0dd5468 30 5 0 1024000 12484 PO- /home/informix/psck5701/dpchk31 e0dd55d8 31 5 0 1024000 7515 PO- /home/informix/psck5701/dpchk32 e0dd5748 32 6 0 1024000 0 PD- /backup/INFORMIX/data37.dat e0dd58b8 33 6 0 1024000 0 PD- /backup/INFORMIX/data38.dat e0dd5a28 34 5 0 1000000 26838 PO- /home/informix/psck5701/dpchk15 e0dd5b98 35 5 0 1000000 21645 PO- /home/informix/psck5701/dpchk23 e0dd5d08 36 6 0 1024000 0 PD- /backup/INFORMIX/data39.dat e0dd5e78 37 6 0 1024000 0 PD- /backup/INFORMIX/data40.dat e0dd6018 38 5 0 1024000 283225 PO- /home/informix/psck5701/dpchk33 e0dd6188 39 5 0 1024000 434343 PO- /home/informix/psck5701/dpchk37 e0dd62f8 40 5 0 1024000 1007685 PO- /home/informix/psck5701/dpchk40 e0dd6468 41 2 0 50000 49947 PO- /home/informix/psck5701/dpchk04 e0dd65d8 42 5 0 1024000 560387 PO- /home/informix/psck5701/dpchk42 e0dd6748 43 6 0 1024000 0 PD- /backup/INFORMIX/data41.dat e0dd68b8 44 6 0 1024000 0 PD- /backup/INFORMIX/data42.dat e0dd6a28 45 5 0 1024000 11935 PO- /home/informix/psck5701/dpchk47 e0dd6b98 46 6 0 1024000 0 PD- /backup/INFORMIX/data43.dat e0dd6d08 47 6 0 1024000 0 PD- /backup/INFORMIX/data44.dat e0dd6e78 48 6 0 1024000 0 PD- /backup/INFORMIX/data45.dat e0dd7018 49 6 0 1024000 0 PD- /backup/INFORMIX/data46.dat e0dd7188 50 5 0 512000 2293 PO- /home/informix/psck5701/dpchk52 e0dd72f8 51 6 0 1024000 0 PD- /backup/INFORMIX/data47.dat e0dd7468 52 6 0 1024000 0 PD- /backup/INFORMIX/data48.dat e0dd75d8 53 6 0 1024000 0 PD- /backup/INFORMIX/data49.dat e0dd7748 54 5 0 512000 5232 PO- /home/informix/psck5701/dpchk56 e0dd78b8 55 5 0 512000 3648 PO- /home/informix/psck5701/dpchk57 e0dd7a28 56 6 0 1024000 0 PD- /backup/INFORMIX/data50.dat e0dd7b98 57 6 0 1024000 0 PD- /backup/INFORMIX/data51.dat e0dd7d08 58 6 0 1024000 0 PD- /backup/INFORMIX/data52.dat e0dd7e78 59 6 0 1024000 0 PD- /backup/INFORMIX/data53.dat e0dd8018 60 6 0 1024000 0 PD- /backup/INFORMIX/data54.dat e0dd8188 61 5 0 1024000 1012 PO- /home/informix/psck5701/dpchk62 e0dd82f8 62 5 0 1024000 8886 PO- /home/informix/psck5701/dpchk63 e0dd8468 63 6 0 1024000 0 PD- /backup/INFORMIX/data55.dat e0dd85d8 64 10 0 1024000 783683 PO- /home/informix/psck5701/dpchk64 e0dd8748 65 5 0 1024000 342365 PO- /backup/INFORMIX/data56.dat e0dd88b8 66 6 0 1024000 0 PD- /backup/INFORMIX/data57.dat e0dd8a28 67 5 0 1024000 541245 PO- /home/informix/psck5701/dpchk05 e0dd8b98 68 5 0 1024000 462653 PO- /home/informix/psck5701/dpchk10 e0dd8d08 69 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk19 e0dd8e78 70 4 0 1024000 1 PO- /home/informix/psck5701/dpchk43 e0dd9018 71 4 0 1024000 0 PO- /home/informix/psck5701/dpchk34 e0dd9188 72 2 512001 500000 499997 PO- /home/informix/psck5701/dpchk52 e0dd92f8 73 6 0 1024000 0 PD- /backup/INFORMIX/data1.dat e0dd9468 74 6 0 1024000 0 PD- /backup/INFORMIX/data2.dat e0dd95d8 75 7 0 400000 380417 PO- /home/informix/psck5701/dpchk67 e0dd9748 76 6 0 1024000 0 PD- /backup/INFORMIX/data3.dat e0dd98b8 77 6 0 1024000 0 PD- /backup/INFORMIX/data4.dat e0dd9a28 78 6 0 1024000 0 PD- /backup/INFORMIX/data5.dat e0dd9b98 79 6 0 1024000 0 PD- /backup/INFORMIX/data6.dat e0dd9d08 80 6 0 1024000 0 PD- /backup/INFORMIX/data7.dat e0dd9e78 81 6 0 1024000 0 PD- /backup/INFORMIX/data8.dat e0dda018 82 6 0 1024000 0 PD- /backup/INFORMIX/data9.dat e0dda188 83 6 0 1024000 0 PD- /backup/INFORMIX/data10.dat e0dda2f8 84 6 0 1024000 0 PD- /backup/INFORMIX/data11.dat e0dda468 85 6 0 1024000 0 PD- /backup/INFORMIX/data12.dat e0dda5d8 86 6 0 1024000 0 PD- /backup/INFORMIX/data13.dat e0dda748 87 6

The safest thing to do is to link the new disks to the original chunk links and perform a full ontape/onbar restore including rolling forward logical logs. If you are confident that the new drives contain undamaged data from the original drives and that nothing went unflushed from the buffer cache when the drives went south, you can call tech support and convince them to mark the chunks and dbspace back to online mode. Art S. Kagel ----- Original Message ----- From: Chanatip La.... <ids@iiug.org> At: 5/05 4:06:03 How to enable dbspace? dbspace3 be disble from I/O error. Now disks were replace already. N740-Informix > onstat -d Informix Dynamic Server Version 9.30.HC3 -- On-Line -- Up 03:03:32 -- 367852 Kbytes Dbspaces address number flags fchunk nchunks flags owner name e06d97e8 1 0x1001 1 1 N informix rootdbs_psc e0de2748 2 0x2001 41 2 N T informix tempdbs e0de2898 3 0x1 3 1 N informix logicaldbs e0de29e8 4 0x1 4 9 N informix dbspace1 e0de2b38 5 0x1 6 51 N informix dbspace2 e0de2c88 6 0x5 73 62 ND informix dbspace3 e0de2dd8 7 0x1 75 1 N informix psc_tmp1 e0de3018 8 0x11 12 1 N B informix blobspace1 e0de3168 9 0x1 13 1 N informix index1 e0de32b8 10 0x1 64 1 N informix dptraining1 10 active, 2047 maximum Note: For BLOB chunks, the number of free pages shown is out of date. Run 'onstat -d update' for current stats. Chunks address chk/dbs offset size free bpages flags pathname e06d9938 1 1 0 25000 21014 PO- /home/informix/psck5701/dpchk01 e0dd2a98 2 5 0 1024000 127235 PO- /home/informix/psck5701/dpchk02 e0dd2c08 3 3 0 1000000 129947 PO- /home/informix/psck5701/dpchk03 e0dd2d78 4 4 0 1000000 272 PO- /home/informix/psck5701/dpchk06 e0dd3018 5 4 0 1000000 432 PO- /home/informix/psck5701/dpchk07 e0dd3188 6 5 0 1000000 4972 PO- /home/informix/psck5701/dpchk11 e0dd32f8 7 5 0 1000000 14662 PO- /home/informix/psck5701/dpchk12 e0dd3468 8 5 0 1024000 26702 PO- /home/informix/psck5701/dpchk16 e0dd35d8 9 5 0 1024000 15113 PO- /home/informix/psck5701/dpchk17 e0dd3748 10 5 0 1024000 9114 PO- /home/informix/psck5701/dpchk35 e0dd38b8 11 5 0 1024000 4435 PO- /home/informix/psck5701/dpchk38 e0dd3a28 12 8 0 1000000 ~200 200 POB /home/informix/psck5701/dpchk39 e0dd3b98 13 9 0 1000000 999569 PO- /home/informix/psck5701/dpchk36 e0dd3d08 14 5 0 1024000 540541 PO- /home/informix/psck5701/dpchk18 e0dd3e78 15 5 0 1024000 349453 PO- /home/informix/psck5701/dpchk21 e0dd4018 16 4 0 1000000 309 PO- /home/informix/psck5701/dpchk08 e0dd4188 17 4 0 1000000 128 PO- /home/informix/psck5701/dpchk09 e0dd42f8 18 5 0 1024000 220856 PO- /home/informix/psck5701/dpchk26 e0dd4468 19 5 0 1000000 8955 PO- /home/informix/psck5701/dpchk13 e0dd45d8 20 5 0 1000000 9520 PO- /home/informix/psck5701/dpchk14 e0dd4748 21 6 0 1024000 0 PD- /backup/INFORMIX/data33.dat e0dd48b8 22 6 0 1024000 0 PD- /backup/INFORMIX/data34.dat e0dd4a28 23 5 0 1024000 12180 PO- /home/informix/psck5701/dpchk20 e0dd4b98 24 5 0 1024000 13568 PO- /home/informix/psck5701/dpchk22 e0dd4d08 25 6 0 1024000 0 PD- /backup/INFORMIX/data35.dat e0dd4e78 26 6 0 1024000 0 PD- /backup/INFORMIX/data36.dat e0dd5018 27 5 0 1024000 12370 PO- /home/informix/psck5701/dpchk24 e0dd5188 28 4 0 1024000 153 PO- /home/informix/psck5701/dpchk25 e0dd52f8 29 5 0 1000000 21095 PO- /home/informix/psck5701/dpchk41 e0dd5468 30 5 0 1024000 12484 PO- /home/informix/psck5701/dpchk31 e0dd55d8 31 5 0 1024000 7515 PO- /home/informix/psck5701/dpchk32 e0dd5748 32 6 0 1024000 0 PD- /backup/INFORMIX/data37.dat e0dd58b8 33 6 0 1024000 0 PD- /backup/INFORMIX/data38.dat e0dd5a28 34 5 0 1000000 26838 PO- /home/informix/psck5701/dpchk15 e0dd5b98 35 5 0 1000000 21645 PO- /home/informix/psck5701/dpchk23 e0dd5d08 36 6 0 1024000 0 PD- /backup/INFORMIX/data39.dat e0dd5e78 37 6 0 1024000 0 PD- /backup/INFORMIX/data40.dat e0dd6018 38 5 0 1024000 283225 PO- /home/informix/psck5701/dpchk33 e0dd6188 39 5 0 1024000 434343 PO- /home/informix/psck5701/dpchk37 e0dd62f8 40 5 0 1024000 1007685 PO- /home/informix/psck5701/dpchk40 e0dd6468 41 2 0 50000 49947 PO- /home/informix/psck5701/dpchk04 e0dd65d8 42 5 0 1024000 560387 PO- /home/informix/psck5701/dpchk42 e0dd6748 43 6 0 1024000 0 PD- /backup/INFORMIX/data41.dat e0dd68b8 44 6 0 1024000 0 PD- /backup/INFORMIX/data42.dat e0dd6a28 45 5 0 1024000 11935 PO- /home/informix/psck5701/dpchk47 e0dd6b98 46 6 0 1024000 0 PD- /backup/INFORMIX/data43.dat e0dd6d08 47 6 0 1024000 0 PD- /backup/INFORMIX/data44.dat e0dd6e78 48 6 0 1024000 0 PD- /backup/INFORMIX/data45.dat e0dd7018 49 6 0 1024000 0 PD- /backup/INFORMIX/data46.dat e0dd7188 50 5 0 512000 2293 PO- /home/informix/psck5701/dpchk52 e0dd72f8 51 6 0 1024000 0 PD- /backup/INFORMIX/data47.dat e0dd7468 52 6 0 1024000 0 PD- /backup/INFORMIX/data48.dat e0dd75d8 53 6 0 1024000 0 PD- /backup/INFORMIX/data49.dat e0dd7748 54 5 0 512000 5232 PO- /home/informix/psck5701/dpchk56 e0dd78b8 55 5 0 512000 3648 PO- /home/informix/psck5701/dpchk57 e0dd7a28 56 6 0 1024000 0 PD- /backup/INFORMIX/data50.dat e0dd7b98 57 6 0 1024000 0 PD- /backup/INFORMIX/data51.dat e0dd7d08 58 6 0 1024000 0 PD- /backup/INFORMIX/data52.dat e0dd7e78 59 6 0 1024000 0 PD- /backup/INFORMIX/data53.dat e0dd8018 60 6 0 1024000 0 PD- /backup/INFORMIX/data54.dat e0dd8188 61 5 0 1024000 1012 PO- /home/informix/psck5701/dpchk62 e0dd82f8 62 5 0 1024000 8886 PO- /home/informix/psck5701/dpchk63 e0dd8468 63 6 0 1024000 0 PD- /backup/INFORMIX/data55.dat e0dd85d8 64 10 0 1024000 783683 PO- /home/informix/psck5701/dpchk64 e0dd8748 65 5 0 1024000 342365 PO- /backup/INFORMIX/data56.dat e0dd88b8 66 6 0 1024000 0 PD- /backup/INFORMIX/data57.dat e0dd8a28 67 5 0 1024000 541245 PO- /home/informix/psck5701/dpchk05 e0dd8b98 68 5 0 1024000 462653 PO- /home/informix/psck5701/dpchk10 e0dd8d08 69 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk19 e0dd8e78 70 4 0 1024000 1 PO- /home/informix/psck5701/dpchk43 e0dd9018 71 4 0 1024000 0 PO- /home/informix/psck5701/dpchk34 e0dd9188 72 2 512001 500000 499997 PO- /home/informix/psck5701/dpchk52 e0dd92f8 73 6 0 1024000 0 PD- /backup/INFORMIX/data1.dat e0dd9468 74 6 0 1024000 0 PD- /backup/INFORMIX/data2.dat e0dd95d8 75 7 0 400000 380417 PO- /home/informix/psck5701/dpchk67 e0dd9748 76 6 0 1024000 0 PD- /backup/INFORMIX/data3.dat e0dd98b8 77 6 0 1024000 0 PD- /backup/INFORMIX/data4.dat e0dd9a28 78 6 0 1024000 0 PD- /backup/INFORMIX/data5.dat e0dd9b98 79 6 0 1024000 0 PD- /backup/INFORMIX/data6.dat e0dd9d08 80 6 0 1024000 0 PD- /backup/INFORMIX/data7.dat e0dd9e78 81 6 0 1024000 0 PD- /backup/INFORMIX/data8.dat e0dda018 82 6 0 1024000 0 PD- /backup/INFORMIX/data9.dat e0dda188 83 6 0 1024000 0 PD- /backup/INFORMIX/data10.dat e0dda2f8 84 6 0 1024000 0 PD- /backup/INFORMIX/data11.dat e0dda468 85 6 0 1024000 0 PD- /backup/INFORMIX/data12.dat e0dda5d8 86 6 0 1024000 0 PD- /backup/INFORMIX/data13.dat e0dda748 87 6 0 1024000 0 PD- /backup/INFORMIX/data14.dat e0dda8b8 88 6 0 1024000 0 PD- /backup/INFORMIX/data15.dat e0ddaa28 89 6 0 1024000 0 PD- /backup/INFORMIX/data16.dat e0ddab98 90 6 0 1024000 0 PD- /backup/INFORMIX/data17.dat e0ddad08 91 6 0 1024000 0 PD- /backup/INFORMIX/data18.dat e0ddae78 92 6 0 1024000 0 PD- /backup/INFORMIX/data19.dat e0ddb018 93 6 0 1024000 0 PD- /backup/INFORMIX/data20.dat e0ddb188 94 6 0 1024000 0 PD- /backup/INFORMIX/data21.dat e0ddb2f8 95 6

you must restore from level 0 backup. Thanks, Frank CHANATIP LA.... wrote: >How to enable dbspace? dbspace3 be disble from I/O error. Now disks were >replace already. >N740-Informix > onstat -d > >Informix Dynamic Server Version 9.30.HC3 -- On-Line -- Up 03:03:32 -- 367852 >Kbytes > >Dbspaces >address number flags fchunk nchunks flags owner name >e06d97e8 1 0x1001 1 1 N informix rootdbs_psc >e0de2748 2 0x2001 41 2 N T informix tempdbs >e0de2898 3 0x1 3 1 N informix logicaldbs >e0de29e8 4 0x1 4 9 N informix dbspace1 >e0de2b38 5 0x1 6 51 N informix dbspace2 >e0de2c88 6 0x5 73 62 ND informix dbspace3 >e0de2dd8 7 0x1 75 1 N informix psc_tmp1 >e0de3018 8 0x11 12 1 N B informix blobspace1 >e0de3168 9 0x1 13 1 N informix index1 >e0de32b8 10 0x1 64 1 N informix dptraining1 >10 active, 2047 maximum > >Note: For BLOB chunks, the number of free pages shown is out of date. > >Run 'onstat -d update' for current stats. > >Chunks >address chk/dbs offset size free bpages flags pathname >e06d9938 1 1 0 25000 21014 PO- /home/informix/psck5701/dpchk01 >e0dd2a98 2 5 0 1024000 127235 PO- /home/informix/psck5701/dpchk02 >e0dd2c08 3 3 0 1000000 129947 PO- /home/informix/psck5701/dpchk03 >e0dd2d78 4 4 0 1000000 272 PO- /home/informix/psck5701/dpchk06 >e0dd3018 5 4 0 1000000 432 PO- /home/informix/psck5701/dpchk07 >e0dd3188 6 5 0 1000000 4972 PO- /home/informix/psck5701/dpchk11 >e0dd32f8 7 5 0 1000000 14662 PO- /home/informix/psck5701/dpchk12 >e0dd3468 8 5 0 1024000 26702 PO- /home/informix/psck5701/dpchk16 >e0dd35d8 9 5 0 1024000 15113 PO- /home/informix/psck5701/dpchk17 >e0dd3748 10 5 0 1024000 9114 PO- /home/informix/psck5701/dpchk35 >e0dd38b8 11 5 0 1024000 4435 PO- /home/informix/psck5701/dpchk38 >e0dd3a28 12 8 0 1000000 ~200 200 POB /home/informix/psck5701/dpchk39 >e0dd3b98 13 9 0 1000000 999569 PO- /home/informix/psck5701/dpchk36 >e0dd3d08 14 5 0 1024000 540541 PO- /home/informix/psck5701/dpchk18 >e0dd3e78 15 5 0 1024000 349453 PO- /home/informix/psck5701/dpchk21 >e0dd4018 16 4 0 1000000 309 PO- /home/informix/psck5701/dpchk08 >e0dd4188 17 4 0 1000000 128 PO- /home/informix/psck5701/dpchk09 >e0dd42f8 18 5 0 1024000 220856 PO- /home/informix/psck5701/dpchk26 >e0dd4468 19 5 0 1000000 8955 PO- /home/informix/psck5701/dpchk13 >e0dd45d8 20 5 0 1000000 9520 PO- /home/informix/psck5701/dpchk14 >e0dd4748 21 6 0 1024000 0 PD- /backup/INFORMIX/data33.dat >e0dd48b8 22 6 0 1024000 0 PD- /backup/INFORMIX/data34.dat >e0dd4a28 23 5 0 1024000 12180 PO- /home/informix/psck5701/dpchk20 >e0dd4b98 24 5 0 1024000 13568 PO- /home/informix/psck5701/dpchk22 >e0dd4d08 25 6 0 1024000 0 PD- /backup/INFORMIX/data35.dat >e0dd4e78 26 6 0 1024000 0 PD- /backup/INFORMIX/data36.dat >e0dd5018 27 5 0 1024000 12370 PO- /home/informix/psck5701/dpchk24 >e0dd5188 28 4 0 1024000 153 PO- /home/informix/psck5701/dpchk25 >e0dd52f8 29 5 0 1000000 21095 PO- /home/informix/psck5701/dpchk41 >e0dd5468 30 5 0 1024000 12484 PO- /home/informix/psck5701/dpchk31 >e0dd55d8 31 5 0 1024000 7515 PO- /home/informix/psck5701/dpchk32 >e0dd5748 32 6 0 1024000 0 PD- /backup/INFORMIX/data37.dat >e0dd58b8 33 6 0 1024000 0 PD- /backup/INFORMIX/data38.dat >e0dd5a28 34 5 0 1000000 26838 PO- /home/informix/psck5701/dpchk15 >e0dd5b98 35 5 0 1000000 21645 PO- /home/informix/psck5701/dpchk23 >e0dd5d08 36 6 0 1024000 0 PD- /backup/INFORMIX/data39.dat >e0dd5e78 37 6 0 1024000 0 PD- /backup/INFORMIX/data40.dat >e0dd6018 38 5 0 1024000 283225 PO- /home/informix/psck5701/dpchk33 >e0dd6188 39 5 0 1024000 434343 PO- /home/informix/psck5701/dpchk37 >e0dd62f8 40 5 0 1024000 1007685 PO- /home/informix/psck5701/dpchk40 >e0dd6468 41 2 0 50000 49947 PO- /home/informix/psck5701/dpchk04 >e0dd65d8 42 5 0 1024000 560387 PO- /home/informix/psck5701/dpchk42 >e0dd6748 43 6 0 1024000 0 PD- /backup/INFORMIX/data41.dat >e0dd68b8 44 6 0 1024000 0 PD- /backup/INFORMIX/data42.dat >e0dd6a28 45 5 0 1024000 11935 PO- /home/informix/psck5701/dpchk47 >e0dd6b98 46 6 0 1024000 0 PD- /backup/INFORMIX/data43.dat >e0dd6d08 47 6 0 1024000 0 PD- /backup/INFORMIX/data44.dat >e0dd6e78 48 6 0 1024000 0 PD- /backup/INFORMIX/data45.dat >e0dd7018 49 6 0 1024000 0 PD- /backup/INFORMIX/data46.dat >e0dd7188 50 5 0 512000 2293 PO- /home/informix/psck5701/dpchk52 >e0dd72f8 51 6 0 1024000 0 PD- /backup/INFORMIX/data47.dat >e0dd7468 52 6 0 1024000 0 PD- /backup/INFORMIX/data48.dat >e0dd75d8 53 6 0 1024000 0 PD- /backup/INFORMIX/data49.dat >e0dd7748 54 5 0 512000 5232 PO- /home/informix/psck5701/dpchk56 >e0dd78b8 55 5 0 512000 3648 PO- /home/informix/psck5701/dpchk57 >e0dd7a28 56 6 0 1024000 0 PD- /backup/INFORMIX/data50.dat >e0dd7b98 57 6 0 1024000 0 PD- /backup/INFORMIX/data51.dat >e0dd7d08 58 6 0 1024000 0 PD- /backup/INFORMIX/data52.dat >e0dd7e78 59 6 0 1024000 0 PD- /backup/INFORMIX/data53.dat >e0dd8018 60 6 0 1024000 0 PD- /backup/INFORMIX/data54.dat >e0dd8188 61 5 0 1024000 1012 PO- /home/informix/psck5701/dpchk62 >e0dd82f8 62 5 0 1024000 8886 PO- /home/informix/psck5701/dpchk63 >e0dd8468 63 6 0 1024000 0 PD- /backup/INFORMIX/data55.dat >e0dd85d8 64 10 0 1024000 783683 PO- /home/informix/psck5701/dpchk64 >e0dd8748 65 5 0 1024000 342365 PO- /backup/INFORMIX/data56.dat >e0dd88b8 66 6 0 1024000 0 PD- /backup/INFORMIX/data57.dat >e0dd8a28 67 5 0 1024000 541245 PO- /home/informix/psck5701/dpchk05 >e0dd8b98 68 5 0 1024000 462653 PO- /home/informix/psck5701/dpchk10 >e0dd8d08 69 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk19 >e0dd8e78 70 4 0 1024000 1 PO- /home/informix/psck5701/dpchk43 >e0dd9018 71 4 0 1024000 0 PO- /home/informix/psck5701/dpchk34 >e0dd9188 72 2 512001 500000 499997 PO- /home/informix/psck5701/dpchk52 >e0dd92f8 73 6 0 1024000 0 PD- /backup/INFORMIX/data1.dat >e0dd9468 74 6 0 1024000 0 PD- /backup/INFORMIX/data2.dat >e0dd95d8 75 7 0 400000 380417 PO- /home/informix/psck5701/dpchk67 >e0dd9748 76 6 0 1024000 0 PD- /backup/INFORMIX/data3.dat >e0dd98b8 77 6 0 1024000 0 PD- /backup/INFORMIX/data4.dat >e0dd9a28 78 6 0 1024000 0 PD- /backup/INFORMIX/data5.dat >e0dd9b98 79 6 0 1024000 0 PD- /backup/INFORMIX/data6.dat >e0dd9d08 80 6 0 1024000 0 PD- /backup/INFORMIX/data7.dat >e0dd9e78 81 6 0 1024000 0 PD- /backup/INFORMIX/data8.dat >e0dda018 82 6 0 1024000 0 PD- /backup/INFORMIX/data9.dat >e0dda188 83 6 0 1024000 0 PD- /backup/INFORMIX/data10.dat >e0dda2f8 84 6 0 1024000 0 PD- /backup/INFORMIX/data11.dat >e0dda468 85 6 0 1024000 0 PD- /backup/INFORMIX/data12.dat >e0dda5d8 86 6 0 1024000 0 PD- /backup/INFORMIX/data13.dat >e0dda748 87 6 0 1024000 0 PD- /backup/INFORMIX/data14.dat >e0dda8b8 88 6 0 1024000 0 PD- /backup/INFORMIX/data15.dat >e0ddaa28 89 6 0 1024000 0 PD- /backup/INFORMIX/data16.dat >e0ddab98 90 6 0 1024000 0 PD- /backup/INFORMIX/data17.dat >e0ddad08 91 6 0 1024000 0 PD- /backup/INFORMIX/data18.dat >e0ddae78 92 6 0 1024000 0 PD- /backup/INFORMIX/data19.dat >e0ddb018 93 6 0 1024000 0 PD- /backup/INFORMIX/data20.dat >e0ddb188 94 6 0 1024000 0 PD- /backup/INFORMIX/data21.dat >e0ddb2f8 95 6 0 1024000 0 PD- /backup/INFORMIX/data22.dat >e0ddb468 96 6 0 1024000 0 PD- /backup/INFORMIX/data23.dat >e0ddb5d8 97 6 0 1024000 0 PD- /backup/INFORMIX/data24.dat >e0ddb748 98 6 0 1024000 0 PD- /backup/INFORMIX/data25.dat >e0ddb8b8 99 6 0 1024000 0 PD- /backup/INFORMIX/data26.dat >e0ddba28 100 6 0 1024000 0 PD- /backup/INFORMIX/dat