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
 
how to calculate index space

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
liying

New User


Joined: 27 May 2010
Posts: 43
Location: da lian.china

PostPosted: Sat Apr 28, 2012 3:18 pm    Post subject: how to calculate index space
Reply with quote

I have checked VSAM dataset's extension infer which have physically stored the index of DB2 tables. But I do not know how to calculate index space from the PRIQTY and SECQTY parameter.Exactly I don't know how many times will the VSAM files which have stored index info can extents.
For the table ,it will be 122 extension times for one DASD, would please tell me how many times can the index extent?Thank you very much!
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Sat Apr 28, 2012 6:45 pm    Post subject:
Reply with quote

you are doing your self a disservice when you insist on being so cleaver and referring to the underlying linear datasets of db2.

rules for vsam do not apply.
db2 does all kinds of things under the covers
none of which are applicable to vsam.

unless you are writing db2 utilities to be marketed around the globe,
get into the habit of referring to db2 as tablespaces, tables and rows.

db2 index calculation is easily found via google.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 Tue Apr 17, 2018 10:42 pm
No new posts VSAM File free space sancraig16 JCL & VSAM 13 Fri Mar 30, 2018 1:02 am
No new posts VSAM BUFFER SPACE? John Poulakos CICS 17 Thu Mar 22, 2018 2:54 am
No new posts *MASTER* address space abending at IPL Alan Playford All Other Mainframe Topics 0 Mon Mar 12, 2018 8:02 am
No new posts KSDS and Index file in cobol deepak14450 COBOL Programming 9 Fri Dec 22, 2017 9:36 am

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