informix dropping idle connections
User reported Informix 9.40 dropping idle connections and asked if the database could automatically terminate idle sessions. Art Kagel noted that Informix 11.70 has automatic idle connection termination, but for version 9.40, manual solutions are needed via SQL to detect and kill idle sessions. Stuart McCann suggested checking CSDK version and TCPKEEPALIVE settings, and identified ArcIMS as a potential culprit for leaving connections open.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello folks Looking for some advice/information IBM Informix Dynamic Server Version 9.40.HC5 (yes I know its not supported any more) HP-UX mafgis2 B.11.11 U 9000/800 SDE ArcSDE 9.2 for Informix Build 1254 max sde connections set at CONNECTIONS 64 Our development people have a spatial database where connections to the database keep growing. I believe it to be an application/sde issue. However they wish to know if there is a way informix can drop idle connections. Does anyone know this if it is possible and how to do it. I dont think it is the way to go as it does not solve the real issue of connections being made and not dropped. I think it better to have a minimum amount of connections and not have the overhead of making a connection to the db when there is none ps does anyone use this forum with firefox - I have problesms with display whebn using firefox
I use firefox, but I use the email gateway, I don't use the web client. Informix 11.70 can automatically drop idle connections. In your version, you will have to do it yourself. Someone (may have been John Miller or Jonathan Leffler) posted SQL to detect long idle connections. Search the forum history. You can have a task wake periodically, look for idle sessions and kill them. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Dec 6, 2010 at 5:11 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > Hello folks > Looking for some advice/information > IBM Informix Dynamic Server Version 9.40.HC5 (yes I know its not supported > any more) > HP-UX mafgis2 B.11.11 U 9000/800 > SDE ArcSDE 9.2 for Informix Build 1254 > max sde connections set at > CONNECTIONS 64 > > Our development people have a spatial database where connections to the > database keep growing. I believe it to be an application/sde issue. > However they wish to know if there is a way informix can drop idle > connections. > Does anyone know this if it is possible and how to do it. > I dont think it is the way to go as it does not solve the real issue of > connections being made and not dropped. I think it better to have a minimum > amount of connections and not have the overhead of making a connection to > the > db when there is none > ps does anyone use this forum with firefox - I have problesms with display > whebn using firefox > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5afe96573af0496c540af
Karl, What CSDK are you using to connect SDE to Informix? 2.81.xC2 is the supported CSDK for SDE 9.2. What is the TCPKEEPALIVE value in giomgr.defs set to? Should be set to FALSE. By any chance are you using ARCIMS in the landscape? I have had many issues with it leaving connections open in DBServer. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL OLIVER Sent: Tuesday, 7 December 2010 9:11 AM To: ids@iiug.org Subject: informix dropping idle connections [22125] Hello folks Looking for some advice/information IBM Informix Dynamic Server Version 9.40.HC5 (yes I know it's not supported any more) HP-UX mafgis2 B.11.11 U 9000/800 SDE ArcSDE 9.2 for Informix Build 1254 max sde connections set at CONNECTIONS 64 Our development people have a spatial database where connections to the database keep growing. I believe it to be an application/sde issue. However they wish to know if there is a way informix can drop idle connections. Does anyone know this if it is possible and how to do it. I don't think it is the way to go as it does not solve the real issue of connections being made and not dropped. I think it better to have a minimum amount of connections and not have the overhead of making a connection to the db when there is none ps does anyone use this forum with firefox - I have problesms with display whebn using firefox ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Land and Property Management Authority. This email message has been swept by MIMEsweeper for the presence of computer viruses. *************************************************************** Please consider the environment before printing this email.
You might want to check out the following: https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/terminate_idle_users_with_the?lang=en_us While this is for version 11, it should give you the pieces to build something for other versions. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 12/06/2010 02:17:29 PM: > [image removed] > > Re: informix dropping idle connections [22126] > > Art Kagel > > to: > > ids > > 12/06/2010 02:19 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I use firefox, but I use the email gateway, I don't use the web client. > Informix 11.70 can automatically drop idle connections. In your version, > you will have to do it yourself. Someone (may have been John Miller or > Jonathan Leffler) posted SQL to detect long idle connections. Search the > forum history. You can have a task wake periodically, look for idle > sessions and kill them. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Mon, Dec 6, 2010 at 5:11 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > > > Hello folks > > Looking for some advice/information > > IBM Informix Dynamic Server Version 9.40.HC5 (yes I know it’s not supported > > any more) > > HP-UX mafgis2 B.11.11 U 9000/800 > > SDE ArcSDE 9.2 for Informix Build 1254 > > max sde connections set at > > CONNECTIONS 64 > > > > Our development people have a spatial database where connections to the > > database keep growing. I believe it to be an application/sde issue. > > However they wish to know if there is a way informix can drop idle > > connections. > > Does anyone know this if it is possible and how to do it. > > I don’t think it is the way to go as it does not solve the real issue of > > connections being made and not dropped. I think it better to have a minimum > > amount of connections and not have the overhead of making a connection to > > the > > db when there is none > > ps does anyone use this forum with firefox - I have problesms with display > > whebn using firefox > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001636c5afe96573af0496c540af > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Stuart IBM/Informix-Client SDK Version 2.81.HC2 TCPKEEPALIVE FALSE ARCIMS in the landscape dont know I will ask the people
Thansk for info Art John cant read your post
Stuart the answer about IMs Yes we're using ArcIMS 9.2.
Stuart the answer Yes we're using ArcIMS 9.2.
Karl,
Can you establish if the connections which persist are ARC IMS connections?
ARC IMS uses connection pooling, some of which are direct connects. We run it
with a proxy server and load balance between two identical Informix Servers
which get refreshed and bounced daily which gets rid of orphaned connections,
not very elegant, but it sure gets rid of those wayward connections.
You could onmode -z the sessions if a bounce is not acceptable.
Stuart
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL
OLIVER
Sent: Tuesday, 7 December 2010 9:46 AM
To: ids@iiug.org
Subject: Re: informix dropping idle connections [22131]
Stuart
the answer about IMs
Yes we're using ArcIMS 9.2.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
***************************************************************
This message is intended for the addressee named and may contain confidential
information. If you are not the intended recipient, please delete it and
notify the sender. Views expressed in this message are those of the individual
sender, and are not necessarily the views of the Land and Property Management
Authority. This email message has been swept by MIMEsweeper for the presence
of computer viruses.
***************************************************************
Please consider the environment before printing this email.
I never used, so I don't know if is reliable and compatible with 9.4 http://www.iiug.org/software/index_all.html#killidle On 12/06/2010 08:11 PM, KARL OLIVER wrote: > Hello folks > Looking for some advice/information > IBM Informix Dynamic Server Version 9.40.HC5 (yes I know its not supported > any more) > HP-UX mafgis2 B.11.11 U 9000/800 > SDE ArcSDE 9.2 for Informix Build 1254 > max sde connections set at > CONNECTIONS 64 > > Our development people have a spatial database where connections to the > database keep growing. I believe it to be an application/sde issue. > However they wish to know if there is a way informix can drop idle > connections. > Does anyone know this if it is possible and how to do it. > I dont think it is the way to go as it does not solve the real issue of > connections being made and not dropped. I think it better to have a minimum > amount of connections and not have the overhead of making a connection to the > db when there is none > ps does anyone use this forum with firefox - I have problesms with display > whebn using firefox > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
I have decided the best way to eliminate the connections is to stop and start
sde.That tidies them up cleanly, Have struck problems before when doing onmode
-z. we have had to restart sde in the end anyway
That's a good outcome. If starting and stopping SDE gets rid of all the
connections it will tidy up its own metadata, like the process_information
table. An onmode -z does not take such things into account. Just check that
IMS leaves no other direct (non-SDE) connections to the DBServer.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL
OLIVER
Sent: Tuesday, 7 December 2010 11:55 AM
To: ids@iiug.org
Subject: Re: informix dropping idle connections [22135]
I have decided the best way to eliminate the connections is to stop and start
sde.That tidies them up cleanly, Have struck problems before when doing onmode
-z. we have had to restart sde in the end anyway
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
***************************************************************
This message is intended for the addressee named and may contain confidential
information. If you are not the intended recipient, please delete it and
notify the sender. Views expressed in this message are those of the individual
sender, and are not necessarily the views of the Land and Property Management
Authority. This email message has been swept by MIMEsweeper for the presence
of computer viruses.
***************************************************************
Please consider the environment before printing this email.
I also thought this, but I hesitated posting it ... ;-) -- From: "John Miller iii" <miller3@us.ibm.com> To: ids@iiug.org Date: 12/06/2010 11:31 PM Subject: Re: informix dropping idle connections [22128] Sent by: ids-bounces@iiug.org You might want to check out the following: https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/terminate_idle_users_with_the?lang=en_us While this is for version 11, it should give you the pieces to build something for other versions. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 12/06/2010 02:17:29 PM: > [image removed] > > Re: informix dropping idle connections [22126] > > Art Kagel > > to: > > ids > > 12/06/2010 02:19 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I use firefox, but I use the email gateway, I don't use the web client. > Informix 11.70 can automatically drop idle connections. In your version, > you will have to do it yourself. Someone (may have been John Miller or > Jonathan Leffler) posted SQL to detect long idle connections. Search the > forum history. You can have a task wake periodically, look for idle > sessions and kill them. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Mon, Dec 6, 2010 at 5:11 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > > > Hello folks > > Looking for some advice/information > > IBM Informix Dynamic Server Version 9.40.HC5 (yes I know it’s not supported > > any more) > > HP-UX mafgis2 B.11.11 U 9000/800 > > SDE ArcSDE 9.2 for Informix Build 1254 > > max sde connections set at > > CONNECTIONS 64 > > > > Our development people have a spatial database where connections to the > > database keep growing. I believe it to be an application/sde issue. > > However they wish to know if there is a way informix can drop idle > > connections. > > Does anyone know this if it is possible and how to do it. > > I don’t think it is the way to go as it does not solve the real issue of > > connections being made and not dropped. I think it better to have a minimum > > amount of connections and not have the overhead of making a connection to > > the > > db when there is none > > ps does anyone use this forum with firefox - I have problesms with display > > whebn using firefox > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001636c5afe96573af0496c540af > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
While the following article is for version 11 it does show the parts you can put together so it would run in other versions. https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/terminat e_idle_users_with_the?lang=en_us John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 12/07/2010 05:13:20 AM: > [image removed] > > Re: informix dropping idle connections [22137] > > Martin Fuerderer > > to: > > ids > > 12/07/2010 05:14 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I also thought this, but I hesitated posting it ... ;-) > -- > > From: > "John Miller iii" <miller3@us.ibm.com> > To: > ids@iiug.org > Date: > 12/06/2010 11:31 PM > Subject: > Re: informix dropping idle connections [22128] > Sent by: > ids-bounces@iiug.org > > You might want to check out the following: https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/terminate_idle_users_with_the?lang=en_us While this is for version 11, it should give you the pieces to build something for other versions. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 12/06/2010 02:17:29 PM: > [image re > > bW92ZWRdDQo+DQo +IFJlOiBpbmZvcm1peCBkcm9wcGluZyBpZGxlIGNvbm5lY3Rpb25zIFsyMjEy > > Nl0NCj4NCj4gQXJ0IEthZ2VsDQo+DQo to: > > ids > > 12/06/2010 02:19 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I use firefox, but I use the email gateway, I don't use the web client. > Informix 11.70 can automatically drop idle connections. In your versi > > b24sDQo +IHlvdSB3aWxsIGhhdmUgdG8gZG8gaXQgeW91cnNlbGYuIFNvbWVvbmUgKG1heSBoYXZl > > IGJlZW4gSm9obiBNaWxsZXIgb3INCj4gSm9uYXRoYW4gTGVmZmxlcikgcG9zdGVkIFNRTCB0byBk > > ZXRlY3QgbG9uZyBpZGxlIGNvbm5lY3Rpb25zLiBTZWFyY2ggdGhlDQo +IGZvcnVtIGhpc3Rvcnku > > IFlvdSBjYW4gaGF2ZSBhIHRhc2sgd2FrZSBwZXJpb2RpY2FsbHksIGxvb2sgZm9yIGlkbGUNCj4g > > c2Vzc2lvbnMgYW5kIGtpbGwgdGhlbS4NCj4NCj4gQXJ0DQo+DQo +IEFydCBTLiBLYWdlbA0KPiBB > > ZHZhbmNlZCBEYXRhVG9vbHMgKHd3dy5hZHZhbmNlZGF0YXRvb2xzLmNvbSkNCj4gSUlVRyBCb2Fy > > ZCBvZiBEaXJlY3RvcnMgKGFydEBpaXVnLm9yZykNCj4gQmxvZzogaHR0cDovL2luZm9ybWl4LW15 > > dmlldy5ibG9nc3BvdC5jb20vDQo+DQo +IERpc2NsYWltZXI6IFBsZWFzZSBrZWVwIGluIG1pbmQg > > dGhhdCBteSBvd24gb3BpbmlvbnMgYXJlIG15IG93biBvcGluaW9ucw0KYW5kDQo +IGRvIG5vdCBy > > eflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor > > dGhvc2Ugb2YgdGhlDQo+IGVudGl0aWVzIHRoZW1zZWx2ZXMuDQo+DQo +IE9uIE1vbiwgRGVjIDYs > > IDIwMTAgYXQgNToxMSBQTSwgS0FSTCBPTElWRVIgPGthcmwub2xpdmVyQG1hZi5nb3Z0Lm56Pg0K > > d3JvdGU6DQo+DQo +ID4gSGVsbG8gZm9sa3MNCj4gPiBMb29raW5nIGZvciBzb21lIGFkdmljZS9p > > bmZvcm1hdGlvbg0KPiA +IElCTSBJbmZvcm1peCBEeW5hbWljIFNlcnZlciBWZXJzaW9uIDkuNDAu > > SEM1ICh5ZXMgSSBrbm93IGl04oCZcyBub3QNCnN1cHBvcnRlZA0KPiA +IGFueSBtb3JlKQ0KPiA+ > > IEhQLVVYIG1hZmdpczIgQi4xMS4xMSBVIDkwMDAvODAwDQo +ID4gU0RFIEFyY1NERSA5LjIgZm9y > > IEluZm9ybWl4IEJ1aWxkIDEyNTQNCj4gPiBtYXggc2RlIGNvbm5lY3Rpb25zIHNldCBhdA0KPiA + > > IENPTk5FQ1RJT05TIDY0DQo +ID4NCj4gPiBPdXIgZGV2ZWxvcG1lbnQgcGVvcGxlIGhhdmUgYSBz > > cGF0aWFsIGRhdGFiYXNlIHdoZXJlIGNvbm5lY3Rpb25zIHRvIHRoZQ0KDQo +ID4gZGF0YWJhc2Ug > > a2VlcCBncm93aW5nLiBJIGJlbGlldmUgaXQgdG8gYmUgYW4gYXBwbGljYXRpb24vc2RlIGlzc3Vl > > Lg0KPiA +IEhvd2V2ZXIgdGhleSB3aXNoIHRvIGtub3cgaWYgdGhlcmUgaXMgYSB3YXkgaW5mb3Jt > > aXggY2FuIGRyb3AgaWRsZQ0KPiA+IGNvbm5lY3Rpb25zLg0KPiA +IERvZXMgYW55b25lIGtub3cg > > dGhpcyBpZiBpdCBpcyBwb3NzaWJsZSBhbmQgaG93IHRvIGRvIGl0Lg0KPiA +IEkgZG9u4oCZdCB0 > > aGluayBpdCBpcyB0aGUgd2F5IHRvIGdvIGFzIGl0IGRvZXMgbm90IHNvbHZlIHRoZSByZWFsIGlz > > c3VlDQpvZg0KPiA +IGNvbm5lY3Rpb25zIGJlaW5nIG1hZGUgYW5kIG5vdCBkcm9wcGVkLiBJIHRo > > aW5rIGl0IGJldHRlciB0byBoYXZlIGENCm1pbmltdW0NCj4gPiBhbW91bnQgb2YgY29ubmVjdGlv > > bnMgYW5kIG5vdCBoYXZlIHRoZSBvdmVyaGVhZCBvZiBtYWtpbmcgYSBjb25uZWN0aW9uDQp0bw0K > > PiA+IHRoZQ0KPiA+IGRiIHdoZW4gdGhlcmUgaXMgbm9uZQ0KPiA +IHBzIGRvZXMgYW55b25lIHVz > > ZSB0aGlzIGZvcnVtIHdpdGggZmlyZWZveCAtIEkgaGF2ZSBwcm9ibGVzbXMgd2l0aA0KZGlzcGxh > > eQ0KPiA+IHdoZWJuIHVzaW5nIGZpcmVmb3gNCj4gPg0KPiA+DQo +ID4NCj4gPg0KPg0KKioqKioq > > KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq > > KioqKioqKioqKioqKioqKg0KDQo +ID4gRm9ydW0gTm90ZTogVXNlICJSZXBseSIgdG8gcG9zdCBh > > IHJlc3BvbnNlIGluIHRoZSBkaXNjdXNzaW9uIGZvcnVtLg0KPiA+DQo +ID4NCj4NCj4gLS0wMDE2 > > MzZjNWFmZTk2NTczYWYwNDk2YzU0MGFmDQo+DQo+DQo +DQoqKioqKioqKioqKioqKioqKioqKioq > > KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq > > DQoNCj4gICBGb3J1bSBOb3RlOiBVc2UgIlJlcGx5IiB0byBwb3N0IGEgcmVzcG9uc2UgaW4gdGhl > > IGRpc2N1c3Npb24gZm9ydW0uDQo+ > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Cesar this script appears to kill idle unix login sessions not database connections
Stuart In regards to the sde connection swwe see this in the log Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Is there anyway we can put a trace on to see where they come from ? in the dbinit.sde file we have set SDEVERBOSE=TRUE
Karl,
As the SDE Server administrator you can use sdemon to check ARC SDE
connections.
sdemon -o info -I users
ArcSDE Instance dev_sde Registered Server Tasks on sde_host at Tue Dec 14
07:06:44 2010
-------------------------------------------------------------------------
S-ID User Host:OS Started
----- -------- -------------------------------- ------------------------
193104 arc_user arc_client:Win32:XDR Tue Dec 14 07:11:40 2010
Not quite a trace, but it will show you who has a connection and what host
they are connected from.
If you want to trace all connections automatically, you can add an insert
trigger to the process_information table. This table keeps a track of SDE
gsrvr processes connected to ARC SDE, and is the table that the sdemon command
above reports on. The trigger could save connection data to another table, as
SDE removes the process_information row when the session disconnects. Eg:-
create trigger connection_trigger insert on process_informationreferencing new as post
for each row (
insert into process_information_save values
(post.start_time , post.owner , post.nodename )
) ;
So, you would need to create a process_information_save table also to save the
rows too, something like this:-
create table process_information_save (
start_time datetime year to second not null ,
owner varchar(30) not null ,
nodename varchar(255)
) ;
Stuart
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL
OLIVER
Sent: Tuesday, 14 December 2010 6:13 AM
To: ids@iiug.org
Subject: Re: informix dropping idle connections [22200]
Stuart
In regards to the sde connection swwe see this in the log
Instance initialized for dev1110 . . .
Instance initialized for dev1110 . . .
Instance initialized for dev1110 . . .
Instance initialized for dev1110 . . .
Instance initialized for dev1110 . . .
Instance initialized for dev1110 . . .
Is there anyway we can put a trace on to see where they come from ?
in the dbinit.sde file we have
set SDEVERBOSE=TRUE
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
***************************************************************
This message is intended for the addressee named and may contain confidential
information. If you are not the intended recipient, please delete it and
notify the sender. Views expressed in this message are those of the individual
sender, and are not necessarily the views of the Land and Property Management
Authority. This email message has been swept by MIMEsweeper for the presence
of computer viruses.
***************************************************************
Please consider the environment before printing this email.
Stuart Thanks for sdemon -o info -I users it is really helpful