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
Single 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
Parameters
There are no parameters for this option.
Examples
- Command line:
dsmc q ba '/usr/fs1/*' -sub=yes -querysummary
[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] $ - Command line:
dsmc query backup k:\.* -subdir=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: 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