Home skin

 

  Location : TOP > Usage for TG ver 0.7X
> Parameter index 		 

 

 

  
 

+ SYSTEM Field
- AUTOEXEC
- EDITOR
- LOGFILE
- PLATFORM
- PROMPT
- SLAVE_SERVERS
- SPOOL
+ DATABASE Field
- CONNECT_URL
- DELAY_START
- DRIVERTYPE
- ERROR_RECONNECT_COUNT
- ERROR_RECONNECT_WAIT
- ERROR_RETRY_COUNT
- ERROR_RETRY_WAIT
- EXECUTION_COUNT
- HOSTNAME
- PASSWORD
- PORT
- RECONNECT_WAIT
- SESSIONS
- SIDNAME
- THINKTIME
- TNSNAMES
- USERNAME
+ VARIABLE Field
- VARIABLE_NAME
- VARIABLE_TYPE
- VARIABLE_PROP
+ TRANSACTION Field
- AVERAGE
- STATEMENT
+ JOB Field
- EXECFILE
- HOSTNAME
- JOB_NAME
- JOB_TYPE
- PORT
- PASSWORD
- TRIGGER
- USERNAME

  
     
  >> TOP  

 

 

 

 

 

 

Before starting transactions, you must specify target database and transaction informaion in the "tg.conf" configuration file.
* If you use TGC, "tg.conf" is generated by TGC automatically.

"tg.conf" is composed of five filelds.

- SYSTEM
- DATABASE
- VARIABLE
- TRANSACTION
- JOB

The meaning of each field is as follows.

SYSTEM Field
Define a whole attribution of TG. For example, configraion filename, log file name, etc...

DATABASE Field
Define a target database information and agent configration.

VARIABLE Field
Define a variable which is used in a transaction. Two or more this fields can be defined according to the number of random numbers used. The number of VARIABLE fields that can be set is 20 or less.

TRANSACTION Field
Define a transaction. Two or more this fields can be defined according to the number of transactions used. The number of TRANSACTION fields that can be set is 20 or less.

JOB Field
Define a job which is executed according to specified timing. The job can be executed in a local node and a remote node using TELNET protocol.

Each field should enclose with "<" and ">" as follows, and parameters must be set here.

<SYSTEM
parameters ...
parameters ...
...
>

<DATABASE
parameters ...
parameters ...
...
>

Using a "#" on the head of line, you can comment out the line.

 

  SYSTEM field
 
AUTOEXEC
 
Parameter type
:
String
Syntax
:
 AUTOEXEC = { on | off }
Default value
:
off
Range of Values
:
on | off
 
The AUTOEXEC parameter enables or disables a job executed automatically. When the value is set to "ON", some commands which is registered as a job are executed at the specified timing.

For details about "JOB", see "JOB Field" in this reference.
 
 
EDITOR
 
Parameter type
:
String
Syntax
:
 EDITOR = filename string
Default value
:
notepad.exe
Range of Values
:
Any valid file name
 
EDITOR specifies an editor program which is started up when EDIT command is executed. This parameters is available in the windows platform only.

For details about "EDIT" command, see Command reference.
 
 
LOGFILE
 
Parameter type
:
String
Syntax
:
 LOGFILE = filename
Default value
:
< the same directory of tg.jar >/tg.log
Range of Values
:
Any valid file name
 
LOGFILE specifies the pathname where debugging log files are written during TG operations.
 
 
PLATFORM
 
Parameter type
:
String
Syntax
:
 PLATFORM = { windows | unix }
Default value
:
Set automatically by TG
Range of Values
:
windows | unix
 
PLATFORM parameter specifies platform name where TG is running. On most platforms, TG automatically sets the value of PLATFORM which is suitable for your system. If auto-detection does not work successfully, you can also set the value to this parameter manually.
 
 
PROMPT
 
Parameter type
:
String
Syntax
:
 PROMPT = prompt string
Default value
:
"TG"
Range of Values
:
None
 
PROMPT specifies TG command prompt strings. When two or more TG is executed in one node, this parameter can be used as a identification flag.
 
 
SLAVE_SERVERS
 
Parameter type
:
String
Syntax
:
 SLAVE_SERVERS = hostname : port-number , ...
Default value
:
none
Range of Values
:
The number of Maximum slave servers is 8.
 

SLAVE_SERVERS specifies hostname ( or IP address) and port number of TG which is running on a remote node. Specified this parameter, TG is act as a "Master server" and control slave servers.

 
 
SPOOL
 
Parameter type
:
String
Syntax
:
 SPOOL = { on | off }
Default value
:
off
Range of Values
:
on | off
 
SPOOL parameter enable or disable messages written into the logfile. When SPOOL is set to "ON", messages which TG outputs to the STANDARD OUTPUT are written into the logfile specified at LOGFILE parameter, too.
 

 

  DATABASE field
 
CONNECT_URL
 
Parameter type
:
String
Syntax
:
 CONNECT_URL = JDBC CONNECT URL String
Default value
:
Automatically generated
Range of Values
:
Any valid JDBC CONNECT URL
 
CONNECT_URL parameter specifies JDBC CONNECT URL directly. Normally this parameter is set automatically by TG using following parameters.

- JDBC Thin driver : HOSTNAME, PORT, SIDNAME
- JDBC OCI driver : TNSNAMES

Use this parameter when you want to use particular functions of OracleNet.
 
 
DELAY_START
 
Parameter type
:
String
Syntax
:
 DELAY_START = { true | false }
Default value
:
false
Range of Values
:
true | false
 
When DELAY_START parameter is set to "TRUE", each agent delayed to start transactions after START command fired. Delay time is 20 seconds or less. This parameter is used to move the transaction execution timing of each Agent.
 
 
DRIVERTYPE
 
Parameter type
:
String
Syntax
:
 DRIVER_TYPE = { thin | oci | oci8 }
Default value
:
Thin
Range of Values
:
thin | oci | oci8
 
DRIVERTYPE parameter specifies JDBC driver type which agents use to connect to the target database.
 
 
ERROR_RECONNECT_COUNT
 
Parameter type
:
Integer
Syntax
:
 ERROR_RECONNECT_COUNT = <number of re-connect >
Default value
:
5
Range of Values
:
-1 or between 0 and unlimited
 

ERROR_RECONNECT_COUNT parameter specifies the maximum counts that agents reconnect to the target database when the session has been cut. "Session has been cut" means like following cases.

- Instance was restarted unexpectedly durling agents operation.
- Agent had failed to send SQL specified times and session was cut.

When the agent has failed over ERROR_RECONNECT_COUNT times, agents give up to establish the connection.

* When this parameter is set to "0", retry is not executed.
* When this parameter is set to "-1", retry is executed unlimitedly.

cf. Waiting time before reconnecting is specified by ERROR_RECONNECT_WAIT parameter.

 
 
ERROR_RECONNECT_WAIT
 
Parameter type
:
Integer
Syntax
:
 ERROR_RECONNECT_WAIT = <time to wait >
Default value
:
10000 (milliseconds)
Range of Values
:
0 .. unlimitted
 
ERROR_RECONNECT_WAIT parameter specifies ( in milliseconds ) the waiting time before agent's reconnecting when the session has been cut.
 
 
ERROR_RETRY_COUNT
 
Parameter type
:
Integer
Syntax
:
 ERROR_RETRY_COUNT = <the number of retry >
Default value
:
5
Range of Values
:
None or 0..unlimitted
 
ERROR_RETRY_COUNT parameter specifies number of times the agent will be allowed to fail to execute SQL statements. When the agent has failed over ERROR_RETRY_COUNT times, the agent disconnects from the target database.

* When this parameter is set to "0", retry is not executed.
* When this parameter is null, retry is repeated unlimitedly.

cf. Waiting time before retring is specified by ERROR_RETRY_WAIT parameter.
 
 
ERROR_RETRY_WAIT
 
Parameter type
:
Integer
Syntax
:
 ERROR_RETRY_WAIT = <time of wait >
Default value
:
1000(milliseconds)
Range of Values
:
none
 
ERROR_RETRY_WAIT parameter specifies ( in milliseconds ) the waiting time before agent's re-executing SQL statements when the SQL has failed.
 
 
EXECUTION_COUNT
 
Parameter type
:
Integer
Syntax
:
 EXECUTION_COUNT = <the number of executing transaction >
Default value
:
1000 (milliseconds)
Range of Values
:
None or 1 .. unlimitted
 
When EXECUTION_COUNT parameter has been set to a value, agents disconnect from the target database after executed SQL statements specified times.

This parameter is used when a lot of connection/disconnection are repeated.

Waiting time before reconnection is specified at RECONNECT_WAIT parameter.
 
 
HOSTNAME
 
Parameter type
:
String
Syntax
:
 HOSTNAME = hostname string or IP address
Default value
:
None
Range of Values
:
Any valid hostname or IP address
 
HOSTNAME parameter spcefifies the hostname where target database is rinning.
* This parameter is available when DRIVERTYPE parameter is set to "THIN".
 
 
PASSWORD
 
Parameter type
:
String
Syntax
:
 PASSWORD = password string
Default value
:
none
Range of Values
:
Any valid password
 
PASSWORD parameter specifies password which is used by agents connecting the target database.
 
 
PORT
 
Parameter type
:
Integer
Syntax
:
 PORT = <port number >
Default value
:
1521
Range of Values
:
0 .. 65535
 
PORT parameter specifies port number which is used by agents connecting to the target database.

* This parameter is available when DRIVERTYPE parameter is set to "THIN".
 
 
RECONNECT_WAIT
 
Parameter type
:
Integer
Syntax
:
 RECONNECT_WAIT = <wait time>
Default value
:
None
Range of Values
:
None
 
RECONNECT_WAIT parameter specifies ( in milliseconds ) the waiting time before agent's reconnecting to the target database.

* This parameter is available when EXECUTION_COUNT parameter is set to some values.
 
 
SESSIONS
 
Parameter type
:
Integer
Syntax
:
 SESSIONS = <the number of connection>
Default value
:
10
Range of Values
:
1 .. 2000
 
SESSIONS parameter specifies the number of agents (virtual clients) which connect to the target database.
 
 
SIDNAME
 
Parameter type
:
String
Syntax
:
 SIDNAME = sid string
Default value
:
None
Range of Values
:
Any valid SIDNAME
 
SIDNAME parameter specifies SID name of the target database.

* This parameter is available when DRIVERTYPE parameter is set to "THIN".
 
 
THINKTIME
 
Parameter type
:
Integer
Syntax
:
 THNKTIME = <wait time>
Default value
:
100
Range of Values
:
None
 
THINKTIME parameter specifies ( in milliseconds ) the interval after one transaction is executed. Agent stands by during the specified time and executes next transactions.
 
 
TNSNAMES
 
Parameter type
:
String
Syntax
:
 TNSNAMES = tnsnames string
Default value
:
None
Range of Values
:
Any valid TNSNAMES
 
TNSNAMES parameter specifies tnsnames description of the target database. It is necessary to define tnsnames description appropriately in "tnsnames.ora"configuration file.

* This parameter is available when DRIVERTYPE parameter is set to "OCI" or "OCI8".
 
 
USERNAME
 
Parameter type
:
String
Syntax
:
 USERNAME = username string
Default value
:
None
Range of Values
:
Any valid database user name
 
USERNAME parameter specifies username which is used by agents connecting to the target database.
 

 

  VARIABLE field
 
VARIABLE_NAME
 
Parameter type
:
String
Syntax
:
 VARIABLE_NAME = variable-name string
Default value
:
None
Range of Values
:
None
 
VARIABLE_NAME parameter specifies random variable name. This name must to be started with the colon (:) and entered in English one byte characters.
 
 
VARIABLE_TYPE
 
Parameter type
:
String
Syntax
:
 VARIABLE_TYPE = { NUMBER | CHARACTER | DATE | LIST | AGENTID }
Default value
:
None
Range of Values
:
NUMBER | CHARACTER | DATE | LIST | AGENTID
 
VARIABLE_TYPE parameter specifies the type of random variable. Following types are avlilable now.
- NUMBER ： Random integral number
- CHARACTER ： Alphanumeric character of random length
- DATE ： Random date（YYYY/MM/DD）
- LIST ： The user definition character string is extracted at random
- AGENTID ： Agent-ID that execute transactions
 
 
VARIABLE_PROP
 
Parameter type
:
Integer
Syntax
:
 VARIABLE_PROP = <depending on VARIABLE_TYPE parameter>
Default value
:
None
Range of Values
:
Depending on VARIABLE_TYPE parameter
 
VARIABLE_PROP parameter controls the value that is set into random variable.

Case1　VARIABLE_TYPE = NUMBER
VARIABLE_PROP specifies the minimum value and maximum value of random integer. When VARIABLE_PROP is set to "10..100", random integer between 10 and 100 is put into random variable.

Case2　VARIABLE_TYPE = CHARACTER
VARIABLE_PROP specifies the minimum length and maximum length of random alphanumeric characters. When VARIABLE_PROP is set to "10..255", string of random length between 10 and 255 characters is put into random variable.

Case3　VARIABLE_TYPE = DATE
VARIABLE_PROP specifies the minimum value and maximum value of random date. When VARIABLE_PROP is set to "2000/1/1..2001/12/31", random date between 2000/01/01 and 2001/12/31 is put into random variable.

Case4　VARIABLE_TYPE = LIST
VARIABLE_PROP is set to one or more character strings. Each string must be Double-quoted, comma-separated list. Character string of the list is extracted at random.

e.g. )
VARIABLE_PROP = "January", "February", "March", "April", "May", "June", "July" , "August" , "September","October", "November", "December"

Case5　VARIABLE_TYPE = AGENTID
Agent-ID executing transactions is put into random variable.
 

 

  TRANSACTION field
 
AVERAGE
 
Parameter type
:
Integer
Syntax
:
 AVERAGE = <ratio of execution >
Default value
:
None
Range of Values
:
None
 
AVERAGE parameter specifies execution ratio of the transaction. For example, Three transactions are registered and AVERAGE parameter are set to "10", "20" and "30", each transaction is executed in 10, 20 and 30 percent.
 
 
STATEMENT
 
Parameter type
:
String
Syntax
:
 STATEMENT = <one SQL statement>
Default value
:
None
Range of Values
:
Any valid SQL statement
 
STATEMENT parameter specifies SQL statements performed in the transaction. Two or more STATEMENT phrases can be defined in one TRANSCATION field. The number of STATEMENT that can be registered in one TRANSACTION is 20 or less.

e.g. 1)
<TRANSACTION
AVERAGE = 90
STATEMENT = select name , id from test;
>

e.g. 2)
<TRANSACTION
AVERAGE = 80
STATEMENT = insert into ntab values (idseq.nextval,':NAME0',to_date(':YEAR/:MONTH/:DAY','yyyy/mm/dd'));
STATEMENT = commit;
>

e.g. 3)
<TRANSACTION
AVERAGE = 10
STATEMENT = select * from test where id = :ID for update;
STATEMENT = update test set name = :NAME where id = :ID;
STATEMENT = rollback;
>
 

 

  JOB field
 
EXECFILE
 
Parameter type
:
String
Syntax
:
 EXECFILE = <depending on JOB_TYPE parameter>
Default value
:
None
Range of Values
:
Depending on JOB_TYPE parameter
 
EXECFILE parameter specifies the command (binary file) or the script file (text file) executed as JOB. This value changes depending on parameter "JOB_TYPE".

Case.1　JOB_TYPE=COMMAND
EXECFILE is set to the command (binary file) or the batch file in the full path.

Case.2　JOB_TYPE=TELNET | SQL | PL/SQL
EXECFILE is set to the name of text file where SQL or PL/SQL statements is written. Only the file name is specified for this parameter (not in the full path). The text files are must to be in the directory that is specified at "JOB_DIR" parameter.
 
 
HOSTNAME
 
Parameter type
:
String
Syntax
:
 HOSTNAME = hostname string
Default value
:
None
Range of Values
:
Any valid Operating System user name
 
HOSTNAME parameter specifies remote host name where some commands are executed.

* This parameter is available when JOB_TYPE parameter is set to "TELNET" or "SQL" or "PL/SQL".
 
 
JOB_NAME
 
Parameter type
:
Sting
Syntax
:
 JOB_NAME = job-name string
Default value
:
None
Range of Values
:
None
 
JOB_NAME parameter specifies the name of JOB.
 
 
JOB_TYPE
 
Parameter type
:
String
Syntax
:
 JOB_TYPE = { COMMAND | TELNET | SQL | PL/SQL }
Default value
:
None
Range of Values
:
COMMAND | TELNET | SQL | PL/SQL
 

JOB_TYPE parameter specifies the type of JOB.

Case1　JOB_TYPE = COMMAND
JOB is executed on the local node. EXECFILE parameter must be set to one command or text file where some commands are written.

Case2　JOB_TYPE = TELNET
JOB is executed on the remote node. EXECFILE parameter must be set to the text file where some commands are written.
* It is necessary to set up the TELNET server appropriately on the remote node to send some commands by using the TELNET protocol.

Case3　JOB_TYPE = SQL
JOB is executed on the target database server. EXECFILE parameter must be set to the text file where some SQL statements are written.

Case4　JOB_TYPE = PL/SQL
JOB is executed on the target database server. EXECFILE parameter must be set to the text file where some PL/SQL statements are written.
 
 
PORT
 
Parameter type
:
Integer
Syntax
:
 PORT = <port number>
Default value
:
23
Range of Values
:
0 .. 65535
 

PORT parameter specifies the port number to connect to the remote node when TG executes a JOB.

Case1　JOB_TYPE = COMMAND
PORT parameter is not used.

Case2　JOB_TYPE = TELNET
PORT parameter must be set to the port number where TELNET server is listening. Default value is "23".

Case3　JOB_TYPE = SQL or PL/SQL
PORT parameter must be set to the port number where ORACLE Listener is listeneing.
 
 
PASSWORD
 
Parameter type
:
String
Syntax
:
 PASSWORD = password string
Default value
:
None
Range of Values
:
Any valid password
 

PASSWORD parameter specifies the password to connect to the remote node when TG executes a JOB.

Case1　JOB_TYPE = COMMAND
PASSWORD parameter is not used.

Case2　JOB_TYPE = TELNET
PASSWORD parameter must be set to OS USER password.

Case3　JOB_TYPE = SQL or PL/SQL
PASSWORD parameter must be set to ORACLE USER password.
 
 
TRIGGER
 
Parameter type
:
String
Syntax
:
 TRIGGER = { PROGRAM_START | PROGRAM_END | MONITOR_START | MONITOR_END | USER_REQUEST }
Default value
:
None
Range of Values
:
PROGRAM_START | PROGRAM_END | MONITOR_START | MONITOR_END | USER_REQUEST
 
TRIGGER parameter specifies the event name that becomes the trigger of the JOB execution.

Case1　TRIGGER = PROGRAM_START
JOB is executed when TG startup.

Case2　TRIGGER = PROGRAM_END
JOB is executed when TG terminate.

Case3　TRIGGER = MONITOR_START
JOB is executed when TPS monitor is started.

Case4　TRIGGER = MONITOR_END
JOB is executed when TPS monitor is terminated.

Case5　TRIGGER = USER_REQUEST
JOB is not executed automatically. Users need to execute the JOB manually using the "EXECUTE" command.
 
 
USERNAME
 
Parameter type
:
String
Syntax
:
 USERNAME = username string
Default value
:
None
Range of Values
:
Any valid user name
 

USERNAME parameter specifies the username to connect to the remote node when TG executes a JOB.

Case1　JOB_TYPE = COMMAND
USERNAME parameter is not used.

Case2　JOB_TYPE = TELNET
USERNAME parameter must be set to OS USER name.

Case3　JOB_TYPE = SQL or PL/SQL
USERNAME parameter must be set to ORACLE USER name.
 

 
     
  >> TOP > Usage for TG ver 0.7X
> Parameter index 		 

 
Copyright 2003 - 2008 tgmstr. All rights reserved.