Query command

Edit online

Use this command to query the IBM® Storage Protect server for information about objects that are backed up. You can obtain information such as whether an object is compressed, encrypted, or deduplicated by the client during a backup operation.

The query command uses the options that are set in the -TDPO_OPTFILE parameter, the tdpo.opt file in the default installation directory, or the default values set by Data Protection for Oracle to query the IBM Storage Protect server.

When you issue the tdposync query command, you are prompted to enter date range for the query. The screen output displays information about the objects that were backed up to the IBM Storage Protect server between the start and end dates that you specified.

Syntax

Optional parameters

-TDPO_OPTFILE =pathname: This parameter specifies the fully qualified path name to the tdpo.opt file. This file is the options file that is used by the utilities and the Data Protection for Oracle library. The file contains the information for the IBM Storage Protect server and the server address that tdposync command must use for synchronizing.
When you specify the query TDPO_OPTFILE command, you must specify the same options file values that were used for the original backup operations. If you do not specify the TDPO_OPTFILE path, the default value in the default Oracle installation path (/Program Files/Tivoli/TSM/AgentOBA64/tdpo.opt) is used.

Description of the output fields

Name

Object name on the IBM Storage Protect server; for instance, /fs/hl/ll.

Owner

The name of the user who backed up the object.

The Owner field is empty if the user is root.

Size

The size of the object size on the IBM Storage Protect server.

Creation Date / Time

The date and time the object was backed up.

Compressed

Lists whether an object was compressed during the backup operation.

Encryption Type

Lists the type of encryption that was used during the backup operation. The possible values are as follows:

None: The object was not encrypted.
AES-128: The object was encrypted by using AES-128 encryption.
AES-256: The object was encrypted by using AES-256 encryption.

Client-deduplicated

Lists whether an object underwent client-side data deduplication.

Examples

Use the tdposync query command to find information about backed up objects, encryption type and data deduplication.

Query the IBM Storage Protect server for information about objects that are backed up

The command to be run is tdposync query.

The following output is displayed:

IBM  Protect for Databases:
Data Protection for Oracle
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1997, 2014. All rights reserved.

From Date (01/01/2016):

To Date (07/02/2016):

Backup Object Information
-------------------------

Name ............................... /adsmorc//df_722435657_35_1
Owner...............................
Size ............................... 2,010 KB
Creation Date / Time ............... 07/02/2013 10:08:20
Compressed ......................... Yes
Encryption Type .................... None
Client-deduplicated ................ No

Backup Object Information
-------------------------

...

IBM  Protect for Databases:
Data Protection for Oracle
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1997, 2016. All rights reserved.

From Date (01/01/2016):

To Date (07/02/2016):

Backup Object Information
-------------------------

Name ............................... \adsmorc\orcnt\df_722435657_35_1
Owner...............................
Size ............................... 2,010 KB
Creation Date / Time ............... 07/02/2014 10:08:20
Compressed ......................... Yes
Encryption Type .................... None
Client-deduplicated ................ No

Backup Object Information
-------------------------

...

Finding the encryption type

When you issue the tdposync query command, the entire list of backup object information is printed to the command prompt window without page separators, scrolling, or canceling capability. Redirect the output of the query to a file and find out the encryption type that was used for the backups from the previous week.

Command: echo -e <from date>\n<to date>\n | tdposync query > out.txt where the from and to dates specify last week's date range.

Command: echo from_date > in.txt & echo to_date >> in.txt & tdposync query < in.txt > out.txt

Open the file out.txt with a text editor and search for Encryption Type to determine the type of encryption that was used.

Finding data deduplication information

Determine the data deduplication reduction for a particular node by querying the IBM Storage Protect™ server activity log for the ANU2526I message.