Here is a summary of the responses I got. Thank you Steve Sharp, Michael Morin and Daniel 1) There is no license.dat file associated with ARCIMS...so you could have it running many places...but always good to be on the up and up. As far as SDE is concerned I can grab SDE layers from multiple ARCVIEW or ARC/INFO sessions so on licence for SDE would only be limited by the number of Oracle licences you have. I have 7 concurrent licences but only processes or uses a licence when you get a hit...so there really is not much of a problem there either. Michael D. Morin Digital Cartographer Office of Information Resource Management Ill. Dept. of Commerce and Community Affairs 620 East Adams Springfield, Ill. 62701 Phone: 217/785-7180 Fax: 217/782-9217 email: mmorin@commerce.state.il.us Coordinates: UTM Zone 16 NAD 27 Easting: 273374; Northing: 4408747 2) Neeraj, In answer to your licensing issues between ArcIMS - SDE - Oracle: In your ArcIMS setup (admin gui) you determine the maximum number of "instances" or "treads" to use when connecting to SDE. Each one of these threads requires one SDE connect license which in turn requires one Oracle connect. So as an example if you set a maximum number of ArcIMS - SDE treads at "6" this will create six connections to SDE which in turn will use six oracle connections. This means that the first six concurrent ArcIMS clients will go straight through to the DB and any additional clients will queue. Here at TCC we have: - ArcIMS max threads = 6 - Number of ArcIMS clients = 250 (obviously not concurrent) - ArcSDE connect licenses = 55 (heaps of additional connects for non ArcIMS clients - ArcInfo, ArcView etc) - We use Oracle Standard Edition on a dual processor Sun Ultra 2 to get around the huge enterprise edition bill! Hope this is a help and you sort out your requirements. DANIEL LOADER... ----------------------------------------------------------------- GIS Analyst, Toowoomba City Council, ----------------------------------------------------------------- 3) -------- Original Message -------- Subject: SUM: ArcSDE and DBMS connections. Date: Fri, 24 Aug 2001 09:43:32 -0500 From: Steve Sharp Reply-To: steves@vcgi.uvm.edu Organization: VCGI, Inc. To: esri-l@esri.com CC: David Brotzman , steves@vcgi.uvm.edu I would like to thank everyone for their response to my questions regarding ArcSDE/DBMS connections and licensing. ORIGINAL QUESTIONS: 1) Does each ArcSDE connection translate into 1 DBMS connection? 2) If yes, is there any way to change this? SUMMARY OF RESPONSES: 1) "Each connection takes one DBMS connection, but the "giomgr" daemon process uses an additional connection, so the number of DBMS seats is N+1, where N is the number of connections." (Vince Angelo - ESRI). 2) "Not without changing your application to use indirect ("proxy") connections, much the way ArcIMS allows thousands of HTTP connects with only a handful of worker threads." (Vince Angelo - ESRI). ALL RESPONSES: The answer is yes. 1 SDE connection = 1 Oracle connection (and I assume SQL Server to be the same). Connections are concurrent so when you log off the connection is dropped. I doubt there is a way to change this. Nick Harrison City of Calgary ------------- Steve -- > Does each ArcSDE connection translate into 1 DBMS connection? Not quite. Each connection takes one DBMS connection, but the "giomgr" daemon process uses an additional connection, so the number of DBMS seats is N+1, where N is the number of connections. > If yes, is there any way to change this? Not without changing your application to use indirect ("proxy") connections, much the way ArcIMS allows thousands of HTTP connects with only a handful of worker threads. -- Vince Angelo -- Applications Programmer / Technodweeb ---------------- Steve, We have spent quite a deal of time getting an answer to this question from Microsoft (Australia) in relation to SQLServer. The answer is that they regard the person at the ultimate client as the user; in other words if you have 20 people accessing SDE you have 20 SQL users and need 20 CALs. They said to us that they were prepared (and confident enough) go to court to contest the argument that only one SDE accessing SQL meant only one CAL. Our assessment in that face of this is that seeing as how we can't tell exactly what the maximum number of concurrent users is going to be we'll go for the CPU license. It may be different in the USA but I wouldn't think so. ---------------- I am not done implementing on MSSQL server yet, but here is one important bit of info. At least is has been to me. MSSQL server does NOT have a native spatial datatype, while Oracle does. This means that you can not immediately register a feature class on an MSSQL table using the sdelayer (which requires a spatial datatype). You can still do it and I am working through it now - which is loosely load the data and run a program to convert x/y/z data into a spatial field that gets added to the table. Wayne -- Steve Sharp Senior Project Manager (Database/Web Admin) Vermont Center for Geographic Information Email: steves@vcgi.uvm.edu URL: http://www.vcgi.org Phone: 802-656-4337 Fax: 802-656-0776 "There are nine-and-sixty ways of constructing tribal lays, And every single one of them is right." - Kipling Neeraj Singh Sr. GIS Programmer/Analyst, Polk County Property Appraiser, Bartow, FL 33811