For Oracle, we considered the following resource model for the backup and restore scenario:Archive Destination Logs resource model: Monitors the Oracle archive logs and the amount of free space and the percentage of free space in the Oracle archiving log destinationFor Informix, the following resource models are relevant for the backup and restore scenario:IBMInformix Archive Monitor resource model: Monitors the IBM Informix backup processes at cycle timeIBMInformix Logical Log Backup Monitor resource model: Monitors the informix online log file for logical log backupsActThe action that relates to the backup and restore process can be assisted by automated tasks.
Chapter 4. Managing databases scenarios 774.3 Operational tasksThis section discusses the available operational tasks from IBM Tivoli Monitoring for Databases. The tasks supplied with IBM Tivoli Monitoring for Databases are categorized into:Product implementation tasks: These tasks help in installing and configuring the IBM Tivoli Monitoring for Databases software.Administration tasks: These tasks start and stop subsystems and instances of the database engine.Other tasks: These tasks perform specialized functions for the related database.Most of the supplied tasks for IBM Tivoli Monitoring for Databases relate to the product implementation and administration. IBM Tivoli Monitoring for Databases: DB2 supplied quite an extensive collection of utilities, which do not exist for the other modules.4.3.1 IBM Tivoli Monitoring for Databases: DB2These DB2 tasks are available:Product implementation tasks:–ECC_Start_DB2SNMP_Agent–ECC_Set_Up_Monitoring_Agent–ECC_Start_Monitoring_Agent–ECC_Stop_DB2SNMP_Agent–ECC_Stop_Monitoring_Agent–ECC_Send_Files_To_TEC_TMR–ECC_TBSM_Discovery–ECC_Configure_TEC_Classes Notifying other users and operator:–ECC_Broadcast_Message: Broadcasts message to all Tivoli desktops–ECC_Send_Notice: Sends notice to all Tivoli administrators, which can be retrieved by them using the desktopModifying and changing audit feature:–ECC_Configure_Audit: Makes changes that take effect in the DB2 auditing facility
78IBM Tivoli Monitoring for Databases - Database Management Made Simple–ECC_Get_Audit_Configuration: Returns the current audit configuration to audit events–ECC_Reset_Audit_Configuration: Resets the DB2 audit configuration to the initial configurationDB2 administration server manipulation:–ECC_Create_Admin_Server: Creates a DB2 administration server–ECC_Drop_Admin_Server: Drops the DB2 administration serverDB2 sample database manipulation for testing:–ECC_Create_Sample_Database: Creates a sample DB2 database–ECC_Drop_Sample_Database: Drops the DB2 sample databaseChanging configuration for administration server:–ECC_Get_Admin_Configuration: Retrieves the DB2 administration configuration–ECC_Reset_Admin_Configuration: Resets the configuration values in the administration server to the system default values–