Parameters for Setting Up the Database Connection 

The system assumes that all environment variables needed for setting up the database connection are set correctly before tp is called. For this reason, only user <sid>adm should use tp at operating system level.

This applies in Release 6.10 and higher. Unlike in earlier releases, tp now no longer modifies the environment variables.

 

To set individual environment variables to a specific value other than the default value for user <sid>adm, you can use parameter mod_env. You can also user this parameter if you want to use operating system users other than <sid>adm.

For information on the environment variables and their recommended values, see Environment Variables for Setting Up the Database Connection.

 

●      mod_env

The value of this parameter can have the following syntax:

●      <conditional_statement>

●      {<conditional_statement>}{<conditional_statement>} [{...}]

 

<conditional_statement> can have the following syntax:

●      <condition> ? <statement> : <statement>

●      <statement>

 

<condition> can have the following syntax:

●      <variable> <> <value>

●      <variable> == <value>

 

Two special variables can be used for the <condition>:

●      HOST

This variable is replaced by the name of the host where the tp is running.

●      OSUSER

This variable is replaced by the name of the operating system user who called the tp.

 

<statement> can have the following syntax:

●      set <variable> = <value>

●      unset <variable>

The syntax of <statement> is independent of the operating system (and of the UNIX shell).

tp converts <statement> automatically to suitable commands in order to change its environment (together with the environment of any programs that have been launched, such as R3trans).

 

Here are some examples of how environment variable MSSQL_USEINTEGRATEDSECURITY can be set to a particular host:

...

                            a.      mod_env = { HOST == host0001 ? set MSSQL_USEINTEGRATEDSECURITY = 0 : set  MSSQL_USEINTEGRATEDSECURITY = 1}

                            b.      P11/mod_env = { HOST == host0001 ? set MSSQL_USEINTEGRATEDSECURITY = 0 : set  MSSQL_USEINTEGRATEDSECURITY = 1}

 

●      dummy

This parameter is usually set automatically during configuration of the transport system. It is set to 1 for all non-SAP systems.

Default: 0

Value range: Boolean

You can use this parameter to make a dummy system known in the global parameter file. No imports are performed for SAP systems with dummy=1.

D11/dummy = 1