IDS Forum

RE: Rows per page

Posted By:
Date:

Karen,
I am not familiar with IDS 9.2 or .4 yet, but on 7.31....
if you are adding columns to the end of the table, you will be working
with "table versioning"/in-place alter issues. As you add new rows to
the table, they will be the new size. As you update old rows, they will
expand to the new size. However any old rows that are not updated (just
reading/selecting won't change them) will remain the old size until they
are updated by users or "fake updated" by you, or hit by a table reorg.

If you reorg the table (unload/rebuild/reload), you will experience a
space consumption potentially greater than you thought would happen as
each row that had not been touched will expand to the new size. you may
avoid this by running an update SQL to hit all rows (where 1=1) now
instead of seeing the space hit later.

We almost got caught by this on a nearly 32GB table. We planned the
reorg weekend with space in mind for the current size and it's
fragmentation need. During the weekend, we almost got slaughtered...
the reorg took longer to expand all the rows and of course it took up
more space. We had tested this, but were not given enough time to fully
test.... but we survived.

Again, I don't know if this is true in 9.x, but it is in 7.3
Norma Jean



-----Original Message-----
From: keith.simmons@bbslimited.co.uk
[mailto:keith.simmons@bbslimited.co.uk]
Sent: Monday, March 03, 2003 8:40 AM
To: ids@iiug.org; forum.subscriber@iiug.org
Subject: RE: Rows per page [552]


Karen

As much of the record as will fit on a page will go on the first free
page
along with a pointer to the remainder. The rest of the record will
occupy
part of a 'remainder page' pointed to by the first part. The remainder
page
will only hold remainders and each new record will start on a new page.

Keith

-> -----Original Message-----
-> From: Egan Karen-.... [mailto:Karen.Egan@motorola.com]
-> Sent: Monday, March 03, 2003 1:16 PM
-> To: ids@iiug.org
-> Subject: Rows per page [550]
->
->
-> Hi all,
->
-> We are running IDS 9.21 UC6 on Solaris 8. I have a table
-> which we are adding 2/3 news columns to. This will increase
-> the size of a row to greater than 2Kb ie. one page.
->
-> Can anyone tell me what affect this will have on the space
-> required to store the data. I understand that retrieval will
-> be affected but is storage/space also affected.
->
-> Regards,
-> Karen
->

************************************************************************
**********
This message is sent in strict confidence for the addressee only. It
may
contain legally privileged information. The contents are not to be
disclosed
to anyone other than the addressee. Unauthorised recipients are
requested
to preserve this confidentiality and to advise the sender immediately of
any
error in transmission.
This footnote also confirms that this email message has been swept for
the
presence of computer viruses, however we cannot guarantee that this
message
is free from such problems.
************************************************************************
**********



--openmail-part-39e3a146-00000002
Content-Type: application/rtf
Content-Disposition: attachment; filename="BDY.RTF"
;Creation-Date="Mon, 3 Mar 2003 10:09:20 -0600"
Content-Transfer-Encoding: base64

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYw
XGZzd2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmls
XGZjaGFyc2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5l
dzt9fQ0Ke1xjb2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1
NTt9DQpcdWMxXHBhcmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIEthcmVuLFxwYXINCkkg
YW0gbm90IGZhbWlsaWFyIHdpdGggSURTIDkuMiBvciAuNCB5ZXQsIGJ1dCBvbiA3LjMxLi4u
LlxwYXINCmlmIHlvdSBhcmUgYWRkaW5nIGNvbHVtbnMgdG8gdGhlIGVuZCBvZiB0aGUgdGFi
bGUsIHlvdSB3aWxsIGJlIHdvcmtpbmcgd2l0aCAidGFibGUgdmVyc2lvbmluZyIvaW4tcGxh
Y2UgYWx0ZXIgaXNzdWVzLiAgQXMgeW91IGFkZCBuZXcgcm93cyB0byB0aGUgdGFibGUsIHRo
ZXkgd2lsbCBiZSB0aGUgbmV3IHNpemUuICBBcyB5b3UgdXBkYXRlIG9sZCByb3dzLCB0aGV5
IHdpbGwgZXhwYW5kIHRvIHRoZSBuZXcgc2l6ZS4gIEhvd2V2ZXIgYW55IG9sZCByb3dzIHRo
YXQgYXJlIG5vdCB1cGRhdGVkIChqdXN0IHJlYWRpbmcvc2VsZWN0aW5nIHdvbid0IGNoYW5n
ZSB0aGVtKSB3aWxsIHJlbWFpbiB0aGUgb2xkIHNpemUgdW50aWwgdGhleSBhcmUgdXBkYXRl
ZCBieSB1c2VycyBvciAiZmFrZSB1cGRhdGVkIiBieSB5b3UsIG9yIGhpdCBieSBhIHRhYmxl
IHJlb3JnLlxwYXINClxwYXINCklmIHlvdSByZW9yZyB0aGUgdGFibGUgKHVubG9hZC9yZWJ1
aWxkL3JlbG9hZCksIHlvdSB3aWxsIGV4cGVyaWVuY2UgYSBzcGFjZSBjb25zdW1wdGlvbiBw
b3RlbnRpYWxseSBncmVhdGVyIHRoYW4geW91IHRob3VnaHQgd291bGQgaGFwcGVuIGFzIGVh
Y2ggcm93IHRoYXQgaGFkIG5vdCBiZWVuIHRvdWNoZWQgd2lsbCBleHBhbmQgdG8gdGhlIG5l
dyBzaXplLiAgeW91IG1heSBhdm9pZCB0aGlzIGJ5IHJ1bm5pbmcgYW4gdXBkYXRlIFNRTCB0
byBoaXQgYWxsIHJvd3MgKHdoZXJlIDE9MSkgbm93IGluc3RlYWQgb2Ygc2VlaW5nIHRoZSBz
cGFjZSBoaXQgbGF0ZXIuXHBhcg0KXHBhcg0KV2UgYWxtb3N0IGdvdCBjYXVnaHQgYnkgdGhp
cyBvbiBhIG5lYXJseSAzMkdCIHRhYmxlLiAgV2UgcGxhbm5lZCB0aGUgcmVvcmcgd2Vla2Vu
ZCB3aXRoIHNwYWNlIGluIG1pbmQgZm9yIHRoZSBjdXJyZW50IHNpemUgYW5kIGl0J3MgZnJh
Z21lbnRhdGlvbiBuZWVkLiAgRHVyaW5nIHRoZSB3ZWVrZW5kLCB3ZSBhbG1vc3QgZ290IHNs
YXVnaHRlcmVkLi4uIHRoZSByZW9yZyB0b29rIGxvbmdlciB0byBleHBhbmQgYWxsIHRoZSBy
b3dzIGFuZCBvZiBjb3Vyc2UgaXQgdG9vayB1cCBtb3JlIHNwYWNlLiAgV2UgaGFkIHRlc3Rl
ZCB0aGlzLCBidXQgd2VyZSBub3QgZ2l2ZW4gZW5vdWdoIHRpbWUgdG8gZnVsbHkgdGVzdC4u
Li4gYnV0IHdlIHN1cnZpdmVkLlxwYXINClxwYXINCkFnYWluLCBJIGRvbid0IGtub3cgaWYg
dGhpcyBpcyB0cnVlIGluIDkueCwgYnV0IGl0IGlzIGluIDcuM1xwYXINCk5vcm1hIEplYW5c
cGFyDQpccGFyDQpccGFyDQpccGFyDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLVxwYXIN
CkZyb206IGtlaXRoLnNpbW1vbnNAYmJzbGltaXRlZC5jby51a1xwYXINClttYWlsdG86a2Vp
dGguc2ltbW9uc0BiYnNsaW1pdGVkLmNvLnVrXVxwYXINClNlbnQ6IE1vbmRheSwgTWFyY2gg
MDMsIDIwMDMgODo0MCBBTVxwYXINClRvOiBpZHNAaWl1Zy5vcmc7IGZvcnVtLnN1YnNjcmli
ZXJAaWl1Zy5vcmdccGFyDQpTdWJqZWN0OiBSRTogUm93cyBwZXIgcGFnZSBbNTUyXSBccGFy
DQpccGFyDQpccGFyDQpLYXJlblxwYXINClxwYXINCkFzIG11Y2ggb2YgdGhlIHJlY29yZCBh
cyB3aWxsIGZpdCBvbiBhIHBhZ2Ugd2lsbCBnbyBvbiB0aGUgZmlyc3QgZnJlZSBwYWdlXHBh
cg0KYWxvbmcgd2l0aCBhIHBvaW50ZXIgdG8gdGhlIHJlbWFpbmRlci4gVGhlIHJlc3Qgb2Yg
dGhlIHJlY29yZCB3aWxsIG9jY3VweVxwYXINCnBhcnQgb2YgYSAncmVtYWluZGVyIHBhZ2Un
IHBvaW50ZWQgdG8gYnkgdGhlIGZpcnN0IHBhcnQuIFRoZSByZW1haW5kZXIgcGFnZVxwYXIN
CndpbGwgb25seSBob2xkIHJlbWFpbmRlcnMgYW5kIGVhY2ggbmV3IHJlY29yZCB3aWxsIHN0
YXJ0IG9uIGEgbmV3IHBhZ2UuXHBhcg0KXHBhcg0KS2VpdGhccGFyDQpccGFyDQotPiAtLS0t
LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLVxwYXINCi0+IEZyb206IEVnYW4gS2FyZW4tLi4uLiBb
bWFpbHRvOkthcmVuLkVnYW5AbW90b3JvbGEuY29tXVxwYXINCi0+IFNlbnQ6IE1vbmRheSwg
TWFyY2ggMDMsIDIwMDMgMToxNiBQTVxwYXINCi0+IFRvOiBpZHNAaWl1Zy5vcmdccGFyDQot
PiBTdWJqZWN0OiBSb3dzIHBlciBwYWdlIFs1NTBdIFxwYXINCi0+IFxwYXINCi0+IFxwYXIN
Ci0+IEhpIGFsbCxccGFyDQotPiBccGFyDQotPiBXZSBhcmUgcnVubmluZyBJRFMgOS4yMSBV
QzYgb24gU29sYXJpcyA4LiBJIGhhdmUgYSB0YWJsZSBccGFyDQotPiB3aGljaCB3ZSBhcmUg
YWRkaW5nIDIvMyBuZXdzIGNvbHVtbnMgdG8uIFRoaXMgd2lsbCBpbmNyZWFzZSBccGFyDQot
PiB0aGUgc2l6ZSBvZiBhIHJvdyB0byBncmVhdGVyIHRoYW4gMktiIGllLiBvbmUgcGFnZS4g
XHBhcg0KLT4gXHBhcg0KLT4gQ2FuIGFueW9uZSB0ZWxsIG1lIHdoYXQgYWZmZWN0IHRoaXMg
d2lsbCBoYXZlIG9uIHRoZSBzcGFjZSBccGFyDQotPiByZXF1aXJlZCB0byBzdG9yZSB0aGUg
ZGF0YS4gSSB1bmRlcnN0YW5kIHRoYXQgcmV0cmlldmFsIHdpbGwgXHBhcg0KLT4gYmUgYWZm
ZWN0ZWQgYnV0IGlzIHN0b3JhZ2Uvc3BhY2UgYWxzbyBhZmZlY3RlZC5ccGFyDQotPiBccGFy
DQotPiBSZWdhcmRzLFxwYXINCi0+IEthcmVuXHBhcg0KLT4gXHBhcg0KXHBhcg0KKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKlxwYXINClRoaXMgbWVzc2FnZSBpcyBzZW50IGluIHN0
cmljdCBjb25maWRlbmNlIGZvciB0aGUgYWRkcmVzc2VlIG9ubHkuICBJdCBtYXlccGFyDQpj
b250YWluIGxlZ2FsbHkgcHJpdmlsZWdlZCBpbmZvcm1hdGlvbi4gVGhlIGNvbnRlbnRzIGFy
ZSBub3QgdG8gYmUgZGlzY2xvc2VkXHBhcg0KdG8gYW55b25lIG90aGVyIHRoYW4gdGhlIGFk
ZHJlc3NlZS4gVW5hdXRob3Jpc2VkIHJlY2lwaWVudHMgYXJlIHJlcXVlc3RlZFxwYXINCnRv
IHByZXNlcnZlIHRoaXMgY29uZmlkZW50aWFsaXR5IGFuZCB0byBhZHZpc2UgdGhlIHNlbmRl
ciBpbW1lZGlhdGVseSBvZiBhbnlccGFyDQplcnJvciBpbiB0cmFuc21pc3Npb24uXHBhcg0K
VGhpcyBmb290bm90ZSBhbHNvIGNvbmZpcm1zIHRoYXQgdGhpcyBlbWFpbCBtZXNzYWdlIGhh
cyBiZWVuIHN3ZXB0IGZvciB0aGVccGFyDQpwcmVzZW5jZSBvZiBjb21wdXRlciB2aXJ1c2Vz
LCBob3dldmVyIHdlIGNhbm5vdCBndWFyYW50ZWUgdGhhdCB0aGlzIG1lc3NhZ2VccGFyDQpp
cyBmcmVlIGZyb20gc3VjaCBwcm9ibGVtcy5ccGFyDQoqKioqKioqKioqKioqKioqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq
KioqKioqXHBhcg0KXHBhcg0KfQ==

--openmail-part-39e3a146-00000002--

Messages In This Thread

• Rows per page
  Egan Karen-kegan01 -- Monday, 3 March 2003, at 8:15 a.m.
  • RE: Rows per page
    Simmons, Keith -- Monday, 3 March 2003, at 9:40 a.m.
    • RE: Rows per page
      NormaJean.Sebastian@tellabs.com -- Monday, 3 March 2003, at 11:12 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.