• 포털 전문가 되기
• 다운로드
• 인쇄
• 내 다운로드 ()

• 지원
• 기술 문서
• Foglight for DB2 (Cartridge) 5.9.4.20
• Foglight for DB2 (Cartridge) 5.9.4.20 - Deployment Guide

Foglight for DB2 (Cartridge) 5.9.4.20 - Deployment Guide

콘텐츠 탐색  

Deployment pre-requisites

Architecture Deployment in Centralized vs Distributed Hardware requirements

SQL PI configured SQL PI not configured Manual configuration required by all users

Supported monitoring platforms Supported monitored databases Supported monitored BI services PI aggregation and retention Permissions for monitored databases

Permissions for Oracle databases

Additional configurations for Amazon Oracle RDS instances

Permissions for SQL Server databases Permissions for Sybase databases Permissions for DB2 for LUW databases

Permissions for monitored operating systems

Install the DB cartridge and DB agent

Install the DB cartridge Install a single DB agent

Install a single SQL Server or Oracle agent Install a single DB2 agent Install a single Sybase agent

Special configurations

Foglight Upgrades High Availability Federation Concentrator (Proxy)

• Viewing Topics 9 - 12 of 29

×

Supported monitored databases

 

Table 7. Supported Monitored Databases

Oracle®	SQL Server®	Sybase®	DB2 for LUW
Oracle Database 10g* Oracle Database 11g Oracle Database 12c Oracle Database 18c Oracle Database 19c	Microsoft® SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 for Windows Microsoft SQL Server 2017 for Linux Microsoft SQL Server 2012 on Amazon RDS Microsoft SQL Server 2014 on Amazon RDS Microsoft SQL Server 2016 on Amazon RDS Microsoft SQL Server 2017 on Amazon RDS	Adaptive Server Enterprise: 12.5.1 through 16.0   Replication Server: 12.1, 12.5, 12.6, 15.0, 15.1, 15.2	DB2 version 9.5, 9.7, 10.1, 10.5, 11.1

Oracle Database 10g* — SQL PI supports version 11g and later

Operating Systems — All operating systems supported by the vendor.

Supported Editions — All editions supported by the vendor. Except for Sybase Edge and Runtime editions.

NOTE: 1. The SQL Server Azure managed instance is supported. 2. For the Amazon RDS SQL Server, only Standard and Enterprise version are supported.

Supported monitored BI services

•	The same user monitoring the SQL Server database engine must be used to monitor the Integration and Reporting Services.

•	The login ID used to monitor the Integration Service must be a user on the SSISDB database. This user ID is created while applying the “Grant permissions” script.

•	The ID used to monitor the Integration Services on the database needs to have:

•	the ssis_admin role in order to gather all needed information for its collections.

•	the db_datareader role on the SSISDB database.

•	Monitoring Analysis Services requires system administrator permissions on the Analysis Services instance.

•	Monitoring Analysis Services is supported only on Agent Managers running on Windows which must have a version of .Net 3.5 installed.

•	No additional permissions are required to monitor the Reporting Services.

 

Table 8. Supported Monitored BI Services

Integration Services*	Reporting Services*	Analysis Services
Microsoft® SQL Server® 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 for Windows	Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 for Windows	Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2017 for Windows

*SQL Server instance must be monitored to be able to monitor the service.

Operating Systems — All operating systems supported by the vendor.

Supported Editions — All editions supported by the vendor.

PI aggregation and retention

PI manages data using an internal time pyramid; the roll-up process runs every 15 minutes.

 

Table 9. Time pyramid table

Time resolution	Retention period
1 minute	6 hours
15 minutes	3 days
1 hour	2 weeks
6 hours	30 days
1 day	90 days
1 week	2 years

Permissions for monitored databases

Ensure that you set the permissions required, based on which database you are using:

•	Permissions for Oracle databases

•	Permissions for SQL Server databases

•	Permissions for Sybase databases

•	Permissions for DB2 for LUW databases

•  이전
• Viewing Topics 9 - 12 of 29
• 다음 

이 문서 검색 모든 문서 검색

×

 지원 시작

계열사 지원 사이트에서 Quest *제품*에 대한 온라인 지원 도움말을 볼 수 있습니다. 올바른 *제품* 지원 콘텐츠 및 지원에 연결하려면 계속을 클릭하십시오.

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center