🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.misc
Article #2894

Re: Sybase - Concept of a User

#2894
From: andrew
Date: Thu, 08 Oct 1992 23:34
36 lines
2190 bytes
In article <1992Oct7.173705.2171@deepthought.uucp> Neil Greene <deepthought!neil@ms.uky.edu> writes:
>I was told a long time ago that Sybase may internally limit the number of  
>simultaneous users based on the license agreement.  (i.e. - a 5 user  
>license will only allow 5 users to access the database at the same time.)  
>
>I was also told that Sybase uses 3 of the 5 users from the Limited Server  
>Edition for internal processes (database writer, etc.).  Leaving only 2  
>users available.  Can someone clarify this, is this true?? 

Not true.  In fact, it appears as if you can have _six_ simultaneous
users running on the limited server:

1> sp_who
2> go
 spid   status     loginame     hostname   blk dbname     cmd
 ------ ---------- ------------ ---------- --- ---------- ----------------
      1 sleeping   andrew       imladris   0   bbs        AWAITING COMMAND
      2 sleeping   sa                      0   master     NETWORK HANDLER
      3 sleeping   sa                      0   master     MIRROR HANDLER
      4 sleeping   sa                      0   master     CHECKPOINT SLEEP
      5 sleeping   andrew       imladris   0   bbs        AWAITING COMMAND
      6 sleeping   andrew       imladris   0   bbs        AWAITING COMMAND
      7 sleeping   andrew       imladris   0   bbs        AWAITING COMMAND
      8 sleeping   andrew       imladris   0   bbs        AWAITING COMMAND
      9 runnable   andrew       imladris   0   bbs        SELECT

(9 rows affected, return status = 0)



andrew
-- 
andrew@cubetech.com     | "We shall not cease from exploration
Andrew Loewenstern      |  And the end of our exploring
Cube Technologies, Inc. |  Will be to arrive where we started
                        |  And know the place for the first time." -T.S. Eliot
Technical Details
Message-ID: <1992Oct8.233439.661@cubetech.com>
Path: arc1-ca.pugleaf.net!sparky!uunet!tcsi.com!iat.holonet.net!uupsi!psinntp!cubetech.com!imladris!andrew
References: <1992Oct7.173705.2171@deepthought.uucp>

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.misc
Path: arc1-ca.pugleaf.net!sparky!uunet!tcsi.com!iat.holonet.net!uupsi!psinntp!cubetech.com!imladris!andrew
From: andrew@cubetech.com
Subject: Re: Sybase - Concept of a User
Message-ID: <1992Oct8.233439.661@cubetech.com>
Organization: Cube Technologies, Inc.
References: <1992Oct7.173705.2171@deepthought.uucp>
Date: Thu, 8 Oct 1992 23:34:39 GMT
Lines: 36