DSXchange

What is your commit size (rows per transaction)?

What else was happening in the database at 2:00am? In another project I was caught by something like this - "they" ran a series of batch updates about which they'd neglected to inform us. DataStage job just hung waiting for table-level locks to be released.

There is no alternative than to take two passes through the data. The second pass, of course, need do nothing other than load the data into the target from the staging files created by the first job, but must be triggered by there being no rejected rows. This can be determined by many means, such as...

If you don't believe that you are using that many hashed files, remember that most of the Repository tables are also hashed files. Every job you create engenders some more, such as RT_CONFIGnn, RT_STATUSnn and RT_LOGnn. T30FILE sets an upper limit on the number that can be open simultaneously: the d...

Or look in JOBCONTROL.H in your DSINCLUDE subdirectory in the project. Look for entries whose names begin "DSJS." You could even search the forum; this information has been posted in the past.

From the Administrator client execute this command
SH -c "grep DSJS. dsinclude/JOBCONTROL.H"

This is where I got the information. Type help start in a cmd shell on your server machine. YMMV C:\Documents and Settings\Ray>help start start -- start program in another window Usage: start [-ABbchlmNnrwx] [-D dtop] [-d dir] [-p x y] [-s w h] [-S c r] [-t title] command [args...] Usage: wstart [-A...

As a start point, investigate HKEY_CURRENT_USER\Software\Ascential Software\DataStage Client\Attach and HKEY_CURRENT_USER\Software\Ascential Software\DataStage Client\Director I haven't found an actual number, but you may be able to work on the actual lists (PrevHostNames key). You will also notice ...

How, precisely, do you think this will help? It is not the structure of the Repository, it is the structure of only some of the tables in doc_tool.mdb and presupposes that the poster is using the Reporting Assistant, which has been deprecated since version 6.0. Nor have you show which of the columns...

This one is not related to T30FILE. The wave number is an internal number used by DataStage to identify separate instances (such as the reset instance) of a job. Dots are not permitted in job names (or batch names) unless specifying an invocation ID for a multi-instance job. It appears that you may ...

What is your volume of data? How much physical memory and how much swap space does the server have?

This is not the first time this question has been posted, and it has been answered in the past. Asking the question again wastes all our time.

There's no such thing as a Command Prompt stage. Do you mean a Command stage in a job design, or an Execute Command activity in a job sequence. The mechanism for the latter is to use the activity variable ActivityName.$ReturnValue With a Command stage - which is executed for every row processed - yo...

Have you even tried to create a Rejects link? Let us know the result.

Raw

Was there any other warning suggesting which data source was causing the problem? What data source type are you using in the Dynamic RDBMS stage?