Search found 53125 matches

by ray.wurlod
Tue Jul 08, 2008 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hashed File Limitiations
Replies: 4
Views: 1463

Moderator: please move to server forum

2^(32-1) is the upper limit for 32-bit (2GB)
2^(64-1) is the upper limit for 64-bit

Upper limit for 64-bit is theoretically 9 million TB, but not all operating systems will support files of this size. Most can manage 1 million TB.
by ray.wurlod
Tue Jul 08, 2008 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Director error with a particular folder only
Replies: 8
Views: 2069

How carefully did you look? Did you capture the output (for example using COMO) for later inspection?
by ray.wurlod
Tue Jul 08, 2008 3:15 pm
Forum: General
Topic: unable to log using admin id
Replies: 3
Views: 1428

What error message do you get?
by ray.wurlod
Tue Jul 08, 2008 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: connect remote server
Replies: 4
Views: 987

What do you mean by "connect" in this question?
by ray.wurlod
Tue Jul 08, 2008 3:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing a wrong SAP
Replies: 5
Views: 1144

I guess you have to find out where the IP address is stored as a stage property. I don't have the SAP stages here so can't advise.
by ray.wurlod
Tue Jul 08, 2008 3:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need to include sysdate into the file name
Replies: 2
Views: 863

That is trickier to do on a Windows operating system. You could use a routine from a Routine activity. The following code is generic - it will work on either UNIX or Windows. Error handling has been omitted for clarity. FUNCTION AddDateToFileName(FileName) * Add yyyymmdd between base name an...
by ray.wurlod
Tue Jul 08, 2008 2:57 pm
Forum: General
Topic: Datastage InstallationConfiguration
Replies: 1
Views: 878

Each core is counted as a processor (CPU) for licensing purposes.

There is no recommended approach to the dual- versus quad-core question as far as I am aware.
by ray.wurlod
Tue Jul 08, 2008 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Finding Recordcount
Replies: 3
Views: 925

Aggregator stage. Group by Event_CD and form count.
by ray.wurlod
Tue Jul 08, 2008 6:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: getting the value from an environment variable
Replies: 3
Views: 1317

Investigate using a Parameter Set, in which you can specify different files to be read to provide the values.
by ray.wurlod
Tue Jul 08, 2008 5:12 am
Forum: General
Topic: South Africa
Replies: 3
Views: 1485

South Africa

I plan to be in Johannesburg for a couple of days (probably 13th-15th) in November. I'd like to catch up with anyone who's available to meet. Nothing formal, purely social.
by ray.wurlod
Tue Jul 08, 2008 5:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datajob hang up
Replies: 7
Views: 1842

With $APT_DISABLE_COMBINATION set to False, chances are that the writing and reading are being done in the same process, which leads to a self-deadlock situation in Oracle. You need to force them to be separate processes, perhaps by disabling combinability in just one of the Oracle stages.
by ray.wurlod
Tue Jul 08, 2008 5:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Finding Recordcount
Replies: 3
Views: 925

Welcome aboard. In Director open a new Monitor. You get total link row counts. You also get them reported in the job log. In Monitor you can right click in the background, choose Show Instances, and then expand the tree to view individual partition row counts.
by ray.wurlod
Tue Jul 08, 2008 5:03 am
Forum: General
Topic: Backup of DataStage ver 8
Replies: 4
Views: 2442

If all you want to do is to back up DataStage, take an export of each project, then take a backup of the DataStage server.
by ray.wurlod
Tue Jul 08, 2008 2:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSSetParam warning
Replies: 2
Views: 868

Welcome aboard. You have incorrectly spelled or cased a parameter name. Parameters must match, both in spelling and in case, the actual job parameter as defined. CustId and CustID are different.
by ray.wurlod
Tue Jul 08, 2008 12:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Write failed for Hashed file
Replies: 2
Views: 928

Moderator: please move to server forum

What does Search yield?