DSXchange

That's correct. The SQL Server is setup with WindowsNT Authentication and it from my testing the ODBC stage in my job uses the DataStage login or login designated for scheduled tasks to connect to the database. UserA = DataStage Login UserB = SQL Server Login We would like UserA to run this job usin...

Sorry to dig this up from the grave, but this issue relates to a current issue I'm having and I'm looking for answers. We currently have many jobs running via Windows Task Scheduler and we've designated a specific user id to run these scheduled jobs via DataStage Administrator. Now we've hit a roadb...

Mimix Replicate1 uses a custom created JClient Stage (aka ApplyStage) that receives file change transaction requests from the kernel of the Replicate1 product. Every file that you want to replicate needs a unique DataStage job where changed data transactions will be handled or 'broadcast' to other s...

Thanks Ray,

Where do I find "etc/services"?
Is this a file, directory, registry key, or something else?

We are starting to use Mimx Replicate1 with target DataStage server jobs handling the changed data via JClient apply stage? One of the requirements in the Mimix Replicate1 model is to define/attach a DataStage job port number. Anyone with experience using Mimix Replicate1 with DataStage know about w...

From what I've figured out so far... Our jobs use the date data element and transforms are derived to utilize the internal date format. When we reinstalled with NLS, all date fields with the date data element are now sourcing from the ODBC-->Transform in ISO format. All transforms expecting the inte...

We've been using DataStage for many years and finally found it necessary to install NLS support. The re-install went smoothly, however, many existing jobs are now aborting due to the change (in a test environment,of course) One big issue is all ODBC input stages getting an error "illegal date/t...

My first transform with 3 output links to 3 separate sequential files is working fine. FileA, FileB, and FileC are getting created without an EOF character = In my next transform I do a before-subroutine ExecDos "Copy FileA+FileB+FileC FileD". This copy command is putting the EOF character...

After reading about serveral issues with the Link Collector stage. I'm trying to follow some advice I read to use an intermediary sequential file. I have a transform with 3 output links to a sequential stage writing to files A, B, and C. Then I have one link from the sequential file stage (file D) t...

We've finally figured out that the task scheduler is getting disabled the same time this event happens: Security policy in the Group policy objects has been applied successfully. It's amazing how you find answers to your own problems AFTER submitting a desparate plea for help on a support forum :win...

We are initializing a new DataStage server with Windows 2003 and one of our major issues is getting the Task Scheduler to stay on "Automatic" For some reason, it changes back to "disabled" on it's own. In Computer Management-->Event Viewer we can see this event logged: User: NT A...