Database administrative tasks - Informix
Several scripts are provided to manage the database for the server components and the Dynamic Workload Console, performing tasks such as granting permissions and updating statistics.
The path and the available database tools vary depending on the
component, as follows:
- master domain manager and backup master domain manager
- <MDM_installation_directory>/TWS/dbtools/<database_vendor>/<OS_type>/scripts
- dynamic domain manager and backup dynamic domain manager
- <DDM_installation_directory>/TDWB/dbtools/<database_vendor>/<OS_type>/scripts
- Dynamic Workload Console
- <DWC_installation_directory>/DWC/dbtools/<database_vendor>/<OS_type>/scripts
The following scripts are available:
- dbgrant
- This script grants the user permissions for the views of the server components and the Dynamic Workload Console. For more information, see Syntax and arguments for the dbgrant script.
- dbmaintenanceIds
- This script updates the database statistics for improving query performance and data read efficiency. For more information, see Syntax and arguments for the dbmaintenanceIds script.
To run the scripts, perform the following steps:
- Either copy the ids folder to the database server, or launch the scripts from the workstation where you installed HCL Workload Automation. The ids folder contains the scripts and the related .sql files.
- Check that the user who is going to run the procedure has
the appropriate rights:
- Database administrator permissions
- Full access to and control of the HCL Workload Automation or Dynamic Workload Console installation directory
- Run the script with the -help parameter to display a list of supported parameters.
Syntax and arguments for the dbgrant script
- UNIX operating systems:
-
./dbgrant.sh host port TWS user TWS password database new user
- Supported parameters for the dbgrant script
-
- host
- The hostname or IP address of the database server.
- port
- The port number on which the database service is listening
- TWS user
- The administrative account with authority to grant permissions.
- TWS password
- The password for the administrative account.
- database
- The name of the specific database instance.
- new user
- The username of the account that receives read permissions.
Syntax and arguments for the dbmaintenanceIds script
- Windows operating systems:
-
dbmaintenanceIds.exe [-s informix_server] -db database [-u user] [-p password] - UNIX operating systems:
-
./dbmaintenanceIds [-s informix_server] -db database [-u user] [-p password]
Supported parameters for the dbmaintenanceIds script are as follows:
- -s informix_server
- The name of the database server, for instance localhost or localhost\SQLEXPRESS. The default value is localhost. This parameter is optional when you copy the ids folder on the database server, otherwise it is required.
- -db database
- The database name. This parameter is required.
- -u user
- Name of the user accessing the database. This parameter is optional when you specify user name and password in the shell where you run the command.
- -p password
- Password of the user accessing the database. This parameter is optional when you specify user name and password in the shell where you run the command.