ca.portal.admin

Fast Access Users

Discussion created by ca.portal.admin on Apr 5, 2006
Hello All:

I am planning to use Fast Access for an Unload and Reload.

I do not have much experience with this product for UPDATE jobs.

I ran a few test unloads and compared them to IDMSQSAM and PREFETCH and
Fast
Access was the better of the three methods. We are running IDMS Release
16.0
Service Pack Two and Fast Access Release 8.0.

Here is the performance information:

Fast Access, 5.28 Minutes Elapsed Time, 6,430 EXCP'S, MAXTRKS=600,
READTRKS=15,ADAPT=ON, DMCL BUFFER=400 Pages

IDMSQSAM, 9.10 Minutes Elapsed Time, 82,286 EXCP'S, IDMSQSAM=ON,
QSAMBUF#=250, DMCL BUFFER=400 Pages

PREFETCH, 9.67 Minutes Elapsed Time, 48,373 EXCP'S, PREFETCH=ON,
PREFETCH_BUF=100, DMCL BUFFER=400 Pages

Does anyone out there have samples of your parameters for a one step
reload
that will improve performance of the update steps?

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
cpu limits when changing processors?
"for those of yo who enforce CPU limits anywhere within IDMS, when you get
a new processor, do you modify those limits by the same percentage that
the MIPs went up or down?

in the other DBMS (the database that must not be spoken), some limits are
enforced by Hardware Service Units which represent the actual amount of
work that can be done (# of instructions?), NOT the amount of CPU time
needed to do the work. So in the DBMS (that must not be spoken) we need
not change ASUTIME upon every processor up/downgrade because we do not
want the amount of work allowed to change, we do not care if the amount of
time needed to do the work changes.

now to IDMS - allowing X seconds of CPU time for a task on processor A
would equate to a DIFFERENT amount of work allowed with a limit of X
seconds on a different CPU with a dirrerent MIPs rating - does any shops
care? or do any shops reduce CPU limits by (lets say) 10% if , as a result
of a cpu upgrade, the MIPS went up by 10%

in other words - service units seem to be an absolute - tied to
#instructions - a unit of work will always take the same # service units
to do its job on ANY processor without regard to MIPs - is THAT what we
want to base limits on, or upon the number of CPU seconds needed to
complete the task?

I hope this question makes sense

Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-710-3038
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
IUA hall of fame recent inductees?
"i was checking out the IUA website, and in particular the Hall of Fame
list .. i see no updates since 2003

were there a 2004 or 2005 (or 2006) inductees?

just curious


Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-710-3038
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
** Announcement ** UKIUA Meeting 4th May 2006
"The UK IDMS User Association and CA are happy to announce a UKIUA
meeting on 4th May 2006 to which all IDMS users are welcome to register
to attend.

It costs NOTHING and the benefits are enormous.

The highlight is a visit from Mike Mickelsen from IDMS Level 2 support
talking about the future plans for IDMS and he is also giving a talk
going into some details about how IDMS works with IBM's Language
Environment (LE). A subject which affects everyone from DBAs to
Programmers.

The full agenda is available on the UKIUA website at: www.ukiua.org

It will also be a great opportunity to meet with him and others and
benefit from all the experienced brains present

The meeting will take place in the Solution Centre inside CA's main
European HQ building in Slough, near London's Heathrow Airport.
Directions to this can be found at
http://www.ca.com/uk/contact/eurohq.htm .

Please register for this event by sending an email To:
steve.cannon@ca.com
(mailTo:steve.cannon@ca.com?subject=UKIUA_Meeting_4th_May_2006)

See you there

Steve Rundle
Chair UKIUA

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








Normal

Normal
IDMS R16 upgrade at the Cleveland Clinic - a success!
"Kay's note about her upgrade came in the weekend we were making our large production conversion. We went up to 16.2 on March 26th and things went very smoothly with almost no issues at all.

We had three SVC dumps the first week with 1117, 1136 and 0C4 abends in IDMSDBMS, all dealing with compressed records (VLRs). At the end of the week, we moved in a revised module with all published maintenance on (including QO76072 to address the OC4) and a test apar for the 1136 which I believe also reduces our chance of getting an 1117. We've had no DBMS abends since then.

One other minor thing we noticed was the DC256004 messages put out during startup showed all the report queues being kept, even though the expired ones were being deleted. A test APAR has been created to fix this. We also had one SMPC in RHDCWTL following a stall in ADS. An SP2/3 test apar was provided for us since there had only been an SP0/1 fix created until our issue. Those two fixes along with recent hypers to DBIO, DBRC and UAJN will be going in next week though our change control procedures, since the problems have not been very serious.

The only other issue was with one librarian skeleton which was taking linkage editor defaults and a program going up using it was affected by a change in AMODE in an IDMS module. It was easily corrected.

We haven't moved in any of the CPU reduction or other recent non-Hyper fixes, but we will soon be testing under z/OS 1.7 and will be doing some PM as we go through that process on our various LPARs.

We've had no known issues with our 3rd party products: OCA-Syslink, OCA-MQseries, EZ-Reorg and Sequential Prefetch.

Happy Easter,
John

------------------------------------------------------------------------------
Confidentiality Note: This message is intended for use only by the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. Thank you.
------------
Visit us online at our award-winning http://www.clevelandclinic.org for a complete listing of Cleveland Clinic services, staff and locations from one of the country's leading hospitals.
==============================================================================

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








Normal

Normal
Re: Available PAGE Ranges
"I have such a task. The DBAs demanded it some years ago, also shows
expand page info.
Pgm responds to two task codes, one of which sorts output by page group,
page range, the other by segment name.
Requires you also genning our own online sort. Can send some sample
output easily.
Hartman Canon
Lockheed-Martin.

Outcomes