ca.portal.admin

to close or not to close?

Discussion created by ca.portal.admin on Sep 29, 2005
we have many native IDMS VSAM files that are re-built each night - for
those files we perform the following:

v area ofl
v area close
v file dealloc



is the close necessary? when I do this kind of thing by hand, I do not
close, and seem to have no trouble - is the close only beneficial to
NVSAM
files, or does it really provide a needed step between varying the area
offline and deallocating the respective file?

thanks,
Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-580-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
Perfmon Information (RESOLVED)
"Hello All:

The programming staff found the problem, it was a currency issue.

They were storing the record into the same sorted set all of the time so the
sorted set was getting longer and longer, 16,545 members. This was a very
big area, 550,000 pages across nine files.

This accounted for the long elapsed run times, the number of pages read and
the number of record locks.

Thanks to everyone who responded.

Bill Allen

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Perfmon Information (RESOLVED)
"But can you programmatically determine (from looking at the member record)
to which owner they belong?











Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-580-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: Perfmon Information (RESOLVED)
"Bill,
There was one statement you made in an earlier post that I believe is in
error. You stated that an insertion into a sorted set will cause IDMS to
read the set from the owner forward (using the NEXT pointer) until the
insertion point is found.
However, I remember from my programming days that if you insert a record
into a sorted set, IDMS will first reestablish currency in that set (if
there is a current of set) and then determine if the record to be inserted
is further down the chain (in the NEXT direction). If so, it starts reading
the set from the current member, not from the owner. If the record is
further back in the chain, it will start from the owner.
I once had an issue where sorted sets were getting very long and I had to
keep inserting into them. My advantage was that the data coming in was
presorted. What I did was create a VSAM file (initialized on each run)
which kept track of the current of set for every set occurance by keeping
the data key of the owner and the DBKEY of the current of set. When I read
my next piece of data, I would determine which set it needed to be inserted
into, read the VSAM file to get the DBKEY for the last time I was in that
set, reestablish currency, and then STORE my record. This caused IDMS to
only read from the point of last insertion to the point of the new
insertion. Once the new record was stored, I'd modify my VSAM record to
update the DBKEY for that set. It cut the run time down by hours.

Joe Lupico
IDMS System Support
""Our World is a Happy World""

Outcomes