Search found 15603 matches

by ArndW
Thu Jun 14, 2007 2:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Stage
Replies: 9
Views: 2114

Space where? In /tmp or in /dsetlsoft?
by ArndW
Thu Jun 14, 2007 2:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able TO release the locked job
Replies: 11
Views: 3931

Shiva, you are getting this message because the session that was aborted had the job locked and this lock has not been released. There are many ways of releasing this lock and all of them have been described in detail in other posts on this site. The preferred (and documented) method is to use the "...
by ArndW
Thu Jun 14, 2007 1:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able TO release the locked job
Replies: 11
Views: 3931

:P
it looks like membership status for Team_2007 has been a quickly changing dimension.
by ArndW
Wed Jun 13, 2007 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file resource allocation
Replies: 0
Views: 436

Configuration file resource allocation

I am assigning multiple resource disks in a configuration along the lines of: resource scratchdisk "/Disk1/Scratch" {pools ""} resource scratchdisk "/Disk2/Scratch" {pools ""} According to the documentation and prior experience, these will ...
by ArndW
Wed Jun 13, 2007 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: _DS_Shell_ error
Replies: 5
Views: 1564

Aakash - look in the manager routines for this function.
by ArndW
Wed Jun 13, 2007 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove Lookup File Set
Replies: 1
Views: 1213

I would use the UNIX command orchadmin rm OCP_PF_BCP.fs. This will remove the descriptor file and all associated data files.
by ArndW
Wed Jun 13, 2007 3:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation of Enterprise Edition on Windows Server 2003.
Replies: 3
Views: 884

They are all included in the installation. I would recommend looking into the Installation and Configuration
Guide for Supplemental Stages
pdf document
by ArndW
Wed Jun 13, 2007 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Combine Dates
Replies: 11
Views: 2973

Sort your input by all three columns in the order they appear. Create a transform stage which stores the lastKey, MinimumEffDt and MaximumExpDt as stage variables. Put a constraint to output a row only when the Key changes and output the stored values. N.B. You will need to add a dummy row to the in...
by ArndW
Wed Jun 13, 2007 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting DSGetLogSummary in More readable format
Replies: 9
Views: 3911

Use CONVERT(@FM,CHAR(10),YourResultString) to convert all field marks to carriage returns in your returned string.
by ArndW
Wed Jun 13, 2007 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: not valid remote file error from FTP Stage
Replies: 6
Views: 4965

You need to put the ftp:// back in to complete the uri for the PX ftp stage. I had issues in the past as well, and recall that I got it working by testing it out by FTP'ing a local file on the same machine. Could you try that, copying the file from the remote location to your local server and testin...
by ArndW
Wed Jun 13, 2007 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error The configuration does not contain the node !
Replies: 3
Views: 1177

Could you check your job log to make sure you are using the configuration file that you think you are, and also post your config file here? Another method to check is to call orchadmin check at UNIX.
by ArndW
Wed Jun 13, 2007 3:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sample stage output problem
Replies: 11
Views: 2628

The contents of the APT_CONFIG file decide partitioning, not the actual number of CPUs on the machine.
by ArndW
Wed Jun 13, 2007 2:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sample stage output problem
Replies: 11
Views: 2628

I'm afraid I don't understand the question you are asking. The partitioning algorithm plays a role in the distribution of records across nodes, but a sample shouldn't care about how records are distributed.
by ArndW
Wed Jun 13, 2007 2:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sample stage : Sample mode = Percent
Replies: 4
Views: 881

That was not your original question 1 - you will get x% output, but a different set of records each run. 2 - you will get x% output, a different list from (1) but the same list each time you run it. 3 - you will get x% output, a different list from (1) and (2) but the same list each time you run it....
by ArndW
Wed Jun 13, 2007 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Undefined symbol: .DSOpenProjectEx
Replies: 9
Views: 4733

This looks like UNIX and not Windows - which platform are you on? Also, have you compiled and run PX jobs that use transform stages on this machine (this is to ensure that you have the correct compiler installed with all necessary paths set up correctly)?