Chat now with support
Chat with Support

Foglight for Sybase 5.7.5.40 - Release Notes

Global Operations

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe.

This release has the following known capabilities or limitations: The server will be enabled for Global Operation, but not localized to any particular locale.

 

Back to Top

Product Licensing

Product Licensing

Foglight includes a licensing capability that restricts access to those features that are defined in the license. Any Management Server installation requires a license that grants access to server-specific parts of the browser interface and the features associated with them. Foglight cartridges are also license-protected. While some cartridges are covered by the base Foglight license (such as Foglight Agent Manager cartridges and the Foglight for Infrastructure), others may require an additional license.

 

To activate a trial or a purchased commercial license:

  1. On the navigation panel, under Dashboards, click Administration > Setup & Support > Manage Licenses.
  2. Click Install.
  3. In the Install License dialog box, click Browse.
  4. In the file browser that appears, specify the location of the license file.
  5. In the Install License dialog box, click Install License.

Back to Top

Getting Started

Getting Started

Contents of the Release Package

The Foglight Cartridge for Sybase release package contains the following:

  1. Foglight Cartridge for Sybase 5.7.5.40
    • SybaseCartridge-aix-powerpc-5_5_8_3.car
    • SybaseCartridge-hpuxB_11-5_5_8_5.car
    • SybaseCartridge-linux-5_5_8_5.car
    • SybaseCartridge-solaris-sparc-5_5_8_5.car
    • SybaseCartridge-windows-5_5_8_5.car
  2. Product Documentation, including:
    • Foglight Managing Sybase Database Systems 5.7.5.40 User and Reference Guide (PDF and online help)
    • Foglight Cartridge for Sybase 5.7.5.40 Release Notes (this document)

Installation Instructions

Verify that your system meets the minimum hardware and software requirements before attempting to install and run the Foglight Cartridge for Sybase 5.7.5.40. Refer to Installation and Compatibility for information regarding installing the new Cartridge for Sybase.

Note: Before beginning the installation process, you must install, or have already installed, Foglight 5.7.5.

The installation process is common for all Foglight cartridges, and is described in the Foglight Administration and Configuration Help.

After installing the Cartridge for Sybase, perform the configuration steps below:

  1. After you install the Sybase cartridge for the first time, go to Components for Download (in Cartridges menu) and download the DB_Sybase_firstRun_scripts. Extract the zip file.
  2. Run script rapsAdmin.sql as "sa" user. This script creates only two helper stored procedures: sp_fgl_addgrant and sp_fgl_adduser.
    isql -Usa -Ppassword -SserverName -i rapsAdmin.sql -o rapsAdmin.out
  3. Send the setup_mon_tables.sql file to your Sybase DBA for review and configuration of relevant Sybase MDA parameters.

To create a new Sybase user:

  1. Run the following scripts as sa user (use your username and password. Note: The new user has to have only one role: mon_role. Grant mon_role to 'username'
exec sp_addlogin 'username' , 'password' , sybsystemprocs
exec sp_fgl_adduser 'username' , 'foglightGroup'


Viewing the Cartridge for Sybase: 


    
	
  • On the navigation panel, under Dashboards, click Administration > 
	Cartridges > Cartridge Inventory. For details specific to the installation 
	of the cartridge agents, see the following sections.



Sybase Adaptive Server Prerequisites: Sybase_MDA Agent


Install Sybase_MDA


The first pre-requisite is that the Sybase_MDA feature be installed on the 
respective ASE. This feature is not automatically installed on all versions of 
Sybase ASE. A check the DBA can run is the query: “select * from 
master..monState”.


If the monitoring tables are not installed in your Adaptive 
Server (12.5.1 or later), have the Sybase DBA for the respective ASE follow the 
steps to install the tables listed in the Addendum at the end of this section.


For versions 15.x, there is no need for loopback and installmontables.


Configure Sybase_MDA


The Sybase_MDA feature has numerous parameters to both turn on and turn off 
specific metrics and determine the amount of memory the ASE will set aside for 
these metrics.


Performance monitoring how has the ability to enable the user to set the 
per_object_statistics flag to off.


Configure ports


Callback collections require communication between the Foglight Management 
Server and the Sybase server.  Ensure that the port used by the Sybase host 
server is open between the Sybase host and the Foglight Management Server.


Sybase 'mon_role' assigned


The Sybase login defined in the Foglight agent property for the respective 
agent must have the “mon_role” assigned. This is also applicable to the ‘sa’ 
login.


Command to execute via ISQL or other client tool:


grant role mon_roleto_<logon_name>


Sybase Adaptive Server Pre-requisites: Sybase_RS Agent


The Sybase_RS agent requires separate common logins to be created for the 
Replication Server, the RSSD data server, the Primary data server, and the 
Replicate data server. 


    
	
  • Replication Server - Create a user with no special permission for each 
	Replication Server being monitored.
	
  • RSSD data server - Create a login for RSSD data server. Create a user 
	with the same login name for the RSSD database. This user should be a member 
	of the rs_systabgroup.
	
  • Primary data server - Create a login with the replication_role in each 
	Primary data server.  Create a user with the same login name for the Primary 
	database.
	
  • Replicate data server - Create a login in each Replicate data server.  
	Create a user with the same login name for the Replicate database. This user 
	should have select permission for the rs_lastcommit table.



Note: Refer to the Sybase_RS "Setting Connection Details" 
topic in the Managing Sybase Database Systems online help for more 
information. 


Addendum


Preparation of the ASE version 12.5.1 or later for Foglight Cartridge for 
Sybase 5.7.5.40


Install MDA


If the monitoring tables are not installed in your Adaptive Server (12.5.1 or 
subsequent release), have the Sybase DBA for the respective ASE follow these 
steps to install the tables.


First, a server named “loopback” must be included in sysservers before 
installing the scripts for the MDA tables. Proxy tables for the monitoring 
tables are not created by default when you configure Adaptive Server. The tables 
are created in the second step using the installmontables script that is 
included in the Adaptive Server install (located in the $SYBASE/ASE-12_5/scripts 
directory).


    
	
  1. Create a loopback server entry in ISQL:
      
		
    1. Logon to Ada.
		
    2. Execute:
		
      sp_addserver 'loopback', null, <ASE server name> go
      
		
	
    
	
	
  2. Execute the installmontables script located in the 
	$SYBASE/ASE-12_5/scripts directory (%SYBASE%/ASE-12_5/scripts for Windows) 
	using ISQL:
	
    isql –Usa –P<sa password> -S<server name> -n –i%SYBASE%/%SYBASE_ASE%/scripts/installmontables
    
	



Adaptive Server Enterprise configuration parameters


Sybase_MDA agent requires the following configuration for it to run correctly 
and gather the specified data for the Foglight Management Server. 
The values 
shown for the following parameters are the minimum required values that the 
Foglight Cartridge for Sybase 5.7.5.40 needs for proper data collection and 
reporting. Any of these parameter values could be increased if necessary. (You 
can copy, paste, and execute the following script into an ISQL or other client 
session.)


sp_configure "statement cache size" <size_of_cache>
go
sp_configure "errorlog pipe max messages",1000
go
sp_configure "max SQL text monitored",256
go
sp_configure "sql text pipe max messages",3000
go
sp_configure "statement pipe max messages",3000
go
-- Flags
sp_configure "enable stmt cache monitoring" , 1
go
sp_configure "enable literal autoparam" [0|1]
go
sp_configure "enable monitoring", 1
go
sp_configure "sql text pipe active", 1
go
sp_configure "errorlog pipe active", 1
go
sp_configure "per object statistics active",1
go
sp_configure "statement statistics active",1
go
sp_configure "statement pipe active",1
go
sp_configure "wait event timing",1
go
sp_configure "SQL batch capture",1
go
sp_configure "process wait events",1
go



The 
following tables list proprietary Sybase flags and the Sybase_MDA agent tables 
dependent upon them. If any of the settings do not have values that fall in the 
recommended value range, data collection will issue complaints and fail to 
successfully collect; indicating that some MDA table collection was canceled as 
a result of the flags being set incorrectly. To prevent these alerts from 
occurring, use the appropriate Data Management properties to disable the 
collection that is failing to collect. Below is a listing of Sybase_MDA agent 
tables and the configuration settings they depend on:


 



Foglight Table
Sybase MonTable (MDA) Configuration Settings
TopHash
enable stmt cache monitoring = 1
statement cache size = size_of_cache
enable literal autoparam = 0 or 1
Note: Setting enable literal autoparam to 0 causes Sybase to treat each SQL statement separately; setting it to 1 produces bind variables for each search argument in an SQL statement.
TopSQL
enable monitoring = 1
statement statistics active = 1
per object statistics active = 1
statement pipe active = 1
SQL batch capture = 1
max SQL text monitored > 0
statement pipe max messages > 0
sql text pipe max messages > 0
UsersBlocked
enable monitoring = 1
wait event timing = 1
SQL batch capture = 1
max SQL text monitored > 0
UsersLogCache
enable monitoring = 1
wait event timing = 1
per object statistics active = 1
TopApplications
enable monitoring = 1
wait event timing = 1
per object statistics active = 1
Index
enable monitoring = 1
wait event timing = 1
per object statistics active = 1
TopUsers
enable monitoring = 1
wait event timing = 1
per object statistics active = 1
SQL batch capture = 1
statement pipe active = 1
max SQL text monitored > 0
sql text pipe max messages > 0



 





Back to Top

For More Information

For More Information
 


Get the latest product information, find helpful resources, test the product betas, and join a discussion 
with the Foglight Quest team and other community members. Join the Foglight Community at
http://communities.quest.com/community/foglight.


Contacting Quest


For sales or other inquiries, visit

http://quest.com/company/contact-us.aspx or call +1-949-754-8000.


Technical support resources


Technical support is available to Quest customers with a valid maintenance 
contract and customers who have trial versions. You can access the Quest Support 
Portal at https://support.quest.com.


 


The Support Portal provides self-help tools you can use to solve problems 
quickly and independently, 24 hours a day, 365 days a year. The Support Portal 
enables you to:


    
	
  • Submit and manage a Service Request.
	
  • View Knowledge Base articles.
	
  • Sign up for product notifications.
	
  • Download software and technical documentation.
	
  • View how-to-videos.
	
  • Engage in community discussions.
	
  • Chat with support engineers online.
	
  • View services to assist you with your product.



Back to Top



			

© 2017 Quest Software, Inc. ALL RIGHTS RESERVED.


 


This guide contains proprietary information protected by copyright. The 
software described in this guide is furnished under a software license or 
nondisclosure agreement. This software may be used or copied only in accordance 
with the terms of the applicable agreement. No part of this guide may be 
reproduced or transmitted in any form or by any means, electronic or mechanical, 
including photocopying and recording for any purpose other than the purchaser’s 
personal use without the written permission of Quest Software Inc.


The information in this document is provided in connection with Quest 
Software products. No license, express or implied, by estoppel or otherwise, to 
any intellectual property right is granted by this document or in connection 
with the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND 
CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST 
SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR 
STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE 
IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR 
NON-INFRINGEMENT. IN NO EVENT SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, 
INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, 
WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS 
OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN 
IF QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest 
Software makes no representations or warranties with respect to the accuracy or 
completeness of the contents of this document and reserves the right to make 
changes to specifications and product descriptions at any time without notice. 
Quest Software does not make any commitment to update the information contained 
in this document.
If you have any questions regarding your potential use of 
this material, contact:



Quest Software Inc.
Attn: LEGAL Dept.
4 Polaris Way
Aliso Viejo, 
CA 92656
Refer to our website (www.quest.com) 
for regional and international office information.


Patents


Quest Software is proud of our advanced technology. Patents and pending 
patents may apply to this product. For the most current information about 
applicable patents for this product, please visit our website at 
www.quest.com/legal.



Trademarks


Quest, Quest Software, the Quest Software logo, Foglight, IntelliProfile, 
PerformaSure, Spotlight, StealthCollect, TOAD, Tag and Follow, Vintela Single Sign-on for Java, 
and vFoglight are trademarks and registered trademarks of Quest Software, Inc in the United 
States of America and other countries. For a complete list of Quest Software's trademarks, please see 
http://www.quest.com/legal/trademark-information.aspx. 
Other trademarks and registered trademarks are property of their respective owners.




Third Party Contributions


Foglight contains some third party components. For a complete list, see the 
License Credits page in Foglight online help.


 



Back to Top
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating