DSMSERV FORMAT (Format the database and log)

Use the DSMSERV FORMAT utility to initialize the server database and recovery log. No other server activity is allowed while initializing the database and recovery log.

The directories that are specified in this utility should be on fast, reliable storage. Do not place the directories on file systems that might run out of space. If certain directories (for example, the active log directory) become unavailable or full, the server stops.

Restriction: If you are using a File Allocation Table (FAT or FAT32) file system format, you cannot specify the root directory of that system as the location of a database directory or log directory. Instead, you must create one or more subdirectories within the root directory. Then, create the database directories and log directories within the subdirectories.

Important: The installation program creates a set of registry keys. One of these keys points to the directory where a default server, named SERVER1, is created. To install an extra server, create a directory and use the DSMSERV FORMAT utility, with the -k parameter, from that directory. That directory becomes the location of the server. The registry tracks the installed servers.

When a server is initially created by using the DSMSERV FORMAT utility or the configuration wizard, a server database and recovery log are created. In addition, files are created to hold database information that is used by the database manager.

Syntax


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

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

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

               .-,---------.     
               V           |     
>--+-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 extra 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. This parameter is optional. The default is SERVER1.
Restriction: Additional instances of the Tivoli® Storage Manager server that are running on the same system will compete for resources and impact overall performance of each Tivoli Storage Manager server.
-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 format dbdir=/tsmdb001 activelogsize=8192
activelogdirectory=/activelog archlogdirectory=/archlog 
archfailoverlogdirectory=/archfaillog mirrorlogdirectory=/mirrorlog

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