Querysummary

The querysummary option provides statistics about files, directories and objects that are returned by the query backup or query archive commands.

The following statistics are provided by the querysummary option:
  • The aggregate number of files and directories that are returned by the query backup or query archive command
  • The aggregate amount of data of the objects that are returned by the query backup or query archive command
  • The classic restore memory-utilization estimate to restore objects that are returned by the query backup or query archive command
  • The total number of unique server volumes where the objects that are returned by the query command reside

Windows operating systemsSingle objects that span multiple volumes only include one volume in the total number of volumes statistics. For example, if c:\bigfile spans two volumes, only one of the volumes is counted in the estimated number of volumes.

Supported Clients

This option is valid for all clients. The IBM Spectrum® Protect API does not support this option.

Syntax

Read syntax diagramSkip visual syntax diagramQUERYSUMMARY

Parameters

There are no parameters for this option.

Examples

Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systems
Command line:
Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsdsmc q ba '/usr/fs1/*' -sub=yes -querysummary
Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systems
[root@kaveri:/home/cpark] $ dsmc q ba '/kalafs1/*' -sub=yes -querysummary
IBM Spectrum Protect
Command Line Backup-Archive Client Interface
  Client Version 8, Release 1, Level 0.0
  Client date/time: 12/09/2016 12:05:35
(c) Copyright by IBM Corporation and other(s) 1990, 2016. All Rights Reserved.

Node Name: KAVERI
Session established with server TEMPLAR: AIX-RS/6000
  Server Version 8, Release 1, Level 0.0
  Server date/time: 12/09/2016   12:05:35  Last access: 12/07/2016   07:48:59

      Size     Backup Date           Mgmt Class      A/I File
      ----     -----------           ----------      --- ----
     4,096  B  08/07/08   12:07:30       BASVT2       A  /kalafs1/
       256  B  08/07/08   12:07:30       BASVT2       A  /kalafs1/dir1
10,485,760  B  08/07/08   12:07:30      DEFAULT       A  /kalafs1/info1
 5,242,880  B  08/07/08   12:07:30      DEFAULT       A  /kalafs1/info2
     1,044  B  08/07/08   12:07:30      DEFAULT       A  /kalafs1/dir1/subfile1
     1,044  B  08/07/08   12:07:30      DEFAULT       A  /kalafs1/dir1/subfile2


Summary Statistics

Total Files Total Dirs  Avg. File Size Total Data  Memory Est.
----------- ----------  -------------- ----------  ----------
         4           2     3.75 MB      15.00 MB     1.07 KB


Estimated Number of Volumes: 2

[root@kaveri:/home/cpark] $ 
Windows operating systems
Command line:
Windows operating systemsdsmc query backup k:\.* -subdir=yes -QUERYSUMMARY
Windows operating systems
IBM Spectrum Protect
Command Line Backup-Archive Client Interface
  Client Version 8, Release 1, Level 0.0
  Client date/time: 12/09/2016 12:05:35
(c) Copyright by IBM Corporation and other(s) 1990, 2016. All Rights Reserved.

Node Name: BARKENSTEIN
Session established with server BARKENSTEIN_SERVER1: Windows
  Server Version 8, Release 1, Level 0.0
  Server date/time: 12/09/2016 12:05:35  Last access: 12/08/2016 05:46:09

Size        Backup Date            Mgmt Class    A/I File
----        -----------            ----------    --- ----
0  B        04/02/2008 20:21:51    STANDARD      A  \\barkenstein\k$\
0  B        04/02/2008 20:21:51    STANDARD      A  \\barkenstein\k$\jack_test
0  B        04/01/2008 12:37:07    STANDARD      A  \\barkenstein\k$\
                                                      System Volume Information
0  B        04/01/2008 12:37:07    STANDARD      A  \\barkenstein\k$\Test1
0  B        04/02/2008 20:21:51    STANDARD      A  \\barkenstein\k$\TestTree
0  B        04/01/2008 12:37:07    STANDARD      A  \\barkenstein\k$\Tree150
0  B        04/02/2008 19:49:20    STANDARD      A  \\barkenstein\k$\Tree150.1
0  B        04/01/2008 12:37:07    STANDARD      A  \\barkenstein\k$\Tree150.2
0  B        04/02/2008 19:50:51    STANDARD      A  \\barkenstein\k$\Tree150.3
0  B        04/01/2008 12:37:07    STANDARD      A  \\barkenstein\k$\Tree1500
0  B        04/02/2008 10:41:40    STANDARD      A  \\barkenstein\k$\Tree150_2
0  B        04/02/2008 20:02:31    STANDARD      A  \\barkenstein\k$\tree18
0  B        04/02/2008 20:15:04    STANDARD      A  \\barkenstein\k$\Tree18.test
0  B        04/01/2008 12:37:07    STANDARD      A  \\barkenstein\k$\Tree30
0  B        04/01/2008 12:37:07    STANDARD      A  \\barkenstein\k$\Tree30.2
0  B        04/02/2008 19:52:30    STANDARD      A  \\barkenstein\k$\tree30.test
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file1
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file10
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file11
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file12
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file13
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file14
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file15
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file16
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file17
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file18
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file19
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file2
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file20
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file21
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file3
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file4
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file5
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file6
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file7
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file8
11,788  B   04/02/2008 19:55:32    DEFAULT       A  \\barkenstein\k$\file9
11,788  B   04/02/2008 13:31:06    DEFAULT       A  \\barkenstein\k$\file910
10,964  B   04/01/2008 12:37:07    DEFAULT       A  \\barkenstein\k$\filea
10,964  B   04/01/2008 12:37:07    DEFAULT       A  \\barkenstein\k$\fileb
10,964  B   04/01/2008 12:37:07    DEFAULT       A  \\barkenstein\k$\x


Summary Statistics

 Total Files   Total Dirs   Avg. File Size       Total Data      Memory Est.
 -----------   ----------   --------------       ----------      -----------
 25            16           11.41 KB             285.37 KB       10.58 KB

Estimated Number of Volumes: 2