Hello All,

This is my first post so please go easy on me !

I believe we are running all of our batch work in host mode. Is there a quick and easy way of checking that this is the case ?

I , once again, believe that if that the bshell and oracle processes show that they are connected via a PIPE, then the likelihood is that we are running in hostmode.

I thought that having the TWO_TASK set would mean that host mode would not be correctly configured, in that the environment would still be running over SQL_NET ( client-server ). Even though I am running in host mode, the TWO_TASK is set in the .profile of the batch user account AND in the table tabledef6.1.

Can anyone shed any light on this ?

Thanks

Tim

Welcome Tim!

First of all, you will be certain that you are running host mode by the presence of the bshell, oracle (driver) process and the Oracle database on the same server.

The Oracle driver process will be connected to the bshell via a pipe. The connection to the database will be via SQL*NET if TWO_TASK is set. The Oracle process will show a LOCAL=NO is TWO_TASK is in use. The preferred method in hostmode is to set the ORACLE_HOME and ORACLE_SID. For example:

whwmd000:* : oracle8(ORACLE_HOME=/db01/app/oracle/product/804,ORACLE_SID=prod):Y

Hope this helps,

-- Jim