Environment variable dbms_type is not set | R3trans -d issue

This is a very small blog just discussing an issue faced while using R3trans -d , Basically this needs some environment variable attached to it i.e. before running this command you should just make sure that your environment variables are set.

Whenever we get this dbms_type is not set , the first thing which should be checked is that the environment variables are set or not.

What is environment variable ?

We have different types of environment variable but without confusing you , right now we are talking about local environment variable

These variable are set and configured in ~/.bashrc, ~/.bash_profile, ~/.bash_login, ~/.profile 

files according to the requirement. These variables can be accessed by a particular user and persist through power offs.

Now the point to understand here, is that the local variable is as per the user , thus it is mandatory for us to run r3trans -d from <sid>adm user (OS User).

Moving forward , sometimes this issue is resolved using start R3trans -d with SIDADM

If this also does not help check SAP Note : 1827566 , But as per our understanding these steps are not relevant in newer version of SAP HANA.

Environment variables are available at this location : ~/.sapenv_<hostname> .csh and ~/.sapenv_<hostname> .sh

What are the various values stored as environment variable,


dbs_db6_schema : Name of the database schema and database connect user if the schema name equals the user name

dbs_db6_user : Name of the database connect user if database schema name does not equal database connect user name

dbms_type : SAP short form for the database platform, for example, db6 equals DB2 for Linux, UNIX, and Windows

DB2_CLI_DRIVER_INSTALL_PATH : If this variable is set to a directory, the default path for the CLI driver installation is overwritten.

and other parameters are DB dependent.

Please let us know in comments if you face this issue and what is the resolution for same.

Read More :

Related SAP Blog

SAP Note