B.1.2 Changing Parameters of the Database

Execute following two setting in order to use the Database of the Dashboard Server which was used with the Systemwalker Service Quality Coordinator V13.5 continuously with the Systemwalker Service Quality Coordinator V15.0.1.

Increase the size of the RDB dictionary
Prevent the database space used up

Increase the size of the RDB dictionary

Increase the size of the RDB dictionary to 1GB by executing following procedure.

Stop the Application Server of the Dashboard Server.
Make a backup of RDB dictionary in case of abnormal termination of the capacity allocation. (When Symfoware Server is installed with default, following command is stored under "<System Drive>:\SFWSV\RDB\BIN".)
1. Start command prompt, and set system name.
```
set RDBNAME=SWSQC
```
2. Execute following command, and set the update control to RDB dictionary.
```
rdbrtr -z -rw
```
3. Execute following command, and save the RDB dictionary.
```
rdbdmpdic -N -f dicback@<Directory to save> -e -y
```
4. Execute following command, and release the update control of RDB dictionary
```
rdbrls -z -rw
```
Execute to increase the size.
1. Execute following command, and stop the RDB system.
```
rdbstop -mwc
```
2. Execute following expansion command. (Default value of the RDB dictionary "<System Drive>:\SWFD\RDB\USR\DIC")
```
rdbaldic -a 20M -e -f <Directory of the RDB dictionary>/DICTIONARY2 -c 2048M
```
3. Execute following command, and start the RDB system.
```
rdbstart
```
Execute to allocate additional capacity.
1. Execute following command, and confirm the usage status of the RDB dictionary. When the Maximum value of the output result is less than 50%, procedure to allocate additional capacity is end.
```
rdbprdic
```
2. Stop Symfoware RDB system
3. Execute following command, and allocate additional capacity. Set the additional capacity with less than 50% of maximum value of rdbprdic.
```
rdbaldic -a <additional capacity>
```
4. Start Symfoware RDB System.

Prevent the database space used up

At the first time, Dashboard Server of the Systemwalker Service Quality Coordinator V15.0.1 uses about 7GB for table space of database.

Correspond as follows according to existing remained capacity.

Less than 5GB : Create new database space
5GB - 7GB : Change the parameter of the default size

Confirm method of the remainder capacity in table space

Confirm as follows by using command prompt.

C:>set RDBNAME=SWSQC
C:>rdbspcinf -d EVENT

        Database space : EVENTSPACE
        Device         : E:\INSTROOT\SWFD\RDB\USR\EVENT
        Size           : 20480000K
        Static allocate size
         total   : 10000000K
        Dynamic allocate size
         total   :   240000K
        Free size
         total   : 10240000K
qdg12074i:rdbspcinf was normally terminated. Return code 00   (SYSTEMNAME =SWSQC )

In above case, remaining capacity (Free size) is about 10GB.

Remaining capacity is less than 5GB: When remaining capacity is less than 5GB, creating a new database space with more than 20GB is required before starting migration. Set a new database space as Events DB from Analytics Management Console of the Interstage Business Process Manager Analytics.

Remaining capacity is 5GB - 7GB

When remaining capacity is 5GB - 7GB, execute following procedure.

Change the parameter for table creation from Analytics Management Console of the Interstage Business Process Management Analytics.
Change the following parameters under Analytics System >> System Settings >> Database Management >> Events DB >> JDBC Connection URL.
- CLI_DEFAULT_TABLE_SIZE=(8,256,25600,128)
- CLI_DEFAULT_INDEX_SIZE=(2,2,256,2560,128)

Example

jdbc:symford://XXX.XXX.XXX.XXX:23451/EVENT;schema=EVENTSCHEMA;ctuneparam='CLI_MAX_SQL=(512);CLI_DEFAULT_TABLE_SIZE=(8,256,25600,128);CLI_DEFAULT_INDEX_SIZE=(2,2,256,256,2560,128)'