Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 6966
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 setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts How to calculate an specific transact... lind sh CICS 2 Tue Sep 13, 2016 9:20 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us