Optional parameters follow the query FCM command
and positional parameters.
- /ACtive
- Use
the /active parameter to display active backup
objects only. This parameter is the default.
- /ALl
- Use
the /all parameter to display both active and
inactive backup objects. If the /all parameter
is not specified, only active backup objects are displayed.
- /CONFIGfile=configfilename
- The /configfile parameter
specifies the name of the Tivoli Storage FlashCopy Manager for SQL configuration
file, which contains the values for the Tivoli Storage FlashCopy Manager configurable
options. See Set command for details
on the content of the file.
Considerations:
- The configfilename variable can include a fully
qualified path. If configfilename does not include
a path, it uses the directory where Tivoli Storage FlashCopy Manager for SQL is
installed.
- If configfilename includes spaces, enclose
it in double quotation marks.
- If you do not specify /configfile, the default
value is tdpsql.cfg.
- If you specify /configfile but not configfilename,
the default value tdpsql.cfg is used.
- /FCMOPTFile=dsmoptfilename
- The /fcmoptfile parameter
specifies the Tivoli Storage FlashCopy Manager options
file to use.
Considerations:
- The dsmoptfilename variable can include a fully
qualified path. If you do not include a path, the Tivoli Storage FlashCopy Manager installation
directory is used.
- If the dsmoptfilename variable spaces, enclose
it in double quotation marks.
- If you do not specify /fcmoptfile, the default
value is dsm.opt.
- If you specify /fcmoptfile but not dsmoptfilename,
the default is also dsm.opt.
- /FROMSQLSERVer=sqlservername
- For query
FCM, the /fromsqlserver parameter specifies
the SQL server that backup objects were backed up from. This parameter
is necessary only when the name of the SQL server to query, as determined
by the /sqlserver parameter, is different from
the name of the SQL server that the backup objects were created from.
The default value is the /sqlserver value or
the value that is set in the Tivoli Storage FlashCopy Manager for SQL configuration
file.
Considerations:
- If the two SQL server names are different, you must use this parameter
even if /fromsqlserver was a non-clustered default
instance.
- After you restore a SQL database to a different SQL server, the
logins of the SQL database might not match the logins for the different
SQL server. If appropriate, you can use the SQL stored procedure SP_CHANGE_USERS_LOGIN
to find and correct such SQL login mismatches.
- /LOGFile=logfilename
- Use the /logfile parameter
to specify the name of the activity log file that is generated by Tivoli Storage FlashCopy Manager for SQL.
The logfilename variable
identifies the name of the activity log file.
If the specified
log file does not exist, a new log file is created. If the specified
log file exists, new log entries are appended to the file. The logfilename variable
can include a fully qualified path. However, if no path is specified,
the log file is written to the Tivoli Storage FlashCopy Manager for SQL installation
directory.
If the
logfilename variable includes
spaces, enclose the entire
/logfile parameter
entry in double quotation marks For example:
/LOGFile="c:\Program Files\mytdpsql.log"
You
cannot turn Tivoli Storage FlashCopy Manager for SQL logging
activity off. If you do not specify /logfile,
log records are written to the default log file. The default log file
is tdpsql.log.
Attention: When you use multiple simultaneous
instances of Tivoli Storage FlashCopy Manager for SQL to
run operations, use the /logfile parameter to
specify a different log file for each instance used. This function
directs logging for each instance to a different log file and prevents
interspersed log file records. Failure to specify a different log
file for each instance can result in unreadable log files.
- /LOGPrune=numdays | No
- Use
the /logprune parameter to disable log pruning
or to explicitly request that the log is to be pruned for one command
run. By default, log pruning is enabled and done one time per day.
The numdays variable represents the number of days
to save log entries. By default, 60 days of log entries
are saved in the pruning process. You can use the Tivoli Storage FlashCopy Manager for SQL GUI
or the set command to change the defaults so that
log pruning is disabled, or so that more or less days of log entries
are saved. If you use the command line, you can use the /logprune parameter
to override these defaults. When the value of the /logprune variable numdays is
a number in the range 0 - 9999, the log is pruned even if log pruning
is already done for the day.
If you specify no,
the log file is not pruned during this command.
Changes
to the value of the
timeformat or
dateformat parameter
can result in pruning the log file unintentionally. If the value of
the
timeformat or
dateformat parameter
is changed, before you issue a
Tivoli Storage FlashCopy Manager for SQL command
that might prune the log file, do one of the following actions to
prevent the log file from being pruned:
- Make a copy of the existing log file.
- Specify a new log file with the /logfile parameter
or logfile setting.
- /OBJect=* | objectname,...
- For restore and inactivate operations, /object specifies
that only particular backup objects for the specified SQL databases
and backup object type (if specified) be restored or deactivated.
For query operations, /object includes
particular objects and object types in the display. The objectname variable
specifies the names of the backup objects you want to restore or deactivate.
The object name uniquely identifies each backup object and is created
by Tivoli Storage FlashCopy Manager.
Use query to view the names of backup objects.
You can use * as a wildcard character in objectname to
replace zero or more characters for each occurrence. Specifying only
the wildcard character indicates all backup objects of the specified
SQL databases and backup object type.
- /QUERYNode=DP | ALWAYSON | BOTH
- Specify whether you want to query standard databases from SQL
Server 2012 that were backed up from a standard Data Protection for SQL Server node,
the AlwaysOn node, or both nodes. This parameter is ignored for availability
databases because the availability databases are always backed up
under the AlwaysOn node.
- /REMOTECOMPUTER=computername
- Enter the IP address or host name for the remote system where
you want to query the data that is backed up.
- /REMOTECOMPUTERUser=user
- Enter the user name that is used to log on to the server specified
with the REMOTECOMPUTER parameter. If a domain
is required to log on with the domain account, enter Domain\User.
To log on to the local account, the domain is not required. There
is no default value.
- /REMOTECOMPUTERPassword=passwd
- Enter the password for the user name that is specified with the REMOTECOMPUTERUser parameter.
There is no default value.