Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    11

    Unanswered: ASE 12.0 Configuration

    I have installed Sybase ASE12.0 on Win 2k Advance Machine.Machine configuration is as follows:
    1 Dual Xeon 3.0Ghz, 1GB Rack Mountable Server.
    1 2GB DDR.
    2 36.4GB Ultra32015K RPM Hard Disk Drive.
    6 72GB Ultra32015K RPM Hard Disk Drive.
    1 5404 SMART Array Controller 256MB Cache.
    1 4354 Rack Drive Encloser
    1 24X7 4 Hrs on site Cover
    1 Internal SDLT Tape Drive
    1 Windows Server 2000 Adv

    While doing the configuration I could change few parameters from the Configure Option on Sybase Central.
    But now when I am trying to change remaining options it is giving following error:
    "Msg 701, Level 17, State 3:Line 1:
    There is not enough procedure cache to run this procedure, trigger, or SQL batch
    . Retry later, or ask your SA to reconfigure SQL Server with more procedure cache."

    But now I can not change the procedure cache as even for changing that it gives same error.

    Can any one help me to solve this issue.

  2. #2
    Join Date
    Nov 2003
    Posts
    1

    12.0 configuration

    Hi

    You can change onr parameter to get more procedure cache

    procedure cache percent = 20 (this is the default value)

  3. #3
    Join Date
    Nov 2003
    Location
    Zurich, Switzerland
    Posts
    7

    Re: 12.0 configuration

    Originally posted by brahmareddy
    Hi

    You can change onr parameter to get more procedure cache

    procedure cache percent = 20 (this is the default value)
    You may have to change the server.cfg file manually BEFORE you start your server.

    config parameter = "procedure cache percent"

    if you did a default install it will be in the $SYBASE/$ASE-12_n/install dir

  4. #4
    Join Date
    Nov 2003
    Posts
    10

    Re: ASE 12.0 Configuration

    Shutdown your server.
    Change configuration parameter. Procedure Cache size.
    Restart server.

  5. #5
    Join Date
    Oct 2003
    Posts
    11

    Re: ASE 12.0 Configuration

    Originally posted by Hemendra
    Shutdown your server.
    Change configuration parameter. Procedure Cache size.
    Restart server.
    manually changed the parameter.It worked..Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •