DSXchange

Hi,

We are running the dsrpcd daemon as root process. Does this process access the /etc/shadow file?? if not how does it authenticates a user.

Thanks
Aravind

So, is there a way to specify the same??? I mean is there any way to reduce round trips from DS client to/from the db while fetching the data.

Hi,
I am using Oracle Enterprise stage to read data from Oracle database.
Do we have any parameter/Env Variable when we can control the arraysize within datastage relative to select operations to do bulk collects to reduce round trips from DS client to/from the db.

Thanks
Aravind

Hi, Here is the Query. SELECT A.* FROM WORKALOC A, RAWADDRESSTOALOC B, RAWADDRESSATTRIBUTE C WHERE A.SOURCESYSTEMID = C.SOURCESYSTEMID AND A.ADDRESSSOURCEKEY1 = C.ADDRESSSOURCEKEY1 AND A.ADDRESSSOURCEKEY2 = C.ADDRESSSOURCEKEY2 AND A.ADDRESSSOURCEKEY3 = C.ADDRESSSOURCEKEY3 AND B.SOURCEADDRSEQNUM = C....

Hi,
Please let me know how we can use the Oracle Bind variable in Input queries. My DBA is forcing to use a bind variable in input query instead of a job parameter.

Thanks
Aravind

Hi,
I Have a simple job which reads from dataset and updates a table. The dataset has 5000 Rows. The jobs keep on running for ever. I am able to insert and update the records manually into the table.

Any idea what could be the issue.

Thanks
Aravind

Hello All,
I need to capture Job Log for each run in file and store it through a AFTER JOB ROUTINE. If I use DSJOBREPORT, if does not capture Fatal errors and Warnings.

Any ideas and pointers would be appreciated.

Thanks
Aravind

How do we do this???

That is not the case. For example, I have job A with 10 instances (1 to 10). Now, in the director i see the LOGS for only the last 2 runs. ex if has run A.1 and A.2 , i will see it. Now, if A.3 and A.4 are run, i am not able to see the logs of A.1 and A.2.

Thats is what I do. Each has its own invocatio id.

Hello, I have a sequencer which is multi instanced. At any point of time 10 instances of that will be running. Now I see that If a particular instance fails, I am unable to view the log of it. It is being over written by other instances. Is there any way to set that the log is not over written by ot...

Hi, Any solution for this issue??? Even I am facing the same issue. Thanks Aravind Hi , I am getting a datastage error in creating a copy to a job .The eror message is as below : Unable to create a copy of the object Unable to get Eobject . This error message is displayed in designer ( GUI ) when cr...

One simple Solutopn. Insert the source records into a database if they come from other source, and do a database join. Hi Experts: Env : DS8.1, Unix, Oracle in PX My Lookup database having 300 Million Records, incoming file having 100 K to 500 K records, it needs to perform database lookup , if matc...

Hi, My tera data Enterprise stage produces 140 Million records. I need these records to be sorted while the records are processed by the next stage. If I sort in datastage, it is not a good option to sort 140 Million records. So, I am planning to sort in the database stage. But the sorting oredr wil...

Hi,
This cab be achieved through costomised buildop stage.

Thanks
MAKREDDY