Re: Need help using Powershell to create custom backup commands

[Schaub, Steve]

Thanks, David.  You are correct.  Someone else pointed me in the direction of 
passing the variable as an array of drive letters rather than a string, which 
works correctly.

-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of David Bronder
Sent: Wednesday, September 23, 2020 11:22 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Need help using Powershell to create custom backup 
commands

Because you have the volume list variable quoted, I think that part of the 
command actually translates to the single string "G: H: I: J:" rather than a 
list of drive letters.  Which I think would be interpreted as G:"\ H: I: J:".


On 9/23/20 8:21 AM, Schaub, Steve wrote:
> I'm using PS to kick off custom backups and having trouble passing a list of 
> volumes to the incremental backup command in dsmc.
>
> Here is what the powershell statement looks like, the "$myBackupVolumeList" 
> variable is a string derived from an array:
> & .\DSMC.exe Incremental "$myBackupVolumeList" 
> "-Optfile=$myClusterOptFile" | Out-File -Encoding ASCII -filepath 
> "$myTSMLogDetail" -Append
>
> The command translates to this:
> c:\program files\tivoli\tsm\baclient\dsmc.exe Incremental G: H: I: J: 
> -Optfile=cluster.opt
>
> Here is what shows up in the normal backup log:
> IBM Spectrum Protect
> Command Line Backup-Archive Client Interface
>   Client Version 8, Release 1, Level 4.0
>   Client date/time: 09/21/2020 15:52:11
> (c) Copyright by IBM Corporation and other(s) 1990, 2017. All Rights Reserved.
> Node Name: WNFC0310
> Session established with server TSMN02: AIX
>   Server Version 8, Release 1, Level 9.200
>   Server date/time: 09/21/2020 15:52:12  Last access: 09/21/2020 
> 15:41:03 Incremental backup of volume 'G: H: I: J:'
>
>
> So it looks like it should work, but it fails with this error in the 
> dsmerror.log:
> ANS1076E The specified directory path 'G:\ H: I: J:' could not be found.
>
> I have been unable to figure out where the stray backslash is coming from, 
> any help would be appreciated.
>
> Steve Schaub
> Senior Platform Engineer II, Backup & Recovery BlueCross BlueShield of 
> Tennessee
>

--
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu

--
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  
https://www.bcbst.com/about/our-company/corporate-governance/privacy-security/email-policy.page
 
<https://www.bcbst.com/about/our-company/corporate-governance/privacy-security/email-policy.page>
--

This email was sent by "Schaub, Steve"  securely using 
Transport Layer Security (TLS).

Re: Need help using Powershell to create custom backup commands

[David Bronder]

Because you have the volume list variable quoted, I think that part of the
command actually translates to the single string "G: H: I: J:" rather than a
list of drive letters.  Which I think would be interpreted as G:"\ H: I: J:".


On 9/23/20 8:21 AM, Schaub, Steve wrote:
> I'm using PS to kick off custom backups and having trouble passing a list of 
> volumes to the incremental backup command in dsmc.
>
> Here is what the powershell statement looks like, the "$myBackupVolumeList" 
> variable is a string derived from an array:
> & .\DSMC.exe Incremental "$myBackupVolumeList" "-Optfile=$myClusterOptFile" | 
> Out-File -Encoding ASCII -filepath "$myTSMLogDetail" -Append
>
> The command translates to this:
> c:\program files\tivoli\tsm\baclient\dsmc.exe Incremental G: H: I: J: 
> -Optfile=cluster.opt
>
> Here is what shows up in the normal backup log:
> IBM Spectrum Protect
> Command Line Backup-Archive Client Interface
>   Client Version 8, Release 1, Level 4.0
>   Client date/time: 09/21/2020 15:52:11
> (c) Copyright by IBM Corporation and other(s) 1990, 2017. All Rights Reserved.
> Node Name: WNFC0310
> Session established with server TSMN02: AIX
>   Server Version 8, Release 1, Level 9.200
>   Server date/time: 09/21/2020 15:52:12  Last access: 09/21/2020 15:41:03
> Incremental backup of volume 'G: H: I: J:'
>
>
> So it looks like it should work, but it fails with this error in the 
> dsmerror.log:
> ANS1076E The specified directory path 'G:\ H: I: J:' could not be found.
>
> I have been unable to figure out where the stray backslash is coming from, 
> any help would be appreciated.
>
> Steve Schaub
> Senior Platform Engineer II, Backup & Recovery
> BlueCross BlueShield of Tennessee
>

--
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu

Need help using Powershell to create custom backup commands

[Schaub, Steve]

I'm using PS to kick off custom backups and having trouble passing a list of 
volumes to the incremental backup command in dsmc.

Here is what the powershell statement looks like, the "$myBackupVolumeList" 
variable is a string derived from an array:
& .\DSMC.exe Incremental "$myBackupVolumeList" "-Optfile=$myClusterOptFile" | 
Out-File -Encoding ASCII -filepath "$myTSMLogDetail" -Append

The command translates to this:
c:\program files\tivoli\tsm\baclient\dsmc.exe Incremental G: H: I: J: 
-Optfile=cluster.opt

Here is what shows up in the normal backup log:
IBM Spectrum Protect
Command Line Backup-Archive Client Interface
  Client Version 8, Release 1, Level 4.0
  Client date/time: 09/21/2020 15:52:11
(c) Copyright by IBM Corporation and other(s) 1990, 2017. All Rights Reserved.
Node Name: WNFC0310
Session established with server TSMN02: AIX
  Server Version 8, Release 1, Level 9.200
  Server date/time: 09/21/2020 15:52:12  Last access: 09/21/2020 15:41:03
Incremental backup of volume 'G: H: I: J:'


So it looks like it should work, but it fails with this error in the 
dsmerror.log:
ANS1076E The specified directory path 'G:\ H: I: J:' could not be found.

I have been unable to figure out where the stray backslash is coming from, any 
help would be appreciated.

Steve Schaub
Senior Platform Engineer II, Backup & Recovery
BlueCross BlueShield of Tennessee



--
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  
https://www.bcbst.com/about/our-company/corporate-governance/privacy-security/email-policy.page
 
<https://www.bcbst.com/about/our-company/corporate-governance/privacy-security/email-policy.page>
--

This email was sent by "Schaub, Steve"  securely using 
Transport Layer Security (TLS).

Re: Re: Query help joining 2 tables

[Bronder, David M]

Note that the occupancy counts will also include archive and HSM files, which
may or may not be expected, unless you add "AND OC.Type='Bkup'" to the outer
WHERE clause.

Another thing that can inflate the occupancy counts (again, may or may not be
expected) is use of traditional copy pools.

=Dave


On 1/17/20 11:14 AM, Hall, Lynn wrote:
> Discovered a join problem. Need to have both node_name and Filespace_ID in
> the equivalence between the tables. Otherwise you are joining only on the
> Filespace_ID which can be the same for multiple nodes. Thus giving large
> errors.
> 
> SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
> FS.Filespace_ID, FS.Age, SUM(OC.Num_Files) FROM (SELECT Node_Name,
> Filespace_Name, Filespace_ID, DAYS(Current_Date)-DAYS(Backup_End) AS Age
> FROM Filespaces where days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS
> Join Occupancy OC on FS.Node_Name=OC.Node_Name AND
>  FS.Filespace_ID=OC.Filespace_ID group by FS.Node_name, FS.FILESPACE_NAME,
> FS.Filespace_ID, FS.AGE ORDER BY FS.NODE_NAME
> 
> 
> Lynn Hall
> Information Technology Specialist IV
> Platform Services
> Office of the Chief Information Officer
> 1305 E Walnut Street | Des Moines, IA 50319  - Mailing
> mobile 515-669-4325
> ocio.iowa.gov
> 
> 
> On Thu, Jan 16, 2020 at 8:11 PM Bronder, David M 
> wrote:
> 
>> I think you can do it without the explicit join (I'm sure an actual SQL
>> expert could explain the difference).  (I also added some formatting of the
>> age and occupancy output):
>>
>>   SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, -
>>  FS.Filespace_ID, SUM(OC.Num_Files) as NUM_FILES, -
>>  FS.Age || ' days' as "LAST_BACKUP" -
>>   FROM (SELECT Node_Name, Filespace_Name, Filespace_ID, -
>>DAYS(Current_Date)-DAYS(Backup_End) AS Age -
>> FROM Filespaces -
>> WHERE days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS, -
>>Occupancy OC -
>>   WHERE FS.Filespace_ID=OC.Filespace_ID -
>>   GROUP BY FS.Node_Name, FS.Filespace_Name, FS.Filespace_ID, FS.Age -
>>   ORDER BY FS.Node_Name
>>
>>
>> If it's OK to report the date of the last backup completion instead of the
>> number of days since the last backup, the following is a slightly simpler
>> query (you could also cast/trim the time out of the end date):
>>
>>   SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, -
>>  FS.Filespace_ID, SUM(OC.Num_Files) as NUM_FILES, FS.Backup_End -
>>   FROM Filespaces FS, Occupancy OC -
>>   WHERE FS.Filespace_ID=OC.Filespace_ID and -
>> DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit -
>>   GROUP BY FS.Node_Name, FS.Filespace_Name, FS.Filespace_ID, FS.Backup_End
>> -
>>   ORDER BY FS.Node_Name
>>
>> =Dave
>>
>>
>> On 1/15/20 2:00 PM, Hall, Lynn wrote:
>>> SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
>>> FS.Filespace_ID, FS.Age, SUM(OC.Num_Files) FROM (SELECT Node_Name,
>>> Filespace_Name, Filespace_ID, DAYS(Current_Date)-DAYS(Backup_End) AS Age
>>> FROM Filespaces where days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS
>>> Join Occupancy OC on FS.Filespace_ID=OC.Filespace_ID group by
>> FS.Node_name,
>>> FS.FILESPACE_NAME, FS.Filespace_ID, FS.AGE ORDER BY FS.NODE_NAME
>>>
>>>
>>> Lynn Hall
>>> Information Technology Specialist IV
>>> Platform Services
>>> Office of the Chief Information Officer
>>> 1305 E Walnut Street | Des Moines, IA 50319  - Mailing
>>> mobile 515-669-4325
>>> ocio.iowa.gov
>>>
>>>
>>> On Wed, Jan 15, 2020 at 6:45 AM Schaub, Steve 
>>> wrote:
>>>
 SP 8.1.9
 I'm trying to write a Powershell script that will return data on all
 filespaces that haven't been backed up in > x days.  I've had the basic
 query from the Filespaces table working for years, but now I'm trying to
 include the total object count from the Occupancy table for each
>> filespace,
 and I'm not adept enough at query writing to do that.  I suspect I need
 some flavor of join but not sure which one.

 Here was my first attempt, more to show what I'm trying to do, it
 obviously isn't working.  If anyone has this working and is willing to
 share, I'd appreciate it.

 SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
 FS.Filespace_ID, DAYS(Current_Date)-DAYS(FS.Backup_End) AS Age,
 SUM(OC.Num_Files) FROM Filespaces FS, Occupancy OC WHERE
 FS.Filespace_ID=OC.Filespace_ID AND FS.filespace_id=OC.filespace_id AND
 DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit

 Steve Schaub
 Systems Eng II, Backup & Recovery
 BlueCross BlueShield of Tennessee

>>

-- 
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu

Re: Query help joining 2 tables

[Hall, Lynn]

Discovered a join problem. Need to have both node_name and Filespace_ID in
the equivalence between the tables. Otherwise you are joining only on the
Filespace_ID which can be the same for multiple nodes. Thus giving large
errors.

SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
FS.Filespace_ID, FS.Age, SUM(OC.Num_Files) FROM (SELECT Node_Name,
Filespace_Name, Filespace_ID, DAYS(Current_Date)-DAYS(Backup_End) AS Age
FROM Filespaces where days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS
Join Occupancy OC on FS.Node_Name=OC.Node_Name AND
 FS.Filespace_ID=OC.Filespace_ID group by FS.Node_name, FS.FILESPACE_NAME,
FS.Filespace_ID, FS.AGE ORDER BY FS.NODE_NAME







[image: OCIO-logo-Transparent.png] 



Lynn Hall

Information Technology Specialist IV

Platform Services

Office of the Chief Information Officer

1305 E Walnut Street | Des Moines, IA 50319  - Mailing

mobile 515-669-4325

ocio.iowa.gov

[image: social media icons_Twitter cir.png]
[image:
social media icons_LinkedIn cir.png]



On Thu, Jan 16, 2020 at 8:11 PM Bronder, David M 
wrote:

> I think you can do it without the explicit join (I'm sure an actual SQL
> expert could explain the difference).  (I also added some formatting of the
> age and occupancy output):
>
>   SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, -
>  FS.Filespace_ID, SUM(OC.Num_Files) as NUM_FILES, -
>  FS.Age || ' days' as "LAST_BACKUP" -
>   FROM (SELECT Node_Name, Filespace_Name, Filespace_ID, -
>DAYS(Current_Date)-DAYS(Backup_End) AS Age -
> FROM Filespaces -
> WHERE days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS, -
>Occupancy OC -
>   WHERE FS.Filespace_ID=OC.Filespace_ID -
>   GROUP BY FS.Node_Name, FS.Filespace_Name, FS.Filespace_ID, FS.Age -
>   ORDER BY FS.Node_Name
>
>
> If it's OK to report the date of the last backup completion instead of the
> number of days since the last backup, the following is a slightly simpler
> query (you could also cast/trim the time out of the end date):
>
>   SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, -
>  FS.Filespace_ID, SUM(OC.Num_Files) as NUM_FILES, FS.Backup_End -
>   FROM Filespaces FS, Occupancy OC -
>   WHERE FS.Filespace_ID=OC.Filespace_ID and -
> DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit -
>   GROUP BY FS.Node_Name, FS.Filespace_Name, FS.Filespace_ID, FS.Backup_End
> -
>   ORDER BY FS.Node_Name
>
> =Dave
>
>
> On 1/15/20 2:00 PM, Hall, Lynn wrote:
> > SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
> > FS.Filespace_ID, FS.Age, SUM(OC.Num_Files) FROM (SELECT Node_Name,
> > Filespace_Name, Filespace_ID, DAYS(Current_Date)-DAYS(Backup_End) AS Age
> > FROM Filespaces where days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS
> > Join Occupancy OC on FS.Filespace_ID=OC.Filespace_ID group by
> FS.Node_name,
> > FS.FILESPACE_NAME, FS.Filespace_ID, FS.AGE ORDER BY FS.NODE_NAME
> >
> >
> > Lynn Hall
> > Information Technology Specialist IV
> > Platform Services
> > Office of the Chief Information Officer
> > 1305 E Walnut Street | Des Moines, IA 50319  - Mailing
> > mobile 515-669-4325
> > ocio.iowa.gov
> >
> >
> > On Wed, Jan 15, 2020 at 6:45 AM Schaub, Steve 
> > wrote:
> >
> >> SP 8.1.9
> >> I'm trying to write a Powershell script that will return data on all
> >> filespaces that haven't been backed up in > x days.  I've had the basic
> >> query from the Filespaces table working for years, but now I'm trying to
> >> include the total object count from the Occupancy table for each
> filespace,
> >> and I'm not adept enough at query writing to do that.  I suspect I need
> >> some flavor of join but not sure which one.
> >>
> >> Here was my first attempt, more to show what I'm trying to do, it
> >> obviously isn't working.  If anyone has this working and is willing to
> >> share, I'd appreciate it.
> >>
> >> SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
> >> FS.Filespace_ID, DAYS(Current_Date)-DAYS(FS.Backup_End) AS Age,
> >> SUM(OC.Num_Files) FROM Filespaces FS, Occupancy OC WHERE
> >> FS.Filespace_ID=OC.Filespace_ID AND FS.filespace_id=OC.filespace_id AND
> >> DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit
> >>
> >> Steve Schaub
> >> Systems Eng II, Backup & Recovery
> >> BlueCross BlueShield of Tennessee
> >>
>
> --
> Hello World.David Bronder - Systems
> Architect
> Segmentation Fault  ITS-EI, Univ. of
> Iowa
> Core dumped, disk trashed, quota filled, soda warm.
> david-bron...@uiowa.edu
>

Re: Query help joining 2 tables

[Bronder, David M]

I think you can do it without the explicit join (I'm sure an actual SQL
expert could explain the difference).  (I also added some formatting of the
age and occupancy output):

  SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, -
 FS.Filespace_ID, SUM(OC.Num_Files) as NUM_FILES, -
 FS.Age || ' days' as "LAST_BACKUP" -
  FROM (SELECT Node_Name, Filespace_Name, Filespace_ID, -
   DAYS(Current_Date)-DAYS(Backup_End) AS Age -
FROM Filespaces -
WHERE days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS, -
   Occupancy OC -
  WHERE FS.Filespace_ID=OC.Filespace_ID -
  GROUP BY FS.Node_Name, FS.Filespace_Name, FS.Filespace_ID, FS.Age -
  ORDER BY FS.Node_Name


If it's OK to report the date of the last backup completion instead of the
number of days since the last backup, the following is a slightly simpler
query (you could also cast/trim the time out of the end date):

  SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, -
 FS.Filespace_ID, SUM(OC.Num_Files) as NUM_FILES, FS.Backup_End -
  FROM Filespaces FS, Occupancy OC -
  WHERE FS.Filespace_ID=OC.Filespace_ID and -
DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit -
  GROUP BY FS.Node_Name, FS.Filespace_Name, FS.Filespace_ID, FS.Backup_End -
  ORDER BY FS.Node_Name

=Dave


On 1/15/20 2:00 PM, Hall, Lynn wrote:
> SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
> FS.Filespace_ID, FS.Age, SUM(OC.Num_Files) FROM (SELECT Node_Name,
> Filespace_Name, Filespace_ID, DAYS(Current_Date)-DAYS(Backup_End) AS Age
> FROM Filespaces where days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS
> Join Occupancy OC on FS.Filespace_ID=OC.Filespace_ID group by FS.Node_name,
> FS.FILESPACE_NAME, FS.Filespace_ID, FS.AGE ORDER BY FS.NODE_NAME
> 
> 
> Lynn Hall
> Information Technology Specialist IV
> Platform Services
> Office of the Chief Information Officer
> 1305 E Walnut Street | Des Moines, IA 50319  - Mailing
> mobile 515-669-4325
> ocio.iowa.gov
> 
> 
> On Wed, Jan 15, 2020 at 6:45 AM Schaub, Steve 
> wrote:
> 
>> SP 8.1.9
>> I'm trying to write a Powershell script that will return data on all
>> filespaces that haven't been backed up in > x days.  I've had the basic
>> query from the Filespaces table working for years, but now I'm trying to
>> include the total object count from the Occupancy table for each filespace,
>> and I'm not adept enough at query writing to do that.  I suspect I need
>> some flavor of join but not sure which one.
>>
>> Here was my first attempt, more to show what I'm trying to do, it
>> obviously isn't working.  If anyone has this working and is willing to
>> share, I'd appreciate it.
>>
>> SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
>> FS.Filespace_ID, DAYS(Current_Date)-DAYS(FS.Backup_End) AS Age,
>> SUM(OC.Num_Files) FROM Filespaces FS, Occupancy OC WHERE
>> FS.Filespace_ID=OC.Filespace_ID AND FS.filespace_id=OC.filespace_id AND
>> DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit
>>
>> Steve Schaub
>> Systems Eng II, Backup & Recovery
>> BlueCross BlueShield of Tennessee
>>

-- 
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu

Re: Query help joining 2 tables - sum() without GroupBy

[Neil Duffee]

Can't SUM() - a column function - without GroupBy.  Remove the SUM() and the 
query is fine.  Obviously doesn't do what you want but Lynn's response might.

ps.  DB2 probably ignores it but you've repeated the FileSpace_ID comparison in 
the Where clause.

-->  signature = 8 lines follows  <
Neil Duffee, Joe Sysprog, uOttawa, Ont, Canada
Telephone: 1 613 562 5800 x4585
mailto: Nduffee of uOttawa.ca  http:/ /aix1.uOttawa.ca/ ~nduffee
"How *do* you plan for something like that?"  Guardian Bob, Reboot
"For every action, there is an equal and opposite criticism."
"Systems Programming: Guilty, until proven innocent"  John Norgauer 2004
"Schrodinger's backup: The condition of any backup is unknown until a restore 
is attempted."  John McKown 2015

-Original Message-----
From: Schaub, Steve  
Sent: January 15, 2020 7:43 AM
Subject: Query help joining 2 tables

SP 8.1.9
I'm trying to write a Powershell script that will return data on all filespaces 
that haven't been backed up in > x days.  I've had the basic query from the 
Filespaces table working for years, but now I'm trying to include the total 
object count from the Occupancy table for each filespace, and I'm not adept 
enough at query writing to do that.  I suspect I need some flavor of join but 
not sure which one.

Here was my first attempt, more to show what I'm trying to do, it obviously 
isn't working.  If anyone has this working and is willing to share, I'd 
appreciate it.

SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, 
FS.Filespace_ID, DAYS(Current_Date)-DAYS(FS.Backup_End) AS Age, 
SUM(OC.Num_Files) FROM Filespaces FS, Occupancy OC WHERE 
FS.Filespace_ID=OC.Filespace_ID AND FS.filespace_id=OC.filespace_id AND 
DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit

Steve Schaub
Systems Eng II, Backup & Recovery
BlueCross BlueShield of Tennessee

Re: Query help joining 2 tables

[Hall, Lynn]

SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
FS.Filespace_ID, FS.Age, SUM(OC.Num_Files) FROM (SELECT Node_Name,
Filespace_Name, Filespace_ID, DAYS(Current_Date)-DAYS(Backup_End) AS Age
FROM Filespaces where days(Current_Date)-DAYS(Backup_End)>$myAgeLimit) FS
Join Occupancy OC on FS.Filespace_ID=OC.Filespace_ID group by FS.Node_name,
FS.FILESPACE_NAME, FS.Filespace_ID, FS.AGE ORDER BY FS.NODE_NAME





[image: OCIO-logo-Transparent.png] 



Lynn Hall

Information Technology Specialist IV

Platform Services

Office of the Chief Information Officer

1305 E Walnut Street | Des Moines, IA 50319  - Mailing

mobile 515-669-4325

ocio.iowa.gov

[image: social media icons_Twitter cir.png]
[image:
social media icons_LinkedIn cir.png]



On Wed, Jan 15, 2020 at 6:45 AM Schaub, Steve 
wrote:

> SP 8.1.9
> I'm trying to write a Powershell script that will return data on all
> filespaces that haven't been backed up in > x days.  I've had the basic
> query from the Filespaces table working for years, but now I'm trying to
> include the total object count from the Occupancy table for each filespace,
> and I'm not adept enough at query writing to do that.  I suspect I need
> some flavor of join but not sure which one.
>
> Here was my first attempt, more to show what I'm trying to do, it
> obviously isn't working.  If anyone has this working and is willing to
> share, I'd appreciate it.
>
> SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,
> FS.Filespace_ID, DAYS(Current_Date)-DAYS(FS.Backup_End) AS Age,
> SUM(OC.Num_Files) FROM Filespaces FS, Occupancy OC WHERE
> FS.Filespace_ID=OC.Filespace_ID AND FS.filespace_id=OC.filespace_id AND
> DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit
>
> Steve Schaub
> Systems Eng II, Backup & Recovery
> BlueCross BlueShield of Tennessee
>
>
>
>
> --
> Please see the following link for the BlueCross BlueShield of Tennessee
> E-mail disclaimer:
> https://www.bcbst.com/about/our-company/corporate-governance/privacy-security/email-policy.page
> <
> https://www.bcbst.com/about/our-company/corporate-governance/privacy-security/email-policy.page
> >
>

Query help joining 2 tables

[Schaub, Steve]

SP 8.1.9
I'm trying to write a Powershell script that will return data on all filespaces 
that haven't been backed up in > x days.  I've had the basic query from the 
Filespaces table working for years, but now I'm trying to include the total 
object count from the Occupancy table for each filespace, and I'm not adept 
enough at query writing to do that.  I suspect I need some flavor of join but 
not sure which one.

Here was my first attempt, more to show what I'm trying to do, it obviously 
isn't working.  If anyone has this working and is willing to share, I'd 
appreciate it.

SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, 
FS.Filespace_ID, DAYS(Current_Date)-DAYS(FS.Backup_End) AS Age, 
SUM(OC.Num_Files) FROM Filespaces FS, Occupancy OC WHERE 
FS.Filespace_ID=OC.Filespace_ID AND FS.filespace_id=OC.filespace_id AND 
DAYS(Current_Date)-DAYS(FS.Backup_End)>$myAgeLimit

Steve Schaub
Systems Eng II, Backup & Recovery
BlueCross BlueShield of Tennessee



--
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  
https://www.bcbst.com/about/our-company/corporate-governance/privacy-security/email-policy.page
 

SV: [ADSM-L] Support and help to SPP

[Leif Torstensen]

THK ! that page i didn't know

Med venlig hilsen / Best regards
 
Leif Torstensen
Backup Technician

 

-Oprindelig meddelelse-
Fra: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] På vegne af Andrew 
Raibeck
Sendt: 23. november 2017 13:29
Til: ADSM-L@VM.MARIST.EDU
Emne: Re: [ADSM-L] Support and help to SPP

Hi,

According to this web page:

https://www.ibm.com/developerworks/community/groups/service/html/communitystart?communityUuid=12565c59-628b-4e53-aa2c-458a93e90d81

You can obtain trial support by sending email to plush...@us.ibm.com.

Best regards,

Andy



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

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

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

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

"ADSM: Dist Stor Manager"  wrote on 2017-11-23
02:40:29:

> From: Leif Torstensen 
> To: ADSM-L@VM.MARIST.EDU
> Date: 2017-11-23 06:28
> Subject: Support and help to SPP
> Sent by: "ADSM: Dist Stor Manager" 
>
> Hi
>
> Anyone know how to get some support to SPP (Spectrum Protect Plus).
> Try to test functionality, both offload to Spectrum Protect and file 
> cataloging, but got lots off errors.
>
> Try to find out how communications flows and what port to have open in 
> a firewall environment and how to read logfiles to different jobs. 
> Really need a drawing off the different ports to have open on 
> different Vlan's: SPP to HyperV, SPP to Vstorage server, SPP to Vcenter.
>
> Try to put in support case, but the doesn't seems to have licens yet 
> to open PMR
>
> Med venlig hilsen / Best regards
>
>
> Leif Torstensen
> Athena IT Group
>

Re: Support and help to SPP

[Andrew Raibeck]

Hi,

According to this web page:

https://www.ibm.com/developerworks/community/groups/service/html/communitystart?communityUuid=12565c59-628b-4e53-aa2c-458a93e90d81

You can obtain trial support by sending email to plush...@us.ibm.com.

Best regards,

Andy



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

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

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

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

"ADSM: Dist Stor Manager"  wrote on 2017-11-23
02:40:29:

> From: Leif Torstensen 
> To: ADSM-L@VM.MARIST.EDU
> Date: 2017-11-23 06:28
> Subject: Support and help to SPP
> Sent by: "ADSM: Dist Stor Manager" 
>
> Hi
>
> Anyone know how to get some support to SPP (Spectrum Protect Plus).
> Try to test functionality, both offload to Spectrum Protect and file
> cataloging, but got lots off errors.
>
> Try to find out how communications flows and what port to have open
> in a firewall environment and how to read logfiles to different
> jobs. Really need a drawing off the different ports to have open on
> different Vlan's: SPP to HyperV, SPP to Vstorage server, SPP to Vcenter.
>
> Try to put in support case, but the doesn't seems to have licens yet
> to open PMR
>
> Med venlig hilsen / Best regards
>
>
> Leif Torstensen
> Athena IT Group
>

Support and help to SPP

[Leif Torstensen]

Hi

Anyone know how to get some support to SPP (Spectrum Protect Plus). Try to test 
functionality, both offload to Spectrum Protect and file cataloging, but got 
lots off errors.

Try to find out how communications flows and what port to have open in a 
firewall environment and how to read logfiles to different jobs. Really need a 
drawing off the different ports to have open on different Vlan's: SPP to 
HyperV, SPP to Vstorage server, SPP to Vcenter.

Try to put in support case, but the doesn't seems to have licens yet to open PMR

Med venlig hilsen / Best regards


Leif Torstensen
Athena IT Group

help troubleshooting a vm that won't gbackup

[Lee, Gary]

I have two VMs exhibiting the same errors.
Extract from dsmerror.log follows:

08/15/2017 19:37:26 ANS9365E VMware vStorage API error for virtual machine 
'fmc-edge'.
   TSM function name : VixDiskLib_Read
   TSM file  : vmvddksdk.cpp (2930)
   API return code   : 14009
   API error message : The server refused connection
08/15/2017 19:37:26 ANS0361I DIAG: VmReadVDDK(): Read failed: vddksdkRead() 
rc=-1, startSector=38871040, numSectorsToRead=8192
08/15/2017 19:37:26 ANS0361I DIAG: VmReadVDDK(): retrying vddk write operation 
for up to 120 seconds.

These repeat until the backup fails after 12 retries.
Our vmware admin says he doesn't see anything.
Is there a place I can look further, or have him check?

Google results were that it was an indication of tsm server overload, so reduce 
the number of parallel sessions.
Tried that with no change.

All other VMs backup normally.

Script help

[rou...@univ.haifa.ac.il]

Hi to all

Need a little help with this script below , need to get the summary amount 
backup  result for the node .

Now I got a lot of entries from this script as:

Protect: POSTBACK>run q_obj_0 IHPPROD_ORA

Nodename  Date (D/M/Y)  Begin timeEnd time  
Elapsed time in Minutes  Num Obj Num Obj Failed  Bytes
- - - - 
 --- --- ---
IHPPROD_ORA   2017-07-1810.00.20  10.04.21  4   
 1   0   5 Gb
IHPPROD_ORA   2017-07-1810.00.23  10.05.14  4   
 1   0   6 Gb
IHPPROD_ORA   2017-07-1810.05.23  10.06.22  0   
 1   0   822 Mb
IHPPROD_ORA   2017-07-1810.00.22  10.07.00  6   
 1   0   10 Gb
IHPPROD_ORA   2017-07-1810.07.06  10.08.59  1   
 1   0   3 Gb
IHPPROD_ORA   2017-07-1810.06.29  10.09.26  2   
 1   0   4 Gb
IHPPROD_ORA   2017-07-1810.00.19  10.11.17  10  
 1   0   17 Gb
IHPPROD_ORA   2017-07-1810.04.29  10.11.23  6   
 1   0   9 Gb
IHPPROD_ORA   2017-07-1810.09.10  10.12.01  2   
 1   0   4 Gb
IHPPROD_ORA   2017-07-1810.09.36  10.12.33  2   
 1   0   4 Gb
IHPPROD_ORA   2017-07-1810.11.21  10.13.47  2   
 1   0   4 Gb

Want to get:

Nodename  Date (D/M/Y)  Begin timeEnd time  
Elapsed time in Minutes  Num Obj Num Obj Failed  Bytes
- --
- --- 
--- ---
IHPPROD_ORA   2017-07-1810.00.20  10.13.47  
39 11   
0   66.8 Gb


The script is:

set sqlmathmode round
set sqldatetimeformat eur
select cast(entity as varchar(16)) as "Nodename", -
cast(date(start_time) as varchar(12)) as "Date (D/M/Y)", -
cast(time(start_time) as varchar(12)) as "Begin time", -
cast(time(end_time) as varchar(12)) as "End time", -
cast(timestampdiff(4,char(end_time-start_time)) as varchar(16)) as "Elapsed 
time in Minutes" , -
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,'07:00:00') and -
 start_time<=timestamp(current_date,'23:59:00') and -
 successful='YES' -
 and entity like upper('%%$1%%') -
   group by entity,start_time,end_time

T.I.A Best Regards

Robert

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

Help running commands via the TSM REST api

[Jakob Jóhannes Sigurðsson]

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: Convert stg help

[Stefan Folkerts]

Oh, and i've seen database grow about 30-40% and need a database
backup/restore after the conversion to lose about 50% of their size.

This might be the most important thing to know, and the reset conversion
command.

On Mon, Oct 31, 2016 at 3:40 PM, Stefan Folkerts 
wrote:

> the basics.
> Make 100% sure no procs run on the old pool, reclaims etc, all must be
> stopped and removed from housekeeping.
> Change all to be converted copygroups to point to the new pool, double
> check that stuff too. :-)
>
> "q conversion" to follow progres
> "reset conversion" to reset conversion.
> You will need this reset conversion if something (or someone) did in fact
> start (for example) a reclaim on the old pool, this reclaim locks volumes
> and can cause data to be skipped during conversion, the reset will make it
> so that it can still convert this data.
>
> It's pretty fast and doesn't seem to impact backups/restores other than
> making them a bit slower.
>
>
> On Sat, Oct 29, 2016 at 6:11 PM, Robert Ouzen 
> wrote:
>
>> Hello All
>>
>> I want to begin the process CONVERT STG from File to   Directory  om my
>> TSM server version 7.1.7.0 .
>>
>> Any suggestions , tips as when to run the convert process, preparation to
>> do about defining the directory storage etc etc…
>>
>> Any help will be really appreciate….
>>
>> T.I.A  Best Regards
>>
>> Robert
>>
>
>

Re: Convert stg help

[Stefan Folkerts]

the basics.
Make 100% sure no procs run on the old pool, reclaims etc, all must be
stopped and removed from housekeeping.
Change all to be converted copygroups to point to the new pool, double
check that stuff too. :-)

"q conversion" to follow progres
"reset conversion" to reset conversion.
You will need this reset conversion if something (or someone) did in fact
start (for example) a reclaim on the old pool, this reclaim locks volumes
and can cause data to be skipped during conversion, the reset will make it
so that it can still convert this data.

It's pretty fast and doesn't seem to impact backups/restores other than
making them a bit slower.


On Sat, Oct 29, 2016 at 6:11 PM, Robert Ouzen 
wrote:

> Hello All
>
> I want to begin the process CONVERT STG from File to   Directory  om my
> TSM server version 7.1.7.0 .
>
> Any suggestions , tips as when to run the convert process, preparation to
> do about defining the directory storage etc etc…
>
> Any help will be really appreciate….
>
> T.I.A  Best Regards
>
> Robert
>

Convert stg help

[Robert Ouzen]

Hello All

I want to begin the process CONVERT STG from File to   Directory  om my TSM 
server version 7.1.7.0 .

Any suggestions , tips as when to run the convert process, preparation to do 
about defining the directory storage etc etc…

Any help will be really appreciate….

T.I.A  Best Regards

Robert

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<mailto: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<mailto: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

Help to Operational Report.

[Bo Nielsen]

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<mailto:boa...@dtu.dk>

Re: Script help

[Paul van Dongen]

Hi Robert, 

Maybe something like this?

SELECT cast((entity) as char(36)) as "Node 
Adsm2",cast(substr(address,1,locate_in_string(address,':')-1) as char(20)) , 
DATE(start_time) as DATE, cast((activity) as char(15)) as OPERATION, 
cast(float(SUM(bytes))/1024/1024/1024 as DEC(8,1)) as GB FROM summary WHERE  
activity='RETRIEVE' OR activity='RESTORE' GROUP BY 
entity,substr(address,1,locate_in_string(address,':')-1),DATE(start_time),activity
 ORDER BY DATE


Met vriendelijke groet / With kind regards,
Paul van Dongen

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Robert 
Ouzen
Sent: 24 September 2016 07:55
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Script help

Hi  to all


I have this script to receive information about restore and retrieve activity.

SELECT cast((entity) as char(36)) as "Node Adsm2" , DATE(start_time) as DATE, 
cast((activity) as char(15)) as OPERATION, 
cast(float(SUM(bytes))/1024/1024/1024 as DEC(8,1)) as GB FROM summary WHERE  
activity='RETRIEVE' OR activity='RESTORE' GROUP BY 
entity,DATE(start_time),activity ORDER BY DATE   ESC

I want to add ADDRESS  , field in summary table too.

But when I added it I got a lot of entries of each ADDRESS  even when I added 
ADDRESS to GROUP BY

Any idea to get for a single  ADDRESS ?

Best Regards

Robert

Script help

[Robert Ouzen]

Hi  to all


I have this script to receive information about restore and retrieve activity.

SELECT cast((entity) as char(36)) as "Node Adsm2" , DATE(start_time) as DATE, 
cast((activity) as char(15)) as OPERATION, 
cast(float(SUM(bytes))/1024/1024/1024 as DEC(8,1)) as GB FROM summary WHERE  
activity='RETRIEVE' OR activity='RESTORE' GROUP BY 
entity,DATE(start_time),activity ORDER BY DATE   ESC

I want to add ADDRESS  , field in summary table too.

But when I added it I got a lot of entries of each ADDRESS  even when I added 
ADDRESS to GROUP BY

Any idea to get for a single  ADDRESS ?

Best Regards

Robert

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 [mail

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
> > <https://urldefense.proofpoint.com/v2/url?u=https-3A__urldefense&d=DQI
> > BaQ&c=AzgFQeXLLKhxSQaoFCm29A&r=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJj
> > Ffxw&m=5PRblP2zIuEBKbqOWcmYmtDqOHr

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 
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__urldefense&d=DQI
> 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 o

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 
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__urldefense&d=DQI
> 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 a

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 <https://urldefense.
> 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 
<https://urldefense.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.

Help with DFS backups

[Zoltan Forray]

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 http://infosecurity.vcu.edu/phishing.html

Re: Basic select help

[Skylar Thompson]

Not quite sure why that query is not working, but LEFT OUTER JOIN works
fine for me:

SELECT n.node_name FROM nodes n LEFT OUTER JOIN filespaces f ON 
n.node_name=f.node_name WHERE f.node_name IS NULL

On Tue, Aug 23, 2016 at 12:58:47PM +, Loon, Eric van (ITOPT3) - KLM wrote:
> Hi David!
> Your query doesn't work either. I was puzzling too with Shawn's SQL query and 
> I don't understand why it isn't working.
> 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 
> David Ehresman
> Sent: dinsdag 23 augustus 2016 14:13
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: Basic select help
>
> I think this should do what you want:
>
> select node_name  from nodes where node_name not in (select node_name from 
> filespaces)
>
> David
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
> Shawn Drew
> Sent: Monday, August 22, 2016 8:00 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Basic select help
>
> I am trying to get a list of nodes that have no filespaces and I am getting 
> stuck on what seems to be a very basic select statement.  Can someone tell me 
> where I am going wrong?
> The way I understand it, the select should at least show the node I just 
> created with no filespaces.
>
>
> tsm: TSM1500>reg n shawntest  do=admin userid=none ANR2060I Node 
> SHAWNTEST registered in policy domain ADMIN.
>
> tsm: TSM1500>select node_name from nodes where node_name NOT IN (select 
> distinct(node_name) from filespaces) ANR2034E SELECT: No match found using 
> this criteria.
> ANS8001I Return code 11.
> 
> 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
> 
>   

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

Re: Basic select help

[Loon, Eric van (ITOPT3) - KLM]

Hi David!
Your query doesn't work either. I was puzzling too with Shawn's SQL query and I 
don't understand why it isn't working.
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 David 
Ehresman
Sent: dinsdag 23 augustus 2016 14:13
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Basic select help

I think this should do what you want:

select node_name  from nodes where node_name not in (select node_name from 
filespaces)

David

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Shawn 
Drew
Sent: Monday, August 22, 2016 8:00 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Basic select help

I am trying to get a list of nodes that have no filespaces and I am getting 
stuck on what seems to be a very basic select statement.  Can someone tell me 
where I am going wrong?
The way I understand it, the select should at least show the node I just 
created with no filespaces.


tsm: TSM1500>reg n shawntest  do=admin userid=none ANR2060I Node SHAWNTEST 
registered in policy domain ADMIN.
 
tsm: TSM1500>select node_name from nodes where node_name NOT IN (select 
distinct(node_name) from filespaces) ANR2034E SELECT: No match found using this 
criteria.
ANS8001I Return code 11.

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: Basic select help

[David Ehresman]

I think this should do what you want:

select node_name  from nodes where node_name not in (select node_name from 
filespaces)

David

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Shawn 
Drew
Sent: Monday, August 22, 2016 8:00 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Basic select help

I am trying to get a list of nodes that have no filespaces and I am getting 
stuck on what seems to be a very basic select statement.  Can someone tell me 
where I am going wrong?
The way I understand it, the select should at least show the node I just 
created with no filespaces.


tsm: TSM1500>reg n shawntest  do=admin userid=none
ANR2060I Node SHAWNTEST registered in policy domain ADMIN.
 
tsm: TSM1500>select node_name from nodes where node_name NOT IN (select 
distinct(node_name) from filespaces)
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

Basic select help

[Shawn Drew]

I am trying to get a list of nodes that have no filespaces and I am getting 
stuck on what seems to be a very basic select statement.  Can someone tell me 
where I am going wrong?
The way I understand it, the select should at least show the node I just 
created with no filespaces.


tsm: TSM1500>reg n shawntest  do=admin userid=none
ANR2060I Node SHAWNTEST registered in policy domain ADMIN.
 
tsm: TSM1500>select node_name from nodes where node_name NOT IN (select 
distinct(node_name) from filespaces)
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

Re: need help with TSM for nz backup

[Jeanne Bruno]

Step back.we have a winner.



This is the command that worked:

Objects: sh   /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh



No quotes, but needed the 'sh'.

No permission changes.

And the ./nzbackup worked as well



Thank you all very much!







-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Stef 
Coene
Sent: Tuesday, July 12, 2016 4:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] need help with TSM for nz backup





** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / attachments. 
Never supply UserID/PASSWORD information.





On 07/12/2016 10:26 PM, Jeanne Bruno wrote:

> Hello.  I will try that

> I read on one of the ibm tsm sites to use the single quotes.

> Let me try double

Just remove all the quotes and 'sh'.

Just specify the script, but the first line of the script should be #!/bin/sh





Stef

Re: need help with TSM for nz backup

[Remco Post]

and,

don’t use ./nzbackup, but specify the full path, for example: /usr/bin/nzbackup 

> On 13 jul. 2016, at 00:19, Andrew Raibeck  wrote:
> 
> On top of Stef's advice (and if you're still stuck), I would suggest:
> 
> * cd into the directory where the script exists and run it; that is, make
> sure the script itself runs correctly (if you haven't already done this).
> 
> * Verify that the account under which the scheduler runs has proper
> permissions (including 'x') to run the script.
> 
> Regards,
> 
> Andy
> 
> 
> 
> Andrew Raibeck | IBM Spectrum Protect Level 3 | stor...@us.ibm.com
> 
> IBM Tivoli Storage Manager links:
> Product support:
> https://www.ibm.com/support/entry/portal/product/tivoli/tivoli_storage_manager
> 
> Online documentation:
> http://www.ibm.com/support/knowledgecenter/SSGSG7/landing/welcome_ssgsg7.html
> 
> Product Wiki:
> https://www.ibm.com/developerworks/community/wikis/home/wiki/Tivoli%20Storage%20Manager
> 
> "ADSM: Dist Stor Manager"  wrote on 2016-07-12
> 16:48:07:
> 
>> From: Jeanne Bruno 
>> To: ADSM-L@VM.MARIST.EDU
>> Date: 2016-07-12 16:49
>> Subject: Re: need help with TSM for nz backup
>> Sent by: "ADSM: Dist Stor Manager" 
>> 
>> Hello.  yes, the first line of the .sh file is #!/bin/sh
>> 
>> I will try with no quotes and no 'sh'.
>> 
>> Will let you know
>> 
>> -Original Message-
>> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
>> Behalf Of Stef Coene
>> Sent: Tuesday, July 12, 2016 4:40 PM
>> To: ADSM-L@VM.MARIST.EDU
>> Subject: Re: [ADSM-L] need help with TSM for nz backup
>> 
>> 
>> ** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links /
>> attachments. Never supply UserID/PASSWORD information.
>> 
>> 
>> On 07/12/2016 10:26 PM, Jeanne Bruno wrote:
>>> Hello.  I will try that
>>> I read on one of the ibm tsm sites to use the single quotes.
>>> Let me try double
>> Just remove all the quotes and 'sh'.
>> Just specify the script, but the first line of the script should be
> #!/bin/sh
>> 
>> 
>> Stef
>> 

-- 

 Met vriendelijke groeten/Kind Regards,

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

Re: need help with TSM for nz backup

[Andrew Raibeck]

On top of Stef's advice (and if you're still stuck), I would suggest:

* cd into the directory where the script exists and run it; that is, make
sure the script itself runs correctly (if you haven't already done this).

* Verify that the account under which the scheduler runs has proper
permissions (including 'x') to run the script.

Regards,

Andy



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

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

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

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

"ADSM: Dist Stor Manager"  wrote on 2016-07-12
16:48:07:

> From: Jeanne Bruno 
> To: ADSM-L@VM.MARIST.EDU
> Date: 2016-07-12 16:49
> Subject: Re: need help with TSM for nz backup
> Sent by: "ADSM: Dist Stor Manager" 
>
> Hello.  yes, the first line of the .sh file is #!/bin/sh
>
> I will try with no quotes and no 'sh'.
>
> Will let you know
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
> Behalf Of Stef Coene
> Sent: Tuesday, July 12, 2016 4:40 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] need help with TSM for nz backup
>
>
> ** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links /
> attachments. Never supply UserID/PASSWORD information.
>
>
> On 07/12/2016 10:26 PM, Jeanne Bruno wrote:
> > Hello.  I will try that
> > I read on one of the ibm tsm sites to use the single quotes.
> > Let me try double
> Just remove all the quotes and 'sh'.
> Just specify the script, but the first line of the script should be
#!/bin/sh
>
>
> Stef
>

Re: need help with TSM for nz backup

[Howard Nordli]

TSM inherits the return code of the command and if it is not 0 the schedule is 
reported as failed. Your script is returning 2 which according to this is all 
queries failed: 
https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.dbu.doc/r_dbuser_nzsql_exit_codes.html

Try running the script and run "echo $?" You will see 2. Fix the script and 
verify it runs ok.


--howard

> On 12 Jul 2016, at 22:50, Jeanne Bruno  wrote:
> 
> Hello.  yes, the first line of the .sh file is #!/bin/sh
> 
> I will try with no quotes and no 'sh'.
> 
> Will let you know
> 
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Stef 
> Coene
> Sent: Tuesday, July 12, 2016 4:40 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] need help with TSM for nz backup
> 
> 
> ** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / 
> attachments. Never supply UserID/PASSWORD information.
> 
> 
>> On 07/12/2016 10:26 PM, Jeanne Bruno wrote:
>> Hello.  I will try that
>> I read on one of the ibm tsm sites to use the single quotes.
>> Let me try double
> Just remove all the quotes and 'sh'.
> Just specify the script, but the first line of the script should be #!/bin/sh
> 
> 
> Stef

Re: need help with TSM for nz backup

[Jeanne Bruno]

Hello.  yes, the first line of the .sh file is #!/bin/sh

I will try with no quotes and no 'sh'.

Will let you know

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Stef 
Coene
Sent: Tuesday, July 12, 2016 4:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] need help with TSM for nz backup


** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / attachments. 
Never supply UserID/PASSWORD information.


On 07/12/2016 10:26 PM, Jeanne Bruno wrote:
> Hello.  I will try that
> I read on one of the ibm tsm sites to use the single quotes.
> Let me try double
Just remove all the quotes and 'sh'.
Just specify the script, but the first line of the script should be #!/bin/sh


Stef

Re: need help with TSM for nz backup

[Stef Coene]

On 07/12/2016 10:26 PM, Jeanne Bruno wrote:

Hello.  I will try that
I read on one of the ibm tsm sites to use the single quotes.
Let me try double

Just remove all the quotes and 'sh'.
Just specify the script, but the first line of the script should be
#!/bin/sh


Stef

Re: need help with TSM for nz backup

[Jeanne Bruno]

Failed, but different RC:
Executing Operating System command or script:
   "sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh"
07/12/2016 16:30:08 Finished command.  Return code is: 127
07/12/2016 16:30:08 ANS1909E The scheduled command failed.
07/12/2016 16:30:08 ANS1512E Scheduled event 'NETEZZA_WKD' failed.  Return code 
= 127.
07/12/2016 16:30:08 Sending results for scheduled event 'NETEZZA_WKD'.
07/12/2016 16:30:08 Results sent to server for scheduled event 'NETEZZA_WKD'.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew 
Raibeck
Sent: Tuesday, July 12, 2016 4:19 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] need help with TSM for nz backup


** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / attachments. 
Never supply UserID/PASSWORD information.


Hi Jeanne,

What are the backtick (`) and single quote (') doing that surround the OBJECTS 
field? Were you using quotes?

What if you updated the schedule like this, using just regular double quotation 
marks to surround the command?

   upd sch netezza netezza_wkd
objects="sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh"

Best regards,

Andy



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

IBM Tivoli Storage Manager links:
Product support:
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_entry_portal_product_tivoli_tivoli-5Fstorage-5Fmanager&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=OOkk6HR8781TS4G74iyDVaQ4mrF8KxdDapOceVBVJ3U&s=ZThbxKFKxrsgpuvCYsdSgh39wLZ2YDx67jcFFRlWrCg&e=
 

Online documentation:
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ibm.com_support_knowledgecenter_SSGSG7_landing_welcome-5Fssgsg7.html&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=OOkk6HR8781TS4G74iyDVaQ4mrF8KxdDapOceVBVJ3U&s=Yu5Zf2zXAUBd-Lue3EEYR4JGkUnbY_J3D84zRCz-bt4&e=
 

Product Wiki:
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_community_wikis_home_wiki_Tivoli-2520Storage-2520Manager&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=OOkk6HR8781TS4G74iyDVaQ4mrF8KxdDapOceVBVJ3U&s=HC1jKtba2K78-EZJFM0htP0kHZvI4tPdjAwL_JNYjJ8&e=
 

"ADSM: Dist Stor Manager"  wrote on 2016-07-12
15:57:29:

> From: Jeanne Bruno 
> To: ADSM-L@VM.MARIST.EDU
> Date: 2016-07-12 15:58
> Subject: need help with TSM for nz backup Sent by: "ADSM: Dist Stor 
> Manager" 
>
> Hello.   I'm trying to create a new TSM schedule for our Netezza server.
> I want TSM to run the .sh file I created, so I have this:
>
>
>Policy Domain Name: NETEZZA
> Schedule Name: NETEZZA_WKD
>   Description: Netezza Server
>Action: Command
> Subaction:
>   Options:
>   Objects: `sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
>  Priority: 5
>   Start Date/Time: 07/12/2016 15:00:00
>  Duration: 4 Hour(s)
>Maximum Run Time (Minutes): 0
>Schedule Style: Classic
>Period: 1 Day(s)
>   Day of Week: Weekday
> Month:
>
> The scheduler kicks off but fails with these messages:
>
> ANR0406I Session 200168 started for node NETEZZA (Linux x86-64) 
> (Tcp/Ip 10.1.4.246(35323)).
> ANR2579E Schedule NETEZZA_WKD in domain NETEZZA for node NETEZZA 
> failed (return code 2).
> ANR0403I Session 200168 ended for node NETEZZA (Linux x86-64).
> ANR0406I Session 200169 started for node NETEZZA (Linux x86-64) 
> (Tcp/Ip 10.1.4.246(35324)).
>
>
> Schedlog has this:
> 07/12/2016 15:00:41
> Executing Operating System command or script:
>`sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
> 07/12/2016 15:00:41 Finished command.  Return code is: 2
> 07/12/2016 15:00:41 ANS1909E The scheduled command failed.
> 07/12/2016 15:00:41 ANS1512E Scheduled event 'NETEZZA_WKD' failed.
> Return code = 2.
> 07/12/2016 15:00:41 Sending results for scheduled event 'NETEZZA_WKD'.
> 07/12/2016 15:00:41 Results sent to server for scheduled event
'NETEZZA_WKD'.
>
>
> the commands inside the .sh file work from a linux command prompt.
> An example:
> ./nzbackup  -u admin -pw x -db DB   -connector Tivoli -
> connectorArgs "TSM_PASSWD=XX"  -cumulative  -v >> 
> cum_histdb.log
>
>
> I have a host and a proxy node, and I have both associated with the 
> Schedule, but I'm not sure if I need both associated.  But the 
> scheduler fails either way.
>
> Anyone ever see this or can lead me in the direction on how to
resolve
>
>
> 
> Jeannie Bruno
> Senior Systems Analyst
> jbr...@cenhud.com<mailto:jbr...@cenhud.com>
> Central Hudson Gas & Electric
> (845) 486-5780
>

Re: need help with TSM for nz backup

[Jeanne Bruno]

Hello.  I will try that
I read on one of the ibm tsm sites to use the single quotes.
Let me try double

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew 
Raibeck
Sent: Tuesday, July 12, 2016 4:19 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] need help with TSM for nz backup


** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / attachments. 
Never supply UserID/PASSWORD information.


Hi Jeanne,

What are the backtick (`) and single quote (') doing that surround the OBJECTS 
field? Were you using quotes?

What if you updated the schedule like this, using just regular double quotation 
marks to surround the command?

   upd sch netezza netezza_wkd
objects="sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh"

Best regards,

Andy



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

IBM Tivoli Storage Manager links:
Product support:
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_entry_portal_product_tivoli_tivoli-5Fstorage-5Fmanager&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=OOkk6HR8781TS4G74iyDVaQ4mrF8KxdDapOceVBVJ3U&s=ZThbxKFKxrsgpuvCYsdSgh39wLZ2YDx67jcFFRlWrCg&e=
 

Online documentation:
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ibm.com_support_knowledgecenter_SSGSG7_landing_welcome-5Fssgsg7.html&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=OOkk6HR8781TS4G74iyDVaQ4mrF8KxdDapOceVBVJ3U&s=Yu5Zf2zXAUBd-Lue3EEYR4JGkUnbY_J3D84zRCz-bt4&e=
 

Product Wiki:
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_community_wikis_home_wiki_Tivoli-2520Storage-2520Manager&d=CwIFAg&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=OOkk6HR8781TS4G74iyDVaQ4mrF8KxdDapOceVBVJ3U&s=HC1jKtba2K78-EZJFM0htP0kHZvI4tPdjAwL_JNYjJ8&e=
 

"ADSM: Dist Stor Manager"  wrote on 2016-07-12
15:57:29:

> From: Jeanne Bruno 
> To: ADSM-L@VM.MARIST.EDU
> Date: 2016-07-12 15:58
> Subject: need help with TSM for nz backup Sent by: "ADSM: Dist Stor 
> Manager" 
>
> Hello.   I'm trying to create a new TSM schedule for our Netezza server.
> I want TSM to run the .sh file I created, so I have this:
>
>
>Policy Domain Name: NETEZZA
> Schedule Name: NETEZZA_WKD
>   Description: Netezza Server
>Action: Command
> Subaction:
>   Options:
>   Objects: `sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
>  Priority: 5
>   Start Date/Time: 07/12/2016 15:00:00
>  Duration: 4 Hour(s)
>Maximum Run Time (Minutes): 0
>Schedule Style: Classic
>Period: 1 Day(s)
>   Day of Week: Weekday
> Month:
>
> The scheduler kicks off but fails with these messages:
>
> ANR0406I Session 200168 started for node NETEZZA (Linux x86-64) 
> (Tcp/Ip 10.1.4.246(35323)).
> ANR2579E Schedule NETEZZA_WKD in domain NETEZZA for node NETEZZA 
> failed (return code 2).
> ANR0403I Session 200168 ended for node NETEZZA (Linux x86-64).
> ANR0406I Session 200169 started for node NETEZZA (Linux x86-64) 
> (Tcp/Ip 10.1.4.246(35324)).
>
>
> Schedlog has this:
> 07/12/2016 15:00:41
> Executing Operating System command or script:
>`sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
> 07/12/2016 15:00:41 Finished command.  Return code is: 2
> 07/12/2016 15:00:41 ANS1909E The scheduled command failed.
> 07/12/2016 15:00:41 ANS1512E Scheduled event 'NETEZZA_WKD' failed.
> Return code = 2.
> 07/12/2016 15:00:41 Sending results for scheduled event 'NETEZZA_WKD'.
> 07/12/2016 15:00:41 Results sent to server for scheduled event
'NETEZZA_WKD'.
>
>
> the commands inside the .sh file work from a linux command prompt.
> An example:
> ./nzbackup  -u admin -pw x -db DB   -connector Tivoli -
> connectorArgs "TSM_PASSWD=XX"  -cumulative  -v >> 
> cum_histdb.log
>
>
> I have a host and a proxy node, and I have both associated with the 
> Schedule, but I'm not sure if I need both associated.  But the 
> scheduler fails either way.
>
> Anyone ever see this or can lead me in the direction on how to
resolve
>
>
> 
> Jeannie Bruno
> Senior Systems Analyst
> jbr...@cenhud.com<mailto:jbr...@cenhud.com>
> Central Hudson Gas & Electric
> (845) 486-5780
>

Re: need help with TSM for nz backup

[Andrew Raibeck]

Hi Jeanne,

What are the backtick (`) and single quote (') doing that surround the
OBJECTS field? Were you using quotes?

What if you updated the schedule like this, using just regular double
quotation marks to surround the command?

   upd sch netezza netezza_wkd
objects="sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh"

Best regards,

Andy



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

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

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

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

"ADSM: Dist Stor Manager"  wrote on 2016-07-12
15:57:29:

> From: Jeanne Bruno 
> To: ADSM-L@VM.MARIST.EDU
> Date: 2016-07-12 15:58
> Subject: need help with TSM for nz backup
> Sent by: "ADSM: Dist Stor Manager" 
>
> Hello.   I'm trying to create a new TSM schedule for our Netezza server.
> I want TSM to run the .sh file I created, so I have this:
>
>
>Policy Domain Name: NETEZZA
> Schedule Name: NETEZZA_WKD
>   Description: Netezza Server
>Action: Command
> Subaction:
>   Options:
>   Objects: `sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
>  Priority: 5
>   Start Date/Time: 07/12/2016 15:00:00
>  Duration: 4 Hour(s)
>Maximum Run Time (Minutes): 0
>Schedule Style: Classic
>Period: 1 Day(s)
>   Day of Week: Weekday
> Month:
>
> The scheduler kicks off but fails with these messages:
>
> ANR0406I Session 200168 started for node NETEZZA (Linux x86-64)
> (Tcp/Ip 10.1.4.246(35323)).
> ANR2579E Schedule NETEZZA_WKD in domain NETEZZA for node NETEZZA
> failed (return code 2).
> ANR0403I Session 200168 ended for node NETEZZA (Linux x86-64).
> ANR0406I Session 200169 started for node NETEZZA (Linux x86-64)
> (Tcp/Ip 10.1.4.246(35324)).
>
>
> Schedlog has this:
> 07/12/2016 15:00:41
> Executing Operating System command or script:
>`sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
> 07/12/2016 15:00:41 Finished command.  Return code is: 2
> 07/12/2016 15:00:41 ANS1909E The scheduled command failed.
> 07/12/2016 15:00:41 ANS1512E Scheduled event 'NETEZZA_WKD' failed.
> Return code = 2.
> 07/12/2016 15:00:41 Sending results for scheduled event 'NETEZZA_WKD'.
> 07/12/2016 15:00:41 Results sent to server for scheduled event
'NETEZZA_WKD'.
>
>
> the commands inside the .sh file work from a linux command prompt.
> An example:
> ./nzbackup  -u admin -pw x -db DB   -connector Tivoli -
> connectorArgs "TSM_PASSWD=XX"  -cumulative  -v >> cum_histdb.log
>
>
> I have a host and a proxy node, and I have both associated with the
> Schedule, but I'm not sure if I need both associated.  But the
> scheduler fails either way.
>
> Anyone ever see this or can lead me in the direction on how to
resolve
>
>
> 
> Jeannie Bruno
> Senior Systems Analyst
> jbr...@cenhud.com<mailto:jbr...@cenhud.com>
> Central Hudson Gas & Electric
> (845) 486-5780
>

need help with TSM for nz backup

[Jeanne Bruno]

Hello.   I'm trying to create a new TSM schedule for our Netezza server.
I want TSM to run the .sh file I created, so I have this:


   Policy Domain Name: NETEZZA
Schedule Name: NETEZZA_WKD
  Description: Netezza Server
   Action: Command
Subaction:
  Options:
  Objects: `sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
 Priority: 5
  Start Date/Time: 07/12/2016 15:00:00
 Duration: 4 Hour(s)
   Maximum Run Time (Minutes): 0
   Schedule Style: Classic
   Period: 1 Day(s)
  Day of Week: Weekday
Month:

The scheduler kicks off but fails with these messages:

ANR0406I Session 200168 started for node NETEZZA (Linux x86-64) (Tcp/Ip 
10.1.4.246(35323)).
ANR2579E Schedule NETEZZA_WKD in domain NETEZZA for node NETEZZA failed (return 
code 2).
ANR0403I Session 200168 ended for node NETEZZA (Linux x86-64).
ANR0406I Session 200169 started for node NETEZZA (Linux x86-64) (Tcp/Ip 
10.1.4.246(35324)).


Schedlog has this:
07/12/2016 15:00:41
Executing Operating System command or script:
   `sh /nz/kit.7.2.1.1-P1/bin/daily_tsm.sh'
07/12/2016 15:00:41 Finished command.  Return code is: 2
07/12/2016 15:00:41 ANS1909E The scheduled command failed.
07/12/2016 15:00:41 ANS1512E Scheduled event 'NETEZZA_WKD' failed.  Return code 
= 2.
07/12/2016 15:00:41 Sending results for scheduled event 'NETEZZA_WKD'.
07/12/2016 15:00:41 Results sent to server for scheduled event 'NETEZZA_WKD'.


the commands inside the .sh file work from a linux command prompt.  An example:
./nzbackup  -u admin -pw x -db DB   -connector Tivoli -connectorArgs 
"TSM_PASSWD=XX"  -cumulative  -v >> cum_histdb.log


I have a host and a proxy node, and I have both associated with the Schedule, 
but I'm not sure if I need both associated.  But the scheduler fails either way.

Anyone ever see this or can lead me in the direction on how to resolve



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

restart restore help

[Lee, Gary]

Haven't found this in the client manual.

Can the restart restore command be scheduled? If so, how?

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<mailto: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]<http://computing.haifa.ac.il/>

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

Fw: [ADSM-L] Help on Directory Container

[Ron Delaware]

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



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]<http://computing.haifa.ac.il/>

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

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

Help on Directory Container

[Robert Ouzen]

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

help configuring amazon storage gateway vtl

[Lee, Gary]

Finally have nmore information on our possible vtl configurations.

First, the medium changer / library is either "amazon storage gateway changer" 
or stk l700.
The drives are configured as IBM ult3580-tb5.
These drives are supported by the lin_tape driver.  No problem there.

Looking for help getting the medium changer configured.
Is it possible to use the tsm generic scsi driver for this and use lin_tpae for 
the drives?

Looking at the various manuals, but a little confused.

Thanks for any and all help.

help determining reason why full backup of vm failed

[Lee, Gary]

Tsm server 6.3.4
Client 6.4.2.
Data mover os RHEL 6.5.

Received following:

ANe4174e . . .   failed with return code 4379

Nothing in dsmerror.log at all.

Where to go from hnere?

Antwort: Re: [ADSM-L] Antwort: [ADSM-L] Windows exclude.archive help

[Rainer Holzinger]

Hi Bob,

give that a try:

Object:   \\ed-files\v$\webs\

regards,
Rainer



Von:Bob Booth 
An: ADSM-L@VM.MARIST.EDU
Datum:  14.01.2016 20:28
Betreff:Re: [ADSM-L] Antwort: [ADSM-L] Windows exclude.archive
help
Gesendet von:   "ADSM: Dist Stor Manager" 



On Thu, Jan 14, 2016 at 08:19:15PM +0100, Rainer Holzinger wrote:
> Hi,
>
> did you add the '-subdir=yes' option at the archive command?

Yes, sorry, I forgot to include the schedule options:

Action: Archive
Subaction:
Options: -subdir=yes
Objects: \\ed-files\v$\webs

>
> regards,
> Rainer
>
>
>
> Von:Bob Booth 
> An: ADSM-L@VM.MARIST.EDU
> Datum:  14.01.2016 19:59
> Betreff:[ADSM-L] Windows exclude.archive help
> Gesendet von:   "ADSM: Dist Stor Manager" 
>
>
>
> Hello all!
>
> I'm trying to help a remote admin that is trying to exclude/include
things
> in windows filesystem for a scheduled monthly archive.
>
> I will admit that I am not very familiar at all with how windows
excludes
> work, so I have not been much help, so I am asking the gurus!
>
> He has a windows filesystem:  \\ed-files\v$\webs  and he only wants to
> archive certain files.  Here is the relevant part of the opt file:
>
> EXCLUDE.ARCHIVE "*.*"
> EXCLUDE.ARCHIVE "\\ed-files\v$\webs\...\*"
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\cdl\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\ceep\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\clas\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\dell-d\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecap\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecrp\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\eic\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\facts\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\idec\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecam\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecamintranet\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\iel\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoisparents\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoispip\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\intranet\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\i-parents\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\npen\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\readyweb\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\resnet\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\sharingavision\html\...\*" 2YRLOCAL
>
> query inclexcl where 'webs' shows up is below:
>
> Include Archive   \\ed-files\webs\sharingavision\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\resnet\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\readyweb\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\npen\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\i-parents\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\intranet\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\illinoispip\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\illinoisparents\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\iel\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\iecamintranet\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\iecam\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\idec\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\facts\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\eic\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\ecrp\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\ecap\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\dell-d\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\clas\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\ceep\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\cdl\html\...\* dsm.opt
>
> When the archive gets run by the scheduler, the only thing that gets
> archived
> is the directory \\ed-files\v$\webs and no files.
>
> So, what is the best way to accomplish this.
>
> Thanks as always!

Re: Antwort: [ADSM-L] Windows exclude.archive help

[Bob Booth]

On Thu, Jan 14, 2016 at 08:19:15PM +0100, Rainer Holzinger wrote:
> Hi,
>
> did you add the '-subdir=yes' option at the archive command?

Yes, sorry, I forgot to include the schedule options:

Action: Archive
Subaction:
Options: -subdir=yes
Objects: \\ed-files\v$\webs

>
> regards,
> Rainer
>
>
>
> Von:Bob Booth 
> An: ADSM-L@VM.MARIST.EDU
> Datum:  14.01.2016 19:59
> Betreff:[ADSM-L] Windows exclude.archive help
> Gesendet von:   "ADSM: Dist Stor Manager" 
>
>
>
> Hello all!
>
> I'm trying to help a remote admin that is trying to exclude/include things
> in windows filesystem for a scheduled monthly archive.
>
> I will admit that I am not very familiar at all with how windows excludes
> work, so I have not been much help, so I am asking the gurus!
>
> He has a windows filesystem:  \\ed-files\v$\webs  and he only wants to
> archive certain files.  Here is the relevant part of the opt file:
>
> EXCLUDE.ARCHIVE "*.*"
> EXCLUDE.ARCHIVE "\\ed-files\v$\webs\...\*"
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\cdl\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\ceep\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\clas\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\dell-d\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecap\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecrp\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\eic\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\facts\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\idec\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecam\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecamintranet\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\iel\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoisparents\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoispip\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\intranet\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\i-parents\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\npen\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\readyweb\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\resnet\html\...\*" 2YRLOCAL
> INCLUDE.ARCHIVE "\\ed-files\v$\webs\sharingavision\html\...\*" 2YRLOCAL
>
> query inclexcl where 'webs' shows up is below:
>
> Include Archive   \\ed-files\webs\sharingavision\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\resnet\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\readyweb\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\npen\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\i-parents\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\intranet\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\illinoispip\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\illinoisparents\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\iel\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\iecamintranet\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\iecam\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\idec\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\facts\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\eic\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\ecrp\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\ecap\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\dell-d\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\clas\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\ceep\html\...\* dsm.opt
> Include Archive   \\ed-files\webs\cdl\html\...\* dsm.opt
>
> When the archive gets run by the scheduler, the only thing that gets
> archived
> is the directory \\ed-files\v$\webs and no files.
>
> So, what is the best way to accomplish this.
>
> Thanks as always!

Antwort: [ADSM-L] Windows exclude.archive help

[Rainer Holzinger]

Hi,

did you add the '-subdir=yes' option at the archive command?

regards,
Rainer



Von:Bob Booth 
An: ADSM-L@VM.MARIST.EDU
Datum:  14.01.2016 19:59
Betreff:[ADSM-L] Windows exclude.archive help
Gesendet von:   "ADSM: Dist Stor Manager" 



Hello all!

I'm trying to help a remote admin that is trying to exclude/include things
in windows filesystem for a scheduled monthly archive.

I will admit that I am not very familiar at all with how windows excludes
work, so I have not been much help, so I am asking the gurus!

He has a windows filesystem:  \\ed-files\v$\webs  and he only wants to
archive certain files.  Here is the relevant part of the opt file:

EXCLUDE.ARCHIVE "*.*"
EXCLUDE.ARCHIVE "\\ed-files\v$\webs\...\*"
INCLUDE.ARCHIVE "\\ed-files\v$\webs\cdl\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\ceep\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\clas\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\dell-d\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecap\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecrp\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\eic\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\facts\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\idec\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecam\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecamintranet\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\iel\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoisparents\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoispip\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\intranet\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\i-parents\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\npen\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\readyweb\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\resnet\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\sharingavision\html\...\*" 2YRLOCAL

query inclexcl where 'webs' shows up is below:

Include Archive   \\ed-files\webs\sharingavision\html\...\* dsm.opt
Include Archive   \\ed-files\webs\resnet\html\...\* dsm.opt
Include Archive   \\ed-files\webs\readyweb\html\...\* dsm.opt
Include Archive   \\ed-files\webs\npen\html\...\* dsm.opt
Include Archive   \\ed-files\webs\i-parents\html\...\* dsm.opt
Include Archive   \\ed-files\webs\intranet\html\...\* dsm.opt
Include Archive   \\ed-files\webs\illinoispip\html\...\* dsm.opt
Include Archive   \\ed-files\webs\illinoisparents\html\...\* dsm.opt
Include Archive   \\ed-files\webs\iel\html\...\* dsm.opt
Include Archive   \\ed-files\webs\iecamintranet\html\...\* dsm.opt
Include Archive   \\ed-files\webs\iecam\html\...\* dsm.opt
Include Archive   \\ed-files\webs\idec\html\...\* dsm.opt
Include Archive   \\ed-files\webs\facts\html\...\* dsm.opt
Include Archive   \\ed-files\webs\eic\html\...\* dsm.opt
Include Archive   \\ed-files\webs\ecrp\html\...\* dsm.opt
Include Archive   \\ed-files\webs\ecap\html\...\* dsm.opt
Include Archive   \\ed-files\webs\dell-d\html\...\* dsm.opt
Include Archive   \\ed-files\webs\clas\html\...\* dsm.opt
Include Archive   \\ed-files\webs\ceep\html\...\* dsm.opt
Include Archive   \\ed-files\webs\cdl\html\...\* dsm.opt

When the archive gets run by the scheduler, the only thing that gets
archived
is the directory \\ed-files\v$\webs and no files.

So, what is the best way to accomplish this.

Thanks as always!

Windows exclude.archive help

[Bob Booth]

Hello all!

I'm trying to help a remote admin that is trying to exclude/include things
in windows filesystem for a scheduled monthly archive.

I will admit that I am not very familiar at all with how windows excludes
work, so I have not been much help, so I am asking the gurus!

He has a windows filesystem:  \\ed-files\v$\webs  and he only wants to
archive certain files.  Here is the relevant part of the opt file:

EXCLUDE.ARCHIVE "*.*"
EXCLUDE.ARCHIVE "\\ed-files\v$\webs\...\*"
INCLUDE.ARCHIVE "\\ed-files\v$\webs\cdl\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\ceep\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\clas\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\dell-d\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecap\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\ecrp\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\eic\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\facts\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\idec\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecam\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\iecamintranet\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\iel\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoisparents\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\illinoispip\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\intranet\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\i-parents\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\npen\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\readyweb\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\resnet\html\...\*" 2YRLOCAL
INCLUDE.ARCHIVE "\\ed-files\v$\webs\sharingavision\html\...\*" 2YRLOCAL

query inclexcl where 'webs' shows up is below:

Include Archive   \\ed-files\webs\sharingavision\html\...\* dsm.opt
Include Archive   \\ed-files\webs\resnet\html\...\* dsm.opt
Include Archive   \\ed-files\webs\readyweb\html\...\* dsm.opt
Include Archive   \\ed-files\webs\npen\html\...\* dsm.opt
Include Archive   \\ed-files\webs\i-parents\html\...\* dsm.opt
Include Archive   \\ed-files\webs\intranet\html\...\* dsm.opt
Include Archive   \\ed-files\webs\illinoispip\html\...\* dsm.opt
Include Archive   \\ed-files\webs\illinoisparents\html\...\* dsm.opt
Include Archive   \\ed-files\webs\iel\html\...\* dsm.opt
Include Archive   \\ed-files\webs\iecamintranet\html\...\* dsm.opt
Include Archive   \\ed-files\webs\iecam\html\...\* dsm.opt
Include Archive   \\ed-files\webs\idec\html\...\* dsm.opt
Include Archive   \\ed-files\webs\facts\html\...\* dsm.opt
Include Archive   \\ed-files\webs\eic\html\...\* dsm.opt
Include Archive   \\ed-files\webs\ecrp\html\...\* dsm.opt
Include Archive   \\ed-files\webs\ecap\html\...\* dsm.opt
Include Archive   \\ed-files\webs\dell-d\html\...\* dsm.opt
Include Archive   \\ed-files\webs\clas\html\...\* dsm.opt
Include Archive   \\ed-files\webs\ceep\html\...\* dsm.opt
Include Archive   \\ed-files\webs\cdl\html\...\* dsm.opt

When the archive gets run by the scheduler, the only thing that gets archived
is the directory \\ed-files\v$\webs and no files.

So, what is the best way to accomplish this.

Thanks as always!

Re: All volumes in STGPOOL show as full. Please help.

[Dury, John C.]

We do not have a backup of the DEDUP pool but it is being replicated to a 
different TSM server. The copy stgpool option is disabled.
John


-Original Message-
From: Stef Coene [mailto:stef.co...@docum.org] 
Sent: Thursday, January 14, 2016 8:54 AM
To: ADSM: Dist Stor Manager; Dury, John C.
Subject: Re: All volumes in STGPOOL show as full. Please help.

Hi,

There is one question not asked: do you have a backup of the dedup pool?
Per default, TSM will only reclaim volumes after the data is copied to a copy 
storage pool. You can overrule that in the dsmserv.opt config file.


Stef

Re: All volumes in STGPOOL show as full. Please help.

[Stef Coene]

Hi,

There is one question not asked: do you have a backup of the dedup pool?
Per default, TSM will only reclaim volumes after the data is copied to a copy
storage pool. You can overrule that in the dsmserv.opt config file.


Stef

Re: All volumes in STGPOOL show as full. Please help.

[Ron Delaware]

John,

Do you have enough scratch volumes available in the dedup pool? Could you 
please provide output from these commands: q stg deduppool f=d and  q devc 
 f=d

 
Best Regards,
_

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

 



From:   "Dury, John C." 
To: ADSM-L@VM.MARIST.EDU
Date:   01/13/16 07:02
Subject:[ADSM-L] All volumes in STGPOOL show as full. Please help.
Sent by:"ADSM: Dist Stor Manager" 



We have 2 storage pools. A BACKUPPOOL and a DEDUP pool. All nightly 
backups come into the BACKUPPOOL and then migrate to the DEDUP pool for 
permanent storage. All volumes in the DEDUP pool are showing FULL although 
the pool is only 69% in use. I tried doing a move data on a volume in the 
DEDUP pool to the BACKUPPOOL just to free space so reclamation could run, 
and although it says it ran to successful completion, the volume still 
shows as FULL. So for whatever reason, all volumes in the DEDUP pool are 
never freeing up. I ran an audit on the same volume I tried to the MOVE 
DATA command on and it also ran to successful completion. No idea what is 
going on here but hopefully someone else has an idea. If our BACKUPPOOL 
fills up, we can't back anything up any more and we will have a 
catastrophe. The BACKUPPOOL is roughly 15T  and 15% full and I have no way 
to increase it.
Please reply directly to my email address and list as I am currently 
subscribed as digest only.
TSM Server is 6.3.5.300 on RHEL 5

AW: All volumes in STGPOOL show as full. Please help.

[Rettenberger Sabine]

John,

are you able to define one new volume to DEDUP-Pool?

Mit freundlichem Gruß / Best regards
Sabine Rettenberger

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Rick 
Adamson
Gesendet: Mittwoch, 13. Januar 2016 16:45
An: ADSM-L@VM.MARIST.EDU
Betreff: Re: All volumes in STGPOOL show as full. Please help.

John,
It may help it you provided a detailed listing of the storage pool and 
associated device class.
q stg dedup f=d
q devcl  f=d

-Rick Adamson

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Dury, 
John C.
Sent: Wednesday, January 13, 2016 10:37 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] All volumes in STGPOOL show as full. Please help.

I tried reclamation but it fails since all volume in stgpool DEDUP show as 
full. An audit run to successful completion but volume stays as FULL. Even a 
MOVE DATA of a volume in DEDUP pool runs to successful completion but the 
status stays as FULL.
John


-Original Message-
From: Rettenberger Sabine [mailto:sabine.rettenber...@wolf-heiztechnik.de]
Sent: Wednesday, January 13, 2016 10:35 AM
To: ADSM: Dist Stor Manager
Cc: Dury, John C.
Subject: AW: All volumes in STGPOOL show as full. Please help.

Hi John,

did you try a RECLAIM at the DEDUP-Pool to get the volumes free?
What says an AUDIT VOLUME of the empty volumes?
Are they really empty?

Best regards
Sabine

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Dury, 
John C.
Gesendet: Mittwoch, 13. Januar 2016 16:01
An: ADSM-L@VM.MARIST.EDU
Betreff: All volumes in STGPOOL show as full. Please help.

We have 2 storage pools. A BACKUPPOOL and a DEDUP pool. All nightly backups 
come into the BACKUPPOOL and then migrate to the DEDUP pool for permanent 
storage. All volumes in the DEDUP pool are showing FULL although the pool is 
only 69% in use. I tried doing a move data on a volume in the DEDUP pool to the 
BACKUPPOOL just to free space so reclamation could run, and although it says it 
ran to successful completion, the volume still shows as FULL. So for whatever 
reason, all volumes in the DEDUP pool are never freeing up. I ran an audit on 
the same volume I tried to the MOVE DATA command on and it also ran to 
successful completion. No idea what is going on here but hopefully someone else 
has an idea. If our BACKUPPOOL fills up, we can't back anything up any more and 
we will have a catastrophe. The BACKUPPOOL is roughly 15T  and 15% full and I 
have no way to increase it.
Please reply directly to my email address and list as I am currently subscribed 
as digest only.
TSM Server is 6.3.5.300 on RHEL 5
--
Wolf GmbH
Sitz der Gesellschaft:
Industriestr. 1, D-84048 Mainburg
Registergericht:
Amtsgericht Regensburg HR-B-1453
Vorsitzender des Aufsichtsrates: Alfred Gaffal Geschäftsführung:Bernhard Steppe 
(Sprecher) Christian Amann Gerdewan Jacobs Rudolf Meindl

Telefon +49 8751/74-0
Telefax +49 8751/74-1600
Internet: 
https://urldefense.proofpoint.com/v2/url?u=http-3A__cp.mcafee.com_d_avndzgOcygArhovjsd79EVjupdTdFEK9EEEI6QQn4QkhPNJ6XbNEVppvhd79JBV4QsFIEECN51K9o58dyNYy9evbCQ6No-2Dh4DfBPq9EVZNMQsKfZvAkS7C3hOZRXBQSkTKjvssKqehTbnhIyyHtVPBgY-2DF6lK1FJ4SyrLOb2rPUV5xcQsCXCOD6aDKBOvO59-5FoD2hnAfdQQxa7Z7VP-2D13UAvy2z5jTiVfV2A-5FIjx8HO7CS6nCjow0GhEw43PPh0pGuSHZ3h1a1Ew60i4wI60M5jh1gDkMq8dEq87mPP-2Dd40mf-5Fquq82vDHsrvpdJIlhZP2t&d=CwIFAw&c=AzgFQeXLLKhxSQaoFCm29A&r=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw&m=t_WJZUMfpbbCz1Z1TOWZcQbOxMN4UVDgX3f-5NNq6HM&s=jbYECa5dVyELP0nNRgBGadK4FnBhubqnYXzSYnfowTc&e=
USt-IdNr.: DE811132553
ILN: 40 45013 01
--
Wolf GmbH
Sitz der Gesellschaft:
Industriestr. 1, D-84048 Mainburg
Registergericht:
Amtsgericht Regensburg HR-B-1453
Vorsitzender des Aufsichtsrates: Alfred Gaffal
Geschäftsführung:Bernhard Steppe (Sprecher)
Christian Amann
Gerdewan Jacobs
Rudolf Meindl

Telefon +49 8751/74-0
Telefax +49 8751/74-1600
Internet: www.wolf-heiztechnik.de
USt-IdNr.: DE811132553
ILN: 40 45013 01

Re: All volumes in STGPOOL show as full. Please help.

[Rick Adamson]

John,
It may help it you provided a detailed listing of the storage pool and 
associated device class.
q stg dedup f=d
q devcl  f=d

-Rick Adamson

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Dury, 
John C.
Sent: Wednesday, January 13, 2016 10:37 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] All volumes in STGPOOL show as full. Please help.

I tried reclamation but it fails since all volume in stgpool DEDUP show as 
full. An audit run to successful completion but volume stays as FULL. Even a 
MOVE DATA of a volume in DEDUP pool runs to successful completion but the 
status stays as FULL.
John


-Original Message-
From: Rettenberger Sabine [mailto:sabine.rettenber...@wolf-heiztechnik.de] 
Sent: Wednesday, January 13, 2016 10:35 AM
To: ADSM: Dist Stor Manager
Cc: Dury, John C.
Subject: AW: All volumes in STGPOOL show as full. Please help.

Hi John,

did you try a RECLAIM at the DEDUP-Pool to get the volumes free?
What says an AUDIT VOLUME of the empty volumes?
Are they really empty?

Best regards
Sabine

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Dury, 
John C.
Gesendet: Mittwoch, 13. Januar 2016 16:01
An: ADSM-L@VM.MARIST.EDU
Betreff: All volumes in STGPOOL show as full. Please help.

We have 2 storage pools. A BACKUPPOOL and a DEDUP pool. All nightly backups 
come into the BACKUPPOOL and then migrate to the DEDUP pool for permanent 
storage. All volumes in the DEDUP pool are showing FULL although the pool is 
only 69% in use. I tried doing a move data on a volume in the DEDUP pool to the 
BACKUPPOOL just to free space so reclamation could run, and although it says it 
ran to successful completion, the volume still shows as FULL. So for whatever 
reason, all volumes in the DEDUP pool are never freeing up. I ran an audit on 
the same volume I tried to the MOVE DATA command on and it also ran to 
successful completion. No idea what is going on here but hopefully someone else 
has an idea. If our BACKUPPOOL fills up, we can't back anything up any more and 
we will have a catastrophe. The BACKUPPOOL is roughly 15T  and 15% full and I 
have no way to increase it.
Please reply directly to my email address and list as I am currently subscribed 
as digest only.
TSM Server is 6.3.5.300 on RHEL 5
--
Wolf GmbH
Sitz der Gesellschaft:
Industriestr. 1, D-84048 Mainburg
Registergericht:
Amtsgericht Regensburg HR-B-1453
Vorsitzender des Aufsichtsrates: Alfred Gaffal Geschäftsführung:Bernhard Steppe 
(Sprecher) Christian Amann Gerdewan Jacobs Rudolf Meindl

Telefon +49 8751/74-0
Telefax +49 8751/74-1600
Internet: 
https://urldefense.proofpoint.com/v2/url?u=http-3A__cp.mcafee.com_d_avndzgOcygArhovjsd79EVjupdTdFEK9EEEI6QQn4QkhPNJ6XbNEVppvhd79JBV4QsFIEECN51K9o58dyNYy9evbCQ6No-2Dh4DfBPq9EVZNMQsKfZvAkS7C3hOZRXBQSkTKjvssKqehTbnhIyyHtVPBgY-2DF6lK1FJ4SyrLOb2rPUV5xcQsCXCOD6aDKBOvO59-5FoD2hnAfdQQxa7Z7VP-2D13UAvy2z5jTiVfV2A-5FIjx8HO7CS6nCjow0GhEw43PPh0pGuSHZ3h1a1Ew60i4wI60M5jh1gDkMq8dEq87mPP-2Dd40mf-5Fquq82vDHsrvpdJIlhZP2t&d=CwIFAw&c=AzgFQeXLLKhxSQaoFCm29A&r=eqh5PzQPIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw&m=t_WJZUMfpbbCz1Z1TOWZcQbOxMN4UVDgX3f-5NNq6HM&s=jbYECa5dVyELP0nNRgBGadK4FnBhubqnYXzSYnfowTc&e=
 
USt-IdNr.: DE811132553
ILN: 40 45013 01

Re: All volumes in STGPOOL show as full. Please help.

[Dury, John C.]

I tried reclamation but it fails since all volume in stgpool DEDUP show as 
full. An audit run to successful completion but volume stays as FULL. Even a 
MOVE DATA of a volume in DEDUP pool runs to successful completion but the 
status stays as FULL.
John


-Original Message-
From: Rettenberger Sabine [mailto:sabine.rettenber...@wolf-heiztechnik.de] 
Sent: Wednesday, January 13, 2016 10:35 AM
To: ADSM: Dist Stor Manager
Cc: Dury, John C.
Subject: AW: All volumes in STGPOOL show as full. Please help.

Hi John,

did you try a RECLAIM at the DEDUP-Pool to get the volumes free?
What says an AUDIT VOLUME of the empty volumes?
Are they really empty?

Best regards
Sabine

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Dury, 
John C.
Gesendet: Mittwoch, 13. Januar 2016 16:01
An: ADSM-L@VM.MARIST.EDU
Betreff: All volumes in STGPOOL show as full. Please help.

We have 2 storage pools. A BACKUPPOOL and a DEDUP pool. All nightly backups 
come into the BACKUPPOOL and then migrate to the DEDUP pool for permanent 
storage. All volumes in the DEDUP pool are showing FULL although the pool is 
only 69% in use. I tried doing a move data on a volume in the DEDUP pool to the 
BACKUPPOOL just to free space so reclamation could run, and although it says it 
ran to successful completion, the volume still shows as FULL. So for whatever 
reason, all volumes in the DEDUP pool are never freeing up. I ran an audit on 
the same volume I tried to the MOVE DATA command on and it also ran to 
successful completion. No idea what is going on here but hopefully someone else 
has an idea. If our BACKUPPOOL fills up, we can't back anything up any more and 
we will have a catastrophe. The BACKUPPOOL is roughly 15T  and 15% full and I 
have no way to increase it.
Please reply directly to my email address and list as I am currently subscribed 
as digest only.
TSM Server is 6.3.5.300 on RHEL 5
--
Wolf GmbH
Sitz der Gesellschaft:
Industriestr. 1, D-84048 Mainburg
Registergericht:
Amtsgericht Regensburg HR-B-1453
Vorsitzender des Aufsichtsrates: Alfred Gaffal Geschäftsführung:Bernhard Steppe 
(Sprecher) Christian Amann Gerdewan Jacobs Rudolf Meindl

Telefon +49 8751/74-0
Telefax +49 8751/74-1600
Internet: 
http://cp.mcafee.com/d/avndzgOcygArhovjsd79EVjupdTdFEK9EEEI6QQn4QkhPNJ6XbNEVppvhd79JBV4QsFIEECN51K9o58dyNYy9evbCQ6No-h4DfBPq9EVZNMQsKfZvAkS7C3hOZRXBQSkTKjvssKqehTbnhIyyHtVPBgY-F6lK1FJ4SyrLOb2rPUV5xcQsCXCOD6aDKBOvO59_oD2hnAfdQQxa7Z7VP-13UAvy2z5jTiVfV2A_Ijx8HO7CS6nCjow0GhEw43PPh0pGuSHZ3h1a1Ew60i4wI60M5jh1gDkMq8dEq87mPP-d40mf_quq82vDHsrvpdJIlhZP2t
USt-IdNr.: DE811132553
ILN: 40 45013 01

AW: All volumes in STGPOOL show as full. Please help.

[Rettenberger Sabine]

Hi John,

did you try a RECLAIM at the DEDUP-Pool to get the volumes free?
What says an AUDIT VOLUME of the empty volumes?
Are they really empty?

Best regards
Sabine

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Dury, 
John C.
Gesendet: Mittwoch, 13. Januar 2016 16:01
An: ADSM-L@VM.MARIST.EDU
Betreff: All volumes in STGPOOL show as full. Please help.

We have 2 storage pools. A BACKUPPOOL and a DEDUP pool. All nightly backups 
come into the BACKUPPOOL and then migrate to the DEDUP pool for permanent 
storage. All volumes in the DEDUP pool are showing FULL although the pool is 
only 69% in use. I tried doing a move data on a volume in the DEDUP pool to the 
BACKUPPOOL just to free space so reclamation could run, and although it says it 
ran to successful completion, the volume still shows as FULL. So for whatever 
reason, all volumes in the DEDUP pool are never freeing up. I ran an audit on 
the same volume I tried to the MOVE DATA command on and it also ran to 
successful completion. No idea what is going on here but hopefully someone else 
has an idea. If our BACKUPPOOL fills up, we can't back anything up any more and 
we will have a catastrophe. The BACKUPPOOL is roughly 15T  and 15% full and I 
have no way to increase it.
Please reply directly to my email address and list as I am currently subscribed 
as digest only.
TSM Server is 6.3.5.300 on RHEL 5
--
Wolf GmbH
Sitz der Gesellschaft:
Industriestr. 1, D-84048 Mainburg
Registergericht:
Amtsgericht Regensburg HR-B-1453
Vorsitzender des Aufsichtsrates: Alfred Gaffal
Geschäftsführung:Bernhard Steppe (Sprecher)
Christian Amann
Gerdewan Jacobs
Rudolf Meindl

Telefon +49 8751/74-0
Telefax +49 8751/74-1600
Internet: www.wolf-heiztechnik.de
USt-IdNr.: DE811132553
ILN: 40 45013 01

All volumes in STGPOOL show as full. Please help.

[Dury, John C.]

We have 2 storage pools. A BACKUPPOOL and a DEDUP pool. All nightly backups 
come into the BACKUPPOOL and then migrate to the DEDUP pool for permanent 
storage. All volumes in the DEDUP pool are showing FULL although the pool is 
only 69% in use. I tried doing a move data on a volume in the DEDUP pool to the 
BACKUPPOOL just to free space so reclamation could run, and although it says it 
ran to successful completion, the volume still shows as FULL. So for whatever 
reason, all volumes in the DEDUP pool are never freeing up. I ran an audit on 
the same volume I tried to the MOVE DATA command on and it also ran to 
successful completion. No idea what is going on here but hopefully someone else 
has an idea. If our BACKUPPOOL fills up, we can't back anything up any more and 
we will have a catastrophe. The BACKUPPOOL is roughly 15T  and 15% full and I 
have no way to increase it.
Please reply directly to my email address and list as I am currently subscribed 
as digest only.
TSM Server is 6.3.5.300 on RHEL 5

Re: any help file for dsmc options

[Erwann Simon]

Hello, 

Have a look to TSM Client installation and user's guide and dsmc help command.
There's no CHM file for general TSM Client help. 

Le 11 août 2015 16:33:54 WEST, Srikanth Kola23  a écrit :
>Hi Team,
>
>do we have any file that can be downloaded to see help or commands of
>all
>commands in dsmc
>
>like dsmcutil html file in windows under default installation folder
>
>Thanks & Regards,
>
>Srikanth kola
>Backup & Recovery
>IBM India Pvt Ltd, Chennai
>Mobile: +91 9885473450

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

Re: any help file for dsmc options

[Srikanth Kola23]

Hi Team,

do we have any file that can be downloaded to see help or commands of all
commands in dsmc

like dsmcutil html file in windows under default installation folder

Thanks & Regards,

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

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.

help with designing a backup system for Teradata

[Rhodes, Richard L.]

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: script help

[Ron Delaware]

Jeanne,

If you were to run those command at the DB2 level, they would work fine or
possible as a shell script ran from a TSM macro. There are limitations, as
you found out, when trying to run select statements from within TSM.


Best Regards,
_

email: ron.delaw...@us.ibm.com
Storage Services Offerings






From:   Jeanne Bruno 
To: ADSM-L@VM.MARIST.EDU
Date:   03/12/15 14:36
Subject:[ADSM-L] script help
Sent by:"ADSM: Dist Stor Manager" 



Hello.  Need some help.  I'm trying to create a new script for myself and
I want to get the PROCESS_NUM from the Processes table in a variable.

def script Processes desc="get Process Number"
update script Processes 'declare process processes.PROCESS_NUM%type'
update script Processes 'START:'
update script Processes 'select PROCESS_NUM into process from processes
where PROCESS<>"Identify Duplicates"'
update script Processes 'if (rc_ok) goto ID'
update script Processes 'ID:'
update script Processes "DBMS_OUTPUT.PUT_LINE('process id=' process)"
update script Processes 'EXIT:'
update script Processes 'exit'

tsm: TSMPOK_SERVER1>update script cancelreps 'declare process
processes.PROCESS_NUM%type'
ANR1469E UPDATE SCRIPT: Command script CANCELREPS, Line 1 is an INVALID
command : declare process processes.PROCESS_NUM%type.
ANS8001I Return code 3.

tsm: TSMPOK_SERVER1>update script cancelreps
"DBMS_OUTPUT.PUT_LINE('process id=' process)"
ANR2002E Missing closing quote character.
ANR1469E UPDATE SCRIPT: Command script CANCELREPS, Line 20 is an INVALID
command : DBMS_OUTPUT.PUT_LINE('process id=' process).
ANS8001I Return code 3.

And when I put the word 'process' in quotes (just to get around the quote
error above)it's an invalid command anyway.

tsm: TSMPOK_SERVER1>update script cancelreps
"DBMS_OUTPUT.PUT_LINE('process')"
ANR1469E UPDATE SCRIPT: Command script CANCELREPS, Line 20 is an INVALID
command : DBMS_OUTPUT.PUT_LINE('process').
ANS8001I Return code 3.

Are there DB2 equivalents for the 'declare' and 'DBMS_OUTPUT' commands???
I've googled and it looks you can use the commands in DB2, but maybe not
for TSM???

Any input is much appreciated.


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

script help

[Jeanne Bruno]

Hello.  Need some help.  I'm trying to create a new script for myself and I 
want to get the PROCESS_NUM from the Processes table in a variable.

def script Processes desc="get Process Number"
update script Processes 'declare process processes.PROCESS_NUM%type'
update script Processes 'START:'
update script Processes 'select PROCESS_NUM into process from processes where 
PROCESS<>"Identify Duplicates"'
update script Processes 'if (rc_ok) goto ID'
update script Processes 'ID:'
update script Processes "DBMS_OUTPUT.PUT_LINE('process id=' process)"
update script Processes 'EXIT:'
update script Processes 'exit'

tsm: TSMPOK_SERVER1>update script cancelreps 'declare process 
processes.PROCESS_NUM%type'
ANR1469E UPDATE SCRIPT: Command script CANCELREPS, Line 1 is an INVALID command 
: declare process processes.PROCESS_NUM%type.
ANS8001I Return code 3.

tsm: TSMPOK_SERVER1>update script cancelreps "DBMS_OUTPUT.PUT_LINE('process 
id=' process)"
ANR2002E Missing closing quote character.
ANR1469E UPDATE SCRIPT: Command script CANCELREPS, Line 20 is an INVALID 
command : DBMS_OUTPUT.PUT_LINE('process id=' process).
ANS8001I Return code 3.

And when I put the word 'process' in quotes (just to get around the quote error 
above)it's an invalid command anyway.

tsm: TSMPOK_SERVER1>update script cancelreps "DBMS_OUTPUT.PUT_LINE('process')"
ANR1469E UPDATE SCRIPT: Command script CANCELREPS, Line 20 is an INVALID 
command : DBMS_OUTPUT.PUT_LINE('process').
ANS8001I Return code 3.

Are there DB2 equivalents for the 'declare' and 'DBMS_OUTPUT' commands???
I've googled and it looks you can use the commands in DB2, but maybe not for 
TSM???

Any input is much appreciated.


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

Re: Select Statement Help

[Kamp, Bruce (Ext)]

Thanks for the help!
This what I ended up with.

SELECT CAST((NODE_NAME) AS CHAR(20)) AS "Node Name",CAST(MIN(BACKUP_DATE) AS 
DATE) AS "BACKUP DATE" FROM BACKUPS WHERE NODE_NAME LIKE '%_TDP' AND 
STATE='ACTIVE_VERSION' AND CLASS_NAME LIKE 
'%DB%' AND BACKUP_DATE < '2015-02-01' AND FILESPACE_NAME NOT LIKE '%$%' GROUP 
BY NODE_NAME


Bruce Kamp
TSM Administrator
(817) 568-7331


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Hanover, Cameron
Sent: Tuesday, March 10, 2015 11:05 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement Help

This probably isn't completely right, but it might be a start:

select node_name,hl_name,min(backup_date) from backups group by 
node_name,hl_name

--
Cameron Hanover
chano...@umich.edu

"Let's get dangerous."
--Darkwing Duck

On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext)  wrote:

> I am found a couple TDP SQL nodes that aren't inactivating there backups so 
> TSM isn't expiring them...
> What I am trying to find is the oldest backup date for each server with a 
> name like _TDP.
> 
> I can get this:
> Node Name HL_NAME 
>BACKUP DATE STATE
> - 
> -  
> --
> XYZ_TDP //
>   2009-08-17 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-13 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-14 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-15 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-16 ACTIVE_VERSION
> 
> What I really want is something like this:
> Node Name HL_NAME 
>BACKUP DATE STATE
> - 
> -  
> --
> XYZ_TDP //
>   2009-08-17 ACTIVE_VERSION
> ABC_TDP //
>   2009-09-13 ACTIVE_VERSION
> 123_TDP //
>   2009-09-14 ACTIVE_VERSION
> 
> Is this possible ?
> 
> Thanks,
> Bruce Kamp
> TSM Administrator
> (817) 568-7331

Re: Select Statement Help

[Hanover, Cameron]

This probably isn't completely right, but it might be a start:

select node_name,hl_name,min(backup_date) from backups group by 
node_name,hl_name

--
Cameron Hanover
chano...@umich.edu

"Let's get dangerous."
--Darkwing Duck

On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext)  wrote:

> I am found a couple TDP SQL nodes that aren't inactivating there backups so 
> TSM isn't expiring them...
> What I am trying to find is the oldest backup date for each server with a 
> name like _TDP.
> 
> I can get this:
> Node Name HL_NAME 
>BACKUP DATE STATE
> - 
> -  
> --
> XYZ_TDP //
>   2009-08-17 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-13 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-14 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-15 ACTIVE_VERSION
> XYZ_TDP //
>   2009-09-16 ACTIVE_VERSION
> 
> What I really want is something like this:
> Node Name HL_NAME 
>BACKUP DATE STATE
> - 
> -  
> --
> XYZ_TDP //
>   2009-08-17 ACTIVE_VERSION
> ABC_TDP //
>   2009-09-13 ACTIVE_VERSION
> 123_TDP //
>   2009-09-14 ACTIVE_VERSION
> 
> Is this possible ?
> 
> Thanks,
> Bruce Kamp
> TSM Administrator
> (817) 568-7331

Re: Select Statement Help

[Ron Delaware]

Bruce,

You could do a group by node_name at the end of your select statement.


Best Regards,
_

email: ron.delaw...@us.ibm.com
Storage Services Offerings






From:   "Kamp, Bruce (Ext)" 
To: ADSM-L@VM.MARIST.EDU
Date:   03/09/15 12:46
Subject:[ADSM-L] Select Statement Help
Sent by:"ADSM: Dist Stor Manager" 



I am found a couple TDP SQL nodes that aren't inactivating there backups
so TSM isn't expiring them...
What I am trying to find is the oldest backup date for each server with a
name like _TDP.

I can get this:
Node Name HL_NAME   BACKUP DATE STATE
-
- 
--
XYZ_TDP //  2009-08-17 ACTIVE_VERSION
XYZ_TDP //  2009-09-13 ACTIVE_VERSION
XYZ_TDP //  2009-09-14 ACTIVE_VERSION
XYZ_TDP //  2009-09-15 ACTIVE_VERSION
XYZ_TDP //  2009-09-16 ACTIVE_VERSION

What I really want is something like this:
Node Name HL_NAME   BACKUP DATE STATE
-
- 
--
XYZ_TDP //  2009-08-17 ACTIVE_VERSION
ABC_TDP //  2009-09-13 ACTIVE_VERSION
123_TDP //  2009-09-14 ACTIVE_VERSION

Is this possible ?

Thanks,
Bruce Kamp
TSM Administrator
(817) 568-7331

Select Statement Help

[Kamp, Bruce (Ext)]

I am found a couple TDP SQL nodes that aren't inactivating there backups so TSM 
isn't expiring them...
What I am trying to find is the oldest backup date for each server with a name 
like _TDP.

I can get this:
Node Name HL_NAME   
 BACKUP DATE STATE
- 
-  
--
XYZ_TDP //  
2009-08-17 ACTIVE_VERSION
XYZ_TDP //  
2009-09-13 ACTIVE_VERSION
XYZ_TDP //  
2009-09-14 ACTIVE_VERSION
XYZ_TDP //  
2009-09-15 ACTIVE_VERSION
XYZ_TDP //  
2009-09-16 ACTIVE_VERSION

What I really want is something like this:
Node Name HL_NAME   
 BACKUP DATE STATE
- 
-  
--
XYZ_TDP //  
2009-08-17 ACTIVE_VERSION
ABC_TDP //  
2009-09-13 ACTIVE_VERSION
123_TDP //  
2009-09-14 ACTIVE_VERSION

Is this possible ?

Thanks,
Bruce Kamp
TSM Administrator
(817) 568-7331

Re: recovering a DB from full backup when one of TSM DB DIR became corrupt and DB is in roll forward mode (need help)

[Dury, John C.]

The issue was that I needed a way to recreate the actual files in the dbdirs. 
It is fixed now.

 Original Message 
From: Erwann Simon
Sent: Mon, Nov 24, 2014 12:42 AM
To: ADSM: Dist Stor Manager ; Dury, John C.
CC:
Subject: Re: [ADSM-L] recovering a DB from full backup when one of TSM DB DIR 
became corrupt and DB is in roll forward mode (need help)


Hello John,
See both Admin Guide and Admin Reference regarding "dsmserv restore db". There 
are two recovery methods : on that deletes the logs (point in time restore,  
ignore it) and one that keeps and rollforwards the logs after db restore (most 
current state, use this one).
The command is pretty simple :
Login as instance owner
Change to the instance directory
Simply run : dsmserv restore db

Note that of you use the todate option of the dsmserv restore db command, 
you'll have a point in time restore which deletes the log !



Le 24 novembre 2014 00:57:56 CET, "Dury, John C."  a écrit :
>Long story short, I have a full DB backup taken on a linux system
>running TSM 6.3.4.300 with the DB in roll forward mode. The DB is
>spread across 4 different dbdirs file systems. One of the file systems
>became corrupt and I need to recover the DB from the full backup.
>I have the dbdirs file systems back  and the active log and archive log
>directories are ok and were untouched. The dbdirs directories are back
>but there are no files in them.
>The active log and archive log directories are ok and uncorrupted.
>How can I restore the DB to the most recent point since the archivelog
>is still intact and recreate the files in the dbdirs so a restore can
>repopulate them from the full DB backup?

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

Re: recovering a DB from full backup when one of TSM DB DIR became corrupt and DB is in roll forward mode (need help)

[Erwann Simon]

Hello John,
See both Admin Guide and Admin Reference regarding "dsmserv restore db". There 
are two recovery methods : on that deletes the logs (point in time restore,  
ignore it) and one that keeps and rollforwards the logs after db restore (most 
current state, use this one).
The command is pretty simple :
Login as instance owner
Change to the instance directory
Simply run : dsmserv restore db

Note that of you use the todate option of the dsmserv restore db command, 
you'll have a point in time restore which deletes the log !



Le 24 novembre 2014 00:57:56 CET, "Dury, John C."  a écrit :
>Long story short, I have a full DB backup taken on a linux system
>running TSM 6.3.4.300 with the DB in roll forward mode. The DB is
>spread across 4 different dbdirs file systems. One of the file systems
>became corrupt and I need to recover the DB from the full backup.
>I have the dbdirs file systems back  and the active log and archive log
>directories are ok and were untouched. The dbdirs directories are back 
>but there are no files in them.
>The active log and archive log directories are ok and uncorrupted.
>How can I restore the DB to the most recent point since the archivelog
>is still intact and recreate the files in the dbdirs so a restore can
>repopulate them from the full DB backup?

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

recovering a DB from full backup when one of TSM DB DIR became corrupt and DB is in roll forward mode (need help)

[Dury, John C.]

Long story short, I have a full DB backup taken on a linux system running TSM 
6.3.4.300 with the DB in roll forward mode. The DB is spread across 4 different 
dbdirs file systems. One of the file systems became corrupt and I need to 
recover the DB from the full backup.
I have the dbdirs file systems back  and the active log and archive log 
directories are ok and were untouched. The dbdirs directories are back  but 
there are no files in them.
The active log and archive log directories are ok and uncorrupted.
How can I restore the DB to the most recent point since the archivelog is still 
intact and recreate the files in the dbdirs so a restore can repopulate them 
from the full DB backup?

Re: Anyone else doing replica backups of exchange datastores? Need some help please.

[Dury, John C.]

This is exactly how I am trying to get the replica backup to work. It is 
running on the passive server and I believe the DSMAGENT configuration is 
correct in ters of the proxy settings. I continue to work with IBM to get it to 
work.




Hi John, You can't run a backup of a replica from the primary server. You must 
be running that command on the passive server. The Microsoft Exchange Replica 
Writer will be running on the passive server. That is the machine you need to 
have DP/Exchange and the Windows BA Client installed and configured on. Also 
keep in mind that it's the DSMAGENT (Windows BA Client) is the node that 
actually sends the data to the TSM Server. It uses the proxy capability to 
store the data on behalf of the DP/Exchange node. The service team can assist 
you through this. Thank you, Del 
 "ADSM: Dist Stor Manager" 
 wrote on 10/31/2014 02:47:25 PM: > From: "Dury, 
John C."  > To: ADSM-L AT VM.MARIST DOT EDU > Date: 
10/31/2014 02:49 PM > Subject: Re: Anyone else doing replica backups of 
exchange > datastores? Need some help please. > Sent by: "ADSM: Dist Stor 
Manager"  > > Thanks for the reply. I agree that 
it sounds like a configuration > issue. We are trying to do this via command 
line so it can be > scripted and therefore automated. I do have a problem open 
with IBM > and sent them some logs and lots of information but their first was 
> response was to tell me that it wasn't configured correctly as they > were 
looking at early entries in the logs I sent them instead of > further down. 
Lesson learned, delete all of your logs before > recreating problem as support 
won't look at timestamps and first > error they see must be the problem.  
The command line I am > using looks like this: > C:\Program 
Files\Tivoli\TSM\TDPExchange>tdpexcc backup  > incr /fromreplica 
/backupmethod=vss /backupdestination=tsm / > tsmoptfile="c:\Program 
Files\Tivoli\TSM\TDPExchange\dsm.opt" > I was getting it to create a TSM 
session but the session would just > be WAITING on the server for hours and 
never actually did anything. > FWIW, the datastore I am testing with is tiny. > 
Now when I try running the backup on the inactive CCR replica I get: > Updating 
mailbox history on TSM Server... > Mailbox history has been updated 
successfully. > Querying Exchange Server to gather component information, 
please wait... > ACN5241E The Microsoft Exchange Information Store is currently 
not running. > but as I mentioned before, according to my exchange admins, that 
> service should never be running on both sides of the CCR cluster. > I have 
changed the dsm.opt and tdpexc.cfg options so many times with > every option 
can think of which is why I was hoping someone had a > sanitized version of 
their dsm.opt and tdpexc.cfg that are working > in their environment I could 
look at. >

Re: Anyone else doing replica backups of exchange datastores? Need some help please.

[Del Hoobler]

Hi John,

You can't run a backup of a replica from the primary server.
You must be running that command on the passive server.

The Microsoft Exchange Replica Writer will be running on the
passive server. That is the machine you need to have
DP/Exchange and the Windows BA Client installed and
configured on.

Also keep in mind that it's the DSMAGENT (Windows BA Client)
is the node that actually sends the data to the TSM Server.
It uses the proxy capability to store the data on behalf
of the DP/Exchange node.

The service team can assist you through this.


Thank you,

Del



"ADSM: Dist Stor Manager"  wrote on 10/31/2014
02:47:25 PM:

> From: "Dury, John C." 
> To: ADSM-L@VM.MARIST.EDU
> Date: 10/31/2014 02:49 PM
> Subject: Re: Anyone else doing replica backups of exchange
> datastores? Need some help please.
> Sent by: "ADSM: Dist Stor Manager" 
>
> Thanks for the reply. I agree that it sounds like a configuration
> issue. We are trying to do this via command line so it can be
> scripted and therefore automated.  I do have a problem open with IBM
> and sent them some logs and lots of information but their first was
> response was to tell me that it wasn't configured correctly as they
> were looking at early entries in the logs I sent them instead of
> further down. Lesson learned, delete all of your logs before
> recreating problem as support won't look at timestamps and first
> error they see must be the problem.  The command line I am
> using looks like this:
> C:\Program Files\Tivoli\TSM\TDPExchange>tdpexcc backup 
> incr /fromreplica /backupmethod=vss /backupdestination=tsm /
> tsmoptfile="c:\Program Files\Tivoli\TSM\TDPExchange\dsm.opt"
> I was getting it to create a TSM session but the session would just
> be WAITING on the server for hours and never actually did anything.
> FWIW, the datastore I am testing with is tiny.
> Now when I try running the backup on the inactive CCR replica I get:
> Updating mailbox history on TSM Server...
> Mailbox history has been updated successfully.
> Querying Exchange Server to gather component information, please wait...
> ACN5241E The Microsoft Exchange Information Store is currently not
running.
> but as I mentioned before, according to my exchange admins, that
> service should never be running on both sides of the CCR cluster.
> I have changed the dsm.opt and tdpexc.cfg options so many times with
> every option can think of which is why I was hoping someone had a
> sanitized version of their dsm.opt and tdpexc.cfg that are working
> in their environment I could look at.
>

Re: Anyone else doing replica backups of exchange datastores? Need some help please.

[Dury, John C.]

Thanks for the reply. I agree that it sounds like a configuration issue. We are 
trying to do this via command line so it can be scripted and therefore 
automated.  I do have a problem open with IBM and sent them some logs and lots 
of information but their first was response was to tell me that it wasn't 
configured correctly as they were looking at early entries in the logs I sent 
them instead of further down. Lesson learned, delete all of your logs before 
recreating problem as support won't look at timestamps and first error they see 
must be the problem.  The command line I am using looks like this:
C:\Program Files\Tivoli\TSM\TDPExchange>tdpexcc backup  incr 
/fromreplica /backupmethod=vss /backupdestination=tsm /tsmoptfile="c:\Program 
Files\Tivoli\TSM\TDPExchange\dsm.opt"
I was getting it to create a TSM session but the session would just be WAITING 
on the server for hours and never actually did anything. FWIW, the datastore I 
am testing with is tiny.
Now when I try running the backup on the inactive CCR replica I get:
Updating mailbox history on TSM Server...
Mailbox history has been updated successfully.
Querying Exchange Server to gather component information, please wait...
ACN5241E The Microsoft Exchange Information Store is currently not running.
but as I mentioned before, according to my exchange admins, that service should 
never be running on both sides of the CCR cluster.
I have changed the dsm.opt and tdpexc.cfg options so many times with every 
option can think of which is why I was hoping someone had a sanitized version 
of their dsm.opt and tdpexc.cfg that are working in their environment I could 
look at.




Hi John, This looks like a configuration issue to me. Exchange Server 2007 CCR 
and LCR replica copies can be backed up and restored by using the VSS method 
only. Microsoft does not allow Legacy backups of Exchange Server 2007 CCR and 
LCR replica copies. Also keep in mind, all VSS Restores of a CCR or LCR replica 
can be restored only into the running instance of a storage group (primary, 
recovery, or alternate). Microsoft does not support VSS Restores into a replica 
instance. If you want to back up from the replica copy when running in a CCR or 
LCR environment, specify the "FromReplica True" backup option in the Protect 
tab of the MMC GUI. You can also specify the /fromreplica parameter with the 
tdpexcc backup command on the command-line interface. Here is the important 
one... For CCR copies, you must run the backup while logged on to the secondary 
node of the cluster that currently contains the replica copy and you must use 
the "FROMREPLICA" option. Here are a few more things: 
http://www-01.ibm.com/support/knowledgecenter/SSTG2D_6.4.0/com.ibm.itsm.mail.exc.doc/c_dpfcm_bup_replica_exc.html?cp=SSTG2D_6.4.0&lang=en
 If you are not able to get this working, you should open a PMR so that the 
service team can help you get the configuration working. Del 
 "ADSM: Dist Stor Manager" 
 wrote on 10/31/2014 08:40:00 AM: > From: "Dury, 
John C."  > To: ADSM-L AT VM.MARIST DOT EDU > Date: 
10/31/2014 08:42 AM > Subject: Anyone else doing replica backups of exchange 
datastores? > Need some help please. > Sent by: "ADSM: Dist Stor Manager" 
 > > I have been trying to get this to work for 
days now and I don't seem > to be making any progress. I have tried all kinds 
of options in both > the dsm.opt and tdpexc.cfg files and I get various 
messages. The > documentation in the TDP for Exchange manual on doing replica > 
backups is not very detailed at all. > Our environment looks like this. > We 
have two windows 2008 exchange 2007 servers setup for CCR > replication to each 
other. I am trying to do replica backups on the > offline cluster member so it 
doesn't affect performance on the live > cluster member. > The TSM server is 
6.3.4.300 running on RHEL5 linux. > I thought I had it working but nothing was 
actually backed up. The > TSM session was established on the TSM server but no 
data was > actually sent. The sessions appeared to be hung and seemed to > 
eventually timeout. > The other message I was receiving on the offline exchange 
cluster member was > Updating mailbox history on TSM Server... > Mailbox 
history has been updated successfully. > > Querying Exchange Server to gather 
component information, please wait... > > ACN5241E The Microsoft Exchange 
Information Store is currently not running. > but from what I was told by our 
exchange experts is that that > service only runs on the active cluster member 
and not on the offline member. > Below are my sanitized dsm.opt and tdpexc.cfg 
> dsm.opt > NODename exchange > deduplication no > CLUSTERnode yes > 
COMPRESSIon Off > COMPRESSalways On > PASSWORDAccess Genera

Re: Anyone else doing replica backups of exchange datastores? Need some help please.

[Del Hoobler]

Hi John,

This looks like a configuration issue to me.

Exchange Server 2007 CCR and LCR replica copies can be backed up and
restored by using the VSS method only. Microsoft does not allow
Legacy backups of Exchange Server 2007 CCR and LCR replica copies.

Also keep in mind, all VSS Restores of a CCR or LCR replica can be
restored only
into the running instance of a storage group (primary, recovery, or
alternate).
Microsoft does not support VSS Restores into a replica instance.

If you want to back up from the replica copy when running in a CCR or LCR
environment,
specify the "FromReplica True" backup option in the Protect tab of the MMC
GUI.
You can also specify the /fromreplica parameter with the tdpexcc backup
command
on the command-line interface.

Here is the important one...

For CCR copies, you must run the backup while logged on to the secondary
node
of the cluster that currently contains the replica copy and you must use
the "FROMREPLICA" option.

Here are a few more things:


http://www-01.ibm.com/support/knowledgecenter/SSTG2D_6.4.0/com.ibm.itsm.mail.exc.doc/c_dpfcm_bup_replica_exc.html?cp=SSTG2D_6.4.0&lang=en


If you are not able to get this working, you should open a PMR so that
the service team can help you get the configuration working.


Del



"ADSM: Dist Stor Manager"  wrote on 10/31/2014
08:40:00 AM:

> From: "Dury, John C." 
> To: ADSM-L@VM.MARIST.EDU
> Date: 10/31/2014 08:42 AM
> Subject: Anyone else doing replica backups of exchange datastores?
> Need some help please.
> Sent by: "ADSM: Dist Stor Manager" 
>
> I have been trying to get this to work for days now and I don't seem
> to be making any progress. I have tried all kinds of options in both
> the dsm.opt and tdpexc.cfg files and I get various messages. The
> documentation in the TDP for Exchange manual on doing replica
> backups is not very detailed at all.
> Our environment looks like this.
> We have two windows 2008 exchange 2007 servers setup for CCR
> replication to each other. I am trying to do replica backups on the
> offline cluster member so it doesn't affect performance on the live
> cluster member.
> The TSM server is 6.3.4.300 running on RHEL5 linux.
> I thought I had it working but nothing was actually backed up. The
> TSM session was established on the TSM server but no data was
> actually sent. The sessions appeared to be hung and seemed to
> eventually timeout.
> The other message I was receiving on the offline exchange cluster member
was
> Updating mailbox history on TSM Server...
> Mailbox history has been updated successfully.
>
> Querying Exchange Server to gather component information, please wait...
>
> ACN5241E The Microsoft Exchange Information Store is currently not
running.
> but from what I was told by our exchange experts is that that
> service only runs on the active cluster member and not on the offline
member.
> Below are my sanitized dsm.opt and tdpexc.cfg
> dsm.opt
> NODename  exchange
> deduplication no
> CLUSTERnode   yes
> COMPRESSIon   Off
> COMPRESSalwaysOn
> PASSWORDAccessGenerate
> resourceutilization 5
> COMMMethodTCPip
> TCPPort   1500
> TCPServeraddress tsmserver
> TCPWindowsize 128
> TCPBuffSize   64
> diskbuffsize 32
> SCHEDMODE Prompted
> SCHEDLOGRetention 14,d
> HTTPport  1581
> tdpexc.cfg
> BUFFers 4
> BUFFERSIze 8192
> clusternode yes
> compression off
> compressalways on
> LOGFile tdpexc.log
> LOGPrune 60
> MOUNTWait Yes
> TEMPLOGRestorepath P:\TempRestoreLoc
> LASTPRUNEDate 10/31/2014 06:55:09
> BACKUPMETHod LEGACY
> * BACKUPMETHod vss
> RETRies 0
> LANGuage ENU
> BACKUPDESTination TSM
> LOCALDSMAgentnode exchangeofflineclustertsmnodename
> REMOTEDSMAgentnode  exchange
> TEMPDBRestorepath P:\TempRestoreLoc
> CLIENTACcessserver
>
> Could someone who actually has this working send me their sanitized
> dsm.opt.tdpexc.cfg and the actual command used to do a replica backup
from the
> offline cluster member?
>

Anyone else doing replica backups of exchange datastores? Need some help please.

[Dury, John C.]

I have been trying to get this to work for days now and I don't seem to be 
making any progress. I have tried all kinds of options in both the dsm.opt and 
tdpexc.cfg files and I get various messages. The documentation in the TDP for 
Exchange manual on doing replica backups is not very detailed at all.
Our environment looks like this.
We have two windows 2008 exchange 2007 servers setup for CCR replication to 
each other. I am trying to do replica backups on the offline cluster member so 
it doesn't affect performance on the live cluster member.
The TSM server is 6.3.4.300 running on RHEL5 linux.
I thought I had it working but nothing was actually backed up. The TSM session 
was established on the TSM server but no data was actually sent. The sessions 
appeared to be hung and seemed to eventually timeout.
The other message I was receiving on the offline exchange cluster member was
Updating mailbox history on TSM Server...
Mailbox history has been updated successfully.

Querying Exchange Server to gather component information, please wait...

ACN5241E The Microsoft Exchange Information Store is currently not running.
but from what I was told by our exchange experts is that that service only runs 
on the active cluster member and not on the offline member.
Below are my sanitized dsm.opt and tdpexc.cfg
dsm.opt
NODename  exchange
deduplication no
CLUSTERnode   yes
COMPRESSIon   Off
COMPRESSalwaysOn
PASSWORDAccessGenerate
resourceutilization 5
COMMMethodTCPip
TCPPort   1500
TCPServeraddress tsmserver
TCPWindowsize 128
TCPBuffSize   64
diskbuffsize 32
SCHEDMODE Prompted
SCHEDLOGRetention 14,d
HTTPport  1581
tdpexc.cfg
BUFFers 4
BUFFERSIze 8192
clusternode yes
compression off
compressalways on
LOGFile tdpexc.log
LOGPrune 60
MOUNTWait Yes
TEMPLOGRestorepath P:\TempRestoreLoc
LASTPRUNEDate 10/31/2014 06:55:09
BACKUPMETHod LEGACY
* BACKUPMETHod vss
RETRies 0
LANGuage ENU
BACKUPDESTination TSM
LOCALDSMAgentnode exchangeofflineclustertsmnodename
REMOTEDSMAgentnode  exchange
TEMPDBRestorepath P:\TempRestoreLoc
CLIENTACcessserver

Could someone who actually has this working send me their sanitized 
dsm.opt.tdpexc.cfg and the actual command used to do a replica backup from the
offline cluster member?

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

Help in Mac client

[Robert Ouzen]

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: Select Statement Help

[white jeff]

SELECT * FROM ACTLOG WHERE MSGNO IN (406,4952,4954,4958,4960,4957,
4970,4959,4961,4965,4963,4966,4967,4968,4969,4964, 4976, 4981) and
start_time>current_timestamp - 24 hours


On 24 June 2014 19:39, Lepre, James  wrote:

> Hello Everyone -
>
> I am attempting miserably I might add to write a select statement that
> will produce a bunch of message found in the actlog.  The problem I am
> having is grabbing the data from the last 24 hours..  I will schedule this
> to produce an email each day.. Any thoughts on how to construct this
>
> Thank you
>
> SELECT * FROM ACTLOG WHERE (MSGNO IN
> (406,4952,4954,4958,4960,4957,4970,4959,4961,4965,4963,4966,4967,4968,4969,4964,
> 4976, 4981)) and start_time>=current_timestamp - 24 hours
>
> 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: Select Statement Help

[Lepre, James]

Version 7.1

James Lepre
Infrastructure Support Specialist
Solix, Inc. | 30 Lanidex Plaza West | Parsippany, NJ 07054
T: 973.581.5362 | F: 973.599.6544
www.solixinc.com | Solix on Facebook | Solix on Twitter


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick 
Saylor
Sent: Tuesday, June 24, 2014 3:19 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement Help

James,

What version of TSM? Your select statement will work in TSM 6.3 if you change 
"start_time" to "date_time". Please note that I did not verify the output, only 
that I got output.

Rick

At 01:39 PM 6/24/2014, you wrote:
>Hello Everyone -
>
>I am attempting miserably I might add to write a select statement that 
>will produce a bunch of message found in the actlog.  The problem I am 
>having is grabbing the data from the last 24 hours..  I will schedule 
>this to produce an email each day.. Any thoughts on how to construct 
>this
>
>Thank you
>
>SELECT * FROM ACTLOG WHERE (MSGNO IN
>(406,4952,4954,4958,4960,4957,4970,4959,4961,4965,4963,4966,4967,4968,4
>969,4964, 4976, 4981)) and start_time>=current_timestamp - 24 hours
>
>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.



Rick Saylor  Austin Community College   Voice: (512)223-1182
Director of System Services  9101 Tuscany Way   Fax:   (512)223-1211
Information Technology   Austin, Texas  78754

Re: Select Statement Help

[Rick Saylor]

James,

What version of TSM? Your select statement will work in TSM 6.3 if
you change "start_time" to "date_time". Please note that I did not
verify the output, only that I got output.

Rick

At 01:39 PM 6/24/2014, you wrote:

Hello Everyone -

I am attempting miserably I might add to write a select statement
that will produce a bunch of message found in the actlog.  The
problem I am having is grabbing the data from the last 24 hours..  I
will schedule this to produce an email each day.. Any thoughts on
how to construct this

Thank you

SELECT * FROM ACTLOG WHERE (MSGNO IN
(406,4952,4954,4958,4960,4957,4970,4959,4961,4965,4963,4966,4967,4968,4969,4964,
4976, 4981)) and start_time>=current_timestamp - 24 hours

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.




Rick Saylor  Austin Community College   Voice: (512)223-1182
Director of System Services  9101 Tuscany Way   Fax:   (512)223-1211
Information Technology   Austin, Texas  78754

Select Statement Help

[Lepre, James]

Hello Everyone -

I am attempting miserably I might add to write a select statement that will 
produce a bunch of message found in the actlog.  The problem I am having is 
grabbing the data from the last 24 hours..  I will schedule this to produce an 
email each day.. Any thoughts on how to construct this

Thank you

SELECT * FROM ACTLOG WHERE (MSGNO IN 
(406,4952,4954,4958,4960,4957,4970,4959,4961,4965,4963,4966,4967,4968,4969,4964,
 4976, 4981)) and start_time>=current_timestamp - 24 hours

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