Fixing improper Adaptive Server configurations

[CR #298723] If you configure Adaptive Server incorrectly, or if you do not have sufficient memory, you may see the following error in your Jaguar.log or in the Portal and Studio datamanager.log when you install Enterprise Portal:

Cannot initialize the Java Virtual Machine because the Java class library ($SYBASE/$SYBASE_ASE/lib/runtime.zip) is either missing, corrupted, or incompatible with the current server release. Contact your System Administrator for help.

Workaround: Make sure that you have properly defined your SYBASE_ASE environment variable before you run your Adaptive Server.

Setting your SYBASE_ASE environment variable in Windows NT

1. Shut down your Adaptive Server:

   isql -Usa -P -Sservername
   1> shutdown
   2> go
   

2. Using the Control Panel | System interface, select the Environment tab.

3. Click in the System Variables window.

4. At the Variable prompt, enter SYBASE_ASE.

5. At the Value prompt, enter the path to your Adaptive Server, such as %SYBASE%\ASE-12_5.

6. Click Set.

7. Click Done.

8. Restart the Adaptive Server Service

If setting your SYBASE_ASE environment variable does not solve the problem, your Adaptive Server might have insufficient memory.

Increasing the amount of memory for Adaptive Server

1. Log in to your Adaptive Server.

   isql -Usa -P -Sservername
   

2. Determine your existing configuration for process object heap using the sp_configure system procedure:

   1> sp_configure "size of process object heap"
   2> go
   

   Parameter Name                  Default    Memory Used  Config Value
       Run Value    Unit                Type
   -----------------------------   -------    -----------  ------------
       -----------  ------------------- ----------
   size of process object heap     1500       3076        1500
       1500         memory pages(2k)    dynamic
   (1 row affected)
   (return status = 0)
   

3. Increase this parameter to a level that allows your Java Virtual Machine to operate. If the value you enter causes an insufficient memory error, increase the memory, and reexecute sp_configure:

   1> sp_configure "size of process object heap", 2000
   2> go
   

   Msg 5861, Level 16, State 2:
   Server 'tangelo', Procedure 'sp_configure', Line 599:
   The current 'max memory' value '33792', is not sufficient to change the parameter 'size of process object heap' to '2000'. 'max memory' should be greater than 'total logical memory' '34288' required for the configuration.
   (return status = 1)
   

   1> sp_configure "max memory", 34288
   2> go
   

   Parameter Name                  Default    Memory Used  Config Value
       Run Value    Unit                Type
   -----------------------------   -------    -----------  ------------
       -----------  ------------------- ----------
   max memory                      33792      68576        34288
       34288        memory pages(2k)    dynamic
   
   (1 row affected)
   Configuration option changed. The SQL Server need not be rebooted since the option is dynamic.
   Changing the value of 'max memory' does not increase the amount of memory Adaptive Server uses.
   (return status = 0)
   

   1>  sp_configure "size of process object heap", 2000
   2> go
   

   Parameter Name                  Default    Memory Used  Config Value
       Run Value    Unit                Type
   -----------------------------   -------    -----------  ------------
       -----------  ------------------- ----------
   size of process object heap    1500        4076        2000
       2000         memory pages(2k)    dynamic
   
   (1 row affected)
   Configuration option changed. The SQL Server need not be rebooted since the option is dynamic.
   Changing the value of 'size of process object heap' to '2000' increases the amount of memory ASE uses by 1000 K.
   (return status = 0)
   

Copyright © 2005. Sybase Inc. All rights reserved.

View this release bulletin as PDF