Reinstates a previously excluded object.
Syntax
REPLACE PROCEDURE TDSTATS.RemoveExcludedObject ( IN DatabaseName VARCHAR(128) CHARACTER SET UNICODE, IN TableName VARCHAR(128) CHARACTER SET UNICODE, OUT NumRemoved INTEGER ) ... ;
Syntax Elements
- DatabaseName
- Name of the database. DatabaseName allows you to specify the database to reinstate or the database containing a table to reinstate.
- TableName
- Name of the table within the specified DatabaseName. TableName allows you to specify a table within DatabaseName to be reinstated.
- NumRemoved
- Number of objects removed from the exclusion list.
Usage Notes
Reinstated objects and their statistics are considered by subsequent invocations of Automate, Analyzer, and Collect-related external stored procedures.
Reinstating Statistics
| To reinstate all ... | You must specify a value for ... |
|---|---|
| objects and statistics within a specified database | DatabaseName only. |
| statistics for a specified table | both DatabaseName and TableName. |
Examples: Using RemoveExcludedObject
The following example show how to reinstate the Personnel.Project table and prepare all statistics for the Personnel database, including those on the Personnel.Project table.
CALL TDSTATS.RemoveExcludedObject('PERSONNEL','PROJECT', NumRemoved);
Result:
*** Procedure has been executed.
*** Total elapsed time was 1 second.
NumRemoved
-----------
1
CALL TDSTATS.PrepCollect ('PERSONNEL', NULL, NULL, NULL, NumStmtsPrepped, NumStatsPrepped, CmdListID);
Result:
*** Procedure has been executed. *** Total elapsed time was 3 seconds.