DSXchange

Thenkyew, thenkyew.

Welcome aboard. :D This behaviour suggests that the index on DS_STAGETYPES needs to be rebuilt. You need to find a time when no client connection exists into DataStage in that project, and issue the command DS.REINDEX DS_STAGETYPES You may as well make sure they're all intact: prefer DS.REINDEX ALL ...

IoD announced confirmed release dates of October 2006 for the Windows version and November 2006 for the AIX and Linux versions.

When a parallel job starts the Conductor process reads the generated osh and the configuration file, and from that composes the "score". The score is what all nodes "play" (execute). The score is then distributed to the Section Leader processes; that this occurs can be verified by enabling the APT_S...

Execute the type or copy command as the Filter command in a Sequential File stage; the output link from the stage is fed from stdout of the command.

Note that some UNIX operating systems use remsh for remote shell; in these operating systems rsh is "restricted shell" which, as the name suggests, you may lack permission to use.

Don't do what Access is complaining about - ensure that this is so with a higher transaction isolation level.

You are seeking to compare apples and oranges. UNIX is an operating system, SQL Server is a database server that runs on Windows operating system. There IS a scaling strategy with SQL Server. If you have a competent SQL Server DBA, there may be value in leveraging that skill set. It will require add...

That's precisely what the Description fields are for. To get to them in a Transformer stage you need to open the link properties. The leftmost tool in the toolbar opens stage properties, from which tabs can get you to the link properties, or you can right-click on the title bar in the link represent...

Another thing to keep in mind before considering indexes (only ) is the fact that the indexes are only used if the number of qualifying rows for a query are a small percentage (i think 20%) of the total cardinality of the table. Otherwise DB2 ends up doing a table scan any ways. So please take into...

Even if your operating system limits file sizes to 2GB there is no effective limit. Data Sets' data will be stored in multiple files per partition. So, if you had 10000 files per partition and 1000 partitions, that's 2.0E9 GB of data. And you're allowed more than that; I only chose those numbers for...

Some stage types do not show row counts. For example the output link from a Modify stage does not. If you have JobMonApp disabled no row counts will be displayed. If you have toggled off the display of performance statistics (Diagram menu) the row counts will not be shown. One of these three is prob...

Background processes are called "phantom" processes in DataStage, for reasons historical. These processes direct their output to files in &PH& which is a subdirectory in the project directory. Do not use the sledgehammer approach proposed by rameshrr3. Instead use a gentler approach which re...

Inspect the score. If you choose Auto as the partitioning algorithm the composed score will have inserted tsort operators on each input link, and will report the chosen partitioning algorithm. This *should* be one of the key-based algorithms, but why rely on that? Propose a specific algorithm (usual...