Transcript IBM blue-and-white template

Informix Administration Overview
John F. Miller III
March 2008
July 17, 2015
© 2008 IBM Corporation
Information Management – IDS
What is OpenAdmin Tool for IDS?
 OAT is a web-based administration
tool for the IBM Informix Database
Server V11 and moving forward
 A single OAT installation can
administer one or more data servers
 No additional software is needed on
the data server
IDS
Servers
Web Server
OAT
2
© 2008 IBM Corporation
Information Management – IDS
The OAT Stack
Web Server
OAT
 Components which are
required to run
OpenAdmin Tool for IDS
 100% Free
 Available from various
sources
– Individual pieces
• IBM
• IIUG
– One Click Bundle
Installer which includes
all the components
• IBM
OpenAdmin Tool
Informix Connect
(or Client SDK)
PDO
Informix
sqllite
PDO
PHP 5
Web Server
3
© 2008 IBM Corporation
Information Management – IDS
OAT Data Server Interaction
 OAT accesses the data server using only
standard SQL statements
– Uses the existing sysmaster database to retrieve
performance and monitoring data
– Utilizes the SQL Admin API to make configuration
changes to the data server
SQL Statement
Returned Data
4
© 2008 IBM Corporation
Information Management – IDS
5
© 2008 IBM Corporation
Information Management – IDS
Google Map of IDS Servers
6
© 2008 IBM Corporation
Information Management – IDS
Performance History Graph
7
© 2008 IBM Corporation
Information Management – IDS
DBSpace Explorer
8
© 2008 IBM Corporation
Information Management – IDS
Query Drill Down
9
© 2008 IBM Corporation
Information Management – IDS
MACH
Explorer
10
© 2008 IBM Corporation
Information Management – IDS
MACH
Explore
r
11
© 2008 IBM Corporation
Information Management – IDS
MACH SDS Wizard
12
© 2008 IBM Corporation
Information Management – IDS
MACH Connection Manager Wizard
13
© 2008 IBM Corporation
Information Management – IDS
New sysmaster table sysmachineinfo
14
© 2008 IBM Corporation
Information Management – IDS
Recent Improvements in OpenAdmin
 Auto Update Statistics
 Dynamic Reconfiguration
 Onconfig analyzer and
recommendation
 Historical Data Graphs
 Data/Index Checking
 Memory Statistics
 Simple Switching between
server
 Task Scheduler improvements
15
 Menu Highlighting and
restructuring
 MACH 11 start/stop server
 Read only access to server.
 Redesigned Help system
 Simple installer
 MACH 11 connection manager
wizard
 Improved documentation and
FAQ
© 2008 IBM Corporation
Information Management – IDS
Other New Administration Features
 Alarm Message in the ph_alert table
 Database Scheduler does day of week
 SQL Trace Improvements
– The iterator table
• Part numbers of all scan iterators
• Time spent running iterators
– Add table called syssqltrace_hvar
• Contains host variables
 Improved Index Usage
16
© 2008 IBM Corporation