Database Analyzer space calculation

book

Article ID: 5198

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

What is the formula to use to turn RATS_PQTY_A+RATS_SQTY_A in PTI. RATS_STATS_1105  into CYLs on the Space Summary report (option 6)?   For 4K pages you appear to divide by 180 but I don’t understand why 180 works?   The same for RAIX_PQTY_A + RAIX_SQTY_A in PTI.RAIX_STATS_1105 as well please.

Environment

Release:
Component: PDA

Resolution

12 4K pages per track, 15 tracks per cylinder = 180 4K pages per cylinder. (on a 3390 device) check out the DB2 Administration Guide.  The v10 version is here: http://publibfp.dhe.ibm.com/epubs/pdf/dsnagm0e.pdf

The rest of DB2v10 manuals are located here: http://www-01.ibm.com/support/docview.wss?uid=swg27019288