Monitoring fragment use

Once you determine a fragmentation strategy, you can monitor fragmentation.

You can monitor fragmentation in the following ways:
  • Run individual onstat utility commands to capture information about specific aspects of a running query.
  • Run a SET EXPLAIN statement before you run a query to write the query plan to an output file.

Copyright© 2020 HCL Technologies Limited