analyze_schema.sh script

Use the analyze_schema.sh script to generate statistics of your Oracle and DB2® databases.

Syntax

analyze_schema.sh

Parameters

None

This command prompts to get the dbpassword and use the current user id as the schema name to analyze.

Example

In this example, the analyze_schema.sh script is run.

$<install directory>/bin/db/analyze_schema.sh

Sample output

============================================================
Analyzing schema 'schema1'
This may take several minutes. Do not kill the session.
============================================================
Note: If the schema to analyze is not the same as the current user id, the output is empty.
No other details display when the script is run, that is, if the script finishes without errors. Therefore, to check the last updated statistics time in Db2 and Oracle, see the following: