upgrade from 9.4 to 11.5-Tablespace extent problem

Posted in 2010

Topics: Installation, Setup & Upgrades, Storage & Space Management, Migration, Import/Export & Data Conversion

STANISLAV — Wed, 10 Nov 2010 12:59:08 — source: IIUG Forums & Mailing Lists

Hi all we are trying to do upgrade from Informix 9.4 to 11.5, but after running oninit on new installed version we get the following output: 11:40:56 Conversion from version 9.40 Started 11:40:57 Checking partition header pages for needed free space 11:40:58 ERROR: Not enough space in partition header page 11:40:58 Partition header page (Chunk 11 Offset 414965) for partition 0x200265 (with 414 extents) has free space 4 and the space needed is 8 11:40:58 Reduce the number of extents from 414 using UNLOAD and LOAD or ALTER FRAGMENT INIT and free up space And after researching with oncheck we figure out that offset 414965 belongs to tablespace tblespace in the Chunk 11: 128 rzbrws:'prod'.fivumins_ix2 414948 4 gdpdbs:'informix'.TBLSpace 414952 50 rzbrws:'prod'. 180_505 415002 2272 rzbrws:'prod'.ausausol_ix1 417274 3040 Is there any solution to this problem besides unload and load the whole database? Bacause i thinkg it cannot be possible to alter fragment for tablespace tablespace. Thank you ind advance for your help. best regards Stanislav Ondac

↪ replying to STANISLAV

Art Kagel — Wed, 10 Nov 2010 13:32:15 — source: IIUG Forums & Mailing Lists

Alter fragment ... unit in may do it. Or if the table has any old legacy attached indexes you can stop one of them. That will also free up space on the header page. Deyach Art On Nov 10, 2010 7:59 AM, "STANISLAV ONDAC" <stanislav.ondac@dignitas.sk> wrote: > Hi all > > we are trying to do upgrade from Informix 9.4 to 11.5, but after running > oninit on new installed version we get the following output: > 11:40:56 Conversion from version 9.40 Started > 11:40:57 Checking partition header pages for needed free space > 11:40:58 ERROR: Not enough space in partition header page > 11:40:58 Partition header page (Chunk 11 Offset 414965) for partition > 0x200265 (with 414 extents) has free space 4 and the space needed is 8 > 11:40:58 Reduce the number of extents from 414 using UNLOAD and LOAD or > ALTER FRAGMENT INIT and free up space> > And after researching with oncheck we figure out that offset 414965 belongs to > tablespace tblespace in the Chunk 11: > > 128 > rzbrws:'prod'.fivumins_ix2 414948 > 4 > gdpdbs:'informix'.TBLSpace 414952 > 50 > rzbrws:'prod'. 180_505 415002 > 2272 > rzbrws:'prod'.ausausol_ix1 417274 > 3040 > > Is there any solution to this problem besides unload and load the whole > database? > Bacause i thinkg it cannot be possible to alter fragment for tablespace > tablespace. > > Thank you ind advance for your help. > > best regards > Stanislav Ondac > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636283616479b1c0494b2e24d

↪ replying to Art Kagel

Art Kagel — Wed, 10 Nov 2010 13:35:07 — source: IIUG Forums & Mailing Lists

Oops that got away from me. I meant to add that detached indexes don't take up partition page space, though. Art On Nov 10, 2010 8:32 AM, "Art Kagel" <art.kagel@gmail.com> wrote: > Alter fragment ... unit in may do it. Or if the table has any old legacy > attached indexes you can stop one of them. That will also free up space on > the header page. Deyach > > Art > On Nov 10, 2010 7:59 AM, "STANISLAV ONDAC" <stanislav.ondac@dignitas.sk> > wrote: >> Hi all >> >> we are trying to do upgrade from Informix 9.4 to 11.5, but after running >> oninit on new installed version we get the following output: >> 11:40:56 Conversion from version 9.40 Started >> 11:40:57 Checking partition header pages for needed free space >> 11:40:58 ERROR: Not enough space in partition header page >> 11:40:58 Partition header page (Chunk 11 Offset 414965) for partition >> 0x200265 (with 414 extents) has free space 4 and the space needed is 8 >> 11:40:58 Reduce the number of extents from 414 using UNLOAD and LOAD or >> ALTER FRAGMENT INIT and free up space>> >> And after researching with oncheck we figure out that offset 414965 > belongs to >> tablespace tblespace in the Chunk 11: >> >> 128 >> rzbrws:'prod'.fivumins_ix2 414948 >> 4 >> gdpdbs:'informix'.TBLSpace 414952 >> 50 >> rzbrws:'prod'. 180_505 415002 >> 2272 >> rzbrws:'prod'.ausausol_ix1 417274 >> 3040 >> >> Is there any solution to this problem besides unload and load the whole >> database? >> Bacause i thinkg it cannot be possible to alter fragment for tablespace >> tablespace. >> >> Thank you ind advance for your help. >> >> best regards >> Stanislav Ondac >> >> >> > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > --001636283616479b1c0494b2e24d > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --00163628361695bc7d0494b2ecf1

↪ replying to Art Kagel

STANISLAV — Wed, 10 Nov 2010 13:55:22 — source: IIUG Forums & Mailing Lists

I'm little bit confused now. How can i use alter fragment, if it is not regular table, but tablespace tablespace? Offset 414965 points to : gdpdbs:'informix'.TBLSpace 414952 50 Can you please explain it more detailed? or show the concrete sql statement? Thank you Stanislav ondac

↪ replying to STANISLAV

STANISLAV — Wed, 10 Nov 2010 14:53:32 — source: IIUG Forums & Mailing Lists

Problem solved....I bring to my mind how the things works and everythings is OK now :) So i take back my last foolish question. Thank you for your help best regards Stanislav Ondac

Glossary

chunk