Question for the DBA's.

[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


***************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, Windstream requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Question for the DBA's.
"I have done this several times, creating as many as 16 files.
Simply:
1. Determine how many file you want
2. Find an SMP page for the beginning of each new file.
Page size - 32 / 2 should get you each SMP page.
3. Create a sort extracting each page range by db-key that you want, or
just the number of pages in a file.=20
4. Run the sorts that create the new files that you want.
5. Make changes to a Test DMCL modifying the area with the new Files and
Page ranges.
6. Add the new files to your database file startup deck or proc.
7. Run a space report for the old area and old files.
8. Run a space report for the old area and new files.
9. The results on the space, number of pages, and records should be
identical.
Ok, maybe it's not that simple, and it took some research and testing to
get it to work, but its implementation was very easy and successful.

Del Barlett
Database Administrator
NH Department of Information Technology
Operations, DoS
603-271-1062
www.doit.nh.gov
=20
Statement of Confidentiality: The contents of this message are
confidential. Any unauthorized disclosure, reproduction, use or
dissemination (either whole or in part) is prohibited. If you are not
the intended recipient of this message, please notify the sender
immediately and delete the message from your system.