Oninit cdi / Archive
Talk to an expert →

oncheck -cc

Posted in 2000

Topics: Storage & Space Management

gorgos@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Hello all I'm getting the following message when running oncheck -cc: System catalogues warning:No sysdepend record for TBLspace root.stockm Ignore this warning if view is on table(s) external to current database. What causes this record ? Also, when running oncheck -ce, I'm getting extents overlap errors. Why might this be and how serious is this ? Thanks all Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to gorgos@my-deja.com
Norman Erickson Lugtu — — source: Informix-list mailing list archive (1991-1998)

You do an oncheck -ce before you do a level-0 backup to ensure that there is no problem with your database system. On the Informix documentation, if you encounter extent overlap error, do not do a level- 0 backup and do a restore. In article <8tucga$5l0$1@nnrp1.deja.com>, gorgos@my-deja.com wrote: > Hello all > I'm getting the following message when running oncheck -cc: > > System catalogues warning:No sysdepend record for TBLspace root.stockm > Ignore this warning if view is on table(s) external to current database. > > What causes this record ? > > Also, when running oncheck -ce, I'm getting extents overlap errors. > Why might this be and how serious is this ? > > Thanks all > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to gorgos@my-deja.com
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

gorgos@my-deja.com wrote: > > Hello all > I'm getting the following message when running oncheck -cc: > > System catalogues warning:No sysdepend record for TBLspace root.stockm > Ignore this warning if view is on table(s) external to current database. > > What causes this record ? It just means that no tables refer to this one in any constraints. Is OK, informative only. One day it may alert you to a table you thought was referenced in FOREIGN key constraints but is not indicating that the constraints have been dropped and not replaced. > Also, when running oncheck -ce, I'm getting extents overlap errors. > Why might this be and how serious is this ? Trouble. Restore and reload logical logs. Art S. Kagel > Thanks all > > Sent via Deja.com http://www.deja.com/ > Before you buy.