Debugging environment problems which lead to "Error executing command: orchdbutil" messages when importing database table definitions in DataStage Designer.

Troubleshooting

Problem

When importing a table definition in DataStage Designer through Orchestrate, the orchdbutil command is used. This is typically done by right-clicking on the Table Definitions folder or a subfolder, and selecting "Import Table Definition -> Orchestrate Schema Definitions..." and then selecting "Database table (via orchdbutil). DataStage uses the input on the dialog to construct a call to orchdbutil. If there is a problem with the invocation of orchdbutil, an error will be returned. Included in the message text will be the orchdbutil command which was used, with some minor changes to hide the user credentials. If the problem is due to the environment, it can be painful to debug since any environment changes will require a restart of DataStage. In a Windows setting, the entire system must be rebooted for environment changes to take effect. This may not be a realistic option to debug a problem with the environment.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5;8.1;8.0;7.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Was this topic helpful?

Document Information

More support for:
IBM InfoSphere DataStage

Software version:
8.5, 8.1, 8.0, 7.5

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
161191

Modified date:
25 April 2025

UID

swg21501796

IBM Support

Tips