dbTalk Databases Forums  

dbsrv9 -c does not work correctly on Sun Solaris

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss dbsrv9 -c does not work correctly on Sun Solaris in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Monica
 
Posts: n/a

Default dbsrv9 -c does not work correctly on Sun Solaris - 04-06-2006 , 07:10 AM






Dear All,

I run ASA 9.0.2 build 3044 on SunOS Release 5.9 Generic_118558-06. The
Solaris box has 8GB RAM.

I try to run the following command to start up the ASA 9 database server
with an initial cache size of 2GB:

dbsrv9 -ud -gk all -m -c 2048M -ca 0 -ti 0 -o <output log file name> -os
102400 -n <DB Name> <db script name>

However, according to what returned by the "top" command, the ASA 9 database
server has only got the initial cache size of 937MB.

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
256 root 33 58 0 937M 934M cpu0 90.6H 38.21% dbsrv9

Nevertheless, there is no such problem in ASA 8.0.1. If I run ASA 8.0.1
with the same parameters on the same box, it can correctly take 2GB space
according to the -c option.

Has anyone encountered similar problem before? Any pointer or information
is much appreciated. Thank you very much in advance.

Thanks and Best Regards,
Monica



Reply With Quote
  #2  
Old   
Mark Culp
 
Posts: n/a

Default Re: dbsrv9 -c does not work correctly on Sun Solaris - 04-06-2006 , 01:18 PM






In 9.0.x when the engine starts it allocates address space for the cache
but does not physically "commit" the memory to the process, so this could
be the reason why you are seeing the difference.

If you add -z -cs to the command line, what size of cache does the server say
that it is using?
--
Mark Culp
SQLAnywhere Research and Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

Monica wrote:
Quote:
Dear All,

I run ASA 9.0.2 build 3044 on SunOS Release 5.9 Generic_118558-06. The
Solaris box has 8GB RAM.

I try to run the following command to start up the ASA 9 database server
with an initial cache size of 2GB:

dbsrv9 -ud -gk all -m -c 2048M -ca 0 -ti 0 -o <output log file name> -os
102400 -n <DB Name> <db script name

However, according to what returned by the "top" command, the ASA 9 database
server has only got the initial cache size of 937MB.

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
256 root 33 58 0 937M 934M cpu0 90.6H 38.21% dbsrv9

Nevertheless, there is no such problem in ASA 8.0.1. If I run ASA 8.0.1
with the same parameters on the same box, it can correctly take 2GB space
according to the -c option.

Has anyone encountered similar problem before? Any pointer or information
is much appreciated. Thank you very much in advance.

Thanks and Best Regards,
Monica

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.