Page 1 of 1
Database connection
Posted: Thu Aug 07, 2008 1:26 am
by subrat
Hi,
Can anyone help me to understand below elements in DB connection in datastage
$DB2_CLIENT_INSTANCE_NAME
$APT_DB2INSTANCE_HOME
$DB2_SERVER
$DB2_DATABASE
How all are different from one another.While database connection in a job, how all these perform in which order?
Thanks
Re: Database connection
Posted: Thu Aug 07, 2008 1:39 am
by naveen19
subrat wrote:Hi,
Can anyone help me to understand below elements in DB connection in datastage
$DB2_CLIENT_INSTANCE_NAME
$APT_DB2INSTANCE_HOME
$DB2_SERVER
$DB2_DATABASE
How all are different from one another.While database connection in a job, how all these perform in which order?
Thanks
Hi Subrat,
$DB2_CLIENT_INSTANCE_NAME : db2lcnt
$APT_DB2INSTANCE_HOME: path ex: (/home/db2home/db2clnt)
$DB2_SERVER: Server where the database has been installed
$DB2_DATABASE:(This prob sid(system identification Number)
When u connect from client machine
Client spans,Serches the server,finds the home,in that find which instance to be connected
Regards
Naveen.K
Re: Database connection
Posted: Thu Aug 07, 2008 1:41 am
by naveen19
subrat wrote:Hi,
Can anyone help me to understand below elements in DB connection in datastage
$DB2_CLIENT_INSTANCE_NAME
$APT_DB2INSTANCE_HOME
$DB2_SERVER
$DB2_DATABASE
How all are different from one another.While database connection in a job, how all these perform in which order?
Thanks
Hi Subrat,
$DB2_CLIENT_INSTANCE_NAME : db2lcnt
$APT_DB2INSTANCE_HOME: path ex: (/home/db2home/db2clnt)
$DB2_SERVER: Server where the database has been installed
$DB2_DATABASE:(This prob sid(system identification Number)
Regards
Naveen.K
Re: Database connection
Posted: Thu Aug 07, 2008 2:23 am
by subrat
Hi Naveen,
You mean to say it will execute in below order?
$DB2_CLIENT_INSTANCE_NAME-->$DB2_SERVER-->$DB2_DATABASE-->$APT_DB2INSTANCE_HOME....
Please let me know if the above is correct?
naveen19 wrote:subrat wrote:Hi,
Can anyone help me to understand below elements in DB connection in datastage
$DB2_CLIENT_INSTANCE_NAME
$APT_DB2INSTANCE_HOME
$DB2_SERVER
$DB2_DATABASE
How all are different from one another.While database connection in a job, how all these perform in which order?
Thanks
Hi Subrat,
$DB2_CLIENT_INSTANCE_NAME : db2lcnt
$APT_DB2INSTANCE_HOME: path ex: (/home/db2home/db2clnt)
$DB2_SERVER: Server where the database has been installed
$DB2_DATABASE:(This prob sid(system identification Number)
Regards
Naveen.K
Re: Database connection
Posted: Thu Aug 07, 2008 2:38 am
by naveen19
This will be the Order
$DB2_CLIENT_INSTANCE_NAME-->$DB2_SERVER-->-->$APT_DB2INSTANCE_HOME-->$DB2_DATABASE....
Regards Naveen.k
Re: Database connection
Posted: Thu Aug 07, 2008 2:41 am
by naveen19
This will be the Order
$DB2_CLIENT_INSTANCE_NAME-->$DB2_SERVER-->-->$APT_DB2INSTANCE_HOME-->$DB2_DATABASE....
Regards Naveen.k