IBM Tivoli Storage Manager, Version 7.1

DSMUPGRD EXTRACTDB (Extract data from a server database)

Use the DSMUPGRD EXTRACTDB utility to extract data from a server database. The data can be inserted into a version 7.1 server database either later or at the same time as the extraction process.

Prerequisite

Before using this utility, you must use the DSMUPGRD PREPAREDB utility on the existing database.

Syntax


>>-DSMUPGRD--+---------------+--+-------------------+----------->
             |  (1)          |  '- -o -options_file-'   
             '------- -quiet-'                          

    (2).- -k--Server1--.              
>------+---------------+--EXTRACTDB----------------------------->
       '- -k--key_name-'              

>--+-| A: Extract to media |------------------------+----------->
   '-| B: Extract and transmit by using a network |-'   

   .-EVentbasedused--=--Yes---.   
>--+--------------------------+--------------------------------><
   '-EVentbasedused--=--Never-'   

A: Extract to media

|--DEVclass--=--device_class_name--MANifest--=--file_name------->

   .-SCRatch--=--Yes-----.   
>--+---------------------+-------------------------------------->
   '-SCRatch--=--+-Yes-+-'   
                 '-No--'     

>--+---------------------------------------+--------------------|
   |                       .-,-----------. |   
   |  (3)                  V             | |   
   '-------VOLumenames--=----volume_name-+-'   

B: Extract and transmit by using a network

|--HLAddress--=--ip_address--LLAddress--=--tcp_port-------------|

Notes:

The option applies to AIX®, HP-UX, Linux, Solaris, and z/OS® systems.
Windows only: This option is required if the server name is not SERVER1.
You must specify VOLUMENAMES if you specify SCRATCH=NO.

Parameters

-quiet

Specifies that messages to the console are suppressed. This parameter is optional.

-o options_file

Specifies an options file to use. This parameter is optional.

-k key_name

Specifies the name of the Windows registry key from which to retrieve information about the server. The default is SERVER1. This parameter is optional.

DEVclass

Specifies a sequential device class to use for storing the extracted data. This parameter is required if you want to extract the database to media.

Restriction: You cannot use a device class with a device type of NAS or CENTERA.

Restriction: For a Tivoli® Storage Manager server running on a z/OS system, you cannot use a device class with a device type of FILE.

MANifest

Specifies the location of the manifest file. Use a fully qualified file name, or place in a local directory. For example: ./manifest.txt

This parameter is required if you want to extract the database to media.

EVentbasedused

Specifies whether event-based archive retention was ever in use on the server. Event-based archive retention supports the retention of an archived object to be based on an external event. The default value for this parameter is YES. Possible values are:

Yes: Specifies that event-based archive retention was in use on the server. The default is YES. If you are not sure whether event-based archive retention was in use, accept the default.
Overriding the default might cause archive objects to expire prematurely after the upgrade, if event-based archive retention was ever used. Using the default value ensures correct results.
Never: Specifies that event-based archive retention was never in use on the server.
Attention: Specifying EVENTBASEDUSED=NEVER might improve the performance of the upgrade operation. However, do not use this value if there is any chance that event-based archive retention was ever used on the server. If event-based archive retention was ever used on the server, specifying EVENTBASEDUSED=NEVER can result in archive files expiring prematurely after the upgrade completes.

SCRatch

Specifies whether scratch volumes can be used to store the data. This parameter is optional. The default value is YES. Possible values are:

Yes

Specifies that scratch volumes can be used.

If you specify SCRATCH=YES and also specify volumes with the VOLUMENAMES parameter, the specified volumes are used first. Scratch volumes are used only if the specified volumes do not have enough space to contain the extracted data.

If the device type for the device class is FILE, the names for the scratch volumes are generated based on a time stamp.

No

Specifies that scratch volumes cannot be used. If you specify this value, you must also specify volumes by using the VOLUMENAMES parameter.

If the volumes that you specify with the VOLUMENAMES parameter do not have enough space to contain the extracted data, the process fails.

VOLumenames

Specifies the volumes to use to store the extracted database. To specify multiple volumes, separate the names with commas and without intervening spaces.

HLAddress

Specifies either the numeric IP address or the domain name of the V7.1 server. This parameter is required if you want to extract and simultaneously transmit the data to the V7.1 server by using the network.

If the V5 server and the V7.1 server are on the same system, you can specify localhost.

LLAddress

Specifies the low-level address of the V7.1 server. This address is the same as the value that is specified with the TCPPORT server option for the V7.1 server. This parameter is required if you want to extract and simultaneously transmit the data to the V7.1 server by using the network.

Examples

Extract and transmit the data to a server by using the network:

dsmupgrd extractdb hladdress=xyz.company.com lladdress=1555

Extract and store the data on media:

dsmupgrd extractdb devclass=tapeclass manifest=keepthis.txt

Feedback