Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 
Support > Technical Documents > Document Types > Technote > Monitor Server Problem with Support of Over 1.75GB...

Monitor Server Problem with Support of Over 1.75GB Shared Memory

Dataserver binary does not support over 1.75GB of Adaptive Server shared memory.
 
RSS Feed
 
 
 

The monserver binary does not support more than 1.75GB of Adaptive Server Enterprise (ASE) shared memory on the HP-UX platform.

Problem

Monitor Server cannot connect to Adaptive Server when more than 1.75GB of shared memory is enabled on HP-UX.

Symptoms

When you enable more than 1.75GB of shared memory using the HP-UX command chatr-m dataserver, then attempt to start Monitor Server while Adaptive Server is running, a connection error occurs. A message like the following is displayed:

msgid 20074 os_attach_region: shmat(409); invalid argument, 2011 KB attach: couldn’t attach to kernel region

Although the chatr-m dataserver command created a new dataserver binary with the SHEM-MAGIC (shared memory) bit set, Monitor Server cannot connect to the newly created shared memory.

Cause

In order to support over 1.75GB of shared memory, both Adaptive Server and Monitor Server must be built with a flag that accommodates this. Adaptive Server is built with this flag, but not all versions of Monitor Server are built with the flag; with these versions of Monitor Server, it is not possible to support this amount of shared memory.

Solution

Use a Monitor Server version and EBF level that are built with the appropriate flag to support more than 1.75GB of ASE shared memory:

  • Use Monitor Server 11.9.2, with EBF #8824, for SQL Server 11.0.x.

  • Use Monitor Server 11.5.1, with EBF #8078, for Adaptive Server 11.5.x.

  • Use Monitor Server 11.5.1, with EBF #8078, for Adaptive Server 11.9.x.

You still need to execute the chatr -m command for the monserver binary using the syntax: chatr -m monserver.


 

DOCUMENT ATTRIBUTES
Last Revised: Feb 04, 2000
Product: SQL Server Monitor
Technical Topics: Database Admin
  
Business or Technical: Technical
Content Id: 20281
Infotype: Technote
 
 
 

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics