Search found 53125 matches

by ray.wurlod
Wed Feb 03, 2010 3:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Through File set can we retrive multiple files ?
Replies: 2
Views: 1497

Not through File Set stage (unless you're particularly devious about file names and locations and can construct a File Set descriptor file). Use a Sequential File stage with multiple File properties and, if you wish, the property that specifies to treat the files as a File Set - which means that the...
by ray.wurlod
Wed Feb 03, 2010 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dscmdexport via Task Scheduler
Replies: 27
Views: 13226

I know they're not supposed to be positional, but try it with the domain switch first. For example:

Code: Select all

dscmdexport  /D=%Domain% /U=%User% /P=%Password% /H=%Server% %ProjectName%
by ray.wurlod
Wed Feb 03, 2010 3:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: auto purge settings for a specific job
Replies: 5
Views: 2800

In the Jobs menu select Clear Log. You can perform a manual purge or change the auto-purge settings.
by ray.wurlod
Wed Feb 03, 2010 3:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Question regarding dsapi_server and dsapi_slave
Replies: 3
Views: 4610

Have you examined dsprcservices file? Essentially dsapi_server is always started because this is the executable associated with the dscs service. It looks after the connection. Whether or not a dsapi_slave process is started depends on whether there's any work to be done accessing the repository. Ad...
by ray.wurlod
Wed Feb 03, 2010 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hash File limit
Replies: 7
Views: 3256

You need to show the exact SETFILE command that you executed and its output.
by ray.wurlod
Wed Feb 03, 2010 3:07 pm
Forum: General
Topic: Replace space character with new line character in UNIX file
Replies: 3
Views: 1845

Execute in sequential mode, or make sure that your collector re-assembles the lines in their correct order.
by ray.wurlod
Wed Feb 03, 2010 3:06 pm
Forum: General
Topic: Sequential file limitation
Replies: 2
Views: 1326

Some operating systems limit the size of a line in a text file, but fewer and fewer these days. DataStage imposes no limits. Take extra care when importing the table definition; it will save buckets of time if you get it right at the first attempt.
by ray.wurlod
Wed Feb 03, 2010 3:04 pm
Forum: General
Topic: Datastage Security
Replies: 1
Views: 1129

There's nothing in DataStage, but you can always use the Windows file system object (folder) properties to be as specific as you like.
by ray.wurlod
Wed Feb 03, 2010 3:03 pm
Forum: IBM QualityStage
Topic: how can we standardize foreign address and names?
Replies: 5
Views: 2027

Welcome aboard. Step 1 is to pre-process your data with the COUNTRY rule set. This will give you two new columns, one of which is an ISO country code that you can use to filter your data into separate streams by country (or groups of countries). For some, you can process with country-specify rule se...
by ray.wurlod
Wed Feb 03, 2010 2:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to get number of loaded records to log table
Replies: 8
Views: 2620

DSGetLinkInfo() is correct.

Why you get different results can not be explained without more information. For example are you examining precisely the same run of the job? Does dsjob command produce different results again?
by ray.wurlod
Wed Feb 03, 2010 2:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Question regarding dsapi_server and dsapi_slave
Replies: 3
Views: 4610

dscs = DataStage Common Services - the service requested by connecting DataStage clients and resolved via the dsrpcservices file consulted by dsrpcd (DataStage RPC daemon).

It is from this that dsapi_server instances get created.

Either dsapi_server or dscs processes may fork dsapi_slave processes.
by ray.wurlod
Wed Feb 03, 2010 2:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_ipcgetnext() - timeout waiting for mutex
Replies: 3
Views: 3052

Search will be your friend here.
by ray.wurlod
Tue Feb 02, 2010 11:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML output Stage
Replies: 7
Views: 1577

That's what the manuals are for. It may even be that IBM offers a class in using XML with DataStage. Check it out on their website - training is usually buried under Services.

You couldn't afford what IBM would charge for Ernie!
by ray.wurlod
Tue Feb 02, 2010 10:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XMETA Password Expired in DB2 Respository
Replies: 4
Views: 4577

You should, as DBA user, be able to reset the password. Unfortunately I do not have the knowledge to supply you with the actual command. Can Google help if your DB2 DBA and official support provider cannot?

At the same time, change the XMETA password to "never expires".