RE: Sluggish Connections to IIF.2000 on NT Server

1. Is your network sometimes busy ond sometimes not? 2. Is there anything else on your database server? 3. Where is your BDC or PDC? (local or remote) 4. How busy does your BDC or PDC get? (Anything else on it)? 5. How many users exist in the NT user table? 6. How long does "dbaccess databasename" take from the command prompt on the database server? The client needs to locate the database server on the network. The database server must obtain authentication from the BDC or PDC (after having located it) from the user. Authentication is completely different on NT to Unix and is more time consuming for Informix. Under these situations there are a number of network requests taking place in sequential manner. If the response of any of these is slow, your connection time will be very slow - as you observe. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Steve Romankiw1 Sent: Thursday, November 09, 2000 9:35 AM To: Informix User Group (E-mail) Subject: Sluggish Connections to IIF.2000 on NT Server I reposting this message. When connecting to iif.2000 via a client or dbaccess via tcp, I am noticing connect latency of up to 15 seconds (sometimes the connection is under 1 second). I get the results no matter how busy the network is. In my case, 5 users tops. I noticed in the manuals that if you have DHCP enabled, you need to have WINS enabled. As you can see from from settings below, I don't have WINS Proxy enabled by I do have a Primary WINS server installed. I placed a call with Informix, but they don't have answer yet. They are sayings its an O/S issue. OK, if it is an O/S issue, what happens when a user tries to authenticate against a NT server? What look-ups are performed? TIA Steve Romankiw ----------------------------------------------------------- >From Server iif.2000 v9.21.TC1 NETTYPE soctcp,1,50,NET Windows NT 4.0 (SP 6a) User Id informix is stored locally and is part of the "Administrators and Inform-Admins" groups. ----------------------------------------------------------- c:/> ipconfig /all Windows NT IP Configuration Host Name . . . . . . . . . : constellation.engyro.com DNS Servers . . . . . . . . : xxx.xxx.109.39 xxx.xxx.109.40 Node Type . . . . . . . . . : Hybrid NetBIOS Scope ID. . . . . . : IP Routing Enabled. . . . . : No WINS Proxy Enabled. . . . . : No NetBIOS Resolution Uses DNS : No Ethernet adapter N1001: Description . . . . . . . . : Compaq Ethernet/FastEthernet or Gigabit NIC Physical Address. . . . . . : 00-50-8B-EE-26-1F DHCP Enabled. . . . . . . . : No IP Address. . . . . . . . . : yyy.yyy.0.27 Subnet Mask . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . : yyy.yyy.0.1 Primary WINS Server . . . . : yyy.yyy.0.3 ----------------------------------------------------------- >From Client Machine csdk : 9.40 2.50.TC2 Windows 2000 Professional ----------------------------------------------------------- c:/> ipconfig /all Windows 2000 IP Configuration Host Name . . . . . . . . . . . . : SROMANKIW Primary DNS Suffix . . . . . . . : Node Type . . . . . . . . . . . . : Hybrid IP Routing Enabled. . . . . . . . : No WINS Proxy Enabled. . . . . . . . : No Ethernet adapter Local Area Connection 3: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : FE575C-3COM 10/100 LAN CardBus-Fast Ethernet Physical Address. . . . . . . . . : 00-00-86-5C-80-99 DHCP Enabled. . . . . . . . . . . : Yes Autoconfiguration Enabled . . . . : Yes IP Address. . . . . . . . . . . . : yyy.yyy.0.80 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : yyy.yyy.0.1 DHCP Server . . . . . . . . . . . : yyy.yyy.0.3 DNS Servers . . . . . . . . . . . : xxx.xxx.109.39 xxx.xxx.109.40 Primary WINS Server . . . . . . . : yyy.yyy.0.3 Lease Obtained. . . . . . . . . . : Wednesday, November 08, 2000 10:11:06 AM Lease Expires . . . . . . . . . . : Sunday, December 03, 2000 10:11:06 AM