Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Overview of automatic monitoring and corrective actionsYou can use the SQL administration API, the Scheduler, and drill-down queries to manage automatic maintenance, monitoring, and administrative tasks.
The SchedulerYou can use the Scheduler to create jobs to run administrative tasks or collect information at predictable times. The Scheduler uses SQL statements instead of operating system job scheduling tools.
Creating a groupYou can create a group to organize Scheduler tasks and sensors.

Creating a group

You can create a group to organize Scheduler tasks and sensors.

Before you begin

You must be connected to the sysadmin database as user informix or another authorized user.

When you create a task or sensor, you can specify a group name from the ph_group table in the tk_group column of the ph_task table.

About this task

To create a group:

Procedure

Use an INSERT statement to add a row into the ph_group table in the sysadmin database.

You must include a name for the group for the group_name column and a description of the group for the group_description column. The database server generates an ID for the group in the group_id column.

Example

The following example adds a group named TABLES:

INSERT INTO ph_group 
(
group_name,
group_description
)
VALUES
(
"TABLES",
"Tasks that trim history and results tables."
);