Utilities

Privileges Required for Statements › Utilities

Utilities

To execute CA IDMS utilities, a user requires the privilege indicated in the following table if the resource type to which the privilege applies has been secured.

Note: The AREA NRU, and TABL resource types are secured when the DB resource type is secured.

Statement	Privilege Required	Resource Type	Resource Name
ARCHIVE JOURNAL	USE	DMCL	dmcl-name
ARCHIVE LOG	DBAWRITE	AREA	SYSTEM.DDLDCLOG
BACKUP AREA	DBAREAD	AREA	segment-name.area-name
BACKUP FILE	DBAREAD	AREA	segment-name.area-name (all areas in file)
BACKUP SEGMENT	DBAREAD	AREA	segment-name.area-name (all areas in segment)
BUILD	INSERT	TABL	schema-name.table-identifier
CLEANUP SEGMENT	DBAWRITE	AREA	segment-name.area-name (all areas in segment)
CLEANUP SEGMENT ... AREA	DBAWRITE	AREA	segment-name.area-name
EXPAND PAGE	DBAWRITE	AREA	segment-name.area-name (all areas in file)
FASTLOAD	DBAWRITE	AREA	segment-name.area-name (all areas in load)
FIX ARCHIVE	USE	DMCL	dmcl-name
FIX PAGE	DBAWRITE	AREA	segment-name.area-name
FORMAT AREA	DBAWRITE	AREA	segment-name.area-name
FORMAT FILE	DBAWRITE	AREA	segment-name.area-name (all areas in file)
FORMAT JOURNAL	USE	DMCL	dmcl-name
FORMAT SEGMENT	DBAWRITE	AREA	segment-name.area-name (all areas in segment)
INSTALL STAMPS	DBAWRITE	AREA	segment-name.area-name
LOAD	INSERT	TABL	schema-name.table-identifier
MAINTAIN INDEX	DBAWRITE	AREA	segment-name.area-name (affected areas in segment)
PRINT INDEX	DBAREAD	AREA	segment-name.area-name (index and data areas)
PRINT JOURNAL	USE	DMCL	dmcl-name
PRINT LOG	DBAREAD	AREA	SYSTEM.DDLDCLOG
PRINT PAGE	DBAREAD	AREA	segment-name.area-name
PRINT SPACE FOR AREA	DBAREAD	AREA	segment-name.area-name
PRINT SPACE FOR FILE	DBAREAD	AREA	segment name.area-name (all areas in file)
PRINT SPACE FOR SEGMENT	DBAREAD	AREA	segment-name.area-name (all areas in segment)
PUNCH DBTABLE	USE	DBTB	dbtable-name
PUNCH DMCL	USE	DMCL	dmcl-name
RELOAD	DBAWRITE	AREA	segment-name.area-name (all areas in load)
REORG	DBAREAD DBAWRITE	AREA	segment-name.area-name (all selected areas and areas with set connections to the records in the selected areas or indexes on the records in the selected areas)
RESTORE AREA	DBAWRITE	AREA	segment-name.area-name
RESTORE FILE	DBAWRITE	AREA	segment-name.area-name (all areas in file)
RESTORE SEGMENT	DBAWRITE	AREA	segment-name.area-name (all areas in segment)
RESTRUCTURE CONNECT	DBAWRITE	AREA	segment-name.area-name (all selected areas)
RESTRUCTURE	DBAWRITE	AREA	segment-name.area-name (all selected areas)
ROLLBACK AREA	DBAWRITE	AREA	segment-name.area-name
ROLLBACK DMCL	DBAWRITE	AREA	segment-name.area-name (affected areas in DMCL)
ROLLBACK FILE	DBAWRITE	AREA	segment-name.area-name (affected areas in file)
ROLLBACK SEGMENT	DBAWRITE	AREA	segment-name.area-name (affected areas in segment)
ROLLFORWARD AREA	DBAWRITE	AREA	segment-name.area-name
ROLLFORWARD DMCL	DBAWRITE	AREA	segment-name.area-name (affected areas in DMCL)
ROLLFORWARD FILE	DBAWRITE	AREA	segment-name.area-name (affected areas in file)
ROLLFORWARD SEGMENT	DBAWRITE	AREA	segment-name.area-name (affected areas in segment)
UNLOAD	DBAREAD	AREA	segment-name.area-name (all selected areas and areas with set connections to the records in the selected areas or indexes on the records in the selected areas)
UNLOCK AREA	DBAWRITE	AREA	segment-name.area-name
UNLOCK SEGMENT	DBAWRITE	AREA	segment-name.area-name (all areas in segment)
UPDATE STATISTICS FOR AREA	DBAREAD	AREA	segment-name.area-name
UPDATE STATISTICS FOR SCHEMA	ALTER	SCHEMA	schema-name
UPDATE STATISTICS FOR TABLE	ALTER	TABL	schema-name.table-identifier
VALIDATE	SELECT	TABL	schema-name.table-identifier (all selected tables)
IDMSDBAN	DBAREAD	AREA	segment-name.area-name
IDMSRPTS	EXECUTE	NRU	dictionary-name. IDMSNWKG.IDMSRPTS Additional privileges may be required depending on the report requested.

Note: For more information, see GRANT Physical Database Definition Privileges.