View previous topic :: View next topic |
Author |
Message |
kumarsivarajan Beginner

Joined: 23 Sep 2003 Posts: 13 Topics: 2 Location: chennai
|
Posted: Wed Oct 01, 2003 1:51 am Post subject: Automate Space Calculations |
|
|
> 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 |
|
 |
kumarsivarajan Beginner

Joined: 23 Sep 2003 Posts: 13 Topics: 2 Location: chennai
|
Posted: Tue Feb 03, 2004 1:40 am Post subject: |
|
|
hai i got answer finally _________________ the total world is equal to pure knowledge |
|
Back to top |
|
 |
|
|