Issues after upgrade
After upgrading from IDS 7.31 to 11.50, oncheck -pe/-ce reported "ERROR: Missing pages 480063 through 528062" in rootdbs chunk 1, though the instance ran fine. Replies explained this is a gap in the chunk's extent map: space the server has lost track of (not in any extent nor on the free list), likely from an old orphaned table/index; 7.31's oncheck only looked for overlaps, 11.50 also detects gaps, and IBM support could clean it up. A separate oncheck -cc complaint (sysusers nextsize 1500 != tblspace.nxtsize 8) was blamed on damaged catalog pages, with dbexport/dbimport suggested; the poster fixed it simply with "alter table sysusers modify next size 3000". No fix for the missing pages themselves is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
I have error messages after the upgrade from 7.31 to 11.5
In 7.31, the output of oncheck -pe was:
...
LOGICAL LOG Pages - Log 52 456063
8000
LOGICAL LOG Pages - Log 53 464063
8000
LOGICAL LOG Pages - Log 54 472063
8000
DATABASE TBLSPACE 528063
4
FREE 528067
232
...
However, in 11.50, the output of oncheck -pe is:
...
LOGICAL LOG: Log file 52
456063 8000
LOGICAL LOG: Log file 53
464063 8000
LOGICAL LOG: Log file 54
472063 8000
ERROR: Missing pages 480063 through 528062 inclusive
sysmaster:'informix'.sysdatabases
528063 4
xnear:'xnear'.rol
528067 117
FREE
528184 115
...
The instance is working fine.
What it means the error "missing pages" ?
Please, provide me any clues according your experience.
Thanks in advance
Roger Vilca
Hello Roger.
I would suggest you to run an onmode -ce, and check its output first.
Then, if nothing strange appears (no errors) I think you could rebuild
your sysmaster database,
since you didn´t specify your actual release (11.50 had some sysmaster
upgrades failures on some specific releases) ok?
Hope this helps.
Regards.
Em 15/09/2011 12:17, Roger escreveu:
> Hi,
> I have error messages after the upgrade from 7.31 to 11.5
>
> In 7.31, the output of oncheck -pe was:
>
> ...
> LOGICAL LOG Pages - Log 52 456063
> 8000
> LOGICAL LOG Pages - Log 53 464063
> 8000
> LOGICAL LOG Pages - Log 54 472063
> 8000
> DATABASE TBLSPACE 528063
> 4
> FREE 528067
> 232
> ...
>
> However, in 11.50, the output of oncheck -pe is:
>
> ...
> LOGICAL LOG: Log file 52
> 456063 8000
> LOGICAL LOG: Log file 53
> 464063 8000
> LOGICAL LOG: Log file 54
> 472063 8000
> ERROR: Missing pages 480063 through 528062 inclusive
> sysmaster:'informix'.sysdatabases
> 528063 4
> xnear:'xnear'.rol
> 528067 117
> FREE
> 528184 115
> ...
>
> The instance is working fine.
>
> What it means the error "missing pages" ?
>
> Please, provide me any clues according your experience.
>
> Thanks in advance
> Roger Vilca
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
--
Alexandre Marini
Tecnologia da Informação - DBA
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
<Cert-Info-Mgmt_color.jpg>
IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
V11.70
IBM Information Management Informix Technical Professional v3
On Sep 15, 11:17 am, Roger <roger_vi...@yahoo.es> wrote:
> Hi,
> I have error messages after the upgrade from 7.31 to 11.5
>
> In 7.31, the output of oncheck -pe was:
>
> ...
> LOGICAL LOG Pages - Log 52 456063
> 8000
> LOGICAL LOG Pages - Log 53 464063
> 8000
> LOGICAL LOG Pages - Log 54 472063
> 8000
> DATABASE TBLSPACE 528063
> 4
> FREE 528067
> 232
> ...
>
> However, in 11.50, the output of oncheck -pe is:
>
> ...
> LOGICAL LOG: Log file 52
> 456063 8000
> LOGICAL LOG: Log file 53
> 464063 8000
> LOGICAL LOG: Log file 54
> 472063 8000
> ERROR: Missing pages 480063 through 528062 inclusive
> sysmaster:'informix'.sysdatabases
> 528063 4
> xnear:'xnear'.rol
> 528067 117
> FREE
> 528184 115
> ...
>
> The instance is working fine.
>
> What it means the error "missing pages" ?
>
> Please, provide me any clues according your experience.
>
> Thanks in advance
> Roger Vilca
It means you are missing pages. The oncheck -pe found a gap in
pages. So between logical log file 54 which ends at 472063+8000
(which would be 480063) and before the extent at 528063, the oncheck
didn't find a table extent using those pages and they are not included
in the chunk free list page (which would show them as FREE). So you
have wasted space, that the server has lost track of and can't be
freed/reused for anything. Have you had tech support dial-ins before
or had problems in the past where I table wasn't dropped (an easy way
to run into this issue would be to manually delete references to a
table/index from a databases system catalogs, which removes the
references but doesn't actually clean up any of the space for that
table/index). So the older 7.31 oncheck -pe just was concerned with
extent overlap, but the newer 11.50 oncheck now is able to check for
gaps, which it's found on your system. It is something that tech
support could likely "clean up/fix" via a dial in, but at this point
it seems like it's been that way awhile so it would be hard to say how
it would have happened.
Jacques Renaut
IBM Informix Advanced Support
APD Team
On Sep 15, 11:31 am, jrenaut <jpren...@yahoo.com> wrote:
> On Sep 15, 11:17 am, Roger <roger_vi...@yahoo.es> wrote:
>
>
>
> > Hi,
> > I have error messages after the upgrade from 7.31 to 11.5
>
> > In 7.31, the output of oncheck -pe was:
>
> > ...
> > LOGICAL LOG Pages - Log 52 456063
> > 8000
> > LOGICAL LOG Pages - Log 53 464063
> > 8000
> > LOGICAL LOG Pages - Log 54 472063
> > 8000
> > DATABASE TBLSPACE 528063
> > 4
> > FREE 528067
> > 232
> > ...
>
> > However, in 11.50, the output of oncheck -pe is:
>
> > ...
> > LOGICAL LOG: Log file 52
> > 456063 8000
> > LOGICAL LOG: Log file 53
> > 464063 8000
> > LOGICAL LOG: Log file 54
> > 472063 8000
> > ERROR: Missing pages 480063 through 528062 inclusive
> > sysmaster:'informix'.sysdatabases
> > 528063 4
> > xnear:'xnear'.rol
> > 528067 117
> > FREE
> > 528184 115
> > ...
>
> > The instance is working fine.
>
> > What it means the error "missing pages" ?
>
> > Please, provide me any clues according your experience.
>
> > Thanks in advance
> > Roger Vilca
>
> It means you are missing pages. The oncheck -pe found a gap in
> pages. So between logical log file 54 which ends at 472063+8000
> (which would be 480063) and before the extent at 528063, the oncheck
> didn't find a table extent using those pages and they are not included
> in the chunk free list page (which would show them as FREE). So you
> have wasted space, that the server has lost track of and can't be
> freed/reused for anything. Have you had tech support dial-ins before
> or had problems in the past where I table wasn't dropped (an easy way
> to run into this issue would be to manually delete references to a
> table/index from a databases system catalogs, which removes the
> references but doesn't actually clean up any of the space for that
> table/index). So the older 7.31 oncheck -pe just was concerned with
> extent overlap, but the newer 11.50 oncheck now is able to check for
> gaps, which it's found on your system. It is something that tech
> support could likely "clean up/fix" via a dial in, but at this point
> it seems like it's been that way awhile so it would be hard to say how
> it would have happened.
>
> Jacques Renaut
> IBM Informix Advanced Support
> APD Team
Thank you Alexandre, thank you Jacques
When I run oncheck -ce, this is the output:
Validating extents for Space 'rootdbs' ...
Chunk Pathname Size
Used Free
1 /dev/informix/synergia/chunk1 974336
715064 259272
ERROR: Missing pages 480063 through 528062 inclusive
2 /dev/informix/synergia/chunk2 974336
888980 85356
I've upgraded from 7.31.FD3W1 to 11.50.FC8
Is it dangerous rebuild the sysmaster ?
Roger Vilca
Of course it would be better for you, if you´re without any users
(except normal informix sessions, of course)....
I´ve already ran it right after an engine bouncing, without any troubles.
Check the link:
http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm.adref.doc%2Fids_adr_0201.htm
But it would be nice if you ask for support assistance first, to check
if that´s a recomended fix for your troubles.
Regards.
Em 15/09/2011 13:26, Roger escreveu:
> On Sep 15, 11:31 am, jrenaut<jpren...@yahoo.com> wrote:
>> On Sep 15, 11:17 am, Roger<roger_vi...@yahoo.es> wrote:
>>
>>
>>
>>> Hi,
>>> I have error messages after the upgrade from 7.31 to 11.5
>>> In 7.31, the output of oncheck -pe was:
>>> ...
>>> LOGICAL LOG Pages - Log 52 456063
>>> 8000
>>> LOGICAL LOG Pages - Log 53 464063
>>> 8000
>>> LOGICAL LOG Pages - Log 54 472063
>>> 8000
>>> DATABASE TBLSPACE 528063
>>> 4
>>> FREE 528067
>>> 232
>>> ...
>>> However, in 11.50, the output of oncheck -pe is:
>>> ...
>>> LOGICAL LOG: Log file 52
>>> 456063 8000
>>> LOGICAL LOG: Log file 53
>>> 464063 8000
>>> LOGICAL LOG: Log file 54
>>> 472063 8000
>>> ERROR: Missing pages 480063 through 528062 inclusive
>>> sysmaster:'informix'.sysdatabases
>>> 528063 4
>>> xnear:'xnear'.rol
>>> 528067 117
>>> FREE
>>> 528184 115
>>> ...
>>> The instance is working fine.
>>> What it means the error "missing pages" ?
>>> Please, provide me any clues according your experience.
>>> Thanks in advance
>>> Roger Vilca
>> It means you are missing pages. The oncheck -pe found a gap in
>> pages. So between logical log file 54 which ends at 472063+8000
>> (which would be 480063) and before the extent at 528063, the oncheck
>> didn't find a table extent using those pages and they are not included
>> in the chunk free list page (which would show them as FREE). So you
>> have wasted space, that the server has lost track of and can't be
>> freed/reused for anything. Have you had tech support dial-ins before
>> or had problems in the past where I table wasn't dropped (an easy way
>> to run into this issue would be to manually delete references to a
>> table/index from a databases system catalogs, which removes the
>> references but doesn't actually clean up any of the space for that
>> table/index). So the older 7.31 oncheck -pe just was concerned with
>> extent overlap, but the newer 11.50 oncheck now is able to check for
>> gaps, which it's found on your system. It is something that tech
>> support could likely "clean up/fix" via a dial in, but at this point
>> it seems like it's been that way awhile so it would be hard to say how
>> it would have happened.
>>
>> Jacques Renaut
>> IBM Informix Advanced Support
>> APD Team
> Thank you Alexandre, thank you Jacques
>
> When I run oncheck -ce, this is the output:
>
> Validating extents for Space 'rootdbs' ...
>
> Chunk Pathname Size
> Used Free
> 1 /dev/informix/synergia/chunk1 974336
> 715064 259272
> ERROR: Missing pages 480063 through 528062 inclusive
> 2 /dev/informix/synergia/chunk2 974336
> 888980 85356
>
> I've upgraded from 7.31.FD3W1 to 11.50.FC8
> Is it dangerous rebuild the sysmaster ?
>
> Roger Vilca
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
--
Alexandre Marini
Tecnologia da Informação - DBA
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
<Cert-Info-Mgmt_color.jpg>
IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
V11.70
IBM Information Management Informix Technical Professional v3
On Sep 15, 12:37 pm, Alexandre Marini <amar...@fazenda.ms.gov.br>
wrote:
> Of course it would be better for you, if you´re without any users
> (except normal informix sessions, of course)....
> I´ve already ran it right after an engine bouncing, without any troubles.
>
> Check the link:http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic...
>
> But it would be nice if you ask for support assistance first, to check
> if that´s a recomended fix for your troubles.
>
> Regards.
> Em 15/09/2011 13:26, Roger escreveu:
>
>
>
> > On Sep 15, 11:31 am, jrenaut<jpren...@yahoo.com> wrote:
> >> On Sep 15, 11:17 am, Roger<roger_vi...@yahoo.es> wrote:
>
> >>> Hi,
> >>> I have error messages after the upgrade from 7.31 to 11.5
> >>> In 7.31, the output of oncheck -pe was:
> >>> ...
> >>> LOGICAL LOG Pages - Log 52 456063
> >>> 8000
> >>> LOGICAL LOG Pages - Log 53 464063
> >>> 8000
> >>> LOGICAL LOG Pages - Log 54 472063
> >>> 8000
> >>> DATABASE TBLSPACE 528063
> >>> 4
> >>> FREE 528067
> >>> 232
> >>> ...
> >>> However, in 11.50, the output of oncheck -pe is:
> >>> ...
> >>> LOGICAL LOG: Log file 52
> >>> 456063 8000
> >>> LOGICAL LOG: Log file 53
> >>> 464063 8000
> >>> LOGICAL LOG: Log file 54
> >>> 472063 8000
> >>> ERROR: Missing pages 480063 through 528062 inclusive
> >>> sysmaster:'informix'.sysdatabases
> >>> 528063 4
> >>> xnear:'xnear'.rol
> >>> 528067 117
> >>> FREE
> >>> 528184 115
> >>> ...
> >>> The instance is working fine.
> >>> What it means the error "missing pages" ?
> >>> Please, provide me any clues according your experience.
> >>> Thanks in advance
> >>> Roger Vilca
> >> It means you are missing pages. The oncheck -pe found a gap in
> >> pages. So between logical log file 54 which ends at 472063+8000
> >> (which would be 480063) and before the extent at 528063, the oncheck
> >> didn't find a table extent using those pages and they are not included
> >> in the chunk free list page (which would show them as FREE). So you
> >> have wasted space, that the server has lost track of and can't be
> >> freed/reused for anything. Have you had tech support dial-ins before
> >> or had problems in the past where I table wasn't dropped (an easy way
> >> to run into this issue would be to manually delete references to a
> >> table/index from a databases system catalogs, which removes the
> >> references but doesn't actually clean up any of the space for that
> >> table/index). So the older 7.31 oncheck -pe just was concerned with
> >> extent overlap, but the newer 11.50 oncheck now is able to check for
> >> gaps, which it's found on your system. It is something that tech
> >> support could likely "clean up/fix" via a dial in, but at this point
> >> it seems like it's been that way awhile so it would be hard to say how
> >> it would have happened.
>
> >> Jacques Renaut
> >> IBM Informix Advanced Support
> >> APD Team
> > Thank you Alexandre, thank you Jacques
>
> > When I run oncheck -ce, this is the output:
>
> > Validating extents for Space 'rootdbs' ...
>
> > Chunk Pathname Size
> > Used Free
> > 1 /dev/informix/synergia/chunk1 974336
> > 715064 259272
> > ERROR: Missing pages 480063 through 528062 inclusive
> > 2 /dev/informix/synergia/chunk2 974336
> > 888980 85356
>
> > I've upgraded from 7.31.FD3W1 to 11.50.FC8
> > Is it dangerous rebuild the sysmaster ?
>
> > Roger Vilca
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
>
> --
>
> Alexandre Marini
>
> Tecnologia da Informação - DBA
>
> SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
>
> <Cert-Info-Mgmt_color.jpg>
>
> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
> V11.70
>
> IBM Information Management Informix Technical Professional v3
Thanks,
When I run oncheck -cc <database>, it shows this error:
ERROR: informix.sysusers nextsize 1500 != tblspace.nxtsize 8
select from systables shows nextsize = 3000, but oncheck -pt
<database>.sysusers shows Next extent size = 8
Please, any help
Best regards,
Roger Vilca
The 8 is coming from the table's actual header page or partition page. You
can see that page by looking up the sysmaster:sysptnhdr record for the
table's partnum. The 1500 is the 3000 from systables divided by the
pagesize (2K). Systables stores KB, but the system reports in pages.
Your system catalog pages for this database are damaged, Best to dbexport
the database, rename it, reload it with dbimport, then if everything checks
out, you can drop the original copy.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Sep 15, 2011 at 5:46 PM, Roger <roger_vilca@yahoo.es> wrote:
> On Sep 15, 12:37 pm, Alexandre Marini <amar...@fazenda.ms.gov.br>
> wrote:
> > Of course it would be better for you, if you´re without any users
> > (except normal informix sessions, of course)....
> > I´ve already ran it right after an engine bouncing, without any troubles.
> >
> > Check the link:
> http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic...
> >
> > But it would be nice if you ask for support assistance first, to check
> > if that´s a recomended fix for your troubles.
> >
> > Regards.
> > Em 15/09/2011 13:26, Roger escreveu:
> >
> >
> >
> > > On Sep 15, 11:31 am, jrenaut<jpren...@yahoo.com> wrote:
> > >> On Sep 15, 11:17 am, Roger<roger_vi...@yahoo.es> wrote:
> >
> > >>> Hi,
> > >>> I have error messages after the upgrade from 7.31 to 11.5
> > >>> In 7.31, the output of oncheck -pe was:
> > >>> ...
> > >>> LOGICAL LOG Pages - Log 52 456063
> > >>> 8000
> > >>> LOGICAL LOG Pages - Log 53 464063
> > >>> 8000
> > >>> LOGICAL LOG Pages - Log 54 472063
> > >>> 8000
> > >>> DATABASE TBLSPACE 528063
> > >>> 4
> > >>> FREE 528067
> > >>> 232
> > >>> ...
> > >>> However, in 11.50, the output of oncheck -pe is:
> > >>> ...
> > >>> LOGICAL LOG: Log file 52
> > >>> 456063 8000
> > >>> LOGICAL LOG: Log file 53
> > >>> 464063 8000
> > >>> LOGICAL LOG: Log file 54
> > >>> 472063 8000
> > >>> ERROR: Missing pages 480063 through 528062 inclusive
> > >>> sysmaster:'informix'.sysdatabases
> > >>> 528063 4
> > >>> xnear:'xnear'.rol
> > >>> 528067 117
> > >>> FREE
> > >>> 528184 115
> > >>> ...
> > >>> The instance is working fine.
> > >>> What it means the error "missing pages" ?
> > >>> Please, provide me any clues according your experience.
> > >>> Thanks in advance
> > >>> Roger Vilca
> > >> It means you are missing pages. The oncheck -pe found a gap in
> > >> pages. So between logical log file 54 which ends at 472063+8000
> > >> (which would be 480063) and before the extent at 528063, the oncheck
> > >> didn't find a table extent using those pages and they are not included
> > >> in the chunk free list page (which would show them as FREE). So you
> > >> have wasted space, that the server has lost track of and can't be
> > >> freed/reused for anything. Have you had tech support dial-ins before
> > >> or had problems in the past where I table wasn't dropped (an easy way
> > >> to run into this issue would be to manually delete references to a
> > >> table/index from a databases system catalogs, which removes the
> > >> references but doesn't actually clean up any of the space for that
> > >> table/index). So the older 7.31 oncheck -pe just was concerned with
> > >> extent overlap, but the newer 11.50 oncheck now is able to check for
> > >> gaps, which it's found on your system. It is something that tech
> > >> support could likely "clean up/fix" via a dial in, but at this point
> > >> it seems like it's been that way awhile so it would be hard to say how
> > >> it would have happened.
> >
> > >> Jacques Renaut
> > >> IBM Informix Advanced Support
> > >> APD Team
> > > Thank you Alexandre, thank you Jacques
> >
> > > When I run oncheck -ce, this is the output:
> >
> > > Validating extents for Space 'rootdbs' ...
> >
> > > Chunk Pathname Size
> > > Used Free
> > > 1 /dev/informix/synergia/chunk1 974336
> > > 715064 259272
> > > ERROR: Missing pages 480063 through 528062 inclusive
> > > 2 /dev/informix/synergia/chunk2 974336
> > > 888980 85356
> >
> > > I've upgraded from 7.31.FD3W1 to 11.50.FC8
> > > Is it dangerous rebuild the sysmaster ?
> >
> > > Roger Vilca
> > > _______________________________________________
> > > Informix-list mailing list
> > > Informix-l...@iiug.org
> > >http://www.iiug.org/mailman/listinfo/informix-list
> >
> > --
> >
> > Alexandre Marini
> >
> > Tecnologia da Informação - DBA
> >
> > SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
> >
> > <Cert-Info-Mgmt_color.jpg>
> >
> > IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
> > V11.70
> >
> > IBM Information Management Informix Technical Professional v3
>
> Thanks,
> When I run oncheck -cc <database>, it shows this error:
>
> ERROR: informix.sysusers nextsize 1500 != tblspace.nxtsize 8
> select from systables shows nextsize = 3000, but oncheck -pt
> <database>.sysusers shows Next extent size = 8
>
> Please, any help
>
> Best regards,
> Roger Vilca
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
On Sep 15, 5:15 pm, Art Kagel <art.ka...@gmail.com> wrote:
> The 8 is coming from the table's actual header page or partition page. You
> can see that page by looking up the sysmaster:sysptnhdr record for the
> table's partnum. The 1500 is the 3000 from systables divided by the
> pagesize (2K). Systables stores KB, but the system reports in pages.
>
> Your system catalog pages for this database are damaged, Best to dbexport
> the database, rename it, reload it with dbimport, then if everything checks
> out, you can drop the original copy.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog:http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Thu, Sep 15, 2011 at 5:46 PM, Roger <roger_vi...@yahoo.es> wrote:
> > On Sep 15, 12:37 pm, Alexandre Marini <amar...@fazenda.ms.gov.br>
> > wrote:
> > > Of course it would be better for you, if you´re without any users
> > > (except normal informix sessions, of course)....
> > > I´ve already ran it right after an engine bouncing, without any troubles.
>
> > > Check the link:
> >http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic...
>
> > > But it would be nice if you ask for support assistance first, to check
> > > if that´s a recomended fix for your troubles.
>
> > > Regards.
> > > Em 15/09/2011 13:26, Roger escreveu:
>
> > > > On Sep 15, 11:31 am, jrenaut<jpren...@yahoo.com> wrote:
> > > >> On Sep 15, 11:17 am, Roger<roger_vi...@yahoo.es> wrote:
>
> > > >>> Hi,
> > > >>> I have error messages after the upgrade from 7.31 to 11.5
> > > >>> In 7.31, the output of oncheck -pe was:
> > > >>> ...
> > > >>> LOGICAL LOG Pages - Log 52 456063
> > > >>> 8000
> > > >>> LOGICAL LOG Pages - Log 53 464063
> > > >>> 8000
> > > >>> LOGICAL LOG Pages - Log 54 472063
> > > >>> 8000
> > > >>> DATABASE TBLSPACE 528063
> > > >>> 4
> > > >>> FREE 528067
> > > >>> 232
> > > >>> ...
> > > >>> However, in 11.50, the output of oncheck -pe is:
> > > >>> ...
> > > >>> LOGICAL LOG: Log file 52
> > > >>> 456063 8000
> > > >>> LOGICAL LOG: Log file 53
> > > >>> 464063 8000
> > > >>> LOGICAL LOG: Log file 54
> > > >>> 472063 8000
> > > >>> ERROR: Missing pages 480063 through 528062 inclusive
> > > >>> sysmaster:'informix'.sysdatabases
> > > >>> 528063 4
> > > >>> xnear:'xnear'.rol
> > > >>> 528067 117
> > > >>> FREE
> > > >>> 528184 115
> > > >>> ...
> > > >>> The instance is working fine.
> > > >>> What it means the error "missing pages" ?
> > > >>> Please, provide me any clues according your experience.
> > > >>> Thanks in advance
> > > >>> Roger Vilca
> > > >> It means you are missing pages. The oncheck -pe found a gap in
> > > >> pages. So between logical log file 54 which ends at 472063+8000
> > > >> (which would be 480063) and before the extent at 528063, the oncheck
> > > >> didn't find a table extent using those pages and they are not included
> > > >> in the chunk free list page (which would show them as FREE). So you
> > > >> have wasted space, that the server has lost track of and can't be
> > > >> freed/reused for anything. Have you had tech support dial-ins before
> > > >> or had problems in the past where I table wasn't dropped (an easy way
> > > >> to run into this issue would be to manually delete references to a
> > > >> table/index from a databases system catalogs, which removes the
> > > >> references but doesn't actually clean up any of the space for that
> > > >> table/index). So the older 7.31 oncheck -pe just was concerned with
> > > >> extent overlap, but the newer 11.50 oncheck now is able to check for
> > > >> gaps, which it's found on your system. It is something that tech
> > > >> support could likely "clean up/fix" via a dial in, but at this point
> > > >> it seems like it's been that way awhile so it would be hard to say how
> > > >> it would have happened.
>
> > > >> Jacques Renaut
> > > >> IBM Informix Advanced Support
> > > >> APD Team
> > > > Thank you Alexandre, thank you Jacques
>
> > > > When I run oncheck -ce, this is the output:
>
> > > > Validating extents for Space 'rootdbs' ...
>
> > > > Chunk Pathname Size
> > > > Used Free
> > > > 1 /dev/informix/synergia/chunk1 974336
> > > > 715064 259272
> > > > ERROR: Missing pages 480063 through 528062 inclusive
> > > > 2 /dev/informix/synergia/chunk2 974336
> > > > 888980 85356
>
> > > > I've upgraded from 7.31.FD3W1 to 11.50.FC8
> > > > Is it dangerous rebuild the sysmaster ?
>
> > > > Roger Vilca
> > > > _______________________________________________
> > > > Informix-list mailing list
> > > > Informix-l...@iiug.org
> > > >http://www.iiug.org/mailman/listinfo/informix-list
>
> > > --
>
> > > Alexandre Marini
>
> > > Tecnologia da Informação - DBA
>
> > > SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
>
> > > <Cert-Info-Mgmt_color.jpg>
>
> > > IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
> > > V11.70
>
> > > IBM Information Management Informix Technical Professional v3
>
> > Thanks,
> > When I run oncheck -cc <database>, it shows this error:
>
> > ERROR: informix.sysusers nextsize 1500 != tblspace.nxtsize 8
> > select from systables shows nextsize = 3000, but oncheck -pt
> > <database>.sysusers shows Next extent size = 8
>
> > Please, any help
>
> > Best regards,
> > Roger Vilca
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
Hi,
I run:
alter table sysusers modify next size 3000;and the error is gone
Thanks,
Roger Vilca