Database connection

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
subrat
Premium Member
Premium Member
Posts: 77
Joined: Tue Dec 11, 2007 5:54 am
Location: UK

Database connection

Post 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
Top
naveen19
Participant
Posts: 52
Joined: Tue Mar 06, 2007 9:08 am
Location: India
Contact:
Contact naveen19

Re: Database connection

Post 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
Last edited by naveen19 on Thu Aug 07, 2008 1:43 am, edited 1 time in total.
Top
naveen19
Participant
Posts: 52
Joined: Tue Mar 06, 2007 9:08 am
Location: India
Contact:
Contact naveen19

Re: Database connection

Post 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
Top
subrat
Premium Member
Premium Member
Posts: 77
Joined: Tue Dec 11, 2007 5:54 am
Location: UK

Re: Database connection

Post 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
Top
naveen19
Participant
Posts: 52
Joined: Tue Mar 06, 2007 9:08 am
Location: India
Contact:
Contact naveen19

Re: Database connection

Post by naveen19 »

This will be the Order

$DB2_CLIENT_INSTANCE_NAME-->$DB2_SERVER-->-->$APT_DB2INSTANCE_HOME-->$DB2_DATABASE....


Regards Naveen.k
Top
naveen19
Participant
Posts: 52
Joined: Tue Mar 06, 2007 9:08 am
Location: India
Contact:
Contact naveen19

Re: Database connection

Post by naveen19 »

This will be the Order

$DB2_CLIENT_INSTANCE_NAME-->$DB2_SERVER-->-->$APT_DB2INSTANCE_HOME-->$DB2_DATABASE....


Regards Naveen.k
Top
Post Reply

Return to “General”