Modifies certain database characteristics. MUPIP SET operates on either regions or files.
![[Note]](images/note.jpg) | |
In regions that have journaling enabled and on, users can switch journal files without either requiring standalone access or freezing updates. |
The format of the SET command is:
SE[T] -FILE | -REGION [ -A[CCESS_METHOD=BG|MM]] -B[YPASS] -DB[FILENAME]=database_file -DE[FER_TIME]=seconds -E[XTENSION_COUNT]=integer(no of blocks) -FI[LE] -F[LUSH_TIME]= integer -G[LOBAL_BUFFERS]=<integer> -JN[LFILE] -JO[URNAL]=journal-option-list -L[OCK_SPACE]=integer -PA[RTIAL_RECOV_BYPASS] -PR[EVJNLFILE]=jnl_file_name -REG[ION] -REP[LICATION]=ON|OFF -REPL_STATE=ON|OFF -RES[ERVED_BYTES]=integer -S[TANDALONENOT] -V[ERSION]=V4|V5 -W[AIT_DISK]=integer ] filename | region-list
The file-name (or region-list) identifies the target of the SET.
The SET command must include one of the following qualifiers which determine whether the argument to the SET is a file-name or a region-list.
Exclusive access to the database is required if the MUPIP SET command specifies -ACCESS_METHOD, -GLOBAL_BUFFERS, LOCK_SPACE or -NOJOURNAL, or if any of the -JOURNAL options ENABLE, DISABLE, or BUFFER_SIZE are specified.
The following section describe the qualifiers of the MUPIP SET command.