Transcript What is Fathom Trend database ? (cont.)

OPS-15: What was Happening with My
Database, AppServer™, OS ...
Yesterday, Last Month, Last Year?
Ruanne Cluer
Libor Laubacher
Principal Tech Support Engineer
Principal Tech Support Engineer
Agenda
What was happening with my database ….
 What's New in OpenEdge® Management
3.1C
 Fathom Trend database overview
 Current OpenEdge Management reports
 Progress® EasyAsk® overview
 Building EasyAsk dictionary for Fathom Trend
database
 Querying the data
 Wrap up
2
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
What's New in OE Management 3.1C
New features of 3.1C and 10.1C
 Property configuration
• enabled in 3.1C by default
• local and remote
 Resource properties distribution
• propagates polling properties from an existing
resource
 Rotating unified brokers log file support
• affects AppServer & WebSpeed®
• available since SP1
3
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
What's New in OE Management 3.1C
New features of 3.1C and 10.1C (cont.)
 Java™ 1.5 support
• including 64-bit
 Adminserver debugging
• -DdebugJVM=yes
 IPv6 support
• -ipver IPv4/IPv6
 Remote monitoring improvements
• threads deadlock fix
 Remote (log) file monitoring
4
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
What's New in OE Management 3.1C
Property configuration - demo
5
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Agenda
What was happening with my database ….





What's New in OpenEdge Management 3.1C
Fathom Trend database overview
Current OpenEdge Management reports
Progress EasyAsk overview
Building EasyAsk dictionary for Fathom Trend
database
 Querying the data
 Wrap up
6
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Fathom Trend Database overview
What is Fathom Trend database ?
 OpenEdge database
• default location $FATHOM/db
 Used to store performance data for a
monitored resource
• fed via JDBC from OpenEdge Management
• trending of the data is optional
• polling interval configurable
 Default poll timeout is 5 minutes
• 288 samples per day
7
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Fathom Trend Database overview
What is Fathom Trend database ? (cont.)
 Schema and table descriptions available in
OpenEdge Management online help
• Help 8 Documentation 8 Index
 Some tables worth mentioning
• Cf_resrc
• Cf_sample
• DB_*, OE_*, Sys_*
• Ar_*
8
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Fathom Trend Database overview
What is Fathom Trend database ? (cont.)
 Trend DB can contain 2 sample types
• real-time
• archived
 Compaction Job
• converts “real-time” data into “archived”
• takes samples (Cf_*, Db_*, Sys_* …) and
archives them into daily, weekly, monthly
information (rows in Ar_* tables)
• possible to purge old data
9
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Fathom Trend Database overview
What is Fathom Trend database ? (cont.) –
Compaction example

Db_ActSum Table

ActSum_Commits
ActSum_Undos
ActSum_DbReads
…

Cf_Sample
Sample_Date
Sample_Transaction
…
10
OPS-15: What was happening with my Database, AppServer, OS ...
Ar_ActSum
ActSum_Commits
ActSum_Undos
ActSum_DbReads
…
ActSum_StartDate
ActSum_EndDate
ActSum_Transactions
© 2008 Progress Software Corporation
Agenda
What was happening with my database ….





What's New in OpenEdge Management 3.1C
Fathom Trend database overview
Current OpenEdge Management reports
Progress EasyAsk overview
Building EasyAsk dictionary for Fathom Trend
database
 Querying the data
 Wrap up
11
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Current OpenEdge Management reports
OpenEdge Management reports overview
 Pure ABL (4GL) reports
• predefined
– r-code shipped
• C/N license required
• located under $FATHOM/src
• multiple formats output
 Source code available
• $FATHOM/src/fathom4gl-p.pl
12
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Current OpenEdge Management reports
OpenEdge Management reports overview (cont.)
 General reports
• alert detail
• alert summary
 System reports
• CPU & memory summary
• file system, network and disk activity
 AppServer & WebSpeed reports
• performance
• application profile
13
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Current OpenEdge Management reports
OpenEdge Management reports overview (cont.)
 Database reports
•
•
•
•
•
•
14
ai & bi info
checkpoints
table & index analysis
table & index usage
locking report
summary report
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Agenda
What was happening with my database ….





What's New in OpenEdge Management 3.1C
Fathom Trend database overview
Current OpenEdge Management reports
Progress EasyAsk overview
Building EasyAsk dictionary for Fathom Trend
database
 Querying the data
 Wrap up
15
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Progress EasyAsk overview
In short, what does EasyAsk do ?
 Allows its users to communicate with a
database in their native language
• English, French, Dutch, German …
 Puts Ad Hoc reporting in the hands of its end
users
• no need to involve IT to get a new report
 Integrates with several security models
 active directory, LDAP …
 Complements existing reporting systems
16
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Progress EasyAsk overview
In short, what does EasyAsk do ? (cont.)
 Translates user’s question into SQL
 Executes it against the database
 Returns the answer
 Current version 11.0
• includes the ability to simultaneously search the
database and existing reports.
• provides ‘a type ahead ability’ to help users
understand the type of questions they can ask
• automatically “offers” data names and previously
asked questions
17
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Progress EasyAsk overview
In short, what does EasyAsk do ? (cont.)
 “Who buys seafood but not dairy products”
translates to:
SELECT [CUSTOMERS].[LAST_NAME] as [Last Name],
[CUSTOMERS].[FIRST_NAME] as [First Name],
[CUSTOMERS].[COMPANY_NAME] as [Company Name] FROM
[CUSTOMERS] WHERE EXISTS(SELECT * FROM [ORDERS], [LINE ITEMS],
[PRODUCTS], [CATEGORIES] WHERE ([Category Name]='Seafood') and
[CUSTOMERS].[CUST ID] = [ORDERS].[CUST ID] and [ORDERS].[ORDER_ID]
= [LINE ITEMS].[ORDER_ID] and [PRODUCTS].[Product ID] = [LINE
ITEMS].[PRODUCT_ID] and [CATEGORIES].[Category ID] =
[PRODUCTS].[Category ID]) and NOT EXISTS(SELECT * FROM [ORDERS],
[LINE ITEMS], [PRODUCTS], [CATEGORIES] WHERE ([Category
Name]='Dairy') and [CUSTOMERS].[CUST ID] = [ORDERS].[CUST ID] and
[ORDERS].[ORDER_ID] = [LINE ITEMS].[ORDER_ID] and
[PRODUCTS].[Product ID] = [LINE ITEMS].[PRODUCT_ID] and
[CATEGORIES].[Category ID] = [PRODUCTS].[Category ID])
18
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Agenda
What was happening with my database ….





What's New in OpenEdge Management 3.1C
Fathom Trend database overview
Current OpenEdge Management reports
Progress EasyAsk overview
Building EasyAsk dictionary for Fathom Trend
database
 Querying the data
 Wrap up
19
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Building EA Dictionary for Fathom Trend DB
What does an EasyAsk dictionary contain ?
 Basic language constructs
 The connection information and table map for
the database
 A set of definitions that EasyAsk uses to
translate “English” to SQL
 Each definition consists of an English word
and its database meaning
• Definitions can also contain synonyms and
abbreviations
20
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Building EA Dictionary for Fathom Trend DB
How is an EasyAsk dictionary used ?
 Flat text file with .DXP extension
 Initially built by EasyAsk DataWorkshop
 Refined during implementation
• test questions
• search tuning
 Used by EasyAsk Server
• web access
• dictionary is being used to interpret the
language and link to the database
21
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Building EA Dictionary for Fathom Trend DB
Building the dictionary …
 Now the real fun begins!
 We need to teach EasyAsk about
• Fathom Trend db schema
• Data, terminology, synonyms
• Table relations, VIEWs creation
 Over to the EasyAsk DataWorkshop & Server
22
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Agenda
What was happening with my database ….





What's New in OpenEdge Management 3.1C
Fathom Trend database overview
Current OpenEdge Management reports
Progress EasyAsk overview
Building EasyAsk dictionary for Fathom Trend
database
 Querying the data
 Wrap up
23
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Querying the data
Querying Fathom Trend DB from EasyAsk - demo
24
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Agenda
What was happening with my database ….





What's New in OpenEdge Management 3.1C
Fathom Trend database overview
Current OpenEdge Management reports
Progress EasyAsk overview
Building EasyAsk dictionary for Fathom Trend
database
 Querying the data
 Wrap up
25
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
In Summary
Wrap up
 Fathom Trend database is not a black box or
something to be afraid of
• It contains useful data about your system,
database and application
 EasyAsk can be used to report on your trended
data without needing programming skills
26
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
For More Information, go to…
 OpenEdge Management PSDN corner
• http://www.psdn.com/library/kbcategory.jspa?ca
tegoryID=1296
 EasyAsk PSDN corner
• http://www.psdn.com/library/kbcategory.jspa?ca
tegoryID=665
27
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Relevant Exchange Sessions
 OPS-2: OpenEdge Management in the
Real World
 DEV-28: Making Business Intelligence as
Easy as Web Search
 OPS-21: Managing Multiple Sites Part
Time: OpenEdge Replication &
Management
28
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
?
Questions
29
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
Thank You
30
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation
31
OPS-15: What was happening with my Database, AppServer, OS ...
© 2008 Progress Software Corporation