Search found 53125 matches

by ray.wurlod
Tue Jun 28, 2016 11:42 pm
Forum: General
Topic: XML Stage - Assembly Editor Fails to open
Replies: 3
Views: 2133

Are the machines configured differently (CPU, memory, etc.)? What other load is there on the DEV machine that does not exist on the SIT environment when you're trying to open the Assembly Editor? How much memory exists in the client machines? Do all machines have the same patch levels? (Check their ...
by ray.wurlod
Tue Jun 28, 2016 11:13 pm
Forum: General
Topic: command to create package/ add items to package
Replies: 5
Views: 3047

Yes, use the istool build package variant.

Details here.
by ray.wurlod
Mon Jun 27, 2016 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restrict rows processed in a job
Replies: 6
Views: 2546

Some more thoughts.

You could build a Custom stage type to encapsulate a Data Set and a Head stage. But operator combination will achieve the same.

Or you could specify a Wrapped stage to effect the same using orchadmin and head commands in a pipeline.
by ray.wurlod
Mon Jun 27, 2016 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restrict rows processed in a job
Replies: 6
Views: 2546

If you compile the job in trace mode (which you set in job properties before compiling) you can then limit the number of rows processed.

A Head, Tail or Sample stage would be more efficient than a Filter stage.

But there is no such thing as a filter condition/WHERE clause on a Data Set.
by ray.wurlod
Mon Jun 27, 2016 4:17 pm
Forum: General
Topic: DataStage Certifications
Replies: 9
Views: 4977

Basically there is a large degree of overlap. As you would expect, the 11.3 certification includes questions about some of the new features in version 11.3.
by ray.wurlod
Fri Jun 24, 2016 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column generators or transformers?
Replies: 6
Views: 2022

You should also research use of the Exceptions stage and the Data Quality console - you may be able to save yourself a lot of work.
by ray.wurlod
Fri Jun 24, 2016 3:16 pm
Forum: General
Topic: Infosphere Event Server Timestamp question
Replies: 7
Views: 1952

You're paying maintenance (which includes support) - why not use it?
by ray.wurlod
Fri Jun 24, 2016 3:16 pm
Forum: General
Topic: Scheduled DataStage job on Windows server does not run
Replies: 10
Views: 3543

Either get yourself set up on the engine (with appropriate group membership) or map your engine credentials to an existing user (that has appropriate group membership).
by ray.wurlod
Fri Jun 24, 2016 3:13 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA Logs
Replies: 3
Views: 3982

Don't forget to set automatic log purge in the ANALYZERPROJECT project.
by ray.wurlod
Thu Jun 23, 2016 9:18 pm
Forum: Enhancement Wish List
Topic: File Connector stage
Replies: 0
Views: 6116

File Connector stage

I've just opened File Connector stage (version 11.3.1.2) for the first time, only to discover that the Help button is disabled.

I notified IBM of this through developerWorks
by ray.wurlod
Thu Jun 23, 2016 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Split file based on Count ..
Replies: 4
Views: 1450

Contemplate using a server job with a Folder stage, or perhaps a Folder stage in a server Shared Container in your parallel job.
by ray.wurlod
Thu Jun 23, 2016 4:31 pm
Forum: General
Topic: Scheduled DataStage job on Windows server does not run
Replies: 10
Views: 3543

Just run as yourself if you're happy to do that. The tab in the Administrator client is there in case you want to use a different user name and password for running scheduled jobs. Note that this possibility only exists when the DataStage engine is running on a Windows server, not when running on UN...
by ray.wurlod
Thu Jun 23, 2016 4:29 pm
Forum: General
Topic: Job sequence failed with unknown reason
Replies: 11
Views: 2895

The PeekHeader parameter is entirely irrelevant to the current question. It is the RecCountx parameters that drive the exercise's intent.
by ray.wurlod
Wed Jun 22, 2016 4:26 pm
Forum: General
Topic: Infosphere Event Server Timestamp question
Replies: 7
Views: 1952

I don't know enough about Event Server to answer the question in that environment. In DataStage parallel job you would specify a timestamp format string that included microseconds, for example

Code: Select all

"%yyyy-%mm-%dd %hh:%nn:%ss.6"
by ray.wurlod
Wed Jun 22, 2016 4:21 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA Logs
Replies: 3
Views: 3982

When you submit jobs, select Retain Scripts. That having been done you will be able to view job logs using the DataStage Director client. The only pertinent logs you'll find in the WebSphere environment are SystemOut.log and SystemErr.log, which log ALL activity from Information Server, and might pr...