Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi guys, need your help with this memory leak issue using dbsrv9. I have set a -c 64m and -ch 128m to limit the memory usage but the -c and -ch option is not working. In fact, it is now at 1 gb and increasing.

Hope you can give me some ideas, i have been struggling to solve this for almost amount now.

Thanks.

asked 21 Jul '12, 23:44

xbrandon's gravatar image

xbrandon
16112
accept rate: 0%

retagged 24 Jul '12, 05:26

Daz%20Liquid's gravatar image

Daz Liquid
905202541

What is the build number? SELECT @@VERSION

Exactly where do you see the "1 gb" number?

What does this query return? SELECT PROPERTY ( 'CurrentCacheSize' ), PROPERTY ( 'MaxCacheSize' );

Please show us the exact command line that launches dbsrv9.exe.

(22 Jul '12, 07:06) Breck Carter

Thank you for your reply.

Actually i have no idea about sybase database. I am just wondering if you have answers with Symantec embedded database issue (Adaptive server anywhere), which we think has memory leak.

Exactly where do you see the "1 gb" number? - It is the memory usage listed under task manager

Please show us the exact command line that launches dbsrv9.exe. - I did not launch the command, it is pre configured by symantec application and listed under registry settings. Please see below info

-c 64m -ch 64m -gp 8192 -gc 30 -gr 30 -o "C:\Program Files\Symantec\Symantec Protection Center\db\out.log" -oe "C:\Program Files\SymantecSymantec Protection Center\db\err.log" -os 1m -gn 80 -n Win2k8 "C:\Program Files\Symantec\Symantec Protection Center\db\sem5.db" -n sem5 -sb 0 -x tcpip(localonly=yes;port=2638)

Hope you can give me some answers.

Thanks.

(22 Jul '12, 08:54) xbrandon
Replies hidden

Your best hope is to call Symantec tech support for the product that using the database.

You could also try calling Sybase tech support: http://www.sybase.com/contactus/support/

(22 Jul '12, 17:24) Breck Carter

Breck was correct in his first recommendation: contact Symantec Technical Support ( http://www.symantec.com/business/support/ ). They are responsible for the application itself, it's supported versions, and your specific environment configuration.

Symantec is a partner of Sybase.

permanent link

answered 23 Jul '12, 12:34

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×11

question asked: 21 Jul '12, 23:44

question was seen: 3,496 times

last updated: 24 Jul '12, 05:26