calculation for space in cylinder

Baskaran · New User Joined: 24 Oct 2006 Posts: 32 Location: India

Hi,

I need 159876 bytes required for a dataset,How i can represent it in JCL space parameter in CYL

space (CYL(?,?),,)

Is there any calculation avaliable.

Thanks
Baskaran

expat · Posted: Tue Jun 05, 2007 12:43 pm

dick scherrer · Posted: Tue Jun 05, 2007 6:08 pm

Hello,

What kind of mainframe dataset will you define? Are you aware of different mainframe file types?

Your number sounds like a windows or unix file length.

Baskaran · New User Joined: 24 Oct 2006 Posts: 32 Location: India

Hi,

This is a sequential file,this will be used as unload dataset for REORG job for a DB2 table.

We calculated this number in bytes using formulas avaialble for us from IBM utility guids.

Results of the formula suggest us,this file requires 159876 bytes,Now how to specify it in SPACE parameter.

SPACE=(cyl(?,?)

Is there any conversion formula avaliable.

Thanks
Baskaran

expat · Posted: Wed Jun 06, 2007 12:07 pm

What is the LRECL & RECFM of the dataset ???

As a quick guide ..............

159876 / 27998 = 5.71026501892992 blocks of data @ 27998 (half track blocking)

5.71026501892992 = 6 blocks used

As they are half track blocks, 6 / 2 = 3 tracks used

The above assumes that all available data is used within the blocks, but in most cases this is not true - so add another 2 tracks for contingency and this totals 5 tracks. This is 0.333333333 cylinders, which gets rounded up to 1 cylinder.

So, how big was the original DB2 table ???

Baskaran · New User Joined: 24 Oct 2006 Posts: 32 Location: India

Hi ,

My total space required for unload dataset is 44059546 KB.So how i would represent it in space =(cyl(?,?) ...

Thanks
Baskaran

expat · Posted: Thu Jun 07, 2007 2:52 pm

I have given you a quick method to obtain a reasonable estimate on your previous post, so all you have to do is to apply that formula to the new number of bytes quoted.

dick scherrer · Posted: Thu Jun 07, 2007 2:55 pm

Hello,

Use the method Expat explained earlier.

Calculate how many blocks you need by dividing by 27998 (still using 1/2 track blocking). Round up to the next full block.

Divide the block count by 2 giving tracks (round up).

Next, an oversimplification, but divide the track count by 15 giving cyls (round up and add 10 or 15%). This would depend on how many non-database bytes were written to the unload file (if any).

That should give you enough space to hold the data.

You may want to look at the documentation for whatever you use for the unload as often that documentation provides space calculation info.