DSXchange

Check for a Transaction Size option in the stage, that sets the number of rows to commit at any one time. At least on the server side. You may also want to look for some $APT configuration parameters to set, I seem to remember reading about them here. Search the forum for 'commit' and see what turns...

While it's really not all that difficult to move jobs to a new Category, the SQL to do the rename was recently posted to the forum, so I would say... yes, it's possible.

Read the readme. There's all kinds of good information in there, including a whole section on What's New.

Search is your friend. As mentioned in this post and on ADN, there is something in the works.

Very true and excellent advice, especially the part about recognizing if all parameters are being prompted for. Only problem is with the stages in the Shared Container. From what I recall, they won't have any 'default' values in their parameter fields, so you won't know about mismatches there until ...

Actualy we hacve faced problem in DS server few days back , one person run DS job with NO limit option and around 100000 log entry created and as result serevr hang , so I want to monitor DS job , Log must be 3 days only . That's not going to help when someone runs jobs with no warning limit that c...

Welcome aboard! Hard to say what your problem might be without seeing the actual job. At first blush, the problem would seem to be that you might have the parameters mixed up, sending the wrong values to the wrong stages. That would be the first thing I would triple-check, especially the passwords a...

You are probably better off making sure that all of your jobs have their Auto-Purge settings correct so that this happens automatically. There is a post here with discussion of the issue plus code for a routine that will update the settings for you.

As noted by Roy - change the section of the SHLIB_PATH that references your Oracle Home to look like this: $ORACLE_HOME/lib32:$ORACLE_HOME/lib You need to make sure the 32bit libraries come first. I'm not even sure you need the second 'lib' statement, and 'rdbms/lib' is not something I've needed on ...

Well, besides the fact that we're in the wrong forum and you've marked this as an issue with PX jobs, you've got a Windows problem not a DataStage problem. You need to take some of the keywords of the messages you've posted and slap them into Microsoft's online Knowledge Base and see what turns up. ...

Two ways. What happens when you open the stage and click on the Help button inside it? That should bring up specific help for the stage. There should also be a merge.pdf file available in your Docs folder where you installed the client.

More than likely. It could be related to the fact that you are mixing 8i and 9i. To be honest, I've never had an occasion to even try the Automatic mode, we use the Manual mode exclusively. We have scripts that work through the large collection of extracted files we pull out of CDC and this gives us...

If you can't use CDC, then it seems like there are only two other options that I can think of... not that there may not be others, of course. The first would be the triggers you mentioned earlier. It would take some effort to get setup, but then you would have complete control over how it was implem...

It could mean it's not installed, but since there are ways to customize the palette... Does this stage not show up for anyone or just not for you? You can check in the Manager to see if it shows the stage. Check under the 'Stage Types / Server / Processing' category to see if the Sort stage shows th...

Make sure you're not looking at the help page for a Parallel stage. They're all in there, even if you don't have a license for the product. It does tend to confuse people every now and then. Look at the color of the header and the background image there...