Search found 53125 matches

by ray.wurlod
Wed Apr 13, 2005 3:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do handle static Hash File corruption?
Replies: 5
Views: 1125

Dealing with hashed file corruption is the same whether the hashed file is static or dynamic. Prevention is better than cure; monitor to ensure they don't go over, say, 1.5GB. Once they do, RESIZE to 64-bit addressing, and question why they're so large. Monitor disk space; set alarms to send email a...
by ray.wurlod
Wed Apr 13, 2005 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Monitor Status Mesage
Replies: 1
Views: 1020

It can also mean that someone has cleared the job's status file.
This is the hashed file (RT_STATUSnnn) in the Repository from which Director gets the status.
by ray.wurlod
Wed Apr 13, 2005 2:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compare string
Replies: 10
Views: 2842

The cost of QualityStage is probably less than the nine months worth of salaries they've already spent (wasted?). :roll:
by ray.wurlod
Wed Apr 13, 2005 2:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Split file to respect limit of records
Replies: 3
Views: 1689

Even though you're on Windows, Isabelle, there's no reason not to use UNIX utilities. By installing software such as MKS Toolkit you get robust, tested, Windows-based UNIX utilities. (There are also free and shareware versions out there; a search on Google should find them for you.)
by ray.wurlod
Wed Apr 13, 2005 2:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key generator
Replies: 5
Views: 3016

Small pedantic point. Surrogate keys don't need to be a sequence of numbers, they don't even have to be numbers; all they have to be is unique within the table. It happens that generating a sequence of integers is the easiest way to achieve this, and that integers are maximally efficient for joins. ...
by ray.wurlod
Wed Apr 13, 2005 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Diff between OCI, ODBC and Oracle Enterprise Stages
Replies: 2
Views: 2094

$DATABASE Enterprise stage is the stage that connects to that database and runs in Enterprise Edition (that is, parallel jobs). OCI is a stage type that uses the Oracle Client Interface software to connect to Oracle. ODBC is a stage type that uses an ODBC driver to connect to a data source. You nee...
by ray.wurlod
Wed Apr 13, 2005 2:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Very Interesting Bugs...
Replies: 3
Views: 1408

Don't you somehow think that "drop = FALSE" means "keep"?
by ray.wurlod
Wed Apr 13, 2005 4:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compare string
Replies: 10
Views: 2842

QualityStage is what you really need for name and address matching. It's the main thing that QualityStage does. Standardizing within QualityStage puts tokens into appropriate "buckets", such as lastname, firstname, title, generation (senior, junior, III, etc), streetname, streettype (ST, RD, Ave, et...
by ray.wurlod
Wed Apr 13, 2005 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does Partioning and Parallel Processing go hand in hand
Replies: 3
Views: 1371

Parallel processing (of which data partitioning is one example) can also overload a system and therefore result in decreased performance. You have to be careful not to demand more resources than can be delivered.
by ray.wurlod
Tue Apr 12, 2005 6:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQFILE
Replies: 4
Views: 1017

No problem, set up your output constraints to take the extra condition into account.
by ray.wurlod
Tue Apr 12, 2005 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Upgrade Path
Replies: 2
Views: 991

Only the clients can "co-exist". And, even then, only one can be active at any one time. You can switch between them. While you can install both versions of the server, without a substantial amount of tweaking (for example changing the naming rules for shared memory segments) only one can run at any...
by ray.wurlod
Tue Apr 12, 2005 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating file dynamically
Replies: 8
Views: 2509

Create the routine in the routines branch of the repository. You will need to learn some BASIC statements, among them the ones for working with files in sequential mode: OpenSeq WeofSeq and/or Seek WriteSeq CloseSeq Search the forum. Read on-line help and the DataStage BASIC manual. Post again if yo...
by ray.wurlod
Tue Apr 12, 2005 3:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: clear version control log
Replies: 4
Views: 1033

Simply edit the long description field (job properties) and remove those lines.
by ray.wurlod
Tue Apr 12, 2005 3:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Information about activities in DataStage
Replies: 10
Views: 2586

Did you notice that there's been no response from Editor, even though you posted on the Editor's Corner forum? Editor just doesn't have the technical knowledge you have ascribed to him! The reason Arnd posted the column definitions for DS_AUDIT is that they can't be imported; they, like all Reposito...
by ray.wurlod
Tue Apr 12, 2005 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: clear version control log
Replies: 4
Views: 1033

Can you be more specific about what you mean by the "version control log"? For example, are you referring to the version information added to the long description by Version Control when promoting, or some other log?