Reinstates a previously excluded object.
Definition
REPLACE PROCEDURE TDSTATS.RemoveExcludedObject (IN DatabaseName VARCHAR(128) CHARACTER SET UNICODE, IN TableName VARCHAR(128) CHARACTER SET UNICODE, OUT NumRemoved INTEGER) . . . ;
Input Parameters
| Parameter | Description |
|---|---|
| DatabaseName | Name of database. DatabaseName allows you to specify the database to reinstate or the database containing a table to reinstate. |
| TableName | Name of the table. TableName allows you to specify a table within DatabaseName to be reinstated. |
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. |
Output Parameter
| Parameter. | Description |
|---|---|
| NumRemoved | Number of objects removed from the exclusion list. |
Example: Using RemoveExcludedObject
The following example shows 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);
*** Procedure has been executed.
*** Total elapsed time was 1 second.
NumRemoved
-----------
1
CALL TDSTATS.PrepCollect ('PERSONNEL', NULL, NULL, NULL, NumStmtsPrepped, NumStatsPrepped, CmdListID);
*** Procedure has been executed.
*** Total elapsed time was 3 seconds.