Equivalent administration statements and commands

This section contains two tables listing all the administration statements (for administration using SESADM) and administration commands (for administration using INFORM-PROGRAM or a CALL DML program), and indicating which statements and commands are equivalent.

The table 20 contains the administration statements in alphabetical order. The table 21 has the administration commands in alphabetical order.

Administration statement in SDF format	Administration command in ISP format and at the CALL DML interface
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 (with 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 (at 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 or [,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

Table 20: List of equivalent administration statements and commands

¹only in ISP format

²only on the CALL-DML interface
³not available in ISP format and not available on the CALL-DML interface

Administration command in ISP format and at the CALL DML interface	Administration statement in 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-SERVCIE-TASK-DUMP
FCOPY,E[ND]	END-FOREIGN-COPY
FCOPY,P[REPARE]	PREPARE-FOREIGN-COPY
FREE FREE,USER,INACT	RELEASE-USER-RESOURCES
GO-TA (at SESDCN: GO,TA)	RESUME-TRANSACTION-ADMISSION
GO,USER	RESUME-USER-ADMISSION
HOLD-TA (with 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

Table 21: List of equivalent administration commands and statements

¹only in ISP format
²only on the CALL-DML interface
³not available in ISP format and not available on the CALL-DML interface