Search found 15603 matches

by ArndW
Mon Oct 19, 2009 2:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file
Replies: 5
Views: 2663

In that case it does sound like the patch listed by Kryt0n is your most likely solution.
by ArndW
Mon Oct 19, 2009 2:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migration from datastage 8.0.1 to 8.1
Replies: 4
Views: 1502

I would still do a full export, remove the old, install the new and then re-import on the new.
by ArndW
Mon Oct 19, 2009 2:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: finding out the jobs/processes running on server
Replies: 9
Views: 2304

It isn't that easy to identify all those processes. One way would be to do a "ps -ef | grep phantom" which will show the parent processes of started jobs.
by ArndW
Mon Oct 19, 2009 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Combining two column values in to a Singe Column
Replies: 11
Views: 2281

This could be done by using a transform stage and stage variables. Store the last Col1 value in a stage variable, when it changes for a new row then output a string "{NewValue}:CHAR(13):Char(10):{Col2}" otherwise just output the contents of Col2. The output of the transform stage must go t...
by ArndW
Mon Oct 19, 2009 2:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migration from datastage 8.0.1 to 8.1
Replies: 4
Views: 1502

It sounds like you have 2 separate machines; in that case a simple export from the old and subsequent import into the new project should not cause any problems.
by ArndW
Sun Oct 18, 2009 6:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ds Naming convensions
Replies: 4
Views: 1533

Take a look at this DataStage Wiki page for some history on DataStage and it's nomenclature.
by ArndW
Sun Oct 18, 2009 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change of IP address after installation of 8.1 DS on AIX mc
Replies: 6
Views: 1731

While I haven't experimented with version 8 configurations as much, at Versions 7 and before the critical issue was not the actual IP address but the hostname of the DataStage server, which could not be changed after installation, since that name is hardcoded at installation time in several places. ...
by ArndW
Sun Oct 18, 2009 6:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to open a job which is opened by some one else?
Replies: 3
Views: 1415

Only one person can edit a job at time and be able to save it. You will need to wait for the other person to close their copy before you can make any changes to it.
by ArndW
Sun Oct 18, 2009 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Compiling problem
Replies: 4
Views: 3445

While I don't have a Windows 8.1 installation, it might speed things up if you could post your DSParams values for the compiler switches to this thread, that way anyone with the same software version can compare to see if the error might lie there.
by ArndW
Sun Oct 18, 2009 6:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what is the best practice to load 50Mil+ in HF
Replies: 12
Views: 3884

After the file has been loaded with data, do a "ANALYZE.FILE {YourHashedFile}" from either TCL or from the admin client. Add 10% to your current number of groups and using "PRIME {YourNumber}" to get the next higher prime number and choose that as your MINIMUM.MODULUS value used ...
by ArndW
Sun Oct 18, 2009 6:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with Aggregator stage.
Replies: 3
Views: 1341

Is this a warning message or an error message causing the job to abort? One option you have is to sort your incoming data according to your aggregation group(s).
by ArndW
Sat Oct 17, 2009 6:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exception raised in GCI subroutine
Replies: 4
Views: 1924

Also, could the file be in a remotely mounted location? You can also try to locate what is happening at line 553 by going into TCL or issuing the following command from the admin tool : VLIST DSD_BP DSD_SEQOpen.B the first column is the source line number. Sometimes one can decode the action from th...
by ArndW
Sat Oct 17, 2009 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file
Replies: 5
Views: 2663

It is clear that your actual data format and metadata don't match. Start off with the first field, what is it called, what is the PIC clause for it and have you used a binary or similar editor to compare the actual file contents with your picture clause?
by ArndW
Sat Oct 17, 2009 6:15 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to perform Bulk delete oe optimize delete operation
Replies: 4
Views: 1970

How about partitioning your database according to this key, then a delete operation could involve just removing one or more database partitions.
by ArndW
Fri Oct 16, 2009 10:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset management
Replies: 8
Views: 4516

What happens when you choose a dataset in the window; doesn't it open up the dataset details window?