 | |
#1
 
| |||
| |||
|
Issues after upgrade -
09-15-2011
, 11:17 AM
#2
| |||
| |||
|
|
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 (AT) iiug (DOT) 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
#3
| |||
| |||
|
|
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 |
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
#4
| |||
| |||
|
|
On Sep 15, 11:17*am, Roger <roger_vi... (AT) yahoo (DOT) 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 |
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
#5
| |||
| |||
|
|
On Sep 15, 11:31 am, jrenaut<jpren... (AT) yahoo (DOT) com> wrote: On Sep 15, 11:17 am, Roger<roger_vi... (AT) yahoo (DOT) 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 (AT) iiug (DOT) 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
#6
| |||
| |||
|
|
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/infoce...adr_020 1.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... (AT) yahoo (DOT) com> <jpren... (AT) yahoo (DOT) com> wrote: On Sep 15, 11:17 am, Roger <roger_vi... (AT) yahoo (DOT) es> <roger_vi... (AT) yahoo (DOT) 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 listInformix-list (AT) iiug (DOT) or...//www.iiug.org/mailman/listinfo/informix-list -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix http://Cert-Info-Mgmt_color.jpg>**** IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70**** IBM Information Management Informix Technical Professional v3**** ** ** _______________________________________________ Informix-list mailing list Informix-list (AT) iiug (DOT) org http://www.iiug.org/mailman/listinfo/informix-list |
#7
| |||
| |||
|
|
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/infoce...ndex.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... (AT) yahoo (DOT) com> *wrote: On Sep 15, 11:17 am, Roger<roger_vi... (AT) yahoo (DOT) 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... (AT) iiug (DOT) 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 |
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
#8
| |||
| |||
|
|
On Sep 15, 12:37 pm, Alexandre Marini <amar... (AT) fazenda (DOT) 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/infoce...ndex.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... (AT) yahoo (DOT) com> wrote: On Sep 15, 11:17 am, Roger<roger_vi... (AT) yahoo (DOT) 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... (AT) iiug (DOT) 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 (AT) iiug (DOT) org http://www.iiug.org/mailman/listinfo/informix-list |
#9
| |||
| |||
|
|
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, orby 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... (AT) yahoo (DOT) es> wrote: On Sep 15, 12:37 pm, Alexandre Marini <amar... (AT) fazenda (DOT) 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/infoce...ndex.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... (AT) yahoo (DOT) com> *wrote: On Sep 15, 11:17 am, Roger<roger_vi... (AT) yahoo (DOT) 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). *Soyou 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 sayhow 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... (AT) iiug (DOT) 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... (AT) iiug (DOT) org http://www.iiug.org/mailman/listinfo/informix-list |
I run:
alter table sysusers modify next size 3000;
and the error is gone
Thanks,
Roger Vilca
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.