DSXchange

Usage Analysis is also available from the Manager's toolbar; it's the tool whose icon looks like a chemist's beaker. Once the usage analysis report is presented, you may be able to perform further usage analysis. For example, if your routine is invoked by another routine, and the Dependencies are co...

OK, that suggests that they're not in the same block. You also need to MOVE @WGT to get the agreement weights. You can select this from the same drop down list where you found @SET8. You'll also need to advise which columns you used for blocking (forming the blocks of potential duplicates). Ideally ...

The worksheet must be in columnar format with column headings. If it is not, the ODBC driver doesn't work, so you would need to revert to saving the worksheet in CSV or TXT format (the latter is tab-delimited) and processing that with a Sequential File stage.

There's no such thing as a virtual File Set, only a virtual Data Set. It's useful to think of every link in the job connecting through a virtual Data Set. Look at the generated OSH to discover the control file name (the name ending in ".v") for that virtual Data Set. The error message suggests that ...

Where'd you hear that? Some operating system vendors provide utilities (for example Affinity) that can tie a particular process to a particular CPU, but there's nothing within DataStage. Nor have I heard any rumour to that effect about the Hawk release. But I don't hear everything, so do let us know...

What are the aggregate weights for the XA entry and the first and last DA entries for this difficult group (block of records)? If you can see that they're all in the same block (I'm assuming this), why do you claim that they don't match? Surely being in the same block is the defintion of match, when...

What else was happening in Oracle at the time that might also have needed some of the UNDO tablespace?

The maximum permissible MAXKEYLENGTH setting is 768.

You simply can not make it 2000.

What the heck are you trying to do?!!!

Small is good, as far as hashed files are concerned.

I'm sure if anyone has an idea they will post it. Stop hassling us!

Try these queries against the database.

What do these tell you about grouping?

In a before-job or before-stage subroutine you can use appropriate UNIX commands such as test to determine existence, readability, etc. The only way to detect data type mismatch is to read everything as VarChar and create your own tests. Data type mismatch is logged, so you could pick this up in an ...

The prompt for invocation ID should still appear when you're requesting a job run in Schedule view, so you fill the value in in exactly the same way as you would from a regular run request.

The job PID is usually findable through the early entries in the job's log and/or through its DSD.RUN entry in &PH&.

DataStage does not support dynamic metadata. Therefore the answer is no, given your client's imposed constraint.

We would need to determine that by test.
The current location in the file is maintained by READSEQ (and is returnable using FILEINFO() function). If this is also an int32 then READSEQ and WRITESEQ would also be limited to 2GB.