ca.portal.admin

Question for the DBA's.

Discussion created by ca.portal.admin on Jan 19, 2010
Latest reply on Jan 19, 2010 by ca.portal.admin
We have a very large area, that is split between two files.
We want to split this area into 10 files, merely by DFSORTING by page
number and then stuffing the pages into the appropriate file. The
segment/dmcl definition will be changed accordingly. No unload/reload
is planned, due to the time constraints. So far, so good? Now we also
want to do an expand page, after the area has been split into 10 files.

This all sounds fine to me, but I am thinking about the SMI, which will
be changed to the appropriate size for the expand page, but is the space
management interval computed differently depending on the number of
files in an area? Or is space management interval planning done
strictly on the page range and page size?

Any suggestions would be welcome.

Lutz Petzold
TDM DB2 LUW/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: Question for the DBA's.
"Hi Lutz,

The SMI is based on the page size when the area is initialized,
regardless of the number of files.

For splitting the file, you could use IDMSBCF, with the BACKUP/RESTORE
by area. You backup with the 2 file definition, then you restore with
the 10 file definition (prior to the EXPAND PAGE).

Laura Rochon
Ajilon Consulting

On 1/19/2010 3:55 PM, Petzold, Lutz wrote:
We have a very large area, that is split between two files=2E=0D=0AWe want =
to split this area into 10 files, merely by DFSORTING by page number and th=
en stuffing the pages into the appropriate file=2E The segment/dmcl defini=
tion will be changed accordingly=2E No unload/reload is planned, due to th=
e time constraints=2E So far, so good? Now we also want to do an expand p=
age, after the area has been split into 10 files=2E=0D=0A=0D=0AThis all sou=
nds fine to me, but I am thinking about the SMI, which will be changed to t=
he appropriate size for the expand page, but is the space management interv=
al computed differently depending on the number of files in an area? Or is=
space management interval planning done strictly on the page range and pag=
e size?=0D=0A=0D=0AAny suggestions would be welcome=2E=0D=0A=0D=0ALutz Petz=
old=0D=0ATDM DB2 LUW/IDMS Support=0D=0A401-782-2265=0D=0APage 860 366 0865 =
or Telalert=0D=0A=0D=0A=0D=0A=0D=0A =0D=0A=0D=0AThis e-mail may contain con=
fidential or privileged information=2E If=0Ayou think you have received thi=
s e-mail in error, please advise the=0Asender by reply e-mail and then dele=
te 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: Question for the DBA's.
"My preference would to=20
A) dump the area (old IDMSDUMP now BACKUP AREA) by area; =20
B) format the new areas (using the same page range.)
C) Restore the area by area.
And you're done. Now you can do the xpage if you wish.

I would be very much afraid of doing this with a operating system
utility. Also, ISTR that the first block in each file has control
information in it. I could be wrong about that though.

Ps. Our largest area has 90 31k 8904 byte pages.

Dick

Richard Pierce
(617) 973-8911
richard.pierce@state.ma.us

Outcomes