Manually create the database tables
About this task
If you did not choose
to create database tables during the Foundation installation, a database
administrator can create these tables manually now. The dbverify
utility
generates SQL scripts to manage database table creation and modification.
Depending on the task, you may apply all the dbverify-generated SQLs
or specific SQLs. For example, when adding a column to a table, you
need only to apply the relevant "Create Column" SQL.
When you
run an installation in upgrade mode, a new entity XML repository is
installed, but dbverify
is not run. A database matching
the old entity XML repository already exists. During the upgrade process,
the initupgrade
target compares the entity XML repositories
from the old and new runtimes and generates alter scripts for shard
migration. The alter scripts are applied to the database, which then
reflects the new installation and the customer changes from the old
runtime.
Sometimes, the alter scripts do not include all the
necessary database changes. In these cases, dbverify
is
used to make corrections to the database.
You can run dbverify
as
follows:
Procedure
Example
- EFrame_TextIndexDrops.sql
- EFrame_IndexDrops.sql
- EFrame_TableChanges.sql
- EFrame_IndexAdds.sql
- EFrame_TextIndexAdds.sql
- EFrame_Sequence.sql
- EFrame_TextIndexModify.sql
- EFrame_TextIndexUpdates.sql
- EFrame_TextIndexUpgrade.sql
- EFrame_Static.sql
- Connect to the database by entering:
db2 "connect to <SERVER> user <USER> using <PASSWORD>"
- Then for each file:
db2 -v -f <SQLFILE>
- Then enter:
db2 "connect reset"