ca.portal.admin

ADSO Applications without a Mainframe

Discussion created by ca.portal.admin on Sep 13, 2007
Does anyone know of any products that host ADSO Applications without a
Mainframe?



Joe S Cates, Database Analyst II

Systems Architecture and Operations
Database Management/Unix Administration

Montgomery County Public Schools

Rockville, MD 20850


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








Normal

Normal
Re: Index Levels
"I don't worry too much about how many levels an index has. My site has lots
and lots of indexes that are 5 and 6 levels deep. I prefer to have smaller
SR8's. It seems to help with reducing ""collisions"" while updating the index
structure. Unless you rebuild often, the index will drop 1 more level than
what you built it at. This isn't a big deal. I always keep the max SR8 size
to 25% of the page or less. Build in plenty of free space and make sure
there are plenty of displacement pages. If the top levels have crawled out
of the displacement it is time to rebuild. Orphans are always a problem.
Don't let the orphan chains get too long. I have gone SOS in pool 255
because of this (this was before locks were remove from pool 255, SYSLOCKS
now manages that storage. And you don't want to run out of SYSLOCK storage
either). I have been isolating data areas and index areas into seperate
buffer pools, data in one and index in another. Buffers with index areas
only are much easier to tune.

To answer your original question, many is relative and really depends on the
length of the key. I don't like index area page sizes larger than 13K. I
would prefer to see them 8K or less. Large in my world is 10,000,000
entries, really big is 30 - 40 million.


Mark Grindstaff

----- Original Message -----
From: ""Hall, Dan (GE Comm Fin)"" <Dan.Hall@GE.COM>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Thursday, September 13, 2007 2:55 PM
Subject: Index Levels


Listers,
I am working on resizing a lot of indexes in our environment. The manual
states that you should design for a 3 level index except for ""indexes
with many entries..."". Nowhere in the manuals or on CA's website can I
find a definition of what they consider ""many"" in this circumstance. I
have some ideas on where I would draw the line, but would like to get
some ideas from the list.

So, my question is: At what point do you decide to target an index for 4
levels (or even 5) instead of the recommended 3 level's?

Thanks for any assistance.

Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Index Levels
"Dan,

The number of levels is a function of SR8 size as a percentage of page
size rather than number of entries in index. If the index key is large in
terms of storage requirements, then the SR8 will be larger and a 3 level
index could be impossible while respecting limitation that the SR8 be
approximately 30% of page size.

John Wheeler


--- ""Hall, Dan (GE Comm Fin)"" <Dan.Hall@GE.COM> wrote:
Listers,
I am working on resizing a lot of indexes in our environment. The manual
states that you should design for a 3 level index except for ""indexes
with many entries..."". Nowhere in the manuals or on CA's website can I
find a definition of what they consider ""many"" in this circumstance. I
have some ideas on where I would draw the line, but would like to get
some ideas from the list.

So, my question is: At what point do you decide to target an index for 4
levels (or even 5) instead of the recommended 3 level's?

Thanks for any assistance.

Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/
____________________________________________________________________________________
Check out the hottest 2008 models today at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
CASDATA
"Hello All:

Anybody out there still running CASDATA? If so, on what release of IDMS?

I have a client still running release 12 they have CAS and use CASDATA
extensively.

We are looking at upgrading but we are afraid of the CASDATA Component.

Bill Allen
(704) 641-0296



************************************** See what's new at http://www.aol.com
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: CASDATA
"We have a client running casdata and are trying to upgrade to 16.0 but
cannot do it until we get a fix from the vendor for casdata.

Dick

Richard C Borman/GIS/CSC
CSC/GIS Idms System Support
9305 Lightwave Ave
San Diego, Ca 92193-9011
home 760-787-1075
cell 858-245-4761
rborman@csc.com



--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------





Bill Allen
<ARCHCONB@AOL.COM
> To
Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
Public Discussion cc
Forum
<IDMS-L@LISTSERV. Subject
IUASSN.COM> CASDATA


09/14/2007 08:19
AM


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






Hello All:

Anybody out there still running CASDATA? If so, on what release of IDMS?

I have a client still running release 12 they have CAS and use CASDATA
extensively.

We are looking at upgrading but we are afraid of the CASDATA Component.

Bill Allen
(704) 641-0296



************************************** See what's new at http://www.aol.com
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: CASDATA
"Hi Bill,

There was a thread in March of this year about CASDATA and release 16.0. I
believe the answer was that there is a version for 16.0 and it did require a
new version of CASDATA from SSA which is now Infor. That said, you would
need to be current in maintenance to get it.

Last I checked, James Jackson was the contact:

James Jackson
Senior Technical Support Consultant
Product Support
Ifor
Ofice: 312-474-733
fax: 618-475-8039
james.jackson@infor.com

Outcomes