Andrew Thanks, Since I am beginner at using scripts, I was trying to find another way to display diskbackuppool volumes only using a sql "select" statement" as oppose to the query volume command.
Regards, Tim Andrew Raibeck wrote: > I don't understand the question in relationship to the script. > > As far as displaying volumes only in diskbackuppool: from the Admin > command line interface, issue HELP QUERY VOLUME and you should find that > information there. > > Regards, > > Andy > > Andy Raibeck > IBM Software Group > Tivoli Storage Manager Client Development > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] > Internet e-mail: [EMAIL PROTECTED] > > IBM Tivoli Storage Manager support web page: > http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html > > The only dumb question is the one that goes unasked. > The command line is your friend. > "Good enough" is the enemy of excellence. > > "ADSM: Dist Stor Manager" <[email protected]> wrote on 06/15/2006 > 08:33:05: > > > Hello all, > > > > I have a script/query question the query below > > lists all the devclass=disk. How would I modify this in > > a script to display the Backuppool disk's only using a > > script? Right now I am just running the Query command > > via the Admin Schedule. > > > > Thanks in advance! > > > > query volume devclass=disk > > > > > > /dev/rstg024r BACKUPPOOL DISK 21,056.0 0.0 > > On-Line > > /dev/rstg025r BACKUPPOOL DISK 21,056.0 0.0 > > On-Line > > /dev/rstg026r BACKUPPOOL DISK 21,056.0 0.0 > > On-Line > > /dev/rstg027r BACKUPPOOL DISK 21,056.0 0.0 > > On-Line > > /mig0/mig0.dsm SPACEMGPOOL DISK 13,000.0 53.9 On-Line > > /mig1/mig1.dsm SPACEMGPOOL DISK 13,000.0 52.1 On-Line > > /stg3/stg30.dsm ARCHIVEPOOL DISK 6,800.0 0.0 > > On-Line > > /stg3/stg31.dsm ARCHIVEPOOL DISK 6,800.0 0.0 > > On-Line > > /stg3/stg32.dsm ARCHIVEPOOL DISK 6,800.0 0.0 > > On-Line > > > > TSM 5.3.3 > > AIX 5.3
