DSMSERV LOADFORMAT (Format a database)

Edit online

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

Read syntax diagramSkip visual syntax diagram DSMSERV 1-uuser_name1-iinstance_dir-kServer12-kkey_name-ooptions_file-noexpire-quiet LOADFORMAT DBDir=,directoryDBFile=fileACTIVELOGSize=16384ACTIVELOGSize=megabytes ACTIVELOGDirectory = directory ARCHLogdirectory = directory ARCHFailoverlogdirectory=directoryMIRRorlogdirectory=directory
Notes:
  • 1 This parameter applies to AIX® and Linux® servers only.
  • 2 This parameter applies only to Windows servers.

Parameters

Linux operating systemsAIX operating systems-u user_name
Linux operating systemsAIX operating systemsSpecifies a user name to switch to before initializing the server. This parameter is optional.
Linux operating systemsAIX operating systems-i instance_dir
Linux operating systemsAIX operating systemsSpecifies an instance directory to use. This directory becomes the current working directory of the server. This parameter is optional.
Windows operating systems-k key_name
Windows operating systemsSpecifies 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 the server starts. 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.
Tip: If you specify multiple directories, ensure that the underlying file systems are of equal size to ensure a consistent degree of parallelism for database operations. If one or more directories for the database are smaller than the others, they reduce the potential for optimized parallel prefetching and distribution of the database.
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 file in megabytes. This parameter is optional. The minimum value is 2048 MB (2 GB); the maximum is 524,288 MB (512 GB). If an odd number is specified, the value is rounded up to the next even number. The default is 16384 MB.
The size of an active log file is based on the value of the ACTIVELOGSIZE option. Guidelines for space requirements are in the following table:
Table 1. How to estimate volume and file space requirements
ACTIVELOGSize option value Reserve this much free space in the active log directory, in addition to the ACTIVELOGSize space
16 GB - 128 GB 5120 MB
129 GB - 256 GB 10240 MB
257 GB - 512 GB 20480 MB
ACTIVELOGDirectory (Required)
Specifies the directory in which the 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

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

Windows operating systems
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