Re: Help running commands via the TSM REST api

[Jakob Jóhannes Sigurðsson]

Hi all.

Thanks Robert for this suggestion.

What got things up and running for us was the "Content-Type: text/plain" header.
That allows you to run all commands and really seems to be needed when POSTing 
to the ISP OC API. Someone should document this somewhere!

TIP: Use the jq command to parse json on the command line, for human sane and 
readable output. https://software.opensuse.org/package/jq

So I am now running (and piping that through jq):
curl -s -X POST -H 'Content-Type: text/plain' -H 'OC-API-Version: 1.0' 
--insecure --user xx:yy https://127.0.0.1:11090/oc/api/cli/issueCommand --data 
@largecommandinatextfile.txt | jq

Or simply:
curl -s -X POST -H 'Content-Type: text/plain' -H 'OC-API-Version: 1.0' 
--insecure --user xx:yy https://127.0.0.1:11090/oc/api/cli/issueCommand --data 
"query option" | jq

This is so much easier to do than executing stuff via dsmadmc.

Have fun!

Regards, Jakob


From: Michael Malitz [mailto:michael.mal...@mm-it.at]
Sent: miðvikudagur, 23. nóvember 2016 08:06
To: Robert Jose ; ADSM: Dist Stor Manager 

Cc: michael.malitz ; Jakob Jóhannes Sigurðsson 

Subject: Re: Help running commands via the TSM REST api


Hallo Jose and Jakob.

The Rest API exists for the OC and the CMS.

If you use the OC REST API connection and would like to register a node, please 
try the following example which i

developed for my 3 - day TSM/IBM Spectrum Protect 7.1.7 Update Workshop.

node name: node_black_rest

1.) create a file with the following content  (my test target path/file name is 
C:\scripts\spec713g\sql\batch_register_node.txt)



{

"registerclient" : {

"name":"node_black_rest",

"authentication":"local",

"password":"node_black_rest",

"domain":"standard",

"contact":"class_716_update",

"email":"m...@mm-it.at<mailto:m...@mm-it.at>"

}}

2.)  and then use the following CURL statement  (TSM user id and PW is admin1):



curl -X POST -H "Content-Type: application/json" -H "OC-API-Version: 0" -k 
--user admin1:admin1 https://TSM1:11090/oc/api/servers/SERVER_BLACK/clients 
--data  "@C:\scripts\spec713g\sql\batch_register_node.txt"



hope this helps..

kind rgds  Michael Malitz



Robert Jose mailto:rj...@us.ibm.com>> hat am 22. November 
2016 um 23:07 geschrieben:


Hello Jakob
I do not know the curl application very well, but I did notice that when
using the -data option, it sets the consume type to
"application/x-www-form-urlencoded". Unfortunately, the OC REST API does
not support this consumption. You will need to change it to consume
"text/plain".

Sorry I couldn't be more help.

Rob Jose
Spectrum Protect OC UI Developer / L3 Support

-Original Message-
From: "Jakob Jóhannes Sigurðsson" [mailto:jakob.sigurds...@nyherji.is]
Sent: Friday, November 18, 2016 3:13 AM
To: ADSM-L@VM.MARIST.EDU<mailto:ADSM-L@VM.MARIST.EDU>
Subject: [ADSM-L] Help running commands via the TSM REST api

Hi all.

I saw a message here regarding running registration of clients against the
REST API.
I am not able to get this working and the user did not include his fix in
his reply.

Has anyone successfully tried this? I keep getting Internal Server error
replies and the OC log says:

[11/18/16 11:08:42:206 GMT] 0001eeaf
org.apache.wink.server.internal.registry.ResourceRegistry I The system
cannot find any method in the com.ibm.tsm.gui.rest.CliResource class that
consumes application/x-www-form-urlencoded media type. Verify that a method
exists that consumes the media type specified.

Here is my command:
[jakob@centos-minimal ~]$ curl -s -X POST -H "OC-API-Version: 1.0" -H
"Accept: application/json" --insecure --user jakob:foobar
https://192.168.1.10:11090/oc/api/cli/issueCommand --data "query option"
Response:
{"error":{"httpStatus":"Internal Server
Error","errorCode":500,"message":null}}

Regards, Jakob
jak...@nyherji.is<mailto:jak...@nyherji.is>

Re: Help running commands via the TSM REST api

[Michael Malitz]

Hallo Jose and Jakob.

The Rest API exists for the OC and the CMS.

If you use the OC REST API connection and would like to register a node, please
try the following example which i

developed for my 3 - day TSM/IBM Spectrum Protect 7.1.7 Update Workshop.

node name: node_black_rest

1.) create a file with the following content  (my test target path/file name is
C:\scripts\spec713g\sql\batch_register_node.txt)



{

“registerclient” : {

“name”:“node_black_rest”,

“authentication”:“local”,

“password”:“node_black_rest”,

“domain”:“standard”,

“contact”:“class_716_update”,

“email”:"m...@mm-it.at"

}}

2.)  and then use the following CURL statement  (TSM user id and PW is admin1):


curl -X POST -H "Content-Type: application/json“ -H ”OC-API-Version: 0" -k
--user admin1:admin1 https://TSM1:11090/oc/api/servers/SERVER_BLACK/clients
--data  "@C:\scripts\spec713g\sql\batch_register_node.txt"


hope this helps..

kind rgds  Michael Malitz 


> 
> Robert Jose  hat am 22. November 2016 um 23:07
> geschrieben:
> 
> 
> Hello Jakob
> I do not know the curl application very well, but I did notice that when
> using the -data option, it sets the consume type to
> "application/x-www-form-urlencoded". Unfortunately, the OC REST API does
> not support this consumption. You will need to change it to consume
> "text/plain".
> 
> Sorry I couldn't be more help.
> 
> Rob Jose
> Spectrum Protect OC UI Developer / L3 Support
> 
> -Original Message-
> From: "Jakob Jóhannes Sigurðsson" [mailto:jakob.sigurds...@nyherji.is]
> Sent: Friday, November 18, 2016 3:13 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Help running commands via the TSM REST api
> 
> Hi all.
> 
> I saw a message here regarding running registration of clients against the
> REST API.
> I am not able to get this working and the user did not include his fix in
> his reply.
> 
> Has anyone successfully tried this? I keep getting Internal Server error
> replies and the OC log says:
> 
> [11/18/16 11:08:42:206 GMT] 0001eeaf
> org.apache.wink.server.internal.registry.ResourceRegistry I The system
> cannot find any method in the com.ibm.tsm.gui.rest.CliResource class that
> consumes application/x-www-form-urlencoded media type. Verify that a
> method
> exists that consumes the media type specified.
> 
> Here is my command:
> [jakob@centos-minimal ~]$ curl -s -X POST -H "OC-API-Version: 1.0" -H
> "Accept: application/json" --insecure --user jakob:foobar
> https://192.168.1.10:11090/oc/api/cli/issueCommand --data "query option"
> Response:
> {"error":{"httpStatus":"Internal Server
> Error","errorCode":500,"message":null}}
> 
> Regards, Jakob
> jak...@nyherji.is
>

Re: Help running commands via the TSM REST api

[Robert Jose]

Hello Jakob
I do not know the curl application very well, but I did notice that when
using the -data option, it sets the consume type to
"application/x-www-form-urlencoded". Unfortunately, the OC REST API does
not support this consumption. You will need to change it to consume
"text/plain".

Sorry I couldn't be more help.

Rob Jose
Spectrum Protect OC UI Developer / L3 Support

-Original Message-
From: "Jakob Jóhannes Sigurðsson" [mailto:jakob.sigurds...@nyherji.is]
Sent: Friday, November 18, 2016 3:13 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help running commands via the TSM REST api

Hi all.

I saw a message here regarding running registration of clients against the
REST API.
I am not able to get this working and the user did not include his fix in
his reply.

Has anyone successfully tried this? I keep getting Internal Server error
replies and the OC log says:

[11/18/16 11:08:42:206 GMT] 0001eeaf
org.apache.wink.server.internal.registry.ResourceRegistryI The system
cannot find any method in the com.ibm.tsm.gui.rest.CliResource class that
consumes application/x-www-form-urlencoded media type. Verify that a method
exists that consumes the  media type specified.

Here is my command:
[jakob@centos-minimal ~]$ curl -s -X POST -H "OC-API-Version: 1.0" -H
"Accept: application/json" --insecure --user jakob:foobar
https://192.168.1.10:11090/oc/api/cli/issueCommand --data "query option"
Response:
{"error":{"httpStatus":"Internal Server
Error","errorCode":500,"message":null}}

Regards, Jakob
jak...@nyherji.is

Re: Help to Operational Report.

[Bo Nielsen]

Hi Neil,

It was just, what I was looking for.

Thank you.

/Bo

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Schofield, Neil (Storage & Middleware, Backup & Restore)
Sent: 10. oktober 2016 23:27
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help to Operational Report.

Classification: Public

Bo

If I understand you correctly, you want everything from the 16th character of 
the message up to the character before the bracket and the word SESSION? In 
that case, would something like the following be suitable?

select nodename, substr(char(date_time), 1, 20) as TME, substr(char(message), 
16, instr(char(message), '(SESSION')-16) as MSG from actlog where (msgno=4005 
or msgno=4007 or msgno=4018 or msgno=4037 or msgno=4987) and 
date_time>(current_timestamp-24 hours) and domainname='LINUX_DOMAIN_SQKO'

Regards
Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT LLOYDS BANKING GROUP 




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Help to Operational Report.

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

Bo

If I understand you correctly, you want everything from the 16th character of 
the message up to the character before the bracket and the word SESSION? In 
that case, would something like the following be suitable?

select nodename, substr(char(date_time), 1, 20) as TME, substr(char(message), 
16, instr(char(message), '(SESSION')-16) as MSG from actlog where (msgno=4005 
or msgno=4007 or msgno=4018 or msgno=4037 or msgno=4987) and 
date_time>(current_timestamp-24 hours) and domainname='LINUX_DOMAIN_SQKO'

Regards
Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Help to Operational Report.

[David Ehresman]

Can you post-process your output with

sed 's/(SESSION:.*$//'



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bo 
Nielsen
Sent: Friday, October 07, 2016 5:40 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help to Operational Report.

I try to create a select in Operational Report, but I need some help.
I want to display Missed file details for a couple of nodes, as in the standard 
Report.
I can't figure out the last of the the message.
My select:
select nodename, substr(char(date_time), 1, 20) as TME, 
substr(char(message), 16, 88) as MSG from actlog where (msgno=4005 or 
msgno=4007 or msgno=4018 or msgno=4037 or msgno=4987) and 
date_time>(current_timestamp-24 hours) and domainname='LINUX_DOMAIN_SQKO'
My output:
   '/var/log/secure' changed during processing. Object skipped. (SESSION: 
113123)
I don't want . (SESSION: 113123)

Regards

Bo Nielsen


IT Service



Technical University of Denmark

IT Service

Frederiksborgvej 399

Building 109

DK - 4000 Roskilde

Denmark

Mobil +45 2337 0271

boa...@dtu.dk

Re: Help to Operational Report.

[Loon, Eric van (ITOPT3) - KLM]

Hi Bo!
I doubt if that will be possible at all. Both the message as the part you would 
like to get rid of (SESSION: 113123) have a variable length. If CHARINDEX was 
supported you could have used LEFT(message, CHARINDEX('(SESSION' )) to return 
everything left of (SESSION, but unfortunately it isn't...
Kind regards,
Eric van Loon
Air France/KLM Storage Engineering

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bo 
Nielsen
Sent: vrijdag 7 oktober 2016 11:40
To: ADSM-L@VM.MARIST.EDU
Subject: Help to Operational Report.

I try to create a select in Operational Report, but I need some help.
I want to display Missed file details for a couple of nodes, as in the standard 
Report.
I can't figure out the last of the the message.
My select:
select nodename, substr(char(date_time), 1, 20) as TME, 
substr(char(message), 16, 88) as MSG from actlog where (msgno=4005 or 
msgno=4007 or msgno=4018 or msgno=4037 or msgno=4987) and 
date_time>(current_timestamp-24 hours) and domainname='LINUX_DOMAIN_SQKO'
My output:
   '/var/log/secure' changed during processing. Object skipped. (SESSION: 
113123) I don't want . (SESSION: 113123)

Regards

Bo Nielsen


IT Service



Technical University of Denmark

IT Service

Frederiksborgvej 399

Building 109

DK - 4000 Roskilde

Denmark

Mobil +45 2337 0271

boa...@dtu.dk

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: Help with DFS backups

[Ryder, Michael S]

Zoltan

Have you tried explicitly including each DFS share as a mount point?

I've had to do something similar in the past, though I can't remember
exactly whether I used the "DOMAIN" "INCLUDE" or BOTH statements.

Sorry, that's my best effort - though I would like to hear about the
solution you end up with.

Best regards,

Mike, x7942
RMD IT Client Services

On Mon, Sep 12, 2016 at 9:05 AM, Zoltan Forray  wrote:

> Thanks for the feedback.  I got this info from another source.
>
> Method #1 is exactly what we DON'T want to do.  The DFS process is
> replacing the CIFS process we currently use for backups.  There are going
> to be dozens of "mountpoints", 1-per individual department/group and each
> will be kept as separate/individual nodes so everyone has their own control
> over restores, etc.
>
> Method#2 is also lacking since we will need to backup multiple DFS
> "mountpoints" from 1-"workstation", like we currently do with CIFS.  We
> have 2-Windows 2012 servers whose sole purpose is to run 20-30 TSM backups
> (each), one per CIFS node.
>
> Unfortunately, there aren't an details on how to configure the DFS stuff
> and TSM options to work the same way.  All of our tests have mostly failed
> with the backup backing-up too much (traversing too many subdirectories) or
> not-enough).
>
> Our structure is going to be (and is currently working as such as CIFS
> mounts)
>
> DFS backup server(s)
>
> Department Directory A
>A-Subdir
>A-Subdiretc
>
> Department Directory B
>   B-Subdir.etc
>
> and each "Department" must have their own backups/TSM node/interface
>
>
> On Fri, Sep 9, 2016 at 7:39 AM, Rick Adamson 
> wrote:
>
> > Hi Zoltan,
> > There's a section in the BA client user guide that talks about the
> options
> > available for backing up Microsoft DFS, perhaps that will help it's a
> > short read. I haven't used it in a few years so would be reluctant to be
> > specific on usage.
> >
> > (from page 180 on the 7.1 version of the BA guide)
> >
> > There are the methods you should use to protect your Microsoft Dfs data:
> > 1. Back up the Dfs link metadata and the actual data at the share
> > target of each
> > link from the workstation hosting the Dfs root. This method
> > simplifies back up
> > and restore by consolidating all of the Tivoli Storage Manager
> > activities on a
> > single workstation. This method has the disadvantage of requiring
> > an
> > additional network transfer during backup to access the data
> > stored at link
> > targets.
> > 2. Back up only the Dfs link metadata that is local to the
> > workstation hosting the
> > Dfs root. Back up the data at the target of each link from the
> > workstation(s)
> > which the data is local too. This method increases back up and
> > restore
> > performance by eliminating the extra network transfer, but
> > requires Tivoli
> > Storage Manager back up and restores to be coordinated among
> > several
> > workstations.
> >
> > Hope this helps..
> >
> > -Rick Adamson
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> > Zoltan Forray
> > Sent: Thursday, September 08, 2016 3:44 PM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: Re: [ADSM-L] Help with DFS backups
> >
> > We were able to determine it was a rights issue on the Isilon system.
> TSM
> > needs root-level access.
> >
> > However, our current problem is how TSM backs things up when using DFS
> > mounts.  Eventhough we specifically say to backup "\\rams.adp.vcu.edu
> \vpa\vp
> > administration\*", the only filesystem TSM sees and registers when it
> backs
> > up is the highest level, that being "\\rams.adp.vcu.edu\vpa" - it
> ignores
> > the "vp administration" sub-directory/folder.
> >
> > Does anyone out there have experience with backing up DFS with TSM?  Is
> > this the way it is going to be?   This is back to each
> > department/group/area wanting total control over backup/restore of their
> > "shares".
> >
> > On Thu, Sep 8, 2016 at 9:18 AM, Schneider, Jim  >
> > wrote:
> >
> > > Do you have the correct capitalization in the backup command?
> > >
> > > Jim Schneider
> > >
> > > -Original Message-
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> > > Of Zoltan Forray
> > > Sent: Thursday, September 8, 2016 7:54 AM
> > > To: ADSM-L@VM.MARIST.EDU
> > > Subject: [ADSM-L] Help with DFS backups
> > >
> > > We are redesigning our storage systems, moving to Isilon and to DFS vs
> > > CIFS.
> > >
> > > Unfortunately, we have not been able to get TSM to backup the first
> > > test DFS mount.
> > >
> > > All efforts to run a backup the DFS fail with:
> > >
> > > Incremental backup of volume '\\rams.adp.vcu.edu\vpa\vp
> administration'
> > > ANS1228E Sending of object '\\rams.adp.vcu.edu\vpa\VP Administration'
> > > failed.
> > > *ANS4007E Error processing '\\rams.adp.vcu.edu
> > > 

Re: Help with DFS backups

[Zoltan Forray]

Thanks for the feedback.  I got this info from another source.

Method #1 is exactly what we DON'T want to do.  The DFS process is
replacing the CIFS process we currently use for backups.  There are going
to be dozens of "mountpoints", 1-per individual department/group and each
will be kept as separate/individual nodes so everyone has their own control
over restores, etc.

Method#2 is also lacking since we will need to backup multiple DFS
"mountpoints" from 1-"workstation", like we currently do with CIFS.  We
have 2-Windows 2012 servers whose sole purpose is to run 20-30 TSM backups
(each), one per CIFS node.

Unfortunately, there aren't an details on how to configure the DFS stuff
and TSM options to work the same way.  All of our tests have mostly failed
with the backup backing-up too much (traversing too many subdirectories) or
not-enough).

Our structure is going to be (and is currently working as such as CIFS
mounts)

DFS backup server(s)

Department Directory A
   A-Subdir
   A-Subdiretc

Department Directory B
  B-Subdir.etc

and each "Department" must have their own backups/TSM node/interface


On Fri, Sep 9, 2016 at 7:39 AM, Rick Adamson 
wrote:

> Hi Zoltan,
> There's a section in the BA client user guide that talks about the options
> available for backing up Microsoft DFS, perhaps that will help it's a
> short read. I haven't used it in a few years so would be reluctant to be
> specific on usage.
>
> (from page 180 on the 7.1 version of the BA guide)
>
> There are the methods you should use to protect your Microsoft Dfs data:
> 1. Back up the Dfs link metadata and the actual data at the share
> target of each
> link from the workstation hosting the Dfs root. This method
> simplifies back up
> and restore by consolidating all of the Tivoli Storage Manager
> activities on a
> single workstation. This method has the disadvantage of requiring
> an
> additional network transfer during backup to access the data
> stored at link
> targets.
> 2. Back up only the Dfs link metadata that is local to the
> workstation hosting the
> Dfs root. Back up the data at the target of each link from the
> workstation(s)
> which the data is local too. This method increases back up and
> restore
> performance by eliminating the extra network transfer, but
> requires Tivoli
> Storage Manager back up and restores to be coordinated among
> several
> workstations.
>
> Hope this helps..
>
> -Rick Adamson
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> Zoltan Forray
> Sent: Thursday, September 08, 2016 3:44 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Help with DFS backups
>
> We were able to determine it was a rights issue on the Isilon system.  TSM
> needs root-level access.
>
> However, our current problem is how TSM backs things up when using DFS
> mounts.  Eventhough we specifically say to backup "\\rams.adp.vcu.edu\vpa\vp
> administration\*", the only filesystem TSM sees and registers when it backs
> up is the highest level, that being "\\rams.adp.vcu.edu\vpa" - it ignores
> the "vp administration" sub-directory/folder.
>
> Does anyone out there have experience with backing up DFS with TSM?  Is
> this the way it is going to be?   This is back to each
> department/group/area wanting total control over backup/restore of their
> "shares".
>
> On Thu, Sep 8, 2016 at 9:18 AM, Schneider, Jim 
> wrote:
>
> > Do you have the correct capitalization in the backup command?
> >
> > Jim Schneider
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> > Of Zoltan Forray
> > Sent: Thursday, September 8, 2016 7:54 AM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: [ADSM-L] Help with DFS backups
> >
> > We are redesigning our storage systems, moving to Isilon and to DFS vs
> > CIFS.
> >
> > Unfortunately, we have not been able to get TSM to backup the first
> > test DFS mount.
> >
> > All efforts to run a backup the DFS fail with:
> >
> > Incremental backup of volume '\\rams.adp.vcu.edu\vpa\vp administration'
> > ANS1228E Sending of object '\\rams.adp.vcu.edu\vpa\VP Administration'
> > failed.
> > *ANS4007E Error processing '\\rams.adp.vcu.edu
> >  > BaQ&c=AzgFQeXLLKhxSQaoFCm29A&r=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJj
> > Ffxw&m=5PRblP2zIuEBKbqOWcmYmtDqOHrzrqJ4mnewDAB6qEg&s=rZoJajrq2_UeeiVpg
> > -zB-efFopQrZGkd8a0nu0ICnbo&e= .>
> > proofpoint.com/v2/url?u=http-3A__rams.adp.vcu.edu_&d=DQIBaQ&c=
> > MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvW
> > vgE- JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIybdYao96cpsMsRS6Ip-A&s=
> > JpzTtoiZFZZag3Nn8eLnC77-XeRLd9tdS020hD2N7nA&e= >\vpa\VP Administration':
> > access to the object is
> > denied*
> > ANS1802E Incremental backup of '\\rams.adp.vcu.edu\vpa\VP
> Administration'
> >

Re: Help with DFS backups

[Rick Adamson]

Hi Zoltan,
There's a section in the BA client user guide that talks about the options 
available for backing up Microsoft DFS, perhaps that will help it's a short 
read. I haven't used it in a few years so would be reluctant to be specific on 
usage.

(from page 180 on the 7.1 version of the BA guide)

There are the methods you should use to protect your Microsoft Dfs data:
1. Back up the Dfs link metadata and the actual data at the share 
target of each
link from the workstation hosting the Dfs root. This method simplifies 
back up
and restore by consolidating all of the Tivoli Storage Manager 
activities on a
single workstation. This method has the disadvantage of requiring an
additional network transfer during backup to access the data stored at 
link
targets.
2. Back up only the Dfs link metadata that is local to the workstation 
hosting the
Dfs root. Back up the data at the target of each link from the 
workstation(s)
which the data is local too. This method increases back up and restore
performance by eliminating the extra network transfer, but requires 
Tivoli
Storage Manager back up and restores to be coordinated among several
workstations.

Hope this helps..

-Rick Adamson

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: Thursday, September 08, 2016 3:44 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help with DFS backups

We were able to determine it was a rights issue on the Isilon system.  TSM 
needs root-level access.

However, our current problem is how TSM backs things up when using DFS mounts.  
Eventhough we specifically say to backup "\\rams.adp.vcu.edu\vpa\vp 
administration\*", the only filesystem TSM sees and registers when it backs up 
is the highest level, that being "\\rams.adp.vcu.edu\vpa" - it ignores the "vp 
administration" sub-directory/folder.

Does anyone out there have experience with backing up DFS with TSM?  Is
this the way it is going to be?   This is back to each
department/group/area wanting total control over backup/restore of their 
"shares".

On Thu, Sep 8, 2016 at 9:18 AM, Schneider, Jim 
wrote:

> Do you have the correct capitalization in the backup command?
>
> Jim Schneider
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
> Of Zoltan Forray
> Sent: Thursday, September 8, 2016 7:54 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Help with DFS backups
>
> We are redesigning our storage systems, moving to Isilon and to DFS vs 
> CIFS.
>
> Unfortunately, we have not been able to get TSM to backup the first 
> test DFS mount.
>
> All efforts to run a backup the DFS fail with:
>
> Incremental backup of volume '\\rams.adp.vcu.edu\vpa\vp administration'
> ANS1228E Sending of object '\\rams.adp.vcu.edu\vpa\VP Administration'
> failed.
> *ANS4007E Error processing '\\rams.adp.vcu.edu 
>  BaQ&c=AzgFQeXLLKhxSQaoFCm29A&r=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJj
> Ffxw&m=5PRblP2zIuEBKbqOWcmYmtDqOHrzrqJ4mnewDAB6qEg&s=rZoJajrq2_UeeiVpg
> -zB-efFopQrZGkd8a0nu0ICnbo&e= .> 
> proofpoint.com/v2/url?u=http-3A__rams.adp.vcu.edu_&d=DQIBaQ&c=
> MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvW
> vgE- JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIybdYao96cpsMsRS6Ip-A&s=
> JpzTtoiZFZZag3Nn8eLnC77-XeRLd9tdS020hD2N7nA&e= >\vpa\VP Administration':
> access to the object is
> denied*
> ANS1802E Incremental backup of '\\rams.adp.vcu.edu\vpa\VP Administration'
> finished with 1 failure(s)
>
> This is supposed to be the structure:
>
> Isilon - \\uccisilon.rams.adp.vcu.edu\VP Administration DFS - \\ 
> rams.adp.vcu.edu\VPA\VP Administration
>
> Normally the "access denied" would be an authorization/rights issue.
> However, everything has been checked and double-checked and supposedly 
> (I don't have anything to do with it) is correct.
>
> Backing up the Isilon mountpoint works. This command fails with the 
> "access denied" error:
>
> dsmc i -optfile=C:\tsmcifsnode\isilon-vpadmin\dsm-vpadmin.opt
> -subdir=yes  "\\rams.adp.vcu.edu\vpa\vp administration"
>
> So, what are we missing?
>
>
> --
> *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 https://urldefense.proofpoint.com/v2/url?u=http-3A__
> infosecurity.vcu.edu_phishing.html&d=DQIBaQ&c=
> MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvW
> vgE- JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIyb

Re: Help with DFS backups

[Schneider, Jim]

I run NDMP backups Isilon shares.  I created virtual file system definitions to 
be able to run targeted backups.  Because TSM sees the Isilon as one big file 
system, your storage pool must have the available capacity to backup all data 
on the Isilon, even if you only back up parts using virtualfs.  If you back up 
to tape, there should be no problem.

Jim Schneider

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: Thursday, September 8, 2016 2:44 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help with DFS backups

We were able to determine it was a rights issue on the Isilon system.  TSM 
needs root-level access.

However, our current problem is how TSM backs things up when using DFS mounts.  
Eventhough we specifically say to backup "\\rams.adp.vcu.edu\vpa\vp 
administration\*", the only filesystem TSM sees and registers when it backs up 
is the highest level, that being "\\rams.adp.vcu.edu\vpa" - it ignores the "vp 
administration" sub-directory/folder.

Does anyone out there have experience with backing up DFS with TSM?  Is
this the way it is going to be?   This is back to each
department/group/area wanting total control over backup/restore of their 
"shares".

On Thu, Sep 8, 2016 at 9:18 AM, Schneider, Jim 
wrote:

> Do you have the correct capitalization in the backup command?
>
> Jim Schneider
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
> Of Zoltan Forray
> Sent: Thursday, September 8, 2016 7:54 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Help with DFS backups
>
> We are redesigning our storage systems, moving to Isilon and to DFS vs 
> CIFS.
>
> Unfortunately, we have not been able to get TSM to backup the first 
> test DFS mount.
>
> All efforts to run a backup the DFS fail with:
>
> Incremental backup of volume '\\rams.adp.vcu.edu\vpa\vp administration'
> ANS1228E Sending of object '\\rams.adp.vcu.edu\vpa\VP Administration'
> failed.
> *ANS4007E Error processing '\\rams.adp.vcu.edu 
>  BaQ&c=MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFk
> LOVjvWvgE-JVnMc6qtesQ14R0&m=4zX4yfwyXp1i_CqIQLNknsg4tfw_4GdNw9GWbvDBQi
> Y&s=w6WSkZU6wqc-u9ImQhSOne2FSoreL33lBw5_emcDxRM&e= .> 
> proofpoint.com/v2/url?u=http-3A__rams.adp.vcu.edu_&d=DQIBaQ&c=
> MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvW
> vgE- JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIybdYao96cpsMsRS6Ip-A&s=
> JpzTtoiZFZZag3Nn8eLnC77-XeRLd9tdS020hD2N7nA&e= >\vpa\VP Administration':
> access to the object is
> denied*
> ANS1802E Incremental backup of '\\rams.adp.vcu.edu\vpa\VP Administration'
> finished with 1 failure(s)
>
> This is supposed to be the structure:
>
> Isilon - \\uccisilon.rams.adp.vcu.edu\VP Administration DFS - \\ 
> rams.adp.vcu.edu\VPA\VP Administration
>
> Normally the "access denied" would be an authorization/rights issue.
> However, everything has been checked and double-checked and supposedly 
> (I don't have anything to do with it) is correct.
>
> Backing up the Isilon mountpoint works. This command fails with the 
> "access denied" error:
>
> dsmc i -optfile=C:\tsmcifsnode\isilon-vpadmin\dsm-vpadmin.opt
> -subdir=yes  "\\rams.adp.vcu.edu\vpa\vp administration"
>
> So, what are we missing?
>
>
> --
> *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 https://urldefense.proofpoint.com/v2/url?u=http-3A__
> infosecurity.vcu.edu_phishing.html&d=DQIBaQ&c=
> MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvW
> vgE- JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIybdYao96cpsMsRS6Ip-A&s=
> j5Kzor69UmuMAbR8r3Lsv6l9uRm50ZAn2FTOQgjdoEc&e=
>
> **
> 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.
>



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

Re: Help with DFS backups

[Zoltan Forray]

We were able to determine it was a rights issue on the Isilon system.  TSM
needs root-level access.

However, our current problem is how TSM backs things up when using DFS
mounts.  Eventhough we specifically say to backup "\\rams.adp.vcu.edu\vpa\vp
administration\*", the only filesystem TSM sees and registers when it backs
up is the highest level, that being "\\rams.adp.vcu.edu\vpa" - it ignores
the "vp administration" sub-directory/folder.

Does anyone out there have experience with backing up DFS with TSM?  Is
this the way it is going to be?   This is back to each
department/group/area wanting total control over backup/restore of their
"shares".

On Thu, Sep 8, 2016 at 9:18 AM, Schneider, Jim 
wrote:

> Do you have the correct capitalization in the backup command?
>
> Jim Schneider
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> Zoltan Forray
> Sent: Thursday, September 8, 2016 7:54 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Help with DFS backups
>
> We are redesigning our storage systems, moving to Isilon and to DFS vs
> CIFS.
>
> Unfortunately, we have not been able to get TSM to backup the first test
> DFS mount.
>
> All efforts to run a backup the DFS fail with:
>
> Incremental backup of volume '\\rams.adp.vcu.edu\vpa\vp administration'
> ANS1228E Sending of object '\\rams.adp.vcu.edu\vpa\VP Administration'
> failed.
> *ANS4007E Error processing '\\rams.adp.vcu.edu  proofpoint.com/v2/url?u=http-3A__rams.adp.vcu.edu_&d=DQIBaQ&c=
> MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvWvgE-
> JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIybdYao96cpsMsRS6Ip-A&s=
> JpzTtoiZFZZag3Nn8eLnC77-XeRLd9tdS020hD2N7nA&e= >\vpa\VP Administration':
> access to the object is
> denied*
> ANS1802E Incremental backup of '\\rams.adp.vcu.edu\vpa\VP Administration'
> finished with 1 failure(s)
>
> This is supposed to be the structure:
>
> Isilon - \\uccisilon.rams.adp.vcu.edu\VP Administration DFS - \\
> rams.adp.vcu.edu\VPA\VP Administration
>
> Normally the "access denied" would be an authorization/rights issue.
> However, everything has been checked and double-checked and supposedly (I
> don't have anything to do with it) is correct.
>
> Backing up the Isilon mountpoint works. This command fails with the
> "access denied" error:
>
> dsmc i -optfile=C:\tsmcifsnode\isilon-vpadmin\dsm-vpadmin.opt
> -subdir=yes  "\\rams.adp.vcu.edu\vpa\vp administration"
>
> So, what are we missing?
>
>
> --
> *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 https://urldefense.proofpoint.com/v2/url?u=http-3A__
> infosecurity.vcu.edu_phishing.html&d=DQIBaQ&c=
> MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvWvgE-
> JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIybdYao96cpsMsRS6Ip-A&s=
> j5Kzor69UmuMAbR8r3Lsv6l9uRm50ZAn2FTOQgjdoEc&e=
>
> **
> 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.
>



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

Re: Help with DFS backups

[Schneider, Jim]

Do you have the correct capitalization in the backup command?

Jim Schneider

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan 
Forray
Sent: Thursday, September 8, 2016 7:54 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help with DFS backups

We are redesigning our storage systems, moving to Isilon and to DFS vs CIFS.

Unfortunately, we have not been able to get TSM to backup the first test DFS 
mount.

All efforts to run a backup the DFS fail with:

Incremental backup of volume '\\rams.adp.vcu.edu\vpa\vp administration'
ANS1228E Sending of object '\\rams.adp.vcu.edu\vpa\VP Administration'
failed.
*ANS4007E Error processing '\\rams.adp.vcu.edu 
\vpa\VP Administration': access to the object is
denied*
ANS1802E Incremental backup of '\\rams.adp.vcu.edu\vpa\VP Administration'
finished with 1 failure(s)

This is supposed to be the structure:

Isilon - \\uccisilon.rams.adp.vcu.edu\VP Administration DFS - 
\\rams.adp.vcu.edu\VPA\VP Administration

Normally the "access denied" would be an authorization/rights issue.
However, everything has been checked and double-checked and supposedly (I don't 
have anything to do with it) is correct.

Backing up the Isilon mountpoint works. This command fails with the "access 
denied" error:

dsmc i -optfile=C:\tsmcifsnode\isilon-vpadmin\dsm-vpadmin.opt  -subdir=yes  
"\\rams.adp.vcu.edu\vpa\vp administration"

So, what are we missing?


--
*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 
https://urldefense.proofpoint.com/v2/url?u=http-3A__infosecurity.vcu.edu_phishing.html&d=DQIBaQ&c=MqzcmAKsw3j3xTQl5efyrz6ChwH9_xFQsqxq8hPjflw&r=oC06_8Fv3bsc_6MYFkLOVjvWvgE-JVnMc6qtesQ14R0&m=FGrnyJKGKidLaS1WgSPITHIybdYao96cpsMsRS6Ip-A&s=j5Kzor69UmuMAbR8r3Lsv6l9uRm50ZAn2FTOQgjdoEc&e=
 

**
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: Help on Directory Container

[Robert Ouzen]

Hello Guys

Thanks’ a lot for the output…. Really appreciate

Best Regards

Robert Ouzen
Haifa University
Israel


From: Ron Delaware [mailto:ron.delaw...@us.ibm.com]
Sent: Tuesday, March 22, 2016 1:30 PM
To: ADSM: Dist Stor Manager 
Cc: רוברט אוזן 
Subject: Fw: [ADSM-L] Help on Directory Container




Robert,

you run protect stgpool prior to replicate node. By doing the protect first, 
you can reduce the amount of traffic needed for the replicate node process. 
Also, without performing protect stgpool, you loose the ability to use REPAIR 
STGPOOL as it depends on Protect Stgpool being performed.

Protect Stgpool and Node replication perform two different functions, but 
complement each other. Node replication will send stgpool data and catalog 
metadata.  To insure the logical consistency of the metadata, it will lock the 
data it is replicating (not positive at what level).  After doing node 
replication, you can recover client data.

Protect stgpool moves the data, as well, but does not lock as badly, so it will 
have less of an impact to other operations.  Once it completes, you can recover 
stgpool data (which can happen automatically if Protect senses a data 
corruption in the source pool), also Protect Stgpool gives you chunk level 
recovery that hooks into REPAIR Stgpool.


Best Regards.

Ron Delaware





From:Robert Ouzen 
mailto:rou...@univ.haifa.ac.il>>
To:ADSM-L@VM.MARIST.EDU
Date:03/20/16 22:52
Subject:[ADSM-L] Help on Directory Container
Sent by:"ADSM: Dist Stor Manager" 
mailto:ADSM-L@VM.MARIST.EDU>>




Hi to all

I need a little bit more information about all the administrative process on my 
TSM environment .

I have a TSM server 7.1.5 on an O.S Windows server 2008 R2 64B.
I have mix STGPOOLS , some of type FILE (with DEDUP on server side) and some of 
type DIRECTORY

For now my order process of administrative tasks is:


1.   At late afternoon for few hours , run IDENTIFY DUPLICATES

2.   At morning 07:00 ,   run EXPIRE INVENTORY

3.   After it, run 
BACKUP DB

4.   After it, run 
RECLAIM STG

Now because I created new STGpools with type DIRECTORY (inline dedup), and  
create too an TARGET  server version 7.1.5..
Update my stgpools of type DIRECTORYwith the option:  
PROTECTstgpool=Targetstgppol  (on Target server)

Now the questions:

What will be the correct order process to add the new tasks as:

PROTECT STGPOOL
REPLICATE NODE

And what will be the correct command to repair damage container in source STG   
?

As  AUDIT CONTAINER ( with which options ??) and REPAIR CONTAINER???

T.I.A  Regards

Robert


[cid:image001.png@01D1284F.C3B0B400]

רוברט אוזן
ראש תחום שרידות וזמינות נתונים.
אוניברסיטת חיפה
משרד: בניין ראשי, חדר 5015
טלפון:  04-8240345 (פנימי: 2345)
דואר: rou...@univ.haifa.ac.il
_
אוניברסיטת חיפה | שד' אבא חושי 199 | הר הכרמל, חיפה | מיקוד: 3498838
אתר אגף מחשוב ומערכות מידע: 
http://computing.haifa.ac.il

Re: Help on Directory Container

[PAC Brion Arnaud]

Hi Robert,

If not already done, you should have a look at following page : 
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Storage%20Manager/page/Directory-container%20storage%20pools%20FAQs
 
There's a note there (Q8) explaining that "protect stgpool" should be used 
before "replicate node". 

In fact if you use the wizard which is now part of the 7.1.x OC to setup 
replication, you will see that it automatically creates some admin schedules 
which are run every 6 hours (can be customized), that are triggering "protect 
stgpool" commands. 
In addition to this, it also schedules a "replicate" job, which is run once a 
day, as part of TSM daily maintenance jobs.

Regarding audit and repair commands :

- Audit container : will by default use the " SCANAll l" options, which 
basically will look for damaged extents in a container. If any problem is 
found, you can then use "q damaged" to get better information on what client 
file has been damaged.

Option REMOVEDamaged means that the damaged extents will be deleted from TSM 
DB. To my mind it should be used only after an unsuccessful "repair" attempt, 
or  if there's no protection pool.
Option MARKDamaged  will force TSM to mark all of the involved container 
extents as damaged. To my mind, it should be used only if willing to forcibly 
delete a container, and should in this case be followed by an audit with option 
REMOVEDamaged.
Option SCANDamaged will force TSM to check again the extents previously marked 
as damaged. It should be used after "repair" command to reset the error 
conditions (which would be reset with SCANAll option too)

- Repair container : well, it is pretty self-explanatory : once client data 
extents have been found damaged, whether by some process, or following to an 
audit command, it will allow you to restore them, on condition that a 
protection storage pool exists, and that "protect stgpool" commands have been 
used. It is the equivalent of "restore stgpool" command , but for directory 
pools.

Hope this helped ...

Arnaud

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Robert 
Ouzen
Sent: Monday, March 21, 2016 6:50 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Help on Directory Container

Hi to all

I need a little bit more information about all the administrative process on my 
TSM environment .

I have a TSM server 7.1.5 on an O.S Windows server 2008 R2 64B.
I have mix STGPOOLS , some of type FILE (with DEDUP on server side) and some of 
type DIRECTORY

For now my order process of administrative tasks is:


1.   At late afternoon for few hours , run IDENTIFY DUPLICATES

2.   At morning 07:00 ,   run EXPIRE INVENTORY

3.   After it, run 
BACKUP DB

4.   After it, run 
RECLAIM STG

Now because I created new STGpools with type DIRECTORY (inline dedup), and  
create too an TARGET  server version 7.1.5..
Update my stgpools of type DIRECTORYwith the option:  
PROTECTstgpool=Targetstgppol  (on Target server)

Now the questions:

What will be the correct order process to add the new tasks as:

PROTECT STGPOOL
REPLICATE NODE

And what will be the correct command to repair damage container in source STG   
?

As  AUDIT CONTAINER ( with which options ??) and REPAIR CONTAINER???

T.I.A  Regards

Robert


[cid:image001.png@01D1284F.C3B0B400]

רוברט אוזן
ראש תחום שרידות וזמינות נתונים.
אוניברסיטת חיפה
משרד: בניין ראשי, חדר 5015
טלפון:  04-8240345 (פנימי: 2345)
דואר: rou...@univ.haifa.ac.il
_
אוניברסיטת חיפה | שד' אבא חושי 199 | הר הכרמל, חיפה | מיקוד: 3498838
אתר אגף מחשוב ומערכות מידע: 
http://computing.haifa.ac.il

Re: help with designing a backup system for Teradata

[Rhodes, Richard L.]

> What type of storeage system are you using? Does it have the necessary I/O 
> capability to allow the throughput you are going to require?

The I/O is coming from the Teradata box.

Teradata is a dedicated Database system that is highly
optimized and uses very high parallelism.  We are told
it can pump the backup out really fast, as long as it's
tuned correctly.  The DBA's are responsible for this side
of things.

Teradata has a backup program called "Bar" which runs on
dedicated servers (one or more)(Windows or Linux) that interfaces
to the Teradata database engine.  From or understanding, this
program does not handle any media, including writing to
disk.  It expects to interface with another program
(TSM, NetBackup, etc).
They have written a interface to the TSM API client.

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: help with designing a backup system for Teradata

[Ron Delaware]

Rick,

What type of storeage system are you using? Does it have the necessary I/O
capability to allow the throughput you are going to require?


Best Regards,
_

email: ron.delaw...@us.ibm.com





From:   "Rhodes, Richard L." 
To: ADSM-L@VM.MARIST.EDU
Date:   07/30/15 10:03
Subject:[ADSM-L] help with designing a backup system for Teradata
Sent by:"ADSM: Dist Stor Manager" 



We purchased a Teredata database system.
It currently is in test/dev stage with little data.
We don't really know the ultimate backup requirements.
To get things started we setup a simple backup system:

   Teradata
-> to Bar server (Win) with TSM interface sftw
-> to TSM server (AIX)
-> to filepool on DataDomain (getting ~5x dedup)

   From the Bar server to TSM server is a standard 1GB ethernet.

Now we need to scale up/out!

The consultants are saying we will need to backup 30TB in a 6hr window,
but maybe has high as 50TB in 6hr.
That is (roughly):
 30TB in 6hr = 1,400 MB/sec
 50TB in 6hr = 2,300 MB/sec

So we need to design a TSM backup system to support this.

My thoughts:

1) Put a storage agent on the Bar server (Win server)
 and feed a VTL via 4x8gb san connections via a bunch of virtual tape.

2) Put the TSM server directly on the Bar server for just
 local tape and still feed a VTL as above.
 No library sharing.

3) I'd really like to not use tape (even virtual tape),
 but I can't think of any way to feed file devices
 with that throughput.

I'd appreciate any thought/comments anyone might have!

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: help with designing a backup system for Teradata

[Rhodes, Richard L.]

Anything we do for this has to be purchased, so current licensing is not a 
problem.

I'm not sure what using DDBoost would look like.
Where would the plugin run?  I don't think there is a DDboost plugin for TSM or 
Teradata's program.  I know there are plugins for Networker, NetBackup, 
Oracle/RMAN and others, but I don't think for Teradata.  Yea, it would really 
be nice to just bypass TSM altogether, but the Teradata backup program doesn't 
support backup-to-disk.  It want's to feed an API interface, like TSM's API 
client.

Rick



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Mike 
De Gasperis
Sent: Thursday, July 30, 2015 2:16 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: help with designing a backup system for Teradata

Do you have DDboost licensed?  Could always use the boost plugin and go right 
to the DD and skip the TSM server. 



> On Jul 30, 2015, at 1:00 PM, Rhodes, Richard L.  
> wrote:
> 
> We purchased a Teredata database system.
> It currently is in test/dev stage with little data.
> We don't really know the ultimate backup requirements.
> To get things started we setup a simple backup system:
> 
>   Teradata
>-> to Bar server (Win) with TSM interface sftw
>-> to TSM server (AIX)
>-> to filepool on DataDomain (getting ~5x dedup)
> 
>   From the Bar server to TSM server is a standard 1GB ethernet.
> 
> Now we need to scale up/out!
> 
> The consultants are saying we will need to backup 30TB in a 6hr window,
> but maybe has high as 50TB in 6hr.
> That is (roughly):
> 30TB in 6hr = 1,400 MB/sec
> 50TB in 6hr = 2,300 MB/sec
> 
> So we need to design a TSM backup system to support this.
> 
> My thoughts:
> 
> 1) Put a storage agent on the Bar server (Win server)
> and feed a VTL via 4x8gb san connections via a bunch of virtual tape.
> 
> 2) Put the TSM server directly on the Bar server for just
> local tape and still feed a VTL as above.
> No library sharing.
> 
> 3) I'd really like to not use tape (even virtual tape),
> but I can't think of any way to feed file devices
> with that throughput.
> 
> I'd appreciate any thought/comments anyone might have!
> 
> 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.


-
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: help with designing a backup system for Teradata

[Mike De Gasperis]

Do you have DDboost licensed?  Could always use the boost plugin and go right 
to the DD and skip the TSM server. 



> On Jul 30, 2015, at 1:00 PM, Rhodes, Richard L.  
> wrote:
> 
> We purchased a Teredata database system.
> It currently is in test/dev stage with little data.
> We don't really know the ultimate backup requirements.
> To get things started we setup a simple backup system:
> 
>   Teradata
>-> to Bar server (Win) with TSM interface sftw
>-> to TSM server (AIX)
>-> to filepool on DataDomain (getting ~5x dedup)
> 
>   From the Bar server to TSM server is a standard 1GB ethernet.
> 
> Now we need to scale up/out!
> 
> The consultants are saying we will need to backup 30TB in a 6hr window,
> but maybe has high as 50TB in 6hr.
> That is (roughly):
> 30TB in 6hr = 1,400 MB/sec
> 50TB in 6hr = 2,300 MB/sec
> 
> So we need to design a TSM backup system to support this.
> 
> My thoughts:
> 
> 1) Put a storage agent on the Bar server (Win server)
> and feed a VTL via 4x8gb san connections via a bunch of virtual tape.
> 
> 2) Put the TSM server directly on the Bar server for just
> local tape and still feed a VTL as above.
> No library sharing.
> 
> 3) I'd really like to not use tape (even virtual tape),
> but I can't think of any way to feed file devices
> with that throughput.
> 
> I'd appreciate any thought/comments anyone might have!
> 
> 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: Help in Mac client

[Andrew Raibeck]

Robert,

In looking at the content of sign.excl, it looks like the double quotation
marks are "smart quotes" and not straight quotes. Maybe it is just your
email program putting in smart quotes, but make sure you use straight
quotes in the file.

Also, if the EXCLUDE statement is meant to exclude all files (except those
from your INCLUDE statement), you should just specify:

   EXCLUDE *

However, I do not think the content of sign.excl is the issue; otherwise
TSM would complain about the sign.excl content (include or exclude
statements). Instead, TSM is complaining about the INCLE statement itself.

Double check the file name and path, and that permissions are not at issue.

Best regards,

- Andy



Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead |
stor...@us.ibm.com

IBM Tivoli Storage Manager links:
Product support:
http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager

Online documentation:
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
+Documentation+Central/page/Tivoli+Storage+Manager
Product Wiki:
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli
+Storage+Manager/page/Home

"ADSM: Dist Stor Manager"  wrote on 2014-07-02
03:34:25:

> From: Robert Ouzen 
> To: ADSM-L@vm.marist.edu,
> Date: 2014-07-02 03:35
> Subject: Help in Mac client
> Sent by: "ADSM: Dist Stor Manager" 
>
> Hi to all
>
> It's my first time installing a Mac client  (and not a Mac expert)
> and got this error .
>
> The file sign.excl is on the following folder /Users/admin/Desktop/
> tsm.Got this path thru the getinfo feature but still error.
>
> The inclexcl syntax is in the dsm.sys file.
>
> ***
>
>COMMmethod TCPip
> TCPPort1500
> TCPServeraddress   xxx.xx.xx.xx
>  TCPCLIENTADDRESS  yyy.yy.yy.yy
>   NODENAME SIGN
> passwordaccess   generate
>
> INCLE /Users/admin/Desktop/tsm/sign.excl
>
> SCHEDLOGNAMEdsmsched.log
> ERRORLOGNAMEdsmerror.log
> SCHEDMODE PROMPTED
> MANAGEDSERVICES WEBCLIENT SCHEDULE
>
> dirmc mgsign
> 
>
> Last login: Wed Jul  2 10:11:50 on ttys000
> admins-mac-pro:~ admin$ /Library/Application\ Support/tivoli/tsm/
> client/ba/bin/dsmc ; exit;
> ANS1036S The option 'INCLE' or the value supplied for it is not
> valid. It was found in options file '/Library/Preferences/Tivoli
> Storage Manager/dsm.sys' at line number: 35
> The complete entry:
'INCLE /Users/admin/Desktop/tsm/sign.excl'
>
> Here the content of file sign.excl:
>
> EXCLUDE /…/…/*
> INCLUDE “Volumes/Drobo/Movies/…/*”   mgsign
>
> Any help will be appreciate
>
> Best Regards
>
> Robert
>

Re: Help in Mac client

[Sims, Richard B]

On Jul 2, 2014, at 3:34 AM, Robert Ouzen  wrote:

> INCLUDE “Volumes/Drobo/Movies/…/*”   mgsign

Robert -

One thing I can see is that the above line should instead be:

INCLUDE “/Volumes/Drobo/Movies/…/*”   mgsign

You may be able to use command ‘dsmc query inclexcl’ to check the contents.

   Richard Sims, still prevailing at Boston University

Re: Help with planning

[Francisco Javier]

I hope this can help you with everything what you are needing

best regards


2014-05-07 13:12 GMT-05:00 David Jelinek :

> On 05/07/2014 01:51 PM, Francisco Javier wrote:
>
>> if do you want the pre requisites, check out this:
>> http://pic.dhe.ibm.com/infocenter/tsmfbinf/v6/index.
>> jsp?topic=%2Fcom.ibm.itsm.fbws.doc%2Ffbws_relnotes.html
>>
> Ahh, thank you! I had not found that one!
>
> --
> Have a wonderful day,
> David Jelinek
>

Re: Help with planning

[David Jelinek]

On 05/07/2014 01:51 PM, Francisco Javier wrote:

if do you want the pre requisites, check out this:
http://pic.dhe.ibm.com/infocenter/tsmfbinf/v6/index.jsp?topic=%2Fcom.ibm.itsm.fbws.doc%2Ffbws_relnotes.html

Ahh, thank you! I had not found that one!

--
Have a wonderful day,
David Jelinek

Re: Help with planning

[Francisco Javier]

if do you want the pre requisites, check out this:
http://pic.dhe.ibm.com/infocenter/tsmfbinf/v6/index.jsp?topic=%2Fcom.ibm.itsm.fbws.doc%2Ffbws_relnotes.html



2014-05-07 12:43 GMT-05:00 David Jelinek :

> On 05/07/2014 12:48 PM, Francisco Javier wrote:
>
>> check out this ...
>> http://www-03.ibm.com/software/products/es/fastbackforworkstations
>>
> I've been there and not found what I needed so far, but thank you.
>
>>
>>
>> 2014-05-07 11:45 GMT-05:00 David Jelinek :
>>
>>  I've been asked to figure out what we would need in the way of servers
>>> if we were going to use FastBack to back up about 2000 Windows desktop
>>> machines. I have no experience with FastBack at all. We use TSM for our
>>> Enterprise backups of our servers. Are the server side of FastBack
>>> regular TSM servers? I can't seem to find where to look for the
>>> information I need. Any help would be appreciated. Thanks in advance.
>>>
>>> --
>>> Have a wonderful day,
>>> David Jelinek
>>>
>>>
>
> --
> Have a wonderful day,
> David Jelinek
>

Re: Help with planning

[David Jelinek]

On 05/07/2014 12:51 PM, Chavdar Cholev wrote:

This is also useful:
http://www.redbooks.ibm.com/abstracts/sg247685.html?Open

A Redbook! Great! Thank you!


On 5/7/2014 19:45, David Jelinek wrote:

I've been asked to figure out what we would need in the way of servers
if we were going to use FastBack to back up about 2000 Windows desktop
machines. I have no experience with FastBack at all. We use TSM for our
Enterprise backups of our servers. Are the server side of FastBack
regular TSM servers? I can't seem to find where to look for the
information I need. Any help would be appreciated. Thanks in advance.

--
Have a wonderful day,
David Jelinek



--
Have a wonderful day,
David Jelinek

Re: Help with planning

[David Jelinek]

On 05/07/2014 12:48 PM, Francisco Javier wrote:

check out this ...
http://www-03.ibm.com/software/products/es/fastbackforworkstations

I've been there and not found what I needed so far, but thank you.



2014-05-07 11:45 GMT-05:00 David Jelinek :


I've been asked to figure out what we would need in the way of servers
if we were going to use FastBack to back up about 2000 Windows desktop
machines. I have no experience with FastBack at all. We use TSM for our
Enterprise backups of our servers. Are the server side of FastBack
regular TSM servers? I can't seem to find where to look for the
information I need. Any help would be appreciated. Thanks in advance.

--
Have a wonderful day,
David Jelinek




--
Have a wonderful day,
David Jelinek

Re: Help with planning

[Chavdar Cholev]

This is also useful:
http://www.redbooks.ibm.com/abstracts/sg247685.html?Open

On 5/7/2014 19:45, David Jelinek wrote:

I've been asked to figure out what we would need in the way of servers
if we were going to use FastBack to back up about 2000 Windows desktop
machines. I have no experience with FastBack at all. We use TSM for our
Enterprise backups of our servers. Are the server side of FastBack
regular TSM servers? I can't seem to find where to look for the
information I need. Any help would be appreciated. Thanks in advance.

--
Have a wonderful day,
David Jelinek

Re: Help with planning

[Francisco Javier]

check out this ...
http://www-03.ibm.com/software/products/es/fastbackforworkstations



2014-05-07 11:45 GMT-05:00 David Jelinek :

> I've been asked to figure out what we would need in the way of servers
> if we were going to use FastBack to back up about 2000 Windows desktop
> machines. I have no experience with FastBack at all. We use TSM for our
> Enterprise backups of our servers. Are the server side of FastBack
> regular TSM servers? I can't seem to find where to look for the
> information I need. Any help would be appreciated. Thanks in advance.
>
> --
> Have a wonderful day,
> David Jelinek
>

Re: Help on q nodedata

[Roger Deschner]

It looks like the strange behavior is in MOVE NODEDATA, not Q NODEDATA.
You should believe what Q NODEDATA says. Something went wrong with the
move - even though it says SUCCESS. Do something like

Q ACTLOG BEGINT=xx:xx BEGIND=xx/xx/2013 SEARCH='MOVE NODEDATA'

to see why it stopped and thought it had succeeded before moving all of
the data. Perhaps a restore or reclamation underway? Beware that it
likely has to un-dedup the data as a part of the MOVE NODEDATA process.

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



On Thu, 31 Oct 2013, Robert Ouzen wrote:

>Hi to all
>
>I have a strange behavior on a client running the Q NODEDATA EDUNW  , here the 
>output:
>
>
>
>Node NameVolume NameStorage Pool 
>Physical
>Name  
> Space
> 
> Occupied
>   
> (MB)
> --  
>
>EDUNWT:\DEDUP6\00053C08.BFS DEDUP6TSM 
>18.16
>EDUNWT:\DEDUP6\00053C21.BFS DEDUP6TSM 
>71.95
>EDUNWT:\DEDUP6\00053C25.BFS DEDUP6TSM
>4,964.89
>EDUNWT:\DEDUP6\00053C39.BFS DEDUP6TSM  
>0.06
>EDUNWT:\DEDUP6\00053C44.BFS DEDUP6TSM 
>699.58
>EDUNW\\DD580G\BACKUP\POSTBACK\EDUC- DD_EDUCATION 
>36,533.5
>  ATION\.BFS   
>   7
>EDUNW\\DD580G\BACKUP\POSTBACK\EDUC- DD_EDUCATION 
>37,187.1
>  ATION\0001.BFS   
>   4
>EDUNW\\DD580G\BACKUP\POSTBACK\EDUC- DD_EDUCATION 
>38,004.6
>  ATION\0002.BFS   
>   9
>EDUNW\\DD580G\BACKUP\POSTBACK\EDUC- DD_EDUCATION 
>33,756.1
>  ATION\0003.BFS   
>   9
>EDUNW\\DD580G\BACKUP\POSTBACK\EDUC- DD_EDUCATION 
>24,543.9
>  ATION\0004.BFS   
>   1
>EDUNW\\DD580G\BACKUP\POSTBACK\EDUC- DD_EDUCATION 
>32,374.4
>  ATION\0005.BFS   
>   0
>
>The correct storage to be on is:  DD_EDUCATION
>
>I run several times a move nodedata edunw from=dedup6tsm  to=dd_education   
>recons=yes   with every time success process.
>
>But still  got this output ?
>
>I did to a : q nodedata * vol= T:\DEDUP6\00053C08.BFS and still 
>see reference of node EDUNW on it ?
>
>tsm: POSTBACK>q nodedata edunw vol=S:\DEDUP6\00053BB2.BFS
>
>Node NameVolume NameStorage Pool 
>Physical
>Name  
> Space
> 
> Occupied
>   
> (MB)
> --  
>
>EDUNWS:\DEDUP6\00053BB2.BFS DEDUP6TSM 
>57.52
>
>How I can be rid of those entries ?
>
>My Tsm server version is:   6.3.4.200
>My Tsm client version is: 6.2.2.0
>
>T.I.A  Regards
>
>Robert
>

Re: help - tsm vg upgrade test

[Richard Rhodes]

Found the problem.

Apparently the upgrade utility requires the account to access the tsm v5
server to be an actual login account.  That is, you can ssh to the box as
that id and enter the ID and PWD of the account and get a shell.  We had
tried rsh and ssh setups without pwd's (ssh with public/private keys set).
 This allowed cmd execution but not a login.That wasn't good enough.
We had to make root to be allowed to login to access the tsm v5 db (we are
setup to run tsm v5 as root).

Rick





From:   Zoltan Forray 
To: ADSM-L@VM.MARIST.EDU
Date:   09/11/2013 03:09 PM
Subject:    Re: help - tsm vg upgrade test
Sent by:"ADSM: Dist Stor Manager" 



Did you install the Server Upgrade utilities for the level you are
upgrading from? For instance, when I did my conversion from 5.5.7 to V6.3
Linux, I downloaded and installed:

ftp://service.boulder.ibm.com//storage/tivoli-storage-management/maintenance/server-upgrade/v5r5/Linux/5.5.7.000/x86_64/5.5.7.000-TIV-TSMUPG-LinuxX64.tar.bz2


which when installed, contains dsmupgrd


On Wed, Sep 11, 2013 at 2:59 PM, Richard Rhodes
 wrote:

> We are trying a first test of the tsm v6 upgrade procedure for a v5 tsm
> server.
> We are trying the network method.  We restored the tsm v5 db to a test
> system
> and setup a tsm v6 install on a different test system.
>
>   lpar A - tsm v5 db (source)
>   lpar B - tsm v6 system (destination)
>
> On lpar B we are running the gui upgrade wizard dsmupgdx.
> Following the prompts we enter what it wants:
>   server for the tsm v5 db, userid, pwd
>   begin new upgrade
>   phase = "prepare the db for the upgrade"
>   location of dsmserv.dsk and dsmserv.opt
>   gives a list of tsm v5 db and log volumes - it's correct
>   Then . . . get this ERROR:
>  Beginning database preparation...
>  sh[129]: /usr/tivoli/tsm/upgrade/bin/dsmupgrd:  not found.
>  Preparation completed with return code 499
>
> It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
>   :/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>   -rwxr-xr-x1 root system 21221457 Oct 24 2011
> /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>
> The utility is communicating with the tsm v5 system just fine - it
> found the dsmserv.dsk/dsmserv.opt.  The dsmupgrd is there.
>
> Any thoughts on what we are doing wrong?
>
> 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.
>



--
*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: help - tsm vg upgrade test

[Richard Rhodes]

I has said . . .

  > It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
  >:/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
  >-rwxr-xr-x1 root system 21221457 Oct 24 2011
  > /usr/tivoli/tsm/upgrade/bin/dsmupgrd

I typed "" when I should have said "". 
dsmupgrd is on lparA - it's there, right where dsmupgdx log says it tried 
to find it.

Sorry for the confusion.

Rick





From:   Michael Prix 
To: ADSM-L@VM.MARIST.EDU
Date:   09/11/2013 04:13 PM
Subject:Re: help - tsm vg upgrade test
Sent by:"ADSM: Dist Stor Manager" 



Richard,

dsmupgrd is on the wrong LPAR.
The upgrade tools must be installed on the LPAR which has the v5 DB, not 
on the LPAR hosting the v6

-- 
Mit freundlichen Grüßen / kind regards

Michael Prix

On 09/11/2013 08:59 PM, Richard Rhodes wrote:
> We are trying a first test of the tsm v6 upgrade procedure for a v5 tsm
> server.
> We are trying the network method.  We restored the tsm v5 db to a test
> system
> and setup a tsm v6 install on a different test system.
>
>lpar A - tsm v5 db (source)
>lpar B - tsm v6 system (destination)
>
> On lpar B we are running the gui upgrade wizard dsmupgdx.
> Following the prompts we enter what it wants:
>server for the tsm v5 db, userid, pwd
>begin new upgrade
>phase = "prepare the db for the upgrade"
>location of dsmserv.dsk and dsmserv.opt
>gives a list of tsm v5 db and log volumes - it's correct
>Then . . . get this ERROR:
>   Beginning database preparation...
>   sh[129]: /usr/tivoli/tsm/upgrade/bin/dsmupgrd:  not found.
>   Preparation completed with return code 499
>
> It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
>:/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>-rwxr-xr-x1 root system 21221457 Oct 24 2011
> /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>
> The utility is communicating with the tsm v5 system just fine - it
> found the dsmserv.dsk/dsmserv.opt.  The dsmupgrd is there.
>
> Any thoughts on what we are doing wrong?
>
> 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: help - tsm vg upgrade test

[Richard Rhodes]

I think we have it right - the upgrade utilities are installed on the v5 
server as you say.

>lpar A - tsm v5 db (source)
  upgrade utilities installed

>lpar B - tsm v6 system (destination)
  new v6 server
  running dsmupgdx
successfully finds dsmserv.opt/dsmserv.dsk on lpar A
but throws the error below

We have RSH setup between the two lpars for the communications.
This seems to work since dsmupgdx sees dsmserv.opt/dsmserv.dsk of the v5 
tsm instance.

Will be opening a case with IBM shortly.

Thanks

Rick





From:   Michael Prix 
To: ADSM-L@VM.MARIST.EDU
Date:   09/11/2013 04:13 PM
Subject:        Re: help - tsm vg upgrade test
Sent by:"ADSM: Dist Stor Manager" 



Richard,

dsmupgrd is on the wrong LPAR.
The upgrade tools must be installed on the LPAR which has the v5 DB, not 
on the LPAR hosting the v6

-- 
Mit freundlichen Grüßen / kind regards

Michael Prix

On 09/11/2013 08:59 PM, Richard Rhodes wrote:
> We are trying a first test of the tsm v6 upgrade procedure for a v5 tsm
> server.
> We are trying the network method.  We restored the tsm v5 db to a test
> system
> and setup a tsm v6 install on a different test system.
>
>lpar A - tsm v5 db (source)
>lpar B - tsm v6 system (destination)
>
> On lpar B we are running the gui upgrade wizard dsmupgdx.
> Following the prompts we enter what it wants:
>server for the tsm v5 db, userid, pwd
>begin new upgrade
>phase = "prepare the db for the upgrade"
>location of dsmserv.dsk and dsmserv.opt
>gives a list of tsm v5 db and log volumes - it's correct
>Then . . . get this ERROR:
>   Beginning database preparation...
>   sh[129]: /usr/tivoli/tsm/upgrade/bin/dsmupgrd:  not found.
>   Preparation completed with return code 499
>
> It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
>:/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>-rwxr-xr-x1 root system 21221457 Oct 24 2011
> /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>
> The utility is communicating with the tsm v5 system just fine - it
> found the dsmserv.dsk/dsmserv.opt.  The dsmupgrd is there.
>
> Any thoughts on what we are doing wrong?
>
> 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: help - tsm vg upgrade test

[Michael Prix]

Richard,

dsmupgrd is on the wrong LPAR.
The upgrade tools must be installed on the LPAR which has the v5 DB, not 
on the LPAR hosting the v6


--
Mit freundlichen Grüßen / kind regards

Michael Prix

On 09/11/2013 08:59 PM, Richard Rhodes wrote:

We are trying a first test of the tsm v6 upgrade procedure for a v5 tsm
server.
We are trying the network method.  We restored the tsm v5 db to a test
system
and setup a tsm v6 install on a different test system.

   lpar A - tsm v5 db (source)
   lpar B - tsm v6 system (destination)

On lpar B we are running the gui upgrade wizard dsmupgdx.
Following the prompts we enter what it wants:
   server for the tsm v5 db, userid, pwd
   begin new upgrade
   phase = "prepare the db for the upgrade"
   location of dsmserv.dsk and dsmserv.opt
   gives a list of tsm v5 db and log volumes - it's correct
   Then . . . get this ERROR:
  Beginning database preparation...
  sh[129]: /usr/tivoli/tsm/upgrade/bin/dsmupgrd:  not found.
  Preparation completed with return code 499

It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
   :/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
   -rwxr-xr-x1 root system 21221457 Oct 24 2011
/usr/tivoli/tsm/upgrade/bin/dsmupgrd

The utility is communicating with the tsm v5 system just fine - it
found the dsmserv.dsk/dsmserv.opt.  The dsmupgrd is there.

Any thoughts on what we are doing wrong?

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: help - tsm vg upgrade test

[Thomas Denier]

-Richard Rhodes wrote: -

>  Then . . . get this ERROR:
> Beginning database preparation...
> sh[129]: /usr/tivoli/tsm/upgrade/bin/dsmupgrd:  not found.
> Preparation completed with return code 499
>
>It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
>  :/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>  -rwxr-xr-x1 root system 21221457 Oct 24 2011
>/usr/tivoli/tsm/upgrade/bin/dsmupgrd

I remember once seeing a message like this because the interpreter
named in the first line of the script did not exist. The situation
was something like the following:

The first line of the script was

#! /bin/sh

and the system did not in fact have a binary named 'sh' in /bin.

Thomas Denier,
Thomas Jefferson University Hospital

Re: help - tsm vg upgrade test

[Zoltan Forray]

Did you install the Server Upgrade utilities for the level you are
upgrading from? For instance, when I did my conversion from 5.5.7 to V6.3
Linux, I downloaded and installed:

ftp://service.boulder.ibm.com//storage/tivoli-storage-management/maintenance/server-upgrade/v5r5/Linux/5.5.7.000/x86_64/5.5.7.000-TIV-TSMUPG-LinuxX64.tar.bz2

which when installed, contains dsmupgrd


On Wed, Sep 11, 2013 at 2:59 PM, Richard Rhodes  wrote:

> We are trying a first test of the tsm v6 upgrade procedure for a v5 tsm
> server.
> We are trying the network method.  We restored the tsm v5 db to a test
> system
> and setup a tsm v6 install on a different test system.
>
>   lpar A - tsm v5 db (source)
>   lpar B - tsm v6 system (destination)
>
> On lpar B we are running the gui upgrade wizard dsmupgdx.
> Following the prompts we enter what it wants:
>   server for the tsm v5 db, userid, pwd
>   begin new upgrade
>   phase = "prepare the db for the upgrade"
>   location of dsmserv.dsk and dsmserv.opt
>   gives a list of tsm v5 db and log volumes - it's correct
>   Then . . . get this ERROR:
>  Beginning database preparation...
>  sh[129]: /usr/tivoli/tsm/upgrade/bin/dsmupgrd:  not found.
>  Preparation completed with return code 499
>
> It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
>   :/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>   -rwxr-xr-x1 root system 21221457 Oct 24 2011
> /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>
> The utility is communicating with the tsm v5 system just fine - it
> found the dsmserv.dsk/dsmserv.opt.  The dsmupgrd is there.
>
> Any thoughts on what we are doing wrong?
>
> 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.
>



--
*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: help - tsm vg upgrade test

[Richard Rhodes]

Our tsm server is 5.5.6, and the upgrade utilities installed is 5.5.6.

rick





From:   Zoltan Forray 
To: ADSM-L@VM.MARIST.EDU
Date:   09/11/2013 03:09 PM
Subject:Re: help - tsm vg upgrade test
Sent by:"ADSM: Dist Stor Manager" 



Did you install the Server Upgrade utilities for the level you are
upgrading from? For instance, when I did my conversion from 5.5.7 to V6.3
Linux, I downloaded and installed:

ftp://service.boulder.ibm.com//storage/tivoli-storage-management/maintenance/server-upgrade/v5r5/Linux/5.5.7.000/x86_64/5.5.7.000-TIV-TSMUPG-LinuxX64.tar.bz2


which when installed, contains dsmupgrd


On Wed, Sep 11, 2013 at 2:59 PM, Richard Rhodes
 wrote:

> We are trying a first test of the tsm v6 upgrade procedure for a v5 tsm
> server.
> We are trying the network method.  We restored the tsm v5 db to a test
> system
> and setup a tsm v6 install on a different test system.
>
>   lpar A - tsm v5 db (source)
>   lpar B - tsm v6 system (destination)
>
> On lpar B we are running the gui upgrade wizard dsmupgdx.
> Following the prompts we enter what it wants:
>   server for the tsm v5 db, userid, pwd
>   begin new upgrade
>   phase = "prepare the db for the upgrade"
>   location of dsmserv.dsk and dsmserv.opt
>   gives a list of tsm v5 db and log volumes - it's correct
>   Then . . . get this ERROR:
>  Beginning database preparation...
>  sh[129]: /usr/tivoli/tsm/upgrade/bin/dsmupgrd:  not found.
>  Preparation completed with return code 499
>
> It can't find /usr/tivoli/tsm/upgrade/bin/dsmupgrd, which exists:
>   :/home/root==>ls -ld /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>   -rwxr-xr-x1 root system 21221457 Oct 24 2011
> /usr/tivoli/tsm/upgrade/bin/dsmupgrd
>
> The utility is communicating with the tsm v5 system just fine - it
> found the dsmserv.dsk/dsmserv.opt.  The dsmupgrd is there.
>
> Any thoughts on what we are doing wrong?
>
> 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.
>



--
*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: Help with NDMP dump & diff expiration

[Huebner, Andy]

Another option, the one we use, is to use the NAS to snap a copy and keep that 
snap for some number of days and only make full dumps once a week.

Andy Huebner


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Prather, Wanda
Sent: Thursday, December 27, 2012 4:41 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help with NDMP dump & diff expiration

Exactly what I needed to know.
Thanks Remco.

( and saves me the trouble of putting  in another RFE!)


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco 
Post
Sent: Thursday, December 27, 2012 12:44 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help with NDMP dump & diff expiration

Hi,

I once raised an RFE for managing diffs separately from the fulls. 
Unfortunately the answer is NO.

workaround: use multiple nodenames and make fulls on both nodenames and diffs 
only with one yes a pita and a waste of tapes... if only IBM could think of 
something better ;-)

On 27 dec. 2012, at 18:05, "Prather, Wanda"  wrote:

> Need some help from folks doing "external" NDMP dumps, where TSM triggers the 
> dump but it's done by the NAS device across the fibre to pool defined as 
> TYPE=NDMPDUMP, not a standard TSM storage pool.
> 
> Have a customer installing an EMC (VNX)  NAS which will store multiple 
> millions of .pdf files.  The data change rate is very low, but can't back up 
> via the CIFS mount using the regular client, too many files to scan the 
> filesystem.  And VNX doesn't support snapdiff.
> 
> So the plan is to have the VNX do full and diff dumps under TSM control.
> Customer wants monthly fulls + daily diffs between, and wants to be able to 
> go back a year.
> 
> My experience is with NDMP via TCPIP in a normal TSM storage pool, but the 
> thing I see there is that when you do a new full, the previous diffs don't 
> expire.
> 
> There's no reclaim for a pool defined as TYPE-NDMPDUMP, so how do you handle 
> this without keeping 365 cartridges tied up in the vault?  Is there a good 
> way to blow way those "in between" diffs?
> 
> Thanks and Happy New Year
> 
> Wanda (NDMP is Evil) P
> 
> 
> 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)

--
Met vriendelijke groeten/Kind Regards,

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

Re: Help with NDMP dump & diff expiration

[Prather, Wanda]

Exactly what I needed to know.
Thanks Remco.

( and saves me the trouble of putting  in another RFE!)


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco 
Post
Sent: Thursday, December 27, 2012 12:44 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help with NDMP dump & diff expiration

Hi,

I once raised an RFE for managing diffs separately from the fulls. 
Unfortunately the answer is NO.

workaround: use multiple nodenames and make fulls on both nodenames and diffs 
only with one yes a pita and a waste of tapes... if only IBM could think of 
something better ;-)

On 27 dec. 2012, at 18:05, "Prather, Wanda"  wrote:

> Need some help from folks doing "external" NDMP dumps, where TSM triggers the 
> dump but it's done by the NAS device across the fibre to pool defined as 
> TYPE=NDMPDUMP, not a standard TSM storage pool.
> 
> Have a customer installing an EMC (VNX)  NAS which will store multiple 
> millions of .pdf files.  The data change rate is very low, but can't back up 
> via the CIFS mount using the regular client, too many files to scan the 
> filesystem.  And VNX doesn't support snapdiff.
> 
> So the plan is to have the VNX do full and diff dumps under TSM control.
> Customer wants monthly fulls + daily diffs between, and wants to be able to 
> go back a year.
> 
> My experience is with NDMP via TCPIP in a normal TSM storage pool, but the 
> thing I see there is that when you do a new full, the previous diffs don't 
> expire.
> 
> There's no reclaim for a pool defined as TYPE-NDMPDUMP, so how do you handle 
> this without keeping 365 cartridges tied up in the vault?  Is there a good 
> way to blow way those "in between" diffs?
> 
> Thanks and Happy New Year
> 
> Wanda (NDMP is Evil) P
> 
> 
> 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)

--
Met vriendelijke groeten/Kind Regards,

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

Re: Help with NDMP dump & diff expiration

[Remco Post]

Hi,

I once raised an RFE for managing diffs separately from the fulls. 
Unfortunately the answer is NO.

workaround: use multiple nodenames and make fulls on both nodenames and diffs 
only with one yes a pita and a waste of tapes... if only IBM could think of 
something better ;-)

On 27 dec. 2012, at 18:05, "Prather, Wanda"  wrote:

> Need some help from folks doing "external" NDMP dumps, where TSM triggers the 
> dump but it's done by the NAS device across the fibre to pool defined as 
> TYPE=NDMPDUMP, not a standard TSM storage pool.
> 
> Have a customer installing an EMC (VNX)  NAS which will store multiple 
> millions of .pdf files.  The data change rate is very low, but can't back up 
> via the CIFS mount using the regular client, too many files to scan the 
> filesystem.  And VNX doesn't support snapdiff.
> 
> So the plan is to have the VNX do full and diff dumps under TSM control.
> Customer wants monthly fulls + daily diffs between, and wants to be able to 
> go back a year.
> 
> My experience is with NDMP via TCPIP in a normal TSM storage pool, but the 
> thing I see there is that when you do a new full, the previous diffs don't 
> expire.
> 
> There's no reclaim for a pool defined as TYPE-NDMPDUMP, so how do you handle 
> this without keeping 365 cartridges tied up in the vault?  Is there a good 
> way to blow way those "in between" diffs?
> 
> Thanks and Happy New Year
> 
> Wanda (NDMP is Evil) P
> 
> 
> 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)

-- 
Met vriendelijke groeten/Kind Regards,

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

Re: Help! Select statement syntax for legal reasons

[Moyer, Joni M]

Thanks Del!

I actually figured out what works:  select * from backups where 
node_name='LNBRTZM315YR' and backup_date between '06/30/2008' and '02/01/2009' 
and ll_name like '%lidz4dx%' but now I'm trying to find the tape this object is 
on and that's taking quite a while.  I'm not even sure it will return a result 
at this point in time.  

Thanks again!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
Hoobler
Sent: Friday, February 10, 2012 9:11 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help! Select statement syntax for legal reasons

Hi Joni,

Sorry... I am not a SQL expert. I will let one of the other
SQL experts assist with your question. I just wanted to make sure
that you had the correct object names.

Thanks,

Del




"ADSM: Dist Stor Manager"  wrote on 02/10/2012
08:35:02 AM:

> From: "Moyer, Joni M" 
> To: ADSM-L@vm.marist.edu
> Date: 02/10/2012 08:37 AM
> Subject: Re: Help! Select statement syntax for legal reasons
> Sent by: "ADSM: Dist Stor Manager" 
>
> Thanks Del!
>
> If I were looking for lidb88n.nsf files from the server
> LNBRTZM315YR, then would the syntax be as follows?  I'm trying to
> find all backup objects during the time period below?  Thanks again!
>
> select * from backups where node_name='LNBRTZM315YR' and backup_date
> between '06/30/2008' and '02/01/2009' and ll_name='/mail/lidb88n.nsf.*'?
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
> Behalf Of Del Hoobler
> Sent: Friday, February 10, 2012 8:26 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: Help! Select statement syntax for legal reasons
>
> When formulating your queries, please keep this in mind...
>
> From the Data Protect for Domino User's Guide...
>
> A single database backup is stored as two objects on the
> Tivoli Storage Manager server. The objects created are the
> relative database name and the relative database name
> plus a .DATA extension. For example, a backup of
> database mail6\user1.nsf would result in the following two objects:
>
>1. The relative name of the database:
>
>   mail6\user1.nsf
>
>2. The relative name of the database plus .DATA:
>
>   mail6\user1.nsf.DATA
>
>
> Thanks,
>
> Del
>
> ----
>
> Del Hoobler
> Tivoli Storage Manager Development
> IBM Corporation
>
>
>
> "ADSM: Dist Stor Manager"  wrote on 02/09/2012
> 03:44:49 PM:
>
> > From: Xav Paice 
> > To: ADSM-L@vm.marist.edu
> > Date: 02/09/2012 03:48 PM
> > Subject: Re: Help! Select statement syntax for legal reasons
> > Sent by: "ADSM: Dist Stor Manager" 
> >
> > You could, if you really want a SQL query, run the following SQL on
> > a regular basis and dump the output to a file, which will give you a
> > listing on the day of the tapes for that criteria:
> >
> > SELECT VOLUME_NAME from contents where object_id in (SELECT
> > object_id FROM backups WHERE node_name LIKE 'LNBRTZM3%5YR' AND
> > ll_name LIKE 'training%.nsf')
> >
> > If that wildcard is supposed to be just one character replace % with
> > _ , but I took * in your question to mean 'one or more of any
> > character'. Pedantic, but please ignore my own spelling and typos.
> >
> > However, the query will probably take an age to run and you'll need
> > to keep a close eye on the server in case of log pinning etc.   I'd
> > advise against it if possible.
> >
> > Note that, as previously noted, a query like this will only give you
> > a current snapshot - you seem to be asking which tapes the data was
> > on between some dates in the past - I don't know how to do that.
> > You could tell the auditors to advise you what data to collect for
> > them to query you on at a later date...maybe you need to pull a
> > complete TSM database backup out of the cycle and pop it on a shelf
> > on a regular basis to keep them happy.
> >
> > DISCLAIMER - I've not tested that query, it might have errors I've
> > not spotted.
> >
> >
> > - "Joni M Moyer"  wrote:
> >
> >
> > >
> > > I guess that's what I'm looking for today.  A report that will show
me
> > > where that particular file is on what particular tape for
LNMBRZM355YR
> > > for the mail1 filesystem for the training.nsf database for the time
> > > frame of 7/08 - 1/09.  It&

Re: Help! Select statement syntax for legal reasons

[Del Hoobler]

Hi Joni,

Sorry... I am not a SQL expert. I will let one of the other
SQL experts assist with your question. I just wanted to make sure
that you had the correct object names.

Thanks,

Del




"ADSM: Dist Stor Manager"  wrote on 02/10/2012
08:35:02 AM:

> From: "Moyer, Joni M" 
> To: ADSM-L@vm.marist.edu
> Date: 02/10/2012 08:37 AM
> Subject: Re: Help! Select statement syntax for legal reasons
> Sent by: "ADSM: Dist Stor Manager" 
>
> Thanks Del!
>
> If I were looking for lidb88n.nsf files from the server
> LNBRTZM315YR, then would the syntax be as follows?  I'm trying to
> find all backup objects during the time period below?  Thanks again!
>
> select * from backups where node_name='LNBRTZM315YR' and backup_date
> between '06/30/2008' and '02/01/2009' and ll_name='/mail/lidb88n.nsf.*'?
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
> Behalf Of Del Hoobler
> Sent: Friday, February 10, 2012 8:26 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: Help! Select statement syntax for legal reasons
>
> When formulating your queries, please keep this in mind...
>
> From the Data Protect for Domino User's Guide...
>
> A single database backup is stored as two objects on the
> Tivoli Storage Manager server. The objects created are the
> relative database name and the relative database name
> plus a .DATA extension. For example, a backup of
> database mail6\user1.nsf would result in the following two objects:
>
>1. The relative name of the database:
>
>   mail6\user1.nsf
>
>2. The relative name of the database plus .DATA:
>
>   mail6\user1.nsf.DATA
>
>
> Thanks,
>
> Del
>
> 
>
> Del Hoobler
> Tivoli Storage Manager Development
> IBM Corporation
>
>
>
> "ADSM: Dist Stor Manager"  wrote on 02/09/2012
> 03:44:49 PM:
>
> > From: Xav Paice 
> > To: ADSM-L@vm.marist.edu
> > Date: 02/09/2012 03:48 PM
> > Subject: Re: Help! Select statement syntax for legal reasons
> > Sent by: "ADSM: Dist Stor Manager" 
> >
> > You could, if you really want a SQL query, run the following SQL on
> > a regular basis and dump the output to a file, which will give you a
> > listing on the day of the tapes for that criteria:
> >
> > SELECT VOLUME_NAME from contents where object_id in (SELECT
> > object_id FROM backups WHERE node_name LIKE 'LNBRTZM3%5YR' AND
> > ll_name LIKE 'training%.nsf')
> >
> > If that wildcard is supposed to be just one character replace % with
> > _ , but I took * in your question to mean 'one or more of any
> > character'. Pedantic, but please ignore my own spelling and typos.
> >
> > However, the query will probably take an age to run and you'll need
> > to keep a close eye on the server in case of log pinning etc.   I'd
> > advise against it if possible.
> >
> > Note that, as previously noted, a query like this will only give you
> > a current snapshot - you seem to be asking which tapes the data was
> > on between some dates in the past - I don't know how to do that.
> > You could tell the auditors to advise you what data to collect for
> > them to query you on at a later date...maybe you need to pull a
> > complete TSM database backup out of the cycle and pop it on a shelf
> > on a regular basis to keep them happy.
> >
> > DISCLAIMER - I've not tested that query, it might have errors I've
> > not spotted.
> >
> >
> > - "Joni M Moyer"  wrote:
> >
> >
> > >
> > > I guess that's what I'm looking for today.  A report that will show
me
> > > where that particular file is on what particular tape for
LNMBRZM355YR
> > > for the mail1 filesystem for the training.nsf database for the time
> > > frame of 7/08 - 1/09.  It's just proof for them of where it resides
as
> > > of today.  I just don't know what the syntax of the SQL statement
> > > should be to get that information?
> > >
> > > Any thoughts/ideas?
> > >
> > > Thanks!
> > >
> > > -Original Message-
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
Behalf
> > > Of George Huebschman
> > > Sent: Thursday, February 09, 2012 2:02 PM
> > > To: ADSM-L@VM.MARIST.EDU
> > > Subject: Re: Help! Select statement syntax for legal reasons
> > >
> > > I 

Re: Help! Select statement syntax for legal reasons

[Moyer, Joni M]

Thanks Del!

If I were looking for lidb88n.nsf files from the server LNBRTZM315YR, then 
would the syntax be as follows?  I'm trying to find all backup objects during 
the time period below?  Thanks again!

select * from backups where node_name='LNBRTZM315YR' and backup_date between 
'06/30/2008' and '02/01/2009' and ll_name='/mail/lidb88n.nsf.*'?

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del 
Hoobler
Sent: Friday, February 10, 2012 8:26 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help! Select statement syntax for legal reasons

When formulating your queries, please keep this in mind...

>From the Data Protect for Domino User's Guide...

A single database backup is stored as two objects on the
Tivoli Storage Manager server. The objects created are the
relative database name and the relative database name
plus a .DATA extension. For example, a backup of
database mail6\user1.nsf would result in the following two objects:

   1. The relative name of the database:

  mail6\user1.nsf

   2. The relative name of the database plus .DATA:

  mail6\user1.nsf.DATA


Thanks,

Del



Del Hoobler
Tivoli Storage Manager Development
IBM Corporation



"ADSM: Dist Stor Manager"  wrote on 02/09/2012
03:44:49 PM:

> From: Xav Paice 
> To: ADSM-L@vm.marist.edu
> Date: 02/09/2012 03:48 PM
> Subject: Re: Help! Select statement syntax for legal reasons
> Sent by: "ADSM: Dist Stor Manager" 
>
> You could, if you really want a SQL query, run the following SQL on
> a regular basis and dump the output to a file, which will give you a
> listing on the day of the tapes for that criteria:
>
> SELECT VOLUME_NAME from contents where object_id in (SELECT
> object_id FROM backups WHERE node_name LIKE 'LNBRTZM3%5YR' AND
> ll_name LIKE 'training%.nsf')
>
> If that wildcard is supposed to be just one character replace % with
> _ , but I took * in your question to mean 'one or more of any
> character'. Pedantic, but please ignore my own spelling and typos.
>
> However, the query will probably take an age to run and you'll need
> to keep a close eye on the server in case of log pinning etc.   I'd
> advise against it if possible.
>
> Note that, as previously noted, a query like this will only give you
> a current snapshot - you seem to be asking which tapes the data was
> on between some dates in the past - I don't know how to do that.
> You could tell the auditors to advise you what data to collect for
> them to query you on at a later date...maybe you need to pull a
> complete TSM database backup out of the cycle and pop it on a shelf
> on a regular basis to keep them happy.
>
> DISCLAIMER - I've not tested that query, it might have errors I've
> not spotted.
>
>
> - "Joni M Moyer"  wrote:
>
>
> >
> > I guess that's what I'm looking for today.  A report that will show me
> > where that particular file is on what particular tape for LNMBRZM355YR
> > for the mail1 filesystem for the training.nsf database for the time
> > frame of 7/08 - 1/09.  It's just proof for them of where it resides as
> > of today.  I just don't know what the syntax of the SQL statement
> > should be to get that information?
> >
> > Any thoughts/ideas?
> >
> > Thanks!
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> > Of George Huebschman
> > Sent: Thursday, February 09, 2012 2:02 PM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: Re: Help! Select statement syntax for legal reasons
> >
> > I agree with Thom, the data gets spread everywhere and moved often by
> > reclamation.  You can only tell them where it was when you ran the
> > report.
> >
> > On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier <
> > thomas.den...@jeffersonhospital.org> wrote:
> >
> > > -Joni Moyer wrote: -
> > >
> > > >I have a situation where someone wants to know what tapes
> > particular
> > > >people's backup data is on for our TDP for Mail backups for the
> > time
> > > >period from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR
> > and
> > > >the mail filesystem location is: mailx and the .nsf file names we
> > are
> > > >looking for are the training*.nsf and we need to know what tapes
> > the
> > > >data is on.
> > > >
> > > >
> > > >LNBRTZM335YR, mail1\training.nsf
> > > >
> > > >LNBRTZM355YR, mail2\t

Re: Help! Select statement syntax for legal reasons

[Del Hoobler]

When formulating your queries, please keep this in mind...

>From the Data Protect for Domino User's Guide...

A single database backup is stored as two objects on the
Tivoli Storage Manager server. The objects created are the
relative database name and the relative database name
plus a .DATA extension. For example, a backup of
database mail6\user1.nsf would result in the following two objects:

   1. The relative name of the database:

  mail6\user1.nsf

   2. The relative name of the database plus .DATA:

  mail6\user1.nsf.DATA


Thanks,

Del



Del Hoobler
Tivoli Storage Manager Development
IBM Corporation



"ADSM: Dist Stor Manager"  wrote on 02/09/2012
03:44:49 PM:

> From: Xav Paice 
> To: ADSM-L@vm.marist.edu
> Date: 02/09/2012 03:48 PM
> Subject: Re: Help! Select statement syntax for legal reasons
> Sent by: "ADSM: Dist Stor Manager" 
>
> You could, if you really want a SQL query, run the following SQL on
> a regular basis and dump the output to a file, which will give you a
> listing on the day of the tapes for that criteria:
>
> SELECT VOLUME_NAME from contents where object_id in (SELECT
> object_id FROM backups WHERE node_name LIKE 'LNBRTZM3%5YR' AND
> ll_name LIKE 'training%.nsf')
>
> If that wildcard is supposed to be just one character replace % with
> _ , but I took * in your question to mean 'one or more of any
> character'. Pedantic, but please ignore my own spelling and typos.
>
> However, the query will probably take an age to run and you'll need
> to keep a close eye on the server in case of log pinning etc.   I'd
> advise against it if possible.
>
> Note that, as previously noted, a query like this will only give you
> a current snapshot - you seem to be asking which tapes the data was
> on between some dates in the past - I don't know how to do that.
> You could tell the auditors to advise you what data to collect for
> them to query you on at a later date...maybe you need to pull a
> complete TSM database backup out of the cycle and pop it on a shelf
> on a regular basis to keep them happy.
>
> DISCLAIMER - I've not tested that query, it might have errors I've
> not spotted.
>
>
> - "Joni M Moyer"  wrote:
>
>
> >
> > I guess that's what I'm looking for today.  A report that will show me
> > where that particular file is on what particular tape for LNMBRZM355YR
> > for the mail1 filesystem for the training.nsf database for the time
> > frame of 7/08 - 1/09.  It's just proof for them of where it resides as
> > of today.  I just don't know what the syntax of the SQL statement
> > should be to get that information?
> >
> > Any thoughts/ideas?
> >
> > Thanks!
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> > Of George Huebschman
> > Sent: Thursday, February 09, 2012 2:02 PM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: Re: Help! Select statement syntax for legal reasons
> >
> > I agree with Thom, the data gets spread everywhere and moved often by
> > reclamation.  You can only tell them where it was when you ran the
> > report.
> >
> > On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier <
> > thomas.den...@jeffersonhospital.org> wrote:
> >
> > > -Joni Moyer wrote: -
> > >
> > > >I have a situation where someone wants to know what tapes
> > particular
> > > >people's backup data is on for our TDP for Mail backups for the
> > time
> > > >period from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR
> > and
> > > >the mail filesystem location is: mailx and the .nsf file names we
> > are
> > > >looking for are the training*.nsf and we need to know what tapes
> > the
> > > >data is on.
> > > >
> > > >
> > > >LNBRTZM335YR, mail1\training.nsf
> > > >
> > > >LNBRTZM355YR, mail2\training2.nsf
> > > >
> > > >Does anyone know what the syntax of this select statement would be
> > to
> > > >find this information?  Any help is greatly appreciated as I was
> > told
> > > >I need this information by EOD and I'm not quite sure how to
> > gather
> > > >this from the TSM server side.  My TSM server is on AIX and is at
> > > >5.5.5.0.
> > >
> > > TSM files on tape are more or less routinely moved to other volumes
> > > by reclamation processing. As far as I can tell, there are three
> > > possible ways of dealing with this possibility: suppress
> > reclamation
> > > of the volumes involved, send updates to the lawyers when and if
> > > files are move to other volumes, or respond in bad faith by
> > implying
> > > that today's information will remain valid indefinitely.
> > >
> > > Thomas Denier
> >
>

Re: Help! Select statement syntax for legal reasons

[Xav Paice]

You could, if you really want a SQL query, run the following SQL on a regular 
basis and dump the output to a file, which will give you a listing on the day 
of the tapes for that criteria:

SELECT VOLUME_NAME from contents where object_id in (SELECT object_id FROM 
backups WHERE node_name LIKE 'LNBRTZM3%5YR' AND ll_name LIKE 'training%.nsf')

If that wildcard is supposed to be just one character replace % with _ , but I 
took * in your question to mean 'one or more of any character'. Pedantic, but 
please ignore my own spelling and typos.

However, the query will probably take an age to run and you'll need to keep a 
close eye on the server in case of log pinning etc.   I'd advise against it if 
possible.

Note that, as previously noted, a query like this will only give you a current 
snapshot - you seem to be asking which tapes the data was on between some dates 
in the past - I don't know how to do that.  You could tell the auditors to 
advise you what data to collect for them to query you on at a later 
date...maybe you need to pull a complete TSM database backup out of the cycle 
and pop it on a shelf on a regular basis to keep them happy.

DISCLAIMER - I've not tested that query, it might have errors I've not spotted.


- "Joni M Moyer"  wrote:


>
> I guess that's what I'm looking for today.  A report that will show me
> where that particular file is on what particular tape for LNMBRZM355YR
> for the mail1 filesystem for the training.nsf database for the time
> frame of 7/08 - 1/09.  It's just proof for them of where it resides as
> of today.  I just don't know what the syntax of the SQL statement
> should be to get that information?
>
> Any thoughts/ideas?
>
> Thanks!
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> Of George Huebschman
> Sent: Thursday, February 09, 2012 2:02 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: Help! Select statement syntax for legal reasons
>
> I agree with Thom, the data gets spread everywhere and moved often by
> reclamation.  You can only tell them where it was when you ran the
> report.
>
> On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier <
> thomas.den...@jeffersonhospital.org> wrote:
>
> > -Joni Moyer wrote: -
> >
> > >I have a situation where someone wants to know what tapes
> particular
> > >people's backup data is on for our TDP for Mail backups for the
> time
> > >period from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR
> and
> > >the mail filesystem location is: mailx and the .nsf file names we
> are
> > >looking for are the training*.nsf and we need to know what tapes
> the
> > >data is on.
> > >
> > >
> > >LNBRTZM335YR, mail1\training.nsf
> > >
> > >LNBRTZM355YR, mail2\training2.nsf
> > >
> > >Does anyone know what the syntax of this select statement would be
> to
> > >find this information?  Any help is greatly appreciated as I was
> told
> > >I need this information by EOD and I'm not quite sure how to
> gather
> > >this from the TSM server side.  My TSM server is on AIX and is at
> > >5.5.5.0.
> >
> > TSM files on tape are more or less routinely moved to other volumes
> > by reclamation processing. As far as I can tell, there are three
> > possible ways of dealing with this possibility: suppress
> reclamation
> > of the volumes involved, send updates to the lawyers when and if
> > files are move to other volumes, or respond in bad faith by
> implying
> > that today's information will remain valid indefinitely.
> >
> > Thomas Denier
>

Re: Help! Select statement syntax for legal reasons

[Moyer, Joni M]

I guess that's what I'm looking for today.  A report that will show me where 
that particular file is on what particular tape for LNMBRZM355YR for the mail1 
filesystem for the training.nsf database for the time frame of 7/08 - 1/09.  
It's just proof for them of where it resides as of today.  I just don't know 
what the syntax of the SQL statement should be to get that information?

Any thoughts/ideas?

Thanks!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of George 
Huebschman
Sent: Thursday, February 09, 2012 2:02 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help! Select statement syntax for legal reasons

I agree with Thom, the data gets spread everywhere and moved often by
reclamation.  You can only tell them where it was when you ran the report.

On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier <
thomas.den...@jeffersonhospital.org> wrote:

> -Joni Moyer wrote: -
>
> >I have a situation where someone wants to know what tapes particular
> >people's backup data is on for our TDP for Mail backups for the time
> >period from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR and
> >the mail filesystem location is: mailx and the .nsf file names we are
> >looking for are the training*.nsf and we need to know what tapes the
> >data is on.
> >
> >
> >LNBRTZM335YR, mail1\training.nsf
> >
> >LNBRTZM355YR, mail2\training2.nsf
> >
> >Does anyone know what the syntax of this select statement would be to
> >find this information?  Any help is greatly appreciated as I was told
> >I need this information by EOD and I'm not quite sure how to gather
> >this from the TSM server side.  My TSM server is on AIX and is at
> >5.5.5.0.
>
> TSM files on tape are more or less routinely moved to other volumes
> by reclamation processing. As far as I can tell, there are three
> possible ways of dealing with this possibility: suppress reclamation
> of the volumes involved, send updates to the lawyers when and if
> files are move to other volumes, or respond in bad faith by implying
> that today's information will remain valid indefinitely.
>
> Thomas Denier



This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.

Re: Help! Select statement syntax for legal reasons

[Ajay Patel]

Hi,
Please check this link
https://www-304.ibm.com/support/docview.wss?uid=swg21114873

Regards,
Ajay Patel







From:   George Huebschman 
To: ADSM-L@vm.marist.edu,
Date:   02/09/2012 12:10 PM
Subject:Re: [ADSM-L] Help! Select statement syntax for legal
reasons
Sent by:"ADSM: Dist Stor Manager" 



I agree with Thom, the data gets spread everywhere and moved often by
reclamation.  You can only tell them where it was when you ran the report.

On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier <
thomas.den...@jeffersonhospital.org> wrote:

> -Joni Moyer wrote: -
>
> >I have a situation where someone wants to know what tapes particular
> >people's backup data is on for our TDP for Mail backups for the time
> >period from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR and
> >the mail filesystem location is: mailx and the .nsf file names we are
> >looking for are the training*.nsf and we need to know what tapes the
> >data is on.
> >
> >
> >LNBRTZM335YR, mail1\training.nsf
> >
> >LNBRTZM355YR, mail2\training2.nsf
> >
> >Does anyone know what the syntax of this select statement would be to
> >find this information?  Any help is greatly appreciated as I was told
> >I need this information by EOD and I'm not quite sure how to gather
> >this from the TSM server side.  My TSM server is on AIX and is at
> >5.5.5.0.
>
> TSM files on tape are more or less routinely moved to other volumes
> by reclamation processing. As far as I can tell, there are three
> possible ways of dealing with this possibility: suppress reclamation
> of the volumes involved, send updates to the lawyers when and if
> files are move to other volumes, or respond in bad faith by implying
> that today's information will remain valid indefinitely.
>
> Thomas Denier

Re: Help! Select statement syntax for legal reasons

[Richard Sims]

My suspicion is that the legal request is a lawyer's pro forma procedure 
written in the 1980s for collecting evidentiary information in a data 
processing environment: "Obtain a list of the tapes upon which the data 
resides".  It's likely that they don't actually care what tapes are involved: 
their goal is to generate a list which contributes to an impressive compendium 
of factoids which fill lawyerly paper.

Given the size of TSM tables, my inclination would be to narrow down to a set 
of tapes, which you know by virtue of common storage pool and perhaps 
collocation by node.  Then perform 'query content' on each volume, output to a 
file per volume, which you can subsequently grep for containing the files of 
interest.  Query Content is tailored and efficient, greatly reducing time and 
impact.

Richard Simsnot a lawyer

Re: Help! Select statement syntax for legal reasons

[George Huebschman]

I agree with Thom, the data gets spread everywhere and moved often by
reclamation.  You can only tell them where it was when you ran the report.

On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier <
thomas.den...@jeffersonhospital.org> wrote:

> -Joni Moyer wrote: -
>
> >I have a situation where someone wants to know what tapes particular
> >people's backup data is on for our TDP for Mail backups for the time
> >period from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR and
> >the mail filesystem location is: mailx and the .nsf file names we are
> >looking for are the training*.nsf and we need to know what tapes the
> >data is on.
> >
> >
> >LNBRTZM335YR, mail1\training.nsf
> >
> >LNBRTZM355YR, mail2\training2.nsf
> >
> >Does anyone know what the syntax of this select statement would be to
> >find this information?  Any help is greatly appreciated as I was told
> >I need this information by EOD and I'm not quite sure how to gather
> >this from the TSM server side.  My TSM server is on AIX and is at
> >5.5.5.0.
>
> TSM files on tape are more or less routinely moved to other volumes
> by reclamation processing. As far as I can tell, there are three
> possible ways of dealing with this possibility: suppress reclamation
> of the volumes involved, send updates to the lawyers when and if
> files are move to other volumes, or respond in bad faith by implying
> that today's information will remain valid indefinitely.
>
> Thomas Denier

Re: Help! Select statement syntax for legal reasons

[George Huebschman]

Joni,
It isn't elegant, and it won't produce a report format, but it should
narrow your search down a lot and make a query of the Contents Table a lot
lighter:
 You could try initiating restores of the data to see what tapes are
called for.  Just check the actlog.
Then you could do a select against the contents table (which can be huge)
for just those tapes and that Node.

I hope that is helpful.

George Huebschman

On Thu, Feb 9, 2012 at 12:22 PM, Moyer, Joni M wrote:

> Hi Everyone,
>
> I have a situation where someone wants to know what tapes particular
> people's backup data is on for our TDP for Mail backups for the time period
> from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR and the mail
> filesystem location is: mailx and the .nsf file names we are looking for
> are the training*.nsf and we need to know what tapes the data is on.
>
>
> LNBRTZM335YR, mail1\training.nsf
>
> LNBRTZM355YR, mail2\training2.nsf
>
> Does anyone know what the syntax of this select statement would be to find
> this information?  Any help is greatly appreciated as I was told I need
> this information by EOD and I'm not quite sure how to gather this from the
> TSM server side.  My TSM server is on AIX and is at 5.5.5.0.
>
> Any help is greatly appreciated!
>
> Thanks in advance!
>
> Joni
>
>
> 
>
> This e-mail and any attachments to it are confidential and are intended
> solely for use of the individual or entity to whom they are addressed. If
> you have received this e-mail in error, please notify the sender
> immediately and then delete it. If you are not the intended recipient, you
> must not keep, use, disclose, copy or distribute this e-mail without the
> author's prior permission. The views expressed in this e-mail message do
> not necessarily represent the views of Highmark Inc., its subsidiaries, or
> affiliates.
>

Re: Help! Select statement syntax for legal reasons

[Thomas Denier]

-Joni Moyer wrote: -

>I have a situation where someone wants to know what tapes particular
>people's backup data is on for our TDP for Mail backups for the time
>period from 7/08 - 1/09.  The TSM client names are LNBRTZM3*5YR and
>the mail filesystem location is: mailx and the .nsf file names we are
>looking for are the training*.nsf and we need to know what tapes the
>data is on.
>
>
>LNBRTZM335YR, mail1\training.nsf
>
>LNBRTZM355YR, mail2\training2.nsf
>
>Does anyone know what the syntax of this select statement would be to
>find this information?  Any help is greatly appreciated as I was told
>I need this information by EOD and I'm not quite sure how to gather
>this from the TSM server side.  My TSM server is on AIX and is at
>5.5.5.0.

TSM files on tape are more or less routinely moved to other volumes
by reclamation processing. As far as I can tell, there are three
possible ways of dealing with this possibility: suppress reclamation
of the volumes involved, send updates to the lawyers when and if
files are move to other volumes, or respond in bad faith by implying
that today's information will remain valid indefinitely.

Thomas Denier

Re: Ang: Re: Help tracking down spurious "Failed 12"

[Zoltan Forray/AC/VCU]

We had the same problem with a Windows box when the client was upgraded
from 6.1 to 6.2.  The help file from the previous version was left behind
and caused errors.  Replaced it with the same version installed by the
newer client (but into a different sub-directory)


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:   Lindsay Morris 
To: ADSM-L@VM.MARIST.EDU
Date:   11/02/2011 09:22 PM
Subject:Re: [ADSM-L] Ang: Re: Help tracking down spurious "Failed
12"
Sent by:"ADSM: Dist Stor Manager" 



We have the same issue.  In our case, it's caused by a corrupt or
mismatched dscenu.txt file, causing "ANS0106E message index not found for
message..." in dsmerror.log.

To fix it, we stop the TSM scheduler (no need for that if you're using CAD
I guess), replace the dscenu.txt file with a good one from a client that
is
NOT giving you RC 12s, and restart the scheduler. Works for us anyway.

Lindsay Morris
CEO, TSMworks
Tel. 1-859-539-9900
lind...@tsmworks.com


On Fri, Aug 26, 2011 at 12:37 PM, Andrew Raibeck 
wrote:

> An in-use file should not cause an RC 12. Either you are running an old
> client level with some defect that issues the wrong return code (for
> example, see go to the URL in my sig and search for IC35763); or there
is
> some additional error being thrown that causes the RC to be set to 12.
> Examine your dsmerror.log and dsmsched.log files very carefully for any
> other ANSE or ANSS messages that might trigger the RC 12. Also,
see
> my other recent posts on this topic.
>
> 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_Storage_Manager

>
> "ADSM: Dist Stor Manager"  wrote on 2011-08-25
> 09:26:24:
>
> > From: Jimou 
> > To: ADSM-L@vm.marist.edu
> > Date: 2011-08-26 12:15
> > Subject: Ang: Re: Help tracking down spurious "Failed 12"
> > Sent by: "ADSM: Dist Stor Manager" 
> >
> > Hi
> > I wonder why we can have a RC =12 for a skipped file in use,
> > cause there http://www.dsi.upmc.fr/dsi/doc/stockage/clients-tsm/
> > tsmwin/ans60012.htm
> > i see that it should be RC=4
> >
> > But i also have a RC=12 and the only message i got is "in used file".
> >
> > Someone could explain to me why it is not a RC=4 ??
> > Ty in advance.
> >
> >
+--
> > |This was sent by jm.fa...@gmail.com via Backup Central.
> > |Forward SPAM to ab...@backupcentral.com.
> >
+--
>

Re: Ang: Re: Help tracking down spurious "Failed 12"

[Lindsay Morris]

We have the same issue.  In our case, it's caused by a corrupt or
mismatched dscenu.txt file, causing "ANS0106E message index not found for
message..." in dsmerror.log.

To fix it, we stop the TSM scheduler (no need for that if you're using CAD
I guess), replace the dscenu.txt file with a good one from a client that is
NOT giving you RC 12s, and restart the scheduler. Works for us anyway.

Lindsay Morris
CEO, TSMworks
Tel. 1-859-539-9900
lind...@tsmworks.com


On Fri, Aug 26, 2011 at 12:37 PM, Andrew Raibeck  wrote:

> An in-use file should not cause an RC 12. Either you are running an old
> client level with some defect that issues the wrong return code (for
> example, see go to the URL in my sig and search for IC35763); or there is
> some additional error being thrown that causes the RC to be set to 12.
> Examine your dsmerror.log and dsmsched.log files very carefully for any
> other ANSE or ANSS messages that might trigger the RC 12. Also, see
> my other recent posts on this topic.
>
> 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_Storage_Manager
>
> "ADSM: Dist Stor Manager"  wrote on 2011-08-25
> 09:26:24:
>
> > From: Jimou 
> > To: ADSM-L@vm.marist.edu
> > Date: 2011-08-26 12:15
> > Subject: Ang: Re: Help tracking down spurious "Failed 12"
> > Sent by: "ADSM: Dist Stor Manager" 
> >
> > Hi
> > I wonder why we can have a RC =12 for a skipped file in use,
> > cause there http://www.dsi.upmc.fr/dsi/doc/stockage/clients-tsm/
> > tsmwin/ans60012.htm
> > i see that it should be RC=4
> >
> > But i also have a RC=12 and the only message i got is "in used file".
> >
> > Someone could explain to me why it is not a RC=4 ??
> > Ty in advance.
> >
> > +--
> > |This was sent by jm.fa...@gmail.com via Backup Central.
> > |Forward SPAM to ab...@backupcentral.com.
> > +--
>

Re: Help on Tsm 6 script

[Erwann SIMON]

Hi Robert,

With TSM v6, you have to determine the max lengh of each column and then cast 
the coumns to this max lengh in order to have the output displayed as table 
view.

There's a technote on this subject.
--
Best regards / Cordialement / مع تحياتي
Erwann SIMON

-Original Message-
From: Robert Ouzen 
Sender: "ADSM: Dist Stor Manager" 
Date: Sun, 23 Oct 2011 07:48:24 
To: 
Reply-To: "ADSM: Dist Stor Manager" 
Subject: Re: [ADSM-L] Help on Tsm 6 script

Another question , anybody know how to get the output as a table view.

Now in version 6 the output is  shown in lines instead before in table , like 
for example this script:  run list

select node_name , platform_name , tcp_address , contact from nodes group by 
contact , node_name , tcp_address , platform_name

Output in V5:

NODE_NAME  PLATFORM_NAMETCP_ADDRESSCONTACT
--   -- 
--
ADSM AIX   
132.74.XX.XX  CC
AUTH-S1   Linux86   
132.74.XX.XX  CC

Output in V6:


NODE_NAME: AKKO
PLATFORM_NAME: WinNT
  TCP_ADDRESS: 132.74.XX.XX
  CONTACT: Sea Department

NODE_NAME: ALEPHPROD
PLATFORM_NAME: Linux86
  TCP_ADDRESS: 132.74.XX.XX
  CONTACT: Library

Any ideas ?

Regards  Robert

Hi Rainer

Just what I needed ...

Thanks, Regards

Robert

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer 
Sch?pf
Sent: Friday, October 21, 2011 10:52 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help on Tsm 6 script

Hi Robert,

I believe the difference of two timestamps is given in seconds. To convert that 
to minutes or hours, you can use the timestampdiff function:

  
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r861.htm

E.g.,

  select -
   timestampdiff(4,char(current_timestamp-start_time)) -
   from processes

gives you the elapsed time in minutes.

 Rainer



On Thu, 20 Oct 2011, Robert Ouzen wrote:

 > Hi to all
 >
 > This week I upgrade one  my Tsm server from V5.5.4.0 to V6.2.3.0 in Windows 
 > platform 2008R2, everything work fine ….
 >
 > Now trying to update some scripts by example this one (Report of backup / 
 > archive in specific period).
 >
 > set sqlmathmode round
 > set sqldatetimeformat eur
 > select entity as nodename, -
 > date(start_time) as "Date (Y/M/D)", -
 > time(start_time) as "Begin time", -
 > time(end_time) as "End time", -
 > cast(sum(affected) as varchar(10)) as "Num Obj", -
 > cast(sum(failed) as varchar(10)) as "Num Obj Failed", -
 >   case -
 > when sum(bytes)>1073741824 then cast(sum(bytes)/1073741824 as 
 > varchar(10)) || ' Gb' -
 > when sum(bytes)>1048576 then cast(sum(bytes)/1048576 as varchar(10)) || 
 > ' Mb' -
 > when sum(bytes)>1024 then cast(sum(bytes)/1024 as varchar(10)) || ' Kb' -
 > else cast(sum(bytes) as varchar(10)) -
 > end as "Bytes" -
 >   from summary -
 >   where (activity='BACKUP' or activity='ARCHIVE') and -
 >  start_time>=timestamp(current_date-$1 day,'10:00:00') and -
 >  start_time<=timestamp(current_date,'09:00:00') and -
 >  successful='YES' -
 >  and entity  like upper('%%$2%%') -
 >group by entity,start_time,end_time
 >
 > How can I calculate the elapsed time between the begin and end time this 
 > line in my previous version work fine but here I got:  ELAPSED: 7.00  >  
 > > Here the line I used:
 > substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, -  >  > By 
 > the way it is a possibility to got the output as a table now I got the 
 > output in few lines ?
 >
 > Regards  Robert
 > 


ProteoSys AG
Carl-Zeiss-Straße 51
55129 Mainz

Dr. Rainer Schöpf
Leiter Software/Softwareentwicklung

Mail:   rainer.scho...@proteosys.com
Phone:  +49-(0)6131-50192-41
Fax:+49-(0)6131-50192-11
WWW:http://www.proteosys.com/

ProteoSys AG - Carl-Zeiss-Str. 51 - D-55129 Mainz Amtsgericht Mainz HRB 7508 - 
USt.-Id Nr.: DE213940570
Vorstand: Helmut Matthies (Vorsitzender), Prof. Dr. André Schrattenholz 
Vorsitzender des Aufsichtsrates: Dr. Werner Zöllner

Re: Help on Tsm 6 script

[Grigori Solonovitch]

Maybe look for "dsmadmc -displaymode=table ..."

Grigori G. Solonovitch

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Robert 
Ouzen
Sent: Sunday, October 23, 2011 10:48 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help on Tsm 6 script

Another question , anybody know how to get the output as a table view.

Now in version 6 the output is  shown in lines instead before in table , like 
for example this script:  run list

select node_name , platform_name , tcp_address , contact from nodes group by 
contact , node_name , tcp_address , platform_name

Output in V5:

NODE_NAME  PLATFORM_NAMETCP_ADDRESSCONTACT
--   -- 
--
ADSM AIX   
132.74.XX.XX  CC
AUTH-S1   Linux86   
132.74.XX.XX  CC

Output in V6:


NODE_NAME: AKKO
PLATFORM_NAME: WinNT
  TCP_ADDRESS: 132.74.XX.XX
  CONTACT: Sea Department

NODE_NAME: ALEPHPROD
PLATFORM_NAME: Linux86
  TCP_ADDRESS: 132.74.XX.XX
  CONTACT: Library

Any ideas ?

Regards  Robert

Hi Rainer

Just what I needed ...

Thanks, Regards

Robert

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer 
Sch?pf
Sent: Friday, October 21, 2011 10:52 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help on Tsm 6 script

Hi Robert,

I believe the difference of two timestamps is given in seconds. To convert that 
to minutes or hours, you can use the timestampdiff function:

  
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r861.htm

E.g.,

  select -
   timestampdiff(4,char(current_timestamp-start_time)) -
   from processes

gives you the elapsed time in minutes.

 Rainer



On Thu, 20 Oct 2011, Robert Ouzen wrote:

 > Hi to all
 >
 > This week I upgrade one  my Tsm server from V5.5.4.0 to V6.2.3.0 in Windows 
 > platform 2008R2, everything work fine 
 >
 > Now trying to update some scripts by example this one (Report of backup / 
 > archive in specific period).
 >
 > set sqlmathmode round
 > set sqldatetimeformat eur
 > select entity as nodename, -
 > date(start_time) as "Date (Y/M/D)", -
 > time(start_time) as "Begin time", -
 > time(end_time) as "End time", -
 > cast(sum(affected) as varchar(10)) as "Num Obj", -
 > cast(sum(failed) as varchar(10)) as "Num Obj Failed", -
 >   case -
 > when sum(bytes)>1073741824 then cast(sum(bytes)/1073741824 as 
 > varchar(10)) || ' Gb' -
 > when sum(bytes)>1048576 then cast(sum(bytes)/1048576 as varchar(10)) || 
 > ' Mb' -
 > when sum(bytes)>1024 then cast(sum(bytes)/1024 as varchar(10)) || ' Kb' -
 > else cast(sum(bytes) as varchar(10)) -
 > end as "Bytes" -
 >   from summary -
 >   where (activity='BACKUP' or activity='ARCHIVE') and -
 >  start_time>=timestamp(current_date-$1 day,'10:00:00') and -
 >  start_time<=timestamp(current_date,'09:00:00') and -
 >  successful='YES' -
 >  and entity  like upper('%%$2%%') -
 >group by entity,start_time,end_time
 >
 > How can I calculate the elapsed time between the begin and end time this 
 > line in my previous version work fine but here I got:  ELAPSED: 7.00  >  
 > > Here the line I used:
 > substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, -  >  > By 
 > the way it is a possibility to got the output as a table now I got the 
 > output in few lines ?
 >
 > Regards  Robert
 >


ProteoSys AG
Carl-Zeiss-Straße 51
55129 Mainz

Dr. Rainer Schöpf
Leiter Software/Softwareentwicklung

Mail:   rainer.scho...@proteosys.com
Phone:  +49-(0)6131-50192-41
Fax:+49-(0)6131-50192-11
WWW:http://www.proteosys.com/

ProteoSys AG - Carl-Zeiss-Str. 51 - D-55129 Mainz Amtsgericht Mainz HRB 7508 - 
USt.-Id Nr.: DE213940570
Vorstand: Helmut Matthies (Vorsitzender), Prof. Dr. André Schrattenholz 
Vorsitzender des Aufsichtsrates: Dr. Werner Zöllner

Please consider the environment before printing this Email.

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or inte

Re: Help on Tsm 6 script

[Robert Ouzen]

Hi Rainer
Just what I needed ...

Thanks, Regards

Robert

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer 
Sch?pf
Sent: Friday, October 21, 2011 10:52 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help on Tsm 6 script

Hi Robert,

I believe the difference of two timestamps is given in seconds. To convert that 
to minutes or hours, you can use the timestampdiff function:

  
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r861.htm

E.g.,

  select -
   timestampdiff(4,char(current_timestamp-start_time)) -
   from processes

gives you the elapsed time in minutes.

 Rainer



On Thu, 20 Oct 2011, Robert Ouzen wrote:

 > Hi to all
 >
 > This week I upgrade one  my Tsm server from V5.5.4.0 to V6.2.3.0 in Windows 
 > platform 2008R2, everything work fine ….
 >
 > Now trying to update some scripts by example this one (Report of backup / 
 > archive in specific period).
 >
 > set sqlmathmode round
 > set sqldatetimeformat eur
 > select entity as nodename, -
 > date(start_time) as "Date (Y/M/D)", -
 > time(start_time) as "Begin time", -
 > time(end_time) as "End time", -
 > cast(sum(affected) as varchar(10)) as "Num Obj", -
 > cast(sum(failed) as varchar(10)) as "Num Obj Failed", -
 >   case -
 > when sum(bytes)>1073741824 then cast(sum(bytes)/1073741824 as 
 > varchar(10)) || ' Gb' -
 > when sum(bytes)>1048576 then cast(sum(bytes)/1048576 as varchar(10)) || 
 > ' Mb' -
 > when sum(bytes)>1024 then cast(sum(bytes)/1024 as varchar(10)) || ' Kb' -
 > else cast(sum(bytes) as varchar(10)) -
 > end as "Bytes" -
 >   from summary -
 >   where (activity='BACKUP' or activity='ARCHIVE') and -
 >  start_time>=timestamp(current_date-$1 day,'10:00:00') and -
 >  start_time<=timestamp(current_date,'09:00:00') and -
 >  successful='YES' -
 >  and entity  like upper('%%$2%%') -
 >group by entity,start_time,end_time
 >
 > How can I calculate the elapsed time between the begin and end time this 
 > line in my previous version work fine but here I got:  ELAPSED: 7.00  >  
 > > Here the line I used:
 > substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, -  >  > By 
 > the way it is a possibility to got the output as a table now I got the 
 > output in few lines ?
 >
 > Regards  Robert
 > 


ProteoSys AG
Carl-Zeiss-Straße 51
55129 Mainz

Dr. Rainer Schöpf
Leiter Software/Softwareentwicklung

Mail:   rainer.scho...@proteosys.com
Phone:  +49-(0)6131-50192-41
Fax:+49-(0)6131-50192-11
WWW:http://www.proteosys.com/

ProteoSys AG - Carl-Zeiss-Str. 51 - D-55129 Mainz Amtsgericht Mainz HRB 7508 - 
USt.-Id Nr.: DE213940570
Vorstand: Helmut Matthies (Vorsitzender), Prof. Dr. André Schrattenholz 
Vorsitzender des Aufsichtsrates: Dr. Werner Zöllner

Re: Help on Tsm 6 script

[Rainer Schöpf]

Hi Robert,

I believe the difference of two timestamps is given in seconds. To convert that 
to minutes or hours, you can use the timestampdiff function:

  
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r861.htm

E.g.,

  select -
   timestampdiff(4,char(current_timestamp-start_time)) -
   from processes

gives you the elapsed time in minutes.

 Rainer



On Thu, 20 Oct 2011, Robert Ouzen wrote:

 > Hi to all
 > 
 > This week I upgrade one  my Tsm server from V5.5.4.0 to V6.2.3.0 in Windows 
 > platform 2008R2, everything work fine ….
 > 
 > Now trying to update some scripts by example this one (Report of backup / 
 > archive in specific period).
 > 
 > set sqlmathmode round
 > set sqldatetimeformat eur
 > select entity as nodename, -
 > date(start_time) as "Date (Y/M/D)", -
 > time(start_time) as "Begin time", -
 > time(end_time) as "End time", -
 > cast(sum(affected) as varchar(10)) as "Num Obj", -
 > cast(sum(failed) as varchar(10)) as "Num Obj Failed", -
 >   case -
 > when sum(bytes)>1073741824 then cast(sum(bytes)/1073741824 as 
 > varchar(10)) || ' Gb' -
 > when sum(bytes)>1048576 then cast(sum(bytes)/1048576 as varchar(10)) || 
 > ' Mb' -
 > when sum(bytes)>1024 then cast(sum(bytes)/1024 as varchar(10)) || ' Kb' -
 > else cast(sum(bytes) as varchar(10)) -
 > end as "Bytes" -
 >   from summary -
 >   where (activity='BACKUP' or activity='ARCHIVE') and -
 >  start_time>=timestamp(current_date-$1 day,'10:00:00') and -
 >  start_time<=timestamp(current_date,'09:00:00') and -
 >  successful='YES' -
 >  and entity  like upper('%%$2%%') -
 >group by entity,start_time,end_time
 > 
 > How can I calculate the elapsed time between the begin and end time this 
 > line in my previous version work fine but here I got:  ELAPSED: 7.00
 > 
 > Here the line I used:
 > substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, -
 > 
 > By the way it is a possibility to got the output as a table now I got the 
 > output in few lines ?
 > 
 > Regards  Robert
 > 


ProteoSys AG
Carl-Zeiss-Straße 51
55129 Mainz

Dr. Rainer Schöpf
Leiter Software/Softwareentwicklung

Mail:   rainer.scho...@proteosys.com
Phone:  +49-(0)6131-50192-41
Fax:+49-(0)6131-50192-11
WWW:http://www.proteosys.com/

ProteoSys AG - Carl-Zeiss-Str. 51 - D-55129 Mainz
Amtsgericht Mainz HRB 7508 - USt.-Id Nr.: DE213940570
Vorstand: Helmut Matthies (Vorsitzender), Prof. Dr. André Schrattenholz
Vorsitzender des Aufsichtsrates: Dr. Werner Zöllner

Re: help

[Ferid Cholich]

Sorry for this post. It was intended to go to lists...@vm.marist.edu and not to 
ads...@marist.edu . That is result of old age, lack of think and not being here 
for eons. I'll post my question with real subject.
Thanks,
Ferid.

- Original Message -
From: "Thorneycroft, Doug" 
To: 'Ferid Cholich' 
Cc: 
Sent: Thursday, September 22, 2011 7:43 PM
Subject: RE: help

http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ferid 
Cholich
Sent: Thursday, September 22, 2011 10:07 AM
To: ADSM-L@VM.MARIST.EDU
Subject: help

HELP

Re: Help Required Diagnosing ASR Backup Problem

[Lee, Gary D.]

Take a look at the windows aplication event logs.

There is usually more info there.
 


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

 
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Davis, 
Adrian
Sent: Friday, September 09, 2011 8:12 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help Required Diagnosing ASR Backup Problem

I am getting the following messages in "dsmsched.log" when doing a system state 
backup...


Backing up object 'COM+ REGDB Writer' component 'COM+ REGDB' using shadow copy.
Backing up object 'Registry Writer' component 'Registry' using shadow copy.
Backing up object 'System Writer' component 'System Files' using shadow copy.
Backing up object 'Event Log Writer' component 'Event Logs' using shadow copy.
Backing up object 'IIS Metabase Writer' component 'IISMETABASE' using shadow 
copy.
Backing up object 'WMI Writer' component 'Windows Managment Instrumentation' 
using shadow copy.
ANS4085I Assigned '3356' objects from previous systemstate backup to the new 
systemstate backup.
Backup of object 'SystemState' component 'System State' finished successfully.
ANS1228E Sending of object 'C:' failed
ANS1468E Backing up Automated System Recovery (ASR) files failed.  No files 
will be backed up.
Successful incremental backup of 'MYSERVER\SystemState\NULL\System 
State\SystemState'


...The "dsmerror.log" simply shows...


ANS1468E Backing up Automated System Recovery (ASR) files failed.  No files 
will be backed up.


...There are no other error messages in either log.

Is there a way to get more detailed information concerning this problem?

Many Thanks,
   =Adrian=
DISCLAIMER

This message is confidential and intended solely for the use of the
individual or entity it is addressed to. If you have received it in
error, please contact the sender and delete the e-mail. Please note 
that we may monitor and check emails to safeguard the Council network
from viruses, hoax messages or other abuse of the Council's systems.
To see the full version of this disclaimer please visit the following 
address: http://www.lewisham.gov.uk/AboutThisSite/EmailDisclaimer.htm

For advice and assistance about online security and protection from
internet threats visit the "Get Safe Online" website at
http://www.getsafeonline.org

Re: Help Required Diagnosing ASR Backup Problem

[Andrew Raibeck]

This looks like Windows 2003 running a version 6.2 backup-archive client.

For starters, check whether the pre-requisite hotfixes, as described in the
TSM client requirements document, have been installed. You can find this
document by going to the URL in my sig. In the "Featured links" section,
click on "Client requirements"; then click on the link for the Microsoft
Windows client.

For 6.2 clients on Windows, I recommend client level 6.2.3.1 or higher.

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_Storage_Manager

"ADSM: Dist Stor Manager"  wrote on 2011-09-09
08:12:06:

> From: "Davis, Adrian" 
> To: ADSM-L@vm.marist.edu
> Date: 2011-09-09 08:15
> Subject: Help Required Diagnosing ASR Backup Problem
> Sent by: "ADSM: Dist Stor Manager" 
>
> I am getting the following messages in "dsmsched.log" when doing a
> system state backup...
>
>
> Backing up object 'COM+ REGDB Writer' component 'COM+ REGDB' using
> shadow copy.
> Backing up object 'Registry Writer' component 'Registry' using shadow
copy.
> Backing up object 'System Writer' component 'System Files' using shadow
copy.
> Backing up object 'Event Log Writer' component 'Event Logs' using shadow
copy.
> Backing up object 'IIS Metabase Writer' component 'IISMETABASE'
> using shadow copy.
> Backing up object 'WMI Writer' component 'Windows Managment
> Instrumentation' using shadow copy.
> ANS4085I Assigned '3356' objects from previous systemstate backup to
> the new systemstate backup.
> Backup of object 'SystemState' component 'System State' finished
successfully.
> ANS1228E Sending of object 'C:' failed
> ANS1468E Backing up Automated System Recovery (ASR) files failed.
> No files will be backed up.
> Successful incremental backup of 'MYSERVER\SystemState\NULL\System
> State\SystemState'
>
>
> ...The "dsmerror.log" simply shows...
>
>
> ANS1468E Backing up Automated System Recovery (ASR) files failed.
> No files will be backed up.
>
>
> ...There are no other error messages in either log.
>
> Is there a way to get more detailed information concerning this problem?
>
> Many Thanks,
>=Adrian=
> DISCLAIMER
>
> This message is confidential and intended solely for the use of the
> individual or entity it is addressed to. If you have received it in
> error, please contact the sender and delete the e-mail. Please note
> that we may monitor and check emails to safeguard the Council network
> from viruses, hoax messages or other abuse of the Council’s systems.
> To see the full version of this disclaimer please visit the following
> address: http://www.lewisham.gov.uk/AboutThisSite/EmailDisclaimer.htm
>
> For advice and assistance about online security and protection from
> internet threats visit the "Get Safe Online" website at
> http://www.getsafeonline.org
>

Re: Ang: Re: Help tracking down spurious "Failed 12"

[Andrew Raibeck]

An in-use file should not cause an RC 12. Either you are running an old
client level with some defect that issues the wrong return code (for
example, see go to the URL in my sig and search for IC35763); or there is
some additional error being thrown that causes the RC to be set to 12.
Examine your dsmerror.log and dsmsched.log files very carefully for any
other ANSE or ANSS messages that might trigger the RC 12. Also, see
my other recent posts on this topic.

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_Storage_Manager

"ADSM: Dist Stor Manager"  wrote on 2011-08-25
09:26:24:

> From: Jimou 
> To: ADSM-L@vm.marist.edu
> Date: 2011-08-26 12:15
> Subject: Ang: Re: Help tracking down spurious "Failed 12"
> Sent by: "ADSM: Dist Stor Manager" 
>
> Hi
> I wonder why we can have a RC =12 for a skipped file in use,
> cause there http://www.dsi.upmc.fr/dsi/doc/stockage/clients-tsm/
> tsmwin/ans60012.htm
> i see that it should be RC=4
>
> But i also have a RC=12 and the only message i got is "in used file".
>
> Someone could explain to me why it is not a RC=4 ??
> Ty in advance.
>
> +--
> |This was sent by jm.fa...@gmail.com via Backup Central.
> |Forward SPAM to ab...@backupcentral.com.
> +--

Ang: Re: Help tracking down spurious "Failed 12"

[Jimou]

Hi
I wonder why we can have a RC =12 for a skipped file in use,
cause there 
http://www.dsi.upmc.fr/dsi/doc/stockage/clients-tsm/tsmwin/ans60012.htm
i see that it should be RC=4

But i also have a RC=12 and the only message i got is "in used file".

Someone could explain to me why it is not a RC=4 ??
Ty in advance.

+--
|This was sent by jm.fa...@gmail.com via Backup Central.
|Forward SPAM to ab...@backupcentral.com.
+--

Re: Help tracking down spurious "Failed 12" errors

[Andrew Raibeck]

Does the TSM client dsmsched.log indicate that the backups actually ran (or
attempted to run)? If not, check the TSM server activity log for the
duration of the backup window for messages related to this node and
scheduled event.

If the dsmsched.log error shows that the backup ran, check it as well as
the dsmerror.log again. I never say "never", but I am very hard pressed to
think that the RC 12's are begin generated with no error whatsoever being
identified in the dsmerror.log file, if not dsmsched.log. Especially check
the ending statistics for the backup where it shows whether the backup
completed successfully. If it says it completed successfully, then check
your system for another scheduler, in case there are multiple schedulers
and a different scheduler is having the problem.

What is the scheduled action? Is it INCREMENTAL? Or something else? For
example, if the scheduled action is COMMAND and it launches some script to
perform the backup, then note that if the script does not exit with return
code 0, the event will be treated as failed and the return code shown by
QUERY EVENT will be that from the script (which would be a 12 in this
case).

If you use a PRESCHEDULECMD option as well, and the PRESCHEDULECMD
operation does not end with return code 0, then this will also cause the
backup to fail; in this case, though, the scheduled operation will not run.

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_Storage_Manager

"ADSM: Dist Stor Manager"  wrote on 2011-08-17
04:40:50:

> From: "Davis, Adrian" 
> To: ADSM-L@vm.marist.edu
> Date: 2011-08-17 04:44
> Subject: Help tracking down spurious "Failed 12" errors
> Sent by: "ADSM: Dist Stor Manager" 
>
> When using "query event" to check my scheduled backups, I seem to be
> getting "Failed 12" errors for a couple of  backups which appear to
> have been successful (This occurs every day for the same servers).
>
> I've checked the client schedule and error logs - but there is no
> record of an error and all messages are what I would expect to see
> for a successful backup.
>
> Any ideas where else I should look?
>
> Many Thanks,
>=Adrian=
>
> DISCLAIMER
>
> This message is confidential and intended solely for the use of the
> individual or entity it is addressed to. If you have received it in
> error, please contact the sender and delete the e-mail. Please note
> that we may monitor and check emails to safeguard the Council network
> from viruses, hoax messages or other abuse of the Council’s systems.
> To see the full version of this disclaimer please visit the following
> address: http://www.lewisham.gov.uk/AboutThisSite/EmailDisclaimer.htm
>
> For advice and assistance about online security and protection from
> internet threats visit the "Get Safe Online" website at
> http://www.getsafeonline.org
>

Re: Help tracking down spurious "Failed 12" errors

[Lee, Gary D.]

Do a q act s=clientname for the backup times in question.
You may see something there.

Also, check the windows event log if the clients are windows.

 


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

 
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Davis, 
Adrian
Sent: Wednesday, August 17, 2011 4:41 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help tracking down spurious "Failed 12" errors

When using "query event" to check my scheduled backups, I seem to be getting 
"Failed 12" errors for a couple of  backups which appear to have been 
successful (This occurs every day for the same servers).

I've checked the client schedule and error logs - but there is no record of an 
error and all messages are what I would expect to see for a successful backup.

Any ideas where else I should look?

Many Thanks,
   =Adrian=

DISCLAIMER

This message is confidential and intended solely for the use of the
individual or entity it is addressed to. If you have received it in
error, please contact the sender and delete the e-mail. Please note 
that we may monitor and check emails to safeguard the Council network
from viruses, hoax messages or other abuse of the Council's systems.
To see the full version of this disclaimer please visit the following 
address: http://www.lewisham.gov.uk/AboutThisSite/EmailDisclaimer.htm

For advice and assistance about online security and protection from
internet threats visit the "Get Safe Online" website at
http://www.getsafeonline.org

Re: Help with tsm script

[Prather, Wanda]

This works:

select distinct stgpool_name as "Pool", count(volume_name) as "No. 
Volumes",  cast( sum(est_capacity_mb / 1024 * pct_utilized/100) as 
decimal(9,3))as "GB Reclaimable"  FROM   volumes   WHERE  
pct_reclaim
> $1 GROUP BY stgpool_name

I don't know why.

May be a bug:
https://www-304.ibm.com/support/docview.wss?uid=swg1IC61919



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, 
Gary D.
Sent: Tuesday, June 07, 2011 10:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help with tsm script

I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable space for 
the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as "Pool", - 
count(volume_name) as "No. Volumes", - 
cast(sum(cast((est_capacity_mb / 1024 *  - 
(pct_utilized / 100)) - 
as decimal(9,3))) as decimal(9,3)) - 
as "GB Reclaimable" - 
 FROM   volumes - 
 WHERE  pct_reclaim>$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives the 
exception.
Thanks for any help you can give.


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

 

Re: Help with tsm script

[Schneider, Jim]

I have a script that lists reclaimable space by volume for a given
storage pool.  I've added line numbers so I can see how many tapes would
be reclaimed at a given percentage.  It runs on Unix from a command
prompt.

===
#!/usr/bin/ksh
#
# This script checks reclaimable space in a tape storage pool
# The list is displayed with line numbers and is sorted by
# reclaimable space in descending order.


# Check that a parameter is passed
if [[ $# != 1 ]]
then
   echo Usage: cr \
   exit 4
fi

dsmadmc -id= -pass= -displ=list "q vol stg=$1 f=d" |
grep Reclaimable | sort -n -r -k 4 > $1.usage
cat -n $1.usage | more
rm $1.usage
===
Sample output:
ch2uptsm1 $ ./cr ch2win_offsite
 1  Pct. Reclaimable Space: 99.3
 2  Pct. Reclaimable Space: 98.7
 3  Pct. Reclaimable Space: 98.1
 4  Pct. Reclaimable Space: 97.9
 5  Pct. Reclaimable Space: 97.5
 6  Pct. Reclaimable Space: 97.4
 7  Pct. Reclaimable Space: 96.8
 8  Pct. Reclaimable Space: 93.1
 9  Pct. Reclaimable Space: 88.9
10  Pct. Reclaimable Space: 87.8
11  Pct. Reclaimable Space: 86.9
12  Pct. Reclaimable Space: 86.3
13  Pct. Reclaimable Space: 86.0
14  Pct. Reclaimable Space: 84.6
15  Pct. Reclaimable Space: 83.9
16  Pct. Reclaimable Space: 80.9
17  Pct. Reclaimable Space: 79.0
18  Pct. Reclaimable Space: 77.9
19  Pct. Reclaimable Space: 77.1
20  Pct. Reclaimable Space: 76.0

Hope this helps,
Jim Schneider

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of
Lee, Gary D.
Sent: Tuesday, June 07, 2011 9:24 AM
To: ADSM-L@vm.marist.edu
Subject: [ADSM-L] Help with tsm script

I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable
space for the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as "Pool", - 
count(volume_name) as "No. Volumes", - 
cast(sum(cast((est_capacity_mb / 1024 *  - 
(pct_utilized / 100)) - 
as decimal(9,3))) as decimal(9,3)) - 
as "GB Reclaimable" - 
 FROM   volumes - 
 WHERE  pct_reclaim>$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives
the exception.
Thanks for any help you can give.


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

 

Re: Help with tsm script

[Vandeventer, Harold [BS]]

Do you have the document "Changes to the SELECT command" from 
http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/index.jsp?topic=/com.ibm.itsm.srv.upgrd.doc/r_srv_upgrd_cmd_select.html?

The last section is Data types for arithmetic operations.  Compare your 
"cast(sum(cast((est_capacity_mb / 1024 * (pct_utilized / 100))" string to last 
example in the article.

The example has two "as decimal" strings; you might need an "as decimal" spec 
on the "pct_utilized /100"?


Harold Vandeventer
Systems Programmer
State of Kansas - DISC
harold.vandeven...@da.ks.gov
(785) 296-0631

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, 
Gary D.
Sent: Tuesday, June 07, 2011 9:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help with tsm script

I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable space for 
the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as "Pool", - 
count(volume_name) as "No. Volumes", - 
cast(sum(cast((est_capacity_mb / 1024 *  - 
(pct_utilized / 100)) - 
as decimal(9,3))) as decimal(9,3)) - 
as "GB Reclaimable" - 
 FROM   volumes - 
 WHERE  pct_reclaim>$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives the 
exception.
Thanks for any help you can give.


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

 

Re: Help with library definition and path for a scsi library: ANR8957E

[BEYERS Kurt]

Joni,

You're welcome. The quick response is just a coincidence, but it is the nice 
feature of the ADSM-L mailing list that many people are following it. And I 
recognized your error message directly as it is still  fresh in my memory. I 
had to convince TSM support myself it was a bug after finding the workaround ;-)

regards,
Kurt


Van: ADSM: Dist Stor Manager [ADSM-L@VM.MARIST.EDU] namens Moyer, Joni M 
[joni.mo...@highmark.com]
Verzonden: maandag 31 januari 2011 20:11
Aan: ADSM-L@VM.MARIST.EDU
Onderwerp: Re: [ADSM-L] Help with library definition and path for a scsi 
library: ANR8957E

Thanks Kurt!

That worked as soon as I removed the serial number.  I appreciate the quick 
response!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS 
Kurt
Sent: Monday, January 31, 2011 1:56 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help with library definition and path for a scsi library: ANR8957E

Hi Joni,

I was struggling with the same error message after upgrading our Quantum i2k 
tape libraries to i6k and opened a PMR at IBM. After some investigation it 
turned out to be a bug, the APAR IC73776 is opened for it but not yet solved.

The easy workaround is just to NOT specify the serial number in the 'define 
library' command, the serial number will be picked automatically by TSM. You 
can verify this afterwards with the command 'show library LIDZR8V'.

best regards,
Kurt

Van: ADSM: Dist Stor Manager [ADSM-L@VM.MARIST.EDU] namens Moyer, Joni M 
[joni.mo...@highmark.com]
Verzonden: maandag 31 januari 2011 18:33
Aan: ADSM-L@VM.MARIST.EDU
Onderwerp: [ADSM-L] Help with library definition and path for a scsi library: 
ANR8957E

Hi Everyone,

I'm trying to define a path from the library changer of a Quantum i6000 scsi 
library to my AIX 5.5.5.0 TSM server.  I defined a library called qi6000_test 
with the following definition: define library qi6000_test libtype=scsi 
serial=273100111_LL1

Date/Time Message
  --

Date/Time Message

  --

01/31/11 12:29:48 ANR2017I Administrator LIDZR8V issued command: DEFINE

   LIBRARY qi6000_test serial=273100111_LL1 libtype=scsi

   (SESSION: 4567)

01/31/11 12:30:19 ANR2017I Administrator LIDZR8V issued command: DEFINE PATH

   tsmprod3 qi6000_test srctype=server desttype=library

   device=/dev/lb0  (SESSION: 4568)

01/31/11 12:30:20 ANR8957E DEFINE PATH: The serial number reported by the

   library did not match the serial number in the library

   definition. (SESSION: 4568)

Has anyone experienced this issue before?  Any help is appreciated as this is a 
brand new set up.  Thanks!!!

Information from the TSM library partition of this configuration:

Library: TSM  | 273100111_LL1 | Online| 
606A.GS00301


This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.

Re: Help with library definition and path for a scsi library: ANR8957E

[Moyer, Joni M]

Thanks Kurt!

That worked as soon as I removed the serial number.  I appreciate the quick 
response!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS 
Kurt
Sent: Monday, January 31, 2011 1:56 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help with library definition and path for a scsi library: ANR8957E

Hi Joni,

I was struggling with the same error message after upgrading our Quantum i2k 
tape libraries to i6k and opened a PMR at IBM. After some investigation it 
turned out to be a bug, the APAR IC73776 is opened for it but not yet solved.

The easy workaround is just to NOT specify the serial number in the 'define 
library' command, the serial number will be picked automatically by TSM. You 
can verify this afterwards with the command 'show library LIDZR8V'.

best regards,
Kurt

Van: ADSM: Dist Stor Manager [ADSM-L@VM.MARIST.EDU] namens Moyer, Joni M 
[joni.mo...@highmark.com]
Verzonden: maandag 31 januari 2011 18:33
Aan: ADSM-L@VM.MARIST.EDU
Onderwerp: [ADSM-L] Help with library definition and path for a scsi library: 
ANR8957E

Hi Everyone,

I'm trying to define a path from the library changer of a Quantum i6000 scsi 
library to my AIX 5.5.5.0 TSM server.  I defined a library called qi6000_test 
with the following definition: define library qi6000_test libtype=scsi 
serial=273100111_LL1

Date/Time Message
  --

Date/Time Message

  --

01/31/11 12:29:48 ANR2017I Administrator LIDZR8V issued command: DEFINE

   LIBRARY qi6000_test serial=273100111_LL1 libtype=scsi

   (SESSION: 4567)

01/31/11 12:30:19 ANR2017I Administrator LIDZR8V issued command: DEFINE PATH

   tsmprod3 qi6000_test srctype=server desttype=library

   device=/dev/lb0  (SESSION: 4568)

01/31/11 12:30:20 ANR8957E DEFINE PATH: The serial number reported by the

   library did not match the serial number in the library

   definition. (SESSION: 4568)

Has anyone experienced this issue before?  Any help is appreciated as this is a 
brand new set up.  Thanks!!!

Information from the TSM library partition of this configuration:

Library: TSM  | 273100111_LL1 | Online| 
606A.GS00301


This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.

Re: Help with library definition and path for a scsi library: ANR8957E

[BEYERS Kurt]

Hi Joni,

I was struggling with the same error message after upgrading our Quantum i2k 
tape libraries to i6k and opened a PMR at IBM. After some investigation it 
turned out to be a bug, the APAR IC73776 is opened for it but not yet solved.

The easy workaround is just to NOT specify the serial number in the 'define 
library' command, the serial number will be picked automatically by TSM. You 
can verify this afterwards with the command 'show library LIDZR8V'.

best regards,
Kurt

Van: ADSM: Dist Stor Manager [ADSM-L@VM.MARIST.EDU] namens Moyer, Joni M 
[joni.mo...@highmark.com]
Verzonden: maandag 31 januari 2011 18:33
Aan: ADSM-L@VM.MARIST.EDU
Onderwerp: [ADSM-L] Help with library definition and path for a scsi library: 
ANR8957E

Hi Everyone,

I'm trying to define a path from the library changer of a Quantum i6000 scsi 
library to my AIX 5.5.5.0 TSM server.  I defined a library called qi6000_test 
with the following definition: define library qi6000_test libtype=scsi 
serial=273100111_LL1

Date/Time Message
  --

Date/Time Message

  --

01/31/11 12:29:48 ANR2017I Administrator LIDZR8V issued command: DEFINE

   LIBRARY qi6000_test serial=273100111_LL1 libtype=scsi

   (SESSION: 4567)

01/31/11 12:30:19 ANR2017I Administrator LIDZR8V issued command: DEFINE PATH

   tsmprod3 qi6000_test srctype=server desttype=library

   device=/dev/lb0  (SESSION: 4568)

01/31/11 12:30:20 ANR8957E DEFINE PATH: The serial number reported by the

   library did not match the serial number in the library

   definition. (SESSION: 4568)

Has anyone experienced this issue before?  Any help is appreciated as this is a 
brand new set up.  Thanks!!!

Information from the TSM library partition of this configuration:

Library: TSM  | 273100111_LL1 | Online| 
606A.GS00301


This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.

Re: Help with library definition and path for a scsi library: ANR8957E

[Efim]

Hello

Quantum i6000 support ELEMENT=AUTODETECT during define library and
paths so delete all library objects and define library and path using
this command:

define library qi6000_test libtype=scsi
DEFINE PATH tsmprod3 qi6000_test srctype=server desttype=library device=/dev/lb0

sometimes after connect new library TSM can't work with it correctly
without reboot. (cfgmgr will not help)

Efim


2011/1/31 Moyer, Joni M :
> Hi Everyone,
>
> I'm trying to define a path from the library changer of a Quantum i6000 scsi 
> library to my AIX 5.5.5.0 TSM server.  I defined a library called qi6000_test 
> with the following definition: define library qi6000_test libtype=scsi 
> serial=273100111_LL1
>
> Date/Time             Message
>   
> --
>
> Date/Time             Message
>
>   
> --
>
> 01/31/11 12:29:48     ANR2017I Administrator LIDZR8V issued command: DEFINE
>
>                       LIBRARY qi6000_test serial=273100111_LL1 libtype=scsi
>
>                       (SESSION: 4567)
>
> 01/31/11 12:30:19     ANR2017I Administrator LIDZR8V issued command: DEFINE 
> PATH
>
>                       tsmprod3 qi6000_test srctype=server desttype=library
>
>                       device=/dev/lb0  (SESSION: 4568)
>
> 01/31/11 12:30:20     ANR8957E DEFINE PATH: The serial number reported by the
>
>                       library did not match the serial number in the library
>
>                       definition. (SESSION: 4568)
>
> Has anyone experienced this issue before?  Any help is appreciated as this is 
> a brand new set up.  Thanks!!!
>
> Information from the TSM library partition of this configuration:
>
> Library: TSM          | 273100111_LL1         | Online                | 
> 606A.GS00301
>
> 
> This e-mail and any attachments to it are confidential and are intended 
> solely for use of the individual or entity to whom they are addressed. If you 
> have received this e-mail in error, please notify the sender immediately and 
> then delete it. If you are not the intended recipient, you must not keep, 
> use, disclose, copy or distribute this e-mail without the author's prior 
> permission. The views expressed in this e-mail message do not necessarily 
> represent the views of Highmark Inc., its subsidiaries, or affiliates.
>



-- 
Efim

Re: Help with dsmcutil

[Lee, Gary D.]

V6 gui is java based, and doesn't work well with screen reading software.
Working on that one as well.

Anyway, problem solved.  "erorlogret" instead of "errorlogret"

Listen IBM 

Could use better more helpful error messages.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of 
Nicholas Rodolfich
Sent: Thursday, February 18, 2010 4:13 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help with dsmcutil

What do you see when your run

dsmcutil q  /name:""

dsmcutil q  /name:""

I don't understand why the UNC path is in the options file location! All of 
mine just use C:  instead of \\EMAILTEST02\c$\progr.

The TSM API error usually indicates that the options file cannot be found.

It would be easier to use the setup wizard in the TSM client for base level CAD 
and scheduler configuration. Why kill yourself with dsmcutil in DOS if you are 
not configuring a cluster or something? You can also remove the buggered up 
ones with it.



"ADSM: Dist Stor Manager"  wrote on 02/18/2010
11:33:57 AM:

> [image removed]
>
> [ADSM-L] Help with dsmcutil
>
> Lee, Gary D.
>
> to:
>
> ADSM-L
>
> 02/18/2010 11:33 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" 
>
> Please respond to "ADSM: Dist Stor Manager"
>
> tsm client 6.3
> os windows 2003
>
> Trying to update and/or install services remotely for ba client and
> exchange backup.
>
> Node name and password have been double checked.
>
> Any ideas?
> Data below:
>
>
> --- command executed --
>
> "c:\Program files\TIVOLI\TSM\baclient\dsmcutil" update CAD / name:"TSM
> Client Acceptor" /optfile:"c:\Program Files\Tivoli\TSM
> \baclient\dsm.opt" /machine:emailtest02 /clientdir:"c:\Program Files
> \Tivoli\TSM\baclient" /cadschedname:"TSM Client Scheduler" /
> node:emailtest02 /password:emailtest02 /autostart:yes >>exchinst.log
>
>   output from dsmcutil 
>
> TSM Windows NT Client Service Configuration Utility Command Line
> Interface - Version 6, Release 1, Level 3.0
> (C) Copyright IBM Corporation, 1990, 2009, All Rights Reserved.
> Last Updated Nov 20 2009
> TSM Api Version 6.1.3
>
> Command: Update TSM Client Service Parameters
> Machine: EMAILTEST02
>
>
> Connecting to registry on remote machine EMAILTEST02 ...
>
> Opening Registry Keys ...
>
> Located service 'TSM Client Acceptor' .
>
> Updated registry value 'ImagePath' .
> Updated registry value 'EventMessageFile' .
> Updated registry value 'TypesSupported' .
> Updated registry value 'OptionsFile' .
> Updated registry value 'Start' .
> Updated registry value 'ClientNodeName' .
> Authenticating TSM password for node EMAILTEST02 ...
>
> Connecting to TSM Server via client options file '\\EMAILTEST02\c$
> \Program Files\Tivoli\TSM\baclient\dsm.opt' ...
>
>
>
> Error 6 establishing TSM API session: The client options file is
> corrupt or invalid.
>
>
>
> Error 6 authenticating password: The client options file is corrupt or
> invalid.
>
> Updated registry value 'CadSchedName' .
>
>
>
>  dsm.opt starts here 
>
> NODENAME EMAILTEST02
> TCPSERVERADDRESS spock.bsu.edu
> SNAPSHOTPROVIDERFS VSS
> schedmode prompted
> passwordaccess generate
> schedlogret 15
> erorlogret 15
>
> EXCLUDE.BACKUP "*:\microsoft uam volume\...\*"
> EXCLUDE.BACKUP "*:\microsoft uam volume\...\*.*"
> EXCLUDE.BACKUP "*:\...\EA DATA. SF"
> EXCLUDE.BACKUP "*:\IBMBIO.COM"
> EXCLUDE.BACKUP "*:\IBMDOS.COM"
> EXCLUDE.BACKUP "*:\IO.SYS"
> EXCLUDE.BACKUP "*:\...\system32\config\...\*"
> EXCLUDE.BACKUP "*:\...\system32\Perflib*.dat"
> EXCLUDE.BACKUP "*:\...\system32\dhcp\...\*"
> INCLUDE.BACKUP "*:\...\system32\dhcp\backup\...\*"
> EXCLUDE.BACKUP "*:\...\system32\dns\...\*"
> INCLUDE.BACKUP "*:\...\system32\dns\backup\...\*"
>
> EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*"
> EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*.*"
> EXCLUDE.ARCHIVE "*:\...\EA DATA. SF"
> EXCLUDE.ARCHIVE "*:\IBMBIO.COM"
> EXCLUDE.ARCHIVE "*:\IBMDOS.COM"
> EXCLUDE.ARCHIVE "*:\IO.SYS"
> EXCLUDE.ARCHIVE "*:\...\system32\config\...\*"
> EXCLUDE.ARCHIVE "*:\...\system32\Perflib*.dat"
> EXCLUDE.ARCHIVE "*:\...\system32\dhcp\...\*"
> INCLUDE.ARCHIVE "*:\...\system32\dhcp\backup\...\*"
> EXCLUDE.ARCHIVE "*:\...\system32\dns\...\*"
> INCLUDE.ARCHIVE "*:\...\system32\dns\backup\...\*"
>
> EXCLUDE.DIR "*:\System Volume Information"
> EXCLUDE.DIR "*:\...\Temporary Internet Files"
> EXCLUDE.DIR "*:\Recycled"
> EXCLUDE.DIR "*:\Recycler"
> EXCLUDE.DIR "*:\$Recycle.Bin"
> EXCLUDE.DIR "C:\Program Files\Microsoft\Exchange Server\Mailbox
> \EMAILTEST02-1"
> EXCLUDE.DIR "C:\Program Files\Microsoft\Exchange Server\Mailbox \First
> Storage Group"
>
>
>
>  end of options file 
>
>
> Gary Lee
> Senior System Programmer
> Ball State University
> phone: 765-285-1310
>
>


__ Information from ESET NOD32 Antivirus, version of virus signature 
database 4878 (20100218) __

The message was checked by ESET NOD32 Antivi

Re: Help with dsmcutil

[Nicholas Rodolfich]

What do you see when your run

dsmcutil q  /name:""

dsmcutil q  /name:""

I don't understand why the UNC path is in the options file location! All of
mine just use C:  instead of \\EMAILTEST02\c$\progr.

The TSM API error usually indicates that the options file cannot be found.

It would be easier to use the setup wizard in the TSM client for base level
CAD and scheduler configuration. Why kill yourself with dsmcutil in DOS if
you are not configuring a cluster or something? You can also remove the
buggered up ones with it.



"ADSM: Dist Stor Manager"  wrote on 02/18/2010
11:33:57 AM:

> [image removed]
>
> [ADSM-L] Help with dsmcutil
>
> Lee, Gary D.
>
> to:
>
> ADSM-L
>
> 02/18/2010 11:33 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" 
>
> Please respond to "ADSM: Dist Stor Manager"
>
> tsm client 6.3
> os windows 2003
>
> Trying to update and/or install services remotely for ba client and
> exchange backup.
>
> Node name and password have been double checked.
>
> Any ideas?
> Data below:
>
>
> --- command executed --
>
> "c:\Program files\TIVOLI\TSM\baclient\dsmcutil" update CAD /
> name:"TSM Client Acceptor" /optfile:"c:\Program Files\Tivoli\TSM
> \baclient\dsm.opt" /machine:emailtest02 /clientdir:"c:\Program Files
> \Tivoli\TSM\baclient" /cadschedname:"TSM Client Scheduler" /
> node:emailtest02 /password:emailtest02 /autostart:yes >>exchinst.log
>
>   output from dsmcutil 
>
> TSM Windows NT Client Service Configuration Utility
> Command Line Interface - Version 6, Release 1, Level 3.0
> (C) Copyright IBM Corporation, 1990, 2009, All Rights Reserved.
> Last Updated Nov 20 2009
> TSM Api Version 6.1.3
>
> Command: Update TSM Client Service Parameters
> Machine: EMAILTEST02
>
>
> Connecting to registry on remote machine EMAILTEST02 ...
>
> Opening Registry Keys ...
>
> Located service 'TSM Client Acceptor' .
>
> Updated registry value 'ImagePath' .
> Updated registry value 'EventMessageFile' .
> Updated registry value 'TypesSupported' .
> Updated registry value 'OptionsFile' .
> Updated registry value 'Start' .
> Updated registry value 'ClientNodeName' .
> Authenticating TSM password for node EMAILTEST02 ...
>
> Connecting to TSM Server via client options file '\\EMAILTEST02\c$
> \Program Files\Tivoli\TSM\baclient\dsm.opt' ...
>
>
>
> Error 6 establishing TSM API session: The client options file is
> corrupt or invalid.
>
>
>
> Error 6 authenticating password: The client options file is corrupt
> or invalid.
>
> Updated registry value 'CadSchedName' .
>
>
>
>  dsm.opt starts here 
>
> NODENAME EMAILTEST02
> TCPSERVERADDRESS spock.bsu.edu
> SNAPSHOTPROVIDERFS VSS
> schedmode prompted
> passwordaccess generate
> schedlogret 15
> erorlogret 15
>
> EXCLUDE.BACKUP "*:\microsoft uam volume\...\*"
> EXCLUDE.BACKUP "*:\microsoft uam volume\...\*.*"
> EXCLUDE.BACKUP "*:\...\EA DATA. SF"
> EXCLUDE.BACKUP "*:\IBMBIO.COM"
> EXCLUDE.BACKUP "*:\IBMDOS.COM"
> EXCLUDE.BACKUP "*:\IO.SYS"
> EXCLUDE.BACKUP "*:\...\system32\config\...\*"
> EXCLUDE.BACKUP "*:\...\system32\Perflib*.dat"
> EXCLUDE.BACKUP "*:\...\system32\dhcp\...\*"
> INCLUDE.BACKUP "*:\...\system32\dhcp\backup\...\*"
> EXCLUDE.BACKUP "*:\...\system32\dns\...\*"
> INCLUDE.BACKUP "*:\...\system32\dns\backup\...\*"
>
> EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*"
> EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*.*"
> EXCLUDE.ARCHIVE "*:\...\EA DATA. SF"
> EXCLUDE.ARCHIVE "*:\IBMBIO.COM"
> EXCLUDE.ARCHIVE "*:\IBMDOS.COM"
> EXCLUDE.ARCHIVE "*:\IO.SYS"
> EXCLUDE.ARCHIVE "*:\...\system32\config\...\*"
> EXCLUDE.ARCHIVE "*:\...\system32\Perflib*.dat"
> EXCLUDE.ARCHIVE "*:\...\system32\dhcp\...\*"
> INCLUDE.ARCHIVE "*:\...\system32\dhcp\backup\...\*"
> EXCLUDE.ARCHIVE "*:\...\system32\dns\...\*"
> INCLUDE.ARCHIVE "*:\...\system32\dns\backup\...\*"
>
> EXCLUDE.DIR "*:\System Volume Information"
> EXCLUDE.DIR "*:\...\Temporary Internet Files"
> EXCLUDE.DIR "*:\Recycled"
> EXCLUDE.DIR "*:\Recycler"
> EXCLUDE.DIR "*:\$Recycle.Bin"
> EXCLUDE.DIR "C:\Program Files\Microsoft\Exchange Server\Mailbox
> \EMAILTEST02-1"
> EXCLUDE.DIR "C:\Program Files\Microsoft\Exchange Server\Mailbox
> \First Storage Group"
>
>
>
>  end of options file 
>
>
> Gary Lee
> Senior System Programmer
> Ball State University
> phone: 765-285-1310
>
>

Re: Help with dsmcutil

[Sami Ahomaa]

Hi,


Shouldn't this:
erorlogret 15

be like this:
errorlogret 15 ?


Reg
Sami Ahomaa

2010/2/18 Lee, Gary D. :
> tsm client 6.3
> os windows 2003
>
> Trying to update and/or install services remotely for ba client and exchange 
> backup.
>
> Node name and password have been double checked.
>
> Any ideas?
> Data below:
>
>
> --- command executed --
>
> "c:\Program files\TIVOLI\TSM\baclient\dsmcutil" update CAD /name:"TSM Client 
> Acceptor" /optfile:"c:\Program Files\Tivoli\TSM\baclient\dsm.opt" 
> /machine:emailtest02 /clientdir:"c:\Program Files\Tivoli\TSM\baclient" 
> /cadschedname:"TSM Client Scheduler" /node:emailtest02 /password:emailtest02 
> /autostart:yes >>exchinst.log
>
>   output from dsmcutil 
>
> TSM Windows NT Client Service Configuration Utility
> Command Line Interface - Version 6, Release 1, Level 3.0
> (C) Copyright IBM Corporation, 1990, 2009, All Rights Reserved.
> Last Updated Nov 20 2009
> TSM Api Version 6.1.3
>
> Command: Update TSM Client Service Parameters
> Machine: EMAILTEST02
>
>
> Connecting to registry on remote machine EMAILTEST02 ...
>
> Opening Registry Keys ...
>
> Located service 'TSM Client Acceptor' .
>
> Updated registry value 'ImagePath' .
> Updated registry value 'EventMessageFile' .
> Updated registry value 'TypesSupported' .
> Updated registry value 'OptionsFile' .
> Updated registry value 'Start' .
> Updated registry value 'ClientNodeName' .
> Authenticating TSM password for node EMAILTEST02 ...
>
> Connecting to TSM Server via client options file '\\EMAILTEST02\c$\Program 
> Files\Tivoli\TSM\baclient\dsm.opt' ...
>
>
>
> Error 6 establishing TSM API session: The client options file is corrupt or 
> invalid.
>
>
>
> Error 6 authenticating password: The client options file is corrupt or 
> invalid.
>
> Updated registry value 'CadSchedName' .
>
>
>
>  dsm.opt starts here 
>
> NODENAME         EMAILTEST02
> TCPSERVERADDRESS spock.bsu.edu
> SNAPSHOTPROVIDERFS VSS
> schedmode prompted
> passwordaccess generate
> schedlogret 15
> erorlogret 15
>
> EXCLUDE.BACKUP "*:\microsoft uam volume\...\*"
> EXCLUDE.BACKUP "*:\microsoft uam volume\...\*.*"
> EXCLUDE.BACKUP "*:\...\EA DATA. SF"
> EXCLUDE.BACKUP "*:\IBMBIO.COM"
> EXCLUDE.BACKUP "*:\IBMDOS.COM"
> EXCLUDE.BACKUP "*:\IO.SYS"
> EXCLUDE.BACKUP "*:\...\system32\config\...\*"
> EXCLUDE.BACKUP "*:\...\system32\Perflib*.dat"
> EXCLUDE.BACKUP "*:\...\system32\dhcp\...\*"
> INCLUDE.BACKUP "*:\...\system32\dhcp\backup\...\*"
> EXCLUDE.BACKUP "*:\...\system32\dns\...\*"
> INCLUDE.BACKUP "*:\...\system32\dns\backup\...\*"
>
> EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*"
> EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*.*"
> EXCLUDE.ARCHIVE "*:\...\EA DATA. SF"
> EXCLUDE.ARCHIVE "*:\IBMBIO.COM"
> EXCLUDE.ARCHIVE "*:\IBMDOS.COM"
> EXCLUDE.ARCHIVE "*:\IO.SYS"
> EXCLUDE.ARCHIVE "*:\...\system32\config\...\*"
> EXCLUDE.ARCHIVE "*:\...\system32\Perflib*.dat"
> EXCLUDE.ARCHIVE "*:\...\system32\dhcp\...\*"
> INCLUDE.ARCHIVE "*:\...\system32\dhcp\backup\...\*"
> EXCLUDE.ARCHIVE "*:\...\system32\dns\...\*"
> INCLUDE.ARCHIVE "*:\...\system32\dns\backup\...\*"
>
> EXCLUDE.DIR "*:\System Volume Information"
> EXCLUDE.DIR "*:\...\Temporary Internet Files"
> EXCLUDE.DIR "*:\Recycled"
> EXCLUDE.DIR "*:\Recycler"
> EXCLUDE.DIR "*:\$Recycle.Bin"
> EXCLUDE.DIR "C:\Program Files\Microsoft\Exchange Server\Mailbox\EMAILTEST02-1"
> EXCLUDE.DIR "C:\Program Files\Microsoft\Exchange Server\Mailbox\First Storage 
> Group"
>
>
>
>  end of options file 
>
>
> Gary Lee
> Senior System Programmer
> Ball State University
> phone: 765-285-1310
>
>



-- 
When command line fails, try Google.

Re: help sql tsm 6.1.3.1 windows servers

[Hana Darzi]

Thank you. I tried and it works.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Dmitry
Sent: Sunday, February 14, 2010 4:57 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] help sql tsm 6.1.3.1 windows servers

Hana, This is correct request
select   a.node_name  from filespaces a, nodes b where 
b.node_name=a.node_name
-- 

Dmitry Dukhov
Siberia Software SL
http://www.s-iberia.com


On 14.02.2010 17:33, Hana Darzi wrote:
> Hello all,
>
> Why this query do not work in tsm 6.1.3.1 ?
>
> select   filespaces.node_name  from filespaces
>
> ANR0162W Supplemental database diagnostic information:  -1:42S22:-206
> ([IBM][CLI Driver][DB2/NT64] SQL0206N  "FILESPACES.NODE_NAME" is not valid in
> the context where it is used.  SQLSTATE=42703
> ).
> ANR2940E The command 'select filespaces.node_name from FILESPACEVIEW ' 
> contains
> an unknown SQL column name.
> ANS8001I Return code 3.
>
> I need it in order to select from 2 tables : select ……. From filespaces,nodes
>
> Thank you,
>   Hana
> _
>
> Hana Shparber (Darzi)
> Computation Center, Ben-Gurion University
> Email: ha...@bgu.ac.il
> Phone: 972-8-6461160, Mobile: 972-52-6839378
> _
>

Re: help sql tsm 6.1.3.1 windows servers

[Remco Post]

On 14 feb 2010, at 15:33, Hana Darzi wrote:

> Hello all,
> 
> Why this query do not work in tsm 6.1.3.1 ?
> 

Hana,

have you tried using:

select node_name from filespaces

as a work-around? As you see from the error, there is an underlaying view in 
DB2. It's not unlikely that you have found a bug in TSM, so please also report 
this one to IBM.


> select   filespaces.node_name  from filespaces
> 
> ANR0162W Supplemental database diagnostic information:  -1:42S22:-206
> ([IBM][CLI Driver][DB2/NT64] SQL0206N  "FILESPACES.NODE_NAME" is not valid in
> the context where it is used.  SQLSTATE=42703
> ).
> ANR2940E The command 'select filespaces.node_name from FILESPACEVIEW ' 
> contains
> an unknown SQL column name.
> ANS8001I Return code 3.
> 
> I need it in order to select from 2 tables : select ……. From filespaces,nodes
> 
> Thank you,
> Hana
> _
> 
> Hana Shparber (Darzi)
> Computation Center, Ben-Gurion University
> Email: ha...@bgu.ac.il
> Phone: 972-8-6461160, Mobile: 972-52-6839378
> _

-- 
Met vriendelijke groeten/Kind Regards,

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

Re: help sql tsm 6.1.3.1 windows servers

[Dmitry]

Hana, This is correct request
select   a.node_name  from filespaces a, nodes b where 
b.node_name=a.node_name

--

Dmitry Dukhov
Siberia Software SL
http://www.s-iberia.com


On 14.02.2010 17:33, Hana Darzi wrote:

Hello all,

Why this query do not work in tsm 6.1.3.1 ?

select   filespaces.node_name  from filespaces

ANR0162W Supplemental database diagnostic information:  -1:42S22:-206
([IBM][CLI Driver][DB2/NT64] SQL0206N  "FILESPACES.NODE_NAME" is not valid in
the context where it is used.  SQLSTATE=42703
).
ANR2940E The command 'select filespaces.node_name from FILESPACEVIEW ' contains
an unknown SQL column name.
ANS8001I Return code 3.

I need it in order to select from 2 tables : select ……. From filespaces,nodes

Thank you,
  Hana
_

Hana Shparber (Darzi)
Computation Center, Ben-Gurion University
Email: ha...@bgu.ac.il
Phone: 972-8-6461160, Mobile: 972-52-6839378
_
   

Re: Help resolving ans5268w

[Lee, Gary D.]

Thanks to Richard.  However, our windows guys just rebooted the suspect client, 
and I pushed out a backup.  All is now well. 


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

 
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of 
Richard Sims
Sent: Monday, January 04, 2010 8:29 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help resolving ans5268w

You would probably best pursue this with your Windows people, where they should 
do 'vssadmin list writers' as a starting point relative to whatever state was 
reported in the ANS5268W message.

   Richard Sims

Re: Help resolving ans5268w

[Richard Sims]

You would probably best pursue this with your Windows people, where they should 
do 'vssadmin list writers' as a starting point relative to whatever state was 
reported in the ANS5268W message.

   Richard Sims

Re: Help on TDP_R3 Oracle - AIX

[Steven Langdale]

Yudi

The max throughput of LTO3 is 80 MB/s and LTO4 is 120 - so you've lost 
throughput there.

It looks like (from my very rough calcs) that you were getting approx 
55MB/s average from your LTO3's and LESS than 67MB/s (that's if it 
finished at 10 hours which it isn't)

It looks like the host/backup process is not able to push the drives any 
faster, perhaps you should look here 1st for some perf increases.  Though 
it would be interesting to see the total backup time if you are able to 
let it finish.

The TS3100 is only a single drive lib isn't it  you may have an issue 
with that.  As an aside, how are you doing reclaims and offsite backups?

Did you or someone else architect this solution, if someone else, get them 
back to fix it...

Thanks

Steven Langdale
Global Information Services
EAME SAN/Storage Planning and Implementation
( Phone : +44 (0)1733 584175
( Mob: +44 (0)7876 216782
ü Conference: +44 (0)208 609 7400 Code: 331817
+ Email: steven.langd...@cat.com

 



Yudi Darmadi  
Sent by: "ADSM: Dist Stor Manager" 
27/08/2009 06:53
Please respond to
"ADSM: Dist Stor Manager" 


To
ADSM-L@VM.MARIST.EDU
cc

Subject
Re: [ADSM-L] Help on TDP_R3 Oracle - AIX




Caterpillar: Confidential Green Retain Until: 26/09/2009 



Hi all,

After checkin the anf file, i figure out that there's no error, it's just
slow backup problem..
Our environment has just change the library from 3573 library lto 3 with 2
tape drive, to TS3100 LTO4 with just 1 tape drive, and upgrade TSM version
from v5.3 to v5.5.
Before the change, the SAP backup using 2 LTO cartridge and it takes 6 
hours
(using LANFree backup)
And now the backup takes more than 10 hours i think (it start in 10PM, and
the backup never finished, because we cancel the backup in 8 AM - we don't
do backups in offiice hour, still using LANFree backup). Our DB size is
approx 2.3 TB.
Do you have any idea to increase the backup performance?


Best Regards,


Yudi Darmadi
PT Niagaprima Paramitra
Jl. KH Ahmad Dahlan No.25  Kebayoran Baru, Jakarta Selatan 12130
Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
http://www.niagaprima.com

- Original Message -
From: "Gary Bowers" 
To: 
Sent: Friday, August 21, 2009 9:59 PM
Subject: Re: [ADSM-L] Help on TDP_R3 Oracel - AIX


> The alter tablespace command is an Oracle command, not a TSM command.
> If you were getting error with the library manager (TSM), you would
> see problems with allocating a channel.  I would get with your DBA to
> do some investigation on this table.  The BRBACKUP command just issues
> Oracle commands under the covers.
>
> Gary
> Itrus Technologies
>
> On Aug 21, 2009, at 3:10 AM, Yudi Darmadi wrote:
>
>> Dear TSM'ers
>>
>> I have a TDP_R3 Oracle on AIX V5.5.0.0 - and  when
>> I think this is not TSM issue, but i just wanna know does anyone had
>> been
>> experince this case?
>>
>>
>> BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
>> BR0301E SQL error -600 at location db_file_switch-11
>> ORA-00600: internal error code, arguments: [3664], [3], [1], [4], [0],
>> [1954909839], [0], [1954909839]
>> BR0316E 'Alter tablespace PSAPWPR begin backup' failed
>> BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
>>
>>
>> Best Regards,
>>
>>
>> Yudi Darmadi
>> PT Niagaprima Paramitra
>> Jl. KH Ahmad Dahlan No.25  Kebayoran Baru, Jakarta Selatan 12130
>> Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
>> http://www.niagaprima.com

Re: Help on TDP_R3 Oracle - AIX

[Yudi Darmadi]

Hi all,

After checkin the anf file, i figure out that there's no error, it's just
slow backup problem..
Our environment has just change the library from 3573 library lto 3 with 2
tape drive, to TS3100 LTO4 with just 1 tape drive, and upgrade TSM version
from v5.3 to v5.5.
Before the change, the SAP backup using 2 LTO cartridge and it takes 6 hours
(using LANFree backup)
And now the backup takes more than 10 hours i think (it start in 10PM, and
the backup never finished, because we cancel the backup in 8 AM - we don't
do backups in offiice hour, still using LANFree backup). Our DB size is
approx 2.3 TB.
Do you have any idea to increase the backup performance?


Best Regards,


Yudi Darmadi
PT Niagaprima Paramitra
Jl. KH Ahmad Dahlan No.25  Kebayoran Baru, Jakarta Selatan 12130
Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
http://www.niagaprima.com

- Original Message -
From: "Gary Bowers" 
To: 
Sent: Friday, August 21, 2009 9:59 PM
Subject: Re: [ADSM-L] Help on TDP_R3 Oracel - AIX



The alter tablespace command is an Oracle command, not a TSM command.
If you were getting error with the library manager (TSM), you would
see problems with allocating a channel.  I would get with your DBA to
do some investigation on this table.  The BRBACKUP command just issues
Oracle commands under the covers.

Gary
Itrus Technologies

On Aug 21, 2009, at 3:10 AM, Yudi Darmadi wrote:


Dear TSM'ers

I have a TDP_R3 Oracle on AIX V5.5.0.0 - and  when
I think this is not TSM issue, but i just wanna know does anyone had
been
experince this case?


BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
BR0301E SQL error -600 at location db_file_switch-11
ORA-00600: internal error code, arguments: [3664], [3], [1], [4], [0],
[1954909839], [0], [1954909839]
BR0316E 'Alter tablespace PSAPWPR begin backup' failed
BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17


Best Regards,


Yudi Darmadi
PT Niagaprima Paramitra
Jl. KH Ahmad Dahlan No.25  Kebayoran Baru, Jakarta Selatan 12130
Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
http://www.niagaprima.com

Re: Help on TDP_R3 Oracel - AIX

[Larry Peifer]

   
   
   
   
   
 Subject:  
   
   
   
Ora-6  
00 
[3664  
]  
   
  Doc  
  ID:  
 457212.1  
Type:  
   PROBLEM 
   
Modif  
  ied  
 Date  
:  
 21-MAY-2008   
  Status:  
   PUBLISHED   
   
   
   
 In this Document  
   Symptoms
   Changes 
   Cause   
   Solution
   References  
   
   
   
   
   
 Applies to:   
 Oracle Server -   
 Enterprise Edition -  
 Version: 8.1.7.4 to 11.1  
 This problem can occur
 on any platform.  
 Oracle RDBMS Server   
 Symptoms  
   
   
 The BEGIN BACKUP  
 command generates 
 ORA-00600 [3664]  
   
   
 The alert log will show   
 similar to the following  
   
   
 ALTER TABLESPACE "SYSTEM  
 " BEGIN BACKUP
 Mon Sep  3 09:47:16 2007
   
 Errors in file /opt/orac
 le/app/oracle/admin/cspr  
 cpn1/udump/csprcpn1_ora_  
 17512.trc:
 ORA-00600: internal erro  
 r code, arguments: [3664
 ], [1], [1],

Re: Help on TDP_R3 Oracel - AIX

[Gary Bowers]

The alter tablespace command is an Oracle command, not a TSM command.
If you were getting error with the library manager (TSM), you would
see problems with allocating a channel.  I would get with your DBA to
do some investigation on this table.  The BRBACKUP command just issues
Oracle commands under the covers.

Gary
Itrus Technologies

On Aug 21, 2009, at 3:10 AM, Yudi Darmadi wrote:


Dear TSM'ers

I have a TDP_R3 Oracle on AIX V5.5.0.0 - and  when
I think this is not TSM issue, but i just wanna know does anyone had
been
experince this case?


BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17
BR0301E SQL error -600 at location db_file_switch-11
ORA-00600: internal error code, arguments: [3664], [3], [1], [4], [0],
[1954909839], [0], [1954909839]
BR0316E 'Alter tablespace PSAPWPR begin backup' failed
BR0280I BRCONNECT time stamp: 2009-08-21 08.43.17


Best Regards,


Yudi Darmadi
PT Niagaprima Paramitra
Jl. KH Ahmad Dahlan No.25  Kebayoran Baru, Jakarta Selatan 12130
Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
http://www.niagaprima.com

Re: HELP

[Bell, Charles (Chip)]

LOL

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Kevin
Sent: Wednesday, May 27, 2009 11:19 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] HELP

Help

-
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.

Re: Help with select statement

[Thomas Denier]

-Joni Moyer wrote: -

>I was trying:  select * from archives where node_name='FJSU101' and
>owner='appb2b' and filespace_id=11 and date(archive_date) >
>04/31/2009 as a starting point, but I'm still having no luck.  Any
>suggestions are greatly appreciated

I would expect the output from the 'date' function to look like
'2009-04-31'. When I compare a database fields to a fixed time
stamps, I always enclose the time stamp in single quotation marks.
I would expect 04/31/2009 without enclosing quotation marks to
be interpreted as dividing 4 by 31 and dividing the result by
2009.

Re: Help needed configuring TDP for Exchange2007 with VSS.

[Mcnutt, Larry E.]

Thanks Richard, Del and Steve.

We still haven't resolved the problem, and other priorities have taken
precedence for the Exchange admins.  We think at least part of our
problem involves an isolated Exchange test environment trying to
communicate with the TSM server on the production network.

Thanks again.
Larry


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Del Hoobler
Sent: Wednesday, February 18, 2009 4:13 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Help needed configuring TDP for Exchange2007 with VSS.

This sounds very close to the:
   ANS1353E (RC53)   Session rejected: Unknown or incorrect ID entered

This problem can be caused if the register node was not done correctly.
In order for proxy authority to work, you must have as admin node of
"Client Owner"
admin privilege for the DP/Exchange node.

This is normally done for you automatically when you issue the REGISTER
NODE command.
However if you used something like: REGISTER NODE nodename password
USERID=NONE
or if you used the GUI to define the NODE, the "admin" id may not have
been created.

To check this... on your TSM Server, issue the "QUERY ADMIN " command.
It should show something like this:


tsm: SERVER>q admin

Administrator Days SinceDays Since   Locked?Privilege
Classes
Name Last Access  Password Set
--      --
---
   CTNHEXMB01A   <1   134  No  Client Owner
   CTNHEXMB02A   <1   134  No  Client Owner
EXMB01E   <1   134  No  Client Owner


If this is not the problem, the other thing to verify is that your
CAD Service is configured and running.


Thanks,

Del



"ADSM: Dist Stor Manager"  wrote on 02/18/2009
02:39:10 PM:

> [image removed]
>
> Help needed configuring TDP for Exchange2007 with VSS.
>
> Mcnutt, Larry E.
>
> to:
>
> ADSM-L
>
> 02/18/2009 02:41 PM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" 
>
> Please respond to "ADSM: Dist Stor Manager"
>
> TSM 5.5.2.0
> AIX 5.3
> BA client 5.5.1
> TDP for Mail 5.5.1
> Cluster nodes CTNHEXMB01A and CTNHEXMB02A
> Exchange client node EXMB01E
> tsm: FSPHTSM1>q proxy target=EXMB01E
>
> Target Node Agent Node
> --- ---
> EXMB01E CTNHEXMB01A
>
> We apparently have some configuration problem.  When we try to run a
> local VSS backup from the agent node(CTNHEXMB01A), it always fails
with
> "ANS1033E (RC-53)  An invalid TCP/IP address was specified."  We have
> tried looking at all the documentation, with no resolution.  I know
this
> is not much information to go on, but I thought maybe this failure
> points to a specific problem.  There is so much configuration
> information involved, I preferred not to try to show it all, but will
> provide whatever is needed.  I also have a trace if that will help.
>
> Thanks,
> Larry McNutt
> The Timken Company
>
> -
> This message and any attachments are intended for the individual or
> entity named above. If you are not the intended recipient, please
> do not forward, copy, print, use or disclose this communication to
> others; also please notify the sender by replying to this message,
> and then delete it from your system. The Timken Company / The
> Timken Corporation

Re: Help needed configuring TDP for Exchange2007 with VSS.

[Steven Harris]

Larry

This is a known problem.  See the fix list for TSM Client 5.5.1.10

Regards

Steve

Steven Harris
TSM Admin, Sydney Australia





 "Mcnutt, Larry
 E."
   ADSM-L@VM.MARIST.EDU
 Sent by: "ADSM:cc
 Dist Stor
 Manager"  Subject
  TDP for Exchange2007 with VSS.


 19/02/2009 06:39
 AM


 Please respond to
 "ADSM: Dist Stor
 Manager"
 






TSM 5.5.2.0
AIX 5.3
BA client 5.5.1
TDP for Mail 5.5.1
Cluster nodes CTNHEXMB01A and CTNHEXMB02A
Exchange client node EXMB01E
tsm: FSPHTSM1>q proxy target=EXMB01E

Target Node Agent Node
--- ---
EXMB01E CTNHEXMB01A

We apparently have some configuration problem.  When we try to run a
local VSS backup from the agent node(CTNHEXMB01A), it always fails with
"ANS1033E (RC-53)  An invalid TCP/IP address was specified."  We have
tried looking at all the documentation, with no resolution.  I know this
is not much information to go on, but I thought maybe this failure
points to a specific problem.  There is so much configuration
information involved, I preferred not to try to show it all, but will
provide whatever is needed.  I also have a trace if that will help.

Thanks,
Larry McNutt
The Timken Company

-
This message and any attachments are intended for the individual or
entity named above. If you are not the intended recipient, please
do not forward, copy, print, use or disclose this communication to
others; also please notify the sender by replying to this message,
and then delete it from your system. The Timken Company / The
Timken Corporation

Re: Help needed configuring TDP for Exchange2007 with VSS.

[Del Hoobler]

This sounds very close to the:
   ANS1353E (RC53)   Session rejected: Unknown or incorrect ID entered

This problem can be caused if the register node was not done correctly.
In order for proxy authority to work, you must have as admin node of
"Client Owner"
admin privilege for the DP/Exchange node.

This is normally done for you automatically when you issue the REGISTER
NODE command.
However if you used something like: REGISTER NODE nodename password
USERID=NONE
or if you used the GUI to define the NODE, the "admin" id may not have
been created.

To check this... on your TSM Server, issue the "QUERY ADMIN " command.
It should show something like this:


tsm: SERVER>q admin

Administrator Days SinceDays Since   Locked?Privilege Classes
Name Last Access  Password Set
--      --
---
   CTNHEXMB01A   <1   134  No  Client Owner
   CTNHEXMB02A   <1   134  No  Client Owner
EXMB01E   <1   134  No  Client Owner


If this is not the problem, the other thing to verify is that your
CAD Service is configured and running.


Thanks,

Del



"ADSM: Dist Stor Manager"  wrote on 02/18/2009
02:39:10 PM:

> [image removed]
>
> Help needed configuring TDP for Exchange2007 with VSS.
>
> Mcnutt, Larry E.
>
> to:
>
> ADSM-L
>
> 02/18/2009 02:41 PM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" 
>
> Please respond to "ADSM: Dist Stor Manager"
>
> TSM 5.5.2.0
> AIX 5.3
> BA client 5.5.1
> TDP for Mail 5.5.1
> Cluster nodes CTNHEXMB01A and CTNHEXMB02A
> Exchange client node EXMB01E
> tsm: FSPHTSM1>q proxy target=EXMB01E
>
> Target Node Agent Node
> --- ---
> EXMB01E CTNHEXMB01A
>
> We apparently have some configuration problem.  When we try to run a
> local VSS backup from the agent node(CTNHEXMB01A), it always fails with
> "ANS1033E (RC-53)  An invalid TCP/IP address was specified."  We have
> tried looking at all the documentation, with no resolution.  I know this
> is not much information to go on, but I thought maybe this failure
> points to a specific problem.  There is so much configuration
> information involved, I preferred not to try to show it all, but will
> provide whatever is needed.  I also have a trace if that will help.
>
> Thanks,
> Larry McNutt
> The Timken Company
>
> -
> This message and any attachments are intended for the individual or
> entity named above. If you are not the intended recipient, please
> do not forward, copy, print, use or disclose this communication to
> others; also please notify the sender by replying to this message,
> and then delete it from your system. The Timken Company / The
> Timken Corporation

Re: HElp on ANS9999E

[Richard Sims]

See the past postings on this problem in http://www.mail-archive.com/
adsm-l@vm.marist.edu/ .
IBM Technote 1251903 summarizes the problem.
You don't specify the bitmode of your Windows system, but it is
likely 32-bit and, because of that, can't handle large stuff, partly
because of deficiencies in the design of the Windows OS.

  Richard Sims

Re: Help with a class

[Stephan Boldt]

Hello James,


> 3. cd to the directory called final that is located within my home
> directory.


cd ~/final

A copy of the group file called mygroup was created using the ! as the
> field separator. The fields should be separated using a : not a !.
>
> Create a single command string that will modify the file called mygroup
> and change all occurrences of the ! to a :. The command string must also
> sort the file numerically on the GID field and then save the output to a
> file called newgroup.
>

>
> A. What command string did you use?


sed -e 's/!/:/g' mygroup|sort|sort -n -k 3 -t : > newgroup

8. Consider the following alias:
>
> alias dirc 'ls -l | grep '^d' | wc -l'


>
> A. What EXACTLY will this alias do when it is executed?


It will return the number of subdirectorys of the directory from which this
command is started.


> 4. cd to the directory called final that is located within my home
> directory. Create a command string that will output the name of the
> largest file in the directory. The largest file would be the file with
> the greatest file size in bytes. The ONLY output from the command string
> should be a single file name. (80% credit if you can output a long
> listing of all of the filenames with the largest file listed at the top)
>
>
> A. What command string will do this?
>

ls -S |head --lines=1

Be aware that a subdir is treated the same way as a file. If there is no
file which is larger then an directory entry, then you get a directory name
as the result. But I guess that's correct because in Unix EVERYTHING is a
file... :)


Hope this will help you!

kind regards,
Stephan

Re: Help with a class

[Lepre, James]

Everyone I am a Unix novice and I am taking a class.  I have some
questions I need to answer but I am having a difficult time.  This may
not be the forum but I thought someone may know the answers.  Any help
will be greatly appreciated.  

 

3. cd to the directory called final that is located within my home
directory.

A copy of the group file called mygroup was created using the ! as the
field separator. The fields should be separated using a : not a !.

Create a single command string that will modify the file called mygroup
and change all occurrences of the ! to a :. The command string must also
sort the file numerically on the GID field and then save the output to a
file called newgroup.

A. What command string did you use?

8. Consider the following alias:

alias dirc 'ls -l | grep '^d' | wc -l'

A. What EXACTLY will this alias do when it is executed?

4. cd to the directory called final that is located within my home
directory. Create a command string that will output the name of the
largest file in the directory. The largest file would be the file with
the greatest file size in bytes. The ONLY output from the command string
should be a single file name. (80% credit if you can output a long
listing of all of the filenames with the largest file listed at the top)


A. What command string will do this?

 

Thanks Everyone

 

James Lepre

 


  
  
---
Confidentiality Notice: The information in this e-mail and any attachments 
thereto is intended for the named recipient(s) only.  This e-mail, including 
any attachments, may contain information that is privileged and confidential  
and subject to legal restrictions and penalties regarding its unauthorized 
disclosure or other use.  If you are not the intended recipient, you are hereby 
notified that any disclosure, copying, distribution, or the taking of any 
action or inaction in reliance on the contents of this e-mail and any of its 
attachments is STRICTLY PROHIBITED.  If you have received this e-mail in error, 
please immediately notify the sender via return e-mail; delete this e-mail and 
all attachments from your e-mail  system and your computer system and network; 
and destroy any paper copies you may have in your possession. Thank you for 
your cooperation.

Re: Help on exclude files ...Please

[Robert Ouzen Ouzen]

Hi Richard and others

I left only the /var/tmp/.../*  on the inclexcl file to test , I do a q 
inclexcl as Richard suggest but I still see the files under /var/tmp ???


tsm> q inclexcl
*** FILE INCLUDE/EXCLUDE ***
Mode Function  Pattern (match from top down)  Source File
 - -- -
No exclude filespace statements defined.
Excl Directory /.../.TsmCacheDir  TSM
Exclude All   /var/tmp/.../* 
"/opt/tivoli/tsm/client/ba/bin/cciprnt2.excl"
No DFS include/exclude statements defined.

Robert

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard 
Sims
Sent: Wednesday, July 16, 2008 3:34 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Help on exclude files ...Please

As I frequently advise, do 'dsmc q inclexcl' rather than inspecting
client options files: have TSM report to you what *it* believes your
Include-Exclude list to be, which will also pull in any server-side
specs.

Richard Sims

Re: Help on exclude files ...Please

[Richard Sims]

As I frequently advise, do 'dsmc q inclexcl' rather than inspecting
client options files: have TSM report to you what *it* believes your
Include-Exclude list to be, which will also pull in any server-side
specs.

   Richard Sims

Re: Help with SQL to Pull Information from TSM server

[Richard Sims]

Your posting does not provide the context of utilization of the
data.  I would recommend depending upon the accounting records for
reliable, detailed, and fielded data on client sessions.

   Richard Sims

Re: help with numbers

[goc]

hmm, i think it's exactly ok since

3,665,543,168 bytes -eq 3.41GB

the second try is what the technote says but the first try was exactly the same
so why didn't the client double the vales in the first try ? because
it worked okay ? :-)

i never had similar issues, okay using rman doesnt feedback much to me
so the numbers
are little in the dark but still ...

no problem,thanks all

//g

On Fri, Apr 11, 2008 at 4:49 PM, Richard Sims <[EMAIL PROTECTED]> wrote:
> On Apr 11, 2008, at 10:28 AM, goc wrote:
>
> > Total number of bytes transferred: 3.41 GB
> > LanFree data bytes:3.41 GB < this is ok !!!
> >
>
>  Well, not really.  Whereas the session for the single object resulted
>  in a retry in awaiting a mount, that represents two transmissions of
>  the data, so the number should be double, as corroborated by Technote
>  1142515 and the second session.  Something odd seems to be going on
>  in the software for the two separate sessions on the same data to
>  yield disparate results.
>
>Richard Sims
>

Re: help with numbers

[Richard Sims]

On Apr 11, 2008, at 10:28 AM, goc wrote:

Total number of bytes transferred: 3.41 GB
LanFree data bytes:3.41 GB < this is ok !!!


Well, not really.  Whereas the session for the single object resulted
in a retry in awaiting a mount, that represents two transmissions of
the data, so the number should be double, as corroborated by Technote
1142515 and the second session.  Something odd seems to be going on
in the software for the two separate sessions on the same data to
yield disparate results.

   Richard Sims

Re: help with numbers

[goc]

i didn't change anything
first command was

axpbckp:/home/goran 797>dsmc sel /db/DRM/dbase/data/COREM_DAT03.dbf -se=drm_tdpo

then some

axpbckp:/home/goran 798>
ksh: ^[k:  not found.
axpbckp:/home/goran 812>set -o vi
axpbckp:/home/goran 813>^df -k
.
.
.
then
axpbckp:/home/goran 814>dsmc sel /db/DRM/dbase/data/COREM_DAT03.dbf
-se=drm_tdpo_sched

the gap between prompt 798 and 812 was caused my another admin but
nothin revolutionary

//thanks
g

On Fri, Apr 11, 2008 at 4:35 PM, Howard Coles
<[EMAIL PROTECTED]> wrote:
> Did you change anything from the first and second try?  Did you shut
>  down the client between backups?
>  It looks like TSM combined the stats from the first and second try but
>  just for the size fields.
>
>  See Ya'
>  Howard
>
>
>
>  > -Original Message-
>  > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
>  > Of goc
>  > Sent: Friday, April 11, 2008 9:28 AM
>  > To: ADSM-L@VM.MARIST.EDU
>  > Subject: [ADSM-L] help with numbers
>  >
>  > hi i was doing some testing i i encountered some strange issues , at
>  > least for me :-)
>  > i was firing away 2 backups of the same db file for some analysis and
>  > this is what i got
>  > total number of bytes does not show the right value ... maybe :-S
>  > i'm confused, if anyone have  seend something like this please say
>  > something ...
>  >
>  > --->> first try:
>  > Selective Backup function invoked.
>  >
>  > Normal File--> 3,665,543,168 /db/DRM/dbase/data/COREM_DAT03.dbf
>  > ** Unsuccessful **
>  > ANS1114I Waiting for mount of offline media.
>  > Retry # 1  Normal File--> 3,665,543,168
>  > /db/DRM/dbase/data/COREM_DAT03.dbf [Sent]
>  > Selective Backup processing of '/db/DRM/dbase/data/COREM_DAT03.dbf'
>  > finished without failure.
>  >
>  >
>  > Total number of objects inspected:1
>  > Total number of objects backed up:1
>  > Total number of objects updated:  0
>  > Total number of objects rebound:  0
>  > Total number of objects deleted:  0
>  > Total number of objects expired:  0
>  > Total number of objects failed:   0
>  > Total number of bytes transferred: 3.41 GB
>  > LanFree data bytes:3.41 GB < this is ok !!!
>  > Data transfer time:  108.08 sec
>  > Network data transfer rate:33,125.14 KB/sec
>  > Aggregate data transfer rate:  23,127.43 KB/sec
>  > Objects compressed by:0%
>  > Elapsed processing time:   00:02:34
>  >
>  > --->> second try:
>  > Selective Backup function invoked.
>  >
>  > Normal File--> 3,665,543,168 /db/DRM/dbase/data/COREM_DAT03.dbf
>  > ** Unsuccessful **
>  > ANS1114I Waiting for mount of offline media.
>  > Retry # 1  Normal File--> 3,665,543,168
>  > /db/DRM/dbase/data/COREM_DAT03.dbf [Sent]
>  > Selective Backup processing of '/db/DRM/dbase/data/COREM_DAT03.dbf'
>  > finished without failure.
>  >
>  >
>  > Total number of objects inspected:1
>  > Total number of objects backed up:1
>  > Total number of objects updated:  0
>  > Total number of objects rebound:  0
>  > Total number of objects deleted:  0
>  > Total number of objects expired:  0
>  > Total number of objects failed:   0
>  > Total number of bytes transferred: 6.82 GB  < ISSUE :-)
>  > LanFree data bytes:6.82 GB
>  > Data transfer time:  135.10 sec
>  > Network data transfer rate:52,998.27 KB/sec
>  > Aggregate data transfer rate:  50,367.30 KB/sec
>  > Objects compressed by:0%
>  > Elapsed processing time:   00:02:22
>  >
>  >
>  > server 5.4.1 on aix 5.2
>  > client 5.4.1
>  > sta 5.4.1 on client
>  > 3584 LTO3 drives
>  >
>  > thanks in advance
>

Re: help with numbers

[Howard Coles]

Did you change anything from the first and second try?  Did you shut
down the client between backups?
It looks like TSM combined the stats from the first and second try but
just for the size fields.

See Ya'
Howard

> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
> Of goc
> Sent: Friday, April 11, 2008 9:28 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] help with numbers
> 
> hi i was doing some testing i i encountered some strange issues , at
> least for me :-)
> i was firing away 2 backups of the same db file for some analysis and
> this is what i got
> total number of bytes does not show the right value ... maybe :-S
> i'm confused, if anyone have  seend something like this please say
> something ...
> 
> --->> first try:
> Selective Backup function invoked.
> 
> Normal File--> 3,665,543,168 /db/DRM/dbase/data/COREM_DAT03.dbf
> ** Unsuccessful **
> ANS1114I Waiting for mount of offline media.
> Retry # 1  Normal File--> 3,665,543,168
> /db/DRM/dbase/data/COREM_DAT03.dbf [Sent]
> Selective Backup processing of '/db/DRM/dbase/data/COREM_DAT03.dbf'
> finished without failure.
> 
> 
> Total number of objects inspected:1
> Total number of objects backed up:1
> Total number of objects updated:  0
> Total number of objects rebound:  0
> Total number of objects deleted:  0
> Total number of objects expired:  0
> Total number of objects failed:   0
> Total number of bytes transferred: 3.41 GB
> LanFree data bytes:3.41 GB < this is ok !!!
> Data transfer time:  108.08 sec
> Network data transfer rate:33,125.14 KB/sec
> Aggregate data transfer rate:  23,127.43 KB/sec
> Objects compressed by:0%
> Elapsed processing time:   00:02:34
> 
> --->> second try:
> Selective Backup function invoked.
> 
> Normal File--> 3,665,543,168 /db/DRM/dbase/data/COREM_DAT03.dbf
> ** Unsuccessful **
> ANS1114I Waiting for mount of offline media.
> Retry # 1  Normal File--> 3,665,543,168
> /db/DRM/dbase/data/COREM_DAT03.dbf [Sent]
> Selective Backup processing of '/db/DRM/dbase/data/COREM_DAT03.dbf'
> finished without failure.
> 
> 
> Total number of objects inspected:1
> Total number of objects backed up:1
> Total number of objects updated:  0
> Total number of objects rebound:  0
> Total number of objects deleted:  0
> Total number of objects expired:  0
> Total number of objects failed:   0
> Total number of bytes transferred: 6.82 GB  < ISSUE :-)
> LanFree data bytes:6.82 GB
> Data transfer time:  135.10 sec
> Network data transfer rate:52,998.27 KB/sec
> Aggregate data transfer rate:  50,367.30 KB/sec
> Objects compressed by:0%
> Elapsed processing time:   00:02:22
> 
> 
> server 5.4.1 on aix 5.2
> client 5.4.1
> sta 5.4.1 on client
> 3584 LTO3 drives
> 
> thanks in advance

Re: HELP!! TIPS on freeing up library slots

[Bob Levad]

I've scheduled this script to run every day to keep an eye on our volumes.
I don't look at all of it every day, but if there is a problem, I can
usually find the cause in the output.  NOTE: YMMV and PLEASE test the
sections in your environment to see how much cpu and time the queries may
take.

Bob.
**

/* total volumes in the library */
select count(*) as "Total volumes in the LTO Library " from libvolumes

/* total scratch */
select count(*) as "Scratch volumes in the LTO Library   " from libvolumes
where status='Scratch'

/* newest scratch */
select max(volume_name) as "Newest Volume" from volhistory

/* Total DR Media volumes */
select COUNT(*) as "DRMedia Volumes" from drmedia

/* Total onsite volumes */
select COUNT(*) as "Media Volumes" from media

/* Writable volumes - watch for too few writable in a collocated
pool */
select stg.collocate as "Collocated", -
vol.stgpool_name as "Storage Pool",-
count(*) as "Writable Vols" -
from stgpools stg, volumes vol -
where stg.stgpool_name=vol.stgpool_name and -
vol.devclass_name='LTOCLASS1' and -
(vol.status='EMPTY' or vol.STATUS='FILLING') and -
vol.access<>'OFFSITE' -
group by stg.collocate, -
vol.stgpool_name

/* Allocated and available Scratch pools - watch for 0 vols scratch
*/
select stgpools.stgpool_name, -
stgpools.maxscratch, -
count(stgpools.maxscratch) as "allocated_scratch", -
stgpools.maxscratch-count(stgpools.maxscratch) as
"remaining_scratch" -
from stgpools,volumes -
where (volumes.stgpool_name=stgpools.stgpool_name) and -
((stgpools.devclass='LTOCLASS1')) -
group by stgpools.stgpool_name, -
stgpools.maxscratch

/* Find LRU volumes in the library */
select libv.volume_name, -
vol.stgpool_name, -
vol.status, -
date(current_timestamp)-date(vol.last_read_date) as "Read", -
date(current_timestamp)-date(vol.last_write_date) as "Written" -
from libvolumes libv, -
volumes vol -
where libv.volume_name=vol.volume_name -
order by "Read" desc, -
"Written" desc

/* find offline drives */
q drive

/* find offline paths */
q path

/* show Cleaners, Scratch, DB vols, and improperly checked in
volumes */
select volume_name, -
status, -
last_use, -
home_element -
from libvolumes -
where volume_name not in (select volume_name from volumes)

/* Show details of library volumes - old, full volumes are eject
candidates */
/* old, full volumes are eject candidates */
/* small, volumes w/o recent write are move data candidates */
select  lib.volume_name as "Vol Name", -
vol.stgpool_name as "Stg Pool", -
vol.status, -
vol.pct_utilized as "Util", -
date(vol.last_write_date) as "Last Write" -
from volumes vol, -
libvolumes lib -
where lib.volume_name=vol.volume_name -
order by "Last Write", -
vol.status, -
vol.pct_utilized

/* filling volumes */
/* look for small tapes that haven't been recently written for move
candidates */
select  vol.stgpool_name as "Stg Pool", -
vol.volume_name as "Vol Name", -
vol.pct_utilized as "Util", -
date(vol.last_write_date) as "Last Write", -
vol.location -
from volumes vol -
where devclass_name='LTOCLASS1' and -
status='FILLING' -
order by vol.stgpool_name, -
vol.pct_utilized

/* query number of volumes a node occupies - large numbers = painful
restores  */
/* these are candidates for a full backup */
select distinct stgpool_name, node_name, -
  count(distinct volume_name) as "Volumes"  -
from volumeusage -
group by stgpool_name, -
  node_name -
order by stgpool_name, -
  "Volumes" desc

/* query number of volumes a filespace occupies - large numbers =
painful restores */
select distinct stgpool_name, node_name, filespace_name, -
  count(distinct volume_name) as "Volumes"  -
from volumeusage group by stgpool_name, -
  node_name, filespace_name -
order by stgpool_name, node_name, -
  filespace_name


/* volume inventory section - lists all known volumes and location
for tape vault reconciliation */

/* list all scratch volumes */
select distinct volume_name, -
max(date(date_time)) as "Date Scratched" -
from volhistory -
where type='STGDELETE' and -
devclass='LTOCLASS1' and -
volume_name not in(select volume_name from volumes) and -
volume_name not in(select volume_name from drmedia) -
group by volume_name -
order by volume_name

/* list all database backups */
select volume_name, -
location, -
voltype, -
state -
from drmedia -
where voltype<>'CopyStgPool' -
order by location, -
volume_name

/* list all TSM volumes */
select volume_name, -
loc

Re: HELP!! TIPS on freeing up library slots

[Johnny Lea]

I used the "overflow location" once with success when I was in this same 
situation.  Just long enough to put in some scratch tapes and move data.
I wouldn't recommend it for normal occasions though.

Johnny Lea  CNE
Data Center Manager
Division of Information Systems
University of MS Medical Center
601-984-6398
fax 601-815-3222
[EMAIL PROTECTED]
>>> Nicholas Rodolfich <[EMAIL PROTECTED]> 11/27/07 9:13 AM >>>
Hi All,

Thanks for your help!!


I have TSm 5.3.5 on AIX 5.3.5 using an IBM 3584 w/16 LTO drives. I have
run out of slots in the library and can't seem to get enough scratch
volumes in to get any decent move data commands flowing based on
pct_reclaim values.  Does anyone have any "ideas" on how I could
consolidate some volumes quickly?




IMPORTANT NOTICE:  This message and any included attachments are from East 
Jefferson General Hospital, and is intended only for the addressee(s), and may 
include Protected Health (PHI) or other confidential information.  If you are 
the intended recipient, you are obligated to maintain it in a secure and 
confidential manner and re-disclosure without additional consent or as 
permitted by law is prohibited.   If you are not the intended recipient, use of 
this information is strictly prohibited and may be unlawful.  Please promptly 
reply to the sender by email and delete this message from your computer. East 
Jefferson General Hospital greatly appreciates your cooperation.







Individuals who have received this information in error or are not authorized 
to receive it must promptly return or dispose of the information and notify the 
sender. Those individuals are hereby notified that they are strictly prohibited 
from reviewing, forwarding, printing, copying, distributing or using this 
information in any way.

Re: HELP!! TIPS on freeing up library slots

[Taylor, David]

Are you running backups, directly to tape, in the same storage pool
where you are seeing the "filled" volumes?  

I have an issue, with my SQL DB backups, that results in the same
situation.  Because of their size, they go directly to tape.  Due to the
available backup window, I am forced to back them all up at roughly the
same time.  This generally leads to a each backup going to a separate
tape.

To help rectify the situation, I have a little ksh script that
consolidates the "filled" volumes.

HTH

David
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Tuesday, November 27, 2007 11:31 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] HELP!! TIPS on freeing up library slots

On Nov 27, 2007, at 12:24 PM, Jim Young wrote:

> Does anyone know whay TSM has this issue with keeping lots of
> 'filling' volumes?

This is an old chestnut issue.
See "Tape leak" in http://people.bu.edu/rbs/ADSM.QuickFacts
for general info on it.

Richard Sims

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.clearswift.com
**