We were running
9.0.2.3124 Cons b4 upgrade
9.0.1.1883 Remote DB b4 upgrade

Both DBs were serving web.(Although not sure which one they were primarily
accessing, I'm 90% leaning towards the remote).

After moving their database server to a newly purchased fancy Dell Server
with more horsepower etc. and upgrading their database server to Sybase
9.0.2.3274...

Our webserver has been returning HTTP 503 with such a frequency that it has
almost to the point of crippling a web page that was designed to
automatically refresh every 2 seconds. It is reported by the users that
before the upgrade they had never seen a 503.

While accepted that my web page design may be poor, any thoughts out there
on what has caused the web service to perform poorly only after these
changes?

Could it be the newer build/version of Sybase?

Could it be the os upgrade (was 2000 server is now 2003 Server)?

Could it be the Hardware upgrade (unknown to unknown, but definitely older
to new faster better)?- I can investigate the true details if required.

Could it be the number of licenses for Sybase? (we right on the edge, but I
assumed the webserver doesnt take a licenses since it is part of the server)

Is Sybase's web server just not cut out for the task of serving production
websites?


I'm ruling out network (although it is a rather large 2.4ghz wireless lan)
since the web client properly sent an http request and the server
(in)properly sent out a http 503 error which displayed at the web client.

Christopher Harn wrote:
A 503 is returned if you have exceeded your number of licenses.
Each connection to an HTTP service uses 1 license. So if someone is
making multiple simultaneous browser requests (e.g. using an older
HTTP/1.0 client which opens a different connection for each and every
object(!!)), then they will be using multiple licenses concurrently.

As an experiment, you might try increasing your license count using
dblic and see if the 503's disappear.

In the upcoming Jasper release, the use of SQLAnywhere HTTP Sessions
will reduce this problem as one "session" will use one license.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Greg Fenton wrote:
As an alternative, you could enable the HTTP log and see the error
messages logged in there:

dbsrv9 -xs "http(LOG=c:/asa_http.txt;LOPT=all;LSIZE=10000000)" ...

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Thank you Thank you Thank you... Blessings upon you.
I assume you gotta stop the database to add more licenses to it? : (




Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\>dblic -l perseat -p WIN32 -u 20 dbsrv9.exe
"XXXXX" "?????"
Adaptive Server Anywhere Server Licensing Utility Version 9.0.2.3274
Cannot open executable file 'dbsrv9.exe'

C:\Documents and Settings\>



"Greg Fenton" <greg.fenton_NOSPAM_ (AT) ianywhere (DOT) com> wrote

Yes, I think dblic diddles the actual .EXE file. Here is a sample:

REM -l ... license type perseat or processor
REM -o ... where to put output messages
REM -p ... operating system WIN32, WIN64, NetWare, UNIX
REM -u ... number of users or processors
REM "executable" "user name" "company name"

"%ASANY9%\win32\dblic.exe" -l perseat -o dblic_log.txt -p WIN32 -u
10000 "%ASANY9%\win32\dbsrv9.exe" "Breck Carter" "RisingRoad"
PAUSE


On 11 Apr 2006 13:06:10 -0700, "Christopher Harn" <harncw (AT) hotmail (DOT) com>
wrote:

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com