DSXchange

Umm... (I don't have version 7.1 yet)...

Did you also set a switch to make them protected?

And do they show up in Director? (That would eliminate indexes as a source of the problem.)

32-Bit or 64-bit pointers are dependent upon the OS system hardware configuration. The OS can be of 32-bit or 64-bit configuration. Please correct me if my understanding is wrong. The operating system must also be able to support files of the size implied by 64-bit internal addressing. This is not ...

The search precedence for uvodbc.config (on UNIX platforms) is:
1. project directory
2. DSEngine directory
3. /etc directory

On Windows platforms DSN information is obtained directly from the Registry. These days.

Why not post this on the DataStage forum? Not everyone reads the PX forum, and yours is a server job, not a PX job.

In particular, you can not safely restore a DataStage project "over the top" of an existing one. However, if you have operating system backups, you can close down DataStage, rename the existing project, then restore the previous version. This is safe to do. If your deleted jobs were on the backup th...

Seem to have wiped out the "regen" when I applied the bold! Edited the reply to make it right. bin/uv doesn't issue a message about shared memory segment after all. Apologies if that confused anyone, or if this confuses anyone now that the original error has been edited (if, indeed, it ever existed!...

The ORABULK stage is, as Ken said, for the Oracle bulk loader (sqlldr); it can not be used to extract data from an Oracle data source. To extract data from an Oracle data source you need an Oracle stage type (such as ORAOCI) or an ODBC or OLEDB stage. There is PDF documentation about every stage typ...

UVTEMP is a configuration parameter in the uvconfig file in your DataStage engine directory. You need to have Administrator privileges for this task. Change directory ( cd ) to the DataStage Engine directory. Edit the uvconfig file with any text editor, to change the pathname specified by UVTEMP. Ex...

The cache limit is the maximum amount of memory that can be allocated for caching the hashed file in memory. The maximum hashed file size refers to the largest hashed file that is possible on disk. This maximum is an artifact of the internal pointers used in the hashed file. With 32-bit pointers the...

Welcome to the Forum. In the Director client, Log view, is where you can see the error messages. Double click on any event to get the detail (you can also use right mouse button, or the View > Detail menu option). Still in Director, reset your job after it aborts. In the job log you may get a messag...

I'm guessing here that the entire selection from the Oracle table (minus WHERE clause) is loaded into a dataset. PX datasets are memory-resident. (The alternative would be to go to Oracle for each reference lookup.)
Happy to be corrected.

Resource consumption can be monitored at the UNIX level, watching the osh processes. You can find which pid belongs to which by inspecting a combination information in Director and your configuration file. Whether you can modify stages to be more efficient depends on whether they are optimally writt...

It may simply mean that the /tmp file system became full.

Use the UVTEMP configuration parameter to configure scratch space somewhere with more space than /tmp, and where there is less likely to be contention with other UNIX processes.

Sort on the input link of an Aggregator stage is an assertion that the incoming data are already sorted. For example you may have used an ORDER BY in the SQL that extracted the data, or passed the data through a sort mechanism, possibly a Sort stage, before it reached the Aggregator. There is no cap...

ODBC is a set of standards for accessing databaSes in a generic way using SQL or SQL functions. It makes the assumption that you know what you're doing, that you use SQL appropriate to the circumstances. Therefore, if you perform an UPDATE but there are no rows meeting your criteria, then (a) if the...