Using execdbscript with PortalDB

Use the execdbscript script to manage and monitor the portal database (PortalDB). Start the csi-tool.jar utility as described in “Using the csi-tool.jar utility”, then issue your command, using the usage information in Table 7-5.

Table 7-5: execdbscript arguments

Argument name

Argument description

Argument type

Argument default value

Required arguments

SCRIPT_FILE

The database script file in absolute path.

Readable file

JDBC_URL

The JDBC URL to use when connecting to the database.

string

JDBC_DRIVER

The JDBC driver to register before attempting to connect to the database

Java classname

Optional arguments

JDBC_ADMIN_USERNAME

The user name for connecting to the database for administrative purposes.

string

dba

JDBC_ADMIN_PASSWORD

The password of the user specified by the JDBC_ADMIN_USERNAME argument.

string (password)

sql

SYBASE_ASA_SERVICE NAME

The SERVICENAME connection property to use when connecting to the Sybase ASA database.

string

DELIMITER

The symbol to delimit SQL statements.

string

go

DATABASE_TYPE

The database type. Acceptable values: sybase_asa, sybase_ase.

string choice

sybase_asa