Mainframe, MVS and zOS Discussion

It could be Workload Activity Report that's being asked about. And then summing up gives you percent of an engine, rather than of the processor pool. So it could then go way over 100%.

... and the value of this is to be able to plot usage by time of day - e.g. CPU time in SMF 30(2,3) Interval records. (Likewise RMF.)

@priya I would reckon CPU time savings go hand-in-hand with Elapsed Time savings - which OUGHT to be of interest to your management.

I would also say that ranking jobs by CPU time is the best way to decide which to tackle in an overall CPU reduction effort.

If there is a serious point, it is this:

I suspect it's quite hard to position to the last record in the file and read backwards.

I think we should be gentle with the original poster (OP). My strong suspicion is that English is not their first language and VSAM is not their hottest topic. So let's try and edit in our heads and answer the original question... I would echo "VSAM Demystified" is a very good Redbook - bu...

At the risk of publicising my blog you might also want to try some of the techniques I write about using DFSORT. Use your favourite web engine with the terms "XML DFSORT".

Take a look at http://www.redbooks.ibm.com/redpieces/a ... .html?open and I'd start with a simple example before heading towards a "production ready" one.

SELECT * when all you wanted was columns in an index prevents index-only access. And I'm sure there are other access path no-nos. It also occurs to me that if column data is (eg RACF) protected then the request will fail, whether you wanted columns you don't have access to or not. Of course an unqua...

SMF / Performance / Capacity are largely unrelated to (DF)SMS and the access methods listed there. By the way there don't seem to be other discipline newsgroups (such as "Security" and "Availability") either.

@Mainframe help - which one did you have in mind? None seem really related to Perf / Cap.

As for ICETOOL...

... If you're licenced for DFSORT and have it installed then you have ICETOOL automatically. And if you're looking for a simple solution to a problem check ICETOOL first. Then ICEMAN / SORT.

INREC reformats records on the way into a sort. OUTREC (and OUTFIL OUTREC) reformats them on the way out. General guidance: 1) If you're going to cut down the record length do it on the INREC - if at all possible. 2) You can use INREC with e.g PARSE and IFTHEN to reformat records so that sort fields...

I'm interested in knowing why you want to nose through control blocks. "Idle curiosity" is a good answer, of course. :-)

I don't see one. Am willing to moderate one or whatever.