MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Automate Space Calculations

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
kumarsivarajan
Beginner


Joined: 23 Sep 2003
Posts: 13
Topics: 2
Location: chennai

PostPosted: Wed Oct 01, 2003 1:51 am    Post subject: Automate Space Calculations Reply with quote

> Here i need help to automate my space analysis report for our
Partition/Segmented Tablespaces now iam doing it manauly to calculate
PRIQTY/SECQTY MAX NO EXTENCE CHECK(max extence limit fro reorg purpose)
> egs:
> manul analysis methord:-
>
> 1. If extence limit in Partition TS more than 50 EXETENDS
>
>
> 2. If it is in INDEXSPACE using through PIECESIZE
>
> 3. Run BMC CHANGE MANAGER and estimated space TO get the
> space report.
>
> 4. calculate value of(PRIQTY+(SECQTY* NO. OF EXETENDS))=
> XX GB ->CALULATE VALUE then compare with ESTEMATED
> VALUE IN 2/4/X GB(stanadard PATRT TS AND SEG TS)
>
> 5. CACULATED VALUE > OR < OR = ESTEMATED VALUE
> IF CAL VALUE > TAKE IT ACCOUT FOR REORG ELSE NOT
>
> THE SAME WAY for, PIECESIZE fOR INDEXSPACE
> CACULATED VALUE > OR < OR = ESTEMATED VALUE but
> the both values are converted into MB's or GB's
>
> 6. Then i DECIDE to go to REORG/ALTERING the PRIQTY/SECQTY
> values
>
>
> CAN ANY HELP ME FOR CALCULATING THROUGH REXX OR ANY OTHER WAY TO DO
IT ACCURATELY.
>
> THANKS
> KUMAR
_________________
the total world is equal to pure knowledge
Back to top
View user's profile Send private message
kumarsivarajan
Beginner


Joined: 23 Sep 2003
Posts: 13
Topics: 2
Location: chennai

PostPosted: Tue Feb 03, 2004 1:40 am    Post subject: Reply with quote

hai i got answer finally
_________________
the total world is equal to pure knowledge
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group