Re: "bad primary chunk" with temporary dbspace

We have been experiencing similar problems under 7.12 and have corrected them by modifying the actual dbspace name within the roodbs. Determine if your dbspace name is bad by doing the following: do an 'oncheck -pP 1 4 | pg' . This will dump the page for chunck 1 ( where rootdbs resides ) page 4. The output should be similar to the following: addr stamp nslots flag type frptr frcnt next prev 100004 1131813584 3 1000 ROOTRSV 228 1804 0 0 slot ptr len flg 1 24 68 0 2 92 68 0 3 160 68 0 slot 1: 0: 1 0 1 0 1 0 1 0 4a a3 7c 2f e 0 0 0 ........J#|/.... 16: 9 a3 94 32 43 8d 0 0 18 90 1c 0 43 8d 0 0 .#.2C.......C... 32: ff ff ff ff 58 29 c3 83 72 6f 6f 74 64 62 73 20 ....X)C.rootdbs 48: 20 20 20 20 20 20 20 20 20 20 69 6e 66 6f 72 6d inform 64: 69 78 0 0 ix.............. slot 2: 0: 2 0 1 0 2 0 3 0 2e a8 7c 2f 4 0 0 0 .........(|/.... 16: 9 a3 94 32 43 8d 0 0 18 90 1c 0 43 8d 0 0 .#.2C.......C... 32: 0 0 0 0 90 2e c3 83 69 66 69 63 73 64 62 20 ......C.ificsdb 48: 20 20 20 20 20 20 20 20 20 20 69 6e 66 6f 72 6d inform 64: 69 78 0 0 ix.............. slot 3: 0: 3 0 1 20 5 0 1 0 54 ea 1c 32 4 0 0 0 ... ....Tj.2.... 16: 9 a3 94 32 0 0 0 0 0 0 0 0 0 0 0 0 .#.2............ 32: 0 0 0 0 b0 30 c3 83 69 66 69 63 73 74 6d 70 ....00C.ificstmp 48: 20 20 20 20 20 20 20 20 20 20 69 6e 66 6f 72 6d inform 64: 69 78 0 0 In the example above, our problem was in the 'ificstmp' dbspace name. If the dbspace name has anything other than a space (20) before or after it, then you have a problem. We were consitantly getting a null right after the dbspace name and had to write a program which would read the contents of the device, look for the dpspace name and check for anything other than a space before or after the name. If a space was not found, we would replace it with one. Informix can dial up and correct this for you or you can write a c program like the one we did to modify the dbspace name. oh, bring the engine down before attempting any of this. I recomend that Informix dials up and corrects this for you. If you have a test box to try this, then have fun. ------------------------------------------------------ Jorge Torralba, DBA | Intel Corp | HF2-71 Systems Manufacturing | 5200 N.E. Elam Young Parkway Information Technology | Hillsboro, Or 97124 | (503)696-4587 ------------------------------------------------------ Any views, comments, expressions or suggestions do not reflect those of Intel Corp. ------------------------------------------------------