ca.portal.admin

Re: Question for the DBA's.

Discussion created by ca.portal.admin on Jan 20, 2010
I have done it using SYNCSORT, but I see no reason why DFSORT would not
work just as well, use the COPY option, the pages are already sorted in
the sequence you need them.
Any utility or program that can read one file and write to different
output files based on the number of records read in will work. The SORT
utilities are usually preferred because they require very little coding.

Don't worry about the SMPs, the SMI is based only on the original page
size, and the number of files do not affect it. The expand page does
not change the number or locations of the SMPs.

Tommy Petersen
110 Cokesbury Rd
Room 542H
Lebanon, NJ 08833

Phone:
Internal 200 - 3699
External (908) 236-3699
Fax: (908) 236-3692




""Petzold, Lutz""
<PetzoldL@AETNA.C
OM>
To
Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
Public Discussion
cc
Forum
<IDMS-L@LISTSERV.
Subject
IUASSN.COM> Question for the DBA's.


01/19/2010 04:00
PM


Please respond to
IDMS Public
Discussion Forum
<IDMS-L@LISTSERV.
IUASSN.COM>






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
*****JuliusBaer Disclaimer***** This e-mail is for the intended =
recipient only and may contain confidential or privileged information. =
If you have received this e-mail by mistake, please contact us =
immediately and completely delete it (and any attachments) and do not =
forward it or inform any other person of its contents. If you send us =
messages by e-mail, we take this as your authorization to correspond =
with you by e-mail, however, we will not accept the electronic =
transmission of orders/instructions without a specific agreement being =
in place to govern the same. If you do not wish to receive any further =
e-mail correspondence please let us know. E-mail transmission cannot be =
guaranteed to be secure or error-free as information could be =
intercepted, amended, corrupted, lost, destroyed, arrive late or =
incomplete, or contain viruses. Neither the Julius Baer Group nor the =
sender accept liability for any errors or omissions in the content of =
this message which arise as a result of its e-mail transmission. Please =
note that all e-mail communications to and from the Julius Baer Group =
may be monitored. This communication is for informational purposes only. =
It is not intended as an offer or solicitation for the purchase or sale =
of any financial instrument or as an official confirmation of any =
transaction.
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
zIIP usage
"Hello All,

I am trying to get a feel for how many sites are using the zIIP option
available with Release 17 and what percentage of CP cycles are being
offloaded to the zIIP engines.=20
"
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.
"I just use IDCAMS REPRO with a SKIP and a COUNT parameter. Dead easy.

Chris Trayler

Outcomes