Half Day Informix Class - no travel necessary
svisser1 2700018UK9 Comment (1) Visits (4062)
Managing IDS Using the SQL Admin API and Scheduler ILO course (3S301)
In this course, learn about the features of the Informix SQL Administration Application Programming Interface (API). Learn how to write SQL statements to perform a variety of system administration tasks, and will see different ways in which the Administration API can be used. Also learn about the Informix Dynamic Server (IDS) Scheduler and how to create tasks to be performed at regular times or intervals. You will also learn how to create sensors to gather system information into tables over time. Examples will be presented on how tasks and sensors can be used.View this course in other countries
Note: This is an Instructor Led On Line course. Please do not make travel arrangements for this course. Your system should have a microphone and speakers for interfacing with the instructor and other students. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
This course is eligible for the IBM Education Advantage Program.
Audience This is an intermediate course for Informix Dynamic Server System and Database Administrators.
PrerequisitesYou should have: IBM Informix Dynamic Server System Administration (IX810) or (IX811), or 6 months experience with IDS system administration.
Skills taught * Distinguish between the task and admin functions * Write SQL commands to perform administration tasks * Create and schedule administrative tasks * Create and schedule sensors to collect system information * Analyze the information collected by sensors
I. The sysadmin Database
II. SQL Administration API
* API functions: admin and task * Admin API commands and options * Administration command examples * ONMODE examples * Admin API scenarios
III. Built-in Database Scheduler
* Creating and scheduling a task * Task examples * Creating and scheduling a sensor * Built-in sensors * Sensor examples * Task and sensor scenarios
Course code: 3S301 Skill level: Inte
Make sure you check the course catalog regularly for new Instructor Led On Line courses as they launch.