Special DB2 instructions

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: An 8 KB page size is required when creating a database in DB2.

Review the DB2 documentation to verify 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

Feedback

Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug