FPEY0140I NOTE: <V1>.<V2> CONTAINS <V3> ACTIVE PAGES - CONSIDER A USABLE INDEX

Explanation

This message is produced if Db2 has chosen a table space scan for a table located in a table space larger than 10 active pages.
  • <V1> is the database name.
  • <V2> is the table space name.
  • <V3> is the number of active pages.

User response

If the access path should be index-based, create a usable index, otherwise no action is required.