Search found 53125 matches

by ray.wurlod
Wed May 05, 2010 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DRS Stage
Replies: 1
Views: 1861

Curiously you are not the first to have encountered this message. Did you Search DSXchange before posting your question?
by ray.wurlod
Wed May 05, 2010 4:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error when starting DS engine.
Replies: 14
Views: 8006

Are you starting as root or as dsadm?
by ray.wurlod
Wed May 05, 2010 4:32 pm
Forum: General
Topic: libvmdsapi.so: open failed Error
Replies: 4
Views: 3744

Find where libvmdsapi.so is on your system. Make sure its parent directory exists in LD_LIBRARY_PATH. What permissions obtain for both libvmdsapi.so and the directories in its pathname?
by ray.wurlod
Wed May 05, 2010 4:29 pm
Forum: General
Topic: Managing repository
Replies: 10
Views: 2894

Well, the repository is "open", so you can investigate in the same way that any of us can. Start, for example, by examining the system table that contains the names of tables in the XMETA database, then generate the column names, etc., for those tables that are of interest.
by ray.wurlod
Wed May 05, 2010 4:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server is not responding
Replies: 4
Views: 1661

No.

Look in SystemOut.log and SystemErr.log for starters, as well as startServer.log.
by ray.wurlod
Tue May 04, 2010 10:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server is not responding
Replies: 4
Views: 1661

WebSphere Application Server
ASB Agent
by ray.wurlod
Tue May 04, 2010 9:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeated Warning in a job
Replies: 6
Views: 3525

That's one of those almost impossible-to-eliminate alerts where you can, if you're confident of the rigour of your job design, demote using a message handler.
by ray.wurlod
Tue May 04, 2010 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeated Warning in a job
Replies: 6
Views: 3525

Somewhere in the job stream there is an implied conversion from uint32 to string (not ustring to string). Find it and manage it.
by ray.wurlod
Tue May 04, 2010 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Grid
Replies: 3
Views: 2503

When IBM services installed the grid enablement kit, they would have provided training and documentation about how to use the grid. It is not just parameters; there are changes to sequential file and Data Set management too.
by ray.wurlod
Tue May 04, 2010 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: odbctrace.out growing Drastically
Replies: 5
Views: 2518

There is a switch for ODBC tracing in .odbc.ini. You don't need to trace unless you're diagnosing a problem.
by ray.wurlod
Tue May 04, 2010 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help in building the logic
Replies: 2
Views: 1549

Basically the approach that Sainath suggested, plus you can use the MONTH.LAST transform to generate the date of the last day of a month. You can do that in a User Variables activity or directly in the expression the provides the value to the job parameter.
by ray.wurlod
Tue May 04, 2010 4:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find/List number of Jobs ran on a Particular Day
Replies: 7
Views: 2923

Open Director to Status view. In View menu disable display of categories. Click on run date column to sort by this column. Voila!
by ray.wurlod
Tue May 04, 2010 4:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert & into AND
Replies: 5
Views: 1595

Presumably this is an isolated ampersand, one with space either side of it. Or will you have strings like Abbott&Costello - and, in that case, what is your rule for dealing with it? Check out the parallel version of Ereplace() (search DSXchange for it). It does exactly what you require. But note...
by ray.wurlod
Tue May 04, 2010 4:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Arithmetic Overflow in a Sort stage...
Replies: 2
Views: 3545

Integer data type has a maximum of 10 digits (2^31-1).
BigInt data type has a maximum of 19 digits (2^63-1).
Perhaps you are confusing these with dfloat?
by ray.wurlod
Tue May 04, 2010 4:44 pm
Forum: General
Topic: how to seperate duplicates and unique records from seq file
Replies: 3
Views: 1600

I would use a fork-join design with an Aggregator stage performing a count. Downstream of the Join stage a Filter, Switch or Transformer stage can direct rows with a count of 1 to one stream and other rows to the other stream.