Control-M EM Version 8.0.00 with PostGreSQL Database.

Everything about Control-M Enterprise Manager Server installation or setup.
Post Reply
User avatar
Henk Trumpie
Nouveau
Nouveau
Posts: 22
Joined: 27 Jul 2007 12:00

Control-M EM Version 8.0.00 with PostGreSQL Database.

Post by Henk Trumpie » 14 Apr 2013 1:42

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

User avatar
schidl
Nouveau
Nouveau
Posts: 16
Joined: 11 Jun 2007 12:00
Location: Germany
Contact:

Are you sourceing the .pgenv.sh/.pgenv.csh?

Post by schidl » 17 Apr 2013 8:06

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

User avatar
Henk Trumpie
Nouveau
Nouveau
Posts: 22
Joined: 27 Jul 2007 12:00

Post by Henk Trumpie » 18 Apr 2013 12:50

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

User avatar
schidl
Nouveau
Nouveau
Posts: 16
Joined: 11 Jun 2007 12:00
Location: Germany
Contact:

psql

Post by schidl » 18 Apr 2013 7:03

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

Post Reply