Additional Connection Options in Oracle Enterprise Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sathyanveshi
Participant
Posts: 66
Joined: Tue Dec 07, 2004 12:48 pm

Additional Connection Options in Oracle Enterprise Stage

Post by sathyanveshi »

Hi,

Any idea how and why "Additional Connection Options" is used in Oracle Enterprise Stage?

Cheers,
Mohan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

sathyanveshi,

it is used to establish additional options for the connection to Oracle. At my current site, we add in OracleArraySize to increase the Oracle array size. Other attributes that are session specific can also be put into this space.
sathyanveshi
Participant
Posts: 66
Joined: Tue Dec 07, 2004 12:48 pm

Post by sathyanveshi »

Hi,

Thanks for the response.

May I know what other Oracle options can be used (like NOLOGGING etc).

Cheers,
Mohan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Mohan,

please try it and tell us if it works.
sathyanveshi
Participant
Posts: 66
Joined: Tue Dec 07, 2004 12:48 pm

Post by sathyanveshi »

Hi,

As of now, we are exploring differnt options. Once we test the options, I shall certainly update you.

Cheers,
Mohan
Post Reply