NOTRANS in tbstat -u & Extra Back-ends
Posted in 1993
Background: We're running OnLine 5.00, I-Star 5.00 and 4GL/SQL 4.10 on RS/6000's. Question: Is there a relationship between "tbstat -u" transaction entries with a NOTRANS isolation level and runaway turbos (turbos with no front-end process.) I have noticed a definite slowing down in response time when a number of NOTRANS transactions are reported. For example, we have had 150 turbos on database clients (front-ends) and over 300 turbos on the server (back-ends) -- many [or most] of the extra turbos seem to be NOTRANS! The OnLine Administrator's Guide doesn't provide much information. Also does anyone know why isql/dbaccess takes sooo long sometimes to exit? I wonder if there's a connection? -- / __ \\/ /__ ___ / /_____ ____ ____ ___ Ed Hobbs / /_/ / / _ \\/ __/ __/ ___/ __ \\/ __ `__ \\ Database Administrator / __ / / __/ / / /_/ /__/ /_/ / / / / / / Alert Centre, Inc. /_/ /_/_/\\___/_/ \\_(_)___/\\____/_/ /_/ /_/ ewh@alert.com/(303)488-7636