1. Frank WU
  2. PowerBuilder
  3. Friday, 10 July 2020 04:38 AM UTC

Hi Guys,

I use PB 2017 and connect to JDBC Derby which is java embedded DB, I experienced some slow queries, trying to adjust JVM heap size. based on document, there is way to config JVM, by setting

[HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\PowerBuilder\2017\Java\PBRTConfig\PBJVMconfig]
"Count"="3"
"0"="-Xms512M"
"1"="-Xmx1024M"
"2"="-verbose:jni,class"

but seems it doesn't work, my questions are

1. does this approach still work or not?

2. if works, what's wrong with my setting

 

Very appreciated your feedback.

 

thank you

 

Frank

10/7/2020 

 

 

Frank WU Accepted Answer Pending Moderation
  1. Wednesday, 15 July 2020 05:14 AM UTC
  2. PowerBuilder
  3. # 1

It works by setting environment variable JAVA_TOOL_OPTIONS after some trials

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 15 July 2020 13:49 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.