Search found 55 matches

by sudharma
Thu Feb 22, 2007 1:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is a Sparse Lookup in DataStage EE?
Replies: 15
Views: 37468

Hi Sami, this is what i have found in help. hope this can hint you Lookup Type. Where the DB2 stage is connected to a Lookup stage via a reference link, this property specifies whether the DB2 stage will provide data for an in-memory look up (Lookup Type = Normal) or whether the lookup will access t...
by sudharma
Wed Feb 21, 2007 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Issue
Replies: 3
Views: 1006

hie kumar ,

i am using a wait for file activity in my sequence . I use the Execute command activity to delete the ABC.txt so that when i get a second set of files to run , the ABC.txt comes again with the set set of file polls.

thanks
sudharma
by sudharma
Wed Feb 21, 2007 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Issue
Replies: 3
Views: 1006

Sequence Issue

Hi Everyone, I have a Job Sequence which waits for a file (ABC.txt)and then the Sequence Begins to run. Some files are processed and then they are deleted (i used a command execution Activity ) and then the job Sequence is called again. This Process Goes on with with a timeout length of 30 minutes (...
by sudharma
Thu Feb 15, 2007 2:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File pattern warning in Sequential file
Replies: 9
Views: 2074

You can also use a wait for file activity and specify some time so that the sequence can wait for the file to appear in some specific path or location.

can you tell me clearly how your job has to run?? are the files polled on a regular basis ??

thanks
Sudharma
by sudharma
Wed Feb 14, 2007 1:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Lookup Failure
Replies: 3
Views: 1290

Arnd,

i really dont know how big is that file ( the user limit setting) how do u get there to set the user limitations on that file ??

please let me know

thanks
by sudharma
Wed Feb 14, 2007 12:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Lookup Failure
Replies: 3
Views: 1290

DB2 Lookup Failure

Hi Everyone, I have a DB2 Lookup Table which has 12 Million rows in it. When i run this job , the job is getting aborted ( the error says ERROR WRITING TABLE FILE /the path name /lookuptable.20070214.o2ylidd": File too large. ) can anyone give me a hint on this for a possible solution. thanks
by sudharma
Mon Feb 12, 2007 8:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Nodes in Parallel Extender
Replies: 3
Views: 826

Nodes in Parallel Extender

Hi Everyone,

Can i have odd number of nodes ( 3 or 5 or 7 ...). or the nodes should always be even ( 2 or 4 or 6 ....)

Please clarify

Thanks
Sudharma
by sudharma
Fri Feb 09, 2007 11:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy Stage - Invalid Derivation For Output Column
Replies: 1
Views: 2997

Copy Stage - Invalid Derivation For Output Column

Hi Everyone , I am trying to do a lookup on a DB2 Table ( only on two columns), then i have a copy stage and then the copy stage has two links. DB2 ---->Copy Statge------>then two lookup links I get an Error in the copy stage that ( Invalid Derivation For OutputColumn (ColumnName)). i get the same e...
by sudharma
Mon Feb 05, 2007 2:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete files after the job is run
Replies: 4
Views: 1296

Hi Everyone , My Problem here is , there is a continious flow of files into the specified path , so that these files are picked by the DataStage job and then they are processed. the file names look like this 0123456.tld.488 9654741.tld.569 i still cant think , how can i delete the files which are pr...
by sudharma
Mon Feb 05, 2007 2:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete files after the job is run
Replies: 4
Views: 1296

Delete files after the job is run

hi Everyone , I have a Scenario where my job runs at regular intervals between 4 am to 10 am. Let us say if the job is running at 4 am, processing 100 files and the job ends running at 4.10 and it has processed all the 100 files. now , i have to delete the files which the job processed (100 files). ...
by sudharma
Wed Jan 31, 2007 1:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential files Backup with a timestamp
Replies: 3
Views: 1544

Sequential files Backup with a timestamp

Hi Everyone , I have a job which writes rejected data into 3 different sequential files in three different reject links. Every time i run this job , there is some rejected data getting inside these sequential files. I have to make a copy of these sequential files each and everytime the job runs. one...
by sudharma
Tue Jan 30, 2007 11:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHESTRATE step execution terminating
Replies: 1
Views: 1204

ORCHESTRATE step execution terminating

Hi everyone,

i get this error when i run a job

main_program: ORCHESTRATE step execution terminating due to SIGINT

can anyone brief me about this error.

thanks
by sudharma
Tue Jan 30, 2007 11:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Validating Export Schema Error
Replies: 2
Views: 1370

Thank you so much Brad
by sudharma
Tue Jan 30, 2007 10:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Validating Export Schema Error
Replies: 2
Views: 1370

Validating Export Schema Error

Hi Everyone , I get this Error when i run my job. seq_Order: When checking operator: When validating export schema: At field "filedname": "null_field" length ( 0 ) must match field's fixed width (8 ) can anyone suggest me how to resolve this issue. i dont understand what it means...
by sudharma
Mon Jan 29, 2007 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OLE SERVER CONNECTIVITY
Replies: 5
Views: 3411

Hi everyone ,

i tried to re install the client and the issue is resolved.

thanks a lot for your replies

thank you