SQL Anywhere database - Licensing Not Restricting

Author

Licensing Not Restricting

Nathan Pralle

2005-12-12, 8:23 pm

Sybase 9.0.2 Build 3169 OEM Version

Have used dblic to license the database engine (dbsrv9.exe) to 2 seats
but more than 2 seats are allowed to connect to the DB. What must I
check to find out why this is being allowed and how to make the licenses
work? Very frustrating.

Thanks,
Nathan

Joshua Savill

2005-12-12, 8:23 pm

How many connections can you establish with the database? When the database
server is licensed for 2 seats, then you should be able to make 2 unique IP
connections, plus an extra connection if needed by the DBA. Note that each
connection must come from a unique IP address. All connections from the same
IP are considered 1 connection.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Nathan Pralle" < npralle@BLAHcreative
solutionsunlimited.com> wrote in
message news:439dd8ad$1@foru
ms-1-dub...
> Sybase 9.0.2 Build 3169 OEM Version
>
> Have used dblic to license the database engine (dbsrv9.exe) to 2 seats but
> more than 2 seats are allowed to connect to the DB. What must I check to
> find out why this is being allowed and how to make the licenses work?
> Very frustrating.
>
> Thanks,
> Nathan

Chris Keating(iAnywhere Solutions)

2005-12-12, 8:24 pm

And AFAIK any connection made from the same machine hosting the server
engine is not considered a connection. It is assumed that the connection
is an administrative connection.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

********************
********************
********************
*****************

Nathan Pralle

2005-12-12, 8:24 pm

Joshua Savill wrote:
> How many connections can you establish with the database? When the database
> server is licensed for 2 seats, then you should be able to make 2 unique IP
> connections, plus an extra connection if needed by the DBA. Note that each
> connection must come from a unique IP address. All connections from the same
> IP are considered 1 connection.

We can connect with 4 clients, all on different machines on the same
subnet, but unique IPs. One of the clients is on the server machine
itself, the other 3 are remote.

Nathan

Chris Keating(iAnywhere Solutions)

2005-12-12, 8:24 pm

Can you post the files sa_conn_info.txt and sa_eng_properties generated
from the following:

call sa_conn_info();
output to sa_conn_info.txt;

and

call sa_eng_properties();

output to sa_eng_properties.txt

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

********************
********************
********************
*****************

Nathan Pralle

2005-12-13, 1:23 pm

Attached.

Nathan

Chris Keating(iAnywhere Solutions) wrote:
> Can you post the files sa_conn_info.txt and sa_eng_properties generated
> from the following:
>
> call sa_conn_info();
> output to sa_conn_info.txt;
>
> and
>
> call sa_eng_properties();

> output to sa_eng_properties.txt
>
>
>
>

David Kerber

2005-12-13, 1:23 pm

In article <439de2ea@forums-2-dub>,
npralle@BLAHcreative
solutionsunlimited.com says...
> Joshua Savill wrote:
>
> We can connect with 4 clients, all on different machines on the same
> subnet, but unique IPs. One of the clients is on the server machine
> itself, the other 3 are remote.

From Chris' earlier description, that seems correct: the one from the
server doesn't count, 2 regular users, and one DBA connection. Have you
tried making a fifth connection?

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Reg Domaratzki $iAnywhere Solutions$

2005-12-13, 1:23 pm

Nathan, your sa_conn_info shows that there is a single connection to the
database from the same machine where the database engine is running. Can
you please run sa_conn_info at a time when you believe you have too many
users connected.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Nathan Pralle" < npralle@BLAHcreative
solutionsunlimited.com> wrote in
message news:439f09ac@forums
-2-dub...
> Attached.
>
> Nathan
>
> Chris Keating(iAnywhere Solutions) wrote:
>
>

----------------------------------------------------------------------------
----

> 94,'PacketsReceived'
,'Packets received by server','77'
> 95,'PacketsReceivedU
ncomp','Packets received after decompression','77'
> 96,'BytesReceived','
Bytes received by server','4854'
> 97,'BytesReceivedUnc
omp','Bytes received after decompression','4854
'
> 98,'PacketsSent','Pa
ckets sent to client','76'
> 99,'PacketsSentUncom
p','Packets sent before compression','76'
> 100,'BytesSent','Byt
es sent to client','4746'
> 101,'BytesSentUncomp
','Bytes sent before compression','4746'
> 102,'QueryHeapPages'
,'Cache pages used for query processing (hash and sort
operations)','0'[col
or=darkred]
> 103,'CarverHeapPages
','Cache pages used for carvers','0'
> 104,'HeapsRelocatabl
e','Number of relocatable heaps','9'
> 105,'HeapsLocked','N
umber of relocatable heaps currently locked in[/color]
cache','3'
> 106,'HeapsQuery','Nu
mber of heaps used for query processing (hash and sort
operations)','0'[col
or=darkred]
> 107,'HeapsCarver','N
umber of heaps used for carvers','0'
> 108,'MultiPacketsSen
t','Number of multi-packet sends','0'
> 109,'MultiPacketsRec
eived','Number of multi-packet receives','0'
> 110,'RemoteputWait',
'Remote put waits','0'
> 111,'SendFail','Fail
ed communication sends','0'
> 112,'FreeBuffers','F
ree communication buffers','7'
> 113,'TotalBuffers','
Total communication buffers','10'
> 114,'LicensesInUse',
'Number of unique client network addresses[/color]
connected','0'[color
=darkred]
> 115,'UnschReq','Unsc
heduled requests','0'
> 116,'ActiveReq','Act
ive requests','1'
> 117,'Req','Requests'
,'77'
> 118,'JavaGlobFix','J
ava VM Global Fixed size','0'
> 119,'CacheHitsEng','
Cache Hits','13861'
> 120,'CacheReadEng','
Cache reads','14047'
> 121,'CachePinned','P
inned cache pages','300'
> 122,'DiskReadEng','D
isk reads','81859'
> 123,'LockedHeapPages
','Heap pages locked in cache','7'
> 124,'AvailIO','','25
5'
> 125,'MainHeapPages',
'Main heap pages in cache','274'
> 126,'MainHeapBytes',
'Main heap bytes in cache','425880'
> 127,'CacheReplacemen
ts','Cache replacements','0'
> 128,'CurrentCacheSiz
e','Current cache size in kilobytes','24576'
> 129,'MinCacheSize','
Minimum cache size in kilobytes','24576'
> 130,'MaxCacheSize','
Maximum cache size in kilobytes','262144'
> 131,'PeakCacheSize',
'Peak cache size in kilobytes','24576'
> 132,'MapPhysicalMemo
ryEng','Map physical memory','0'
> 133,'CacheFree','Num
ber of cache pages not being used','11754'
> 134,'CacheFile','Cac
he pages used to hold data from database files','966'
> 135,'CacheFileDirty'
,'Cache pages that are dirty (needing a write)','0'
> 136,'CacheAllocated'
,'Cache pages that have been allocated for server data[/color]
structures','293'[co
lor=darkred]
> 137,'CachePanics','N
umber of times the cache manager has failed to find a[/color]
page to allocate','0'
> 138,'CacheScavenges'
,'Number of times the cache manager has scavenged for
a page to allocate','1265'[col
or=darkred]
> 139,'CacheScavengeVi
sited','Number of pages visited while scavenging for a[/color]
page to allocate','1265'[col
or=darkred]
> 140,'LockedCursorPag
es','Number of pages used to keep cursor heaps pinned[/color]
in memory','2'
> 141,'MultiPageAllocs
','Number of multi-page allocations','7'
> 142,'Name','Name','D
EXSERVER'
> 145,'PageSize','Data
base page size','2048'
> 160,'Platform','Oper
ating system platform','WindowsXP
'
> 161,'PlatformVer','O
perating system platform version','Windows XP Build
2600 Service Pack 2'
> 163,'MessageWindowSi
ze','Maximum number of messages retained from engine
window','400'
> 164,'MaxMessage','Ma
ximum message number in engine window','53'
> 165,'Message','Messa
ge from engine window','12/13 10:28:14. Unable to
initialize NT performance monitor data area; server startup continuing'
> 166,'MessageText','M
essage text from engine window','Unable to initialize
NT performance monitor data area; server startup continuing'
> 167,'MessageTime','M
essage time from engine window','12-13-2005
10:28:14.029'
> 169,'ProductName','P
roduct name','Adaptive Server Anywhere'
> 170,'ProductVersion'
,'Product version','9.0.2.3169'
> 171,'CompanyName','C
ompany name','iAnywhere Solutions, Inc.'
> 172,'LegalCopyright'
,'Copyright notice','Copyright © 1989-2004 Sybase,
Inc. Portions Copyright © 2002-2004, iAnywhere Solutions, Inc. All rights
reserved. All unpublished rights reserved.'
> 173,'LegalTrademarks
','Legal trademarks','Sybase is a trademark of Sybase,
Inc.'
> 174,'QuittingTime','
Engine quitting time','none'
> 175,'ConnsDisabled',
'Connections disabled','OFF'
> 176,'RequestLogging'
,'Request logging','NONE'
> 177,'RequestLogFile'
,'Request logging filename',''
> 178,'RequestLogNumFi
les','Request log file count','-1'
> 179,'RequestLogMaxSi
ze','Request log maximum size','0'
> 180,'RequestFilterCo
nn','Request log connection filter','-1'
> 181,'RequestFilterDB
','Request log database filter','-1'
> 182,'LivenessTimeout
','Client liveness timeout default','120'
> 183,'ProfileFilterCo
nn','Procedure profile connection filter','-1'
> 184,'ProfileFilterUs
er','Procedure profile user filter',''
> 187,'CharSet','Chara
cter Set','cp1252'
> 189,'Language','Lang
uage','us_english'
> 192,'DefaultCollatio
n','Default Collation','1252LATI
N1'
> 200,'TimeZoneAdjustm
ent','Time zone adjustment from UTC time in
minutes','-360'
> 202,'NumProcessorsAv
ail','Number of processors on server','1'
> 203,'NumProcessorsMa
x','Maximum number of processors used','0'
> 204,'LicensedCompany
','Name of the licensed company','CSU'
> 205,'LicensedUser','
Name of the licensed user','Cheryl'
> 206,'LicenseType','L
icense type','networked seat (per-seat)'
> 207,'LicenseCount','
Number of licensed seats','2'
> 211,'MachineName','N
ame of the machine','TRAINING3'

> 214,'CompactPlatform
Ver','Operating system platform version in compact
form','WXP #2600 SP 2 '
> 217,'ProcessCPU','Pr
ocess CPU usage','7.410656'
> 219,'ProcessCPUSyste
m','Process CPU System usage','5.287603'
> 225,'BuildProduction
','Build type','YES'
> 215,'CommandLine','E
xpanded command line used to start the server','-o
C:\\Program Files\\Dextrosity Suite Server\\mess.log -ti 1000 -x
tcpip -qp -n DEXSERVER -c 24M C:\\Program Files\\Dextrosity Suite
Server\\dextrosity.db C:\\Program Files\\Dextrosity Suite
Server\\traindex.db '
> 218,'ProcessCPUUser'
,'Process CPU User usage','2.123053'
> 220,'IsNetworkServer
','Is Network Server','YES'
> 221,'IsRuntimeServer
','Is Runtime Server','NO'
> 222,'BuildClient','C
odeline name','dbbuild_90_90
head'
> 223,'BuildChange','C
odeline revision','403921'
> 224,'BuildReproducib
le','Codeline state','0'
> 229,'C2','C2 communications','NO'

> 251,'RememberLastSta
tement','Remember last statement','OFF'
> 252,'IsJavaAvailable
','Java available','NO'
> 253,'JavaObjectsEnab
led','Java objects enabled','NO'
> 254,'FunctionName','
Function name','max'
> 255,'OmniIdentifier'
,'Omni
Identifier','1054943
188:traindex:DEXSERV
ER:14149000'
> 256,'IdleTimeout','I
dle timeout','1000'
> 257,'ProcessorArchit
ecture','Processor architecture','X86'
> 258,'NativeProcessor
Architecture','Archi
tecture of native processor when
current processor is emulated','X86'[colo
r=darkred]
> 261,'TempDir','Tempo
rary directory','C:\\WIND
OWS\\TEMP'
> 262,'StartTime','Ser
ver start time','12-13-2005 10:28:46.165'
> 264,'IsIQ','Is IQ Server','NO'
> 265,'Threads','Serve
r thread count','20'
> 268,'ConsoleLogFile'
,'Console log filename','C:\\Progr
am Files\\Dextrosity[/color]
Suite Server\\mess.log'
> 275,'HttpPorts','Htt
p Server TCP/IP port number(s)',''
> 276,'HttpsPorts','Ht
tps Server TCP/IP port number(s)',''
> 280,'IsFipsAvailable
','FIPS Available','NO'
> 281,'FipsMode','FIPS
Mode','NO'
> 282,'StartDBPermissi
on','Start database permission','DBA'
> 283,'RememberLastPla
n','Remember last plan','OFF'
> 286,'LogExpensiveQue
ries','Threshold in milliseconds for logging expensive
queries','0'
> 287,'RequestTiming',
'Monitor the cost of requests','OFF'
>

----------------------------------------------------------------------------
----

> 1,'','DBA',1,'12-13-2005
11:23:09. 779',,,'CURSOR_OPEN'
,'local','',7725,,0,
0,0
>

Chris Keating(iAnywhere Solutions)

2005-12-13, 8:24 pm

This shows that there is an engine already running on this computer.
This server is licensed for 2 per-seat licenses. There is a single
connection being made on the same machine.

I was not clear in my first post. Can you rerun the sa_conn_info capture
at the time that you are seeing the connection exceeding the 2 seats.

Thanks
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

********************
********************
********************
*****************

Nathan Pralle

2005-12-13, 8:24 pm

> From Chris' earlier description, that seems correct: the one from the
> server doesn't count, 2 regular users, and one DBA connection. Have you
> tried making a fifth connection?

This was probably not clear -- one client connection from the server, 3
from remote machines. Thus, the one on the server doesn't count, true,
but the three remotes should be limited to 2.

Nathan

Nathan Pralle

2005-12-13, 8:24 pm

Chris Keating(iAnywhere Solutions) wrote:
> This shows that there is an engine already running on this computer.
> This server is licensed for 2 per-seat licenses. There is a single
> connection being made on the same machine.
>
> I was not clear in my first post. Can you rerun the sa_conn_info capture
> at the time that you are seeing the connection exceeding the 2 seats.
>
> Thanks

Ah! Whoops. I wondered.

Ok, will have the tester set that scenario up again.

Thanks,
Nathan

Nathan Pralle

2005-12-13, 8:24 pm

Well....upon having our tester re-setup the scenario where she got too
many machines connected, it suddenly works. GO FIGURE. :P~

Thanks for your time...I think I'll close it as a PEBKAC error for now.

Much appreciated,
Nathan

Nathan Pralle wrote:
> Sybase 9.0.2 Build 3169 OEM Version
>
> Have used dblic to license the database engine (dbsrv9.exe) to 2 seats
> but more than 2 seats are allowed to connect to the DB. What must I
> check to find out why this is being allowed and how to make the licenses
> work? Very frustrating.
>
> Thanks,
> Nathan

Sponsored Links