Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
RAA size calculation in DBD

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Kalirajan

New User


Joined: 20 Apr 2012
Posts: 2
Location: INDIA

PostPosted: Mon Apr 23, 2012 1:39 pm    Post subject: RAA size calculation in DBD
Reply with quote

We are supposed to increase the database size by 50%. We want to know how much do we increase in the RAA ROOT parm?

Current parm size is below,
UOW=(50,5), ROOT=(1030,50)

What would be the calculation for arriving at the new values in UOW and ROOT parms?
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2441
Location: Netherlands, Amstelveen

PostPosted: Mon Apr 23, 2012 1:47 pm    Post subject:
Reply with quote

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.imstools.bbe.doc.ug%2Freorg%2Fbbe_reorg-scenario-dbtune-raa.htm
Back to top
View user's profile Send private message
Kalirajan

New User


Joined: 20 Apr 2012
Posts: 2
Location: INDIA

PostPosted: Mon Apr 23, 2012 1:56 pm    Post subject:
Reply with quote

The link you provided is too much technicals. Please provide the explanation in simpler terms.

Additional information is below,

DBDNAME: BXXXXXXX AREA NAME : DXXXXXXX
AREA NUMBER: 1
AREA DESCRIPTION
RMNAME : DBFHDC40
CI-SIZE: 4096
UOW=(65,7) ROOT=(325,52)
UOW'S IN RAA: 273
NO. OF RAPS : 15,834
CI'S IN DOVF: 1,911

FREESPACE ANALYSIS - *** OVERVIEW *** %FREESPACE - RAA BASE: 9% %USABLE FREESPACE: 6%
DOVF : 5% 1%
IOVF : 87% 86%
SDEP : 100%
CI'S IN IOVF: 3,380
NO. IOVF DIR: 29
CI'S IN SDEP: 66,108

DB RECORD PROFILE ANALYSIS
NO. DB RECORDS: 328,651
AVG REC LENGTH: 206
STD. DEV. : 0
MAX REC LENGTH: 206
MIN REC LENGTH: 206
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 24, 2012 12:12 am    Post subject:
Reply with quote

Hello and welcome to the forum,

Quote:
The link you provided is too much technicals.
If the information given at that link is "too technical" there will be ongoing problems trying to administer the database environment. . . What in that info did you not understand?

Quote:
We want to know how much do we increase in the RAA ROOT parm?

That would depend on your environment and expected growth or reduction.

If you have no one who understands these settings, suggest you hire someone or rent someone for dealing with this or training some/one of you that are already onsite.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JES2 job size field matching Windows ... SRICOBSAS All Other Mainframe Topics 4 Tue Sep 05, 2017 5:49 pm
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm
No new posts MSU calculation for DB2 (to decide be... SRICOBSAS DB2 4 Wed Mar 23, 2016 6:07 pm
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us