DSMSERV LOADFORMAT (Format a database)

Use the DSMSERV LOADFORMAT utility when upgrading from Version 5. The utility formats an empty database in preparation for inserting an extracted database into the empty database.

Syntax


>>-DSMSERV -+----------------------+---------------------------->
            |  (1)                 |   
            '------- -u--user_name-'   

                                 (2).- -k--Server1--.   
>--+-------------------------+------+---------------+----------->
   |  (1)                    |      '- -k--key_name-'   
   '------- -i--instance_dir-'                          

>--+-------------------+--+------------+--+---------+----------->
   '- -o--options_file-'  '- -noexpire-'  '- -quiet-'   

                           .-,---------.     
                           V           |     
>--LOADFORMAT--+-DBDir--=----directory-+-+---------------------->
               '-DBFile--=--file---------'   

   .-ACTIVELOGSize--=--16384-----.   
>--+-----------------------------+------------------------------>
   '-ACTIVELOGSize--=--megabytes-'   

>--ACTIVELOGDirectory--=--directory----------------------------->

>--ARCHLogdirectory--=--directory------------------------------->

>--+----------------------------------------+------------------->
   '-ARCHFailoverlogdirectory--=--directory-'   

>--+----------------------------------+------------------------><
   '-MIRRorlogdirectory--=--directory-'

Notes:

This parameter applies to AIX®, HP-UX, Linux, and Solaris servers only.
This parameter applies only to Windows servers.

Parameters

-u user_name: Specifies a user name to switch to before initializing the server. This parameter is optional.
-i instance_dir: Specifies an instance directory to use. This directory becomes the current working directory of the server. This parameter is optional.
-k key_name: Specifies the name of a Windows registry key that is used to store information about this server. Use this parameter only to install additional servers on the same system. After you install a server by using this parameter, you must always start it with the value of this parameter. The default is SERVER1.
-o options_file: Specifies an options file to use. This parameter is optional.
-noexpire: Specifies that expiration processing is suppressed when starting. This parameter is optional.
-quiet: Specifies that messages to the console are suppressed. This parameter is optional.
DBDir: Specifies the relative path names of one or more directories that are used to store database objects. Directory names must be separated by commas but without spaces. You can specify up to 128 directory names. You must specify either the DBDIR or the DBFILE parameter.
DBFile: Specifies the name of a file that contains the relative path names of one or more directories that are used to store database objects. Each directory name must be on a separate line in the file. You can specify up to 128 directory names. You must specify either the DBDIR or the DBFILE parameter.
ACTIVELOGSize: Specifies the size of the active log in megabytes. This parameter is optional. The minimum value is 2048 MB (2 GB); the maximum is 131,072 MB (128 GB). If you specify an odd number, the value is rounded up to the next even number. The default is 16384 MB.
ACTIVELOGDirectory (Required): Specifies the directory in which the Tivoli® Storage Manager server writes and stores active log files. There is only one active log location. The name must be a fully qualified directory name. The directory must exist, it must be empty, and it must be accessible by the user ID of the database manager. The maximum number of characters is 175.
ARCHLogdirectory (Required): Specifies the directory for the archive log files. The name must be a fully qualified directory name. The maximum number of characters is 175.
ARCHFailoverlogdirectory: Specifies the directory to be used as an alternative storage location if the ARCHLOGDIRECTORY directory is full. This parameter is optional. The maximum number of characters is 175.
MIRRorlogdirectory: Specifies the directory in which the server mirrors the active log (those files in the ACTIVELOGDIRECTORY directory). This parameter is optional. The directory must be a fully qualified directory name. The maximum number of characters is 175.

Example: Format a database

dsmserv loadformat dbdir=/tsmdb001 activelogsize=8192
activelogdirectory=/activelog archlogdirectory=/archlog 
archfailoverlogdirectory=/archfaillog mirrorlogdirectory=/mirrorlog

dsmserv -k server2 loadformat dbdir=d:\tsm\db001 activelogsize=8192 
activelogdirectory=e:\tsm\activelog archlogdirectory=f:\tsm\archlog 
archfailoverlogdirectory=g:\tsm\archfaillog mirrorlogdirectory=h:\tsm\mirrorlog