IBM Mainframe Forum

Hi all,

I am trying to get all the information of a VSAM file through a JCL. If i do so in the File Aid, everything works fine. I mean i get all the information from about that VSAM. But if i run a batch program for the same using IDCAMS utility and listacat(All) command, i dont get all the information
e.g I dont get Used data space: of the VSAM file.

Can aybody give me a sort command or a utility, that will give me all the information of the VSAM file.

I appreciate your help as always!

Mohsin

e.g I dont get Used data space: of the VSAM file.

What do you think that HURBA is ?

I appreciate your reply.

but when i compare the two it really is not the same


This is the File Aid output

. File-AID ----- VSAM Information - (Page 2 of 2 ) ----------------------------- .
. COMMAND ===> .
. Related Datasets - 'BXTD.DEXT0.V.OGB.SORTDATA' .
. CLUSTER - BXTD.DEXT0.V.OGB.SORTDATA Storage: TEST .
. Data: DC4 .
. Management: MC8A .
. Owner ID: .
. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - .
. Current Allocations in Tracks: Current Utilization in Tracks: .
. Allocated space: 3000 Used data space: 2066 ( 69 %) .
. Allocated extents: 1 Used extents: 1 ( 100 %) .
. Allocation type: UNIQUE Prime records: 35,612 .
. KSDS Index Allocation in Tracks: Deleted records: 0 .
. Allocated space: 0 Inserted records: 0 .
. Number of records: 0 Updated records: 0 .
. - - - - - - - - - - - Current Reorganization Information - - - - - - - - - - - .
. Data - Control Area Information: Control Interval Information: .
. Physical record size: 26624 Size-data: 26624 Index: 0 .
. Records per track: 2 Number CIs/CA: 30 .
. Tracks per CA: 15 Number free CIs/CA: 0 .
. Retrieved records: 49329 Percent free CIs/CA: 0 .
. Max record number 0 Percent free bytes/CI: 0 .
. Number CA splits: 0 Number CI splits: 0 .
. Use ENTER to access additional pages, END to return to utility menu .

This is the the listcat output


HISTORY
DATASET-OWNER-----(NULL) CREATION--------2009.259
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--BXTD.DEXT0.V.OGB.SORTDATA
ATTRIBUTES
KEYLEN-----------------0 AVGLRECL------------4096 BUFSPACE-----------53248 CISIZE-------------26624
RKP--------------------0 MAXLRECL------------4096 EXCPEXIT----------(NULL) CI/CA-----------------30
SHROPTNS(1,3) SPEED UNIQUE NOERASE NONINDEXED NOWRITECHK NOIMBED NOREPLICAT
UNORDERED NOREUSE NONSPANNED
STATISTICS
REC-TOTAL----------35612 SPLITS-CI--------------0 EXCPS--------------16209
REC-DELETED------------0 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'C4CBB466A1FD7A88'





. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Display Filter View Print Options Help
-----------------------------------------------------------------------------------------------------------------------------------
SDSF OUTPUT DISPLAY QDDSRUN JOB03609 DSID 102 LINE 44 COLUMNS 02- 133
COMMAND INPUT ===> SCROLL ===> PAGE
REC-RETRIEVED------49329 FREESPC---------49733632
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA-------159744000
SPACE-PRI------------200 HI-U-RBA-------110010368
SPACE-SEC-------------19
VOLUME
IDCAMS SYSTEM SERVICES TIME: 05:03:36 09/16/09 PAGE 2
VOLSER------------BVUD16 PHYREC-SIZE--------26624 HI-A-RBA-------159744000 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK------------2 HI-U-RBA-------110010368 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
LOW-CCHH-----X'153B0000' LOW-RBA----------------0 TRACKS--------------3000
HIGH-CCHH----X'1602000E' HIGH-RBA-------159743999
IDCAMS SYSTEM SERVICES TIME: 05:03:36 09/16/09 PAGE 3
. .

The have marked the rquirement in red and if we see, the file aid used space is not equal to HURBA of listcat.

Am i wrong. Please correct me if i am not able to figure outb but i want someone to help me in this

Thanks all for you response

If you divide the HURBA by the HARBA you get 68.8666666% = 69% used, the same as File Aid.

Thanks a lot..
But what about the Used Data Space value 2066.. how to get that
Thanks

Hello,

Multiple the allocated space by the used % you just calculated. . .

I am really blessed that you people answer all my queries.
I just have one doubt, as you said above to multiply the allocated space by used%, it comes to be 2070 in above example but the file aid result above is 2066. Is there any way the exact number.

I know i am asking for too much, but just wanted to know.


Thanks a million.

Hello,

Adjust the decimal places/rounding in the calculation.

3000 * 68.86% is 2065.9.
3000 * 69% is 2070.

thanks dick, i understand it was a silly ask, i should have done some calculation before asking.

thanks a lot.

You're welcome

i understand it was a silly ask, i should have done some calculation before asking.

Not to worry. Sometimes we get in a hurry

It probably won't happen next time. . .

d