Community
Select to view content in your preferred language

Geodatabase without ArcSDE Service (shutting connections/Logs)

1387
10
12-20-2012 10:23 PM
EmadAl-Mousa
by
Deactivated User
‎12-20-2012 10:23 PM
Hi,

if i want to re-design my current infrastructure from 3-tier to 2-tier Geodatabase infrastructure. (Since 10.1 released ESRI ArcGIS Suit is using direct-database connections)

I have the following two questions:

1. how can i shutdown all connections coming to my geodatabase system ? previously, using ArcSDE as an application server we used (sdemon -o shutdown) command.

2. is there any logs will be generated with 2-tier architecture for the geodatabase (where can i find them) ? previously, using ArcSDE as an application server we would find SDE logs being generated on the database server file system.

Thanks,
0 Kudos
10 Replies
MarcoBoeringa
by MVP Alum
MVP Alum
‎12-21-2012 10:32 PM
another important remark:

DBTUNE , SERVER_CONFIG system tables used to be altered using "sde" commands on the database servers. with 2-tier archtiecture the only way to do modifications with them is to install "sde client" on your local PC.

I think ESRI should re-consider their design in version 10.1 or at least add the functionality of altering DBTUNE and SERVER_CONFIG using the geodatabase administration GUI interface.


It seems likely that more of the geodatabase administration tools will make their way to future releases, but only ESRI can tell when.

I agree having to install an ArcSDE application server to modify DBTUNE and SERVER_CONFIG is cumbersome and it should be possible through the ArcGIS GUI. Question is though, for how many setups a modification is really needed. For lesser experienced ArcGIS users / ArcSDE administrators, sticking to the defaults is probably the best option. In addition, if changes are needed to the configuration at all (ESRI undoubtedly has "tuned" the parameters to be optimal for most situations), than this is in most cases a one-time operation taking place during initial setup. This is in contrast to the new 10.1 (ArcSDE) Geodatabase Administration GUI tools that primarily cater for all of the day-to-day or weekly tasks of maintaining a geodatabase.

Altering the contents of the DBTUNE table

The SERVER_CONFIG system table

An overview of the Geodatabase Administration toolset
0 Kudos