IBM 000-8697 User Manual

Page of 702
Installation and Initial Configuration
1-9
Upgrade an Earlier Version of OnLine
Run tbcheck
Verify the integrity of the upgraded 5.x databases before you continue. To do
this, execute the following commands from the system prompt:
If you encounter any inconsistencies, refer to
.
Create a New Level-0 Archive
After OnLine 5.x is initialized, create a level-0 archive of the OnLine 5.x
system. When the archive is completed, take OnLine to online mode.
Databases are automatically upgraded to OnLine 5.x format when they are
opened for the first time. Part of the upgrading procedure for databases is the
creation of Version 5.x system catalog tables for each database. For further
information about the 5.x
SQL
system catalog, refer to the
IBM I
nformix
G
uide
to
SQL: R
eference.
tbcheck -ci dbname
Checks and verifies the integrity of the database
indexes.
tbcheck -cD dbname
Checks and verifies the integrity of database data.
tbcheck -cc dbname
Checks and verifies the integrity of the OnLine
5.x system catalog tables.
tbcheck -cr
Checks and verifies the integrity of the OnLine
5.x reserved pages.