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
Control-M EM Version 8.0.00 with PostGreSQL Database.
- Henk Trumpie
- Nouveau
- Posts: 22
- Joined: 27 Jul 2007 12:00
Are you sourceing the .pgenv.sh/.pgenv.csh?
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
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
- Henk Trumpie
- Nouveau
- Posts: 22
- Joined: 27 Jul 2007 12:00
psql
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
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