Re: SQL query replnodes

[J. Pohlmann]

Hi Eric. This is what I use in an OC report to report daily on nodes that
have NOT replicated for a couple of days. My concern is finding out if nodes
have been unsuccessful in replicating. The lines can just be put into the OC
custom report panel as title and select statement ( two pairs):


List of Nodes with filespaces NOT replicated within two days


select unique(filespaces.node_name)  from filespaces, nodes  where cast
(day(current_timestamp-last_repl_comp) as decimal) >=  2 and
nodes.repl_state = 'ENABLED' and  filespaces.node_name = nodes.node_name



List of Nodes, Filespaces, and last replication completion

select filespaces.node_name, filespaces.filespace_name,
filespaces.last_repl_comp  from filespaces, nodes where cast
(day(current_timestamp-last_repl_comp) as decimal) >=  2 and
nodes.repl_state = 'ENABLED' and filespaces.node_name = nodes.node_name
order by filespaces.node_name, filespaces.filespace_name

Hope this helps.
Regards,
Joerg Pohlmann




-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 05:47
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL query replnodes

Hi Dmitry,

That still doesn't show me if replnodes exist for a specific node...

Kind regards,
Eric van Loon
Air France/KLM Core Infra

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Dmitry
Dukhov
Sent: donderdag 22 september 2022 13:20
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query replnodes

Hi all
Better to use

Select * from nodes where repl_state='NONE'
Repl_state can have three status: none, enabled, disabled

I think it's more correct
Dmitry Dukhov

https://www.tsmexplorer.copm


> On 21 Sep 2022, at 19:28, Rick Adamson  wrote:
>
> Eric,
> Are you looking for something along these lines.?
>
> select node_name,repl_state,repl_mode from nodes where
repl_state='ENABLED' order by node_name
>
>
> -Rick Adamson
>
> -Original Message-
> From: ADSM: Dist Stor Manager  On Behalf Of Oscar
Kolsteren
> Sent: Wednesday, September 21, 2022 11:04 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] SQL query replnodes
>
> * This email originated outside of the organization. Use caution when
opening attachments or clicking links. *
>
> --
> Hey Eric,
>
> Have a look in our data collector which is used to create our FREE IBM CSA
Health Check report.
>
> If you don't have a copy left, let me know and I'll share one. In the
script are all the select statements we use.
>
> Or just run a fresh collection and upload for me to create a new report.
>
> Best Regards,
>
> Oscar Kolsteren
> Lead Storage Consultant, IBM Client Storage Assessment Team (UKI)
>
> -Original Message-
> From: ADSM: Dist Stor Manager  On Behalf Of Loon,
Eric van (ITOP DI) - KLM
> Sent: 21 September 2022 09:16
> To: ADSM-L@VM.MARIST.EDU
> Subject: [EXTERNAL] [ADSM-L] SQL query replnodes
>
> Hi everybody,
>
> I'm trying to find a way to list replnode(s) through a SQL query, does
anybody know where this information can be found? So something like QUERY
RPELNODE , but than through a SQL query.
> Thanks for any help in advance!
>
> Kind regards,
> Eric van Loon
> Air France/KLM Core Infra
> 
> For information, services and offers, please visit our web site:
https://urldefense.com/v3/__http://www.klm.com__;!!NGPcfA!JTtdb1Yf5ThxhIC1O3
cYrHeyiEIrgVH0_Rok2Ohg7oTNaDo4dqQjf-8SOIzzNI3XqQCML321Q7edDLu_uWAa3-n0Lfyc7Q
$. This e-mail and any attachment may contain confidential and
privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message.
>
> Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any delay in receipt.
> Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered
number 33014286
> 
>
> Unless otherwise stated above:
>
> IBM United Kingdom Limited
> Registered in England and Wales with number 741598 Registered office: PO
Box 41, North Harbour, Portsmouth, Hants. PO6 3AU
>
> **CONFIDENTIALITY NOTICE** This electronic message contains information
from Southeastern Grocers, Inc and is intended only for the use of the
addressee. This message may contain information that is privileged,
confidential and/or exempt from disclosure under applicable Law. This
message may not be read, 

Re: IBM Spectrum Protect wiki replaced with new hosting site

[J. Pohlmann]

Hi Kelly. Please provide the links for use. Appreciate the update.

Regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Kelly Axup
Sent: Monday, April 20, 2020 13:08
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] IBM Spectrum Protect wiki replaced with new hosting site

Just wanted to let everyone know in case you hadn't heard...

 The IBM Spectrum Protect wiki has been replaced with a new hosting site:
 Supplemental information and resources for the IBM Spectrum Protect
product family

 The new site provide links to key documents for the IBM Spectrum Protect
product family, including Blueprints for product deployment, white papers
for product integration, guidelines for container storage pools, a video
library, and answers to frequently asked questions.

 Take care everyone!



Kelly Axup - IBM Spectrum Protect Information Development
+++\


Email: ka...@us.ibm.com

Re: more sophisticated way to delete nodes that are replicated?

[J. Pohlmann]

Even simpler if you define the source server to itself and create a server 
group called both with group members of the source and target servers. Then you 
can issue

both:rem replnode 
both:decomm node  

J. Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bjørn 
Nachtwey
Sent: Friday, December 14, 2018 04:37
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] more sophisticated way to delete nodes that are replicated?

Dear all,

i just started to use replication and it looks to be a good approach to 
replace the copy pools i till now.

But one point seems to become much more complicated: deleting nodes.
The only way i see up to now takes some steps and two times to log on:

log on to the primary server:
1) rem repln 
2) decom n 

log on to the repl server:
3) rem repln 
4) decom n 

but how to simplify this?
i tried to put the commands in script, doing step 3 and 4 using command 
routing, but it does not work.

So:
Does anybody know a more sophisticated approach?

=> perfectly it would work with a single command / script call :-)

thanks in advance
Bjørn



-- 
--
Bjørn Nachtwey

Arbeitsgruppe "IT-Infrastruktur“
Tel.: +49 551 201-2181, E-Mail: bjoern.nacht...@gwdg.de
--
Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG)
Am Faßberg 11, 37077 Göttingen, URL: http://www.gwdg.de
Tel.: +49 551 201-1510, Fax: +49 551 201-2150, E-Mail: g...@gwdg.de
Service-Hotline: Tel.: +49 551 201-1523, E-Mail: supp...@gwdg.de
Geschäftsführer: Prof. Dr. Ramin Yahyapour
Aufsichtsratsvorsitzender: Prof. Dr. Norbert Lossau
Sitz der Gesellschaft: Göttingen
Registergericht: Göttingen, Handelsregister-Nr. B 598
--
Zertifiziert nach ISO 9001
--

v8.1.5 client anomaly detection

[J. Pohlmann]

Is there any way to influence the client anomaly detection algorithm? I have
clients where the amount of data backed up varies a fair bit and routinely
there are anomaly detection alerts when the client behaviour is actually
normal. These alerts need to be ignored, or there needs to be a setting for
these clients to indicate that the apparent abnormal behaviour is actually
normal.



Regards,

Joerg Pohlmann

SP 815 Tiering to clound - file selection

[J. Pohlmann]

Does anyone have an idea on how to predict the number of file that might get
tiered? I used



select count(*) from backups where  (cast
(day(current_timestamp-backup_date) as decimal) >= 30)



and it turns out that the number of files is much larger when the tiering
processes are running.



Regards,

Joerg Pohlmann

Re: spectrum protect documentation

[J. Pohlmann]

Actually the location for publications of all of the Spectrum Protect zip
packages is at ftp://public.dhe.ibm.com/software/products/ISP/current/ - the
zip packages for TSM are at
ftp://public.dhe.ibm.com/software/products/TSM/current/ - pick the release
zip package you need. The Knowledge Center will leads you to these locations
as well. Unfortunately, I cannot help with Braille or audio versions.
Perhaps someone closer to development can make a suggestion.

Regards',
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Marc Lanteigne
Sent: Tuesday, March 13, 2018 07:04
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] spectrum protect documentation

When you go on the Knowledge Center, you have the option to download .PDF.

https://www.ibm.com/support/knowledgecenter/SSEQVQ_8.1.4/tsm/welcome.html

The last bullet under "Getting Started" is a link to PDFs.  If you want a
different version, click the "Change Version" drop down.

-
Thanks,
Marc...

Marc Lanteigne
Accelerated Value Specialist for Spectrum Protect


-Original Message-
From: Lee, Gary [mailto:g...@bsu.edu]
Sent: Tuesday, March 13, 2018 10:57 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] spectrum protect documentation

Went searching for the spectrum protect client documentation.
Wanted to find in pdf for conversion to braille or audio formats.

Every link to the knowledge center I find takes me to a disqus page that
appears to have nothing useful on it.


Is this a function of Chrome, screen reader / browser interaction, or just
operator error?
If the latter, how do I operate this page?

Thanks for any help.

Re: 8.1.2 client and 7.1.7 servers

[J. Pohlmann]

I have tried an 8.1.2 client on an 8.1.1.0 server, and as in your case, it 
worked fine. Then, when I upgraded the server to 8.1.2, the client stopped 
working until I ran dsmcert.exe on my Windows client machine to install the 
certificate. After that, the client worked. I  have not tried this scenario 
with UNIX. If anyone has any experience, please let us know.

I am also concerned as to what needs to be done with "really old" clients. I 
have some installations that are running v5 and v6 clients due to old OS 
levels. Again, if anyone has any experience, I would appreciate knowing.

Best regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: Monday, October 02, 2017 13:21
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] 8.1.2 client and 7.1.7 servers

I want to revisit this thread.  Unbeknownst to me, many of my co-workers have 
installed 8.1.2.0 (both Windows and Linux systems), totally ignoring
my email that said not to.   However, we have not experienced any
disruptions in communications, in contradiction to IBM's dire warning that said 
not to upgrade clients to 8.1.2.0 before first upgrading the servers to 8.1.2.0 
(now 8.1.3.0).

Can someone from IBM explain the details behind the dire warning and perhaps 
explain what combination of server/client will NOT work if someone installs 
8.1.2.x client?

We aren't running any kind of TLS between our servers, although moving to TLS 
is on the horizon due to a big PCI projects that will totally isolate such 
servers and even require me to stand up a lone, isolated SP server within the 
PCI walled-garden/network.

On Tue, Aug 29, 2017 at 6:08 PM, Remco Post  wrote:

> What is totally clear to me is that the entire transition to TLS1.2 
> all the way is potentially messy. We possibly have to remove server 
> definitions in an enterprise setup, communications might (or might 
> not) break, and in any case an extra server restart is required after 
> everything has been upgraded.
>
> What is not clear to me is what will and will not be encrypted by the 
> TLS once it is in place? Will that be everything, all server 2 server 
> and client 2 server comms? And if so, what can we expect the impact on 
> the CPU load to be? Our servers move a substantial amount of data 
> every night ( 50
> - 100 TB each ) how many CPU’s should we be adding?
>
> And then the administrators… really, is there no way to guarantee that 
> an admin can connect to the server using a downlevel client once he 
> has used TLS? At least in my world the server and OC get upgraded by 
> one team, while the client is managed by a different team, each at their 
> discretion.
>
> > On 29 Aug 2017, at 15:24, Mikhail Tolkonyuk 
> wrote:
> >
> > You must update server certificate to SHA-256 before upgrading 
> > clients
> or disable SSL in dsm.opt on all of them.
> >
> > BAC 8.1.2 remembers server certificate and uses TLS by default, it 
> > will
> work with old 7.1.x SHA-1 (or MD5) certificate until you upgrade 
> server and OC to 8.1.2. During upgrade server generates new SHA-256 
> certificate and clients no more able to connect to "untrusted server" with 
> new certificate.
> > As workaround you can remove dsmcert.idx, dsmcert.kdb, dsmcert.sth 
> > files
> from client folder and reset transport method for node after server 
> update, but it's much easier to solve the issue in advance.
> >
> > Check the default cert with the following command:
> > gsk8capicmd_64 -cert -list -db C:\tsminst1\cert.kdb -stashed
> >
> > For more details watch Tricia's video about TLS 1.2:
> > https://youtu.be/QVPrxjmo_aU
> >
> > And see technote 2004844:
> > https://www-01.ibm.com/support/docview.wss?uid=swg22004844
> >
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
> > Behalf
> Of Zoltan Forray
> > Sent: Tuesday, August 22, 2017 4:03 PM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: [ADSM-L] 8.1.2 client and 7.1.7 servers
> >
> > Has anyone tried using the latest 8.1.2 clients with 7.1.7 servers?  
> > I
> haven't had the chance to test such a configuration (since my lone 
> test server is at 8.1.1) and with the dire-warnings in the readme 
> docs, I made sure everyone on my staff knows to NOT install 8.1.2 clients.
> >
> > From the readme/docs:
> >
> > Upgrade your IBM Spectrum Protect™ servers to Version 8.1.2 before 
> > you
> upgrade the backup-archive clients.
> >
> >
> >
> > If you do not upgrade your servers first, communication between 
> > servers
> and clients might be interrupted.
> >
> >
> > --
> > *Zoltan Forray*
> > Spectrum Protect (p.k.a. TSM) Software & Hardware Administrator 
> > Xymon
> Monitor Administrator VMware 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 

Re: tsm ops center 7.1.7 question

[J. Pohlmann]

When you log on to the OC for the first time, or any other time subsequently, 
use your normal TSM Admin ID and password. Make sure you specify the IP of the 
hub server on the logon panel because by default it has localhost on the panel. 
The _OC_ Admin ID will be created by the OC when you are going through the 
initial configuration.

Best regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: Thursday, September 28, 2017 08:06
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm ops center 7.1.7 question

Since I don't use the OPS center, not sure if this is correct.  From this
page:

https://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.7/srv.install/c_oc_inst_admin_ids_and_passwords.html

*When you initially configure the hub server, an administrator ID named 
IBM-OC-server_name is registered with system authority on the hub server and is 
associated with the initial password that you specify.*

On Thu, Sep 28, 2017 at 10:54 AM, Lee, Gary  wrote:

> Just installed ops center 7.1.7.
>
> First question, what is the user id used to log in for the first time 
> to configure.
>
> Looked through the server install guide, don't see it listed.
> The install asked for a password, but never hinted at the user id to 
> go with it.
>
> Thanks for the assistance.
>



--
*Zoltan Forray*
Spectrum Protect (p.k.a. TSM) Software & Hardware Administrator Xymon Monitor 
Administrator VMware 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://phishing.vcu.edu/

Re: [EXTERNAL] Re: [ADSM-L] sp 8.1.2

[J. Pohlmann]

Hi Zoltan. I suppose the approach now for a helpdesk is to have the helpdesk 
folks have root access, have X11/Xwindows installed on the client, and then if 
the helpdesk uses Windows, have MobaXterm or similar to provide access to dsmj. 
On Windows, RDP or TeamViewer or similar might be the solution. I find that 
usually in UNIX/Linux environments that people have used the Web Client. If 
anyone has a simpler solution than root access and X11+Xwindows client, I would 
appreciate hearing about it.

Regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Shawn 
Drew
Sent: Wednesday, August 09, 2017 10:12
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] [EXTERNAL] Re: [ADSM-L] sp 8.1.2

www.ibm.com/support/knowledgecenter/SSEQVQ_8.1.2/client/r_new_for_version.html

"You can no longer use the web client to connect to IBM Spectrum Protect V8.1.2 
or later"

On Aug 9, 2017, 1:04 PM -0400, Zoltan Forray , wrote:
> Say what? If there is no longer a web-client interface, that will 
> totally destroy our current process of having 1-server with 40-TSM 
> clients/nodes and all access for restores is via the web-interface. 
> Can you point me to the document you are referring to?
>
> On Wed, Aug 9, 2017 at 12:53 PM, Shawn Drew  wrote:
>
> > Geez, just read the client section. The web client is deprecated, 
> > which means ndmp is a command-line-only thing now?
> >
> > On Aug 9, 2017, 12:34 PM -0400, Shawn DREW 
> > ,
> > wrote:
> > > Probably just referring to the documentation:
> > >
> > > https://www.ibm.com/support/knowledgecenter/en/SSEQVQ_8.1.
> > 2/srv.common/r_wn_tsmserver.html
> > >
> > >
> > > -Original Message-
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
> > > Behalf
> > Of Zoltan Forray
> > > Sent: Wednesday, August 09, 2017 11:51 AM
> > > To: ADSM-L@VM.MARIST.EDU
> > > Subject: [EXTERNAL] Re: [ADSM-L] sp 8.1.2
> > >
> > > I am curious how you got 8.1.2? I just searched and it isn't on 
> > > the FTP
> > site or Passport? Are you a beta tester?
> > >
> >
>
>
>
> --
> *Zoltan Forray*
> Spectrum Protect (p.k.a. TSM) Software & Hardware Administrator Xymon 
> Monitor Administrator VMware 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

Re: doing something like an incremental restore

[J. Pohlmann]

Gary, you can use -if newer on the restore. 

Best regards
Joerg Pohlmann

> On Jun 21, 2017, at 12:23, Lee, Gary  wrote:
> 
> Working on a strange project.
> 
> First, I have a windows server with a 13 TB filesystem which nees to be 
> copied to another server.
> 
> Given our network circomstances, (server is 60 miles away), it was quicker to 
> restore its data to a local machine.
> However, there may have been changes while that was restoring.
> So, how to restore only changed or added data?
> 
> Replace=no is not the answer, but didn't see anything better in the client 
> manual?
> 
> Client version 7.1.6.
> 
> Thanks for any suggestions.

Re: Protect Storage Pool and Replicate Node Process Issuance

[J. Pohlmann]

Hi David. I have a customer where we have implemented a similar approach.
The environment is significantly smaller than yours. Our daily maintenance
script, which was originally based on the Admincenter is shown below.  I
still prefer to have a scheduled daily maintenance script that performs all
daily housekeeping functions as opposed to a myriad of schedules performing
one function at a time and manually managing timings for the completion of
the individual administrative command schedules.



Name   Line   Command

   Number

-- --


MAINTENAN- 5  backup db devclass=VV  type=full wait=yes

CE_PLAN_-

CUSTOM

   10 prepare  source=dbbackup devcl=VV wait=YES

   15 protect stg backupcontainer w=y

   20 replicate node * maxsess=10 wait=yes

   25 EXPIRE INVENTORY SKIPDIRS=NO WAIT=YES RESOURCE=40

   30 reclaim stgpool ARCHIVETAPE threshold=50

   35 reclaim stgpool VVTAPE threshold=50

   40 mig stg archivepool lo=0

   45 mig stg vvpool lo=0

   50 del volhist type=all todate=-30



We still use virtual volumes for the DBB even though you can make a good
argument that the DBB is less important in a fully synchronized container
storage pool environment and can be put on a local file system (as in the
8.1 Blueprint). The nice thing about virtual volumes is that DRM manages the
DBB and RPF expiration. This server pair is at 7.1.6 and we have not had any
problems with directory container pools, nor moving containers to different
file systems (analogous to moving file device class volumes).



Best regards,

Joerg Pohlmann



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
David Beardsley
Sent: Tuesday, May 09, 2017 05:45
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Protect Storage Pool and Replicate Node Process Issuance



Hello All,

  We are currently in the process of implementing node replication in our
environment.  We have an onsite server onsite, and one about 200 miles away
as our replication target.



Our implementation plan has been to start a "protect stg" for our container
pools in the morning when the majority of our backups are done, allow that
to complete, then later in the day run a "replicate node" command.



This seems like it should work to me, and I started by creating scripts to
run the protect storage pool and been running the replicate node command for
a few days by hand for a few reasons.  But since we have our processes
hammered out, the protect storage pool continued to run without issue, but
when the script issued the "replicate node * " command it crashed the
server.



I am curious to see what implementation specs others have or are looking at
in regards to implementing replication.



Now for some details on the instance that experienced the issue, note our
replication server is running the same OS and TSM server version:



Operating systems: Redhat 6.1

TSM server version: 7.1.7.100

Number of nodes: just over 1600

Nodes currently enabled for replication: about 5





Thanks

David Beardsley

Cornell University

Re: Questions related to Container pools

[J. Pohlmann]

Hi Del. W,r,t  Arnaud's q1 - perhaps you could convince your colleagues to
also open container storage pools for virtual volume (that is the archive
objects at the target server). I have some folks that like the idea of
backing up the database to VVs and also to produce the recovery plan file on
VVs, That way, the DRM set spcifications automate the retention of DBB and
RFP objects. Right now, they are using file device class volumes to store
the archive objects that back the VVs.

Best regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del
Hoobler
Sent: Thursday, May 04, 2017 10:26
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Questions related to Container pools

Hi Arnaud,

For question #1 ... The reason the information is in the document is because
Spectrum Protect restricts it. Stay tuned though, this could be allowed
soon.

For question #2 ... The only reason we recommend using 1 pool is strictly
for the best possible deduplication rates AND the because container pools
can grow much larger in size than its legacy counterparts. For legacy pools,
the housekeeping that was required on the pool made it impossible to grow a
pool too large (identify, reclamations, etc..). With container pools, this
is no longer an issue, so we wanted to call that out. If you want to split
container pools up, knowing the potential dedup rates fallout, that's
perfectly fine ... there are no other repercussions/issues. We have a lot of
customers who have done this, primarily around the partitioning of data
sources (VE, TDPs, BA, etc.)

Thank you,

Del

=


"ADSM: Dist Stor Manager"  wrote on 05/03/2017
10:47:52 AM:

> From: PAC Brion Arnaud 
> To: ADSM-L@VM.MARIST.EDU
> Date: 05/03/2017 10:49 AM
> Subject: Questions related to Container pools Sent by: "ADSM: Dist
> Stor Manager" 
>
> Hi Team !
>
> IBM recently released an interesting document summarizing best
> practices with regards to container storage pools (https://
> www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli
> Storage Manager/page/Container Pool Best Practices ) and some of the
> information in it triggered two questions, which I would like some
> Spectrum Protect insider (Del ?) or anyone having good knowledge of
> this to answer ...
>
> First question :  page 14 of the PDF document, chapter 1.4 , states
> that it is not appropriate to use container pools in the case of NDMP
> backups. What is the reason for it ? My understanding is that it is
> possible to make use of NDMP without a tape based storage pool, thus I
> don't get the point here ...
>
> Second question : several references in the book are seeming to stress
> that one should make use of ONE SINGLE container storage pool for a
> whole TSM server (chapter 1.2.5.1.2 page 13, chapter 1.5.1 page 15). I
> do understand that deduplication is made at storage pool level, and
> that segregating backup data in several storage pools will weaken
> deduplication rates, but are there some other reasons which are not
> explained in the book, that would justify the use of only ONE
> container pool (like more hammering on the TSM DB during backup times
> if we make use of several storage pools, or others I did not think
> about) We plan to build a new TSM environment which will be based only
> on container storage pool(s ?), and I feel kind of uncomfortable to
> send all of my data in the same bucket (less granularity for
> reporting, auditing, protecting and so on ...).  Does someone have
> arguments (pro or cons) or experience to share about this ?
>
> Thanks in advance for your feedback !
>
> Cheers.
>
> Arnaud
>
>

**
> Backup and Recovery Systems Administrator Panalpina Management Ltd.,
> Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002
> Basel/CH
> Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
> Direct: +41 (61) 226 19 78
> e-mail: arnaud.br...@panalpina.com
> This electronic message transmission contains information from
> Panalpina and is confidential or privileged. This information is
> intended only for the person (s) named above. If you are not the
> intended recipient, any disclosure, copying, distribution or use or
> any other action based on the contents of this information is strictly
> prohibited.
>
> If you receive this electronic transmission in error, please notify
> the sender by e-mail, telephone or fax at the numbers listed above.
Thank you.
>

**
>

Re: server script to find what schedules a node is associated with?

[J. Pohlmann]

Try q sch * * no=

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Dury, John C.
Sent: Tuesday, October 04, 2016 12:47
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] server script to find what schedules a node is associated
with?

Anyone have any idea how to query a TSM server (v6 or v7) to find what
backup schedules a node is associated with? I'm trying to do the reverse of
a "q assoc" command and looking for  way to supply a node parameter to a
script and have the TSM server tell me it is in the following list of
schedules.
.

Re: SP 7.1.5 and tape preemption

[J. Pohlmann]

Thanks Roger. Looks like it's PMR time with support.

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Roger Deschner
Sent: April 17, 2016 11:18
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SP 7.1.5 and tape preemption

There seems to be a more overall issue with preemption not happening when it
should in Whatchamacallit 7.1.*. A few days ago, there was a posting here
that Client Restore was not preempting BACKUP STGPOOL.

DBB _must_ be able to preempt anything else, in order to prevent a log
fillup crash.

Roger Deschner  University of Illinois at Chicago rog...@uic.edu
==I have not lost my mind -- it is backed up on tape somewhere.=


On Fri, 15 Apr 2016, J. Pohlmann wrote:

>IHAC where we just upgraded to SP 7.1.5.000 and LTO7. It used to be
>that a DBB pre-empted space reclamation for a mount point. I have had
>the DBB waiting for a mount point for several hours. The q opt output
>shows NOPREMPT
>(No) - the default. Has anyone else noticed this changed behavior?
>
>
>
>Best regards,
>
>Joerg Pohlmann
>
>+1-250-585-3711
>

SP 7.1.5 and tape preemption

[J. Pohlmann]

IHAC where we just upgraded to SP 7.1.5.000 and LTO7. It used to be that a
DBB pre-empted space reclamation for a mount point. I have had the DBB
waiting for a mount point for several hours. The q opt output shows NOPREMPT
(No) - the default. Has anyone else noticed this changed behavior?



Best regards,

Joerg Pohlmann

+1-250-585-3711

Re: Spectrum Protect 7.1.5.100

[J. Pohlmann]

Thanks for the repliy. Also Rick.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: April 13, 2016 10:41
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Spectrum Protect 7.1.5.100

I got this from the README on the FTP server. Go to this page:
http://www-01.ibm.com/support/docview.wss?uid=swg21979249

*APARs fixed in Level 7.1.5.100*

*APAR*
*Operating System/Release*
*of Reported Issue*
* (APAR, CompId, Rel)*
*Abstract*
IT14019 <http://www.ibm.com/support/docview.wss?uid=swg1IT14019> IT14019 
5698ISMSV 71W "ANRD_2077889187 SMREPLSERVERSESSION" AND "REPLICATION
IT14101 <http://www.ibm.com/support/docview.wss?uid=swg1IT14101> IT14101 
5698ISMSV 71L SERVER PROCESSES MIGHT HANG WHILE ADMSERVERMONITORTHREAD IS
IT14233 <http://www.ibm.com/support/docview.wss?uid=swg1IT14233> IT14233 
5698ISMSV 71W CANCELLED/FAILED PROTECT STGPOOL CREATES ORPHANED CHUNKS ON
IT14353 <http://www.ibm.com/support/docview.wss?uid=swg1IT14353> IT14353 
5698ISMSV 71A NON-EMPTY CONTAINERS IN S3 POOLS MAY BE DELETED WHEN FIRST C
IT14388 <http://www.ibm.com/support/docview.wss?uid=swg1IT14388> IT14388 
5698ISMSV 71A MEMORY LEAK IN SDREPL.C


On Wed, Apr 13, 2016 at 1:23 PM, J. Pohlmann <jpohlm...@shaw.ca> wrote:

> I just received My Notification for the new patch level. Could someone 
> please tell me what's new/fixed in the patch level? Neither the My 
> Notifications link nor the README on the ftp server tells me anything 
> about the APARS fixed. The ftp site README leads to some search link 
> only. The link from My Notifications only shows the fixes for 7.1.5.000.
>
>
>
> Thanks.
>
>
>
> Joerg Pohlmann
>



--
*Zoltan Forray*
TSM Software & Hardware Administrator
Xymon Monitor Administrator
VMware Administrator (in training)
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

Spectrum Protect 7.1.5.100

[J. Pohlmann]

I just received My Notification for the new patch level. Could someone
please tell me what's new/fixed in the patch level? Neither the My
Notifications link nor the README on the ftp server tells me anything about
the APARS fixed. The ftp site README leads to some search link only. The
link from My Notifications only shows the fixes for 7.1.5.000.



Thanks.



Joerg Pohlmann

Re: Real world deduplication rates with TSM 7.1 and container pools

[J. Pohlmann]

If you are using node replication, you could re-replicate the data and get
it compressed (both ways). It may be a bit much work, feasible perhaps for
selected nodes.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del
Hoobler
Sent: March 22, 2016 07:11
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Real world deduplication rates with TSM 7.1 and
container pools

Hi David,

No. Only newly stored data will be compressed.


Del




"ADSM: Dist Stor Manager"  wrote on 03/22/2016
09:41:27 AM:

> From: David Ehresman 
> To: ADSM-L@VM.MARIST.EDU
> Date: 03/22/2016 09:42 AM
> Subject: Re: Real world deduplication rates with TSM 7.1 and container
pools
> Sent by: "ADSM: Dist Stor Manager" 
>
> Del,
>
> After upgrading to 7.1.5 is there a way to get pre-existing container
> data compressed?
>
> David
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> Of Del Hoobler
> Sent: Monday, March 21, 2016 5:53 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Real world deduplication rates with TSM 7.1 and
> container pools
>
> I think most of you know Spectrum Protect just added in-line
> compression

> to the container and cloud deduplicated pools in version 7.1.5:
>
>
> https://urldefense.proofpoint.com/v2/url?
> u=http-3A__www.ibm.com_support_knowledgecenter_SSGSG7-5F7.1.
>
5_srv.common_r-5Ftechchg-5Fsrv-5Fcompress-5F715.html=AwIFAg=SgMrq23dbjbG
X6e0ZsSHgEZX6A4IAf1SO3AJ2bNrHlk=dOGCMY197NTNH1k_wcsrWS3_fxedKW4rpKJ8cHCD2L
8=OMHhA4Nmsv9Buo24T83zOFo8w4mvoMyvC_nagZn36T0=C4shp8VD_EyXjruT5Lu2v68tMV
pfpzHcluAuRJfaIK0=
>
> Adding incremental forever, the new in-line deduplication - client or
> server-based (7.1.3), new in-line compression (7.1.5) I think you will
> find that Protect continues to drive overall data reduction. This is
being
> done in the software, so you can choose what disk you want to use.
>
> I encourage folks to try out the the new deduplication along with the
new
> compression to see how it helps with the overall data reduction.
>
>
> Thank you,
>
> Del
>
> 
>
>
>
> "ADSM: Dist Stor Manager"  wrote on 03/18/2016
> 10:41:06 AM:
>
> > From: PAC Brion Arnaud 
> > To: ADSM-L@VM.MARIST.EDU
> > Date: 03/18/2016 10:41 AM
> > Subject: Real world deduplication rates with TSM 7.1 and container
pools
> > Sent by: "ADSM: Dist Stor Manager" 
> >
> > Hi All,
> >
> > We are currently testing TSM 7.1 deduplication feature, in
> > conjunction with container based storage pools.
> > So far, my test TSM instances, installed with such a setup are
> > reporting dedup percentage of 45 %, means dedup factor around 1.81,
> > using a sample of clients which are representative of our production
> > environment.
> > This is unfortunately pretty far from what was promised by IBM
> > (dedup factor of 4) ...
> >
> > I'm wondering if anybody making use of container based storage pools
> > and deduplication would be sharing his deduplication factor, so that
> > I could have a better appreciation of real world figures.
> > If you would be so kind to share your information (possibly with the
> > kind of backed-up data  i.e. VM, DB, NAS, Exchange, and retention
> > values ...) I would be very grateful !
> >
> > Thanks in advance for appreciated feedback.
> >
> > Cheers.
> >
> > Arnaud
> >
> >
>

**
> > Backup and Recovery Systems Administrator Panalpina Management Ltd.,
> > Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002
> > Basel/CH
> > Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
> > Direct: +41 (61) 226 19 78
> > e-mail:
> > arnaud.br...@panalpina.com
> > This electronic message transmission contains information from
> > Panalpina and is confidential or privileged. This information is
> > intended only for the person (s) named above. If you are not the
> > intended recipient, any disclosure, copying, distribution or use or
> > any other action based on the contents of this information is
> > strictly prohibited.
> >
> > If you receive this electronic transmission in error, please notify
> > the sender by e-mail, telephone or fax at the numbers listed above.
> Thank you.
> >
>

**
> >
>

Re: Bring back TSM Administrator's Guide

[J. Pohlmann]

Hi Clare. The Admin Guide provided a one-stop shopping approach to all
functional areas of Spectrum Protect. I think this is what's missing from
the current documentation. Clearly the Admin Guide was aimed at an
experienced person as opposed to a novice. In an initial Spectrum Protect
implementation, the Solutions Guides are of value. However they fall short
in supplying guidance and "how-to" or "setup" information to an existing
installation. So, even though the Admin Guide became bigger over the
releases, the topics are still of extreme value. For example tape is still
aa viable media, especially in the light of LTO 7 technology. It fits into
large to very large enterprises, yet when it comes to media management of
disaster protection implementation, we have no guidance in the new
publications. So, I would vote for the return of the Admin Guide, it still
is the best collection of implementation and usage guidance for all the
various Spectrum Protect aspects. I would prefer one book to a large set of
publications that are topic oriented.

Best regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Clare Byrne
Sent: December 15, 2015 13:59
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Bring back TSM Administrator's Guide

Please be assured that we in IBM development are listening and are
discussing future actions regarding the Administrator's Guide content since
the feedback about the 7.1.3 release that did not include that book.
I gave some information in a response to that earlier feedback:
http://www.mail-archive.com/adsm-l@vm.marist.edu/msg99286.html

We are working on a plan to publish a solution guide for the disk-to-tape
architecture next. This should fill in some gaps left by the removal of the
Administrator's Guide. Timing of the publication is yet to be determined.

We are also discussing how to fill the information needs for those who will
not be using one of the four documented architectures. We already point to
the 7.1.1 guides from newer releases but we realize this is not ideal.
Possible actions include creating additional, supplemental information
outside of the solution guides, similar to what we have done for the
information about NDMP (
http://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.4/srv.admin/r_ndmp.htm
l
).

What are the most important subjects from the old Administrator's Guide for
us to consider? Knowing more specifics about your priorities would be very
helpful to us for setting our priorities and plans. Web traffic for the
content on IBM Knowledge Center gives us some information but not a complete
picture of needs.

Meanwhile, to make the 7.1.1 Administrator's Guide PDFs easier to find and
download, today we added the five English PDFs to the Tivoli Storage Manager
wiki. Find the links to them on this page:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivol
i%20Storage%20Manager/page/Version%207.1.1%20PDF%20files%20of%20IBM%20Tivoli
%20Storage%20Manager%20documentation

The 7.1.1 Administrator's Guide PDFs are also still available in the
711_411_PDFs.zip file that you can find at
ftp://public.dhe.ibm.com/software/products/TSM/current/
The available translations are in the 711_411_PDFs_nl.zip file in the same
directory. All this content (English and other languages) remains available
online in IBM Knowledge Center at
http://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.1/com.ibm.itsm.srv.com
mon.doc/t_server_main.html

PDFs for previous releases, including several unsupported levels, are also
still available. Start on this page:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivol
i%20Storage%20Manager/page/PDF%20documentation

(Note: This wiki was unavailable for several days, starting on 11 December.
While the wiki is available again, restoration of some pages and links is
still in progress. Unfortunately you might find some links that don't work,
especially for the unsupported releases. I don't know the projected date for
completion.)

Clare Byrne
Information Development for IBM Spectrum Protect Tucson, AZ  US

Re: Bring back TSM Administrator's Guide

[J. Pohlmann]

Fully agree.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Roger Deschner
Sent: December 11, 2015 17:39
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Bring back TSM Administrator's Guide

A great book is gone. The TSM Administrator's Guide has been obsoleted as of
v7.1.3. Its priceless collection of how-to information has been scattered to
the winds, which basically means it is lost. A pity, because this book had
been a model of complete, well-organized, documentation.

The "Solution Guides" are suitable only for planning a new TSM installation,
and do not address existing TSM sites. Furthermore, they are much too
narrow, and do not cover real-world existing TSM customers.
For instance, we use a blended disk and tape solution (D2D2D2T) to create a
good working compromise between faster restore and storage cost.

Following links to topics in the online Information Center is a haphazard
process at best, which is never repeatable. There is no Index or Table of
Contents for the online doc - so you cannot even see what information is
there. Unless you actually log in, there is no way to even leave a "trail of
breadcrumbs". Browser bookmarks are useless here, due to IBM's habit of
changing URLs frequently. This is an extremely inefficient use of my time in
finding out how to do something in TSM.

Search is not an acceptable replacement for good organization. Search is
necessary, but it cannot stand alone.

Building a "collection" is not an answer to this requirement. It still lacks
a coherent Index or Table of Contents, so once my collection gets sizeable,
it is also unuseable. And with each successive version, I will be required
to rebuild my collection from scratch all over again.

Despite the fact that it had become fairly large, I humbly ask that the
Administrator's Guide be published again, as a single PDF, in v7.1.4.

Roger Deschner  University of Illinois at Chicago rog...@uic.edu
==I have not lost my mind -- it is backed up on tape somewhere.=

Re: Activate SKLM on existing TS3500 partition

[J. Pohlmann]

Ben, most of my customer with LTO 4 or higher drives use TSM (application) 
managed encryption. It's simple to implement and there is no cost for licensing 
or additional software (ISKLM).
Regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Alford, Ben
Sent: October 21, 2015 12:57
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Activate SKLM on existing TS3500 partition

ADSM folk - we have interested in tape encryption too but have not yet started. 
   Since our drives are only used by TSM, what are the pros/cons of using SKLM 
vs. the free TSM application support for encryption?

Ben Alford
University of Tennessee

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Plair, 
Ricky
Sent: Wednesday, October 21, 2015 3:45 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Activate SKLM on existing TS3500 partition

Hey Maurice,

Did anyone reply to your email?

We are performing about the same thing. We have the SKLM server built and we 
are migrating from EKM.

Rick

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Maurice van 't Loo
Sent: Wednesday, October 14, 2015 8:29 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Activate SKLM on existing TS3500 partition

Friends,

We currently have TSM 7.1.1.3 with TS3500's and LTO6 drives in use.
SLKM server is build and tested successfully.

Now we want to activate tape encryption.

Can we just activate it on the library partition that is already in use?
Will it start using encryption when a new scratch tape is used? Or when we 
relabel a volumes?  (relabel scratch)

Thanks,
Maurice van 't Loo

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
CONFIDENTIALITY NOTICE: This email message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information and/or Protected Health Information (PHI) subject to 
protection under the law, including the Health Insurance Portability and 
Accountability Act of 1996, as amended (HIPAA). If you are not the intended 
recipient or the person responsible for delivering the email to the intended 
recipient, be advised that you have received this email in error and that any 
use, disclosure, distribution, forwarding, printing, or copying of this email 
is strictly prohibited. If you have received this email in error, please notify 
the sender immediately and destroy all copies of the original message.

Re: Version 7.1.3

[J. Pohlmann]

Karel, your reference is to 6.1 - note the fix in 6.1.3 - it was supported but 
in many cases you did not get a great dedup percentage. My test was for a 7.1.3 
environment with directory container storage pools. 

Virtual volumes are still very useful for TSM database backups and storing 
Recovery Plan Files at another TSM server. For client data protection, I will 
always prefer node replication.

Regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel 
Bos
Sent: September 30, 2015 00:27
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Version 7.1.3

Hi,

Storing virtual volumes in a dedup pool is not supported. It was not restricted 
but 

http://www-01.ibm.com/support/docview.wss?uid=swg1IC64970

Kind regards,

Karel

2015-09-23 20:44 GMT+02:00 J. Pohlmann <jpohlm...@shaw.ca>:

> So far only in a lab environment. Found that, when using directory 
> container storage pools, only node type=client data works. For my node 
> type=server, the attempt to store data in the directory container pool 
> failed. Sounds like a restrictions that you can't store virtual volume 
> data (the archive
> objects) at the target server in a directory container pool. Storing 
> the archive objects for virtual volumes in a deduped file device class 
> storage pool works as before.
>
> Regards,
> Joerg Pohlmann
>
> 09/22/2015 13:05:39  ANR0406I Session 111 started for node VVVISTA
> (Windows)
>   (Tcp/Ip W2K8-TSM63(49256)). (SESSION: 111)
> 09/22/2015 13:05:50  ANR2776W Transaction failed for session 111 for
> node
>   VVVISTA (Windows) - A storage pool for the target
>   destination is associated with a container 
> or cloud
>   storage pool. (SESSION: 111)
> 09/22/2015 13:06:36  ANR0403I Session 111 ended for node VVVISTA
> (Windows).
>   (SESSION: 111)
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
> Of Robert Ouzen
> Sent: September 23, 2015 03:59
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Version 7.1.3
>
> Hello All
>
> I wonder if people  , already upgrade to version 7.1.3 and have 
> comments , appreciation .. I understand that it's a new big concept as 
> STG container for inline dedup.
>
> Anyone use it ? and can share remarks !
>
> T.I.A Robert
>

Re: Client for Windows 10

[J. Pohlmann]

I haven't seen a support statement. Here is my experience (sample of 1 - use
your judgement). My 7.1.2 clients survived the upgrade to Windows 10 just
fine. I have upgraded one Windows 10 client to 7.1.3 by installing over the
7.1.2 client. It was a two-step instaal: 1) install the prereq - then the
installed quit; 2) install the client - the installer now saw the pre-req
and the install went fine. I also set up the services and for the first time
in many months, the Web client/Java worked (wonders never cease to happen).
Backups and restore worked fine. My intent is to upgrade once there is a
7.1.3.x with official support for Windows 10. Maybe the install will then
just be a one-step install.

Regards,
Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Roger Deschner
Sent: September 23, 2015 07:48
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Client for Windows 10

We are starting to get requests for a TSM client to back up Windows 10.
I've been testing V7.1.3 on a 64-bit Windows 10 test machine which
*appears* to work. With Microsoft pushing Windows 10 upgrades as fast as
they can backed by slick television advertizing, and with unhappy Windows
8/8.1 users eager for relief, this is starting to come fast.

When might we see a client version that supports Windows 10? What have
others experienced backing up AND RESTORING Windows 10 with a TSM client?

Roger Deschner  University of Illinois at Chicago rog...@uic.edu
==I have not lost my mind -- it is backed up on tape somewhere.=

Re: Version 7.1.3

[J. Pohlmann]

So far only in a lab environment. Found that, when using directory container
storage pools, only node type=client data works. For my node type=server,
the attempt to store data in the directory container pool failed. Sounds
like a restrictions that you can't store virtual volume data (the archive
objects) at the target server in a directory container pool. Storing the
archive objects for virtual volumes in a deduped file device class storage
pool works as before.

Regards,
Joerg Pohlmann

09/22/2015 13:05:39  ANR0406I Session 111 started for node VVVISTA
(Windows)
  (Tcp/Ip W2K8-TSM63(49256)). (SESSION: 111)
09/22/2015 13:05:50  ANR2776W Transaction failed for session 111 for
node
  VVVISTA (Windows) - A storage pool for the target
  destination is associated with a container or
cloud
  storage pool. (SESSION: 111)
09/22/2015 13:06:36  ANR0403I Session 111 ended for node VVVISTA
(Windows).
  (SESSION: 111)

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Robert Ouzen
Sent: September 23, 2015 03:59
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Version 7.1.3

Hello All

I wonder if people  , already upgrade to version 7.1.3 and have comments ,
appreciation .. I understand that it's a new big concept as STG container
for inline dedup.

Anyone use it ? and can share remarks !

T.I.A Robert

Re: Issued with TDP SQL 7.1.2.0 and 2014 SQL server

[J. Pohlmann]

Hi Zoltan. Here is a clip of the APAR:


IT09192: DATABASE BACKUPS USING DATA PROTECTION FOR SQL CAN CRASH DURING 
PROCESSING WITH REFERENCES TO MODULE CLR.DLL
Description
•   When attempting a legacy backup of a Microsoft SQL database
•   the Tivoli Storage Manager for Databases: Data Protection
•   for Microsoft SQL Server application can crash with the
•   following details when run from the MMC:
•   Problem signature:
• Problem Event Name: BEX64
• Application Name: mmc.exe
• Application Version: 6.1.7600.16385
• Application Timestamp: 4a5bc808
• Fault Module Name: clr.dll
• Fault Module Version: 4.0.30319.17929
• Fault Module Timestamp: 4ffa59b1
• Exception Offset: 003faddb
• Exception Code: c409
• Exception Data: 
• OS Version: 6.1.7601.2.1.0.274.10
• Locale ID: 1033
• Additional Information 1: 3381
• Additional Information 2: 338146cd4c3fffe86b5c5e62544c183c
• Additional Information 3: 936b
• Additional Information 4: 936bc181c072ab550a04c713d644b771
•   
•   When run via the CLI, these details are reported:
•   Problem signature:
• Problem Event Name: BEX64
• Application Name: tdpsqlc.exe
• Application Version: 7.1.2.0
• Application Timestamp: 55102a96
• Fault Module Name: clr.dll
• Fault Module Version: 4.0.30319.17929
• Fault Module Timestamp: 4ffa59b1
• Exception Offset: 003faddb
• Exception Code: c409
• Exception Data: 
• OS Version: 6.1.7601.2.1.0.274.10
• Locale ID: 1033
• Additional Information 1: f566
• Additional Information 2: f56603cc7a58ea5bb439787f63f14af5
• Additional Information 3: f62c
• Additional Information 4: f62c63d10952430866f64bd780cbbed3
•   
•   In either method of execution, the backup is successful, however
•   there will be no summary information in the tdpsql.log or
•   /logfile parameter value.  The backup objects can still be
•   viewed in the recovery tab, or from the 'query tsm' output.
•   Scheduled command operations may not report this crash to the
•   console, but the crash details will be seen in the event logs.
•   Restores of SQL databases using backups created when this crash
•   occurs is possible.
•   
•   Customer/L2 Diagnostics: The DP SQL trace may end abnormally
•   near the entries from SQLAPI-CSqlApi::GetSqlDatabaseNames() or
•   updateProtectSize() funtions:
•   
•   SqlApi.cpp  (1230): SQLAPI-CSqlApi::GetSqlDatabaseNames
•enter 15:11:03
•   SqlApi.cpp  (6847): SQLAPI-CSqlApi::LogonServer 
•   enter 15:11:03
•   SqlApi.cpp  (7237): SQLAPI-CSqlApi::LogonServer 
•   exit rc(0):RC_OK 15:11:03
•   ...
•   backupdb.cpp(2473): Calling DSMUPDATEFS()
•   backupdb.cpp(2491): DSMUPDATEFS() was successful.
•   backupdb.cpp(2505): Exiting updateProtectSize():
•   Returning with rc = 0.
•   
•   
•   The call stack retrieved from the crash dump may show the
•   following call sequence:
•   DBaseEri.ProcessRequest(...) - eriBackupSqlDatabase(...) -
•   updateProtectSize(...) - CSqlApi.GetSqlDatabaseNames(...)
•   
•   Versions Affected: Tivoli Storage Manager for Databases: Data
•   Protection for Microsoft SQL 7.1.2
•   
•   Initial Impact: Medium
•   
•   Additional Keywords: dpsql core wer
•   
Local fix
•   Since the backups are successful, the crash can be ignored.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: July 9, 2015 09:46
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Issued with TDP SQL 7.1.2.0 and 2014 SQL server

On Thu, Jul 9, 2015 at 12:39 PM, J. Pohlmann jpohlm...@shaw.ca wrote:

 IT09192


Thank you for the information.  Unfortunately I can not get to the pertinent 
information.  When I Google that APAR, the link takes me to the IBM Support 
Portal and when I attempt to sign-in, I get a Our apologies...The page you 
requested cannot be displayed - 504 Gateway Timeout

If you can get to it, can you send me the details/description?  IBM seems to be 
having some problems.


--
*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

Re: Issued with TDP SQL 7.1.2.0 and 2014 SQL server

[J. Pohlmann]

Zoltan, you are experiencing  APAR IT09192  - there is an e-fix for the crash 
at program termination. Please not the local fix - ignore the crash. There is 
no patch yet.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: July 9, 2015 08:44
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Issued with TDP SQL 7.1.2.0 and 2014 SQL server

My SQL guy is having some interesting problems/crashes with the latest and 
greatest SQL/TDP

He is running TSM client 7.1.2.0 and was running 7.1.1.2 TDP SQL.

They he started getting error messages and not able to backup mirrored DB's.

*ACO6113I Backup of database 'AMCASV2' is bypassed because it is a mirrored 
database. Database attributes are Normal|AutoClosed.*

So, he install 7.1.2.0 and started having problems with transaction log backups 
at first and now all over.  The TDP would backup 1-database and crash/severely 
disconnect from the TSM server (TSM server is 6.3.5.100 Linux).  Messages like 
this:

07/07/2015 06:27:49 ANS1577I The Windows console event handler received a 
'Shutdown' console event.
07/07/2015 06:27:49 ANS2820E An interrupt has occurred. The current operation 
will end and the client will shut down.

We would also see what looks like memory corruption in the dsmerror.log
files:

07/7//2015 06:37:061:37:2177I S1577I indohe windows colo evole enent hahdlnr 
dlerrreeeived daa 'Shutdotdown' conse eveeven.
t.

07//09/2015 06 :06:6:56 6 ANS157 ThI ehei Wins console s vect hsndle er
receive dana dSlutr rwne eionsvled   'Senhut
down' console event.

He tried everything he could but eventually had to return to TDP 7.1.1.2 to be 
able to backup everything else but the mirrored DB's.

Additional error message in the Windows logs:

Faulting application name: tdpsqlc.exe, version: 7.1.2.0, time stamp:
0x55102a96
 Faulting module name: clr.dll, version: 4.0.30319.34209, time stamp:
0x5348a1ef
 Exception code: 0xc409 Fault offset: 0x00355714 Faulting process 
id:
 0xfec Faulting application start time: 0x01d0b8bf99e51e51 Faulting application
 path: C:\Program Files\Tivoli\TSM\TDPSql\tdpsqlc.exe Faulting module path:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll

Any thoughts / suggestions?  Don't see any patches for TDP SQL 7.1.2, yet.


--
*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

Re: Issued with TDP SQL 7.1.2.0 and 2014 SQL server

[J. Pohlmann]

You will need to open a PMR with IBM and reference this APAR.

Best regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: July 9, 2015 10:08
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Issued with TDP SQL 7.1.2.0 and 2014 SQL server

Thank you for the details.  That definitely seems to be our problem.  Will see 
if I can get through and subscribe for when the APAR is resolved.

You said there was a hot fix.  How would we get it?

On Thu, Jul 9, 2015 at 12:55 PM, J. Pohlmann jpohlm...@shaw.ca wrote:

 Hi Zoltan. Here is a clip of the APAR:


 IT09192: DATABASE BACKUPS USING DATA PROTECTION FOR SQL CAN CRASH 
 DURING PROCESSING WITH REFERENCES TO MODULE CLR.DLL Description
 •   When attempting a legacy backup of a Microsoft SQL database
 •   the Tivoli Storage Manager for Databases: Data Protection
 •   for Microsoft SQL Server application can crash with the
 •   following details when run from the MMC:
 •   Problem signature:
 • Problem Event Name: BEX64
 • Application Name: mmc.exe
 • Application Version: 6.1.7600.16385
 • Application Timestamp: 4a5bc808
 • Fault Module Name: clr.dll
 • Fault Module Version: 4.0.30319.17929
 • Fault Module Timestamp: 4ffa59b1
 • Exception Offset: 003faddb
 • Exception Code: c409
 • Exception Data: 
 • OS Version: 6.1.7601.2.1.0.274.10
 • Locale ID: 1033
 • Additional Information 1: 3381
 • Additional Information 2: 338146cd4c3fffe86b5c5e62544c183c
 • Additional Information 3: 936b
 • Additional Information 4: 936bc181c072ab550a04c713d644b771
 •
 •   When run via the CLI, these details are reported:
 •   Problem signature:
 • Problem Event Name: BEX64
 • Application Name: tdpsqlc.exe
 • Application Version: 7.1.2.0
 • Application Timestamp: 55102a96
 • Fault Module Name: clr.dll
 • Fault Module Version: 4.0.30319.17929
 • Fault Module Timestamp: 4ffa59b1
 • Exception Offset: 003faddb
 • Exception Code: c409
 • Exception Data: 
 • OS Version: 6.1.7601.2.1.0.274.10
 • Locale ID: 1033
 • Additional Information 1: f566
 • Additional Information 2: f56603cc7a58ea5bb439787f63f14af5
 • Additional Information 3: f62c
 • Additional Information 4: f62c63d10952430866f64bd780cbbed3
 •
 •   In either method of execution, the backup is successful, however
 •   there will be no summary information in the tdpsql.log or
 •   /logfile parameter value.  The backup objects can still be
 •   viewed in the recovery tab, or from the 'query tsm' output.
 •   Scheduled command operations may not report this crash to the
 •   console, but the crash details will be seen in the event logs.
 •   Restores of SQL databases using backups created when this crash
 •   occurs is possible.
 •
 •   Customer/L2 Diagnostics: The DP SQL trace may end abnormally
 •   near the entries from SQLAPI-CSqlApi::GetSqlDatabaseNames() or
 •   updateProtectSize() funtions:
 •   
 •   SqlApi.cpp  (1230): SQLAPI-CSqlApi::GetSqlDatabaseNames
 •enter 15:11:03
 •   SqlApi.cpp  (6847): SQLAPI-CSqlApi::LogonServer 
 •   enter 15:11:03
 •   SqlApi.cpp  (7237): SQLAPI-CSqlApi::LogonServer 
 •   exit rc(0):RC_OK 15:11:03
 •   ...
 •   backupdb.cpp(2473): Calling DSMUPDATEFS()
 •   backupdb.cpp(2491): DSMUPDATEFS() was successful.
 •   backupdb.cpp(2505): Exiting updateProtectSize():
 •   Returning with rc = 0.
 •   
 •
 •   The call stack retrieved from the crash dump may show the
 •   following call sequence:
 •   DBaseEri.ProcessRequest(...) - eriBackupSqlDatabase(...) -
 •   updateProtectSize(...) - CSqlApi.GetSqlDatabaseNames(...)
 •
 •   Versions Affected: Tivoli Storage Manager for Databases: Data
 •   Protection for Microsoft SQL 7.1.2
 •
 •   Initial Impact: Medium
 •
 •   Additional Keywords: dpsql core wer
 •
 Local fix
 •   Since the backups are successful, the crash can be ignored.


 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
 Of Zoltan Forray
 Sent: July 9, 2015 09:46
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] Issued with TDP SQL 7.1.2.0 and 2014 SQL server

 On Thu, Jul 9, 2015 at 12:39 PM, J. Pohlmann jpohlm...@shaw.ca wrote:

  IT09192


 Thank you for the information.  Unfortunately I can not get to the 
 pertinent information.  When I Google that APAR, the link takes me to 
 the IBM Support Portal and when I attempt to sign

Re: DP for SQL 7.1.2.0

[J. Pohlmann]

Hi Hans Christian. I don't have any further information than the comment from 
support  (via a customer TSM admin). I have DP for SQL 7.1.2 installed in 
another customer and have not had any problems.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans 
Christian Riksheim
Sent: June 11, 2015 01:55
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DP for SQL 7.1.2.0

We are in the process of upgrading from 7.1.1 to 7.1.2 because of bugs.
Could you tell us something about the new bugs in 7.1.2?

We haven't done the actual upgrade yet since 7.1.2 requires SQL Server 2014 
Management Objects despite us running SQL Server 2012. So we had to convince 
our SQL guys first.

Regards

Hans Chr.

On Thu, Jun 11, 2015 at 12:56 AM, J. Pohlmann jpohlm...@shaw.ca wrote:

 One of my customers has had a recommendation from TSM support not to 
 install DP for SQL 7.1.2.0 as apparently it is buggy and instead 
 wait for 7.1.3 which support said will be available in September. I am 
 just wondering if anyone has heard similar recommendations  or 
 experiences with 7.1.2.0 that would substantiate such a 
 recommendation.



 Regards,



 Joerg Pohlmann

DP for SQL 7.1.2.0

[J. Pohlmann]

One of my customers has had a recommendation from TSM support not to install
DP for SQL 7.1.2.0 as apparently it is buggy and instead wait for 7.1.3
which support said will be available in September. I am just wondering if
anyone has heard similar recommendations  or experiences with 7.1.2.0 that
would substantiate such a recommendation.



Regards,



Joerg Pohlmann

Re: contents of a .bfs empty but q vol says different

[J. Pohlmann]

You might be experiencing this:

http://www-01.ibm.com/support/docview.wss?uid=swg1IC86918



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Jeanne Bruno
Sent: May 1, 2015 12:46
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] contents of a .bfs empty but q vol says different

Hello.  I tried that, but it produce the same results.

tsm: TSMPOK_SERVER1q content m:\ggg_Prim8\x_prim3\0004f.bfs
followlinks=yes ANR2034E QUERY CONTENT: No match found using this criteria.
ANS8001I Return code 11.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of J.
Pohlmann
Sent: Friday, May 01, 2015 3:39 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] contents of a .bfs empty but q vol says different

Hi Jeanne. Try

q content n.bfs followlinks=yes

If you are using deduplication it is likely that with a 2GB volume you only
have chunks for other stuff. Even without deduplication, there may just be a
part of a larfe object on this volume.

Regards,
Joerg Pohlman

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Jeanne Bruno
Sent: May 1, 2015 11:45
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] contents of a .bfs empty but q vol says different

Hello.
TSM server v 6.2.3.0

Has anyone seen this?
When I do a Q VOL on a .bfs file, I get this info:

Estimated Capacity: 2.0 G
   Scaled Capacity Applied:
  Pct Util: 100.0
 Volume Status: Full
Access: Read/Write
Pct. Reclaimable Space: 91.4
   Scratch Volume?: Yes
   In Error State?: No
  Number of Writable Sides: 1
   Number of Times Mounted: 4
 Write Pass Number: 1
 Approx. Date Last Written: 03/27/2015 04:27:20
Approx. Date Last Read: 03/29/2015 20:34:42
   Date Became Pending:
Number of Write Errors: 0
 Number of Read Errors: 0
   Volume Location:
Volume is MVS Lanfree Capable : No
Last Update by (administrator):
 Last Update Date/Time: 03/27/2015 04:16:15
  Begin Reclaim Period:
End Reclaim Period:
  Drive Encryption Key Manager:
   Logical Block Protected: No

But when I do a Q CONTENT on the same .bfs, I get:
ANR2034E QUERY CONTENT: No match found using this criteria.
ANS8001I Return code 11.

(I know my typing is correct as I'm using the 'up arrow' on the console and
only changing the word 'vol' to 'content')

The ReUse on the storage pool is 2 days.
And the RETO is set to 19 days.
So I'm assuming the contents have actually been deleted, but why does the
.bfs files show up at all when I do:  Q VOL * STGPOOL=_prim ?


Jeannie Bruno
Senior Systems Analyst
jbr...@cenhud.commailto:jbr...@cenhud.com
Central Hudson Gas  Electric
(845) 486-5780

Re: contents of a .bfs empty but q vol says different

[J. Pohlmann]

Jim, volume names are only case sensitive for UNIX file names, not Windows.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Schneider, Jim
Sent: May 1, 2015 12:57
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] contents of a .bfs empty but q vol says different

I think BFS is case-sensitive.  Most of TSM is case-insensitive, but this is
a exception.

Jim Schneider

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Jeanne Bruno
Sent: Friday, May 01, 2015 2:46 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] contents of a .bfs empty but q vol says different

Hello.  I tried that, but it produce the same results.

tsm: TSMPOK_SERVER1q content m:\ggg_Prim8\x_prim3\0004f.bfs
followlinks=yes ANR2034E QUERY CONTENT: No match found using this criteria.
ANS8001I Return code 11.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of J.
Pohlmann
Sent: Friday, May 01, 2015 3:39 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] contents of a .bfs empty but q vol says different

Hi Jeanne. Try

q content n.bfs followlinks=yes

If you are using deduplication it is likely that with a 2GB volume you only
have chunks for other stuff. Even without deduplication, there may just be a
part of a larfe object on this volume.

Regards,
Joerg Pohlman

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Jeanne Bruno
Sent: May 1, 2015 11:45
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] contents of a .bfs empty but q vol says different

Hello.
TSM server v 6.2.3.0

Has anyone seen this?
When I do a Q VOL on a .bfs file, I get this info:

Estimated Capacity: 2.0 G
   Scaled Capacity Applied:
  Pct Util: 100.0
 Volume Status: Full
Access: Read/Write
Pct. Reclaimable Space: 91.4
   Scratch Volume?: Yes
   In Error State?: No
  Number of Writable Sides: 1
   Number of Times Mounted: 4
 Write Pass Number: 1
 Approx. Date Last Written: 03/27/2015 04:27:20
Approx. Date Last Read: 03/29/2015 20:34:42
   Date Became Pending:
Number of Write Errors: 0
 Number of Read Errors: 0
   Volume Location:
Volume is MVS Lanfree Capable : No
Last Update by (administrator):
 Last Update Date/Time: 03/27/2015 04:16:15
  Begin Reclaim Period:
End Reclaim Period:
  Drive Encryption Key Manager:
   Logical Block Protected: No

But when I do a Q CONTENT on the same .bfs, I get:
ANR2034E QUERY CONTENT: No match found using this criteria.
ANS8001I Return code 11.

(I know my typing is correct as I'm using the 'up arrow' on the console and
only changing the word 'vol' to 'content')

The ReUse on the storage pool is 2 days.
And the RETO is set to 19 days.
So I'm assuming the contents have actually been deleted, but why does the
.bfs files show up at all when I do:  Q VOL * STGPOOL=_prim ?


Jeannie Bruno
Senior Systems Analyst
jbr...@cenhud.commailto:jbr...@cenhud.com
Central Hudson Gas  Electric
(845) 486-5780

**
Information contained in this e-mail message and in any attachments thereto
is confidential. If you are not the intended recipient, please destroy this
message, delete any copies held on your systems, notify the sender
immediately, and refrain from using or disclosing all or any part of its
content to any other person.

Re: contents of a .bfs empty but q vol says different

[J. Pohlmann]

Hi Jeanne. Try

q content n.bfs followlinks=yes

If you are using deduplication it is likely that with a 2GB volume you only
have chunks for other stuff. Even without deduplication, there may just be a
part of a larfe object on this volume.

Regards,
Joerg Pohlman

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Jeanne Bruno
Sent: May 1, 2015 11:45
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] contents of a .bfs empty but q vol says different

Hello.
TSM server v 6.2.3.0

Has anyone seen this?
When I do a Q VOL on a .bfs file, I get this info:

Estimated Capacity: 2.0 G
   Scaled Capacity Applied:
  Pct Util: 100.0
 Volume Status: Full
Access: Read/Write
Pct. Reclaimable Space: 91.4
   Scratch Volume?: Yes
   In Error State?: No
  Number of Writable Sides: 1
   Number of Times Mounted: 4
 Write Pass Number: 1
 Approx. Date Last Written: 03/27/2015 04:27:20
Approx. Date Last Read: 03/29/2015 20:34:42
   Date Became Pending:
Number of Write Errors: 0
 Number of Read Errors: 0
   Volume Location:
Volume is MVS Lanfree Capable : No
Last Update by (administrator):
 Last Update Date/Time: 03/27/2015 04:16:15
  Begin Reclaim Period:
End Reclaim Period:
  Drive Encryption Key Manager:
   Logical Block Protected: No

But when I do a Q CONTENT on the same .bfs, I get:
ANR2034E QUERY CONTENT: No match found using this criteria.
ANS8001I Return code 11.

(I know my typing is correct as I'm using the 'up arrow' on the console and
only changing the word 'vol' to 'content')

The ReUse on the storage pool is 2 days.
And the RETO is set to 19 days.
So I'm assuming the contents have actually been deleted, but why does the
.bfs files show up at all when I do:  Q VOL * STGPOOL=_prim ?


Jeannie Bruno
Senior Systems Analyst
jbr...@cenhud.commailto:jbr...@cenhud.com
Central Hudson Gas  Electric
(845) 486-5780

Re: So long, and thank you...

[J. Pohlmann]

Hi Wanda. All the best for your retirement.

Best regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: April 3, 2015 14:10
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] So long, and thank you...

This is my last day at ICF, and the first day of my retirement!

I'm moving on to the next non-IT-support chapter in life.


I can't speak highly enough of the people who give of their time and
expertise on this list.

I've learned most of what I know about TSM here.


You all are an amazing group, and it has been a  wonderful experience in
world-wide collaboration.


Thank you all!


Best wishes,

Wanda

Re: TSM level for deduplication

[J. Pohlmann]

FYI - 7.1.1.000 is still on the FTP site. 7.1.1.100 is also on the FTP site.
Ref http://www-01.ibm.com/support/docview.wss?uid=swg24035122

Best regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Thomas Denier
Sent: December 8, 2014 08:34
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM level for deduplication

Bent,

TSM 7.1.1.000 had a bug that sometimes caused restores of large files to
fail. IBM considered the bug serious enough to warrant removing 7.1.1.000
from its software distribution servers.

Thomas Denier
Thomas Jefferson University Hospital

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Bent Christensen
Sent: Saturday, December 06, 2014 6:38 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SV: TSM level for deduplication

Hi Thomas,

when you are calling 7.1.1- an utter distaster when it comes to dedup then
what issues are you referring to?

I have been using 7.1.1 in a production environment dedupping some 500 TB,
approx 400 nodes, without any bigger issues for more than a year now.

Surely, there are still lots of not-very-well-documented features in TSM
7, and I am not at all impressed by IBM support, and especially not DB2
support and their lack of willingness to recognize TSM DB2 as being a
production environment, but when it comes to dedupping it has been smooth
sailing for us up until now.


 - Bent


Fra: ADSM: Dist Stor Manager [ADSM-L@VM.MARIST.EDU] P#229; vegne af Thomas
Denier [thomas.den...@jefferson.edu]
Sendt: 5. december 2014 20:56
Til: ADSM-L@VM.MARIST.EDU
Emne: [ADSM-L] TSM level for deduplication

My management is very eager to deploy TSM deduplication in our production
environment. We have been testing deduplication on a TSM 6.2.5.0 test
server, but the list of known bugs makes me very uncomfortable about using
that level for production deployment of deduplication. The same is true of
later Version 6 levels and TSM 7.1.0. TSM 7.1.1.000 was an utter disaster.
Is there any currently available level in which the deduplication code is
really fit for production use?

IBM has historically described patch levels as being less thoroughly tested
than maintenance levels. Because of that I have avoided patch levels unless
they were the only option for fixing crippling bugs in code we were already
using.
Is that attitude still warranted? In particular, is that attitude warranted
for TSM 7.1.1.100?

Has IBM dropped any hints about the likely availability date for TSM
7.1.2.000?

Thomas Denier
Thomas Jefferson University Hospital


The information contained in this transmission contains privileged and
confidential information. It is intended only for the use of the person
named above. If you are not the intended recipient, you are hereby notified
that any review, dissemination, distribution or duplication of this
communication is strictly prohibited. If you are not the intended recipient,
please contact the sender by reply email and destroy all copies of the
original message.

CAUTION: Intended recipients should NOT use email communication for emergent
or urgent health care matters.

Re: TSM 7.1.1 Operations Center Questions

[J. Pohlmann]

Thanks Marcel. For some reason, I thought I could do more to manipulate 
schedules with the OC. Looks like the AdminCenter has some life left to it. 
Thanks also for the hint about the directory. I found the SERVER_ADDRESS in the 
serverConnection.properties file. Have not yet done any experimentation with 
modifying the entry. Would be nice to hear from development if that is the 
right thing to do if there is a DNS change for the hub server.

Thanks again,

Best regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Marcel 
Anthonijsz
Sent: November 2, 2014 06:32
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM 7.1.1 Operations Center Questions

Joerg,

1. From the TSM OC documentation link top right:
To update client schedules, complete the following steps:

On the Operations Center menu bar, hover over Clients.
From the list that is displayed, click Schedules.
Select one or more schedules that you want to edit, and click Details.
Restriction: If you select more than one schedule, the selected schedules 
must all show the same server name in the Server column of the table and the 
same domain name in the Domain column.
On the Schedule Details page, view additional information by expanding a 
schedule name.
Edit the schedules, and click Save.
Tip: You can configure additional schedule settings by issuing the UPDATE 
SCHEDULE command.

The _Tip_ says it all; You can only update Start time, Run Time alert and 
Repeat settings with the current version (7.1.1) I guess we have to wait for 
the next iteration of the OC to update options and objects.
I had to look for the association of schedules and clients; It is under the 
more menu when you right click on a client node in the Clients section.
Neat thing is you can select multipled clients and associate these with one 
schedule with a few clicks (4).

2. Could not find it in the documentation, but as far I understand it is stored 
in the serverConnection.properties file in the directory c:\Program 
Files\Tivoli\TSM\ui\Liberty\usr\servers\guiServer or 
/opt/tivoli/tsm/ui/Liberty/usr/servers/guiServer
if you're on Unix.

Nice thing of OC 7.1.1 is the customizable login page:
edit the file install dir/ui/Liberty/usr/servers/guiServer/loginText.html
for you standard legal disclaimers or Halloween ascii art.






2014-11-01 20:45 GMT+01:00 J. Pohlmann jpohlm...@shaw.ca:

 I have a couple of questions re the OC; have not been able to find an
 answer:



 1.   How do I update/display a client schedule. I need to find the
 objects and options used on the schedule and possibly change them. I 
 get the same OC screen with lack of information regardless of 
 schedmodes any or prompted set on the TSM server.

 2.   How do I change the IP/DNS name of the hub server in the OC. We
 just moved the hub server to a new machine with a different IP. We 
 were lucky in that the DNS entry for the old hub server could be 
 changed to the new one so we were able to connect. I would like to 
 update the name/IP used by the OC to connect.



 Any help is appreciated.



 Best regards,



 Joerg Pohlmann




--
Kind Regards, Groetje,

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

TSM 7.1.1 Operations Center Questions

[J. Pohlmann]

I have a couple of questions re the OC; have not been able to find an
answer:



1.   How do I update/display a client schedule. I need to find the
objects and options used on the schedule and possibly change them. I get the
same OC screen with lack of information regardless of schedmodes any or
prompted set on the TSM server.

2.   How do I change the IP/DNS name of the hub server in the OC. We
just moved the hub server to a new machine with a different IP. We were
lucky in that the DNS entry for the old hub server could be changed to the
new one so we were able to connect. I would like to update the name/IP used
by the OC to connect.



Any help is appreciated.



Best regards,



Joerg Pohlmann

Re: TSM 7.1 usage of volumes for dedupe

[J. Pohlmann]

Try show dedupdeleteinfo - if there are chunks queued or threads actively 
working on deleting chunks, the volumes will remain. 

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Prather, Wanda
Sent: October 22, 2014 11:50
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM 7.1 usage of volumes for dedupe

Don't believe that.
I have seen it before - if you can do a MOVE DATA, it isn't really empty.
I think it has to do with dedup.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Martha 
M McConaghy
Sent: Wednesday, October 22, 2014 1:06 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM 7.1 usage of volumes for dedupe

Yup, they are really empty.

/data0/0D57.BFS  DEDUPEPOOL  FILE  50.0
G   0.0   Full

tsm: TSMPRIMESERVERq content /data0/0D57.BFS Session established with 
server TSMPRIMESERVER: Linux/x86_64
   Server Version 7, Release 1, Level 1.0
   Server date/time: 10/22/2014 12:54:58  Last access: 10/22/2014 11:36:27

ANR2034E QUERY CONTENT: No match found using this criteria.
ANS8001I Return code 11.

Martha

On 10/22/2014 12:08 PM, Michael Roesch wrote:
 Hi Martha,

 have you run query content on some of the volumes to see, if they 
 are really empty?

 Michael

 On Wed, Oct 22, 2014 at 5:47 PM, Martha M McConaghy  
 martha.mccona...@marist.edu wrote:

 We just installed TSM 7.1 during the summer and have been working on 
 migrating our backups over from our old v5.5 system.  We are using 
 deduplication for our main storage pool and it seems to work great.
 However, I'm concerned about how it is using the volumes in the 
 storage pool.  Since we never ran v6, I don't know if this is normal
 or if we have stumbled upon a bug in 7.1.  So, I figured I'd ask on 
 the list and see if any of you have some insight.

 Our dedupe storage pool is dev class FILE, of course.  It is set up 
 to acquire new scratch volumes as it needs over time.  Originally, 
 I had the max scratch vols allowed at 999, which seemed reasonable.
 After about a month, though, we hit that max and I had to keep raising it.
 When I query the volumes belonging to this pool, I see many, many of 
 them in full status, with pct util=0:
 Volume Name Storage Device
 Estimated   Pct  Volume
  Pool Name Class
 Name  Capacity  Util  Status
 ---
 --  - - 
 /data0/0B55.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0B8F.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0BCF.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0BD6.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C16.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C2A.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C63.BFS  DEDUPEPOOL  FILE  49.9
 G 100.0   Full
 /data0/0C72.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C79.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C84.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C8C.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C93.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0C9A.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0CA1.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full
 /data0/0CB3.BFS  DEDUPEPOOL  FILE  50.0
 G   0.0   Full

 Literally, hundreds of them.  I run reclamations, but these volumes 
 never get touched nor reclaimed.  Seems to me that they should. I've 
 gone over the admin guide several times, but have found nothing 
 touching on this.  We just applied the 7.1.1.0 updates, but that has 
 not helped either.  If I do a move data on each, they will disappear.
 However, more will return to take their place.  Anyone seen this 
 before, or have any suggestions?

 Martha

 --
 Martha McConaghy
 Marist: System Architect/Technical Lead
 SHARE: Director of Operations
 Marist College IT
 Poughkeepsie, NY  12601


--
Martha McConaghy
Marist: System Architect/Technical Lead
SHARE: Director of Operations
Marist College IT
Poughkeepsie, NY  12601

Re: 7.1.1 / 4.1.1 Product documentation collections for download

[J. Pohlmann]

Thanks Angela. Most appreciated.

Best regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Angela Robertson
Sent: October 13, 2014 16:48
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] 7.1.1 / 4.1.1 Product documentation collections for
download

The  downloadable IBM Knowledge Center contains the latest set of
information about Tivoli Storage Manager products.

You can download and display an instance of IBM Knowledge Center either
locally on a workstation, or from a server where it can be accessed by
others through a web address.

To download and run the Customer Installable IBM Knowledge Center, complete
the following steps:
   1.   Download the tsm711kc.zip file from the following location:
  ftp://public.dhe.ibm.com/software/products/TSM/current_kc/tsm711kc.zip
   2.   Extract the files to a location of your choice.
   3.   Read the Terms of Use statement (termsofuse.html), and the
  NOTICES.txt file in the KnowledgeCenter directory.
   4.   Review the procedures in the download_dir
  /KnowledgeCenter/knowledgecenter_instructions.html file.
   5.   Start IBM Knowledge Center by following the instructions in the
  knowledgecenter_instructions.html file.

Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com

Re: By request, a link to download all of the 7.1.1 / 4.1.1 PDFs

[J. Pohlmann]

Thanks Angela. Most appreciated.

Best regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Angela Robertson
Sent: September 29, 2014 12:21
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] By request, a link to download all of the 7.1.1 /
4.1.1 PDFs

That link starts the download of the ZIP file with all of the PDFs. If you
want to go to the directory and start the download, go to
ftp://public.dhe.ibm.com/software/products/TSM/current/. Click
711_411_PDFs.zip. The file size is 84.1 MB so the download takes some time.
Angela

Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/29/2014
03:10:36 PM:

 From: Srikanth Kola23 srkol...@in.ibm.com
 To: ADSM-L@VM.MARIST.EDU
 Date: 09/29/2014 03:16 PM
 Subject: Re: [ADSM-L] By request, a link to download all of the 7.1.
 1 / 4.1.1 PDFs
 Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 GETTING FILE NOT FOUNT ,.. PLZ PROVIDE CORRECT LINK,..

 Thanks  Regards,

 Srikanth kola
 Backup  Recovery
 IBM India Pvt Ltd, Chennai
 Mob: +91 9885473450



 From:   Angela Robertson aprob...@us.ibm.com
 To: ADSM-L@VM.MARIST.EDU
 Date:   09/30/2014 12:37 AM
 Subject:[ADSM-L] By request, a link to download all of the
7.1.1 /
 4.1.1 PDFs
 Sent by:ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU



 FYI - By request, we added a package of all of the PDFs now available
 in the current folder (excluding translated PDFs):
 ftp://public.dhe.ibm.com/software/products/TSM/current/711_411_PDFs.zi
 p
 
 Angela Robertson
 IBM Software Group
 Durham, NC 27703
 aprob...@us.ibm.com
 

Re: tsm administration via web

[J. Pohlmann]

No - it will ask that the 7.1 server be upgraded.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
David Ehresman
Sent: September 23, 2014 10:18
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm administration via web

Can the 7.1.1 OpCenter be run with pre-7.1 servers?

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Tuesday, September 23, 2014 12:49 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm administration via web

The ISC is on the FTP site, under Maintenance\admincenter.
But I don't recommend it.

You should know it has been stabilized at 6.3.  There is a 7.1 version on
the site which has been patched to work with a 7.1 server, but it has no 7.1
function and it will never be updated any more.

It also has never been upgraded to run with any IE later than IE8 or Firefox
3.6.  (Although I've gotten good results using IE10, press F12, then
choosing IE8 compatibility mode.)

Just don't go the ISC route.  It's dead. (FINALLY)

And, the Operations Center which came out Sep 12 (the 7.1.1 version) really
has a lot of the functions you want, including client scheduling now, and
will be further developed.
They have a live demo up that you can show your Winders folks.
https://www.ibmserviceengage.com/on-premises-solutions


Wanda


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Lee, Gary
Sent: Tuesday, September 23, 2014 10:58 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm administration via web

Guess I am referring to the isc.

We are running tsm 6.2.5 on redhat enterprise 6.1.

I use the command line client exclusively, but the windows folks want
something gui.

I went looking, but its been so long since I used it, where do you find the
isc?

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Skylar Thompson
Sent: Tuesday, September 23, 2014 9:32 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm administration via web

Are you thinking of the ISC? I started out administering TSM through that,
but it was finicky enough that I ended up using the CLI and haven't looked
back since.

On Tue, Sep 23, 2014 at 01:12:15PM +, Lee, Gary wrote:
 What is the Tivoli product called for administering tsm via a web based
gui?

 I don't really care, but my boss wants me to evaluate gui tsm management
products.

 What is the sens of the list?  IBM, or third party, if so what third
party?

--
-- Skylar Thompson (skyl...@u.washington.edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine

Re: sql question

[J. Pohlmann]

Have you tried the sample script q_nongroupednodes? All the sample scripts
are in the TSM software installation directory in scripts.smp - install with
dsmserv  runfilepathscripts.smp


DEFINE SCRIPT  Q_NONGROUPEDNODES DESC=Display nodes not in a colloc group
UPDATE SCRIPT  Q_NONGROUPEDNODES /* */
UPDATE SCRIPT  Q_NONGROUPEDNODES /* Script Name: q_nongroupednodes  */
UPDATE SCRIPT  Q_NONGROUPEDNODES /* Description: Displays the   */
UPDATE SCRIPT  Q_NONGROUPEDNODES /*  registered nodes that are not  */
UPDATE SCRIPT  Q_NONGROUPEDNODES /*  currently defined as members   */
UPDATE SCRIPT  Q_NONGROUPEDNODES /*  of a collocation group, and their  */
UPDATE SCRIPT  Q_NONGROUPEDNODES /*  domain.*/
UPDATE SCRIPT  Q_NONGROUPEDNODES /* Parameter: none */
UPDATE SCRIPT  Q_NONGROUPEDNODES /* Example: run q_nongroupednodes  */
UPDATE SCRIPT  Q_NONGROUPEDNODES /* */
UPDATE SCRIPT  Q_NONGROUPEDNODES select domain_name as Domain, -
UPDATE SCRIPT  Q_NONGROUPEDNODES  node_name as -
UPDATE SCRIPT  Q_NONGROUPEDNODES  Nodes not defined to collocation
group -
UPDATE SCRIPT  Q_NONGROUPEDNODES  from nodes where collocgroup_name is -
UPDATE SCRIPT  Q_NONGROUPEDNODES  null order by domain_name, node_name


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Lee, Gary
Sent: September 11, 2014 04:51
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] sql question

I have run myself ragged on this one.
I would have sworn it worked yesterday morning.

Tsm server 6.2.5 under RHEL 6.1

I am trying to get a list of nodes not in a collocgroup.
Statement follows:

Select a.node_name from nodes a where
a.node_name not in (select b.node_name from collocgroup b)

Thanks foor any assistance.
Its probably simple, and I'm just not seeing it.

Re: TSM 7.1.1 server on Windows 2012 R2

[J. Pohlmann]

Thanks - that was my point -  the page has not been updated. Del's response was 
that it will be on or before Friday.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Francisco Javier
Sent: September 8, 2014 16:16
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM 7.1.1 server on Windows 2012 R2

check this links:
http://www-01.ibm.com/support/docview.wss?uid=swg21243309


2014-09-08 17:49 GMT-05:00 J. Pohlmann jpohlm...@shaw.ca:

 Hi everyone. Could someone please shed some light on the support of 
 7.1.1 TSM server on Windows 2012 R2 (not client or storage agent). 
 There were some rumblings in the past that TSM server 7.1.1 on Windows 
 2012 R2 would be there, but I have not seen any confirmation based on 
 the announcement letter.



 Best regards,



 Joerg Pohlmann

TSM 7.1.1 server on Windows 2012 R2

[J. Pohlmann]

Hi everyone. Could someone please shed some light on the support of 7.1.1
TSM server on Windows 2012 R2 (not client or storage agent). There were some
rumblings in the past that TSM server 7.1.1 on Windows 2012 R2 would be
there, but I have not seen any confirmation based on the announcement
letter.



Best regards,



Joerg Pohlmann

Re: TSM 7.1.1 server on Windows 2012 R2

[J. Pohlmann]

Thanks Del. Most appreciated.

Best regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del
Hoobler
Sent: September 8, 2014 17:41
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM 7.1.1 server on Windows 2012 R2

Hi Joerg,

Tivoli Storage Manager 7.1.1 Server WILL support Windows Server 2012 R2. The
technote will be updated on or before eGA date of this Friday, September 12,
2014.

Del




ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/08/2014
06:49:49 PM:

 From: J. Pohlmann jpohlm...@shaw.ca
 To: ADSM-L@VM.MARIST.EDU
 Date: 09/08/2014 06:51 PM
 Subject: TSM 7.1.1 server on Windows 2012 R2 Sent by: ADSM: Dist Stor
 Manager ADSM-L@VM.MARIST.EDU

 Hi everyone. Could someone please shed some light on the support of
7.1.1
 TSM server on Windows 2012 R2 (not client or storage agent). There
 were
some
 rumblings in the past that TSM server 7.1.1 on Windows 2012 R2 would
 be there, but I have not seen any confirmation based on the
 announcement letter.



 Best regards,



 Joerg Pohlmann

Re: 7.1.1 Announcement; GA for download Sep 12

[J. Pohlmann]

Hi Angela. My usual request - could you please arrange for a
downloadable/installable Infocenter to be put on the ftp site for 9/12.

Thanks.

Best regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Angela Robertson
Sent: September 2, 2014 13:21
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] 7.1.1 Announcement; GA for download Sep 12

The APAR list is to be published on 12 September. I have no control over
when we publish these materials, but I understand knowing what APARs are in
7.1.1 is important. If I find that the date changes, I'll post. Angela


Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/02/2014
03:19:35 PM:

 From: Matthew McGeary matthew.mcge...@potashcorp.com
 To: ADSM-L@VM.MARIST.EDU
 Date: 09/02/2014 03:21 PM
 Subject: Re: [ADSM-L] 7.1.1 Announcement; GA for download Sep 12 Sent
 by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 I've been looking around but can't find the APAR list for 7.1.1.  In
 particular, I'm checking to see if any APARs fixed by 7.1.0.100 are
 unfixed in 7.1.1.

 Anyone know where I might find this information?

 Matthew McGeary
 Technical Specialist
 PotashCorp - Saskatoon
 306.933.8921



 From:   Prather, Wanda wanda.prat...@icfi.com
 To: ADSM-L@VM.MARIST.EDU
 Date:   09/02/2014 11:14 AM
 Subject:[ADSM-L] 7.1.1 Announcement; GA for download Sep 12
 Sent by:ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU



 http://www.ibm.com/common/ssi/cgi-bin/ssialias?

infotype=ANsubtype=CAappname=gpateamsupplier=897letternum=ENUS214-340pd
f=yes



 Wanda Prather  |  Senior Technical Specialist  |
 wanda.prat...@icfi.com mailto:wanda.prat...@icfi.com  |
 www.icfi.comhttp://www.icfi.com/ |
 410-868-4872 (m)
 ICF International  | 7125 Thomas Edison Dr., Suite 100, Columbia, Md
 |443-718-4900 (o)

Re: 7.1.1 Announcement; GA for download Sep 12

[J. Pohlmann]

Super! Thanks Angela.

Best regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Angela Robertson
Sent: September 2, 2014 18:07
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] 7.1.1 Announcement; GA for download Sep 12

Hi Joerg,

Yes, we are working on a downloadable/installable Infocenter. Because the
IBM Knowledge Center is replacing the information center model, the
downloadable/installable version of the content is called IBM Knowledge
Center customer install. Teams have been using it and the feedback has been
positive. We have plans to post it on / near the GA date. I will post when
it is available.

As always, thanks for the interest in the technical content. Angela

Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/02/2014
04:30:26 PM:

 From: J. Pohlmann jpohlm...@shaw.ca
 To: ADSM-L@VM.MARIST.EDU
 Date: 09/02/2014 04:32 PM
 Subject: Re: [ADSM-L] 7.1.1 Announcement; GA for download Sep 12 Sent
 by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU

 Hi Angela. My usual request - could you please arrange for a
 downloadable/installable Infocenter to be put on the ftp site for 9/12.

 Thanks.

 Best regards,

 Joerg

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
 Of Angela Robertson
 Sent: September 2, 2014 13:21
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] 7.1.1 Announcement; GA for download Sep 12

 The APAR list is to be published on 12 September. I have no control
 over when we publish these materials, but I understand knowing what
 APARs are
in
 7.1.1 is important. If I find that the date changes, I'll post. Angela

 
 Angela Robertson
 IBM Software Group
 Durham, NC 27703
 aprob...@us.ibm.com
 

 ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/02/2014
 03:19:35 PM:

  From: Matthew McGeary matthew.mcge...@potashcorp.com
  To: ADSM-L@VM.MARIST.EDU
  Date: 09/02/2014 03:21 PM
  Subject: Re: [ADSM-L] 7.1.1 Announcement; GA for download Sep 12
  Sent
  by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
 
  I've been looking around but can't find the APAR list for 7.1.1.  In
  particular, I'm checking to see if any APARs fixed by 7.1.0.100 are
  unfixed in 7.1.1.
 
  Anyone know where I might find this information?
 
  Matthew McGeary
  Technical Specialist
  PotashCorp - Saskatoon
  306.933.8921
 
 
 
  From:   Prather, Wanda wanda.prat...@icfi.com
  To: ADSM-L@VM.MARIST.EDU
  Date:   09/02/2014 11:14 AM
  Subject:[ADSM-L] 7.1.1 Announcement; GA for download Sep 12
  Sent by:ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
 
 
 
  http://www.ibm.com/common/ssi/cgi-bin/ssialias?
 

infotype=ANsubtype=CAappname=gpateamsupplier=897letternum=ENUS214-340pd

 f=yes

 
 
  Wanda Prather  |  Senior Technical Specialist  |
  wanda.prat...@icfi.com mailto:wanda.prat...@icfi.com  |
  www.icfi.comhttp://www.icfi.com/ |
  410-868-4872 (m)
  ICF International  | 7125 Thomas Edison Dr., Suite 100, Columbia, Md
  |443-718-4900 (o)
 

Re: LAN-free to disk

[J. Pohlmann]

Eric, you can find LAN-free to disk info in the Storage Agent Guide, and
also a couple of comments in the Admin Guide. With GPFS, the only non-SAN
transfer is if your environment has a Windows Storage Agent on GPFS. Windows
in GPFS transfers across TCP/IP (it's not a TSM function but rather a GPFS
on Windows function).

Regards,

Joerg Pohlmann.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Loon, EJ van (SPLXM) - KLM
Sent: Friday, March 21, 2014 02:36
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] LAN-free to disk

Hi Angela!
Both articles talk about LAN-free to tape, not to disk...
Kind regards,
Eric van Loon
AF/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Angela Robertson
Sent: vrijdag 21 maart 2014 0:23
To: ADSM-L@VM.MARIST.EDU
Subject: Re: LAN-free to disk

There is an article in the TSM wiki re: using LAN-free with TSM VE:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivol
i%20Storage%20Manager/page/Recommendations%20for%20Using%20LAN-free%20with%2
0Tivoli%20Storage%20Manager%20for%20Virtual%20Environments


There's also info in the IBM Knowledge Center at
http://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.0/com.ibm.itsm.srv.
doc/t_lanfree_config_win.html
. If you want LAN-free info for FlashCopy Manager, I can post links, but I
don't think that's the question.

If you cannot find what you want in the IBM Knowledge Center, you can use
the Feedback link at the bottom. When you use that Feedback link, the people
who write the information are supposed to get the feedback. We can get the
content you need published. Angela

Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 03/20/2014
11:20:18 AM:

 From: Joerg Pohlmann jpohlm...@shaw.ca
 To: ADSM-L@vm.marist.edu
 Date: 03/20/2014 11:27 AM
 Subject: Re: [ADSM-L] LAN-free to disk Sent by: ADSM: Dist Stor
 Manager ADSM-L@vm.marist.edu

 Eric, you can use GPFS.

 Joerg

 - Original Message -

 From: EJ van Loon (SPLXM) - KLM eric-van.l...@klm.com
 To: ADSM-L@VM.MARIST.EDU
 Sent: Thursday, March 20, 2014 7:58:31 AM
 Subject: [ADSM-L] LAN-free to disk

 Hi guys!
 I read in several IBM documents lines like TSM also supports some
 configurations with LAN-free to disk-based storage pools and ...
 If you are implementing one of TSM's supported LAN-free to disk
 solutions... but I cannot find any details about these supported
 configurations.
 I know one had to buy Sanergy in the past, but as far as I can see it
 no longer exists...
 Thanks in advance for your reply!
 Kind regards,
 Eric van Loon
 AF/KLM Storage Engineering
 
 For information, services and offers, please visit our web site:
 http://www.klm.com. This e-mail and any attachment may contain
 confidential and privileged material intended for the addressee only.
 If you are not the addressee, you are notified that no part of the
 e-mail or any attachment may be disclosed, copied or distributed, and
 that any other action related to this e-mail or attachment is strictly
 prohibited, and may be unlawful. If you have received this e-mail by
 error, please notify the sender immediately by return e-mail, and
 delete this message.

 Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or
 its employees shall not be liable for the incorrect or incomplete
 transmission of this e-mail or any attachments, nor responsible for
 any delay in receipt.
 Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
 Dutch Airlines) is registered in Amstelveen, The Netherlands, with
 registered number 33014286
 


For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any delay in receipt.

Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered
number 33014286

Re: What is the newest client version supported on Windows server 2003?

[J. Pohlmann]

Last one is 6.3.1.2 on the ftp site. I agree, I wish IBM CSI (former
Tivoli) would keep on supporting Windows 2003 a bit longer, like into v7.1+.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tom
Alverson
Sent: Friday, March 07, 2014 10:18
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] What is the newest client version supported on Windows
server 2003?

I can't make sense of the IBM web page with the compatibility matrix.  What
is the highest version client that is supported for Windows 2003 server for
both the standard BACLIENT and also the TDP database client?   We are
having a lot of problems with the TDP 6.3.1 client and were hoping that
moving to BAC 6.4.0.1 / TDP 6.4.1.3 would help but it appears that will only
work on Server 2008?

Tom

Re: What is the newest client version supported on Windows server 2003?

[J. Pohlmann]

Hi Erwann. You're quite right. Thanks for the pointer.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann 
Simon
Sent: Friday, March 07, 2014 10:41
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] What is the newest client version supported on Windows 
server 2003?

Hi Joerg,

I think you missed this fix pack :
ftp://public.dhe.ibm.com/storage/tivoli-storage-management/maintenance/client/v6r3/Windows/x32/v632/


On 7 mars 2014 19:28:02 CET, J. Pohlmann jpohlm...@shaw.ca wrote:
Last one is 6.3.1.2 on the ftp site. I agree, I wish IBM CSI (former
Tivoli) would keep on supporting Windows 2003 a bit longer, like into 
v7.1+.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
Of Tom Alverson
Sent: Friday, March 07, 2014 10:18
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] What is the newest client version supported on 
Windows server 2003?

I can't make sense of the IBM web page with the compatibility matrix. 
What
is the highest version client that is supported for Windows 2003 server 
for
both the standard BACLIENT and also the TDP database client?   We are
having a lot of problems with the TDP 6.3.1 client and were hoping that 
moving to BAC 6.4.0.1 / TDP 6.4.1.3 would help but it appears that will 
only work on Server 2008?

Tom

--
Erwann SIMON
Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.

Re: Prevent client backups from failing over to tape stgpools

[J. Pohlmann]

You can chain two sequential pools and use mig stg name lo=0 - have used
this technique time and again to change technology, including TSM deduped to
no-deduped on a dedup appliance so that we got hardware dedup. Have also
used it for tape to file devclass. You can always schedule a mig stg command
using an admin schedule.

Regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Sunday, February 02, 2014 12:23
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Prevent client backups from failing over to tape
stgpools

Oh, that's brilliant!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Steven Harris
Sent: Friday, January 31, 2014 8:23 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Prevent client backups from failing over to tape
stgpools

Brian

TSM will only move a backup to the next pool when the pools are disk and
sequential, not when sequential and sequential, so I suggest adding a dummy
sequential pool with no volumes assigned in the middle.

disk - dummy - tape
I've come across this when using an intermediate file pool.  It doesn't
spill like a disk pool does should it fill up.

Regards

Steve
Steven Harris
TSM Admin
Canberra Australia

On 31/01/2014 8:24 AM, Skylar Thompson wrote:
 If the tape pool is in a separate device class from other storage pools,
you could set the mount limit on the device class to 0. That's our strategy
when we do library maintenance to allow operations to continue to/from our
disk and file pools.

 On Thu, Jan 30, 2014 at 10:47:46AM -0800, Brian Kunst wrote:

 We???re in a situation where we want to temporarily prevent our users
from ever writing directly to our tape drives.  In the event that our
primary random access stgpools hit 100% utilization, we want client backups
to fail rather than failover over to the next, sequential access stgpool.
As far as I can see, there are two ways to accomplish this:

 1)  Set maxnummp for all nodes to 0.  This should prevent them from
access a tape drive when backing up, but would also prevent them from access
a tape drive to do a restore.  Clearly not a good option.

 2)  Set the Next Storage Pool value for the primary random access
stgpools to null.  With this method, migrations would no longer work, but we
could still move data to tape using the ???move data??? command on the
random access volumes.

 I???m leaning towards option 2, but I would like to know if anyone cam
think of another way to prevent client backups from going directly to the
tape drives.

 Thanks,

 --
 Brian Kunst
 Storage Administrator
 Large Scale Storage  Systems
 UW Information Technology


 --
 -- Skylar Thompson (skyl...@u.washington.edu)
 -- Genome Sciences Department, System Administrator
 -- Foege Building S046, (206)-685-7354
 -- University of Washington School of Medicine

Re: Cannot bring back a volume to scratch

[J. Pohlmann]

Did you try

Move media volume name stg=storage pool name
wherestate=mountablenotinlib wherestatus=empty

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Karel Bos
Sent: Monday, December 30, 2013 08:48
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Cannot bring back a volume to scratch

Hi,

Empty is a volume status, scratch a libvol status. To remove an empty volume
from a pool issue del vol against that volume number. Response in act log
should be volume xxx deleted from storage pool. If that's not happening,
find out why and fix it

Volumes not in stg and not used for db bck or things like export should end
up as scratch. If it still hangs on priv upd libv  stat=scr should fix
it. If not plunder through act log of libmanager to find out why.



Op 30 dec. 2013 11:49 schreef Robert Ouzen rou...@univ.haifa.ac.il:

 Hi Chadvar

 As I said in my previous message now the satus of this volume is EMPTY
 (after running an audit vol on it) , but still remain the problem of
 making it SCRATCH

 Best Regards Robert

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
 Of Chavdar Cholev
 Sent: Monday, December 30, 2013 12:41 PM
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] Cannot bring back a volume to scratch

 Hi Robert,
 volume status is filling so it is not go to scratch when status is
filling.
 You can try:
 1. q con 15L5
 2. if you need really to scratch this volume try to move data from
 that volume by using /move data  15L5/.

 Regards
 Chavdar
 On 12/30/2013 07:23, Robert Ouzen wrote:
  Hi Chavdar
 
  I upd the access of the vol to readw
 
  tsm: ADSM2upd vol 15l5 acc=readw ANR2207I Volume 15L5
  updated.
 
  I tried again to change it to scratch without success
 
  tsm: ADSM2upd libv lto5lib 15l5 status=scratch ANR8443E UPDATE
  LIBVOLUME: Volume 15L5 in library LTO5LIB cannot be assigned a
 status of SCRATCH.
  ANS8001I Return code 12.
 
  I run too an audit vol 15L5 fix=yes
 
  I'ts fix the problem of the volume status to empty but still cannot
  make
 it scratch !
 
  Regards   Robert
 
  -Original Message-
  From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
  Behalf Of Chavdar Cholev
  Sent: Sunday, December 29, 2013 11:59 PM
  To: ADSM-L@VM.MARIST.EDU
  Subject: Re: [ADSM-L] Cannot bring back a volume to scratch
 
  Hi Robert,
  just an idea .. it is read-only vol... have you tried update vol to
 acc=readw ? and try to delete after that  ...
 
  Regards
  Chavdar
  On 12/29/2013 11:18, Robert Ouzen wrote:
  Hello
  Tried to make a vol in status scratch  again , the volume is in
  LTO5
 robot in status private.
 
  Run a del volh 15l5 discardd=yes and got:
 
  12/29/2013 11:12:44  ANR1425W Scratch volume 15L5 is empty but
 will not be   deleted - volume state is mountablenotinlib. (SESSION:
 16397)
 
  As you see said the volume is empty but in state
  mountablenotinlib ,
 running q media 15l5 give me state: Mountable in library ! and
 volume
 status: Filling !
 
 
  I am stuck .Look the ouput commands below
 
  tsm: ADSM2q media 15l5 stg=i-drm f=d
 
  Volume Name: 15L5
State: Mountable in library Last Update Date/Time:
  09/09/2013 07:14:10
 Location:
Storage Pool Name: I-DRM
Automated LibName: LTO5LIB
Volume Status: Filling
   Access: Read-Only
  Last Reference Date: 09/08/2013 13:24:56
 
 
  tsm: ADSM2q vol 15l5 f=d
 
   Volume Name: 15L5
 Storage Pool Name: I-DRM
 Device Class Name: LTO5CLASS
Estimated Capacity: 2.9 T
   Scaled Capacity Applied:
  Pct Util: 0.0
 Volume Status: Filling
Access: Read-Only
Pct. Reclaimable Space: 43.1
   Scratch Volume?: Yes
   In Error State?: No
  Number of Writable Sides: 1
   Number of Times Mounted: 4,575
 Write Pass Number: 1
 Approx. Date Last Written: 09/08/2013 13:24:56
Approx. Date Last Read: 08/31/2013 10:48:28
   Date Became Pending:
Number of Write Errors: 0
 Number of Read Errors: 0
   Volume Location:
  Volume is MVS Lanfree Capable : No
  Last Update by (administrator): ROBERT
 Last Update Date/Time: 12/29/2013 10:03:50
  Begin Reclaim Period:
End Reclaim Period:
  Drive Encryption Key Manager: None
   Logical Block Protected: No
 
 
  Regards Robert

Re: inquiries

[J. Pohlmann]

Server-free backup was supported in TSM version 5.4 and earlier for Windows
based TSM servers (see the 5.4 TSM Admin Guide for Windows). The SAN Data
Gateway, which enabled SCSI tape drives to be attached to a FC SAN supported
the 3rd party data move SCSI-3 command where TSM instructed the SAN Data
Gateway to move blocks of data from LUN x to LUN y. Depending on x and y
being a tape drive or a SAN reachable disk volume, you had a server free
backup or restore. Only problem was that there was little interest in SAN
Data Gateways because tape drives evolved to native FC SAN attachment and
also became faster than the 1 Gbit FC speed of the SAN Data Gateway. Some
installations did some testing and reported what was the rationale for
server free data movement, namely to offload both client and server CPU and
also FC HBA traffic on both client and TSM server machines.

So much for history.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Remco Post
Sent: Thursday, December 19, 2013 14:06
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] inquiries

Op 19 dec. 2013, om 22:09 heeft Cremator cremator.li...@gmail.com het
volgende geschreven:

 1. Serverless backup - I have not heard of such a thing.

I have, but I don't think there is working implementation. TSM does support
LAN-free data movement.

 2. If you mean snapshot as the ability to backup open files, then it
 can be done.
 3. TSM can and will use VSS provider.
 Per TB licensing is simple - maximum 2 TSM servers, no mixing of per
 TB and per PVU,

there are actually two or three TB license schemes.

One: max 2 servers and max. 100 TB, TSM for UR entry
Two: TSM for UR (the real deal for big sites)

there is also the TSM for UR ProtecTIER option and the archive option. See:
http://www-03.ibm.com/software/products/en/tivostormanasuitforunifreco/

 you pay per TB for all of your primary storage pools, so it kind of
 force you to use deduplication and file pools for your primary storage
 pools.


 On Sat, Dec 14, 2013 at 5:23 PM, madu...@gmail.com
madu...@gmail.comwrote:

 Please advise if the following can be done via TSM:
 - Server less backup
 - Ability to take snapshot
 - VSS volume shadow copy services

 I need to give me your experience with TSM and licensing on capacity
 basis (licensed per TB, not PVUs)


 Which command should be run as assessment command to get the complete
 information of TSM server DB, backed up Data size?


 Thanks
 -mad


--

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

Re: DP for SQL 6.4 Copyfull MC binding

[J. Pohlmann]

Thanks Angela. All very intuitive. I just wanted to be sure.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Angela Robertson
Sent: Wednesday, August 14, 2013 08:40
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DP for SQL 6.4 Copyfull MC binding

Hi Joerg,

I am happy to help. Here's the information to answer your question:

VSSPOLICY  **COPYFULL   TSM  VSS_FULL_TSM_MC

If I can provide more detail, I will post. For now, I think this information
answers the immediate question. Angela


Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/12/2013
08:03:59 PM:

 J. Pohlmann jpohlm...@shaw.ca
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 08/12/2013 08:03 PM

 Please respond to
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 To

 ADSM-L@vm.marist.edu,

 cc

 Subject

 Re: [ADSM-L] DP for SQL 6.4 Copyfull MC binding


 Thanks Angela. What about the VSSPOLICY specification?

 Thanks for your help.

 Regards,

 Joerg Pohlmann

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
 Of Angela Robertson
 Sent: Monday, August 12, 2013 16:48
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] DP for SQL 6.4 Copyfull MC binding

 Here is some information that might help. There's more information
 than
you
 asked for, but I hope you find the additional detail helpful.

 Legacy backups use INCLUDE/EXCLUDE statements in the Data Protection
 for
SQL
 options file. For the examples provided in the following tables,
 grouped statements are intended to be used together. For example:

 \...\full*
 \...\full*\*

 and

 \...\file\f1*\*
 \...\file\f1*
 \...\f1\file*

|+|
 |Object matches for backuptype   |Specification
|

|+|
 |Example for all objects |\...\*
|

|+|
 |Example for exclude statements with |\...\full*
|
 |all type of backups |
|
 |(full, diff, log, group, file, set) |\...\diff*
|

|+|
 |Example for include and exclude |\...\full*
|
 |statements with all type of backups |\...\full*\*
|
 |(full, diff, log, group, file, set) |
|
 ||\...\copyfull*
|
 ||\...\copyfull*\*
|
 ||
|
 ||\...\diff*
|
 ||\...\diff*\*
|
 ||
|
 ||\...\log*
|
 ||\...\log\...\*
|
 ||
|
 ||\...\group*
|
 ||\...\group\...\*
|
 ||
|
 ||\...\file*
|
 ||\...\file\...\*
|
 ||
|
 ||\...\set*
|
 ||\...\set\...\*
|

|+|
 |Example for exclude statements with |\...\g1\group*
|
 |file (f1) and group (g1)|\...\f1\file*
|

|+|
 |Example for include statements with |\...\group\g1*\*
|
 |file (f1) and group (g1)|\...\group\g1*
|
 ||\...\g1\group*
|
 ||
|
 ||\...\file\f1*\*
|
 ||\...\file\f1*
|
 ||\...\f1\file*
|

|+|
 |Example for exclude statements with |\...\g*\group*
|
 |group or file object names beginning|\...\f*\file*
|
 |with g or f |
|

|+|
 |Example for include statements with |\...\group\g*\*
|
 |group or file object names beginning|\...\group\g*
|
 |with g or f |\...\g*\group*
|
 ||
|
 ||\...\file\f*\*
|
 ||\...\file\f*
|
 ||\...\f*\file*
|

|+|
 |Example for exclude statements same |\...\*\group*
|
 |as \...\group* or \...\file

DP for SQL 6.4 Copyfull MC binding

[J. Pohlmann]

We are thinking of upgrading our DP for SQL environment to 6.4 so that we
can take advantage of the copyfull type of backup. We would like to bind a
long-term retention MC to the copyfull backup, however the DP for SQL
Installation and User's Guide (GC27-4010-10) does not cover this (page 3
states that different MCs can be bound to full and copyfull backups). If we
are going to use VSS backups, then we expect that VSSPOLICY statements will
do the MC binding. On page 43 at the revision bars, there is a statement
that only FULL or a * can be used for the backup type, where a * will cause
a FULL backup to be taken. However on p 91 an example of VSSPOLICY shows
FULL and INCR type of backups. There is no INCR type of backup for SQL
(there is for DP for Exchange). Page 253 only shows FULL backup type
examples for VSSPOLICY.



If we were to use a COPYFULL with legacy backups, what would the include
pattern be for the include statement to assign a long-term retention MC?
Page 254 (at the top) only shows the include pattern for the previously
supported legacy backup types.



Please help with the settings.



Regards,



Joerg Pohlmann

Re: DP for SQL 6.4 Copyfull MC binding

[J. Pohlmann]

*\...\* |
|servers beginning with SQL2012\INST ||
|+|
|Same as SQL2012\...\*   |SQL2012\*\...\* |
|+|
|Example for all meta or data objects|SQL2012\INST1\meta\...\* |
|from server SQL2012\INST1   |SQL2012\INST1\data\...\*|
|+|
|Example for all meta or data objects|SQL2012\*\meta\...\*|
|from all named server instances with||
|host SQL2012||
|+|
|Example for all meta or data objects|SQL2012\...\meta\...\*  |
|from all server instances with host ||
|SQL2012 ||
|+|
|Example for all objects from server |SQL2012\meta\...\*   |
|default instance (if no instance|SQL2012\data\...\*  |
|name matches ??ta)  ||
|+|




Angela Robertson
IBM Software Group
Durham, NC 27703
aprob...@us.ibm.com


ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 08/12/2013
06:25:30 PM:

 J. Pohlmann jpohlm...@shaw.ca
 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 08/12/2013 06:25 PM

 Please respond to
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 To

 ADSM-L@vm.marist.edu,

 cc

 Subject

 [ADSM-L] DP for SQL 6.4 Copyfull MC binding

 We are thinking of upgrading our DP for SQL environment to 6.4 so that
 we can take advantage of the copyfull type of backup. We would like to
 bind
a
 long-term retention MC to the copyfull backup, however the DP for SQL
 Installation and User's Guide (GC27-4010-10) does not cover this (page
 3 states that different MCs can be bound to full and copyfull
 backups). If
we
 are going to use VSS backups, then we expect that VSSPOLICY statements
will
 do the MC binding. On page 43 at the revision bars, there is a
 statement that only FULL or a * can be used for the backup type, where
 a * will
cause
 a FULL backup to be taken. However on p 91 an example of VSSPOLICY
 shows FULL and INCR type of backups. There is no INCR type of backup
 for SQL (there is for DP for Exchange). Page 253 only shows FULL
 backup type examples for VSSPOLICY.



 If we were to use a COPYFULL with legacy backups, what would the
 include pattern be for the include statement to assign a long-term
retention MC?
 Page 254 (at the top) only shows the include pattern for the
 previously supported legacy backup types.



 Please help with the settings.



 Regards,



 Joerg Pohlmann
=

Downloadable Infocenter from techprev

[J. Pohlmann]

Hi Angela. Is the downloadable 6.4 infocenter on techprev being updated for
6.3.4 server documentation? If so, could you please let us know so we can
download the updated infocenter.



Thanks.



Best regards,



Joerg Pohlmann

+1-250-585-3711

Re: Tapes required by backup stgpool

[J. Pohlmann]

Try ba stg ... preview=volumesonly.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Thorneycroft, Doug
Sent: Tuesday, April 16, 2013 09:45
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Tapes required by backup stgpool

You could look at the last written date, any tape written to since the last
backup backup stgpool was completed Should be needed.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Benhayoune Khalid
Sent: Tuesday, April 16, 2013 9:35 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Tapes required by backup stgpool

Hi everybody,

TSM 6.2 on AIX 5.3

Is there any way to determine the primary tapes needed by a backup stgpool
command before launching it.

Thanks in advance.

Regards.

Re: When to dsmserv removedb?

[J. Pohlmann]

Hi Wanda. I have done dsmserv removedb with both 6.1 and 6.2 server moves.
In the 6.3.3 Admin Guide, the instructions in the DRM chapter states that
you need to do a removedb after creating the instance so that you can do the
restore db.

In the Admin Reference book for 6.3.3, there is now a scary revision code in
the restore db section. It says that Data cannot be stored on virtual
volumes - several of my customers do a DBB to virtual volumes. A database
restore from virtual volumes has worked in the past. The most recent
database restore I did from virtual volumes was with 6.2.2 - could someone
from development also comment regarding this new restriction please.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Thursday, February 21, 2013 09:00
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] When to dsmserv removedb?

I have found multiple conflicting documents.

For TSM V6,
if you are going to do
dsmserv restore db,
under what circumstances should you do
dsmserv removed TSMDB1 first?

Specifically trying to figure if this is necessary when restoring TSM DB at
a DR site, i.e. to different hardware.



Wanda Prather  |  Senior Technical Specialist  | wanda.prat...@icfi.com  |
www.icfi.com ICF International  | 401 E. Pratt St, Suite 2214, Baltimore, MD
21202 | 410.539.1135 (o)

How do I find the instance directory for a v6 server?

[J. Pohlmann]

Does anyone know how to find the instance directory for a running TSM v6
server? On Windows, it's easy - I use regedit to find the directory. What
about other platforms? Is there a way of getting this information via a TSM
command?



Regards,



Joerg Pohlmann

+1-250-585-3711

Re: How do I find the instance directory for a v6 server?

[J. Pohlmann]

Thanks Remco. If anyone from development is listening, perhaps this
information could be displayed in a more elegant fashion, like as part of a
query stat output.

Regards,

Joerg

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Remco Post
Sent: Tuesday, February 12, 2013 11:11
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How do I find the instance directory for a v6 server?

ps -ef  it's on the command line

On 12 feb. 2013, at 19:59, J. Pohlmann jpohlm...@shaw.ca wrote:

 Does anyone know how to find the instance directory for a running TSM
 v6 server? On Windows, it's easy - I use regedit to find the
 directory. What about other platforms? Is there a way of getting this
 information via a TSM command?



 Regards,



 Joerg Pohlmann

 +1-250-585-3711

--
Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

Re: How do I find the instance directory for a v6 server?

[J. Pohlmann]

I HATE fiddling around with regedit.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Remco Post
Sent: Tuesday, February 12, 2013 11:21
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How do I find the instance directory for a v6 server?

h... so you don't mind fiddling in the registry on windows, but a 'ps
-ef' is a bridge to far? Curious.


On 12 feb. 2013, at 20:15, J. Pohlmann jpohlm...@shaw.ca wrote:

 Thanks Remco. If anyone from development is listening, perhaps this
 information could be displayed in a more elegant fashion, like as part
 of a query stat output.

 Regards,

 Joerg

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
 Of Remco Post
 Sent: Tuesday, February 12, 2013 11:11
 To: ADSM-L@VM.MARIST.EDU
 Subject: Re: [ADSM-L] How do I find the instance directory for a v6
server?

 ps -ef  it's on the command line

 On 12 feb. 2013, at 19:59, J. Pohlmann jpohlm...@shaw.ca wrote:

 Does anyone know how to find the instance directory for a running TSM
 v6 server? On Windows, it's easy - I use regedit to find the
 directory. What about other platforms? Is there a way of getting this
 information via a TSM command?



 Regards,



 Joerg Pohlmann

 +1-250-585-3711

 --
 Met vriendelijke groeten/Kind Regards,

 Remco Post
 r.p...@plcs.nl
 +31 6 248 21 622

--
Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

Re: RE : [ADSM-L] FW: LTO6 TSM

[J. Pohlmann]

Hi Erwann. That's the HP LTO6 support statement. I know I have seen the IBM 
LTO6 support statement (TSM 6.3.3.000) somewhere but I cannot find it any more. 
Maybe someone in development/pubs support can update the supported devices Web 
page.

Joerg Pohlmann 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann 
Simon
Sent: Thursday, December 06, 2012 06:50
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] RE : [ADSM-L] FW: LTO6 TSM

Hi all,

TSM 6.3.3 add support for LTO6 drives, see (for instance) :
http://www-01.ibm.com/support/docview.wss?uid=swg21612814

--
Best regards / Cordialement / مع تحياتي
Erwann SIMON

- Mail original -
De: Erwann Simon erwann.si...@free.fr
À: ADSM-L@VM.MARIST.EDU
Envoyé: Samedi 1 Décembre 2012 04:45:14
Objet: RE : [ADSM-L] FW: LTO6 TSM


Hi Wanda, 


I've heard 2013 Q1, but nothing more precise. 


We'll have to wait for an IBM guy in the list to answer. 


I'm not sure but I believe that LTO6 are available to sell but not to deliver 


Regards,
Erwann
Hi Wanda,

I've heard 2013 Q1, but nothing more precise.

We'll have to wait for an IBM guy in the list  to answer.

I'm not sure but I believe that LTO6 are available to sell but not to deliver

Regards,
Erwann
Prather, Wanda wanda.prat...@icfi.com a écrit :

Anybody heard when TSM will support LTO6? 

From: Stackwick, Stephen
Sent: Friday, November 30, 2012 1:18 PM
To: Prather, Wanda
Subject: LTO6 TSM 

Not on the list yet. 

STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | 
stephen.stackw...@icfi.commailto:sstackw...@icfi.com | 
icfi.comhttp://www.icfi.com/ ICF INTERNATIONAL | 410 E. Pratt Street Suite 
2214, Baltimore, MD 21202 | 410.539.1135 (o) 

Anybody heard when TSM will support LTO6?

From: Stackwick, Stephen
Sent: Friday, November 30, 2012 1:18 PM
To: Prather, Wanda
Subject: LTO6 TSM

Not on the list yet.

STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | 
stephen.stackw...@icfi.commailto:sstackw...@icfi.com | 
icfi.comhttp://www.icfi.com/ ICF INTERNATIONAL | 410 E. Pratt Street Suite 
2214, Baltimore, MD 21202 | 410.539.1135 (o)

Re: full library?

[J. Pohlmann]

There may be tapes in the library of which TSM has no knowledge. Do a 

Checkin libv library name search=yes checkl=b status=scr wait=0

That will look for any possible scratch tapes. After this process is complete, 
do a 

Checkin libv library name search=yes checkl=b status=priv wait=0

which will check in any tapes that TSM knows about but thinks that they are not 
in the library.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Dan 
Olson
Sent: Monday, November 26, 2012 17:08
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] full library?

Hi All...

So I've run into a strange problem.  I've got a tsm server attached to a 
spectra T950 library, with 890 slots in the partition.
Tsm knows about 870 tapes, verified with select count(*) from libvolumes.

When I go to checkin tapes from the CAP I get the message ANR8382W Library 1 
is now full.

I've audited the library and compared the inventory, and tsm's state is 
consistent with the library.

Any ideas?  Anyone know if that full message originates from TSMs state or a 
library return?


Daniel Murphy-Olson
Systems Administrator
Mathematics  Computer Science Division
Argonne National Laboratory

Re: AW: [ADSM-L] 6.4 docs

[J. Pohlmann]

A request to development - could someone please package the TSM 6.4 Infocenter 
into a downloadable package and put in the techprev directory on the ftp site 
along with the other downoadable Infocenters.

Thanks.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela 
Robertson
Sent: Tuesday, November 20, 2012 06:40
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] AW: [ADSM-L] 6.4 docs

The 6.4 Info Center is available:
http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/index.jsp

The ibm.com team has been contacted and the problem should not happen again. 
That said, if the problem persists, thanks for your patience. No one wants the 
site down... Angela


Angela Robertson
IBM Software Group, Tivoli Software
Durham, NC 27703
aprob...@us.ibm.com

“We are what we repeatedly do. Excellence, then, is not an act, but a habit.” - 
Aristotle

ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/20/2012
03:33:15 AM:

 Rainer Holzinger rainerholzin...@gmx.de Sent by: ADSM: Dist Stor 
 Manager ADSM-L@vm.marist.edu

 11/20/2012 03:33 AM

 Please respond to
 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu

 To

 ADSM-L@vm.marist.edu,

 cc

 Subject

 [ADSM-L] AW: [ADSM-L] 6.4 docs

 Hi Andy,

 for me the 6.4 Info Center is still not working.
 Following the link still results in service temporarily unavailable.

 Best regards,
 Rainer

 -Ursprüngliche Nachricht-
 Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag 
 von Andrew Raibeck
 Gesendet: Montag, 19. November 2012 20:37
 An: ADSM-L@VM.MARIST.EDU
 Betreff: Re: [ADSM-L] 6.4 docs

 6.4 Info Center is back up.

 Best regards,

 Andy Raibeck
 IBM Software Group
 Tivoli Storage Manager Client Product Development Level 3 Team Lead 
 Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS Internet 
 e-mail: stor...@us.ibm.com

 IBM Tivoli Storage Manager support web page:

http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Stor

 age_Manager

 ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 2012-11-19
 11:30:47:

  From: Stefan Folkerts stefan.folke...@gmail.com
  To: ADSM-L@vm.marist.edu,
  Date: 2012-11-19 11:34
  Subject: Re: 6.4 docs
  Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu
 
  Simon is the man of the day for me! :-D
 
 
  On Mon, Nov 19, 2012 at 9:37 AM, Erwann Simon erwann.si...@free.fr
 wrote:
 
   Hi all,
  
   It's not working for me either.
  
   Here's a dropbox link to the new publications (.pdf):
   http://db.tt/LWQajxwi
  
   You'll also find a quick review of the new functions.
  
   Regards,
   Erwann
  
  
   Remco Post r.p...@plcs.nl a écrit :
  
   Hi all,
   
   anyone getting something useful from
   http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4 ?
  
   --
   Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
  
 =

Re: Occupancy discrepancy between 6.1.5.10 and 6.2.3.0 server

[J. Pohlmann]

Do a set lic 1 - then your query auditoccupancy numbers a current to within
1 day as opposed to the default 30 days. That way, don't bother doing a
manual audit lic. Also, the server option AUDITSTORAGE needs to be set to
YES, which is the default (if you did nothing with this option, you did it
right).

Joerg Pohlmann
+1-250-585-3711



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Keith Arbogast
Sent: Thursday, March 08, 2012 05:31
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Occupancy discrepancy between 6.1.5.10 and 6.2.3.0
server

Jim,
Re: I found I had to run 'audit licenses' to update the occupancy values.
I have no idea why this would be the case.

One always has to run 'audit lic' to update the auditoccupancy table.

Keith

Re: Internally pre-labeled tapes?

[J. Pohlmann]

Why not update the library with autolabel=yes. Then the tapes are labeled on
first use and you don't need to worry about free drives. Just check them in
with checkl=b.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Richard Sims
Sent: Tuesday, November 15, 2011 10:30
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Internally pre-labeled tapes?

Experience shows that vendors can't be depended upon to fully and accurately
internally label magnetic media.
It is best to do it yourself, and be assured of having reliable labels - and
no ugly surprises that disrupt schedules.

   Richard Sims

On Nov 15, 2011, at 1:08 PM, Shawn Drew wrote:

 We normally purchase pre-labeled LTO4 tapes, but I'm wondering if
 anyone knows if there are vendors that sell prelabeled tapes that are
 also internally labeled with a TSM-compatible label.
 It just feels that the scratch tape label process is getting slower
 and the amount of free-tape-drive-time is getting less and less.

Re: TSM multi libraries in a single stgpool

[J. Pohlmann]

Or, if you want to go all-out, use eRMM - see

http://www-935.ibm.com/services/de/igs/pdf/br-stor-enterprise-remove-mm-en.p
df

that way, you can have many libraries managed by eRMM. TSM uses the external
library manager capability to have a storage pool cover many libraries.

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Remco Post
Sent: Wednesday, July 06, 2011 10:26
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM multi libraries in a single stgpool

On 6 jul 2011, at 14:09, Steven Langdale wrote:

 Can TSM support having two libraries in a single stgpool?  Looking to
 add another library but would to make sure it is used in tandem with
 our current library and not just sit there.

 Thank you,
 Vince


 Vince

 No you can't, it's one devclass in a stgpool and a devclass can only
 point to one library.

 Theres obviously nothing stopping you creating a new devclass and
 stgpool for this new library and pointing some servers at it to spread the
workload.


or, use one library for the primary pools and another for the copy pools, or
define one stgpool in the new library as the next for an existing pool in
the existing lib.

 Steven

--
Met vriendelijke groeten/Kind Regards,

Remco Post
r.p...@plcs.nl
+31 6 248 21 622

Re: volumes associated with a node

[J. Pohlmann]

Why not simply use q nodedata nodename - that will give all the volumes in
all storage pools that contain data for the node. You can subset this to q
nodedata nodename stg=storage pool name so that you get only the volumes
in the storage pool in question that contain data for the node of interest.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Paul Fielding
Sent: Wednesday, June 29, 2011 15:49
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] volumes associated with a node

Hmmm When I do show volumeusage NODENAME, I get no result, regardless
of node

Paul


On Wed, Jun 29, 2011 at 2:49 PM, Shawn Drew 
shawn.d...@americas.bnpparibas.com wrote:

 I would go with the volumeusage table instead of contents if you just 
 want the tapes for a node.
 select distinct(volume_name) from volumeusage where node_name='NODENAME'
 (that will show copypool volumes also)

 Alternatively, there is a show command:
 show volumeusage NODENAME


 Regards,
 Shawn
 
 Shawn Drew





 Internet
 evergreen.sa...@gmail.com

 Sent by: ADSM-L@VM.MARIST.EDU
 06/29/2011 09:09 AM
 Please respond to
 ADSM-L@VM.MARIST.EDU


 To
 ADSM-L
 cc

 Subject
 Re: [ADSM-L] volumes associated with a node






 select volume_name from contents where node_name like '%nodename%' and 
 FILESPACE_NAME like '%Filespacename%' and FILE_NAME like '%Filename%'

 On Wed, Jun 29, 2011 at 3:48 PM, molin gregory
 gregory.mo...@afnor.orgwrote:

  Hello,
 
  Try : q nodedata NODENAME stg=
 
  Cordialement,
  Grégory Molin
  Tel : 0141628162
  gregory.mo...@afnor.org
 
  -Message d'origine-
  De : ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] De la 
  part de Tim Brown Envoyé : mercredi 29 juin 2011 14:40 À : 
  ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] volumes associated with a node
 
  Is there a select statement that will list all tape volumes that 
  have
 files
  for
 
  a given TSM node.
 
 
 
  Thanks,
 
 
 
  Tim Brown
  Systems Specialist - Project Leader
  Central Hudson Gas  Electric
  284 South Ave
  Poughkeepsie, NY 12601
  Email: tbr...@cenhud.com mailto:tbr...@cenhud.com
  Phone: 845-486-5643
  Fax: 845-486-5921
  Cell: 845-235-4255
 
 
 
 
  This message contains confidential information and is only for the
 intended
  recipient. If the reader of this message is not the intended 
  recipient,
 or
  an employee or agent responsible for delivering this message to the
 intended
  recipient, please notify the sender immediately by replying to this 
  note
 and
  deleting all copies and attachments.
 
  ATTENTION.
 
  Ce message et les pièces jointes sont confidentiels et établis à 
  l'attention exclusive de leur destinataire (aux adresses spécifiques 
  auxquelles il a été adressé). Si vous n'êtes pas le destinataire de 
  ce message, vous devez immédiatement en avertir l'expéditeur et 
  supprimer
 ce
  message et les pièces jointes de votre système.
 
  This message and any attachments are confidential and intended to be 
  received only by the addressee. If you are not the intended 
  recipient, please notify immediately the sender by reply and delete 
  the message and
 any
  attachments from your system. 
 



 --
 Thanks  Regards,
 Sarav
 +974-3344-1538

 There are no secrets to success. It is the result of preparation, hard 
 work and learning from failure - Colin Powell



 This message and any attachments (the message) is intended solely 
 for the addressees and is confidential. If you receive this message in 
 error, please delete it and immediately notify the sender. Any use not 
 in accord with its purpose, any dissemination or disclosure, either 
 whole or partial, is prohibited except formal approval. The internet 
 can not guarantee the integrity of this message. BNP PARIBAS (and its 
 subsidiaries) shall (will) not therefore be liable for the message if 
 modified. Please note that certain functions and services for BNP 
 Paribas may be performed by BNP Paribas RCC, Inc.

Re: Tsm v6 migration question

[J. Pohlmann]

Gary, please take a look at

http://www-01.ibm.com/support/docview.wss?uid=swg21421060myns=swgtivmynp=O
CSSGSG7mync=E

I found that the actual amount of space for the DB has been , 2 X. I
generally recommend that a file system of 3 X the v5 database be set aside.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Lee, Gary D.
Sent: Wednesday, March 23, 2011 10:44
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Tsm v6 migration question

We are preparing to migrate our tsm v5,5,4 system to 6.2.2.


Are there any rules of thumb for relating db size in v5.5.4 with what we
will need under v6?

I assume it will be somewhat larger being a truly relational structure.

Thanks for any help.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

Re: TIP performance on Windows

[J. Pohlmann]

Wanda, did you try IE9? Suggest you install it on a test PC first, IE9 has
just been released. I have been using the release candidate and it really is
noticeable faster than anything else.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Monday, March 14, 2011 13:43
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TIP performance on Windows

Thanks for your response!

Performance degradation is throughout, for even the simplest functions.
For example,
When I pull down Select Action  Create Schedule, it takes 8 seconds to open
the Create Schedule wizard.
When I click the Next button on the first page of the Create Schedule
wizard, response is 5 seconds.
When I then click the Cancel button, response is 7 seconds.
This was not a problem with the 6.1.3.0 ISC; no other hardware or software
has changed, except upgrading the ISC  from 6.1.3.0 to TIP 6.2, and
upgrading TSM from 6.1.3.3. to TSM 6.2.2.

There is no delay getting response back from the TSM server; response to Q
schedule from the admin command line is sub-second.
My connection to the server is via 127.0.0.1, so there should be no network
delay involved.
IE browser is IE7.0.5730.13.
You did give me an idea, though; I installed Mozilla 3.05 and response seems
to be about half that of IE, although still not as good as for ISC 6.1.3.

Any suggestions welcomed - if you can point me to any resources for
improving this I would appreciate it.  My customer is not happy with the
upgrade experience!

Thanks
Wanda Prather



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Gergana V Markova
Sent: Saturday, March 12, 2011 12:54 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TIP performance on Windows

Wanda,

what browser are you using in particular?
And are you seeing the performance degradation in specific areas of the
interface ( e.g health Monitor? )

Thanks.

Regards/Pozdravi, Gergana

| |  ~\\  !  //~
| |   ( ( 'o . o' ) )Imagination can change the equation . . .
| |(  w  )
| |  Gergana V Markovagmark...@us.ibm.com  (+1 US) 520 799 5716
T/L 321-5716
| |  Advisory Software Engineer - IBM Tivoli Storage Manager Server
Development
| |
| | IBM Centers for Advanced Studies   http://www.ibm.com/ibm/cas
| | IBM Women Inventors Community
http://w3.webahead.ibm.com/w3ki/display/womeninventors/Home
| | IBM Emerging Technologies  http://www.alphaworks.ibm.com/
| | IBM DeveloperWorks
http://www-128.ibm.com/developerworks/
| | IBM Women In Action
http://w3.tap.ibm.com/w3ki2/display/AoTWIT/3.+Women+Speaker+Series+2009



From:
Prather, Wanda wprat...@icfi.com
To:
ADSM-L@vm.marist.edu
Date:
03/11/2011 02:31 PM
Subject:
[ADSM-L] TIP performance on Windows



TSM on Win2K3 (32 bit),
4-way processor, 16G ram, EMC disk, 260GB TSM data base, standard d-2-t
backup, no dedup.
Runs like a cheetah.
AC on the same server as TSM.

Recently upgraded in place from
TSM 6.1.3.3 w/ AC 6.1.3 to
TSM 6.2.2.0 w/ TIP 6.2

TSM server  DB2 still run like a cheetah.
But the TIP performance is miserably slw compared to previous
performance of AC 6.1.3, which was quite spiffy.
Nothing else changed with the hardware or workload; accessing the TIP the
same way we accessed AC6.1.3, from the browser on the server hosting the TIP
itself.

Can anybody point me to resources for identifying/improving TIP performance
issues?

Thx
Wanda






Wanda Prather  |  Senior Technical Specialist  | wprat...@icfi.com
mailto:wprat...@icfi.com  |  www.jasi.comwww.jasi.com%20 ICF Jacob 
Sundstrom  | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202
| 410.539.1135

Re: Does Move Data recover space on virtual volumes?

[J. Pohlmann]

This is where one additional point comes to mind - that of the size of virtual 
volumes which is controlled with MAXCAP on the device class definition on the 
source server. You can change the value MAXCAP any time. The larger the virtual 
volume, the more white space you carry at the target server. It's difficult 
to get an actual number of the amount of white space, but the logic is as 
follows: Assume you have MAXCAP specified on the source server of 100GB. Assume 
at the source server you are running reclamation at 50%. Note that all virtual 
volumes are marked full at the end of a process, so there may be some amount of 
virtual volumes that are smaller than 100GB. For the purposes of a calculation 
though, let's assume they are all 100GB. Let's further assume that you have 500 
volumes that meet the 50% reclamation threshold. The amount of white space at 
the target server therefore is 500 volumes * 100 GB * 50% =  25 TB of white 
space, which with LTO4 technology is more than 15 tape cartridges. So, it is 
useful to set the DELGRACEPERIOD to zero for your server definitions such that 
you gain back space more quickly. I would also suggest that you run reclamation 
at 50 % on the virtual volumes on the source server. I would also run 
reclamation at the target server very aggressively, namely 50%. To reduce the 
overall white space at the target server, you can reduce the source server's 
MAXCAP specification. One watch-for is that you can get into a situation where 
you now have many small virtual volumes whose corresponding archive objects at 
the target server are scattered across many physical tapes. In such a 
situation, access to large quantities of data by the source server can result 
in an intolerable number of tape mounts at the target server and slow down the 
source server's performance to unacceptable levels. If however the target 
server is not using physical tapes but instead is using disk via a file device 
class, then it is very much worthwhile to have more smaller virtual volumes at 
the source server, therefore more smaller archive objects at the target server 
and therefore less white space. You can get an estimate of the number of 
volumes meeting a given reclamation threshold with a script that I use called 
tl. The script is shown below. Here is a sample of the output where a physical 
tape and a virtual volume would meet a reclamation threshold at 50 percent. 
This was run at the source server.

 

tsm: IT-TSMru tl 50

Session established with server IT-TSM: Windows

  Server Version 6, Release 2, Level 0.0

  Server date/time: 03/14/2011 18:14:10  Last access: 03/14/2011 17:29:44

 

 

Total tapes meeting criterion

--

 1

 

STGPOOL_NAME: BACKUPTAPE

VOLUME_NAME: A00031

PCT_UTILIZED: 31.6

PCT_RECLAIM: 68.5

 

 

Total volumes meeting criterion



   1

 

 STGPOOL_NAME: COPYPOOL

VOLUME_NAME  : IT-TSM-DR.BFS.297618097

 UTIL: 27.3

 RECL: 72.7

  EST_CAPACITY_MB: 51200.0

 

ANR1462I RUN: Command script TL completed successfully.

 

Hope this helps.

 

Regards,

 

Joerg Pohlmann

 

 

tsm: IT-TSMq scr tl f=l

 

Name   Line   Command

   Number

-- -- 


TL 1  select count(*) as Total tapes meeting criterion 
from

   volumes -

   5  where devclass_name  'DISK' and stgpool_name not 
like

   '%COPY%' and pct_reclaim $1 and status in ('FULL',

   'FILLING')

   10 select stgpool_name, volume_name, pct_utilized, 
pct_reclaim

   from volumes -

   15 where devclass_name  'DISK' and stgpool_name not 
like

   '%COPY%' and pct_reclaim $1 and status in

   ('FULL','FILLING') order by stgpool_name asc, 
pct_reclaim

   desc

   20 select count(*) as Total volumes meeting criterion 
from

   volumes -

   25 where devclass_name  'DISK' and stgpool_name like 
'%COPY%'

   and pct_reclaim $1 and status not in ('PENDING', 
'EMPTY')

   30 select stgpool_name, volume_name as VOLUME_NAME  
,

   pct_utilized as UTIL, pct_reclaim as RECL, 
est_capacity_mb

   from volumes -

   35 where devclass_name  'DISK' and stgpool_name like 
'%COPY%'

   and pct_reclaim $1 and status not in ('PENDING', 
'EMPTY')

   order by stgpool_name asc, pct_reclaim desc

 

tsm: IT-TSM

 

 

-Original Message-
From: ADSM: Dist Stor Manager 

Re: TIP performance on Windows

[J. Pohlmann]

Agree, but it's worth a try to see whether or not it's the browser causing
grief or the TIP itself.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Monday, March 14, 2011 18:04
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TIP performance on Windows

Well, the TIP is not supported on IE9.  It isn't even supported on IE8.  So
I can't get any help from IBM on fixing things with IE9.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of J.
Pohlmann
Sent: Monday, March 14, 2011 6:46 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TIP performance on Windows

Wanda, did you try IE9? Suggest you install it on a test PC first, IE9 has
just been released. I have been using the release candidate and it really is
noticeable faster than anything else.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Monday, March 14, 2011 13:43
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TIP performance on Windows

Thanks for your response!

Performance degradation is throughout, for even the simplest functions.
For example,
When I pull down Select Action  Create Schedule, it takes 8 seconds to open
the Create Schedule wizard.
When I click the Next button on the first page of the Create Schedule
wizard, response is 5 seconds.
When I then click the Cancel button, response is 7 seconds.
This was not a problem with the 6.1.3.0 ISC; no other hardware or software
has changed, except upgrading the ISC  from 6.1.3.0 to TIP 6.2, and
upgrading TSM from 6.1.3.3. to TSM 6.2.2.

There is no delay getting response back from the TSM server; response to Q
schedule from the admin command line is sub-second.
My connection to the server is via 127.0.0.1, so there should be no network
delay involved.
IE browser is IE7.0.5730.13.
You did give me an idea, though; I installed Mozilla 3.05 and response seems
to be about half that of IE, although still not as good as for ISC 6.1.3.

Any suggestions welcomed - if you can point me to any resources for
improving this I would appreciate it.  My customer is not happy with the
upgrade experience!

Thanks
Wanda Prather



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Gergana V Markova
Sent: Saturday, March 12, 2011 12:54 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TIP performance on Windows

Wanda,

what browser are you using in particular?
And are you seeing the performance degradation in specific areas of the
interface ( e.g health Monitor? )

Thanks.

Regards/Pozdravi, Gergana

| |  ~\\  !  //~
| |   ( ( 'o . o' ) )Imagination can change the equation . . .
| |(  w  )
| |  Gergana V Markovagmark...@us.ibm.com  (+1 US) 520 799 5716
T/L 321-5716
| |  Advisory Software Engineer - IBM Tivoli Storage Manager Server
Development
| |
| | IBM Centers for Advanced Studies   http://www.ibm.com/ibm/cas
| | IBM Women Inventors Community
http://w3.webahead.ibm.com/w3ki/display/womeninventors/Home
| | IBM Emerging Technologies  http://www.alphaworks.ibm.com/
| | IBM DeveloperWorks
http://www-128.ibm.com/developerworks/
| | IBM Women In Action
http://w3.tap.ibm.com/w3ki2/display/AoTWIT/3.+Women+Speaker+Series+2009



From:
Prather, Wanda wprat...@icfi.com
To:
ADSM-L@vm.marist.edu
Date:
03/11/2011 02:31 PM
Subject:
[ADSM-L] TIP performance on Windows



TSM on Win2K3 (32 bit),
4-way processor, 16G ram, EMC disk, 260GB TSM data base, standard d-2-t
backup, no dedup.
Runs like a cheetah.
AC on the same server as TSM.

Recently upgraded in place from
TSM 6.1.3.3 w/ AC 6.1.3 to
TSM 6.2.2.0 w/ TIP 6.2

TSM server  DB2 still run like a cheetah.
But the TIP performance is miserably slw compared to previous
performance of AC 6.1.3, which was quite spiffy.
Nothing else changed with the hardware or workload; accessing the TIP the
same way we accessed AC6.1.3, from the browser on the server hosting the TIP
itself.

Can anybody point me to resources for identifying/improving TIP performance
issues?

Thx
Wanda






Wanda Prather  |  Senior Technical Specialist  | wprat...@icfi.com
mailto:wprat...@icfi.com  |  www.jasi.comwww.jasi.com%20 ICF Jacob 
Sundstrom  | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202
| 410.539.1135

Re: Managing/deleting DBSNAPSHOTs

[J. Pohlmann]

Zoltan, use reconcile volumes fix=yes at the source server to get rid of
dangling archive objects at the target server. I have a couple of customers
that have a PMR open for the archive objects of virtual volumes not being
deleted at the target server. You might want to open a PMR too so that there
is more evidence of this phenomenon. This started with v6.1 and in one
installation that is not using tape but instead file device class at the
target server I had to run regular reconcile volumes fix=yes commands
because they ran out of space. Regardless of whether you are using file or
disk device class to store the data at the target server, reconcile volumes
fix=yes at the source server will communicate with the target server to
inactivate the dangling archive objects. Then run expire inv at the target
server to physically remove the objects. For file device class, the flat
files will be deleted (assuming they are scratch volumes) and for disk
device class volumes the pages will be freed up.

 And, yes, the comment about delg=0 is quite correct. Use q server f=s to
find out what it is, then update server name delg=0.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Tuesday, December 21, 2010 07:18
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Managing/deleting DBSNAPSHOTs

We have setup a small, offsite TSM server to function as a repository of
across-the-wire DBSNAPSHOT database backups for our production TSM servers.
We want each server to perform daily dbsnapshot backups to this server.
Since the offsite server currently has limited disk space (2-dbsnapshots for
all servers), we need to expire/purge the previous
dbsnapshot-1 before we can perform another dbsnapshot.

I have everything configured and the dbsnapshots work as expected.

My problem is this.  How to I get the dbsnapshots to expire/go away on the
offsite server?  What controls the expiration of the dbsnapshots?  I have
run delete volhist devclass todate=today-1 type=dbsnapshot commands and it
says they are deleted but the space is not release on the offsite server?  I
have had to perform manual delete filespace ... type=server
on the offsite server but that deletes everything in the filespace.

What am I missing?
Zoltan Forray
TSM Software  Hardware Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
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

Re: Select works in 5.5 but not in 6.x

[J. Pohlmann]

Christian, I got the same results as Zoltan on my Windows 6.2.2.0 server -
also confirmed that the select works fine on my 5.5.4.3 server.

Regards,

Joerg Pohlmann

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Monday, December 20, 2010 08:36
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select works in 5.5 but not in 6.x

FWIW, I jumped into dsmadmc on my 6.2.2.0 server and issued the select.
This is what I got:

tsm: SUNselect nodes.domain_name, nodes.node_name, auditocc.backup_mb from
nodes,auditocc where nodes.node_name=auditocc.node_name order by
nodes.domain_name,nodes.node_name ANR0162W Supplemental database diagnostic
information:  -1:42S22:-206 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0206N
NODES.NODE_NAME is not valid in the context where it is used.
SQLSTATE=42703 ).
ANR2940E The command 'select nodes.domain_name , nodes.node_name ,
auditocc.backup_mb from NODESVIEW , auditocc where nodes.node_name =
auditocc.node_name order by nodes.domain_name , nodes.node_name ' contains
an unknown SQL column name.
ANS8001I Return code 3.

tsm: SUN
Zoltan Forray
TSM Software  Hardware Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
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



From:
Prather, Wanda wprat...@icfi.com
To:
ADSM-L@VM.MARIST.EDU
Date:
12/20/2010 10:16 AM
Subject:
Re: [ADSM-L] Select works in 5.5 but not in 6.x Sent by:
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU



Known bug.
You can't do joins in 6.x (usually you don't get errors, you just get no
data, which is worse).
Occasionally it works, but don't rely on any results you get.
Multiple APARS.  IC68322, IC63474, IC70346
IC63474 lists the tables it is supposed to affect, but that's incorrect -
can affect any tables.
Was supposed to be fixed in 6.2.1, but wasn't.
Now it's supposed to be fixed in 6.2.2, but I don't have a 6.2.2 server to
test, so I don't know if it's really fixed or not.

W

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Christian Svensson
Sent: Monday, December 20, 2010 9:58 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select works in 5.5 but not in 6.x

Hi,
Can anyone explain why this select command works fine in TSM 5.5 and not in
TSM 6.x?
Even if all information are still their.

select nodes.domain_name, nodes.node_name, auditocc.backup_mb from
nodes,auditocc where nodes.node_name=auditocc.node_name order by
nodes.domain_name,nodes.node_name

Happy Holiday
Christian Svensson

Best Regards
Christian Svensson

Cell: +46-70-325 1577
E-mail: christian.svens...@cristie.se
Skype: cristie.christian.svensson
Supported Platform for CPU2TSM::
http://www.cristie.se/cpu2tsm-supported-platforms

Re: select statement to display readonly and filling tapes

[J. Pohlmann]

For what it's worth, here is my reado script to display problem tapes:

issue message i Read Only Volumes
q vol acc=reado
issue message i Unavailable Volumes
q vol acc=unav
issue message i Destroyed Volumes
q vol acc=destroyed
issue message i The following volumes had I/O errors:
select volume_name as VOLUME   , stgpool_name,
write_errors, read_errors from volumes where write_errors 0 or read_errors
0

Joerg Pohlmann
250-585-3711



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Guido Martínez
Sent: Monday, November 15, 2010 09:35
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] select statement to display readonly and filling tapes

Perhaps this would also work:

Select VOLUME_NAME from VOLUMES where status='FILLING' and access='READONLY'

El nov 15, 2010 11:30 a.m., Keith M Williams kwill...@us.ibm.com
escribió:

How about  this for TSM:

select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS from
media where VOLUME_NAME='FILLING'

Keith M Williams/Dubuque/IBM
Unix System Administrator, IBM Dubuque
ITDelivery, Global Technology Services
kwill...@us.ibm.com




From:

Timothy Hughes timothy.hug...@oit.state.nj.us
To:
ADSM-L@vm.marist.edu
Date:
11/15/2010 07:40 AM
Subject:

select statement to display readonly and filling tapes Sent by:
ADSM: Dist Stor Manager ADSM-L@vm.marist.edu




Hi

I am trying to add filling tapes to this select statement and I am having
no luck does anyo...

Re: How to monitor Archive Log space in TSM V6?

[J. Pohlmann]

TSM will monitor the usage of the archive log file system (please make sure 
it's a file system/Windows drive, not just a directory in some file system). If 
you find that there are frequent database backups triggered, you might want to 
make the file system/Windows drive bigger. There is an undocumented dsmserv.opt 
option, ARCHLOGUSEDTHRESHOLD xx where xx is the percentage fullness of the file 
system that you are using for the archive log file system to trigger a database 
backup. If you have a large file system, say 500GB or 500GB, and you find that 
there is a lot of empty space in it, you might want to set xx fairly high, for 
example ARCHLOGUSEDTHRESHOLD 90. I don't know if this option will be documented 
or if it will persist over TSM releases. Other options have become invalid, for 
example the DISKSTGPOOLMemsize option is no longer valid even though it is 
still documented in the 6.2 Admin Ref book.

Joerg Pohlmann
250-585-3711

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Scott 
McCambly
Sent: Friday, October 01, 2010 10:58
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How to monitor Archive Log space in TSM V6?

Yes. Q LOG F=D only shows the Active Log space.

It is true that if the Archive Log space fills to 100% then the Active Log 
would not be able to clear archived logs and it too would then begin filling 
towards 100%, but I want to know about the Archive Log being full long before 
then, and before an automatic backup is triggered by DB2.

Also, I would simply like to track the usage during the day.

Quoting Vandeventer, Harold [BS] harold.vandeven...@da.ks.gov:
 Are you looking for more than the Q LOG FORMAT=DETAILED produces?



 Happy Friday everyone.

 Does anyone know of a way to monitor the current utilization, along 
 with total and free space, in the Archive Log directory from within 
 TSM or DB2?  I guess this is really a DB2 question.

 It is clear that DB2 does this internally so that it can trigger 
 automated DB backups, but I have never seen any reference to queries 
 or tables accessible via SQL that report anything other than the size 
 and utilization of the space within the pre-allocated Active Log 
 files.

 I am trying to remotely monitor this resource on a number of TSM 
 servers on different platforms and don't want to go the route of rsh/rexec if 
 possible.

 Thanks!
 Scott

Re: Shoot self in foot - must recreate part of a inactive policy set

[J. Pohlmann]

If your active policy set is OK, then copy po domain_name active
some_inactive_name_eg_STANDARD. Then activate po domain_name
policyset_name and you're back in sync.

Joerg Pohlmann
250-585-3711

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Richard Rhodes
Sent: Tuesday, September 21, 2010 10:55
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Shoot self in foot - must recreate part of a inactive
policy set

What pain . . . .

I have a node that I need to move to it's own domain with special default
mgt classes.  For a base I copied the existing domain that it's in to a new
domain and started changing the inactive policy set - deleting mgt classes I
don't need.

Opps . . . I'm deleting stuff out of the origional domain inactive
policyset.

I caught myself after deleting
several archive mgt classes.  I haven't touched the ACTIVE policy set (ie: I
didn't activate the inactive policy set I was editing).  Now I need to
recover the deleted archive mgt classes.

I could just reenter the deleted archive mgt classes, but I'm wondering if
the easier thing is to just delete the inactive policy set and copy the
active policy set to the name of the inactive I deleted?


Thanks

Rick


-
The information contained in this message is intended only for the personal
and confidential use of the recipient(s) named above. If the reader of this
message is not the intended recipient or an agent responsible for delivering
it to the intended recipient, you are hereby notified that you have received
this document in error and that any review, dissemination, distribution, or
copying of this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete the
original message.

Re: separate volumes for different stg

[J. Pohlmann]

Suggest you create a tape storage pool called ARCHIVETAPE, update stg
archivepool next=archivetape, then move nodedata node1,node2,node3,...
from=pool0 to=archivetape type=archive and, if you have n tape drives, add
maxprocess=n/2.

Joerg Pohlmann
250-585-3711


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Steven Langdale
Sent: Saturday, July 24, 2010 11:25
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] separate volumes for different stg

Archives and backups from the same hosts?   If yes, then no I don't think
there is.
If no, then you can differentiate by node, and use collocation groups.

Failing that, have different backup  archive tape pool hierachies - which
would probably be the more sensible option anyway.

Steven





Mehdi Salehi ezzo...@googlemail.com
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
24/07/2010 16:06
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU


To
ADSM-L@VM.MARIST.EDU
cc

Subject
[ADSM-L] separate volumes for different stg




Caterpillar: Confidential Green Retain Until: 23/08/2010



Hi,
A tape-based pool called pool0 is the next storage pool of backuppool and
archivepool. Is there anyway to have separate cartridges for backup and
archive in pool0?

Thanks

Re: TSM v6 - virtual volume deletion leaves archive objects on target server

[J. Pohlmann]

Hi Dave. The two situations where I am experiencing this are non-dedupe
environments. Both installations have a copypool using devclass=vv (devclass
vv is a server device type device class). In both situations there is a
vvpool - vvtape storage pool hierarchy on the target server such that
prepare devc=vv_small pops the RPF archive object onto a device class disk
storage pool and the large device class vv archive objects can be directed
either to disk or the next storage pool based on maxsize for the vvpool. In
one installation the next storage pool is device class LTO, and in the other
installation it's device class SATA which is a device type FILE device
class. Both installations were v5 to v6 upgrades. In the tape-less
environment, I have set delgraceperiod to 0 because of disk space
constraints. Our problem in both environments is a superset of

http://www-01.ibm.com/support/docview.wss?uid=swg21395087

which talks only about the database backups.

As to being able to stuff the archive objects into a dedupe pool, I assume
that this is now allowed, based on

http://www-01.ibm.com/support/docview.wss?uid=swg1IC64970

The question is, will the archive objects actually be deduped (assuming that
the target server has DEDUPREQUIRESBACKUP NO set in dsmserv.opt).

There is a PMR in the process of being submitted, once I have the PMR number
I will send it to your LN ID.

Joerg Pohlmann
250-686-3711

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Dave Canan
Sent: Wednesday, July 14, 2010 10:30
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM v6 - virtual volume deletion leaves archive
objects on target server

Joerg, I checked with development on this. Are you doing this with a dedup
storage pool? They did have one APAR for that 2 months ago. I would first
suggest getting a PMR opened; if you do that, I can pursue it.



Dave Canan
IBM Advanced Technical Support
TSM Performance
ddcananATUSDOTIBMDOTCOM

On Mon, Jul 12, 2010 at 6:16 PM, J. Pohlmann jpohlm...@shaw.ca wrote:

 I am just wondering if other folks have encountered this problem where
 the deletion of a virtual volume (for example as result of
 reclamation) on the source server leaves the archive object dangling on
the target server.
 Delgraceperiod is the default of 5 days. Reconcile volumes fix=yes
 cleans it all up again. I have seen this on TSM v6.1 and v6.2. TSM v5
 works fine with this default. Does anyone have a fix for this? I have
 been doing ad-hoc periodic reconcile volumes for months on a v6
 virtual volume environment because I first suspected server-to-server
 communications problems, but then saw the same thing happen in other
 installations.



 Joerg Pohlmann

 250-585-3711

TSM v6 - virtual volume deletion leaves archive objects on target server

[J. Pohlmann]

I am just wondering if other folks have encountered this problem where the
deletion of a virtual volume (for example as result of reclamation) on the
source server leaves the archive object dangling on the target server.
Delgraceperiod is the default of 5 days. Reconcile volumes fix=yes cleans it
all up again. I have seen this on TSM v6.1 and v6.2. TSM v5 works fine with
this default. Does anyone have a fix for this? I have been doing ad-hoc
periodic reconcile volumes for months on a v6 virtual volume environment
because I first suspected server-to-server communications problems, but then
saw the same thing happen in other installations.



Joerg Pohlmann

250-585-3711

Re: tape stg capacity

[J. Pohlmann]

In many installations it's a close to meaningless number. For empty tapes,
it's the estimated capacity of the tape multiplied by maxscratch. Then as
tapes become full, the actual number of bytes written will modify the
estimated capacity value. The actual bytes written depends on
compressibility of the data.  The reason why in most of my installations it
is a meaningless number is that tape libraries are managed by the number of
scratch tapes available. I generally suggest that there should be about 10%
scratch tapes in a tape library or at least five (five is also the threshold
value for attention grabbers in the TSM v5 Operational Reporting Facility).
Tape storage pools are then not restricted by the number of scratch tapes
that may be assigned. Very often maxscratch is set to 1 or some such
number. You will often find large maxscratch values also in server-to-server
virtual volume environments where the maximum capacity in most cases is set
to be significantly smaller than the capacity of, for example LTO3 or LTO4
tapes.

Note that for device class disk storage pools the estimated capacity is the
actual capacity.

Joerg Pohlmann
250-585-3711

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Mehdi Salehi
Sent: Friday, July 09, 2010 08:06
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] tape stg capacity

Hi,
How is tape storage pool estimated capacity calculated? I see different
values for similar storage pools of the same devclass and maxscratch.

Thanks

Re: sample script q_ses_stats on v6 servers produces unbelievabl

[J. Pohlmann]

Thanks Scott. Looks like someone in development overlooked the q_ses_stats
script in the scripts.smp file for the new time calculation function. Here
is the updated version - it works on my 6.2.1.0 lab server, but I would
appreciate a quick check on your part as my lab does not have much of any
workload. Perhaps you can test it on your TSM server Interestingly, on one
of my customers' it blows up on 6.1.3.1 and 6.2.1.0 on the timestampdiff
function being absent. I would appreciate it if someone can shed some light
on this problem.

Here is the new script:

/*  -*/
/*  Script Name:  Q_SES_STATS*/
/*  Description: Display connection time */
/*   and send and receive*/
/*   throughput for active   */
/*   sessions*/
/*  Parameter:   none*/
/*  Example:  run q_ses_stats*/
/*  -*/
select session_id as Session, -
  client_name as Client, state as State, -
  timestampdiff(2,char(current_timestamp-start_time)) as Elapsed Time,-
  (cast(bytes_sent as decimal(18,0)) / -
  cast(timestampdiff(2,current_timestamp-start_time) as -
  decimal(18,0))) Bytes sent/second,-
  (cast(bytes_received as decimal(18,0)) / -
  cast(timestampdiff(2,current_timestamp-start_time) as -
  decimal(18,0))) Bytes received/second -
  from sessions where -
  cast(timestampdiff(2,(current_timestamp-start_time)) -
  as decimal)  0

Here is the error regarding the timestampdiff function:

tsm: TSM01ru q_ses_stats_v6
Session established with server TSM01: Windows
  Server Version 6, Release 1, Level 3.1
  Server date/time: 07/06/2010 10:11:19  Last access: 07/06/2010 10:10:44

ANR0162W Supplemental database diagnostic information:  -1:42884:-440
([IBM][CLI Driver][DB2/NT64] SQL0440N  No authorized routine named
TIMESTAMPDIFF of type FUNCTION having compatible arguments was found.
SQLSTATE=42884
).
ANR0516E SQL processing for statement select session_id as Session ,
client_name as Client , state as State , timestampdiff ( 2 , char (
current_timestamp-start_time ) ) as Elapsed Time , ( cast ( bytes_sent as
decimal ( 18 , 0 ) ) / cast ( timestampdiff ( 2 ,
current_timestamp-start_time
) as decimal ( 18 , 0 ) ) ) Bytes sent/second , ( cast ( bytes_received as
decimal ( 18 , 0 ) ) / cast ( timestampdiff ( 2 ,
current_timestamp-start_time
) as decimal ( 18 , 0 ) ) ) Bytes received/second from sessions where cast
(
timestampdiff ( 2 , ( current_timestamp-start_time ) ) as decimal )  0
failed.
ANR0162W Supplemental database diagnostic information:  -1:42884:-440
([IBM][CLI Driver][DB2/NT64] SQL0440N  No authorized routine named
TIMESTAMPDIFF of type FUNCTION having compatible arguments was found.
SQLSTATE=42884
).
ANR0516E SQL processing for statement select session_id as Session ,
client_name as Client , state as State , timestampdiff ( 2 , char (
current_timestamp-start_time ) ) as Elapsed Time , ( cast ( bytes_sent as
decimal ( 18 , 0 ) ) / cast ( timestampdiff ( 2 ,
current_timestamp-start_time
) as decimal ( 18 , 0 ) ) ) Bytes sent/second , ( cast ( bytes_received as
decimal ( 18 , 0 ) ) / cast ( timestampdiff ( 2 ,
current_timestamp-start_time
) as decimal ( 18 , 0 ) ) ) Bytes received/second from sessions where cast
(
timestampdiff ( 2 , ( current_timestamp-start_time ) ) as decimal )  0
failed.
ANR1463E RUN: Command script Q_SES_STATS_V6 completed in error.
ANS8001I Return code 4.

tsm: TSM01

Joerg Pohlmann
250-585-3711


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
mccambly
Sent: Monday, July 05, 2010 13:57
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] sample script q_ses_stats on v6 servers produces
unbelievabl

Hi Joerg,

You are running into the problem that the old syntax of (time1-time2)seconds
works but doesn't produce the same results in V6 as in V5.

In V5 it gave the timestamp difference in seconds (perfect) but in V6 it
just gives the difference of the 'seconds portion' of the two timestamps.

IBM did not explain/correct this in their migration documentation until much
later after the V6.1 release.

So now to get the same results you must use the db2 timestampdiff()
function like this timestampdiff(2,char(timestamp1-timestamp2)) where 2 is
the argument to return seconds.  google for the full syntax.

Scott.



J. Pohlmann wrote:
 Has anyone experienced and found a fix for the sample script that measures
 session speeds. The sample script q_ses_stats is identical for v5 and v6
and
 runs fine on v 5 and v6 - except that on v6.1 and v6.2 it produces
 unbelievable numbers (100s of MB/sec received or sent).



 Joerg Pohlmann

 250-585-3711


+--
|This was sent by mccam...@unopsys.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--

sample script q_ses_stats on v6 servers produces unbelievably high numbers

[J. Pohlmann]

Has anyone experienced and found a fix for the sample script that measures
session speeds. The sample script q_ses_stats is identical for v5 and v6 and
runs fine on v 5 and v6 - except that on v6.1 and v6.2 it produces
unbelievable numbers (100s of MB/sec received or sent).



Joerg Pohlmann

250-585-3711

TSM server v6 ba volhist requirement

[J. Pohlmann]

Does anyone know if this requirement (ref
http://www-01.ibm.com/support/docview.wss?uid=swg21399352 ) still exists
with v6.2.1? The volume history gets written out to the volume history file
with every update/change of the volume history. The Maintenance Plan of the
AdminCenter does not create a backup volhist presumably due to the fact that
it is automatically externalized anyway. The Maintenance Plan does create a
prepare statement in a DRM environment, which in my opinion is key to
recovery in a disaster. The recovery plan file created by the prepare
command contains the volume history file. Could someone from development
please comment.



Thanks.



Joerg Pohlmann

250-585-3711

sample script q_ses_stats gives overstated bytes/sec on v6.1.3.1

[J. Pohlmann]

I am getting vastly overstated speeds running the sample script q_ses_stats
on TSM 6.1.3.1 - works fine on v5. Example -  a virtual volume session on v5
(the sending session) gives me about 51 MB/sec which sounds very plausible.
The receiving node on v6 gives me about 480 MB/sec which looks like it is
out by a factor of 10 - sometimes it is overstated even higher. The data
flow is from an LTO4 tape via 1GbE to LTO4 tape (ba stg backuptape copypool
where copypool is based on virtual volumes at the source server; data is
sent directly to tape at the target server; steady state where 100s of GB
are being backed up).  I did a select * from sessions on v6 and it looks OK.
Seems like somewhere in the arithmetic something goes wrong. Has anyone else
experienced this? If so is there a fix?



Joerg Pohlmann

250-585-3711

Re: define volume takes a long time in AIX

[J. Pohlmann]

Mehdi, Windows can allocate a file in NTFS without having to write data
into it. The Linux/Unix (including AIX) platforms have to write data into a
file in order to create it to the desired size. You can actually see the
progress of the file being created on Unix - cd into the directory in which
the file is being created as result of your define volume TSM command, then
do repetitive ls commands to see the progress.

Joerg Pohlmann
250-585-3711

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Mehdi Salehi
Sent: Tuesday, March 02, 2010 01:25
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] define volume takes a long time in AIX

Hi,
TSM volumes can be defined instantly in TSM server for Windows but take
several minutes in TSM for AIX. What could be the reason?
- AIX version is 5.3 with latest patch on both platforms
- volume is defined on a single internal physical disk (no SAN, no RAID)
- windows disk is a 500GB SATA, AIX disk is a 36GB 10K rpm SCSI drive
- windows can define a 100GB volume in one second, but AIX defines a 30GB
one in some minutes!

Thanks,
Mehdi

Re: TSM for zLinux, open or not?

[J. Pohlmann]

Depends on what you mean by mainframe world. If you are referring to a TSM
client for USS on zOS, then the answer is yes. See

http://www-01.ibm.com/support/docview.wss?rs=663context=SSGSG7uid=swg21052
224loc=en_UScs=utf-8lang=en

If you are referring to a TSM client for zOS datasets, such as VSAM, BDAM,
and the like, then the answer is no.

The fact that the TSM server runs on zLinux is coincidental, as is the FCP
support in that environment.

Joerg Pohlmann
250-585-3711

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Mehdi Salehi
Sent: Friday, February 12, 2010 23:58
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TSM for zLinux, open or not?

Hi,
Mainframe FICON adapters support Fibre Channel protocol. Does it mean
z/Linux and consequently TSM for z/Linux can handle backups of both
mainframe and open worlds?

Thanks

Re: Tsm license problem

[J. Pohlmann]

You can find the number of clients by issuing q system or by using a select
statement, for example select count(*) from nodes will tell you how many
nodes you have on your TSM server.

Joerg Pohlmann
25-585-3711


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
William ZHANG
Sent: Tuesday, January 19, 2010 21:55
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Tsm license problem

Hi all,



My tsm server version: 5.3.3.0

Tsm client:5.3.4



And I got dataret.lic   tsmbasic.lic   and tsmee.lic

Licenseenddate=never



How do I find how many clients do my server connect to  ?



Thanks !



Best Regards

Re: Customizing tsm client install for windows

[J. Pohlmann]

Suggest you use a client option set instead and assign it to the nodes.

Joerg Pohlmann
250-245-9863


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Lee, Gary D.
Sent: Friday, September 11, 2009 12:50
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Customizing tsm client install for windows

Tsm client v6.x.
I would like to have a particular set of options added to the dsm.opt on a
very large number of installs.

Is there a way to automate this into the standard installer?
If so, just a pointer to docs will help.

Thank you all.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

TSM 6.1.2.0 watch-for - EVENTS.SQL table/admin/select problems

[J. Pohlmann]

Just an FYI  - in a couple of situations including one I came across last
week, a select * from events resulted in an ANR0102E admsql.c error 1
inserting in table EVENTS.SQL message that caused the admin session to hang
on this and any subsequent select (whatever) from events. The admin session
will eventually time out. Many reporting environments (including ITM - TSM
Reporting in 6.1) rely on select (something) from events and will hang if
this problem is encountered. It appears that the error is caused by a TSM
administrator having removed nodes. We ended up setting eventretention to 0
days and re-registering the nodes, and then removing them again, then
rebooting the server and had our problem cleared so that we were able to
select (something) from events and had our reporting operational again. I do
not know if this is a real work-around of this problem or if we were just
lucky and TSM 6.1.2.0 healed itself. You might want to be careful about
removing nodes, especially those that were recently active.



Joerg Pohlmann

250-245-9863

Re: ANR9999D error - need to extend LOG

[J. Pohlmann]

You will need to do a stand-alone log extension. Use dsmfmt -log ...etc
followed by a dsmserv extend log etc. - see the admin ref appendix for a
stand-alone log extension. after that, start the server - suggest in an os
prompt so that you can see the messages. once you're up, reduce log by your
extension and then remove the volume you added with the dsmserv extend log.
Remember in v5 the maximum log size is 13GB, so you want to be at about
10GB. If you have maxed out the log and you cannot do a dsmserv extend log,
you'll have to do a point in time restore of the database.

Joerg Pohlmann
250-245-9863


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Mario Behring
Sent: Friday, August 21, 2009 10:00
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] ANRD error - need to extend LOG

Sorry all...I didn´t make myself clearthere is no TSM command line at
this pointafter the error message, the server shuts down and return to
OS prompt.

Mario





From: Gary Bowers gbow...@itrus.com
To: ADSM-L@VM.MARIST.EDU
Sent: Friday, August 21, 2009 1:30:24 PM
Subject: Re: ANRD error - need to extend LOG

From the tsm command line:

def dbvol Vol_name formatsize=size

Gary
Itrus Technologies

On Aug 21, 2009, at 11:03 AM, Mario Behring wrote:

 Hi list,
 
 I have a TSM 5.5 running on a Windows 2003 box.
 
 Recovery log is full and I am getting the following message at startup:
 
 ANR1635I The server machine GUID,
52.1c.f3.41.5e.70.11.dd.8e.7d.00.0e.0c.64.ba.74, has initialized.A
 NR2997W The server log is 99 percent full. The server will delay
transactions by 300 milliseconds.
 ANRD_2860420907 (adminit.c:1597) Thread0: Insufficient log space to
update table Administrat-
 ive.Attributes.
 ANRD Thread0 issued message  from:
 ANRD Thread0  10646B52 OutDiagToCons()+e2
 ANRD Thread0  10640CD8 outDiagf()+98
 ANRD Thread0  10065235 admInitPart2()+2075
 ANRD Thread0  2E74696E Unknown
 
 
 I am trying to extend the LOG using the DSMSERV EXTEND LOG command, but I
need to create the volume previous to running this command. On Unix/Linux I
would use the DSMFMT command, but I can´t find this utility anywhere on the
TSM Windows server...
 
 Is it missing or it doesn´t exist? If so, how can I create a volume so I
can extend the LOG? I tried DSMSERV FORMAT, but looks like this command is
only for fresh installations, as it obligates me to create a DB as well...
 
 Any help is appreciated.
 
 Mario