Review the following information when using a DB2® database.
Note: Commands listed in this topic are only examples. Consult your
product documentation for details.
Note: 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.
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 all the above succeed.
To see if it is set run the command:
db2set DB2_OPTPROFILE