Review the following information when using a DB2® database.
Notes: - Commands listed in this topic are only examples. Consult your
product documentation for details.
- A 16 KB page size is required when creating a database in DB2 for Rational® Quality Manager.
An 8 KB page size is required when creating a database in DB2 for Rational Team Concert™.
- Information in this topic is not applicable
for DB2 for i, which is included with the IBM® i operating
system.
Review the DB2 documentation
to verify that your system meets the requirements and is configured
correctly.
To take advantage of state-selection fetching optimization, which
can improve performance on large databases, DB2 users must set DB2_OPTPROFILE. Run the following
commands to set DB2_OPTPROFILE.
db2set DB2_OPTPROFILE=YES
db2stop
db2start
Note: After the command runs, stop and restart
the database. A later step in the installation process requires you
to stop and start the database. If you are just beginning the installation,
you can restart the database then.
Make sure the DB2 set, stop,
and start commands succeed. To see if DB2_OPTPROFILE is set, run the
command:
db2set DB2_OPTPROFILE