ca.portal.admin

TCP/IP sockets programs

Discussion created by ca.portal.admin on Sep 12, 2007
At our site, we have crossed the first hurdle of accessing external web

services using the IDMS sockets interface. Now we are looking at

accepting incoming requests. It appears to me that, in order to handle

multiple users, the generic listener program must somehow hand off the

request to another task for processing. But the sample generic listener

provided by CA does not do that. Can anyone give me some sample code

that does? Or am I getting in over my head here?



Kay Rozeboom

State of Iowa

Information Technology Enterprise

Department of Administrative Services

Telephone: 515.281.6139 Fax: 515.281.6137

Email: Kay.Rozeboom@Iowa.Gov
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
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
"Hi Dan:

I don't exactly recall what constituted ""many"" entries for an index, but
over the years, my theory has been to try to keep the size of the SR8's in
line with the database area characteristics, rather than worry about the
number of levels.

Certainly, there are arguments on both sides. However, consider a database
with 1M members, and a concatenated index key of 100 bytes (not at all that
terribly large, in today's referential environment). To maintain a 3-level
index, you'd have to have an IBC of 100. 100x100 = 10K bytes, just for the
keys.

So, a 10K+ record is likely to strain the ""not larger than 30% of page size""
rule for most database areas, with or without page reserve.

Of course, there are database areas that have index SR8 entries that are
much larger than 30% of page size - as always, ""it all depends on the
environment"". One must consider online and batch
updates/additions/deletions, types of processing, service levels to meet,
etc.

Just my initial 2cents, but hope it gives you some ideas regarding
trade-offs.

Regards,

Tom Schoenborn



----- Original Message -----
From: ""Hall, Dan (GE Comm Fin)"" <Dan.Hall@GE.COM>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Thursday, September 13, 2007 1: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
ADSO Applications without a Mainframe
"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
"Dan

Each level represents an additional I/O to search via the index, so
keeping indexes to the fewest levels is best.

The number of levels is directly related to the IBC. The IBC value
raised to the power of the number of levels is the number of keys that
can be held (number of members connected).

For example, if your IBC is 50, you could connect 125,000 (that is
50^3) members in a 3-level index. After that, it spawns a new top-level
SR8, so now you have 4 levels. 50^4 gives you a maximum of 6,250,000
members.



Jim Ritterbusch Mail:
GE Capital Solutions 10 Riverview Dr.
101 East Ridge Danbury, CT 06811

T 203.749.3585 F 203.749.4016
D 8*662.3585 E james.ritterbusch@ge.com
http://www.ge.com/capitalsolutions/

Outcomes