Search found 53125 matches

by ray.wurlod
Sat Jan 08, 2011 7:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IS query
Replies: 1
Views: 1098

Parallel jobs can ONLY be run in Information Server. To run parallel jobs you must have DataStage Enterprise Edition licensed. To run server jobs you must have the server engine licensed.
by ray.wurlod
Sat Jan 08, 2011 3:45 pm
Forum: General
Topic: Datastage access
Replies: 10
Views: 2519

Welcome aboard. Where is user dsadm defined (in operating system registry, in Active Directory, in custom internal registry in Information Server)?
by ray.wurlod
Sat Jan 08, 2011 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml records drop while loading into oracle target table
Replies: 11
Views: 2998

Learn patience. You waited less than an hour, and on a weekend. Would your official support provider have responded in under an hour on a weekend?
by ray.wurlod
Sat Jan 08, 2011 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to import DB2 metadata from different server in DS 8.5?
Replies: 1
Views: 1498

Start by configuring connectivity to the remote instance using DB2 client software. Then establish a Data Connection object to record connection parameters you need for that. Use an associated Parameter Set if you like. Then, when using the Connector import wizard, specify that Data Connection. And,...
by ray.wurlod
Sat Jan 08, 2011 3:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe error
Replies: 1
Views: 1372

You don't necessarily need to set a pointer; the pathname of the hashed file will suffice, depending on the option chosen in the Hashed File stage. The error, by the way, is not in UniVerse, it's in your design - you have not properly specified the location of the hashed file. If you believe you nee...
by ray.wurlod
Sat Jan 08, 2011 3:37 pm
Forum: General
Topic: Difference between Cluster & Grid Architecture
Replies: 7
Views: 13883

As far as DataStage is concerned, MPP = cluster, which has a fixed number of machines. A grid has a dynamically variable number of machines, with available resources being managed by some form of grid management software.
by ray.wurlod
Fri Jan 07, 2011 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Schema File
Replies: 7
Views: 8479

It's not a difficult routine to write, provided that your script is in some standard form such as ANSI-compliant SQL.
by ray.wurlod
Fri Jan 07, 2011 4:33 pm
Forum: General
Topic: Migration from IIS 8.1 installation to IIS 8.5
Replies: 11
Views: 8579

The concierge program is to help you with a new migration tool which picks up other things like DSParams values, Information Server and product roles, scripts, and so on.

They (IBM) are possibly releasing this tool to general availability late in 1Q2011.
by ray.wurlod
Fri Jan 07, 2011 4:30 pm
Forum: General
Topic: Difference in Server and Datastage Director Time
Replies: 24
Views: 13108

Ah. My Sys Admin always uses smit (or smitty, usually). Useful to know.
by ray.wurlod
Fri Jan 07, 2011 4:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MONTH & YEAR FROM DATE
Replies: 10
Views: 4131

:oops:

Code: Select all

Right("00":MonthFromDate(InLink.TheDate), 2) : "-" : Right(YearFromDate(InLink.TheDate), 2)
by ray.wurlod
Fri Jan 07, 2011 4:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Errors with Oracle during migration from 7.5 to 8.5
Replies: 1
Views: 3622

A "pin" is the junction between a link and a stage (the analogy is from the way that integrated circuit components plug in to a printed circuit board). Each link, therefore, has two pins. Input pin 0 is the first pin attached to the stage, input pin 1 the second, and so on. Ditto for outpu...
by ray.wurlod
Fri Jan 07, 2011 4:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sporadic Unhandled failure issue
Replies: 5
Views: 5057

ExecCmd_Split returned an exit status of 255. You have "automatically handle failures" selected. The non-zero exit status from the Execute Command activity has caused the sequence to fail, returning the captured exit status. Investigate why the command has returned 255.
by ray.wurlod
Fri Jan 07, 2011 4:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Jobs Running Very Slow
Replies: 12
Views: 10867

Welcome aboard.

So what's suddenly changed in your environment? Hint: "nothing" is clearly not the correct answer.
by ray.wurlod
Fri Jan 07, 2011 4:14 pm
Forum: General
Topic: What are advantages / issues migrating from 8.1 to 8.5?
Replies: 10
Views: 5233

I have just learned of one customer having QualityStage issues after a do-it-yourself upgrade, in particular with the Match Designer test utility, but this customer happily admits that the problem could be between the keyboard and the chair. Will be reviewing their system some time this month.
by ray.wurlod
Fri Jan 07, 2011 4:12 pm
Forum: General
Topic: Send Email as Body
Replies: 3
Views: 3606

The only thing that is possible with the Notification activity is a hard-coded body. To do anything else create a routine that ends up invoking DSSendMail().