Zuordnung von Administrationsanweisungen und -kommandos

In diesem Abschnitt finden Sie eine Zuordnung aller Administrationsanweisungen (für die Administration über SESADM) zu den entsprechenden Administrationskommandos (für die Administration über INFORM-PROGRAM bzw. über ein CALL-DML-Programm).

Die Übersicht in Tabelle 20 ist nach Administrationsanweisungen sortiert. Die Übersicht in Tabelle 21 ist sortiert nach Administrationskommandos.

Administrationsanweisung im SDF-Format	Administrationskommando im ISP-Format und an der CALL-DML-Schnittstelle
ABORT-LOCK-SEQUENCE	LSQ,A[BORT]
ADD-DISTRIBUTION-RULE-ENTRY	UPD 1
ADD-OLD-TABLE-CATALOG-ENTRY	OPT,CDBC-INS
ADD-SQL-DB-CATALOG-ENTRY	OPT,DBC-INS
ASSIGN-SYSLST	SYSLST
BEGIN-LOCK-SEQUENCE	LSQ,B[EGIN]
CANCEL-STATEMENT	CANCEL
CHANGE-CATLOG	CAW
CHANGE-DALOG	DAW
CLOSE-SPACE	CLOSE,S[PACE]
COMMIT-PTC-TRANSACTION	CPTC
CREATE-DUMP	DUMP[,STOP]
CREATE-SERVICE-TASK-DUMP	DUMP,SVT
END-FOREIGN-COPY	FCOPY,E[ND]
END-LOCK-SEQUENCE	LSQ,E[ND]
HOLD-TRANSACTION-ADMISSION	HOLD-TA (bei SESDCN: HOLD,TA) WAIT,HOLD 2
HOLD-USER-ADMISSION	HOLD,USER
MODIFY-ADMINISTRATION	OPT,ADM
MODIFY-CATALOG-ACCESS-RIGHTS	OPT,ACCESS
MODIFY-CATID-LIST	UPD,C[ID-LIST]
MODIFY-DISTRIBUTION-RULE-ENTRY	UPDPRO
MODIFY-MSG-OUTPUT	OPT,MSG-OUTPUT
MODIFY-MAIL-PARAMETERS	3
MODIFY-OLD-TABLE-CATALOG-LIMIT	OPT,CDBC-LIMIT
MODIFY-RECOVER-OPTIONS	OPT,RECOVER
MODIFY-REQUEST-CONTROL	OPT,REQ-CON
MODIFY-RESTART-CONTROL	OPT,RESTART
MODIFY-RETRIEVAL-CONTROL	OPT,RET-CON
MODIFY-SECURITY	OPT,SECURITY
MODIFY-SERVICE-TASKS	OPT,SVT
MODIFY-SESSION-LOGGING-ID	OPT,LOG-ID
MODIFY-SQL-SORTLIMIT	OPT,SORTLIMIT
MODIFY-STORAGE-SIZE	OPT,STO-SIZE
MODIFY-SUBORDER-LIMIT	OPT,SUBORDERS
MODIFY-TRANSACTION-SECURITY	OPT,TA-SEC
PREPARE-FOREIGN-COPY	FCOPY,P[REPARE]
RECONFIGURE-DBH-SESSION	3
RELEASE-USER-RESOURCES	FREE FREE,USER,INACT
RELOAD-DBH-SESSION	3
REMOVE-DISTRIBUTION-RULE-ENTRY	DEL,DB DEL,PRO-NAME
REMOVE-OLD-TABLE-CATALOG-ENTRY	OPT,CDBC-DEL
REMOVE-SQL-DB-CATALOG-ENTRY	OPT,DBC-DEL
RESUME-TRANSACTION-ADMISSION	GO[-TA] (bei SESDCN: GO,TA)
RESUME-USER-ADMISSION	GO,USER
REUSE-OLD-TABLE-CATALOG-ENTRY	OPT,CDBC-REUSE
REUSE-PARTITIONS	PARTITION,REUSE
ROLLBACK-PTC-TRANSACTION	RPTC
ROLLBACK-TRANSACTION	RESET
SAVE-DBH-OPTIONS	OPT,SAVE
SET-ACCOUNTING-PARAMETER	ACC,TP
SET-DBH-MSG-TRACE	TRACE
SET-DIAGNOSIS-DUMP-PARAMETER	OPT,DIAG,diag-spec
SET-REQUEST-CONTROL	OPT,REQ-CON oder [,ON/,OFF]
SET-SAT-SUPPORT	OPT,SAT
SET-SQL-DB-CATALOG-STATUS	OPT,DBC-UPD
SET-TUNING-TRACE	COS
SET-USER-CALL-TRACE	TRACE=PAR,TYPE=CALL... TRACE={ON|OFF...}
SET-USER-INACTIVE-TIME	OPT,INACT
SET-USER-MSG-TRACE	TRACE=PAR,TYPE=MSG... TRACE={ON|OFF...}
SHOW-CALL-DML-SUBORDERS	USER
SHOW-CATALOG-USERS	USER,C[ATALOG]
SHOW-CATID-LIST	INF,C[ID-LIST]
SHOW-DBH-MEDIA-CATALOG	OPT,MEDIA
SHOW-DBH-OPTIONS	OPT
SHOW-DISTRIBUTION-RULE-ENTRIES	USER,CATALOG
SHOW-INACTIVE-SQL-USERS	USER,INACT
SHOW-OLD-TABLE-CATALOG-ENTRIES	OPT,CDBC-INFO
SHOW-MAIL-PARAMETERS	3
SHOW-PARTITIONS	PARTITION,INF
SHOW-SPACE-USERS	USER,SPACE
SHOW-SQL-DB-CATALOG-ENTRIES	OPT,DBC-INFO
SHOW-TRANSACTIONS	USER,TA
SHOW-USERS	USER,PR
SHOW-USER-SPACES	SPACE
STOP-DBH	STOP[,KEEP] STOP,DELETE
STOP-DCN	STOP

Tabelle 20: Zuordnung von Administrationsanweisungen zu -kommandos

¹nur im ISP-Format

²nur an der CALL-DML-Schnittstelle
³nicht im ISP-Format und nicht an der CALL-DML-Schnittstelle verfügbar

Administrationskommando im ISP-Format und an der CALL-DML-Schnittstelle	Administrationsanweisung im SDF-Format
ACC,TP	SET-ACCOUNTING-PARAMETER
CAW	CHANGE-CATLOG
CANCEL	CANCEL-STATEMENT
CLOSE,S[PACE]	CLOSE-SPACE
COS	SET-TUNING-TRACE
CPTC	COMMIT-PTC-TRANSACTION
DAW	CHANGE-DALOG
DEL,DB DEL,PRO-NAME	REMOVE-DISTRIBUTION-RULE-ENTRY
DUMP[,STOP]	CREATE-DUMP
DUMP,SVT	CREATE-SERVICE-TASK-DUMP
FCOPY,E[ND]	END-FOREIGN-COPY
FCOPY,P[REPARE]	PREPARE-FOREIGN-COPY
FREE FREE,USER,INACT	RELEASE-USER-RESOURCES
GO[-TA] (bei SESDCN: GO,TA)	RESUME-TRANSACTION-ADMISSION
GO,USER	RESUME-USER-ADMISSION
HOLD-TA (bei SESDCN: HOLD,TA)	HOLD-TRANSACTION-ADMISSION
HOLD,USER	HOLD-USER-ADMISSION
INF,C[ID-LIST]	SHOW-CATID-LIST
LSQ,A[BORT]	ABORT-LOCK-SEQUENCE
LSQ,B[EGIN]	BEGIN-LOCK-SEQUENCE
LSQ,E[ND]	END-LOCK-SEQUENCE
OPT	SHOW-DBH-OPTIONS
OPT,ACCESS	MODIFY-CATALOG-ACCESS-RIGHTS
OPT,ADM	MODIFY-ADMINISTRATION
OPT,CDBC-DEL	REMOVE-OLD-TABLE-CATALOG-ENTRY
OPT,CDBC-INFO	SHOW-OLD-TABLE-CATALOG-ENTRIES
OPT,CDBC-INS	ADD-OLD-TABLE-CATALOG-ENTRY
OPT,CDBC-LIMIT	MODIFY-OLD-TABLE-CATALOG-LIMIT
OPT,CDBC-REUSE	REUSE-OLD-TABLE-CATALOG-ENTRY
OPT,DBC-DEL	REMOVE-SQL-DB-CATALOG-ENTRY
OPT,DBC-INFO	SHOW-SQL-DB-CATALOG-ENTRIES
OPT,DBC-INS	ADD-SQL-DB-CATALOG-ENTRY
OPT,DBC-UPD	SET-SQL-DB-CATALOG-STATUS
OPT,DIAG,diag-spec	SET-DIAGNOSIS-DUMP-PARAMETER
OPT,INACT	SET-USER-INACTIVE-TIME
OPT,LOG-ID	MODIFY-SESSION-LOGGING-ID
OPT,MEDIA	SHOW-DBH-MEDIA-CATALOG
OPT,MSG-OUTPUT	MODIFY-MSG-OUTPUT
OPT,RECOVER	MODIFY-RECOVER-OPTIONS
OPT,REQ-CON	MODIFY-REQUEST-CONTROL
OPT,REQ-CON	SET-REQUEST-CONTROL
OPT,RESTART	MODIFY-RESTART-CONTROL
OPT,RET-CON	MODIFY-RETRIEVAL-CONTROL
OPT,SAT	SET-SAT-SUPPORT
OPT,SAVE	SAVE-DBH-OPTIONS
OPT,SECURITY	MODIFY-SECURITY
OPT,SORTLIMIT	MODIFY-SQL-SORTLIMIT
OPT,STO-SIZE	MODIFY-STORAGE-SIZE
OPT,SUBORDERS	MODIFY-SUBORDER-LIMIT
OPT,SVT	MODIFY-SERVICE-TASKS
OPT,TA-SEC	MODIFY-TRANSACTION-SECURITY
PARTITION,REUSE	REUSE-PARTITIONS
PARTITION,INF	SHOW-PARTITIONS
RESET	ROLLBACK-TRANSACTION
RPTC	ROLLBACK-PTC-TRANSACTION
SPACE	SHOW-USER-SPACES
STOP,DELETE STOP[,KEEP]	STOP-DBH
STOP	STOP-DCN
SYSLST	ASSIGN-SYSLST
TRACE=PAR,TYPE=CALL... TRACE={ON|OFF...}	SET-USER-CALL-TRACE
TRACE=PAR,TYPE=MSG... TRACE={ON|OFF...}	SET-USER-MSG-TRACE
TRACE={ON|OFF...}	SET-DBH-MSG-TRACE
UPD 1	ADD-DISTRIBUTION-RULE-ENTRY
UPD,C[ID-LIST]	MODIFY-CATID-LIST
UPDPRO	MODIFY-DISTRIBUTION-RULE-ENTRY
USER	SHOW-CALL-DML-SUBORDERS
USER,C[ATALOG]	SHOW-CATALOG-USERS
USER,CATALOG	SHOW-DISTRIBUTION-RULE-ENTRIES
USER,INACT	SHOW-INACTIVE-SQL-USERS
USER,PR	SHOW-USERS
USER,SPACE	SHOW-SPACE-USERS
USER,TA	SHOW-TRANSACTIONS
WAIT,HOLD 2	HOLD-TRANSACTION-ADMISSION
3	MODIFY-MAIL-PARAMETERS SHOW-MAIL-PARAMETERS RECONFIGURE-DBH-SESSION RELOAD-DBH-SESSION

Tabelle 21: Zuordnung von Administrationskommandos zu -anweisungen

¹nur im ISP-Format
²nur an der CALL-DML-Schnittstelle
³nicht im ISP-Format und nicht an der CALL-DML-Schnittstelle verfügbar