This table maintains a catalog of groups.
Table 1. Group table (ARSGROUP)
| Column Name |
Data Type |
Description |
| gid |
INTEGER |
Group identifier |
| id |
INTEGER |
Owner of the group; can be a user or a group |
| name |
VARCHAR(128) |
Name of group |
| description |
VARCHAR(120) |
Group description |
| upd_userid |
VARCHAR(128) |
Userid of last user to update group |
| upd_date |
BIGINT
(DB2®, SQL Server), INT (Oracle) |
Date and time group was last
updated (in old style) |
| upd_dt |
TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) |
Date and time group was last
updated |
Table 2. Indexes for group table (ARSGROUP)
| Index name |
Columns in index |
Type of index |
| arsgroup_gid_idx |
gid |
Unique cluster index for DB2; Unique index for Oracle and SQL Server |
| arsgroup_name_idx |
name |
Unique index |