## Can DFSORT pick out the SMF data with different offset?

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

### Can DFSORT pick out the SMF data with different offset?

Hi:

I need help to pick out SMF data with different offset within header section.

In SMF type 72, subtype 3, I want to get the value of R723CSRV ( 8 byte floating, 24 offset
in Service/Report Class Period Data Section).

The position of 'Service/Report Class Period Data Section' is depend on the value content in

For example, the SMF type 72,:

6----+----7

0000B040000
00014200100
-----------
Y
0000E040000
10018200100
-----------

0000B040000
00014200100

In the first record, the 61 to 64 byte, the value is x'000001B4' (436), so the R723CSRV is in
offset 436 + 24 = 460. Then I can take the 8 byte and count the value.

The second record, the 61 to 64 byte, the value is x'000001E8' (488), so the R723CSRV is in
offset 488 + 24 = 512.

Then, the third record, the 61 to 64 byte, the value is x'000001B4' (436), so the R723CSRV is in
offset 436 + 24 = 460.

Can DFSORT help me to pick out the data?

TIA.
j2422tw

Posts: 25
Joined: Wed Sep 19, 2007 9:46 am
Has thanked: 0 time
Been thanked: 0 time

### Re: Can DFSORT pick out the SMF data with different offset?

You show two different values for bytes 61-64. If practical for the number of unique values in 61-64, you can set up an IFTHEN clause for each unique value. Here's a simple example with a DFSORT INREC statement. Of course, you have to get the starting positions right for the VB file (including the RDW).

OPTION COPY
INREC IFTHEN=(WHEN=(61,4,BI,EQ,+436),
BUILD=(460,8)),
IFTHEN=(WHEN=(61,4,BI,EQ,+488),
BUILD=(512,8))
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Frank Yaeger
Global moderator

Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

### Re: Can DFSORT pick out the SMF data with different offset?

It can get the result by using IFTHEN clause.

Thanks again.
Jerry
j2422tw

Posts: 25
Joined: Wed Sep 19, 2007 9:46 am
Has thanked: 0 time
Been thanked: 0 time