Start of change

PGRNGSCR in macro DSN6SPRM

Determines whether to enable a function that is introduced by APAR PM81692.

This function allows page range screening on tables that are partitioned by TIMESTAMP columns so that the optimizer can improve the performance of queries that contain any of the following predicates:
  • TIMESTAMP < host variable or string constant
  • TIMESTAMP <= host variable or string constant
  • TIMESTAMP >= host variable or string constant
  • TIMESTAMP > host variable or string constant
  • TIMESTAMP BETWEEN host variable or string constant AND host variable or string constant

Valid values for this parameter are NO and YES.

A value of NO specifies that this function is disabled. This is the default value.

A value of YES specifies that this function is enabled. Do not use this setting unless you are advised to do so by IBM® Software Support.

This subsystem parameter is deprecated in DB2® 10.

In later releases, the function is always enabled.

End of change