Automatic table maintenance work? When? How often? For which tables?

These SQL queries will help to clarify questions of this kind.

--------------------------------------------------------------------------------
-- SQL-Statistics-Diag.sql - Statistics Collection Vorgänge
--------------------------------------------------------------------------------
--
-- Successfully completed autoReorg and autoRunst events:
SELECT DATE(TIMESTAMP), TIME(TIMESTAMP),
       CASE 
         WHEN INSTR(UPPER(FUNCTION),'REORG')>0 THEN 'REORG'
         WHEN INSTR(UPPER(FUNCTION),'RUNST')>0 THEN 'RUNSTATS'
         ELSE UPPER(FUNCTION)
       END AS FUNCTION,
       REPLACE(CASE
                 WHEN OBJNAME IS NULL
                      THEN REPLACE(SUBSTR(FULLREC,POSSTR(FULLREC,'completed successfully')+32),'"','')
                 ELSE OBJNAME_QUALIFIER||'.'||OBJNAME
               END, ' ','') AS OBJECT
       ,T.*
FROM   TABLE (SYSPROC.PD_GET_DIAG_HIST( 'ALL', 'E', '', CURRENT_TIMESTAMP - 2 DAYS, 
                                       NULL) ) AS T 
WHERE FULLREC LIKE '%completed successfully%'
AND   COMPONENT = 'Automatic Table Maintenance'
ORDER BY TIMESTAMP
;
-- Statistics Events:
SELECT
    PID ,
    TID ,
    SUBSTR(EVENTTYPE , 1 , 10) ,
    SUBSTR(OBJTYPE , 1 , 26)                  AS OBJTYPE ,
    SUBSTR(OBJNAME_QUALIFIER , 1 , 8)         AS OBJSCHEMA ,
    SUBSTR(OBJNAME , 1 , 18)                  AS OBJNAME ,
    SUBSTR(FIRST_EVENTQUALIFIER , 1 , 26)     AS EVENT1 ,
    SUBSTR(SECOND_EVENTQUALIFIERTYPE , 1 , 2) AS EVENT2_TYPE ,
    SUBSTR(SECOND_EVENTQUALIFIER , 1 , 20)       EVENT2 ,
    SUBSTR(THIRD_EVENTQUALIFIERTYPE , 1 , 6)     EVENT3_TYPE ,
    SUBSTR(THIRD_EVENTQUALIFIER , 1 , 15)        EVENT3 ,
    SUBSTR(EVENTSTATE , 1 , 20)               AS EVENTSTATE
FROM
    TABLE(SYSPROC.PD_GET_DIAG_HIST('OPTSTATS' , 'EX' , 'NONE' , 
				CURRENT_TIMESTAMP - 1 DAY , 
				CAST(NULL AS TIMESTAMP))) AS STATS
ORDER BY
    TIMESTAMP(VARCHAR(SUBSTR(FIRST_EVENTQUALIFIER , 1 , 26) , 26)) DESC
;
-- keywords: auto_stats statistics profile