Search found 262 matches

by asitagrawal
Wed Mar 07, 2007 3:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs getting stuck
Replies: 18
Views: 5294

As you said, all these functionality can be clubbed in single Transformer. Did you try to break the file and run the job? ... Ok, I agree that the 3 Xmr may be clubbed into 1. Unfortunately the problem is that due the functional reqmt of the job, I cannot split this input file. Also we are doing br...
by asitagrawal
Wed Mar 07, 2007 3:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs getting stuck
Replies: 18
Views: 5294

No, I ll tell u what each Xmr is doing: Xmr_Lines: Matches the 6 key fields Xmr_ifLenEqZero: Checks if any incoming fld ( total there are 67 flds ) has length = 0 or not. If zero then it assign a default value. Xmr_CSFormatLines: Forms the 5 groups, each containg some 13 - 14 flds out of the 67 flds...
by asitagrawal
Wed Mar 07, 2007 2:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs getting stuck
Replies: 18
Views: 5294

yes my server and client are on same machine. I amusing Win 2003 Server EE. The job is running for successfully for 13 Million rows.. I also attempted to run it on a different set of inpu of 30 Million rows, expecting it to crash... but it ran successfully. but if I repeat the test with the , so cal...
by asitagrawal
Tue Mar 06, 2007 10:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs getting stuck
Replies: 18
Views: 5294

Something more:

I also found that:
1) Each Xmr stage had a different PID
2) The PID correspomding to Xmr_Lines was the one for which Page Fault goes high.
by asitagrawal
Tue Mar 06, 2007 10:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs getting stuck
Replies: 18
Views: 5294

Hi, I tried to make few more attempts to resolve the above problem.. This is the Job Design. Job Design Input: Input has 22Million to 30 Million rows of data. One row has some 66 fields. Process: The Input row keys are matched from the Hashed Files and if a lookup is found , it moves to Next and ult...
by asitagrawal
Fri Mar 02, 2007 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in datastage scheduling
Replies: 8
Views: 4392

Can u provide the step by step procedure of how u are scheduling?
by asitagrawal
Fri Mar 02, 2007 9:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs getting stuck
Replies: 18
Views: 5294

Jobs getting stuck

Hi All, My job design has local containers and am running 10 instances of the same job ( after marking Allow multiple instances ). I dont understand a strange behavior, that why the job is getting stuck while processing and also why so much of Page Faults are there ?? http://asit.agrawal.googlepages...
by asitagrawal
Thu Mar 01, 2007 5:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running DOS Commands parallely
Replies: 7
Views: 1718

hey am sorry to change my reply..

still the sequence of execution depends on the sequence of commands separated by '&'.

My target is to break this sequence.
by asitagrawal
Wed Feb 28, 2007 2:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading from a Mainframe Server
Replies: 5
Views: 1324

I am using ConnectDirect . In my case I know what is the structure of the file, so I have specified the metadata accordingly, so same u can do. I am not very comfortable with mainframes, so cannot comment on the metadata specific to the mainframe file. I am dealing with text files. The file to be pr...
by asitagrawal
Wed Feb 28, 2007 2:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running DOS Commands parallely
Replies: 7
Views: 1718

yes, the one DOS command is waiting for the previous one to finish.
by asitagrawal
Wed Feb 28, 2007 11:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find EOF using DataStage
Replies: 9
Views: 6003

Open the file using OpenSeq.
Use SEEK to move the pointer to EOF.

Refer BASIC guide for more details.
by asitagrawal
Wed Feb 28, 2007 11:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading from a Mainframe Server
Replies: 5
Views: 1324

FTP sometimes results in illegal character translation, I am using a different tool , which does the file exchange between Mainframes and my Windows server, which till date, did not report any illegal character translations ( as with FTP ) too. Once the file is on your Windows sever, you can read it...
by asitagrawal
Wed Feb 28, 2007 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RPC daemon
Replies: 7
Views: 2480

Go to Control Panel --> DataStage.

Ensure that DSRPC service is running, else start the service.
by asitagrawal
Wed Feb 28, 2007 10:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running DOS Commands parallely
Replies: 7
Views: 1718

Running DOS Commands parallely

Hi, I have 3 MS-DOS commands, which I want to run in parallel. I approached like this: Created a sequence. Added 3 Command Stages to it and ran the commands. The commands were triggerred in parallel as desired. Due, to some reasons, I need to run the same commands from a routine, so I approached lik...
by asitagrawal
Tue Feb 27, 2007 8:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Appending to a Sequential File
Replies: 5
Views: 1865

Thx a lot...
I think I missed that command..
I used SEEK to shift the pointer to EOF..

and I exaclty wanted the same i.e Appending to an existing file..


Thx a lot to all.. :)