SYSIN syntax

This topic describes the BMC AMI Check SYSIN syntax.

Related topics

Getting-started-with-BMC-AMI-Check

BMC-AMI-Check-command-and-syntax-reference

CHECK INDEX

CHECK INDEX is the primary command for the BMC AMI Check product.


CheckIndex_Syntax.png

If you do not specify a database name or database name pattern, BMC AMI Check uses the default DSNDB04.

The database name and table space name patterns use Db2 SQL wildcard characters to reference groups of objects. You can use any combination of the standard SQL wildcard characters  %  and underscore ( _ ). The product constructs and issues an SQL query to obtain the names of all objects that match the specified patterns. The product prints a line on SYSPRINT and SUMMARY for each object that it finds.

To check all indexes in all table spaces in a database, type databaseName.% as in the following example:

Example
CHECK INDEX (ALL) TABLESPACE BIGDBASE.%


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*