Search found 53125 matches

by ray.wurlod
Mon Apr 18, 2011 12:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsrpcd log information
Replies: 3
Views: 1912

You can have a log if you like, by changing the startup characteristics of dsrpcd. But this process VERY rarely has issues. Log is used primarily for troubleshooting - otherwise it is just another way to fill your disk.
by ray.wurlod
Sun Apr 17, 2011 5:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsrpcd log information
Replies: 3
Views: 1912

Wherever you ask it to be created. Typically, and by default, it's not created.
by ray.wurlod
Sat Apr 16, 2011 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need help on this
Replies: 9
Views: 3301

I think I know what the rule is, but will await the original poster's response.

A meaningful subject line would have been good, too.
by ray.wurlod
Sat Apr 16, 2011 4:15 pm
Forum: General
Topic: Extracting files from unix
Replies: 24
Views: 6198

Are you giving this expression as the file name or as the filter command?
by ray.wurlod
Sat Apr 16, 2011 4:14 pm
Forum: General
Topic: DataStage VS Oracle Data Integrator ---- DS Vs ODI
Replies: 2
Views: 5679

DataStage has a far richer range of connectivity options and transformation capabilities than does ODI. Its graphical user interface is, to my mind, easier to use, understand and maintain than the ODI one. Finally, in DataStage one does not need to become an expert in the use of PL/SQL scripting (or...
by ray.wurlod
Sat Apr 16, 2011 4:12 pm
Forum: General
Topic: Client Install Error. ASB node. . .
Replies: 5
Views: 4395

What other diagnostic information was generated? What's in the install log, for example?
by ray.wurlod
Sat Apr 16, 2011 4:11 pm
Forum: General
Topic: JobLinkStatistics & ResurrectLog File
Replies: 5
Views: 1911

Wrong on so many counts. JobLinkStatistics is something written at your site, therefore we can't comment on it other than by surmise. The same is true of the other parameter ResurrectLogFile. The dsjob command with -jobstatus option returns the return status of the job, which you can find documented...
by ray.wurlod
Sat Apr 16, 2011 4:07 pm
Forum: General
Topic: Regarding dsapi_slave and dscs UNIX processes
Replies: 5
Views: 3457

A client connecting to a DataStage engine engages the DataStage RPC mechanism requesting a process running the dscs (DataStage common service). This is looked up in the dsrpcservices file and the relevant executable (dsapi_server) started as the agent process of that particular client connection. Am...
by ray.wurlod
Fri Apr 15, 2011 4:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage server job
Replies: 1
Views: 1372

The Merge stage in server jobs reads two files, the pathnames of which are given in the stage properties itself. The stage type does not support inputs.

So, what are you trying to accomplish?
by ray.wurlod
Fri Apr 15, 2011 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resource Estimates for Scratch and Resource Disk
Replies: 5
Views: 3264

Use the DataStage resource estimation tool.
by ray.wurlod
Fri Apr 15, 2011 3:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract data using ODBC stage using sequential file
Replies: 5
Views: 2274

Welcome aboard. You don't want to select in your target. You need a design like ODBC | V SeqFile ---> Transformer ---> whatever Let DataStage generate the SQL in the ODBC stage. Mark the column that has to be in the WHERE clause as "Key".
by ray.wurlod
Fri Apr 15, 2011 3:49 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA Job fails with Unable to validate DSOptions
Replies: 3
Views: 3163

Are you using a static user name for executing DataStage jobs in ANALYZERPROJECT project? If so, ensure that a valid user name and password are provided in this frame. Also check that the DataStage credentials are correct for the engine tier on which this project resides.
by ray.wurlod
Fri Apr 15, 2011 3:48 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Error Executing DS Job
Replies: 2
Views: 2638

Correct forum. This message comes up when you attempt to validate the analysis engine settings in Information Analyzer either the global ones in the Home pillar menu or in the Project Properties workspace for a particular project. It's usually caused by the user ID being incorrect. Are you using a s...
by ray.wurlod
Thu Apr 14, 2011 11:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: yydddffhhnnss format
Replies: 1
Views: 1316

For the date portion use a format string of "%yy%ddd". You're on the right track.
by ray.wurlod
Thu Apr 14, 2011 11:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata password issue
Replies: 5
Views: 3375

Do you have $, # or _ character in your password?