Re: query auditocc question

2016-08-10 Thread Paul_Dudley
To all,

It appears that I have solved this problem. The issue was that the "expire 
inventory" command was not running to completion.
It was being run with a duration parameter which did not allow it to complete 
the expire inventory of all nodes.

Thanks & Regards
Paul



-Original Message-
From: Paul_Dudley [mailto:pdud...@anl.com.au]
Sent: Thursday, 28 July 2016 10:11 AM
To: 'ADSM: Dist Stor Manager'
Subject: RE: query auditocc question

Thanks. I ran this command and it ran successfully and provided me with a list 
of totals.
However they are a lot higher than what is reported by my query auditocc 
command.
Does it total just the primary storage or all storage pools?

I am just interested in primary storage to keep track of storage used as we 
have the unified terabyte licensing for TSM.

Thanks & Regards
Paul



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David 
Ehresman
Sent: Wednesday, 27 July 2016 11:13 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] query auditocc question

Perhaps the following query would give you better data:

select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy group by 
node_name


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Paul_Dudley
Sent: Tuesday, July 26, 2016 9:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] query auditocc question

To keep track of our primary storage usage, on a weekly basis I run the 
following command:



query auditocc pooltype=primary



For one of the nodes - an SQL server - it is reporting that the backup storage 
used is 7Tb.

However knowing the size of the databases on that server and the number of 
copies of each backup we keep, I believe that to be incorrect.

I started the DP for SQL client on that server, clicked on Restore Data, and 
then selected all backups (both active and inactive).

I then added up the size of each backup (both active and inactive) and it added 
up to 2.2Tb.



How could there be such a huge difference between each total?





Thanks & Regards

Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add ressees. Any unauthorised dissemination or use is strictly 
prohibited. If you received this e-mail in error, please immediately notify the 
sender by return e-mail from your s ystem. Please do not copy, use or make 
reference to it for any purpose, or disclose its  contents to any person.
--
Message  protected by MailGuard: e-mail anti-virus, anti-spam and content 
filtering.
http://www.mailguard.com.au

Click here to report this message as spam:
https://console.mailguard.com.au/ras/1OVoBqtOtJ/3vhxB9XK9tUP8GWQIH6joI/0.022







ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add
ressees. Any unauthorised dissemination or use is strictly prohibited. If you 
received
this e-mail in error, please immediately notify the sender by return e-mail 
from your s
ystem. Please do not copy, use or make reference to it for any purpose, or 
disclose its
 contents to any person.


Re: Backup VE via Resource Pool

2016-08-10 Thread Robert Ouzen
Hello Marcel and Bas

Thank you for the information

I  will try with the option VMFOLDER=, 

It's a possibility to do it in command line for testing (before adding it at 
dsm.opt)

BACKUP VM ..

 I did not find the correct syntax ?

T.I.A Regards

Robert


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Marcel 
Anthonijsz
Sent: Wednesday, August 10, 2016 3:31 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Backup VE via Resource Pool

Hi Robert,

There is no option (yet) to directly backup a VMware Resource Pool. If you have 
a look at the dsmc backup command, there are following options for VMware 
backup:
Ref:
https://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.3/client/r_cmd_bkupvm.html
and :
https://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.3/client/r_opt_domainvmfull.html

The domain level parameters are:
all-vm
all-windows
vmhost
vmfolder
vmhostcluster
vmdatastore

No vmresourcepool option here :-(. You could create an RFE for that.

I manage a lot of backups using the VMFOLDER option, i.e. move a VM into a 
dedicated VMware folder and it gets backupped by that datamover.
A workaround that we have discussed in last Dutch Spectrum Protect User group 
is to create a script to list the VMs and create a backup script from that list.
This requires scheduled (manual or automated) regeneration of the scripts, so I 
opted for the VMFOLDER option as this is easy manageable, also by the VMware 
administrators. We have found out that nested VMfolders also work, so you can 
have multiple folders with the same name in your folder structure, the TDP for 
VE picks up all those VMs in the folders.




2016-08-10 3:40 GMT+02:00 Robert Ouzen :

> Hello to all
>
> We decided to back up our VMware environment with TSM VE 7.1.6 via
> Resource Pool   !
>
> Did you have example what line I need to add in  adequate dsm.opt  to 
> configure Resource Pool backup???
>
> T.I.A .Best Regards
>
> Robert
>



--
Kind Regards, Groetje,

Marcel Anthonijsz
T: +31(0)299-776768
M:+31(0)6-53421341


Re: Backup VE via Resource Pool

2016-08-10 Thread Marcel Anthonijsz
Hi Robert,

There is no option (yet) to directly backup a VMware Resource Pool. If you
have a look at the dsmc backup command, there are following options for
VMware backup:
Ref:
https://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.3/client/r_cmd_bkupvm.html
and :
https://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.3/client/r_opt_domainvmfull.html

The domain level parameters are:
all-vm
all-windows
vmhost
vmfolder
vmhostcluster
vmdatastore

No vmresourcepool option here :-(. You could create an RFE for that.

I manage a lot of backups using the VMFOLDER option, i.e. move a VM into a
dedicated VMware folder and it gets backupped by that datamover.
A workaround that we have discussed in last Dutch Spectrum Protect User
group is to create a script to list the VMs and create a backup script from
that list.
This requires scheduled (manual or automated) regeneration of the scripts,
so I opted for the VMFOLDER option as this is easy manageable, also by the
VMware administrators. We have found out that nested VMfolders also work,
so you can have multiple folders with the same name in your folder
structure, the TDP for VE picks up all those VMs in the folders.




2016-08-10 3:40 GMT+02:00 Robert Ouzen :

> Hello to all
>
> We decided to back up our VMware environment with TSM VE 7.1.6 via
> Resource Pool   !
>
> Did you have example what line I need to add in  adequate dsm.opt  to
> configure Resource Pool backup???
>
> T.I.A .Best Regards
>
> Robert
>



--
Kind Regards, Groetje,

Marcel Anthonijsz
T: +31(0)299-776768
M:+31(0)6-53421341


Re: Backup VE via Resource Pool

2016-08-10 Thread Bas van Kampen
Robert,

I think this isn't possible with TSMVE (at least not with version 7.1.4). I've 
build a custom (python) script to do this. Which is working with some caveats. 

Met vriendelijke groet,

Bas van Kampen
Lead Engineer
Interconnect
Cloud, Connectivity, Datacenter & Hosted Telecom
Interconnect Services B.V. | 073 - 88 000 00
De Steenbok 1 | 5215 MG  | 's-Hertogenbosch | KvK 50100572
Park Forum  1041 | 5657 HJ | Eindhoven | bedrijfsnummer 6020



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Robert 
Ouzen
Sent: woensdag 10 augustus 2016 03:41
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Backup VE via Resource Pool

Hello to all

We decided to back up our VMware environment with TSM VE 7.1.6 via Resource 
Pool   !

Did you have example what line I need to add in  adequate dsm.opt  to configure 
Resource Pool backup???

T.I.A .Best Regards

Robert