Re: Issue restoring SQL database via TDP

[Paul_Dudley]

Hi Andy,

In the Windows client GUI there is no replace option. I selected the Restore to 
Alternate location option.
Under that are the options:

Restore to original database
Restore to new database (select Instance and enter the database name)

Restore to original location
Restore files to all one directory (then you can browse and select the location 
to restore to)
Relocate files individually (you can then edit the logical name, path & file 
name if you want)

I chose to restore to a new database and relocate the files individually (and 
modify the file name to restore over)


Thanks & Regards
Paul


-Original 
Message---
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew 
Raibeck
Sent: Wednesday, 1 November 2017 10:01 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Issue restoring SQL database via TDP

Hi Paul, did you use the REPLACE option?

Regards,

Andy



Andrew Raibeck | IBM Spectrum Protect Level 3 | stor...@us.ibm.com

IBM Tivoli Storage Manager links:
Product support:
https://www.ibm.com/support/entry/portal/product/tivoli/tivoli_storage_manager

Online documentation:
http://www.ibm.com/support/knowledgecenter/SSGSG7/landing/welcome_ssgsg7.html

Product Wiki:
https://www.ibm.com/developerworks/community/wikis/home/wiki/Tivoli%20Storage%20Manager

"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 2017-10-31
23:07:56:

> From: Paul_Dudley <pdud...@anl.com.au>
> To: ADSM-L@VM.MARIST.EDU
> Date: 2017-10-31 23:09
> Subject: Issue restoring SQL database via TDP Sent by: "ADSM: Dist
> Stor Manager" <ADSM-L@VM.MARIST.EDU>
>
> I was trying to restore an SQL database from one server (production)
> to another server (test) and over the top of a database with a
> different
name.
>
>
>
> On the production server the database is called
> "InterfaceLoggingProduction". On the test server the database I was
> trying to restore over the top of is called
"InterfaceLoggingProdHoldRestore".
>
> The databases are backed up using Legacy, not VSS. I was using the TDP
> for SQL client on a Windows server to perform the restore. I selected
> the options to manually enter the new database name, and to select the
> locations of the database and log files. The error I kept running into
> was:
>
>
>
> An exception occurred while executing a Transact-SQL statement or batch.
>
> The backup set holds a backup of a database other than the existing
> 'InterfaceLoggingProdHoldRestore' database.
>
> RESTORE DATABASE is terminating abnormally.
>
> In the end I had to restore the database from the production server to
> the test server and use the same database name. Is it not possible to
> restore over the top of a different named database?
>
>
>
> Regards
>
> Paul Dudley
>
> pdud...@anl.com.au <mailto: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/1RZwAMWfhL/3fwfdH5KeIFQWRSUPCCG5Q/0.5







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.

Issue restoring SQL database via TDP

[Paul_Dudley]

I was trying to restore an SQL database from one server (production) to another 
server (test) and over the top of a database with a different name.



On the production server the database is called "InterfaceLoggingProduction". 
On the test server the database I was trying to restore over the top of is 
called "InterfaceLoggingProdHoldRestore".

The databases are backed up using Legacy, not VSS. I was using the TDP for SQL 
client on a Windows server to perform the restore. I selected the options to 
manually enter the new database name, and to select the locations of the 
database and log files. The error I kept running into was:



An exception occurred while executing a Transact-SQL statement or batch.

The backup set holds a backup of a database other than the existing 
'InterfaceLoggingProdHoldRestore' database.

RESTORE DATABASE is terminating abnormally.

In the end I had to restore the database from the production server to the test 
server and use the same database name. Is it not possible to restore over the 
top of a different named database?



Regards

Paul Dudley

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.

Increase resourcetimeout TSM 6.3

[Paul_Dudley]

How do you increase the resourcetimeout value in TSM 6.3? From the TSM 
Administrative Command Line I have run the command "resourcetimeout 120" 
however this fails with an unknown command error.

I have checked the dsmserv.opt file on the server but there is no mention of a 
resourcetimeout parameter in the file.





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.

Backing up Active Directory server using TSM client

[Paul_Dudley]

Is there any point in backing up an Active Directory server using the TSM 
client? Would a restore of Active Directory work? I have read conflicting views 
on this - some say it would not work yet others say it has worked for them, 
while others say that they use another tool to backup Active Directory and then 
use TSM to backup those backup files.





Thanks & Regards

Paul





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.

Making use of two NICs

[Paul_Dudley]

We have TSM v6.3 running on an IBM x3650 M4 server with Windows 2008. The 
server has a second un-used NIC.

If we configure and connect the second NIC, is it possible to make use of it so 
that TSM network traffic (ie: backups) could be spread across the two NICs?





Thanks & Regards

Paul





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.

Re: query auditocc question

[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: query occupancy command - file names

[Paul_Dudley]

Hi,

Tried that but it failed after 18 hours with the following memory failure:

ANS8000I Server command: 'select file_name from contents where volume_name in 
(select volume_name from volumes where stgpool_name='B KPLTO6POOL' )'
ANR0163E tbnsql.c(789): Database insufficient memory detected on 47:1.
ANR0162W Supplemental database diagnostic information:  -1:57011:-1218 
([IBM][CLI Driver][DB2/NT64] SQL1218N  There are no pages currently available 
in bufferpool "1".  SQLSTATE=57011 ).
ANR0516E SQL processing for statement select file_name from contents where 
volume_name in ( select volume_name from volumes where st gpool_name = 
'BKPLTO6POOL' )  failed.


Thanks & Regards
Paul



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Ullrich Mänz
Sent: Thursday, 4 August 2016 6:29 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] AW: query occupancy command - file names

Hi Paul,

try out that:

select file_name from contents where volume_name in (select volume_name from 
volumes where stgpool_name='BKPLTO6POOL')

Because data is taken out of contents table, this query may run very long.

Regards
Ulli Maenz

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von 
Paul_Dudley
Gesendet: Donnerstag, 4. August 2016 02:11
An: ADSM-L@VM.MARIST.EDU
Betreff: [ADSM-L] query occupancy command - file names

The query occupancy command below shows 283 files in the bkplto6pool storage 
pool for this filespace. Is it possible to get a list of the file names?



tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup



Node Name  Type Filespace  FSID Storage  Number of  
  Physical Logical

NamePool NameFiles  
 Space   Space


  OccupiedOccupied


  (MB)(MB)

--  --  -- --- 
--- ---

DBPROD-Bkup DBPROD-   17   BKPLTO6PO- 283 
9,771,429.0 9,771,429.0

_SQL\data\00-   OL  
0   0

 01







Thanks & Regards

Paul





Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au

61-3-8842-5603








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/1OYBJ9Ghcx/5mAucmMa3OSDp5zeRiFgkA/1.222







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.

query occupancy command - file names

[Paul_Dudley]

The query occupancy command below shows 283 files in the bkplto6pool storage 
pool for this filespace. Is it possible to get a list of the file names?



tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup



Node Name  Type Filespace  FSID Storage  Number of  
  Physical Logical

NamePool NameFiles  
 Space   Space


  OccupiedOccupied


  (MB)(MB)

--  --  -- --- 
--- ---

DBPROD-Bkup DBPROD-   17   BKPLTO6PO- 283 
9,771,429.0 9,771,429.0

_SQL\data\00-   OL  
0   0

 01







Thanks & Regards

Paul





Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au

61-3-8842-5603








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: query auditocc question

[Paul_Dudley]

Thanks David - I ran the second command which provided me with a report. 
However the figures in that report match what I already receive from the query 
auditocc command.
This makes me think that there is something wrong with the data that it is 
reporting on. There are two SQL database servers for which the reported data 
appears to be obviously wrong.

For one of them the reported primary storage pool data has increased over the 
past 4 weeks from 2.3Tb, to 4.5Tb, to 7.0Tb and now this week it is 9.1Tb.
We have not increased the number of backups kept, and we have not added any new 
SQL databases.
When I start the DP for SQL client and add up all the active and inactive 
databases which I can restore from, the total amount of data is 2.3Tb.

On another SQL server, the reported primary storage pool data has increased 
over the past 4 weeks from 310Gb, to 610Gb, then 950Gb and now it is 1300Gb.
When I start the DP for SQL client and add up all the active and inactive 
databases which I can restore from, the total amount of data is around 310Gb.

It is as if each week the amount of primary storage pool data is being added to 
rather than replaced. However this is only happening for SQL database servers.
For other non-database servers the amount of reported primary storage pool data 
has been stable.

Where is this the information for this reported primary storage pool data kept? 
Is it on our TSMADMIN server somewhere?

Thanks & Regards
Paul



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

Paul,

You are right.  All of my data is in primary storage pools so I no longer worry 
about copy pools.  Back when I had copy pools, my storage pool names would 
indicate whether it was primary or copy pool.  Can you mask on pool name to 
distinguish between primary and copy pool?

If so,

select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy group by 
node_name  where stgpool_name like '%NAME MASK%'c

Alternatively,

select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy where 
stgpool_name in (select stgpool_name from stgpools where POOLTYPE='PRIMARY' ) 
group by node_name

David

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Paul_Dudley
Sent: Wednesday, July 27, 2016 8:11 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] 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.
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.mailguard.com.au=AwIFAg=SgMrq23dbjbGX6e0ZsSHgEZX6A4IAf1SO3AJ2bNrHlk=dOGCMY197NTNH1k_wcsrWS3_fxedKW4rpKJ8cHCD2L8=cU1nSXe9zeJeTX

Re: query auditocc question

[Paul_Dudley]

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: query auditocc question

[Paul_Dudley]

I checked and our audit license process runs at night every second day. It ran 
about 10 hours prior to the command below being run.

Thanks & Regards
Paul



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

Paul,

The metrics displayed by Q AUDITOCC are updated by AUDIT LICENSE; not in real 
time.

..Paul
(sent from my iPhone)

On Jul 26, 2016, at 9:37 PM, Paul_Dudley 
<pdud...@anl.com.au<mailto:pdud...@anl.com.au>> wrote:

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<mailto: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/1OVfnIigZp/43RuRtkrn8UcyaDwDNdZy5/0.222







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.

query auditocc question

[Paul_Dudley]

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.

Re: Library offline issue

[Paul_Dudley]

Further to my message below, the "q library f=d" command does display details 
about the library, as does the "show library" command.



tsm: TSMANL>q library f=d



  Library Name: LB0.1.0.6

  Library Type: SCSI

ACS Id:

  Private Category:

  Scratch Category:

 WORM Scratch Category:

  External Manager:

RSM Media Type:

Shared: No

   LanFree:

ObeyMountRetention:

   Primary Library Manager:

   WWN:

 Serial Number: 00L4U78L0331_LL0

 AutoLabel: No

  Reset Drives: No

   Relabel Scratch: No

  ZosMedia:

Last Update by (administrator): ADMIN

 Last Update Date/Time: 12/09/2013 17:38:36



tsm: TSMANL>show library

MMSV->libList: head=0537E930, tail=0537E930



Library LB0.1.0.6 (type SCSI):

  refCount=0, online=0, updateCount=0

  basicCfgBuilt=1, libInfoBuild=0, definingPathToLibrary=0

  addLibPath=0, borrowedDrives=0

  passthru=-1

  library extension at 05326530

  Serial Number: (00L4U78L0331_LL0)

  WWN: *EMPTY*

SCSI library scanInProgress=0, relabelScratch=0

  autochanger list:

dev=lb2.1.0.2, busy=0, online=0



  drive list:

L6DRI0:

  Device Type = LTO,

  Drive state: UNKNOWN, Drive descriptor state: NO PENDING CHANGES,

  Online = 1, polled = 0, nativeFilePolled = 0

  Inquiry String = ULT3580-HH6,

  Device Type From Inquiry = 21,

  RD Capabilities = 0FC0,

(ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5,ULTRIUM4C,ULTRIUM4),

  WR Capabilities = 0F00,

(ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5),

  Serial Number: (1068020440)

  WWN: (5000E111312AF001)

  priorReadFailed = 0, priorWriteFailed = 0, priorLocateFailed = 0,

  Update count = 0, checking = 0, passthru = -1,

  offline time/date: 00:00:00 1900/00/00

SCSI-specific fields:

  CleaningFreq(GB)=-1, KBytesProc=0, needsCleaning=0.

  appendOnlySupported=-1, appendOnly=0.

  lbpRequired=0, lbpEnabled=0, nativeFileExists=-1.

  None



However the update library command fails with the error below:



tsm: TSMANL>update library lb0.1.0.6 libtype=scsi shared=no resetd=no 
autolabel=no relabelscr=no serial=00L4U78L0331_LL0

ANR8529E UPDATE LIBRARY: Unable to open library LB0.1.0.6 by using an open 
system call.

ANS8001I Return code 11.





Thanks & Regards

Paul





From: Paul_Dudley [mailto:pdud...@anl.com.au]
Sent: Thursday, 17 March 2016 11:02 AM
To: 'ADSM: Dist Stor Manager'
Subject: Library offline issue





We are running TSM version 6.3 on a Windows 2008 server with an IBM TS3200 tape 
library. The windows server crashed overnight. It has been rebooted and is 
working ok now however TSM will not talk to the tape library drives.

I have powered the tape library off and on and have also performed a clean 
shutdown and restart of the server.



When I run "q path" it reports that the library is online.



tsm: TSMANL>q path



Source Name Source Type Destination Destination On-Line

NameType

--- --- --- --- ---

TSMANL  SERVER  LB0.1.0.6   LIBRARY Yes

TSMANL  SERVER  L6DRI0  DRIVE   Yes

TSMANL  SERVER  L6DRI1  DRIVE   Yes

TSMANL  SERVER  L6DRI2  DRIVE   Yes



tsm: TSMANL>q path f=d



   Source Name: TSMANL

   Source Type: SERVER

  Destination Name: LB0.1.0.6

  Destination Type: LIBRARY

   Library:

 Node Name:

Device: lb2.1.0.2

  External Manager:

  ZOS Media Server:

  Comm. Method:

   LUN:

 Initiator: 0

 Directory:

   On-Line: Yes



When I run "q drive" it reports that the drives are online.



tsm: TSMANL>q drive



Library Name Drive Name   Device Type On-Line

  --- ---

LB0.1.0.6L6DRI0   LTO Yes

LB0.1.0.6L6DRI1   LTO Yes

LB0.1.0.6L6DRI2   LTO Yes



However the status of the drives is unknown



tsm: TSMANL>q drive f=d



Library Name: LB0.1.0.6

  Drive Name: L6DRI0

 Device Type: LTO

 On-Line: Yes

Rea

Library offline issue

[Paul_Dudley]

We are running TSM version 6.3 on a Windows 2008 server with an IBM TS3200 tape 
library. The windows server crashed overnight. It has been rebooted and is 
working ok now however TSM will not talk to the tape library drives.

I have powered the tape library off and on and have also performed a clean 
shutdown and restart of the server.



When I run "q path" it reports that the library is online.



tsm: TSMANL>q path



Source Name Source Type Destination Destination On-Line

NameType

--- --- --- --- ---

TSMANL  SERVER  LB0.1.0.6   LIBRARY Yes

TSMANL  SERVER  L6DRI0  DRIVE   Yes

TSMANL  SERVER  L6DRI1  DRIVE   Yes

TSMANL  SERVER  L6DRI2  DRIVE   Yes



tsm: TSMANL>q path f=d



   Source Name: TSMANL

   Source Type: SERVER

  Destination Name: LB0.1.0.6

  Destination Type: LIBRARY

   Library:

 Node Name:

Device: lb2.1.0.2

  External Manager:

  ZOS Media Server:

  Comm. Method:

   LUN:

 Initiator: 0

 Directory:

   On-Line: Yes



When I run "q drive" it reports that the drives are online.



tsm: TSMANL>q drive



Library Name Drive Name   Device Type On-Line

  --- ---

LB0.1.0.6L6DRI0   LTO Yes

LB0.1.0.6L6DRI1   LTO Yes

LB0.1.0.6L6DRI2   LTO Yes



However the status of the drives is unknown



tsm: TSMANL>q drive f=d



Library Name: LB0.1.0.6

  Drive Name: L6DRI0

 Device Type: LTO

 On-Line: Yes

Read Formats: 
ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5,ULTRIUM4C,ULTRIUM4

   Write Formats: 
ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5

 Element: 256

 Drive State: UNKNOWN

 Volume Name:

Allocated to:

 WWN: 5000E111312AF001

   Serial Number: 1068020440

  Last Update by (administrator): ADMIN

   Last Update Date/Time: 06/04/2015 11:38:08

Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE



When I try to update the drive I get the following error informing me that the 
drive is unavailable.



tsm: TSMANL>update drive lb0.1.0.6 l6dri0 serial=avoid online=yes

ANR8444E UPDATE DRIVE: Library LB0.1.0.6 is currently unavailable.

ANS8001I Return code 14.



I can login to the library via the browser GUI and it all looks OK. The "q 
libvol" command seems to work OK and returns the results I expect.

When I check the properties of the SCSI tape drive devices on the windows 
server they report that the devices are working properly.

Any suggestions? Do I have to run an "update path" or "update library" command?



Thanks & Regards

Paul





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.

Re: Library offline issue

[Paul_Dudley]

Thanks - this has been fixed. I had to use the information from the tsmdlst 
command and run the "update path" commands for the library and the drives.
I then halted and restarted the TSM service and started an audit of the library 
which is running OK.

Thanks & Regards
Paul



-Original Message-

Hello Paul,

you are not using persistent names for the devices, and chances are that after 
the reboot the devices got different names.
check the actual device names with

c:\program files\tivoli\tsm\server\tsmdlst

and update the pathes to the library and the drives accordingly.
"show libray" should report an online=1 in the 3rd line.

tsm: TSMANL>show library

MMSV->libList: head=0537E930, tail=0537E930



Library LB0.1.0.6 (type SCSI):

  refCount=0, online=0, updateCount=0


If possible, enable sandiscovery:

setopt sandiscovery on

or read the devicedriver documentation of the IBM Tape driver on how to enable 
persistent naming, which makes life much easier.


--
Michael Prix

Am 17.03.2016 um 01:21 schrieb Paul_Dudley:
> Further to my message below, the "q library f=d" command does display details 
> about the library, as does the "show library" command.
>
>
>
> tsm: TSMANL>q library f=d
>
>
>
>   Library Name: LB0.1.0.6
>
>   Library Type: SCSI
>
> ACS Id:
>
>   Private Category:
>
>   Scratch Category:
>
>  WORM Scratch Category:
>
>   External Manager:
>
> RSM Media Type:
>
> Shared: No
>
>LanFree:
>
> ObeyMountRetention:
>
>Primary Library Manager:
>
>WWN:
>
>  Serial Number: 00L4U78L0331_LL0
>
>  AutoLabel: No
>
>   Reset Drives: No
>
>Relabel Scratch: No
>
>   ZosMedia:
>
> Last Update by (administrator): ADMIN
>
>  Last Update Date/Time: 12/09/2013 17:38:36
>
>
>
> tsm: TSMANL>show library
>
> MMSV->libList: head=0537E930, tail=0537E930
>
>
>
> Library LB0.1.0.6 (type SCSI):
>
>   refCount=0, online=0, updateCount=0
>
>   basicCfgBuilt=1, libInfoBuild=0, definingPathToLibrary=0
>
>   addLibPath=0, borrowedDrives=0
>
>   passthru=-1
>
>   library extension at 05326530
>
>   Serial Number: (00L4U78L0331_LL0)
>
>   WWN: *EMPTY*
>
> SCSI library scanInProgress=0, relabelScratch=0
>
>   autochanger list:
>
> dev=lb2.1.0.2, busy=0, online=0
>
>
>
>   drive list:
>
> L6DRI0:
>
>   Device Type = LTO,
>
>   Drive state: UNKNOWN, Drive descriptor state: NO PENDING
> CHANGES,
>
>   Online = 1, polled = 0, nativeFilePolled = 0
>
>   Inquiry String = ULT3580-HH6,
>
>   Device Type From Inquiry = 21,
>
>   RD Capabilities = 0FC0,
>
> (ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5,ULTRIUM4C,ULTRIUM4),
>
>   WR Capabilities = 0F00,
>
> (ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5),
>
>   Serial Number: (1068020440)
>
>   WWN: (5000E111312AF001)
>
>   priorReadFailed = 0, priorWriteFailed = 0, priorLocateFailed =
> 0,
>
>   Update count = 0, checking = 0, passthru = -1,
>
>   offline time/date: 00:00:00 1900/00/00
>
> SCSI-specific fields:
>
>   CleaningFreq(GB)=-1, KBytesProc=0, needsCleaning=0.
>
>   appendOnlySupported=-1, appendOnly=0.
>
>   lbpRequired=0, lbpEnabled=0, nativeFileExists=-1.
>
>   None
>
>
>
> However the update library command fails with the error below:
>
>
>
> tsm: TSMANL>update library lb0.1.0.6 libtype=scsi shared=no resetd=no
> autolabel=no relabelscr=no serial=00L4U78L0331_LL0
>
> ANR8529E UPDATE LIBRARY: Unable to open library LB0.1.0.6 by using an open 
> system call.
>
> ANS8001I Return code 11.
>
>
>
>
>
> Thanks & Regards
>
> Paul
>
>
>
>
>
> From: Paul_Dudley [mailto:pdud...@anl.com.au]
> Sent: Thursday, 17 March 2016 11:02 AM
> To: 'ADSM: Dist Stor Manager'
> Subject: Library offline issue
>
>
>
>
>
> We are running TSM version 6.3 on a Windows 2008 server with an IBM TS3200 
> tape library. The windows server crashed overnight. It has been rebooted and 
> is working ok now however TSM will not talk to the tape library drives.
>
> I have powered the tape library off and on and have also performed a clean 
> shutdown and restart of the server.
>
>
>
> When I run "q pat

Re: Library offline issue

[Paul_Dudley]

Thanks Michael,

Here is the output from the tsmdlst command. The tape library is listed as 
lb2.1.0.3 below.

Computer Name:  TSMANL
OS Version: 6.1
OS Build #: 7601
TSM Device Driver:  TSMScsi - Not Running

3 HBAs were detected.

ManufacturerModel  Driver  VersionFirmware 
Description


TSM Name ID   LUN  Bus  Port SSN WWN   TSM 
Type Driver   Device Identifier
-
mt2.0.0.2200210WT010084  - LTO  
IBM  IBM ULT3580-HH6 D8E5
mt2.0.0.320031068020440  - LTO  
IBM  IBM ULT3580-HH6 D8E5
lb2.1.0.3210300L4U78L0331_LL0- 
LIBRARY  IBM  IBM 3573-TL B.90
mt2.0.0.420041068014982  - LTO  
IBM  IBM ULT3580-HH6 D8E5

Thanks & Regards
Paul



-Original Message-

Hello Paul,

you are not using persistent names for the devices, and chances are that after 
the reboot the devices got different names.
check the actual device names with

c:\program files\tivoli\tsm\server\tsmdlst

and update the pathes to the library and the drives accordingly.
"show libray" should report an online=1 in the 3rd line.

tsm: TSMANL>show library

MMSV->libList: head=0537E930, tail=0537E930



Library LB0.1.0.6 (type SCSI):

  refCount=0, online=0, updateCount=0


If possible, enable sandiscovery:

setopt sandiscovery on

or read the devicedriver documentation of the IBM Tape driver on how to enable 
persistent naming, which makes life much easier.


--
Michael Prix

Am 17.03.2016 um 01:21 schrieb Paul_Dudley:
> Further to my message below, the "q library f=d" command does display details 
> about the library, as does the "show library" command.
>
>
>
> tsm: TSMANL>q library f=d
>
>
>
>   Library Name: LB0.1.0.6
>
>   Library Type: SCSI
>
> ACS Id:
>
>   Private Category:
>
>   Scratch Category:
>
>  WORM Scratch Category:
>
>   External Manager:
>
> RSM Media Type:
>
> Shared: No
>
>LanFree:
>
> ObeyMountRetention:
>
>Primary Library Manager:
>
>WWN:
>
>  Serial Number: 00L4U78L0331_LL0
>
>  AutoLabel: No
>
>   Reset Drives: No
>
>Relabel Scratch: No
>
>   ZosMedia:
>
> Last Update by (administrator): ADMIN
>
>  Last Update Date/Time: 12/09/2013 17:38:36
>
>
>
> tsm: TSMANL>show library
>
> MMSV->libList: head=0537E930, tail=0537E930
>
>
>
> Library LB0.1.0.6 (type SCSI):
>
>   refCount=0, online=0, updateCount=0
>
>   basicCfgBuilt=1, libInfoBuild=0, definingPathToLibrary=0
>
>   addLibPath=0, borrowedDrives=0
>
>   passthru=-1
>
>   library extension at 05326530
>
>   Serial Number: (00L4U78L0331_LL0)
>
>   WWN: *EMPTY*
>
> SCSI library scanInProgress=0, relabelScratch=0
>
>   autochanger list:
>
> dev=lb2.1.0.2, busy=0, online=0
>
>
>
>   drive list:
>
> L6DRI0:
>
>   Device Type = LTO,
>
>   Drive state: UNKNOWN, Drive descriptor state: NO PENDING
> CHANGES,
>
>   Online = 1, polled = 0, nativeFilePolled = 0
>
>   Inquiry String = ULT3580-HH6,
>
>   Device Type From Inquiry = 21,
>
>   RD Capabilities = 0FC0,
>
> (ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5,ULTRIUM4C,ULTRIUM4),
>
>   WR Capabilities = 0F00,
>
> (ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5),
>
>   Serial Number: (1068020440)
>
>   WWN: (5000E111312AF001)
>
>   priorReadFailed = 0, priorWriteFailed = 0, priorLocateFailed =
> 0,
>
>   Update count = 0, checking = 0, passthru = -1,
>
>   offline time/date: 00:00:00 1900/00/00
>
> SCSI-specific fields:
>
>   CleaningFreq(GB)=-1, KBytesProc=0, needsCleaning=0.
>
>   appendOnlySupported=-1, appendOnly=0.
>
>   lbpRequired=0, lbpEnabled=0, nativeFileExists=-1.
>
>   None
>
>
>
> However the update library command fails with the error below:
>
>
>
> tsm: TSMANL>upd

Re: What have they done to Passport!

[Paul_Dudley]

I have wasted hours of my life on the Passport Advantage site going around in 
circles. Of any website by any major manufacturer of any product, it is far and 
away the worst I have ever encountered.

Thanks & Regards
Paul



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Vandeventer, Harold [OITS]
Sent: Wednesday, 24 February 2016 9:16 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] What have they done to Passport!

Yep, looks like a re-do with a major hiccup.

The link to get to passport advantage seems to just reload the initial page.



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: Tuesday, February 23, 2016 3:07 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] What have they done to Passport!

I haven't been to Passport for a while. All I want to do is download the latest 
7.1 with included licenses (vs patches from the FTP site).

I have been wandering around and clicking for 30+ minutes and can't figure out 
what used to be a simple 3-clicks to get to my entitled software!  It keeps 
wanting to sell me something.  All I want is the software I am entitled to!  
Why is this being made so hard?

--
*Zoltan Forray*
TSM Software & Hardware Administrator
Xymon Monitor Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
www.ucc.vcu.edu
zfor...@vcu.edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will never 
use email to request that you reply with your password, social security number 
or confidential personal information. For more details visit 
http://infosecurity.vcu.edu/phishing.html

[Confidentiality notice:]
***
This e-mail message, including attachments, if any, is intended for the person 
or entity to which it is addressed and may contain confidential or privileged 
information.  Any unauthorized review, use, or disclosure is prohibited.  If 
you are not the intended recipient, please contact the sender and destroy the 
original message, including all copies, Thank you.
***
--
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/1NTKAweMoL/1O4kmAXFgpsNvteX6OaW2M/0.012







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.

Moving nodes to a new policy

[Paul_Dudley]

If I have nodes that are currently under a policy that keeps 5 backup versions, 
can I move them to another policy which keeps only 2 backup versions?

Will TSM then start expiring all the older backup versions of files which are 
no longer needed?

We have two nodes which are taking up a lot of backup space in TSM and want to 
reduce this.





Thanks  Regards

Paul Dudley

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.

Change from PVU to Unified licensing

[Paul_Dudley]

We have recently changed from PVU based licensing to the Unified/Terabyte based 
licensing model on TSM.

What do I need to do on the TSM system itself to update the licensing? Is there 
a file that needs to be updated or a command that needs to be run?

When I run q lic it is still showing the old licensing type.





Thanks  Regards

Paul



Paul Dudley

IT Operations








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.

TDP Flashcopy - restore to alternate location

[Paul_Dudley]

We have TSM v6.3. On two Windows 2012 64bit servers we have the TDP Storage 
Flashcopy manager v3.2.1.0 client.

Both of these servers run MS SQL Server 2012.



I would like to restore databases backed up on one server to the other. The 
databases are backed up using the tdpsqlc backup * full command, which runs 
via Windows Task Scheduler.

To restore databases backed up on one server to the other I first change the 
dsm.opt file in the TDPSql folder - making the nodename the node from which I 
am restoring the databases from.

I then start the DP for SQL Management Console which in turn opens the TDP 
Storage Flashcopy manager window.



My problem occurs when I select a database and then select Restore Alternate 
Location. In the settings window I click on Restore to a new database, 
however the option to relocate files individually is greyed out.

When restoring from other servers when I click on Restore to a new database I 
see the green progress bar appear at the bottom of this settings window and 
then TSM displays the location of the database file and log file on the source 
server.

This does not happen on this occasion.



Is there a setting when trying to restore (or when backing up the original 
files) that has to be changed? There is an option to relocate all the files to 
one location however this is not suitable as the database file and log file 
need to be restored to different drives.





Thanks  Regards

Paul










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.

FW: TDP Flashcopy - restore to alternate location

[Paul_Dudley]

More research and testing on the issue below seems to indicate that I have to 
change the backup type from VSS to Legacy to fully enable the Restore Alternate 
Location option on the target server.


Thanks  Regards
Paul

 We have TSM v6.3. On two Windows 2012 64bit servers we have the TDP Storage 
 Flashcopy manager v3.2.1.0 client.
 Both of these servers run MS SQL Server 2012.

 I would like to restore databases backed up on one server to the other. The 
 databases are backed up using the tdpsqlc backup * full command, which runs 
 via Windows Task Scheduler.
 To restore databases backed up on one server to the other I first change the 
 dsm.opt file in the TDPSql folder - making the nodename the node from which I 
 am restoring the databases from.
 I then start the DP for SQL Management Console which in turn opens the TDP 
 Storage Flashcopy manager window.

 My problem occurs when I select a database and then select Restore Alternate 
 Location. In the settings window I click on Restore to a new database, 
 however the option to relocate files individually is greyed out.
 When restoring from other servers when I click on Restore to a new database I 
 see the green progress bar appear at the bottom of this settings window and 
 then TSM displays the location of the database file and log file on the 
 source server.
 This does not happen on this occasion.

 Is there a setting when trying to restore (or when backing up the original 
 files) that has to be changed? There is an option to relocate all the files 
 to one location however this is not suitable as the database file and log 
 file need to be restored to different  drives.








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.

Error when installing TSM client on RHES 5.7

[Paul_Dudley]

Hi all,



I am trying to install the TSM client on Red Hat linux version ES 5.7. 
TIVsm-API-5.2.0-0 has installed OK via the rpm command however I have run into 
the problem below:



rpm -i TIVsm-BA.i386.rpm

error: Failed dependencies:

libstdc++-libc6.1-1.so.2 is needed by TIVsm-BA-5.2.0-0.i386

libXp.so.6 is needed by TIVsm-BA-5.2.0-0.i386



Any suggestions? I assume there are some other linux packages I have to install?





Thanks  Regards

Paul



Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au







ANL - Regional Carrier of the Year 2011 - Containerisation International

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: Error when installing TSM client on RHES 5.7

[Paul_Dudley]

Thanks Grant - I will keep that info for future reference however I got around 
it by installing a later version of the client (5.5.4).


Thanks  Regards
Paul


-Original Message-
Subject: Re: [ADSM-L] Error when installing TSM client on RHES 5.7

yum whatprovides */libstdc++-libc6.1-1.so.2 yum whatprovides */libXp.so.6

will tell you what is missing.

HTH

Grant

On 13/09/12 11:43, Paul_Dudley wrote:
 Hi all,



 I am trying to install the TSM client on Red Hat linux version ES 5.7. 
 TIVsm-API-5.2.0-0 has installed OK via the rpm command however I have run 
 into the problem below:



 rpm -i TIVsm-BA.i386.rpm

 error: Failed dependencies:

  libstdc++-libc6.1-1.so.2 is needed by TIVsm-BA-5.2.0-0.i386

  libXp.so.6 is needed by TIVsm-BA-5.2.0-0.i386



 Any suggestions? I assume there are some other linux packages I have to 
 install?





 Thanks  Regards
 Paul






ANL - Regional Carrier of the Year 2011 - Containerisation International

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: LTO3 and LTO4 tape classes

[Paul_Dudley]

OK here is the output from that command:

tsm: ANLTSMq devc LTO4CLASS f=d

 Device Class Name: LTO4CLASS
Device Access Strategy: Sequential
Storage Pool Count: 5
   Device Type: LTO
Format: DRIVE
 Est/Max Capacity (MB):
   Mount Limit: DRIVES
  Mount Wait (min): 60
 Mount Retention (min): 3
  Label Prefix: ADSM
  Drive Letter:
   Library: LB0.1.0.6
 Directory:
   Server Name:
  Retry Period:
Retry Interval:
  Twosided:
Shared:
High-level Address:
  Minimum Capacity:
  WORM: No
  Drive Encryption: Allow
   Scaled Capacity:
Last Update by (administrator): ADMIN
 Last Update Date/Time: 05/20/2010 10:44:36


Thanks  Regards
Paul


-Original Message-

Paul,

Can you please post q devc LTO4CLASS f=d

Steve

Steven Harris
TSM Admin
Canberra Australia


On 17.04.2012 19:35, Paul_Dudley wrote:
 We have a mixture of LTO3 and LTO4 tapes in the one tape library. Our
 primary disk backup storage pool - BKPPOOL - is set to migrate to
 BKPLTO4POOL when it reaches 90% full.

 The storage pool BKPLTO4POOL is set to device class LTO4CLASS. We also
 have device class LTO3CLASS for the LTO3 tapes.



 However when the migration is performed from BKPPOOL to BKPLTO4POOL it
 seems to always grab an LTO3 scratch tape despite the fact that there
 are numerous LTO4 scratch tapes available.

 Is it possible to change a setting or force it to use an LTO4 scratch
 tape instead of an LTO3 scratch tape?





 Thanks  Regards

 Paul



 Paul Dudley

 IT Operations

 ANL Container Line

 pdud...@anl.com.au







 ANL - Regional Carrier of the Year 2011 - Containerisation
 International

 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.






ANL - Regional Carrier of the Year 2011 - Containerisation International

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.

LTO3 and LTO4 tape classes

[Paul_Dudley]

We have a mixture of LTO3 and LTO4 tapes in the one tape library. Our primary 
disk backup storage pool - BKPPOOL - is set to migrate to BKPLTO4POOL when it 
reaches 90% full.

The storage pool BKPLTO4POOL is set to device class LTO4CLASS. We also have 
device class LTO3CLASS for the LTO3 tapes.



However when the migration is performed from BKPPOOL to BKPLTO4POOL it seems to 
always grab an LTO3 scratch tape despite the fact that there are numerous LTO4 
scratch tapes available.

Is it possible to change a setting or force it to use an LTO4 scratch tape 
instead of an LTO3 scratch tape?





Thanks  Regards

Paul



Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au







ANL - Regional Carrier of the Year 2011 - Containerisation International

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: Excessive number of filling tapes...

[Paul_Dudley]

Re your line  None of them has data from more than one client

Has collocation been turned on by accident?

Thanks  Regards
Paul
 
 


 So, I've got an offsite machine which exists to accept remote virtual
 volumes.  For years, now, the filling volumes have behaved in a way I
 thought I understood.

 The tapes are collocated by node.  There are about 20 server nodes which
 write to it.

 My number of filling volumes has rattled around 50-60 for years;  I
 interpret this as basic node collocation, plus occasional additional
 tapes allocated when more streams than tapes are writing at a time.  So
 some of the servers have just one filling tape, some have two, and the
 busiest of them might have as many as 6 (my drive count).

 Add a little error for occasionally reclaiming a still-filling volume,
 and that gives me a very clear sense of what's going on, and I can just
 monitor scratch count.

 Right now, I have 190 filling volumes.

 None of them has data from more than one client.

 I have some volumes RO and filling, and am looking into that, but it's
 20 of them, not enough to account for this backlog.  Those are also the
 only vols in error state.

 I've been rooting through my actlogs looking for warnings or errors, but
 I've never had occasion to introspect about how TSM picks which tape to
 call for, when it's going to write.  It's always Just Worked.


 Does this ring any bells for anyone?Any dumb questions I've
 forgotten to ask?  I don't hold much hope for getting a good experience
 out of IBM support on this.


 - Allen S.Rout






ANL - Regional Carrier of the Year 2011 - Containerisation International

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: Offsite copypool question

[Paul_Dudley]

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
 Xav Paice

 - Paul_Dudley pdud...@anl.com.au wrote:
  On the SQL servers I have included the SQL database folder in the
  Exclude-Include configuration of the normal TSM backup setup. (these
  databases are backed up using TDP for SQL) As well as that, SQL is
  running all the time so the normal TSM backup client would never be
  able to get a lock on these database files. I already have a backup of
  these SQL databases in the SQLDB_LTO4 storage pool and therefore a
  copy is in the SQLDB_COPYPOOL storage pool so I don't need another
  copy in BKPLTO4POOL and COPYPOOL_LTO3
 
  Any idea how I can work out why a backup copy of these SQL database
  backups are ending up in BKPLTO4POOL and stop this from happening?
 

 It's likely you're getting the files captured by the client even with the db 
 open.  Try
 to exclude them in the inclexcl, or associate them with the right management
 class.

 'Query occupancy' for the TDP node should list everything in the right storage
 pool.

 Take a look in the BA client gui and hunt down the database files - that will 
 tell you
 if they are being stored.  If you can see them as individual files, and 
 you've not
 made a cold backup of the database, then that's the issue.  You can delete 
 them
 from the ba client if you wish and are sure they're not wanted.

I checked the BA GUI and the database files are not being backed up. However 
when I ran q occupancy I can see that these node names for these SQL database 
backups are in the wrong storage pool -  BKPLTO4POOL. When I query these node 
names the platform is TDP MSSQL Win32, and the Optionset is SQL_SERVERS. Note 
that it is not all of the SQL servers that are this way, some show the correct 
Storage Pool via the q occupancy command.

How can I change the SQL Servers that are incorrect to be backed up into the 
correct storage pool?

Thanks
Paul






ANL - Regional Carrier of the Year 2011 - Containerisation International

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.

Offsite copypool question

[Paul_Dudley]

We have a linux shell script which we use to create our offsite copypool tapes. 
Basically the commands are:



backup stg SQLDB_LTO4 SQLDB_COPYPOOL wait=yes



backup stg BKPLTO4POOL COPYPOOL_LTO3 wait=yes



Our primary SQL storage pool is SQLDB_DISKPOOL and it's secondary pool for data 
migration is SQLDB_LTO4.

Our primary backup storage pool is BKPPOOL and it's secondary pool for data 
migration is BKPLTO4POOL.



However I am finding that backups of SQL databases are also somehow ending up 
in the BKPLTO4POOL storage pool because they are then in turn being backed up 
into the COPYPOOL_LTO3 storage pool.

The reason I know this is that these SQL databases are very large files with 
very distinctive (but consistent) sizes so as soon run q pr and see the 
process copying a 185 Gb file from the BKPLTO4POOL storage pool to the 
COPYPOOL_LTO3 storage pool I know which SQL database file that is.



On the SQL servers I have included the SQL database folder in the 
Exclude-Include configuration of the normal TSM backup setup. (these databases 
are backed up using TDP for SQL) As well as that, SQL is running all the time 
so the normal TSM backup client would never be able to get a lock on these 
database files. I already have a backup of these SQL databases in the 
SQLDB_LTO4 storage pool and therefore a copy is in the SQLDB_COPYPOOL storage 
pool so I don't need another copy in BKPLTO4POOL and COPYPOOL_LTO3



Any idea how I can work out why a backup copy of these SQL database backups are 
ending up in BKPLTO4POOL and stop this from happening?





Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au















ANL - Regional Carrier of the Year 2011 - Containerisation International

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.

TS3200 tape library checkin question

[Paul_Dudley]

We have an IBM TS3200 tape library, which takes both LTO4  LTO3 tapes. The I/O 
cartridge has capacity to slot in 3 tapes at a time. However I am not sure what 
is the correct command to check in 3 scratch tapes at the one time and get the 
tape library to search the I/O cartridge for each of the 3 scratch tapes. Can 
someone advise me on the correct syntax of the checkin command for this?





Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

SQL query - large files

[Paul_Dudley]

Is it possible to interrogate the TSM database with an SQL query to display the 
list of backed up files whose size is larger than - for example - 160 Mbs?

I understand that this will be a query that will take a while to run so I am 
prepared to run it on the weekend. While the total number of files is large the 
number of files larger than 160 Mb is quite small.



Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: SQL query - large files

[Paul_Dudley]

 -Original Message-

 On Jul 17, 2011, at 9:07 PM, Paul_Dudley wrote:

  Is it possible to interrogate the TSM database with an SQL query to display 
  the
 list of backed up files whose size is larger than - for example - 160 Mbs?
 
  I understand that this will be a query that will take a while to run so I 
  am prepared
 to run it on the weekend. While the total number of files is large the number 
 of files
 larger than 160 Mb is quite small.

 V5 or V6?

 With version 5, the CONTENTS table and the BACKUPS tables are both indexed
 reasonably well. BACKUPS has the size and might be all you need.

 Version 6? The BACKUPS view (table?) doesn't have enough indices on it to be
 useful. A colleague at work is trying to dare me to use DB2 to look at the 
 real
 internal tables, but I haven't quite that ambitious yet.

 Nick

It is version 5.5

Regards
Paul






ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Copypool storage advice

[Paul_Dudley]

I believe I have found the problem. The maximum number of scratch volumes 
allowed was set to 40 and it had reached this limit which was causing the 
reclaimation process to fail. I have increased the maximum number of scratch 
volumes allowed and restarted the reclaimation process.

Thanks  Regards
Paul


 -Original Message-

 It's been a while since I've worked much with off-site copypools, but my next
 suggestion is to work with DRMedia. Do you have some volumes (that have been
 reclaimed) in VAULTRETRIEVE status? I don't remember how they show up in your
 volume list (I half expect 'EMPTY' status, but as I said, it's been a while), 
 but if you
 do, they might be returned to scratch status when you MOVE DRM the VAULTRET
 volumes back to ONSITERET.

 How many BACKUP STG processes are you running at a time? If you run four
 backup processes at a time, you'll produce four tapes each day, even if one 
 would
 be enough. That might be contributing to this phenomenon.

 You said these volumes are set as offsite; that's at the volume level; 
 volumes are
 the only things with an offisite status, as I recall. If you do QUERY LIBVOL 
 *
 volid, do they show up? If TSM knows they're in the library, they won't be
 reclaimed if they're in FILLING status, as I recall.

 I love a good puzzle. I'm just not sure how many things I'm taking for 
 granted about
 how you're using TSM. :-)

 Nick

 On Apr 10, 2011, at 6:35 PM, Paul_Dudley wrote:

  Collocation for the storage pool is set to none. No I am not using the 
  du=
 parameter on the reclaim commands. I check the log and they do finish
 successfully.
  They are a mixture of full and filling tapes. They are all set as 
  offsite.
 
  Thanks  Regards
  Paul
 
 
  I currently have a lot of copypool storage tapes which are between 50 - 
  60%
  utilization. Expiration runs daily and I run reclaimation daily on this 
  copypool, set
 to
  50.
 
  Is there anything I can do to try and consolidate the data onto fewer 
  copypool
  tapes?
 
  I would conclude that you have your collocation on the copypool set to
 something
  other than none. My back-up theory is that you're using a dur= 
  parameter on
  your reclaim commands, and they simply are not finishing.
 
  Are these tapes marked as being off-site? Are they in filling status or 
  full?
  Filling tapes normally are excluded from reclamation if they're 
  allegedly still in
 the
  library.
 
  I'm not sure why it would matter, but what's your TSM server level?
 
 
  Nick





ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Copypool storage advice

[Paul_Dudley]

Collocation for the storage pool is set to none. No I am not using the du= 
parameter on the reclaim commands. I check the log and they do finish 
successfully.
They are a mixture of full and filling tapes. They are all set as offsite.

Thanks  Regards
Paul


  I currently have a lot of copypool storage tapes which are between 50 - 60%
 utilization. Expiration runs daily and I run reclaimation daily on this 
 copypool, set to
 50.
 
  Is there anything I can do to try and consolidate the data onto fewer 
  copypool
 tapes?

 I would conclude that you have your collocation on the copypool set to 
 something
 other than none. My back-up theory is that you're using a dur= parameter 
 on
 your reclaim commands, and they simply are not finishing.

 Are these tapes marked as being off-site? Are they in filling status or 
 full?
 Filling tapes normally are excluded from reclamation if they're allegedly 
 still in the
 library.

 I'm not sure why it would matter, but what's your TSM server level?


 Nick






ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Ang: Copypool storage advice

[Paul_Dudley]

The copypool is on LTO3 tapes. They are not database backups just incremental 
server backups

Thanks  Regards
Paul


 -Original Message-

 It would be helpful to know what kind of the tape technology you're using 
 since the
 reclamation threshold % is usually based off which technology is being used.
 Smaller tapes can usually have a small threshold while larger tapes requires a
 larger threshold.

 One way to reduce the amount of tapes is simply to reduce the threshold to
 something like 30 and let the reclaim process run until it's complete. This 
 will require
 enough free tape drives to a) let reclamation run until it's complete b) do 
 normal
 operations.

 There can be several reasons why you get so high pct reclaim. One is that 
 you're
 running full database or application backups. Since this will expire a full 
 backup
 every day, it will cause the reclaim on your tapes to rise. Splitting your 
 copypool into
 separate ones categorized on the type of data stored (one for fileservers, 
 one for
 application servers for example) is one way to go, using collocation is 
 another.

 Best Regards

 Daniel Sparrman

 -ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU skrev: -


 I currently have a lot of copypool storage tapes which are between 50 - 60%
 utilization. Expiration runs daily and I run reclaimation daily on this 
 copypool, set to
 50.

 Is there anything I can do to try and consolidate the data onto fewer copypool
 tapes?



 Thanks  Regards

 Paul



 Paul Dudley

 Senior IT Systems Administrator

 ANL Container Line Pty Limited

 Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au








 ANL DISCLAIMER

 This e-mail and any file attached is confidential, and intended solely to the 
 named
 addressees. 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 system. Please do not copy, use or make reference to it for any 
 purpose,
 or disclose its contents to any person.





ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Copypool storage advice

[Paul_Dudley]

I currently have a lot of copypool storage tapes which are between 50 - 60% 
utilization. Expiration runs daily and I run reclaimation daily on this 
copypool, set to 50.

Is there anything I can do to try and consolidate the data onto fewer copypool 
tapes?



Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Copypool storage question

[Paul_Dudley]

We use LTO4 tapes for the primary tape storage pools and LTO3 tapes for the 
copy pool.
I was trying to see if there was a way to free up more LTO3 tapes for scratch 
tapes.
Looks like we will just have to buy more LTO3 tapes.

Thanks  Regards
Paul



 Short answer no. Its all or nothing with copy pools. You can keep just
 the last version of each file with an active pool, but you should have a
 copy pool as well just in case your primary pool goes bad.  You could
 send the active pool offsite and keep the copy pool onsite.  What are
 you trying to save on?

 Regards

 Steve.


 On 10/02/2011 6:10 PM, Paul_Dudley wrote:
  Our primary tape backup pool is set to keep 5 versions of each file. Each 
  morning
 the overnight incremental backups into this storage pool are copied into the
 copypool and then these tapes are sent offsite. Is there anyway to setup the
 copypool so that it only has the last 2 versions of each file instead of 5 
 versions?
 
 
 
  Thanks  Regards
 
  Paul





ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Copypool storage question

[Paul_Dudley]

Our primary tape backup pool is set to keep 5 versions of each file. Each 
morning the overnight incremental backups into this storage pool are copied 
into the copypool and then these tapes are sent offsite. Is there anyway to 
setup the copypool so that it only has the last 2 versions of each file instead 
of 5 versions?



Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au










ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Deleting ALL tapes from a defunct TSM server from Volhist

[Paul_Dudley]

 Subject: [ADSM-L] Deleting ALL tapes from a defunct TSM server from Volhist

 Back in 2008 there was a thread on forcing the deletion of individual
 tapes from a defunct TSM server.



 http://www.adsm.org/lists/html/ADSM-L/2008-06/msg00068.html

 del volhist todate=today type=remote volume=A00229 force=yes

 I tried that and it worked as expected.

 Now I need to do it 483 more times.

 Is there a parameter that lets you designate which remote location to
 delete from, so that all the volsers can be deleted at once?



 George Huebschman
 Storage Support Team, Media Librarian
 Legg Mason, LMTS

George,

If one of the servers you are backing up via TSM is a linux or unix server you 
should be able to create a shell script on that server to run that command.
The script will need to have a do loop into which you can get it to read a 
list.

It would need to start like this:

#!/bin/ksh

#Standard TSM Admin command.
DSMADMC=/usr/bin/dsmadmc -id=admin -pa=XX -noconfirm 

And then have a line something like this

while read VOL
do
$DSMADMC  del volhist todate=today type=remote volume=$VOL force=yes 
done  /tmp/nodelist

Please check the syntax above before running as this is only a quick example...

Regards
Paul









ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Copypool storage pool questions

[Paul_Dudley]

Thanks for the reply but one thing I am still confused about are these copypool 
tapes sitting in my onsite tape library. Given that the primary reason for this 
copypool is for offsite tapes, should these copypool tapes currently residing 
in my tape library (created by reclaimation processes) be checked out and sent 
offsite as well?

Thanks  Regards
Paul


 -Original Message-
  A lot of these have a status of Full however they are only 50/60/70% used.

 ...a reflection of files on the filled tape expiring over time, which 
 reclamation will
 combine with other data to fill a new tape.  Surrogate reclamation tends to 
 be quite
 slow compared to direct reclamation, where it may not be able to keep up with 
 the
 need for additional offsite tapes for new data, the result being a 
 considerable
 demand for the scratch tapes you have in the library, which could account for 
 your
 issue of running low on scratch tapes.

 The only other suggestion that may apply is to verify the devclass Format 
 being
 used, that it uses compression so as to get the most onto the tapes.

 Richard Sims






ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Copypool storage pool questions

[Paul_Dudley]

It is a copy pool.

Thanks  Regards
Paul

Paul Dudley
Senior IT Systems Administrator
ANL Container Line Pty Limited
Email: pdud...@anl.com.au

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
 Lakshminarayanan, Rajesh
 Sent: Thursday, 7 October 2010 12:46 PM
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] Copypool storage pool questions

 Running reclamation is not an issue. Generally I run it when my scratch
 tapes go below my threshold limit.

 Is BKPLTO4POOL stg pool is it a copy pool or primary pool?

 Regards,

 Rajesh Lakshminarayanan
 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
 Paul_Dudley
 Sent: Thursday, October 07, 2010 8:00 AM
 To: ADSM-L@VM.MARIST.EDU
 Subject: [ADSM-L] Copypool storage pool questions

 Each weekday morning we run the following command backup stg
 BKPLTO4POOL COPYPOOL_LTO3 to backup the data that has been backed up
 overnight onto LTO3 tapes and then checkout these LTO3 tapes and send
 them offsite. I have a reclaimation process running on a daily basis for
 the COPYPOOL_LTO3 storage pool. However this process is using up scratch
 tapes that are within the tape library at an alarming rate and I am
 starting to run low on scratch tapes.



 Am I doing something wrong?

 Should there be a daily reclaimation process running on this offsite
 tape storage pool?

 Should these COPYPOOL_LTO3 tapes which are in the tape library be sent
 offsite as well as the ones that are sent offsite on a daily basis?

 What would happen if I deleted the data on one of these COPYPOOL_LTO3
 tapes which are currently in the tape library?





 Thanks  Regards

 Paul



 Paul Dudley

 Senior IT Systems Administrator

 ANL Container Line Pty Limited

 Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au










 ANL DISCLAIMER

 This e-mail and any file attached is confidential, and intended solely
 to the named addressees. 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 system. Please
 do not copy, use or make reference to it for any purpose, or disclose
 its contents to any person.






ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: Copypool storage pool questions

[Paul_Dudley]

No I do not have collocation turned on for that storage pool. Offsite tapes are 
coming back when they are defined as empty after the reclaimation and 
expiration processes have done their work. However as part of the reclaimation 
process on that storage pool it is using tapes onsite that are in the library. 
A lot of these have a status of Full however they are only 50/60/70% used.

Thanks  Regards
Paul

Paul Dudley

 -Original Message-

 Assure that you aren't collocating on the offsite copy pool tapes, and that 
 partially
 filled tapes are not going offsite - that will certainly eat scratches fast.  
 Obviously,
 offsite tapes need to come back to provide a replenishing tape supply.  Be 
 careful
 about checking in offsite tapes, as they could end up checking out before 
 getting
 reclaimed, depending upon your processing.  Deleting a copypool tape is 
 certainly
 legal, but of course you obliterate that safety copy.

Richard Sims






ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Storage Pool Migration

[Paul_Dudley]

We have TSM 5.5. Shortly after this was originally setup at the start of this 
year data from the DIRMC storage pool was migrated to tape due to the settings 
for the DIRMC storage pool not being correct. Now 9 months later the DIRMC 
storage pool is still only at 3% of capacity. The migrated data is still on the 
tape which is only at 0.2% of capacity. This is basically wasting a tape. What 
are my options to free up this tape and make it a scratch tape again? Can I 
migrate the data from the tape back to the primary disk pool? From what I have 
read it appears not. What happens if I delete the data on the tape? Do I have 
any other options?



Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au










ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Copypool storage pool questions

[Paul_Dudley]

Each weekday morning we run the following command backup stg BKPLTO4POOL 
COPYPOOL_LTO3 to backup the data that has been backed up overnight onto LTO3 
tapes and then checkout these LTO3 tapes and send them offsite. I have a 
reclaimation process running on a daily basis for the COPYPOOL_LTO3 storage 
pool. However this process is using up scratch tapes that are within the tape 
library at an alarming rate and I am starting to run low on scratch tapes.



Am I doing something wrong?

Should there be a daily reclaimation process running on this offsite tape 
storage pool?

Should these COPYPOOL_LTO3 tapes which are in the tape library be sent offsite 
as well as the ones that are sent offsite on a daily basis?

What would happen if I deleted the data on one of these COPYPOOL_LTO3 tapes 
which are currently in the tape library?





Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email:  mailto:pdud...@anl.com.au pdud...@anl.com.au










ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

TSM Copypool question

[Paul_Dudley]

We have recently installed TSM 5.5 on a new server and using a new IBM TS3200 
tape library.



It took some time to migrate the data over from the tapes used in the old tape 
library to the new (migrating data from LTO2  LTO3 tapes to LTO4 tapes) but 
that has finally finished.

While that was happening we were performing backups of client servers onto the 
new library, but I was not copying the data from the primary tape storage pool 
to the copypool to send offsite. I now wish to start this process.



Is it possible to perform full backups of each client now to the primary 
storage pool and have the backed up data flagged so that if I start copying the 
data from the primary tape storage pool to the copypool via the backup stg 
command it will only copy the data from the full backups I do now onwards?





Thanks  Regards

Paul



Paul Dudley

ANL Container Line Pty Limited

Email: pdud...@anl.com.au

Web: http://www.anl.com.au












ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Assign scratch volumes to a device class

[Paul_Dudley]

Is it possible to assign scratch volumes to a specific device class? We have 
TSM 5.5 with an IBM TS3200 tape library. It has a mixture of LTO4 and LTO3 
tapes in it.

Various processes keep using LTO4 scratch tapes when I direct them to use LTO3 
tapes, and vice a versa.



For example running the command backup db type=full devclass=lto3class 
scratch=yes will write to an LTO4 scratch tape if one is available. Similarly 
reclaimation processes on LTO4 tapes will grab an LTO3 scratch tape if one is 
available.







Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email: pdud...@anl.com.au












ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

ACO5423E TDPsql error

[Paul_Dudley]

I am getting an error on a couple of Windows 2003 SP2 servers - one has MS 2005 
SQL Express and the other has the full MS 2005 SQL installed.

The TDP SQL client software is version 5.3.3.0 and I have also installed the 
22699_4 patch.



The error is - ACO5423E Microsoft ODBC SQL Server Driver DBNETLIB SQL Server 
does not exist or access denied.



I have gone into SQL Surface area configuration for Services and Connections 
and ensured that Remote Connections are enabled.



Any suggestions?



Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email: pdud...@anl.com.au












ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Backing up Vcenter with TSM

[Paul_Dudley]

We have VM Ware VSphere with VCenter running on a Windows 2003 SP2 server and 
TSM 5.5. Has anyone encountered any problems in using TSM to back up VCenter?



Thanks  Regards

Paul



Paul Dudley

Senior IT Systems Administrator

ANL Container Line Pty Limited

Email: pdud...@anl.com.au












ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named addressees. 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 system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.