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?

Postby j2422tw » Tue Dec 04, 2007 9:01 am

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
SMF header section.

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?

 

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

Postby Frank Yaeger » Wed Dec 05, 2007 12:22 am

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
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

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

Postby j2422tw » Wed Dec 05, 2007 7:21 am

Frank, thanks for your reply.

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


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post