DSXchange

I think it means your connection works OK now but you have a bad user/password combination. Verify it works outside of the ODBC driver first.

When bringing the server processes down, once no users are connected and no jobs running, I have scripted to remove: - DataStage related files under /tmp - all files from each $TMPDIR location for each project - HA_STATUS/* files under each project directory - lookuptable* files - core* dump files -...

My guess is if they're asking you for that, they are probably asking everyone else too. Ask if they have a template with the headings already defined. These might be new or they may fit into your existing headings: - define your role and responsibilities - working with IBM Support - working with int...

Have you compared the ODBC driver being used and the driver settings?

Have you tried an ODBC trace?

Have you opened a support case?

Once upon a time with the Oracle Connector stage, I found that I had to CALL the SP instead of EXEC the SP. Hope that helps. The end.

Here are a few examples. What is the &PH& directory used for in DataStage and does it need to be cleaned out? https://www.ibm.com/support/pages/what-ph-directory-used-datastage-and-does-it-need-be-cleaned-out Temporary lookuptable files that use up disk space https://www.ibm.com/support/know...

I would also suggest you get familiar with Search on the IBM Support Portal. Search is your friend.

See this topicfor an auto-retry workaround to a similar issue that you could use as well. This can be done at the sequence job level.

It's fine to ask a process question. I don't know the answer though. I really don't know the nature of it so I am imagining if we had that type of scenario in our environment... It sounds like a clever way for allowing people to alter data directly in production without doing the harder work of plan...

It could be read using the regular Sequential File stage into a single varchar column, and then parsed according to your rules by using the looping feature in Transformer stages.

I thought the same thing!

See this tech note:

Datastage environment variable APT_DECIMAL_INTERM_ROUND_MODE has no effect on decimal rounding results in parallel jobs.

I'm not aware of any command line option to export and create a DSX file based on a category. Maybe someone else knows. If not, then you could open a Request For Enhancement (RFE) with IBM. You could also open a severity-4 support case to ask about it.

Ernie,

Thank you for all your help given to everyone in these forums over the years! Good luck in your new role!

Eric

In Designer's repository view, you can simply right-click on a category and choose export. It will catch everything under that category into the DSX file. If you de-select the option to include dependencies, then the export will go much faster.