![]() |
![]() |
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:
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
The number of names must match the number specified by the number_of_log_files parameter. The minimum size for the log is 9MB.
For a regular file, created by the DSMFMT command, specify the file name (for example, /opt/IBMadsm-s/bin/log2.dsm). For a raw partition, specify a symbolic link to a character special file (for example, /dev/rdsk/c0t1d0s5).
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.
The files must exist before you use the command. For a regular file, created by the DSMFMT command, specify the file name (for example, /opt/IBMadsm-s/bin/db2.dsm). For a raw partition, specify a symbolic link to a character special file (for example, /dev/rdsk/c0t1d0s5).
The number of names must match the number specified by the number_of_db_files parameter. The minimum size for the database is 5MB.
For a regular file, created by the DSMFMT command, specify the file name (for example, /opt/IBMadsm-s/bin/db2.dsm). For a raw partition, specify a symbolic link to a character special file (for example, /dev/rdsk/c0t1d0s5).
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 load for two log volumes (logvol1 and logvol2) and one database volume (dbvol1):
dsmserv loadformat 2 logvol1 logvol2 1 dbvol1