One more thing...
My examples assume that the HL_NAME is complete, i.e., it is in the root of
the file system. If \BIOMECHANICS is NOT in the root of the file system,
then you will need to use 'like' in both cases I described earlier, and
prefix the HL_NAME with a '%', like this:
To see all objects in ..\FATIGUE STUDY but not in subdirectories:
select * from backups where node_name='CASTSTORAGE' and hl_name like
'%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY\'
To see all objects in ..\FATIGUE STUDY and its subdirectories:
select * from backups where node_name='CASTSTORAGE' and hl_name like
'%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY\%'
- Andy
____________________________________________________________________________
Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead |
storman AT us.ibm DOT com
IBM Tivoli Storage Manager links:
Product support:
http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager
Online documentation:
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
Documentation Central/page/Tivoli Storage Manager
Product Wiki:
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
+Storage+Manager/page/Home
----- Forwarded by Andrew Raibeck/Hartford/IBM on 2013-05-07 10:30 -----
Andrew Raibeck/Hartford/IBM wrote on 2013-05-07 10:28:53:
> From: Andrew Raibeck/Hartford/IBM
> To: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>,
> Date: 2013-05-07 10:28
> Subject: Re: select question on backups table
>
> Hi Gary,
>
> If this is a Windows client, you do not need to upper-case the
> HL_NAME as long as the actual pattern you specify is in upper case.
> This is because file system backups on Windows are always stored in
> upper case.
>
> The HL_NAME specification should have a terminating backslash.
>
> If you want to see backups in subdirectories of ..\FATIGUE STUDY,
> then append a percent sign to the end of the HL_NAME specification.
> If you do not want to see the backups in subdirectories, then you
> can use '=' instead of 'like'.
>
> In sum:
>
> To see all objects in ..\FATIGUE STUDY but not in subdirectories:
>
> select * from backups where node_name='CASTSTORAGE' and hl_name =
> '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY\'
>
> To see all objects in ..\FATIGUE STUDY and its subdirectories:
>
> select * from backups where node_name='CASTSTORAGE' and hl_name like
> '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY\%'
>
> - Andy
>
>
____________________________________________________________________________
> Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead |
> storman AT us.ibm DOT com
>
> IBM Tivoli Storage Manager links:
> Product support: http://www.ibm.com/support/entry/portal/Overview/
> Software/Tivoli/Tivoli_Storage_Manager
> Online documentation: https://www.ibm.com/developerworks/
> mydeveloperworks/wikis/home/wiki/Tivoli Documentation Central/page/
> Tivoli Storage Manager
> Product Wiki: https://www.ibm.com/developerworks/mydeveloperworks/
> wikis/home/wiki/Tivoli+Storage+Manager/page/Home
>
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on
2013-05-0709:03:11:
>
> > From: "Lee, Gary" <GLEE AT BSU DOT EDU>
> > To: ADSM-L AT vm.marist DOT edu,
> > Date: 2013-05-07 09:10
> > Subject: select question on backups table
> > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
> >
> > Tsm server 5.5.4.
> >
> > Windows client 6.3.0
> > Will the following select show me all backups at and below the
> > designated subdirectory?
> >
> > select * from backups where node_name='CASTSTORAGE' AND -
> > upper(hl_NAME) like '\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY'
> >
> > If not, where have I gone wrong?
> >
|
