Search found 124 matches

by pneumalin
Thu Jun 22, 2006 8:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append to DataSet - expecting 3 segments, read 4 segments
Replies: 11
Views: 3905

Only one partition# 0 showed up and the NODE name is node1.
We just use the default.apt that is configured to one node only.
by pneumalin
Wed Jun 21, 2006 9:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append to DataSet - expecting 3 segments, read 4 segments
Replies: 11
Views: 3905

Arnold,
I know someone will ask this question, fotgot to mention that in previous update.
I used 1 node only!
Thanks!
by pneumalin
Wed Jun 21, 2006 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append to DataSet - expecting 3 segments, read 4 segments
Replies: 11
Views: 3905

The Job design is very simple. It only contains 3 stages including SourceFile, Transformer and Target DataSet. The job simply uses "append" since it will be called by 6 instances using different source files and appending to the same dataset.
by pneumalin
Wed Jun 21, 2006 8:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append to DataSet - expecting 3 segments, read 4 segments
Replies: 11
Views: 3905

Append to DataSet - expecting 3 segments, read 4 segments

Hi All, Has anyone encountered similar warning message like: opt/bi/datasets/bloomberg/bb_bond_price_FromFile.ds, expecting 2 segments, read 3 segments. I have 6 instances appending to the same dataset concurrently, they finished ok with the above warnings. All the warning message states the same co...
by pneumalin
Tue Jun 13, 2006 2:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Promote warning to fatal error
Replies: 7
Views: 3092

Hi We can demote or supress the warnings but not promote I believe. The easy way is to use a transformer and use the condition abort on 1 row. I have not tried the '-warn 10' , will try that, but was thinking if there is away to make a warning convert into FATAL. Thanks for the inputs. There is alw...
by pneumalin
Wed Apr 12, 2006 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to join Header and Trailer records
Replies: 10
Views: 3638

Sam, Follows the steps: 1. Click on Job Properties of your job 2. Select ExecSH from Before-job Subroutine or After-job Subroutine 3. type "cat filename1 filename2 > filename3 " in input value field. Note: filename can be replace with your JobParamter including the absolute path of the fil...
by pneumalin
Mon Apr 10, 2006 2:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX jobs performing slow
Replies: 11
Views: 6096

MTA,
So the LookUp File Set help you fine tune the job via spliting the Update and Insert stream? Please tell us what has helped you fine tune it, so we can learn from it.
Thanks!
by pneumalin
Tue Apr 04, 2006 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Add Months In DataStage
Replies: 5
Views: 13010

Why don't you create c routine to do it. The time sructure will allow you to do everything about manipulating the date.
by pneumalin
Mon Apr 03, 2006 1:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: More problems with Pesky Floats
Replies: 15
Views: 7688

For performance and Torrent conversion issues

bcarlson, To do buildop is cool, I like your method. But it also raises my curiosity about your statement: "For performance and Torrent conversion issues, we do not use Transforms" Many threads in the forum talk about avoid using Transformer for performance consideration, since there is a ...
by pneumalin
Fri Mar 24, 2006 5:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BASIC routine -> Parallel routine
Replies: 2
Views: 1182

As Ray advised, the SurrogateKey stage should serve the same purpose with your Basic Routine. If you want to migrate it to PX, following my post in "CRC320..." might give you some ideas.
by pneumalin
Thu Mar 23, 2006 9:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CRC32 for a column in Parallel Job
Replies: 15
Views: 5673

Hope my two penny description make sense to you guys: 1. server routine cannot take the .c source, it can only take Basic code to compile and to be used in a Basic transformer. 2. .c source needs to be compiled using External C++ compiler to generate .so in Unix and .dll in Windows, and then copied ...
by pneumalin
Thu Mar 23, 2006 9:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to create a Project with deleted name
Replies: 21
Views: 7952

Arnold, Thanks for the advise. That's a very good advise. I just thought the steps might come in handy when I've done something stupid and no where to go except rebuilding the server or the project. An incident once happens to my environment when I am adding a new project to DS server in Administrat...
by pneumalin
Wed Mar 22, 2006 5:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to create a Project with deleted name
Replies: 21
Views: 7952

Kumar_s,
Could you please post all the steps fix your problem, so we can learn from it.
Thanks!

Please discard my wrong posting on the other thread - Insert new recrod to UV.ACCOUNT. My apology.. :oops:

Pneuma.
by pneumalin
Wed Mar 22, 2006 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to insert into UV.ACCOUNT
Replies: 18
Views: 17089

Kumar_s,
Could you please post again all the steps you have done to fix your problem, so that we can learn from it.
Thanks!

Pneuma.
by pneumalin
Tue Jan 03, 2006 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping in Buildop
Replies: 10
Views: 4751

pneuma, The key for the rules reference table is ColumnNumber and key for the input stream is virtual........which is the column number.......Can u plz give more info on how to go a'bt doing it??? pjsimon, Did you get it resolved yet? If I understand your requirement correctly, I would lookup the r...