DataStage Analysis spreadsheet

PhilHibbs · Post by **PhilHibbs** » Wed Jul 06, 2011 5:18 am

Version 1.9f.

More Director functionality - run parameters can be specified in the Job Params sheet, and logs can be retrieved in summary or long mode. If long mode (the default) is specified on the control sheet, parameter values that differ from the default are recorded in the Job Params sheet so you can see at a glance what parameters your jobs were run with.

Want to use DropBox? Use this link and we both get extra space!

PhilHibbs · Post by **PhilHibbs** » Fri Jul 15, 2011 4:48 am

Version 2.0c.

Loads of Parallel Job improvements, picks up Sequential Files but not File Sets yet. Picks up Aggregator Stage functions and sort keys. Also does field-level detail properly now.

Want to use DropBox? Use this link and we both get extra space!

PhilHibbs · Post by **PhilHibbs** » Fri Jul 15, 2011 8:44 am

Version 2.0d.

Picks up link constraints, back-fills Category information, fixed a bug where it would overrun past the end of the last DSJOB and write rubbish to some of the sheets (this wasn't a problem for me as I nearly always cut my DSX files first). Flipped the meaning of "Trim Links" option, this is now "Link Detail" so Yes means include rather than t'other road about.

Want to use DropBox? Use this link and we both get extra space!

PhilHibbs · Post by **PhilHibbs** » Wed Jul 20, 2011 3:48 am

Version 2.0g.

Added File Sets, functionality not yet complete, I think it only works on output files. However, I broke Parameters and Stage Vars in one of the recent releases, so this version fixes those.

Want to use DropBox? Use this link and we both get extra space!

PhilHibbs · Post by **PhilHibbs** » Mon Dec 19, 2011 12:34 pm

Version 2.1.

V8 DSX changes, add plink support, terminal session type selection, and multi-instance job log retrieval.

Want to use DropBox? Use this link and we both get extra space!

chulett · Post by **chulett** » Mon Dec 19, 2011 12:47 pm

plink?

ray.wurlod · Post by **ray.wurlod** » Mon Dec 19, 2011 2:47 pm

plink.

Part of PuTTY. Command line connection tool somewhat like ssh.

vamsi.4a6 · Post by **vamsi.4a6** » Tue Jul 10, 2012 7:41 am

@DataStage Gurus

Could anybody please help on this

1)When I exoprted dsx file it is not showing Job Status,Job Completed,JOb elapsed time in Job List sheet.All the above fields are blank. It is showing only Job Name and Job category.

2)what i need to mention for username and password when I click Log macro in Job List sheet?

PhilHibbs · Post by **PhilHibbs** » Tue Jul 10, 2012 10:03 am

The DSX file only contains the job design. The spreadsheet contains functionality to run jobs and to retrieve job status and log information, for which you need to ensure that Putty (including plink.exe) are installed on your machine, and press the "Log" or "Run" button and enter your Unix user name and password.

*Edit* Also make sure that the server and project are correct on the control sheet, and also set the Invocation value on that sheet if your jobs are multi-instance. Or, edit the Job Name to include the ".XXX" invocation suffix.

kduke · Post by **kduke** » Fri Jul 20, 2012 8:19 pm

The dsjob command will give you runtime stats.

PhilHibbs · Post by **PhilHibbs** » Tue Aug 07, 2012 9:38 am

kduke wrote:The dsjob command will give you runtime stats.

That's what the "Log" button does - it opens up a shell and runs dsjob. I've found it really useful for picking up large amounts of Peek information recently.