Search found 4 matches

by ksenthilvel
Wed May 18, 2005 5:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file problem
Replies: 1
Views: 1338

Configuration file problem

We have two CPU M/C. We created two node configuration file as { node "node1" { fastname "hpsgnvc" pools "" resource disk "/opt/app/Ascential/DataStage/Datasets" {pools ""} resource scratchdisk "/opt/app/Ascential/DataStage/Scratch_1" {pool...
by ksenthilvel
Mon Apr 04, 2005 8:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Connecting to Oracle 10G Data Base.
Replies: 5
Views: 3000

Hi Eric , I had set all setting mention in the release notes. Even though I could not able to access oracle 10G db.If I try to access oracle 10G db through ODBC, then I can able to read and write data into oracle 10G db using RDBMS stage. But I am suspecting whether performance will be good if I use...
by ksenthilvel
Mon Apr 04, 2005 3:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Connecting to Oracle 10G Data Base.
Replies: 5
Views: 3000

Error Connecting to Oracle 10G Data Base.

Hi, We are using DataStage 7.5 PX and Oracle 10G Data Base. Both are installed in same unix box. When we are trying to connect to Oracle 10G table in job, it is giving following errors. If we install oracle 8i instead of Oracle 10G , then it is working fine. "main_program: PATH search failure: ...
by ksenthilvel
Fri Dec 10, 2004 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Err insert timestamp value (with Microseconds) into Oracle9i
Replies: 3
Views: 3625

Err insert timestamp value (with Microseconds) into Oracle9i

HI, I need to insert timestamp value (Including microseconds) to Oracle9i DB. The timestamp value to be extracted from DB2. When I try to insert the timestamp value into Oracle table it is accepting only date and time value. The microsecond value is dropped even though I have declared timestamp data...