find_sql_rollup and dbschema_sync command parameters

This section lists and describe the parameters for commands find_sql_rollup and dbschema_sync, which you run after you finish upgrading the core components.

Note

After running either of the commands find_sql_rollup and dbschema_sync, restart the TMTM Application Service.

During the normal process of upgrading to a newer version of TMTM, the tables and other objects used by the previous version of the database must be migrated to the new version. You can accomplish this by running a migration script provided in the installation.

Different migration scripts are available for each database/operating system combination. A special utility called find_sql_rollup is provided to determine the correct migration script to use.

When you know the name of the migration script to use, run it from the command line so you can observe any errors. You might miss errors if you use a graphical interface to run the scripts. Run the scripts from the user account that created the database. If that user account is not available, ensure that the user running the scripts has full access to the database. Failure to run the scripts with a qualified user can cause invalid database schema errors. If you use switches to stop the database script on errors, your installation might stop for non-fatal errors. Consult your DBA for more information.

Using find_sql_rollup and its parameters

Usage

find_sql_rollup userid [-p password | -s]

find_sql_rollup -d db_type db_name db_userid [-p db_password | -s]

These commands query the Application Service using userid and password to get the database userid and database password. They also look up the database configuration and generate the SQL rollup script name.

-d skips the Application Service lookup and accepts the database user name and password directly.

find_sql_rollup parameters

Parameters and switches	Function
-d	Indicates direct access to database.
db_type	Type of database you use. Your operating system might require quotes around these values. Valid values are: DB2 Oracle 11.2 Oracle 12.1 Microsoft SQL Server
db_name	Name of the database or ODBC connection.
db_userid	Database user name to use to connect to the database.
-p password	Password for userid. Default is to read from console.
db_password	Password for the user name connecting to the database.
-s	Reads from standard input (stdin) for password. Mutually exclusive with -p.
-v, --version	Prints out the product version.
-?, --usage	Prints out the program usage.

Using dbschema_sync and its parameters

Usage

dbschema_sync userid [-p password | -s] [-i] [-o] [-j] [-a] [-n]

dbschema_sync -d db_type db_name db_userid [-p db_password | -s] [-i] [-o] [-j] [-a] [-n]

These commands query the Application Service using userid and password to get the database userid and database password. They then apply the schema synchronizations to the database.

dbschema_sync parameters

Parameters and switches	Function
-d	Skips the Application Service lookup and accepts the database user name and password directly.
db_type	Type of database you use. Your operating system might require quotes around these values. Valid values are: DB2 Oracle 11.2 Oracle 12.1 Microsoft SQL Server
db_name	Name of the database or ODBC connection.
db_userid	Database user name to use to connect to the database.
userid	TMTM name of user who is a member of the database_login group.
-p password	Password for userid. Default is to read from console.
-p db_password	Password for the user name connecting to the database.
-a	Includes the Audit Event tables in the purge of objects in the 'Deleted' state.
-s	Reads from standard input (stdin) for password. Mutually exclusive with -p.
-i	Ignores the result of the check for the total number of database connections.
-j	Includes the ES Journal in the purge of objects in the 'Deleted' state.
-o	Only does a purge of objects in the 'Deleted' state.
-v, --version	Prints out the product version.
-?, --usage	Prints out the program usage.

find_sql_rollup and dbschema_sync command parameters

Using find_sql_rollup and its parameters

Usage

find_sql_rollup parameters

Using dbschema_sync and its parameters

Usage

dbschema_sync parameters

On this page