Search found 53125 matches

by ray.wurlod
Sun Apr 11, 2010 2:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Information server fail over to other LPAR
Replies: 4
Views: 1967

suman27, DataStage jobs do not fail over. Because of the great use they make of shared memory they can not fail over. In a near future release IBM will be improving the high availability of the services tier, but there's nothing they can do to permit failover of DataStage jobs - with current technol...
by ray.wurlod
Sat Apr 10, 2010 6:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Information server fail over to other LPAR
Replies: 4
Views: 1967

My initial two thoughts were (a) SeqA, SeqB and SeqC are not Sequencers - they are Sequences - and (b) you have not taken the trouble to Search DSXchange for information about job status "Running". My next thought was "what's any of this got to do with failover?" (the subject of ...
by ray.wurlod
Sat Apr 10, 2010 3:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ftp of DataSet
Replies: 2
Views: 1106

... and, given that the pathnames of the segment files are stored in the descriptor file, that the target uses exactly the same pathnames. ... and, given that the configuration file information (which includes node name(s)) is stored in both locations, you may need to be very careful when using the ...
by ray.wurlod
Sat Apr 10, 2010 12:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer stage/stage variables
Replies: 1
Views: 1143

Stage variables are useful if used, wasted if not used. Sort merge collector preserves any existing sorting. If the data are already sorted upstream, then an input link sort is a waste; if the data are not already sorted and you need them sorted, then an input link sort is necessary. If you don't ne...
by ray.wurlod
Fri Apr 09, 2010 6:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error reading Japanese data
Replies: 1
Views: 1113

Japanese data is fraught - there are at least 14 different encodings in which it might be supplied. Your first step will need to be to discover how the data are actually encoded. A common map is SHIFT_JIS but there are even variants of that. You need to ask the providers of the data to be as complet...
by ray.wurlod
Fri Apr 09, 2010 6:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between $ENV and $PROJDEF
Replies: 5
Views: 4576

When a UNIX process runs it runs in a shell in which there are some shell variables and environment variables defined. Exported environment variables are available to any sub-shells invoked from that shell. When you run a DataStage job, your shell starts a number of sub-shells. Some of these run uv,...
by ray.wurlod
Fri Apr 09, 2010 6:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Status code = -14 DSJE_TIMEOUT Error
Replies: 3
Views: 7317

Strange, an exact search for "Status code = -14" got 11 hits, some of which had DSJE_TIMEOUT as well. And if you search for just "-14" got 333 hits and if you search for just "timeout" got 719 hits. What was your search criterion? At least some of these will help you to...
by ray.wurlod
Fri Apr 09, 2010 6:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Changing values of Environmental variables at run time
Replies: 7
Views: 2547

But it remains the case that a running job reads the values when it starts, and will not pick up any changes made while it's running.

So what you want to accomplish must be wrought prior to the job starts.
by ray.wurlod
Fri Apr 09, 2010 6:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Timestamp for DB2 database
Replies: 4
Views: 7488

As with date, a time conversion can specify the delimiter.

Code: Select all

Oconv(@DATE, "D-YMD[4,2,2]") : "-" : Oconv(@TIME, "MTS.") : ".000000"
by ray.wurlod
Fri Apr 09, 2010 6:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC connection failes as dstage group user
Replies: 2
Views: 2103

What are the permissions on /tmp ?
by ray.wurlod
Fri Apr 09, 2010 6:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to reset the value using KeyMgtgetnextvalue()
Replies: 2
Views: 1912

:idea:
Search for UPDATE SDKSequences
by ray.wurlod
Fri Apr 09, 2010 6:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding logic
Replies: 7
Views: 2608

Hashed files ("UniVerse" tables) use WITHIN.
by ray.wurlod
Fri Apr 09, 2010 6:06 pm
Forum: IBM QualityStage
Topic: Compilation Error: Mapping failed to copy attributes
Replies: 8
Views: 6990

Check out the job (or the part of the job) that generates the frequencies. Re-run it, if possible. In particular examine its output for this field name.
by ray.wurlod
Fri Apr 09, 2010 6:04 pm
Forum: IBM QualityStage
Topic: UK Address Standardization
Replies: 10
Views: 5047

Maybe you need to check that CHISWICK really exists, and isn't just a figment of Douglas Adams's imagination?
:lol:
by ray.wurlod
Fri Apr 09, 2010 6:03 pm
Forum: IBM QualityStage
Topic: UK Address Standardization
Replies: 10
Views: 5047

It's not there in version 8 either. (I also note that CLWYD is but CLWYDD is not, so maybe there are other issues with this particular rule set.) Since the GBAREA.PAT does not look up any tables, there does not appear to be any mechanism other than a classification override to handle CHISWICK. Or cr...