Enhanced onstat -g Output Displays

For the following onstat -g commands, XPS 8.51 displays additional information that earlier versions did not show in output from the same command-line options:

• The UPDATE STATISTICS status of temporary tables:

  onstat -g ses session_id

• The original format of SQL statements, including linefeeds:

  onstat -g sql session_id
  onstat -g stm session_id

• The overflow to disk of group iterator threads:

  onstat -g xmp [query_id]

• The name of a table for which a query declares an alias:

  onstat -g xqp [query_id]

These onstat -g display enhancements are individually described in sections that follow.