MVSFORUMS.com

Celeste Locklin · Posted: Mon Feb 07, 2011 9:52 pm Post subject: DMBATCH output

greetings.
I have a job that executes DMBATCH to select statistics - and the only 'where' is starttime, so the output file contains all statistics, i think.
the next step sorts the statistic file using

RECORD TYPE=V,LENGTH=4100
SORT FIELDS= (45,4,BI,A,9,8,BI,D)

The file has 30K+ records of dozens of different types and layouts.
on the CT record, the "9,8" could be timestamp, but i don't think a field starts at 45.
I read that sometimes the record layouts change, and i am wondering if that is the case here, and my sort is not doing what it is supposed to do.

Anyone have any idea what might be in those fields worth sorting ?

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

What are the hex values (pos 9 for 8 and pos 45 for 4) in a few of these records?
_________________
All the best,

di

Celeste Locklin · Posted: Tue Feb 08, 2011 12:57 pm Post subject:

i am not exactly sure which position(s) to look at since the file is VBA.
but here is the first 60 bytes of 4 records from the sorted file:
thank you in advance for your interest and your help. cl
[code:1:a75186208c]
----+----1----+----2----+----3----+----4----+----5----+----6
VWO.

kolusu · Posted: Tue Feb 08, 2011 1:23 pm Post subject:

Celeste Locklin,

what are the DMBATCH control cards used for generating the statistics?

Kolusu

Celeste Locklin · Posted: Tue Feb 08, 2011 2:15 pm Post subject:

kolusu,
the date & time are updated every day on the select statement.
this is today's select statement:

SEL STAT WHERE(STARTT=(2011035,16:05:00)) FILE

(there are also signon and signoff, but they aren't pertinent are they?)

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

Is the data posted from the sorted or the unsorted file?

The 8-byte field appears to be the julian date and a timestamp. The 4-byte field Confused

As the 4-byte field is sorted first, it may be to gather/group the records by whatever . . .

Does this process now run differently than it did in the past?
_________________
All the best,

di

Celeste Locklin · Posted: Tue Feb 08, 2011 4:42 pm Post subject:

The record are from the sorted file. They are not consecutive, but they are in order (i.e. there are a lot of records between these records that are not shown).

Does (9,8 ) REALLY MEAN start at position 9 ? or do I need to add or subtract positions to accommodate the file being VBA?

If (9,8 ) really means 9,8, then the first record contains x

kolusu · Posted: Tue Feb 08, 2011 4:49 pm Post subject: