Tivoli Header

Administrator's Reference

DSMSERV LOADFORMAT (Format the Database and Log For Load)

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:

  1. 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.

  2. 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.

  1. The server must be halted.
  2. 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.
  3. 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 ]