Search found 99 matches
- Thu Mar 13, 2014 5:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No ORA messages in Datastage 8.5
- Replies: 3
- Views: 2437
We can read and insert and update data without any problems, but if we have for instance space issue in one partition, then it fails with this type of statement SQL Failed And just repreats the SQL-code send to DB. If we try the same using pure SQL in for instance sqlplus or toad then we get the ORA...
- Thu Mar 13, 2014 2:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No ORA messages in Datastage 8.5
- Replies: 3
- Views: 2437
No ORA messages in Datastage 8.5
Hi, I have a strange problem, most likely, caused by some environment property that I do not know. We are trying to switch from DB2 to Oracle 11g. We configured dsenv to use a Oracle Client 10 and Oracle Connector Stage variant 10 and it worked and returned ORA messages in the director log as expect...
- Wed Sep 30, 2009 4:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse Look Up on DB2 UDB on Mainframes in PX
- Replies: 4
- Views: 2390
- Tue Sep 22, 2009 12:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can DB2 Enterprise Stage be used in Heterogeneous Env
- Replies: 1
- Views: 1460
As far as I know and understand this... (I have only been utilizing DB2 and DB2EE-stages in heterogeneous environments) When using the DB2EE-stage and plain user-defined SQL; At runtime the DB2EE-stage will operate in sequential mode and thereby operating via the client. This part works in theory wi...
- Fri Sep 11, 2009 5:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partitioning in SMP
- Replies: 8
- Views: 4889
DataSet [ 5.5 mil records, 250 fields] | | Sequential file --> Lookup --> Transfomer --> Filter ----> Funnel --> Dataset [1 record, [9 links out 2 fields] from filter] I would suggest flipping this job so you can enable streaming of data. This approach needs to buffer all 5.5 million lookup records...
- Wed Sep 09, 2009 1:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to read data from DB2 Enterprise Edtion Stage
- Replies: 10
- Views: 9027
- Thu Sep 03, 2009 5:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server v. 7.5.x to Informational Server v 8.1
- Replies: 5
- Views: 2689
- Thu Sep 03, 2009 2:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server v. 7.5.x to Informational Server v 8.1
- Replies: 5
- Views: 2689
Is there anything to gain by being connected to the new repository? Maybe some new functionality is available? Metadata benefits etc... The plan is to slowly transition some jobs to parallel were needed, and IBM demands us to upgrade to 8.1, which costs a lot more than the license we are using curre...
- Thu Sep 03, 2009 12:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server v. 7.5.x to Informational Server v 8.1
- Replies: 5
- Views: 2689
Server v. 7.5.x to Informational Server v 8.1
Hi, I would like to know if anyone has had any experience with a Datastage Server Edition upgrade/migration to Informational Server, not converting jobs to parallel... Is it a simple operation or are there any types of jobs that doesn't run on 8.1 without re-programming. I know its a touch question ...
- Wed Sep 02, 2009 4:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to read data from DB2 Enterprise Edtion Stage
- Replies: 10
- Views: 9027
You have to have the px engine library available on the remote db2 machine (and or db2 nodes) and the ability to connect to that machine using rsh or ssh (using remsh.sh in ds-lib) if you wish to use the db2 enterprise stage. Furthermore the os and hardware of those platforms need to match.... The A...
- Tue Sep 01, 2009 6:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem in reading the Excel data with sequential file
- Replies: 10
- Views: 6588
If it is indeed a csv or skv or any -separated file, then your problem probably is on the last or second last column if the last column is empty. Some versions of Excel seems to export data skipping empty fields at the end. This means that datastage will find an early end marker and skip or reject t...
- Thu Aug 20, 2009 12:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read a text file of 5GB
- Replies: 24
- Views: 11482
tested it after the post a couple of weeks(running 8) the restriction is still there. But perhaps I didn't get it quite right: (A) One can define multiple readers on a single node with variable lenght records. I played around today and see that one can increase read speed by specifying multiple rea...
- Mon Aug 17, 2009 3:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read a text file of 5GB
- Replies: 24
- Views: 11482
Rajee, Try what ArndW is saying How many columns does the file have and how long does it take to read the file when the only other stage in your job is a copy stage (or a peek stage)? To see how long the actual file reader stage executes. If it is indeed 35 min then you know for sure that the sff-st...
- Mon Aug 17, 2009 2:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read a text file of 5GB
- Replies: 24
- Views: 11482
Depending on your datastage version you can improve performance (with varied results) based on how your file is structured using sequential file stage by setting the following properties in it. Read From Multiple Nodes = Yes or Number of Readers Per Node = N Furthermore, your performance is also dep...
- Mon Jun 15, 2009 1:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration File issue,Configuring DB2 EE stage
- Replies: 9
- Views: 9680