how to view what data's are there inside a filespace ?

[pharthiphan]

how to view what data's are there inside a filespace ?



tsm: IITMTSM10>q file IITMTSM10LB0 /iitm2

Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct
Name Type pace Util
Unicode?
--------------- ----------- ---- -------- --------- --------- ----------- -----
IITMTSM10LB0 /iitm2 3 Linux GPFS No 960 TB 55.4
x86-64

tsm: IITMTSM10>

 

[marclant]

Easiest way is on the node itself:

dsmc query backup {filespacename}/* -su=yes -inactive

So in your case:

dsmc query backup {/iitm2}/* -su=yes -inactive

The "-inactive" is optional, depends if you want to see only active or both active and inactive versions.

On the server, the ouput is much uglier:

select * from backups where node_name='IITMTSM10LB0' and filespace_name='/iitm2'

 

[pharthiphan]

all 3 commands resulted in error:-

tsm: IITMTSM10>select * from backups where node_name='IITMTSM10LB0' and filespace_name='/iitm2'
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

[root@iitmtsm10 ~]# dsmc query backup {/iitm2}/* -su=yes -inactive
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.0
Client date/time: 03/26/2015 17:21:22
(c) Copyright by IBM Corporation and other(s) 1990, 2013. All Rights Reserved.

Node Name: IITMTSM10LB0
Session established with server IITMTSM10: Linux/x86_64
Server Version 7, Release 1, Level 0.0
Server date/time: 03/26/2015 17:21:22 Last access: 03/26/2015 16:26:18

ANS1092W No files matching search criteria were found
[root@iitmtsm10 ~]#

[root@iitmtsm10 ~]# dsmc query arch {/iitm2}/* -su=yes
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.0
Client date/time: 03/26/2015 17:21:38
(c) Copyright by IBM Corporation and other(s) 1990, 2013. All Rights Reserved.

Node Name: IITMTSM10LB0
Session established with server IITMTSM10: Linux/x86_64
Server Version 7, Release 1, Level 0.0
Server date/time: 03/26/2015 17:21:39 Last access: 03/26/2015 17:21:23

ANS1092W No files matching search criteria were found

 

[marclant]

Actually, they were no errors, just matching files. Are you sending backups or archives to that filespace? If the latter, then the commands I gave you would be no good. You'd need to replace "backup" with "archive" on query for the client. And "backups" with "archives" on the select for the server.

Check the occupancy to see if there are any files backed up or archived for that filespace:

q occ IITMTSM10LB0 /iitm2

 

[pharthiphan]

No match found using this criteria.


tsm: IITMTSM10>q occ IITMTSM10LB0 /iitm2
ANR2034E QUERY OCCUPANCY: No match found using this criteria.
ANS8001I Return code 11.

 

[marclant]

So, there is no backup or archive data in that filespace, which explains why the previous queries all said no match found.

For the filespace to exist, it means something was backed up at some point, but the data either expired or was deleted because it is empty now.