how to correct system catalog tables error?

Posted in 2000

dominic soh — Wed, 17 May 2000 17:40:31 +0800 — source: Informix-list mailing list archive (1991-1998)

Hi, I run the command oncheck -cc database and found the following error: ERROR: syscolumns rowsize 14490 != informix.tpub rowsize 2798 How can I correct this error? Any help will be appreciated. Dominic

↪ replying to dominic soh

mars1972@my-deja.com — Wed, 17 May 2000 12:17:46 GMT — source: Informix-list mailing list archive (1991-1998)

I would unload, drop, rebuild, and reload the table. In article <3922690F.58C9F7D9@netcentre.com.sg>, dominic soh <dominic@netcentre.com.sg> wrote: > Hi, > > I run the command oncheck -cc database and found the following error: > > ERROR: syscolumns rowsize 14490 != informix.tpub rowsize 2798 > > How can I correct this error? Any help will be appreciated. > > Dominic > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to mars1972@my-deja.com

Carlson@WHSmith — Wed, 17 May 2000 14:59:31 -0400 — source: Informix-list mailing list archive (1991-1998)

mars1972@my-deja.com wrote: > > I would unload, drop, rebuild, and reload the table. > To a system table? Ouch!! > In article <3922690F.58C9F7D9@netcentre.com.sg>, > dominic soh <dominic@netcentre.com.sg> wrote: > > Hi, > > > > I run the command oncheck -cc database and found the following > error: > > > > ERROR: syscolumns rowsize 14490 != informix.tpub rowsize 2798 > > > > How can I correct this error? Any help will be appreciated. > > > > Dominic > > > > > > -- > # unrm / > ksh: unrm: not found > # man cpio > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

↪ replying to Carlson@WHSmith

mars1972@my-deja.com — Wed, 17 May 2000 20:16:53 GMT — source: Informix-list mailing list archive (1991-1998)

No, not the system table, the table that's reported in the error. That should recreate the syscolumns record correctly. informix.tpub. I hadn't heard of that table before, so I assumed it wasn't a system table. Is it a system table? In article <3922EC13.5D2D046B@bellsouth.net>, "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: > mars1972@my-deja.com wrote: > > > > I would unload, drop, rebuild, and reload the table. > > > > To a system table? Ouch!! > > > In article <3922690F.58C9F7D9@netcentre.com.sg>, > > dominic soh <dominic@netcentre.com.sg> wrote: > > > Hi, > > > > > > I run the command oncheck -cc database and found the following > > error: > > > > > > ERROR: syscolumns rowsize 14490 != informix.tpub rowsize 2798 > > > > > > How can I correct this error? Any help will be appreciated. > > > > > > Dominic > > > > > > > > > > -- > > # unrm / > > ksh: unrm: not found > > # man cpio > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > -- > John Carlson > Informix DBA > WHSmith USA > > #include std_disclaimer.h /* These are my opinions, not my company's > opinion */ > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to mars1972@my-deja.com

Carlson@WHSmith — Wed, 17 May 2000 16:48:44 -0400 — source: Informix-list mailing list archive (1991-1998)

mars1972@my-deja.com wrote: > > No, not the system table, the table that's reported in the error. That > should recreate the syscolumns record correctly. informix.tpub. I > hadn't heard of that table before, so I assumed it wasn't a system > table. Is it a system table? > No it isn't. I saw the 'syscolumns' and didn't finish reading the entire line . . . Oops! -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

↪ replying to mars1972@my-deja.com

Marat — Fri, 19 May 2000 18:25:50 +0400 — source: Informix-list mailing list archive (1991-1998)

mars1972@my-deja.com wrote: > No, not the system table, the table that's reported in the error. That > should recreate the syscolumns record correctly. informix.tpub. I guess you're right. But first I would count rowsize manually to understand which value "is more like truth". > I > hadn't heard of that table before, so I assumed it wasn't a system > table. Is it a system table? > > In article <3922EC13.5D2D046B@bellsouth.net>, > "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: > > mars1972@my-deja.com wrote: > > > > > > I would unload, drop, rebuild, and reload the table. > > > > > > > To a system table? Ouch!! > > > > > In article <3922690F.58C9F7D9@netcentre.com.sg>, > > > dominic soh <dominic@netcentre.com.sg> wrote: > > > > Hi, > > > > > > > > I run the command oncheck -cc database and found the following > > > error: > > > > > > > > ERROR: syscolumns rowsize 14490 != informix.tpub rowsize 2798 > > > > > > > > How can I correct this error? Any help will be appreciated. > > > > > > > > Dominic > > > > > > > > > > > > > > -- > > > # unrm / > > > ksh: unrm: not found > > > # man cpio > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > > > > -- > > John Carlson > > Informix DBA > > WHSmith USA > > > > #include std_disclaimer.h /* These are my opinions, not my > company's > > opinion */ > > > > -- > # unrm / > ksh: unrm: not found > # man cpio > > Sent via Deja.com http://www.deja.com/ > Before you buy.