Cause: The table name must be fully qualified. The format is authid.tablename where authid contains 1 to 8 characters and tablename contains 1 to 18 characters (bytes in MBCS environments).
The utility stops processing.
Action: Resubmit the command with the fully qualified table name, including the correct qualifier.
Cause: The table name must be fully qualified and in the format authid.name where authid contains 1 to 8 characters and name contains 1 to 18 characters (bytes in MBCS environments) and must be located at a valid application address.
The utility stops processing.
Action: Resubmit the command with the correct table name.
Cause: The address for the list is not valid, the number of entries in the list is less than the number of indexes specified, or the address for an index in the list is not valid.
The utility stops processing.
Action: Resubmit the command with a valid index list.
Cause: The statsopt parameter in the Run Statistics command must be one of the following:
The utility stops processing.
Action: Resubmit the command with a valid statsopt parameter.
Cause: The sharelev parameter in the RUN STATISTICS command must be R for reference or C for change.
The utility stops processing.
Action: Resubmit the command with a valid sharelev parameter.
Cause: The tname parameter specified a view rather than a table.
The utility stops processing.
Action: Resubmit the command with a valid tname parameter.
Cause: The table or index identified by "<name>" does not exist in the database, or the index identified by "<name>" is not defined on the specified table. The qualifier for the table or one of the indexes may be incorrect.
The utility stops processing.
Action: Resubmit the command with valid table names and indexes.
Cause: The Run Statistics utility command may not be run against a system table.
The utility stops processing.
Action: Resubmit the command with a valid table name.
Cause: The index name must be a fully qualified name. The format is authid.tablename where authid contains 1 to 8 characters and tablename contains 1 to 18 characters (bytes in MBCS environments).
The utility stops processing.
Action: Resubmit the command with a fully qualified name, including the correct qualifier.
Cause: The index name must be a fully qualified name. The format is authid.name where authid contains 1 to 8 characters and name contains 1 to 18 characters (bytes in MBCS environments).
The utility stops processing.
Action: Resubmit the command with a valid index.
Cause: An error occurred while the utility was gathering statistics.
The utility stops processing.
Action: Look at the message error number for more information. Make changes and resubmit the command.
Cause: The user attempted to run statistics on the specified table without the appropriate authorization (either the SYSADM or DBADM authority or the CONTROL privilege on the table). If the table specified in RUNSTATS is the root table of a table hierarchy, then the table name returned in the message may be a subtable of the specified root table.
The utility stops processing.
Action: Do not attempt to call the Run Statistics utility command without appropriate authorization.
Cause: The setting of the database configuration parameter stat_heap_sz is not big enough to collect non-uniform distribution statistics on the table.
Action: Update the database configuration parameter stat_heap_sz to the suggested value and try again.
Cause: The setting of the database configuration parameter stat_heap_sz is not big enough to collect non-uniform distribution statistics on the table. Only <n1> of <n2> rows could be processed.
Action: Update the database configuration parameter stat_heap_sz by 20 percent and try again.
Cause: Issuing RUNSTATS on the table only may result in a situation where the table level statistics are inconsistent with the already existing index level statistics. For example, if index level statistics are collected on a particular table and later a significant number of rows is deleted from this table, issuing RUNSTATS on the table only may end up with the table cardinality less than FIRSTKEYCARD which is an inconsistent state. Likewise, issuing RUNSTATS for indexes only may leave the already existing table level statistics in an inconsistent state. For example, if table level statistics are collected on a particular table and later a significant number of rows is deleted from this table, issuing RUNSTATS for the indexes only may end up with some columns having a COLCARD greater than the table cardinality.
Action: If you issued a RUNSTATS for indexes only issue a RUNSTATS on the table as well so that table level and index level statistics are consistent. Likewise, if you issued a RUNSTATS on the table only, issue a RUNSTATS for indexes as well.