5-Informix11.5全新管理工具OAT.pptVIP

OAT – Open Admin Tool 基于浏览器的GUI工具 – Free Download. 辅助DBAs轻松完成各种管理工作 实时地监控并直观的显示数据库实体、实例、集群及操作系统资源 实时告警与修复 动态调整参数 用户会话监控 实时的性能指标报告 SQL语句跟踪及钻取分析 任务调度 数据压缩与存储优化管理 健康中心 - 告警 显示当前数据库系统的健康状态 各种告警提示及可能存在的修复动作 健康中心 – 仪表盘(1) 健康中心 – 仪表盘(2) 监控所有执行过的管理命令 在线的数据库消息日志 数据库备份/恢复的信息 任务调度和管理 数据空间管理 Chunks - Chunk I/O 物理日志/逻辑日志/检查点 Informix高可用数据库集群管理 参数调整 数据校验 用户授权 SQL性能分析 Why SQL Drill Down? To answer questions that DBA’s and other professionals like to ask: How long do SQL statements take? How many resources are individual statements use? How long did a statement execution take? How much time was involved waiting for each resource? Most of the time, these questions arise when something is not right on their systems. This is a way to quickly get into the details of those issues. SQL Explorer SQL Explorer – Detail Statistics SQL Drill Down Analysis 性能历史数据 各类性能分析报告 用户会话管理(1) 用户会话管理(2) 用户会话管理(3) 用户会话管理(4) 数据压缩与存储优化 新增的SQL管理命令 A set of User Defined Routines (UDRs) to administer the Informix database server. The major categories of administration include: Space Management. Configuration Management. Routine task maintenance. System Validation (oncheck functionality). Feature Benefits: SQL Based Administration. Remote Administration. Tracking of command execution and results in a system table. Ontape支持文件目录 TAPEDEV and LTAPEDEV may now each be pathnames: The directories must exist, otherwise an error is returned. A built-in logic generates the file names. The first file for each file group generated shows the level number. e.g. L0…. Or L1…… The server system name is the first part of the filename. Current Backup Filename format: HostName_ServerNum_BackupType. Previous Backup Filename format (if present): HostName_Server_Num_Date/Time_BackupType. Logical Log filename format: HostName_ServerNum”Log” log_uniqid. For logical logs, file names are generated in logical log number order. You can override the prefix (excluding “_BackupType”) of the file name with the environment parameter IFX