View previous topic :: View next topic
|
Author |
Message |
liying
New User
Joined: 27 May 2010 Posts: 47 Location: da lian.china
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
|