Search found 53125 matches

by ray.wurlod
Thu Apr 28, 2011 1:50 am
Forum: General
Topic: Project Level Auto Purge
Replies: 13
Views: 7233

If there's no \\PURGE.SETTINGS entry it's enabled as per the project default. If there is a \\PURGE.SETTINGS entry then you have to review that entry to establish whether auto-purge is enabled for that particular job.
by ray.wurlod
Thu Apr 28, 2011 1:48 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Import Table Definition from Lotus Notes (Domino)
Replies: 2
Views: 1850

Details!!! Convert which file? Convert it how? How will that enable import of table definition?

Clearly in the five months since this was posted no-one has come up with a solution. Dare I suggest that neither have you?
by ray.wurlod
Thu Apr 28, 2011 1:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Partitioning sort and Sort Stage
Replies: 5
Views: 3224

Re: Partitioning sort and Sort Stage

Sampath wrote:Your using sort stage so i will use tem are for operaction so you should check space and your using NFS mount point so and problem in connection check it.
I just don't understand this answer at all! Does anyone?
by ray.wurlod
Thu Apr 28, 2011 1:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Partitioning sort and Sort Stage
Replies: 5
Views: 3224

Unless you specifically set the memory property in the Sort stage it uses exactly the same amount of memory as the input link sort (set by the environment variable APT_TSORT_STRESS_BLOCKSIZE). So one of your theories bites the dust!

Wherever possible always use local disk for scratch.
by ray.wurlod
Thu Apr 28, 2011 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing value from buildop back to job
Replies: 3
Views: 1841

A Build stage can transfer rows to its output. That is what it does. Perhaps you can put a special value onto one field on the output?
by ray.wurlod
Thu Apr 28, 2011 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data file having header and taielr. Want to read the file wi
Replies: 7
Views: 5422

Re: Data file having header and taielr. Want to read the fil

Sampath wrote:Use UNIX command before us the file
sed "1d;\$d" <FileName>

It will remove the header and trailer records from file
What if they need the contents of the header and trailer?

Very poor advice, in my opinion.
by ray.wurlod
Thu Apr 28, 2011 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: upsert is taking long time
Replies: 4
Views: 2193

What's the point of buying a parallel execution engine then?!!!!
Sampath wrote:Use loading as sequential method
Extremely poor advice, in my opinion.
by ray.wurlod
Thu Apr 28, 2011 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mismatches in job executables
Replies: 3
Views: 1294

These jobs are functionally identical.

Curiously enough, I can't bring to mind what the [] in the link (data set) definition means, but I can recall that, if it's empty, there's no additional operation there.
by ray.wurlod
Thu Apr 28, 2011 1:35 am
Forum: Site/Forum
Topic: white papers too good.
Replies: 8
Views: 5709

One of the reasons that the white papers faded a bit was that DSXchange obtained technology that enabled webinars and training DVDs to be created. Would you prefer one of these formats?
by ray.wurlod
Thu Apr 28, 2011 12:35 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Connector drop-down empty when configuring Data Store
Replies: 7
Views: 3222

Using the Connector import wizard does not create a Data Connection definition unless you click the Save option during the process. Do you have any Data Connection objects? (These are not the same as Connector objects.)
by ray.wurlod
Wed Apr 27, 2011 10:38 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Connector drop-down empty when configuring Data Store
Replies: 7
Views: 3222

Have you created any Data Connection definitions (for example in DataStage)?
by ray.wurlod
Wed Apr 27, 2011 10:38 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Migrating Information Analyzer objects to v8.5
Replies: 10
Views: 5132

IADB is a database - it doesn't migrate anything. It may be the case that Information Server Manager was not installed in your client.
by ray.wurlod
Wed Apr 27, 2011 6:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in operator in Transformer
Replies: 3
Views: 1345

Is your Search function broken?

Assuming that the value being sought is a single character called TheCode then a suitable expression would be

Code: Select all

Index("1234", InLink.TheCode, 1)
by ray.wurlod
Wed Apr 27, 2011 6:16 pm
Forum: General
Topic: Export user credentials
Replies: 2
Views: 1362

None that I know of. The Migration Assistant that comes with 8.5 can (I believe) work with 8.1 but nothing older. Might be worth checking with your support provider. They may have a tool.
by ray.wurlod
Wed Apr 27, 2011 6:15 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Migrating Information Analyzer objects to v8.5
Replies: 10
Views: 5132

Information Server Manager been around since at least 7.5. Can't be sure about its command line interface istool but that's definitely in 8.0.1.