Search found 53125 matches

by ray.wurlod
Mon Dec 01, 2008 2:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage PX DB2 stage varchar length
Replies: 1
Views: 1349

That's something you will need to check with your DBA. Typically VarChar data are stored with a length designator then an unpadded string, though some databases do pad the string to a whole word boundary.
by ray.wurlod
Mon Dec 01, 2008 2:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Apt_Communicator
Replies: 1
Views: 965

The APT_Communicator class is used by player process to exchange data between partitions. It appears to be having a problem with the /tmp directory. Do you have a C:\tmp folder (or D:\tmp if that's where you've installed DataStage server)?
by ray.wurlod
Mon Dec 01, 2008 2:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performances of the jobs
Replies: 7
Views: 1832

Does this "set" of jobs contain 1428 jobs?

Despite popular belief, DataStage server machines can not deliver an infinite supply of resources.
by ray.wurlod
Mon Dec 01, 2008 2:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS server installation running on windows Advanced Server
Replies: 2
Views: 840

Go to the IBM website or ask your official support provider about which operating systems are supported.
by ray.wurlod
Mon Dec 01, 2008 2:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage PX Log File
Replies: 2
Views: 884

And yes in any case. While what you say (that a fatal error means that the job must finish with Aborted status) is true for server jobs, it is not true for parallel jobs. You need to inspect the "fatal" messages more carefully, having particular regard to the node and operator that generat...
by ray.wurlod
Mon Dec 01, 2008 2:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File error
Replies: 2
Views: 845

... or use the Display button in the data browser to limit the fields that you are selecting to display.
by ray.wurlod
Mon Dec 01, 2008 2:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL DSN Not working
Replies: 2
Views: 1445

"No configuration file" in the error message suggests that the .odbc.ini file can not be found. Is your ODBCINI environment variable set?
by ray.wurlod
Sun Nov 30, 2008 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Bulk Load Job failing
Replies: 9
Views: 2686

You have specified a pathname in the "Directory for Data and Command Files" property in your bulk load stage but either this directory does not exist or the executing user does not have permission to create the control and data files therein.
by ray.wurlod
Sun Nov 30, 2008 11:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number Calculation
Replies: 6
Views: 1562

The example and the text are incompatible. I would expect something like:

Code: Select all

Input:    11100111000110
Zeroes:   00000200000300
Output:   11100311000410
by ray.wurlod
Sun Nov 30, 2008 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot read large number value
Replies: 7
Views: 2032

Go bigger. Try Decimal(48,10).
by ray.wurlod
Sun Nov 30, 2008 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capture reject records from log
Replies: 2
Views: 1089

There is a special type of log event generated if a reject-handling link processes any rows. You can use DSGetNewestLogId() or dsjob -lognewest to search for this kind of log event specifically.
by ray.wurlod
Sat Nov 29, 2008 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Sequential File is Parallel
Replies: 6
Views: 7200

Ah, read FROM multiple nodes.

In that case the answer to your question 2 is "yes", provided that all the nodes can see the large file.
by ray.wurlod
Sat Nov 29, 2008 3:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can a mail be generated reporting that the server is down?
Replies: 5
Views: 1466

The best command to issue to determine whether the DataStage server is running is shrdump - build that into the BAT file you schedule from AT.
by ray.wurlod
Sat Nov 29, 2008 3:13 pm
Forum: General
Topic: transformer stage error
Replies: 2
Views: 1043

What would you do if you were working in Linux (no DataStage involved) and it said "sh not found"? Do the same in this case. Hint: check your PATH environment variable.
by ray.wurlod
Fri Nov 28, 2008 9:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to assign user for Datastage Administrator
Replies: 1
Views: 696

In version 7 and earlier the dsadm user is the DataStage administrator. On Windows any member of the Administrators group is also a DataStage administrator.