If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL
What will happen?
A.
RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.
B.
RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.
C.
RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK
report will be generated.
D.
RUNSTATS will be executed on all system tables only if statistics have not been collected and aREORGCHK report will be generated.
ON TABLE
USER
Checks the tables that are owned by the run time authorization ID.
SYSTEM
Checks the system tables.
ALL
Checks all user and system tables.
table-name
Specifies the table to check. The fully qualified name or alias in the form: schema.table-name must be used. The schema is the user name under which the table was created. If the table specified is a system catalog table, the schema is SYSIBM. For typed tables, the specified table name must be the name of the hierarchy’s root table.
0
0