Search found 124 matches
- Thu Jun 16, 2016 5:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error :Resource temporarily unavailable
- Replies: 3
- Views: 4692
Check your unix settings for items such as nproc, noproc etc. If the process cannot allocate the resources required to start the process, you could encounter something like this. Also, based on the IBM link, be aware that Redhat linux changes the location of nfiles and nofiles. We first setup Redhat...
- Thu Jun 16, 2016 5:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting fastLoad script from Teradata connector
- Replies: 5
- Views: 5931
The Enterprise stage will present the generated BTEQ script for review. We have an enhancement request with IBM that the connector stage be enhanced to support the same functionality as Enterprise stage. The issue is the binaries used are different between Connector and Enterprise stage. Enterprise ...
- Thu Jun 16, 2016 5:28 am
- Forum: General
- Topic: Datastage 11.5 active-active engine tier
- Replies: 5
- Views: 5563
- Thu Jun 16, 2016 4:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Interaction between a Grid and WLM?
- Replies: 5
- Views: 4929
- Mon Aug 25, 2014 2:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Anyway to force job to run on all compute nodes on a grid?
- Replies: 11
- Views: 7343
- Fri Jan 17, 2014 2:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance of Sequential File Stage
- Replies: 7
- Views: 7557
- Fri Jan 17, 2014 2:39 pm
- Forum: General
- Topic: Unable to See Export and Import options on DS Administrator
- Replies: 1
- Views: 2169
- Fri Jan 17, 2014 2:29 pm
- Forum: General
- Topic: Using Greenplum or Pivotal environments with DataStage
- Replies: 0
- Views: 1780
Using Greenplum or Pivotal environments with DataStage
Hi All
I was wondering how many Greenplum / Pivotal users there are working with both DataStage and Greenplum?
I was hoping to exchange war stories and compare uses of the tool.
Regards
Ray D
I was wondering how many Greenplum / Pivotal users there are working with both DataStage and Greenplum?
I was hoping to exchange war stories and compare uses of the tool.
Regards
Ray D
- Mon Apr 22, 2013 3:23 pm
- Forum: General
- Topic: Disable NLS to improve performance
- Replies: 7
- Views: 6064
Disable NLS to improve performance
One of our contractors here believes that if NLS is disabled, we could see upward of a 30% performance improvement. I'm not sure how to test it. We have a performance system and I can set NLS to 0 in uvconfig, but I still have every directory containing the ".NLS" flag. I also have disable...
- Wed Mar 20, 2013 6:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert records from where it last failed
- Replies: 7
- Views: 3962
You don't mention the volume of data and that has a part in designing the solution. You could always create a dataset which contains ONLY KEYS for the data being inserted. When the job loads, load the keys as a lookup and then perform a lookup on the table. If the key exists, ignore the row. If it d...
- Wed Mar 20, 2013 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Split the Huge Data?
- Replies: 9
- Views: 4903
- Wed Dec 19, 2012 2:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Stop jobs on a grid
- Replies: 5
- Views: 3777
I very rarely have problems with the stop on director..... maybe about 5 times. grep for the jobname. You will see the shell executing, then the su to your execution userid, then dsjob command executing. I usually do the following: kill -15 bin/sh So that should be close to the top of the tree. Make...
- Wed Dec 19, 2012 2:18 pm
- Forum: General
- Topic: Px Jobs are importing in uncompiled state
- Replies: 17
- Views: 18056
We have the development teams break up the datastage jobs to a single element in the SCCS and the job must have been compiled in the Development system only, not the QA environment. 1 Datastage component (EE Job, Sequencer, Shell Script, or Parameter set) and it's object is migrated into the system ...
- Wed Dec 19, 2012 2:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Stop jobs on a grid
- Replies: 5
- Views: 3777
Usually just the stop button on the director will stop the job. We do go on a weekly basis looking for osh or osh.exe jobs on all compute nodes and kill lingering processes. Also, we make sure we purge the scratch directory. Many times the tsort will leave a bunch of files on the system. Thanks in a...
- Wed Dec 19, 2012 2:08 pm
- Forum: General
- Topic: Care and feeding of a Datastage environment daily
- Replies: 3
- Views: 2770
Care and feeding of a Datastage environment daily
I am working for a small retail company and we execute over 250k jobs per week on a Datastage grid environment. Outside of the &PH&, searching for hung OSH processes on each compute node, and disabling the monitoring process, are there any weekly maintance tasks that admins are doing out the...