DSXchange

Contemplate exporting security assets using the istool command. The export file can be viewed with something like WinZip, you can also write some Java code to do so. istool export -domain servername -username user -password pwd -archive "pathname" -security '-securityUser -userident "...

From that starting point monitor system usage via Operations Console and adjust for spare capacity. In a DEV environment you never need more than two nodes*; if it will run on 2 it will run on 2000 - this does not need to be tested, it is inherent in the parallel engine. * The only exception might b...

You can create a "List of Users" report in the Reporting tab of the Web console for Information Server. This report can be executed automatically as a scheduled report.

As a starting point, 0.5 nodes per CPU core.

I have not seen such issues. However, even not using the Unicode extension for string data types, you still clearly have NLSMODE enabled (so that you can use Unicode as required).

I doubt it very much. After all, it's no longer May Day 2015.

The only real impact of using Unicode is that the total number of bytes processed is necessarily larger (typically 2X). Not using Unicode means that you are limited to the ASCII code set. Depending on what external data you are using there may also be a requirement to translate from/to the encoding ...

ahmedwaseem2000 wrote:you see i was out of my mind, then why do you expect me to spell it correctly

Because Rob's family name is spelled "the other way".

The error message suggests that the user that actually executes the DataStage job lacks write permission to the Excel workbook. Check your Engine credentials.

I would leverage (and have leveraged) QualityStage for this task, creating an AUPHONE rule set (my home base is Australia), with lookup tables for country, for area codes, for carriers, and so on.

The parallel engine does not have the string math functions to which Craig referred.

I'm not aware of such a report/utility. Most of that information ought to be findable in SystemOut.log and its precursors, but there may be a prettier solution.

Yes, which is one of the reasons they chose to install on Linux.

There is a uvodbc.config file in the DSEngine directory, however it can be overridden if there is a uvodbc.config file in the project directory.

Can you please attempt the same experiment using a Server job?