ca.portal.admin

Re:resolving EXTEND SPACE

Discussion created by ca.portal.admin on Feb 24, 2009
i am interested in how other IDMS sites deal with this

when you EXTEND SPACE to ""dynamically"" give more space to an area,

do you immediately (within a week) follow up with an unload/reload/reorg to make the entire area calc-available, or do you wait for a pre-existing open window (within 3 months), or do you never revisit the area to resolve the extend space?

thanks,

Chris Hoelscher
Senior IDMS & DB2 Database Administrator Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: resolving EXTEND SPACE
"I have run an extend space in the past, at another site, and found that=0D=
=0Ait is the least time intrusive of all options, certainly faster the a=0D=
=0Areorg=2E it's something you do to avoid the 1211=2E but all it does is=
add=0D=0Aspace at the end of the old area=2E eventually you'll definitely=
want to=0D=0Ado an unload/reload=2E=0D=0A=0D=0ALutz Petzold=0D=0ATDM UDB/I=
DMS Support=0D=0A401-782-2265=0D=0APage 860 366 0865 or Telalert=0D=0A =0D=
=0A =0D=0A=0D=0A=0D=0AThis e-mail may contain confidential or privileged in=
formation=2E If=0Ayou think you have received this e-mail in error, please =
advise the=0Asender by reply e-mail and then delete this e-mail immediately=
=2E=0AThank you=2E Aetna
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: resolving EXTEND SPACE
"I have run an extend space in the past, at another site, and found that
it is the least time intrusive of all options, certainly faster the a
reorg. it's something you do to avoid the 1211. but all it does is add
space at the end of the old area. eventually you'll definitely want to
do an unload/reload.

Lutz Petzold
TDM UDB/IDMS Support
401-782-2265
Page 860 366 0865 or Telalert




This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: resolving EXTEND SPACE
"We used to do something tricky invented by a former DBA that worked like an=
EXTEND SPACE. We would let a file fill up, then add an additional file to=
the area for the VIA records only. Every time we did this, the performanc=
e got worse - slow response time and lots of lock manager abends on space m=
anagement pages. What we finally realized was that every time a record was=
stored, IDMS was bouncing through the space management pages in all of the=
full files until it found some empty space. Since the empty space was all=
in the most recently-added file, everyone was then trying to update the sa=
me space management page at once.

While this was an extreme example, I believe that EXTEND SPACE will always =
add this type of overhead. While most situations may not be bad enough to =
cause lock managers abends, be aware that, under the covers, you are adding=
additional I/O and lock manager waits. I vote for doing the unload/reload=
as soon as possible.
=20

Outcomes