1

We are repointing a large number (>1000) DataStage jobs from one database to another. As part of this, we will need to make the same changes to a single stage for many jobs.

So far, we have been able to export jobs to XML, edit and reimport. This seems to work, but will require a lot of parsing logic. We also have looked at dsjob, but that tool does not seem to have the ability to edit jobs.

What is the best method (UI or CLI/API) to bulk edit job stages?

quannabe
  • 367
  • 1
  • 4
  • 11

2 Answers2

2

Scenarios like this are the reason for using parameters for Databases - I recommend using ParameterSets with DBName, User, Password and Schema parameters. This allows an easy and quick change in one place of a project: the ParameterSet

Hard coding all these things will give you a hard time - the export method is one option you know already. There is a connector migration wizzard - I am not sure if this tool could be helpful as well - you might want to search for documentation on that.

MichaelTiefenbacher
  • 3,805
  • 2
  • 11
  • 17
  • Thanks! We are using parameters sets in some places, but there are many legacy jobs where params are not in use. Will check out the connector migration wizard. – quannabe Jan 31 '23 at 21:57
2

Perhaps you can try the RJUT (Rapid Job Update Tool) or the CMT (Connector Migration Tool).

RJUT: https://www.ibm.com/support/pages/rapid-job-update-tool-ibm-infosphere-information-server-datastage-jobs

CMT: https://www.ibm.com/docs/en/iis/11.7?topic=connectors-using-command-line-migrate-jobs

Emily White
  • 46
  • 2