Tivoli Header
Administrator's Reference
Use this command to format the database and recovery log for a subsequent
DSMSERV LOADDB or DSMSERV RESTORE DB. When you use this command, any
data that exists in the files you specify is lost.
You must run a DSMSERV LOADFORMAT before you run a DSMSERV LOADDB.
After you run a DSMSERV LOADFORMAT, you must run a DSMSERV LOADDB or DSMSERV
RESTORE DB before the server will start.
Notes:
- If a DSMSERV LOADFORMAT was run, and a DSMSERV LOADDB cannot be run, you
can restore the database to a point in time with a DSMSERV RESTORE DB.
See DSMSERV RESTORE DB (Restore the Database) for additional information.
- When a database is loaded or restored, the server-to-server communication
verification token is changed. The verification token is an attribute
of the database and is not stored in the database itself. Part of the
token is the install date and time for the database. For servers that
have been defined for server-to-server communications, you must issue an
UPDATE SERVER command with FORCESYNC=YES.
Syntax
>>-DSMSERV LOADFORMAT--number_of_log_files---------------------->
.---------------.
V |
>--+---log_file_name-+--+--number_of_db_files------------------->
'-file:log_file_name-'
.--------------.
V |
>--+---db_file_name-+--+---------------------------------------><
'-file:db_file_name-'
Parameters
- number_of_log_files (Required)
- Specifies the number of recovery log files.
- log_file_name
- Specifies one or more recovery log file names. The files must exist
before you issue this command. If the files do not exist, you must
allocate and format the files by using the ANRFMT job or the ANRFMT2 job found
in the ASAMPLIB dataset. For information on using these jobs, see
Administrator's Guide. It is recommended that a DSMSERV
LOADDB should not use the original database and log files.
The number of names must match the number specified by the
number_of_log_files parameter. The minimum size for the log is
9MB.
- file:log_file_name
- Specifies the name of a file that contains a list of recovery log
volumes.
It is recommended that you specify a fully-qualified name enclosed in
single quotes so that you will not be affected by data set name qualification
rules that depend on your operating environment.
The number of names must match the number specified by the
number_of_log_files parameter. You must list the volumes in
the order in which they are to be used. The minimum size for the log is
9MB.
- number_of_db_files (Required)
- Specifies the number of database files.
- db_file_name
- Specifies one or more database file names. The files must exist
before you issue the command. If the files do not exist, you must
allocate and format the files by using the ANRFMT job or the ANRFMT2 job found
in the ASAMPLIB dataset. For information on using these jobs, see
Administrator's Guide. It is recommended that a DSMSERV
LOADDB should not use the original database and log files.
The number of names must match the number specified by the
number_of_db_files parameter. The minimum size for the
database is 5MB.
- file:db_file_name
- Specifies the name of a file that contains a list of database
volumes.
The number of names must match the number specified by the
number_of_db_files parameter. You must list the volumes in the
order they are to be used. The minimum size for the database is
5MB.
Examples
Task
Format the database and recovery log for preparation of a subsequent
DSMSERV LOADDB.
- The server must be halted.
- Use the ANRFMT job or the ANRFMT2 job found in the ASAMPLIB dataset to
allocate and format the files to be used for the database and recovery
log.
- Start the DSMSERV LOADFORMAT utility.
Sample JCL:
//LOADFMT JOB ,
// REGION=256M,TIME=1440,CLASS=A,MSGCLASS=H
//DFDSM EXEC PGM=ANRSERV,DYNAMNBR=300,
// PARM='/LOADFORMAT 1 TIVSMSRV.RLOG 1 TIVSMSRV.DB01'
//OPT DD DSN=TIVSMSRV.OPTIONS,DISP=SHR
//DSMAMENG DD DSN=TIVSMSRV.AMENGT3,DISP=SHR
//DSK DD DSN=TIVSMSRV.DISKLOG,DISP=OLD
//ERR DD DSN=TIVSMSRV.ERRORLOG,DISP=OLD
//SYSPRINT DD SYSOUT=*
//SYSTERM DD SYSOUT=*
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]