DSXchange

It depends also on the default lock size setting for the tablespace and whether that has been overridden for the particular table. Check with your DBA.

What's the name of the job parameter environment variable?

$ENV can go right back to the executing user's login environment, so you need to look in places like /etc/profile and the .profile script (if any) for the user ID under which DataStage processes run.

DS_AUDIT seems to be a bit flaky in version 8. For example it seems to use CLASS '7' for pretty much everything. I guess with the totally flexible repository structure there's not much they could do there. Or maybe there was, and they just broke it. The Cross Project compare tool (in versoin 8, not ...

Search for other ftp executables, maybe in strange places like /usr/sbin/ftp or /sbin/ftp. You never know what might show up!

If you had two failover boxes would that be a HAHA configuration?

DS.CHECKER only cleans up orphans in the local DataStage repository. It does not touch the unified metadata repository of Information Server. There's a directory full of scripts (for example cleanup_abandoned_locks.sh) for cleaning things up in the unified metadata repository. It's been mentioned he...

*Topic Relocated - Content Editor*

In short, your system lacks the resources to do everything you are asking it to do. Search for "timed out while waiting for an event" for more information.

Use the AddMonthsToDate() routine from here to calculate a start date and end date, then use MONTH.FIRST and MONTH.LAST transforms.

Depends on how pedantic you want to be and, perhaps, whether production is a protected project. At the most pedantic level you don't migrate design objects into production, only executables. However, having the design objects in production will enable diagnostic activities to be performed in that en...

The easiest is probably just to use the dsjob command line interface. The question then arises about providing data to, and retrieving data from, the job. You have a number of choices here including file system files, message queues, named pipes and so on.

Do you mean to invoke the DataStage job from a Web service, or to expose the DataStage job AS a Web service?

Data Set will preserve sorted order. So will Lookup File Set, which may be more appropriate if you are only going to use these data on a reference input to Lookup stage types.

You can use a server job to read them. In a server job the Sequential File stage allows you to specify "contains terminators" in column definitions and will handle them correctly. This capacity does not seem to be available in the parallel Sequential File stage.

A parallel job design is stored as (a) generated OSH, which can be viewed in job properties, and (b) generated C++ objects/libraries.