Posting from the Informix-list

This is a multi-part message in MIME format. ------=_NextPart_000_0026_01BF9427.8EEE98E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Listers, We are using IDS for Workgroups 7.30.UC3 on Solaris 2.7. I have allocated 6 slices to Informix dbspaces. Two of the dbspaces have one chunk of 2GB each. One of these dbspaces is for our General Ledger tables. The other is for Non-GL tables. I attempted to export and import the database in an effort to consolidate all GL tables and indexes in dbspace "sxxigldbs". Before trying this procedure the dbspaces reported the following amounts of free space: Size Free rootdbs 48MB 43MB logsdbs 97MB 48MB physdbs 29MB 28MB sxxicoredbs 1953MB 1949MB sxxigldbs 1953MB 968MB tempsdbs(1-6) 48MB 48MB After the import failed due to lack of space in the chunk, the space usage reported by the two dbspaces that were changed is as follows: sxxicoredbs 1953MB 1952MB sxxigldbs 1953MB 0MB I know we simply ran out of chunk space. However, my question is why is it that before when the GL indexes was in the other dbspace (sxxicoredbs) the space used was only about 4MB. Then when I'm creating the indexes in the same dbspace as the GL tables they use about 968MB. I know that it is desirable to create indexes in their own dbspace, however, I' ve run out slices on the Sun 9GB external disk. How can I measure the space used by indexes. The GL system has one table that is large. It is the transactions history table. It has 11 indexes consisting of several fields. I know it's the space Hog. It's desirable to create that table in its own dbspace as well. Another issue is that I want to be able to restore just the GL dbspace which would have all the GL tables and indexes and not the Non-GL dbspaces. How can I do that if I'm using ontape to backup? I tried restoring only selected dbspaces before using ontape, but the database was left in an incompatible state. I had to restore all dbspaces. I would appreciate your comments and ideas. Thanks in advance for your help. Denmark W. ------=_NextPart_000_0026_01BF9427.8EEE98E0 Content-Type: application/msword; name="glimportfail.doc" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="glimportfail.doc" 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAbwAAAAAAAAAA EAAAcQAAAAEAAAD+////AAAAAG4AAAD///////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////s pcEANyAJBAAA+BK/AAAAAAAAEAAAAAAABAAAAxgAAA4AYmpialUWVRYAAAAAAAAAAAAAAAAAAAAA AAAJBBYAJSwAADd8AAA3fAAAAxQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//w8AAAAA AAAAAAD//w8AAAAAAAAAAAD//w8AAAAAAAAAAAAAAAAAAAAAAGwAAAAAAKgAAAAAAAAAqAAAAKgA AAAAAAAAqAAAAAAAAACoAAAAAAAAAKgAAAAAAAAAqAAAABQAAAAAAAAAAAAAALwAAAAAAAAAGg8A AAAAAAAaDwAAAAAAABoPAAAAAAAAGg8AAAwAAAAmDwAANAAAALwAAAAAAAAARxsAAPYAAABmDwAA AAAAAGYPAAAAAAAAZg8AAAAAAABmDwAAAAAAAGYPAAAAAAAAZg8AAAAAAABmDwAAAAAAAGYPAAAA AAAAxhoAAAIAAADIGgAAAAAAAMgaAAAAAAAAyBoAAAAAAADIGgAAAAAAAMgaAAAAAAAAyBoAACQA AAA9HAAAIAIAAF0eAAD2AAAA7BoAABUAAAAAAAAAAAAAAAAAAAAAAAAAqAAAAAAAAABmDwAAAAAA AAAAAAAAAAAAAAAAAAAAAABmDwAAAAAAAGYPAAAAAAAAZg8AAAAAAABmDwAAAAAAAOwaAAAAAAAA IhkAAAAAAACoAAAAAAAAAKgAAAAAAAAAZg8AAAAAAAAAAAAAAAAAAGYPAAAAAAAAARsAABYAAAAi GQAAAAAAACIZAAAAAAAAIhkAAAAAAABmDwAAeAQAAKgAAAAAAAAAZg8AAAAAAACoAAAAAAAAAGYP AAAAAAAAxhoAAAAAAAAAAAAAAAAAACIZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAZg8AAAAAAADGGgAAAAAAACIZAACkAQAAIhkAAAAAAAAAAAAA AAAAAMYaAAAAAAAAqAAAAAAAAACoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAxhoAAAAAAABmDwAAAAAAAFoPAAAMAAAAYDcIy0mU vwG8AAAAXg4AABoPAAAAAAAA3hMAAEQFAADGGgAAAAAAAAAAAAAAAAAAxhoAAAAAAAAXGwAAMAAA AEcbAAAAAAAAxhoAAAAAAABTHwAAAAAAACIZAAAAAAAAUx8AAAAAAADGGgAAAAAAACIZAAAAAAAA vAAAAAAAAAC8AAAAAAAAAKgAAAAAAAAAqAAAAAAAAACoAAAAAAAAAKgAAAAAAAAAAgDZAAAAYmJh bmtvd3tzeHhpb3B9L2V4cG9ydC9ob21lL0RCZXhwb3J0cz5kYmltcG9ydCAtZCBzeHhpZ2xkYnMg c3h4aWRiDQ17IERBVEFCQVNFIHN4eGlkYiAgZGVsaW1pdGVyIHwgfQ0NZ3JhbnQgZGJhIHRvICJz eHhpb3AiOw1ncmFudCBkYmEgdG8gImluZm9ybWl4IjsNZ3JhbnQgZGJhIHRvICJkZW5tYXJrIjsN Z3JhbnQgY29ubmVjdCB0byAicHVibGljIjsNLg0uDS4NDQ0BDQ0NDQ0NDQ0NDQ17IFRBQkxFICJz eHhpb3AiLm1jaCByb3cgc2l6ZSA9IDQ5NCBudW1iZXIgb2YgY29sdW1ucyA9IDY4IGluZGV4IHNp emUgPSA4MzggfQ17IHVubG9hZCBmaWxlIG5hbWUgPSBtY2hfXzAwMjE5LnVubCBudW1iZXIgb2Yg cm93cyA9IDcxMjEyOSB9DQ1jcmVhdGUgdGFibGUgInN4eGlvcCIubWNoIA0gICgNICAgIGNvZW50 ZmluY2JsZSBkZWNpbWFsKDUsMCkgbm90IG51bGwgLA0gICAgZmVtb3ZjYmxlIGRlY2ltYWwoOCww KSBub3QgbnVsbCAsDSAgICBjb3RpdW5pb3JnZXh0IGNoYXIoMSkgbm90IG51bGwgLA0gICAgY291 bmlvcmdleHQgZGVjaW1hbCg1LDApIG5vdCBudWxsICwNICAgIGNvY29tY29udCBjaGFyKDMpIG5v dCBudWxsICwNICAgIG5yY29tY2JsZSBkZWNpbWFsKDUsMCkgbm90IG51bGwgLA0gICAgbnJzZWNt Y28gZGVjaW1hbCg1LDApIG5vdCBudWxsICwNICAgIG5yY3RhY2JsZSBjaGFyKDE1KSBub3QgbnVs bCAsDSAgICB0eGRlc21vdiBjaGFyKDUwKSBub3QgbnVsbCAsDSAgICBjb3RpdW5pb3JnZXh0MSBj aGFyKDEpIG5vdCBudWxsICwNICAgIGNvdW5pb3JnZXh0MSBkZWNpbWFsKDUsMCkgbm90IG51bGwg LA0gICAgY290aXVuaW9yZ2V4dDIgY2hhcigxKSBub3QgbnVsbCAsDSAgICBjb3VuaW9yZ2V4dDIg ZGVjaW1hbCg1LDApIG5vdCBudWxsICwNICAgIGNvdGl1bmlvcmdleHQzIGNoYXIoMSkgbm90IG51 bGwgLA0gICAgY291bmlvcmdleHQzIGRlY2ltYWwoNSwwKSBub3QgbnVsbCAsDSAgICBjb3RpdW5p b3JnZXh0NCBjaGFyKDEpIG5vdCBudWxsICwNICAgIGNvdW5pb3JnZXh0NCBkZWNpbWFsKDUsMCkg bm90IG51bGwgLA0gICAgY29uYXRjdGFjYmxlIGNoYXIoMSkgbm90IG51bGwgLA0gICAgZmxtb3Zj YmxlZmVjdmFsIGNoYXIoMSkgbm90IG51bGwgLA0gICAgbnJ0ZXJjYmxlIGNoYXIoMjApIG5vdCBu dWxsICwNICAgIGNvcHJvZCBkZWNpbWFsKDMsMCkgbm90IG51bGwgLA0gICAgY29zYnAgZGVjaW1h bCg1LDApIG5vdCBudWxsICwNICAgIG5ydXNlcmlkIGNoYXIoOCkgbm90IG51bGwgLA0gICAgaW1t b3ZjYmxlbW9ubGVnIGRlY2ltYWwoMTcsMikgbm90IG51bGwgLA0gICAgaW1tb3ZjYmxlbW9uZXh0 IGRlY2ltYWwoMTcsMikgbm90IG51bGwgLA0gICAgaW1tb25yZWV4cCBkZWNpbWFsKDE3LDIpIG5v dCBudWxsICwNICAgIGNvbW9uIGRlY2ltYWwoMywwKSBub3QgbnVsbCAsDSAgICBjb3RyYWNibGUg ZGVjaW1hbCg1LDApIG5vdCBudWxsICwNICAgIG5ydXNlcmlkMSBjaGFyKDgpIG5vdCBudWxsICwN ICAgIG5ydXNlcmlkMiBjaGFyKDgpIG5vdCBudWxsICwNICAgIGZlaW5ncmVzbyBkZWNpbWFsKDgs MCkgbm90IG51bGwgLA0gICAgdG1pbmcgZGVjaW1hbCg4LDApIG5vdCBudWxsICwNICAgIGZlbW9k bW92Y2JsZSBkZWNpbWFsKDgsMCkgbm90IG51bGwgLA0gICAgdG1tb2Rtb3ZjYmxlIGRlY2ltYWwo OCwwKSBub3QgbnVsbCAsDSAgICBucmRvY2NibGUgZGVjaW1hbCgxNSwwKSBub3QgbnVsbCAsDSAg ICBucnJlZmNydWNibGUgY2hhcigxNSkgbm90IG51bGwgLA0gICAgY29pbmRjb250MSBkZWNpbWFs KDksMCkgbm90IG51bGwgLA0gICAgY29pbmRjb250MiBkZWNpbWFsKDksMCkgbm90IG51bGwgLA0g ICAgY29pbmRjb250MyBkZWNpbWFsKDksMCkgbm90IG51bGwgLA0gICAgY29pbmRjb250NCBkZWNp bWFsKDksMCkgbm90IG51bGwgLA0gICAgY29pbmRjb250NSBkZWNpbWFsKDksMCkgbm90IG51bGwg LA0gICAgY29pbmRjb250NiBkZWNpbWFsKDksMCkgbm90IG51bGwgLA0gICAgY29pbmRjb250NyBk ZWNpbWFsKDksMCkgbm90IG51bGwgLA0gICAgY29pbmRjb250OCBkZWNpbWFsKDksMCkgbm90IG51 bGwgLA0gICAgY29pbmRjb250OSBkZWNpbWFsKDksMCkgbm90IG51bGwgLA0gICAgY

In article <8bbnq2$c4e$1@news.xmission.com>, Denmark B. Weatherburn <dweatherb@btl.net> writes > >This is a multi-part message in MIME format. >I know we simply ran out of chunk space. However, my question is why is it >that >before when the GL indexes was in the other dbspace (sxxicoredbs) the space >used >was only about 4MB. Then when I'm creating the indexes in the same dbspace >as the >GL tables they use about 968MB. What does oncheck -pe give?? -- David Williams