onstat -g ses session_id

This command displays information about the specified session, or a single-line summary of each session, if you specify no session_id. A new feature of XPS 8.51 adds a new UpdStat display field to the section of onstat -g ses output that describes temporary tables:

     User-created Temp tables :
       ddtabp          partnum  tabname   rowsize  ref   lock  use   UpdStat
       700000034549450 70006    zz2       133      0     0     0     Y
       700000034fdd098 40007    zz1       133      0     0     0     Y
       700000034546450 1025a    zz        133      0     0     0     Y
       7000000344dcfe8 ffff     test2      43      0     0     0     N
       7000000344ce900 ffff     test1      43      0     0     0     Y
       700000034546850 ffff     test       43      0     0     0     N

Here Y in the UpdStat column means that the UPDATE STATISTICS statement has updated the distribution statistics on the temporary table in the system catalog, and N indicates that the table statistics have not been updated.

This feature is helpful in applications that use temporary tables, especially in sessions where the SET ENVIRONMENT IMPLICIT_PDQ ON statement has enabled implicit PDQ. The database server does not apply implicit PDQ calculations to temporary tables on which UPDATE STATISTICS has not been run, so the enhanced display can show which temporary tables need their statistics updated.