IDS Forum

RE: Index extents

Posted By: NormaJean.Sebastian@tellabs.com
Date:

Kevin,

I believe even on detached indices, the extent size while be the same
extent size as the table and all the usual rules apply....
if it can't get the whole extent size (be it 1st extent or next), it
will take what it can get... if it needs more, it'll get another extent.
if it can, it will concatenate extents that are contiguous.....

but I could be wrong (I'm on 7, not 9), it should be in the admin books,
or others may confirm with answers.

Norma Jean


-----Original Message-----
From: kevinstruckhoff@yahoo.com [mailto:kevinstruckhoff@yahoo.com]
Sent: Tuesday, August 19, 2003 5:24 PM
To: ids@iiug.org; forum.subscriber@iiug.org
Subject: Index extents [1725]


Using IDS 9.30FC2 on an HP-UX 11.0 box.

in creating detached indexes, I have noticed that sometimes the index
has multiple extents in a particular dbspace. For example:

prddwh:'dw_admin'.fl_keylinks 943776
40
prddwh:'dw_admin'.fl_keylinks_n1 139338
8
prddwh:'dw_admin'.fl_keylinks_n1 148623
8
prddwh:'dw_admin'.fl_shipto 943592
24
prddwh:'dw_admin'.fl_shipto_n1 994962
4
prddwh:'dw_admin'.fl_shipto_n1 58472
4


The index 'fl_keylinks_n1' and 'fl_shipto_n1' are split into 2 extents.
I know I can't set the extent size as I can a table.

Is it advantageous to split them up? I'm not sure what logic is used in
determining where and how large the index extent should be. It looks as
though it finds the first available opening in the dbspace and uses it.
If it doesn't all fit there, look for the next available opening.
Hmmm...

TIA,

Kevin Struckhoff
Yamaha Motors U.S.
kevin_struckhoff@yamaha-motor.com

kevin_



--openmail-part-40e4b3f6-00000002
Content-Type: application/rtf
Content-Disposition: attachment; filename="BDY.RTF"
;Creation-Date="Wed, 20 Aug 2003 07:48:56 -0500"
Content-Transfer-Encoding: base64

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYw
XGZzd2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmls
XGZjaGFyc2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5l
dzt9fQ0Ke1xjb2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1
NTt9DQpcdWMxXHBhcmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIEtldmluLFxwYXINClxw
YXINCkkgYmVsaWV2ZSBldmVuIG9uIGRldGFjaGVkIGluZGljZXMsIHRoZSBleHRlbnQgc2l6
ZSB3aGlsZSBiZSB0aGUgc2FtZSBleHRlbnQgc2l6ZSBhcyB0aGUgdGFibGUgYW5kIGFsbCB0
aGUgdXN1YWwgcnVsZXMgYXBwbHkuLi4uXHBhcg0KaWYgaXQgY2FuJ3QgZ2V0IHRoZSB3aG9s
ZSBleHRlbnQgc2l6ZSAoYmUgaXQgMXN0IGV4dGVudCBvciBuZXh0KSwgaXQgd2lsbCB0YWtl
IHdoYXQgaXQgY2FuIGdldC4uLiBpZiBpdCBuZWVkcyBtb3JlLCBpdCdsbCBnZXQgYW5vdGhl
ciBleHRlbnQuICBpZiBpdCBjYW4sIGl0IHdpbGwgY29uY2F0ZW5hdGUgZXh0ZW50cyB0aGF0
IGFyZSBjb250aWd1b3VzLi4uLi5ccGFyDQpccGFyDQpidXQgSSBjb3VsZCBiZSB3cm9uZyAo
SSdtIG9uIDcsIG5vdCA5KSwgaXQgc2hvdWxkIGJlIGluIHRoZSBhZG1pbiBib29rcywgb3Ig
b3RoZXJzIG1heSBjb25maXJtIHdpdGggYW5zd2Vycy5ccGFyDQpccGFyDQpOb3JtYSBKZWFu
XHBhcg0KXHBhcg0KXHBhcg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS1ccGFyDQpGcm9t
OiBrZXZpbnN0cnVja2hvZmZAeWFob28uY29tIFttYWlsdG86a2V2aW5zdHJ1Y2tob2ZmQHlh
aG9vLmNvbV1ccGFyDQpTZW50OiBUdWVzZGF5LCBBdWd1c3QgMTksIDIwMDMgNToyNCBQTVxw
YXINClRvOiBpZHNAaWl1Zy5vcmc7IGZvcnVtLnN1YnNjcmliZXJAaWl1Zy5vcmdccGFyDQpT
dWJqZWN0OiBJbmRleCBleHRlbnRzIFsxNzI1XVxwYXINClxwYXINClxwYXINClVzaW5nIElE
UyA5LjMwRkMyIG9uIGFuIEhQLVVYIDExLjAgYm94LlxwYXINClxwYXINCmluIGNyZWF0aW5n
IGRldGFjaGVkIGluZGV4ZXMsIEkgaGF2ZSBub3RpY2VkIHRoYXQgc29tZXRpbWVzIHRoZSBp
bmRleCBoYXMgbXVsdGlwbGUgZXh0ZW50cyBpbiBhIHBhcnRpY3VsYXIgZGJzcGFjZS4gRm9y
IGV4YW1wbGU6XHBhcg0KXHBhcg0KcHJkZHdoOidkd19hZG1pbicuZmxfa2V5bGlua3MgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDk0Mzc3NiAgICAgICA0MFxwYXINCnBy
ZGR3aDonZHdfYWRtaW4nLmZsX2tleWxpbmtzX24xICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAxMzkzMzggICAgICAgIDhccGFyDQpwcmRkd2g6J2R3X2FkbWluJy5mbF9rZXls
aW5rc19uMSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgMTQ4NjIzICAgICAgICA4
XHBhcg0KcHJkZHdoOidkd19hZG1pbicuZmxfc2hpcHRvICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgIDk0MzU5MiAgICAgICAyNFxwYXINCnByZGR3aDonZHdfYWRtaW4n
LmZsX3NoaXB0b19uMSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA5OTQ5NjIg
ICAgICAgIDRccGFyDQpwcmRkd2g6J2R3X2FkbWluJy5mbF9zaGlwdG9fbjEgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIDU4NDcyICAgICAgICA0XHBhcg0KXHBhcg0KXHBh
cg0KVGhlIGluZGV4ICdmbF9rZXlsaW5rc19uMScgYW5kICdmbF9zaGlwdG9fbjEnIGFyZSBz
cGxpdCBpbnRvIDIgZXh0ZW50cy4gSSBrbm93IEkgY2FuJ3Qgc2V0IHRoZSBleHRlbnQgc2l6
ZSBhcyBJIGNhbiBhIHRhYmxlLiBccGFyDQpccGFyDQpJcyBpdCBhZHZhbnRhZ2VvdXMgdG8g
c3BsaXQgdGhlbSB1cD8gSSdtIG5vdCBzdXJlIHdoYXQgbG9naWMgaXMgdXNlZCBpbiBkZXRl
cm1pbmluZyB3aGVyZSBhbmQgaG93IGxhcmdlIHRoZSBpbmRleCBleHRlbnQgc2hvdWxkIGJl
LiBJdCBsb29rcyBhcyB0aG91Z2ggaXQgZmluZHMgdGhlIGZpcnN0IGF2YWlsYWJsZSBvcGVu
aW5nIGluIHRoZSBkYnNwYWNlIGFuZCB1c2VzIGl0LiBJZiBpdCBkb2Vzbid0IGFsbCBmaXQg
dGhlcmUsIGxvb2sgZm9yIHRoZSBuZXh0IGF2YWlsYWJsZSBvcGVuaW5nLiBIbW1tLi4uXHBh
cg0KXHBhcg0KVElBLFxwYXINClxwYXINCktldmluIFN0cnVja2hvZmZccGFyDQpZYW1haGEg
TW90b3JzIFUuUy5ccGFyDQprZXZpbl9zdHJ1Y2tob2ZmQHlhbWFoYS1tb3Rvci5jb21ccGFy
DQpccGFyDQprZXZpbl9ccGFyDQpccGFyDQp9

--openmail-part-40e4b3f6-00000002--

Messages In This Thread

• Index extents
  KEVIN STRUCKHOFF -- Tuesday, 19 August 2003, at 6:24 p.m.
  • RE: Index extents
    NormaJean.Sebastian@tellabs.com -- Wednesday, 20 August 2003, at 8:51 a.m.
    • RE: Index extents
      Stephanie_Peltier@txnp.uscourts.gov -- Wednesday, 20 August 2003, at 10:12 a.m.
      • RE: Index extents
        Rajib Sarkar -- Wednesday, 20 August 2003, at 11:01 a.m.
  • RE: Index extents
    John Carlson -- Wednesday, 20 August 2003, at 9:35 a.m.
  • Re: Index extents
    ART KAGEL, BLOOMBERG/ 65E 55TH -- Wednesday, 20 August 2003, at 10:43 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.