Search found 55 matches
- 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...
- 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
- 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 (...
- 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
- 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
- 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
- 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
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
- 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...
- 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...
- 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). ...
- 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...
- 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
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
- 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
- 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...
- 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