Search found 53125 matches

by ray.wurlod
Wed Nov 04, 2015 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml stage performance issues
Replies: 4
Views: 2219

You probably could have done that in one job with four partitions (or eight).
by ray.wurlod
Wed Nov 04, 2015 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restart job from the position it failed
Replies: 5
Views: 2338

... but you can usually design that functionality.
by ray.wurlod
Wed Nov 04, 2015 3:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting the error in Webservice stage
Replies: 4
Views: 2355

Those were going to be my next suggestion had the earlier ones proved to be set OK.
by ray.wurlod
Wed Nov 04, 2015 3:37 pm
Forum: General
Topic: Version control in Datastage
Replies: 2
Views: 1665

And to your second question, yes, there is an interface to source code control systems via their Eclipse plug-in and the Information Server Manager client.
by ray.wurlod
Wed Nov 04, 2015 3:36 pm
Forum: General
Topic: Re indexing a datastage project
Replies: 2
Views: 2190

The local DataStage repository is a series of tables, some of which have indexes. Rebuilding those indexes involves dropping the indexes, re-creating and re-populating them from data in the base table.

The DS.REINDEX paragraph (=script) can be used to re-index just a specific table or all tables.
by ray.wurlod
Wed Nov 04, 2015 3:34 pm
Forum: General
Topic: Error executing cleanup_abandoned_locks.sh
Replies: 5
Views: 2269

That you can log in to AIX may be irrelevant. Which user registry does the login and security service for Information Server use?
by ray.wurlod
Wed Nov 04, 2015 3:30 pm
Forum: General
Topic: Messages in Designer / Director
Replies: 6
Views: 2309

Read your log again. It DOES go down. You had a high of 393 on August 19, but only 282 on August 23.
by ray.wurlod
Tue Nov 03, 2015 9:22 pm
Forum: General
Topic: Export latest updated jobs and other items
Replies: 2
Views: 989

Yes. In Designer open Advanced Find. Specify * in the "Name to find" field. Open the "Last modified" option and enter your date range in the "Within a specific period". Open the "Creation" option and enter the same date range. Click Find. In the Results pane s...
by ray.wurlod
Tue Nov 03, 2015 9:18 pm
Forum: General
Topic: Error executing cleanup_abandoned_locks.sh
Replies: 5
Views: 2269

The originating cause is the WSLoginFailedException: it looks like this is not a valid user name or that the password provided with it was not successful. If you are certain that both of those are genuine, research the possibility that the wasds user does not have the role(s) required to run cleanup...
by ray.wurlod
Tue Nov 03, 2015 6:41 pm
Forum: General
Topic: Error executing cleanup_abandoned_locks.sh
Replies: 5
Views: 2269

What is "wasds" on your system?
by ray.wurlod
Tue Nov 03, 2015 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringToDate() Mixed data single digit and double digits
Replies: 1
Views: 916

You did miss something. In particular, the "s" option.

Read about it at http://www-01.ibm.com/support/knowledge ... rmats.html

Example: %(m,s)/%(d,s)/%yyyy
by ray.wurlod
Tue Nov 03, 2015 3:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Soundex issue between Datastage, DB2 and Oracle
Replies: 2
Views: 1043

You can always create your own algorithm.

Some years ago I created a "Soundex" algorithm for Pacific Islands languages, such as Maori, because the standard Soundex did not suit.
by ray.wurlod
Tue Nov 03, 2015 3:12 pm
Forum: General
Topic: Backup Full Datastage Project
Replies: 11
Views: 5459

It's safe most of the time, but TSM can only restore the entire system, not parts of it. For example you would not be able to restore a single job design. There is also a very small chance that TSM will be backing up a structure (such as a hashed file in the internal DataStage repository) while it i...
by ray.wurlod
Mon Nov 02, 2015 4:35 pm
Forum: IBM QualityStage
Topic: Rule set understanding
Replies: 4
Views: 3551

The Business Intelligence fields are typically derived from the input and are likely to be transferred through to final output. The Matching fields are more likely to be used to drive Matching and are unlikely to be transferred through to final output. The five Reporting fields give insight as to ho...