Scheduler Usage

I know this might sound like a stupid question, but I really hope someone can help on this.

We have a customer with Control-M EM Version 8.0.00 installed with a dedicated PostGreSQL Database on a Linux machine (Suse 11).

Everything works fine except we can not seem to find what the command line COMMAND is to log into the actual Database?

We have tried almost everything and without success.

We have tried "pgsql", "psql", "sql", "SQL", "em_sql", "emsql", "isql", "osql" anything we could think of we have tried.

Yeah, it is easy going through the root_menu option, but they have some tasks that is defined to run select statements within the Database as well, and they in pre-defined scripts which they will not want to change.

I hope someone can help

Thx

Hi,

BMC does not include automatically the specific DB profile files in the login profiles of the BMC-USer.

You must include following lines in the login profile $HOME/.cshrc (if the user is using CSH/TCSH and EM-Admin:

source $HOME/ctm_em/.PGenv.csh

Or for the Bash add the line in .profile or .bashrc:

. $HOME/ctm_em/.PGenv.csh

The same must be done for the Control-M/Server-User

Regards,
schidl

Hi,

Thank you for the reply.
I will try and add the line and see what happens

What is the command then to run?
psql / pgsql / SQL / em_sql

Regards
Henk

Hi,

it is psql.

Be carefull, if LINUX-User name is not the DBO-name.

Than you must start psql in the following way:

psql -U $PGUSER

Have fun.
schidl