Orb Data

Orb Data's Blog Site

IWS

Workload Automation – Part 5b: Vexing Variables – variable tables

In the next part of this blog series we will look at variable tables. As mentioned in my previous blog, variable tables were introduced with TWS 8.5 and supplement the use of parameter values in earlier TWS versions. Variable tables Variables are held in variable tables which are stored in the TWS database. This provides […]

, , , ,

Workload Automation – Part 5a: Vexing Variables – parms

In the next part of this blog series we will look at variables used within TWS. This can be a confusing area especially for those long-time users of TWS as the use of “parameters” and “variables” is sometimes interchangeable. And that’s before we look at when variables get resolved – at job submission time or […]

, , , , , ,

Workload Automation – DataStage Jobs

  Define Common Variable Table Assumptions – all DataStage jobs execute through the same pool or agent workstation. Define a variable table to hold parameters common to all DataStage jobs and ADD the variable table to the pool/workstation definition. Do this by editing the workstation definition and supplying a variable tale value. This will need […]

, , , ,

Workload Automation – Part 4: Pull Files

This blog in the series will look at how to use the TWS built-in File Transfer advanced job type to pull files from a 3rd party site. One of the problems with this type of “pull” transfer is that you can’t be certain that the expected file is actually sitting there on the remote system […]

, , , , ,

Workload Automation – Part 3: Dynamic Agents and POOLS

The next blog in this series was intended to discuss automating the pulling of files using built-in TWS functionality. However, when starting to write the article I realised that to do so involves using some of the new advanced job types. The advanced job types will only execute on dynamic agents or POOL type workstations […]

, , , , , ,