Re: Another Failed 12

[Prather, Wanda]

That should NOT cause a 12, because its WAD.
What is in the dsmerror.log on the client?
There should be something else causing that 12...



From: ADSM: Dist Stor Manager on behalf of Gill, Geoffrey L.
Sent: Wed 2/14/2007 5:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Another Failed 12



I was wondering if anyone knows if this would cause a failed 12 report.
Makes sense to me that it would NOT, but my common sense gets the best
of me most of the time. This file is larger than the disk pool allows
and needs to go to tape, which reports happened, but I just don't see
how that would cause the failure, and since there looks to be no other
issues in the log I'm left scratching my head again. The server side
shows no problems, instead it does show the media mount and dismount
normally after the file has been transferred.



Since reported failures are sent to the TEC, and tickets created, it
takes time to investigate only, at least it looks like in this case, to
find no problems. So I'm left with disgruntled administrators as you can
imagine.



02/13/07   03:00:38 Normal File-->65,247,232,000
/d4/backup/PSPRD/b_g2i9tkss_1_1  ** Unsuccessful **

02/13/07   03:00:38 ANS1114I Waiting for mount of offline media.

02/13/07   04:16:21 Retry # 1  Normal File-->65,247,232,000
/d4/backup/PSPRD/b_g2i9tkss_1_1 [Sent] 



Geoff Gill
TSM Administrator
PeopleSoft Sr. Systems Administrator
SAIC M/S-G1b
(858)826-4062
Email: [EMAIL PROTECTED]

Another Failed 12

[Gill, Geoffrey L.]

I was wondering if anyone knows if this would cause a failed 12 report.
Makes sense to me that it would NOT, but my common sense gets the best
of me most of the time. This file is larger than the disk pool allows
and needs to go to tape, which reports happened, but I just don't see
how that would cause the failure, and since there looks to be no other
issues in the log I'm left scratching my head again. The server side
shows no problems, instead it does show the media mount and dismount
normally after the file has been transferred. 

 

Since reported failures are sent to the TEC, and tickets created, it
takes time to investigate only, at least it looks like in this case, to
find no problems. So I'm left with disgruntled administrators as you can
imagine.

 

02/13/07   03:00:38 Normal File-->65,247,232,000
/d4/backup/PSPRD/b_g2i9tkss_1_1  ** Unsuccessful **

02/13/07   03:00:38 ANS1114I Waiting for mount of offline media.

02/13/07   04:16:21 Retry # 1  Normal File-->65,247,232,000
/d4/backup/PSPRD/b_g2i9tkss_1_1 [Sent]  

 

Geoff Gill 
TSM Administrator 
PeopleSoft Sr. Systems Administrator 
SAIC M/S-G1b 
(858)826-4062 
Email: [EMAIL PROTECTED] 

 

Re: SQL date convert

[Allan Mills]

I get this imformation from domdsm.log

the installation of tdp for domino will tell you where this is.

whilst it is not 100% and subject to normal 'hit and miss', it is better
than nothing.
I have found that I get info about backups starting and no info about
totals etc if
it is a long running process,  I have fiddled with duration time in
schedules and now
get approx 90% reporting.   Accuracy does not seem at fault just
reporting.
(with the number of mailboxes in five figures, selective takes approx
16-28 hours.   If duration
is not greater than this figure, totals are not reported/logged but the
full selective completes.
I can check this by trolling thru actlog for a couple of hours.)

I have a perl script which gathers all the info for each domino instance
each night (30),
and puts it into a HTML file, emails it to several people using a perl
module to attach
multiple files to sendmail message.   This gives us a single email with
everything in it.
Not perfect, but easily understood.

Also shows if it is an Incremental, Selective, Archivelog or Journal
backup that is running.

example of output is

TSM Backups - Report by Domino Instance
DOMMPXX
mpxx 14-02-2007 20:05:13
=
mpxx 14-02-2007 20:05:13 Request   : INCREMENTAL
mpxx 14-02-2007 20:05:13 Database Input List   : *
mpxx 14-02-2007 20:05:13 Number of Buffers : 8
mpxx 14-02-2007 20:05:13 Buffer Size   : 8192
mpxx 14-02-2007 20:05:13 Wait for Tape Mounts? : Yes
mpxx 14-02-2007 20:05:13 Process Subdirectories?   : Yes
mpxx 14-02-2007 20:05:13 TSM Options File  :
mpxx 14-02-2007 20:05:13 TSM Nodename Override :
mpxx 14-02-2007 20:05:13
-
mpxx 14-02-2007 20:50:29 Total Domino databases inspected: xxx,xxx
mpxx 14-02-2007 20:50:29 Total Domino databases backed up: 280
mpxx 14-02-2007 20:50:29 Total Domino databases excluded:  0
mpxx 14-02-2007 20:50:29 Total Domino backup objects expired:  0
mpxx 14-02-2007 20:50:29 Throughput rate: 30,706.19 Kb/Sec
mpxx 14-02-2007 20:50:29 Total bytes transferred: 128,688,590,848
mpxx 14-02-2007 20:50:29 Elapsed processing time: 1,704.68 Secs
mpxx 14-02-2007 20:50:31
=
mpxx 14-02-2007 20:50:31 Request   : ARCHIVELOG
mpxx 14-02-2007 20:50:31 Number of Buffers : 8
mpxx 14-02-2007 20:50:31 Buffer Size   : 8192
mpxx 14-02-2007 20:50:31 Wait for Tape Mounts? : Yes
mpxx 14-02-2007 20:50:31 Threshold high: 0
mpxx 14-02-2007 20:50:31 Threshold low : 0
mpxx 14-02-2007 20:50:31 TSM Options File  :
mpxx 14-02-2007 20:50:31 TSM Nodename Override :
mpxx 14-02-2007 20:50:31
-
mpxx 14-02-2007 20:52:14 Total Domino transaction log files ready for
archive: 26
mpxx 14-02-2007 20:52:14 Total Domino transaction log files archived:  26
mpxx 14-02-2007 20:52:14 Throughput rate: 27,052.07 Kb/Sec
mpxx 14-02-2007 20:52:14 Total bytes transferred: 45,744,857,088
mpxx 14-02-2007 20:52:14 Elapsed processing time: 99.93 Secs





Allan Mills | AIX and TSM Administrator
Business & Technology Services | New South Wales Police

8835 9286 (internal 29286)



Ronald Le Large <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" 
15/02/2007 00:04
Please respond to
"ADSM: Dist Stor Manager" 


To
ADSM-L@VM.MARIST.EDU
cc

Subject
[ADSM-L] SQL date convert







Hi everybody,

  The last time when I posted a question I received a few very useful and
quick replies. Thx for that. Hopefully this question is also easy for a
few of you to answer.

  Case:
  A client want's to know how big the daily backup is for a Lotus client
backedp up via TDP.
  I can embed a "query actlog begind=-1 node=[nodename] msg=4991 " in a
script but the output is useless (even with grep) because TDP reports a
summary for every *.nfs its backing up and I am only interested in the
total bytes transferred. (which is also reported with msg 4991 at the end
of the log).
  The alternative (which has my preference ) is an sql query:
  select START_TIME,ACTIVITY,ENTITY from summary where ENTITY='[nodename]'
and ACTIVITY='BACKUP'
  but I struggle with the date.
  The format TSM is using in its table is
  2007-01-15 21:08:34.00
  I am only interested in the backupsize of last night so I use "
START_TIME='2007-02-14%' but that is obviously not the correct syntax.
  Does anyone of you know how I must convert the date ? Or is there a
possibility to use something like "today-1" like you use with a q actlog.

  Your advise would be highly appreciated.
  Thx in advance,
  Abulifia


-
 New Yahoo! Mail is the ultimate force in competitive emailing. Fi

Re: How to query the volume name when I need restore

[Gill, Geoffrey L.]

Another one of the problems I have with TSM is this issue. At the time I
had the same issue as you Wira. I went through a lengthy test trace with
IBM a few years ago and found that was the only way to get a list of
tapes the system needed for the restore. As I recall the list seemed to
be in order of use. 

 
Geoff Gill 
TSM Administrator 
PeopleSoft Sr. Systems Administrator 
SAIC M/S-G1b 
(858)826-4062 
Email: [EMAIL PROTECTED] 


Hi,
   I used TSM for long time. Until now I'm still feel bad every time
when I
have to restore data especially when restore data from API (TDP for
oracle
and backup image). The restore data size is very huge so they need more
than
one volume to restore. Unfortunable I cannot maintain all backup volumes
in
the library. So there are some volumes place out of library. Every time
I
plan to setup restore schedule in the night but I cannot reliably that
the
restore will be compeleted because I don't know which volume should
checked
in before. Any idea please suggest.

Best Regards,

Wira Chinwong
Engineering Department Manager

SCSI Co., Ltd.
719 KPN Tower Bldg., 11th Floor, Bangkapi, Huaykwang, Bangkok 10310 Tel
02-7171066-7  Fax 0-27171068
E-mail: [EMAIL PROTECTED]

Re: How to query the volume name when I need restore

[Drew, Shawn]

You have to decide on the implication on production of this, but
something I vaguely remember doing once...
-  perform the volume usage command
-  Set all the applicable tapes to "unavailable" (temporarily)
-  Perform the restore, expecting failures
-  Search the actlog for the mount errors and compile your list.
-  Undo the "unavailable" settings

-Shawn

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Wira Chinwong
Sent: Wednesday, February 14, 2007 1:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How to query the volume name when I need restore


Hi Rebert,
  Thanks you very much for your recommendation. But it still not
convenient to me. Because I have more 50 volumes which related to the
restoration node. Some time more than 30 volumes are put out of library.
It's not comfortable to checkin all volumes of that node for restore
which actually the number of volume may be need 3-6 volumes for
restoration. I ever use bmc and I'm very appriciate to the dry run
option. TSM should develop this one which I think it is very useful for
client.

Wira.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Robert Ouzen Ouzen
Sent: Wednesday, February 14, 2007 3:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How to query the volume name when I need restore

Hi Wira

Maybe this script will help you:

select node_name , volume_name, stgpool_name, filespace_name from
volumeusage where node_name=upper('$1')

Say you name it: Restore_vol

Run restore_vol nodename

Regards
Robert Ouzen
Haifa University
Israel

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Wira Chinwong
Sent: Wednesday, February 14, 2007 10:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] How to query the volume name when I need restore

Hi,
   I used TSM for long time. Until now I'm still feel bad every time
when I have to restore data especially when restore data from API (TDP
for oracle and backup image). The restore data size is very huge so they
need more than one volume to restore. Unfortunable I cannot maintain all
backup volumes in the library. So there are some volumes place out of
library. Every time I plan to setup restore schedule in the night but I
cannot reliably that the restore will be compeleted because I don't know
which volume should checked in before. Any idea please suggest.

Best Regards,

Wira Chinwong
Engineering Department Manager

SCSI Co., Ltd.
719 KPN Tower Bldg., 11th Floor, Bangkapi, Huaykwang, Bangkok 10310 Tel
02-7171066-7  Fax 0-27171068
E-mail: [EMAIL PROTECTED]


-
The information contained in this e-mail message, and any
attachment thereto, is confidential and may not be disclosed
without our express permission. If you are not the intended
recipient or an employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that you
have received this message in error and that any review,
dissemination, distribution or copying of this message, or any
attachment thereto, in whole or in part, is strictly prohibited. If
you have received this message in error, please immediately notify
us by telephone, fax or e-mail and delete the message and all of
its attachments. Thank you. Every effort is made to keep our
network free from viruses. You should, however, review this e-mail
message, as well as any attachment thereto, for viruses. We take no
responsibility and have no liability for any computer virus which
may be transferred via this e-mail message.

Re: How to query the volume name when I need restore

[Wira Chinwong]

Hi Rebert,
  Thanks you very much for your recommendation. But it still not convenient
to me. Because I have more 50 volumes which related to the restoration node.
Some time more than 30 volumes are put out of library. It's not comfortable
to checkin all volumes of that node for restore which actually the number of
volume may be need 3-6 volumes for restoration. I ever use bmc and I'm very
appriciate to the dry run option. TSM should develop this one which I think
it is very useful for client.

Wira.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Robert Ouzen Ouzen
Sent: Wednesday, February 14, 2007 3:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How to query the volume name when I need restore

Hi Wira

Maybe this script will help you:

select node_name , volume_name, stgpool_name, filespace_name from
volumeusage where node_name=upper('$1')

Say you name it: Restore_vol

Run restore_vol nodename

Regards
Robert Ouzen
Haifa University
Israel

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Wira Chinwong
Sent: Wednesday, February 14, 2007 10:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] How to query the volume name when I need restore

Hi,
   I used TSM for long time. Until now I'm still feel bad every time when I
have to restore data especially when restore data from API (TDP for oracle
and backup image). The restore data size is very huge so they need more than
one volume to restore. Unfortunable I cannot maintain all backup volumes in
the library. So there are some volumes place out of library. Every time I
plan to setup restore schedule in the night but I cannot reliably that the
restore will be compeleted because I don't know which volume should checked
in before. Any idea please suggest.

Best Regards,

Wira Chinwong
Engineering Department Manager

SCSI Co., Ltd.
719 KPN Tower Bldg., 11th Floor, Bangkapi, Huaykwang, Bangkok 10310 Tel
02-7171066-7  Fax 0-27171068
E-mail: [EMAIL PROTECTED]

Re: SQL date convert

[Andrew Raibeck]

Try searching the ADSM-L archives for terms like "current_timestamp". Here
is one entry that might be helpful:

http://adsm.org/lists/html/ADSM-L/2005-01/msg00511.html

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager"  wrote on 02/14/2007
06:04:52 AM:

> Hi everybody,
>
>   The last time when I posted a question I received a few very
> useful and quick replies. Thx for that. Hopefully this question is
> also easy for a few of you to answer.
>
>   Case:
>   A client want's to know how big the daily backup is for a Lotus
> client backedp up via TDP.
>   I can embed a "query actlog begind=-1 node=[nodename] msg=4991 "
> in a script but the output is useless (even with grep) because TDP
> reports a summary for every *.nfs its backing up and I am only
> interested in the total bytes transferred. (which is also reported
> with msg 4991 at the end of the log).
>   The alternative (which has my preference ) is an sql query:
>   select START_TIME,ACTIVITY,ENTITY from summary where
> ENTITY='[nodename]' and ACTIVITY='BACKUP'
>   but I struggle with the date.
>   The format TSM is using in its table is
>   2007-01-15 21:08:34.00
>   I am only interested in the backupsize of last night so I use "
> START_TIME='2007-02-14%' but that is obviously not the correct syntax.
>   Does anyone of you know how I must convert the date ? Or is there
> a  possibility to use something like "today-1" like you use with a q
actlog.
>
>   Your advise would be highly appreciated.
>   Thx in advance,
>   Abulifia
>
>
> -
>  New Yahoo! Mail is the ultimate force in competitive emailing. Find
> out more at the Yahoo! Mail Championships. Plus: play games and win
prizes.

Re: Message ANR1163W during Copy Storage Pool Recamation

[Tim Brown]

It was that that the storage pool exceeed the number of available
volumes. I didnt see that message till now

Tim

- Original Message -
From: "Mark Stapleton" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, February 14, 2007 10:59 AM
Subject: Re: Message ANR1163W during Copy Storage Pool Recamation


...or when you have tapes in the primary pool that are in an "unavailable"
access state. (This is what I usually find.)

--
Mark Stapleton ([EMAIL PROTECTED])
Senior consultant



From: ADSM: Dist Stor Manager on behalf of Zoltan Forray/AC/VCU
Sent: Wed 2/14/2007 9:55 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Message ANR1163W during Copy Storage Pool Recamation



I usually get those when reclamation is canceled or there is a problem
getting to the primary backup tape (operators asleep at the wheel - tape
not in library).




Tim Brown <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" 
02/14/2007 10:53 AM
Please respond to
"ADSM: Dist Stor Manager" 


To
ADSM-L@VM.MARIST.EDU
cc

Subject
[ADSM-L] Message ANR1163W during Copy Storage Pool Recamation






Receive this messsage during copy storage pool reclamation.

ANR1163W Offsite volume A02096 still contains files which could not be
moved.

It displays for 19 different tapes.

How can this be resolved so I can reclaim these tapes.

Tim Brown
Systems Specialist
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: [EMAIL PROTECTED]
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255

Re: SQL date convert

[Mark Stapleton]

There is a much easier way to do this. 
 
Assuming you've got TSM accounting turned on at the server, look for the 
dsmaccnt.log (c:\program files\tivoli\tsm\server1 on a Windows box, 
/usr/tivoli/tsm/server/bin on an AIX box). This is a comma-delimited file 
broken down by date, time, and node name, and contains all client activity 
(including bytes transferred).
 
If you import the file to an Excel spreadsheet, look at column Q.
 
--
Mark Stapleton ([EMAIL PROTECTED])
Senior consultant
 


From: ADSM: Dist Stor Manager on behalf of Ronald Le Large
Sent: Wed 2/14/2007 7:04 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL date convert



Hi everybody,
  
  The last time when I posted a question I received a few very useful and quick 
replies. Thx for that. Hopefully this question is also easy for a few of you to 
answer.
  
  Case:
  A client want's to know how big the daily backup is for a Lotus client 
backedp up via TDP.
  I can embed a "query actlog begind=-1 node=[nodename] msg=4991 " in a script 
but the output is useless (even with grep) because TDP reports a summary for 
every *.nfs its backing up and I am only interested in the total bytes 
transferred. (which is also reported with msg 4991 at the end of the log).
  The alternative (which has my preference ) is an sql query:
  select START_TIME,ACTIVITY,ENTITY from summary where ENTITY='[nodename]' and 
ACTIVITY='BACKUP'
  but I struggle with the date.
  The format TSM is using in its table is
  2007-01-15 21:08:34.00
  I am only interested in the backupsize of last night so I use " 
START_TIME='2007-02-14%' but that is obviously not the correct syntax.
  Does anyone of you know how I must convert the date ? Or is there a  
possibility to use something like "today-1" like you use with a q actlog.
  
  Your advise would be highly appreciated.
  Thx in advance,
  Abulifia

   
-
 New Yahoo! Mail is the ultimate force in competitive emailing. Find out more 
at the Yahoo! Mail Championships. Plus: play games and win prizes.

Re: Cloning clients / retaining existing backups

[Thomas Denier]

-Zoltan Forray wrote: -

>What are the factors that determine if a file/filesystem is "new" vs
>"already there - this is just a new backup".
>
>Given the following scenario:
>
>1.  Box "A" has existing backups.
>2. Create a clone of box "A" - call it "B" . "B" is identical in
>*EVERY* way as far as the filesystem/OS is concerned. Only required
>changes are the IP address and hostname.  The DSM.SYS is copied
>from  box "A".
>3.  We turn off box "A" backups and now want to backup box "B"
>
>Would the first backup of "B" consider everything "brand new" and
>ignore/flush all existing backups or would it not notice anything
>different and just think it is a normal, daily backup?
>
>How can we accomplish this without flushing existing backups or
>doing a complete "first pass" backup of everything ?
>
>The boxes in question are Solaris and/or Linux.

You don't say whether the dsm.sys file has a 'nodename' line.
If it does not, the first backup of B will undoubtedly be a
full backup, since B will be a different node than A.

If the node names do in fact match, I would expect just a typical
daily backup, if the file system contents are completely identical.
We have never cloned an entire system as described above, but we
have copied disk contents to new hardware many times. We have found
that file oriented copying mechanisms such as rsync usually change
the inode number associated with specific file name. This does not
cause all the affected files to be backed up, but does cause TSM toupdate
the attributes of all those files.

Re: Error restoring SQL database

[Loon, E.J. van - SPLXM]

Hi Andy!
No, the log isn't showing more detail.
Together with support, I have identified the tapes on which the backup
resides. I'm currently running an audit on these tapes. Let's wait for
the results...
Thanks for now!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Raibeck
Sent: dinsdag 13 februari 2007 14:21
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Error restoring SQL database

If you haven't already looked up the message, you should do so, as it
does provide a little more information.

Are you sure that the ANR0548W message is the *only* related message to
this condition? When searching the actlog, don't do any filtering,
except for the timeframe (I'd start with a timeframe from when the
client operation started through when it ended).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED]

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan
ager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager"  wrote on 02/13/2007
04:09:59 AM:

> Hi *SM-ers!
> Our SQL guys are trying to restore a SQL database. They receive the 
> following error:
>
> ANS1314E File data currently unavailable on server
>
> In the TSM activity log I see the following message:
>
> ANR0548W Retrieve or restore failed for session 2337961 for node 
> KL1007W9-SQL (TDP MSSQL Win32) processing file space 
> KL1007W9\data\0001
> 2 for file \Zeus\ full stored as Backup - error detected.
>
> Error detected. Right... How do I find what kind of error?
> Thank you very much for your reply!!!
> Kindest regards,
> Eric van Loon
> KLM Royal Dutch Airlines
>
>
> **
> For information, services and offers, please visit our web site:
> http://www.klm.com. This e-mail and any attachment may contain 
> confidential and privileged material intended for the addressee only. 
> If you are not the addressee, you are notified that no part of the 
> e-mail or any attachment may be disclosed, copied or distributed, and 
> that any other action related to this e-mail or attachment is strictly

> prohibited, and may be unlawful. If you have received this e-mail by 
> error, please notify the sender immediately by return e-mail, and 
> delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its

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


**
For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), 
its subsidiaries and/or its employees shall not be liable for the incorrect or 
incomplete transmission of this e-mail or any attachments, nor responsible for 
any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286 
**

Re: SQL date convert

[PAC Brion Arnaud]

Abulifia,

Something like : "where cast((current_timestamp- end_time )hours as
decimal) <= 24" should do the trick ... 

However, if I remember properly, TDP's activity is not reported properly
in summary table ... Double check before trusting your query !

Cheers.

Arnaud 


**
Panalpina Management Ltd., Basle, Switzerland, 
CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]

**

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Ronald Le Large
Sent: Wednesday, 14 February, 2007 14:05
To: ADSM-L@VM.MARIST.EDU
Subject: SQL date convert

Hi everybody,
   
  The last time when I posted a question I received a few very useful
and quick replies. Thx for that. Hopefully this question is also easy
for a few of you to answer.
   
  Case:
  A client want's to know how big the daily backup is for a Lotus client
backedp up via TDP.
  I can embed a "query actlog begind=-1 node=[nodename] msg=4991 " in a
script but the output is useless (even with grep) because TDP reports a
summary for every *.nfs its backing up and I am only interested in the
total bytes transferred. (which is also reported with msg 4991 at the
end of the log). 
  The alternative (which has my preference ) is an sql query: 
  select START_TIME,ACTIVITY,ENTITY from summary where
ENTITY='[nodename]' and ACTIVITY='BACKUP'
  but I struggle with the date.
  The format TSM is using in its table is
  2007-01-15 21:08:34.00
  I am only interested in the backupsize of last night so I use "
START_TIME='2007-02-14%' but that is obviously not the correct syntax. 
  Does anyone of you know how I must convert the date ? Or is there a
possibility to use something like "today-1" like you use with a q
actlog.
   
  Your advise would be highly appreciated.
  Thx in advance,
  Abulifia


-
 New Yahoo! Mail is the ultimate force in competitive emailing. Find out
more at the Yahoo! Mail Championships. Plus: play games and win prizes.

Re: Message ANR1163W during Copy Storage Pool Recamation

[Mark Stapleton]

...or when you have tapes in the primary pool that are in an "unavailable" 
access state. (This is what I usually find.)
 
--
Mark Stapleton ([EMAIL PROTECTED])
Senior consultant



From: ADSM: Dist Stor Manager on behalf of Zoltan Forray/AC/VCU
Sent: Wed 2/14/2007 9:55 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Message ANR1163W during Copy Storage Pool Recamation



I usually get those when reclamation is canceled or there is a problem
getting to the primary backup tape (operators asleep at the wheel - tape
not in library).




Tim Brown <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" 
02/14/2007 10:53 AM
Please respond to
"ADSM: Dist Stor Manager" 


To
ADSM-L@VM.MARIST.EDU
cc

Subject
[ADSM-L] Message ANR1163W during Copy Storage Pool Recamation






Receive this messsage during copy storage pool reclamation.

ANR1163W Offsite volume A02096 still contains files which could not be
moved.

It displays for 19 different tapes.

How can this be resolved so I can reclaim these tapes.

Tim Brown
Systems Specialist
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: [EMAIL PROTECTED]
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255

Re: Message ANR1163W during Copy Storage Pool Recamation

[Zoltan Forray/AC/VCU]

I usually get those when reclamation is canceled or there is a problem
getting to the primary backup tape (operators asleep at the wheel - tape
not in library).




Tim Brown <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" 
02/14/2007 10:53 AM
Please respond to
"ADSM: Dist Stor Manager" 


To
ADSM-L@VM.MARIST.EDU
cc

Subject
[ADSM-L] Message ANR1163W during Copy Storage Pool Recamation






Receive this messsage during copy storage pool reclamation.

ANR1163W Offsite volume A02096 still contains files which could not be
moved.

It displays for 19 different tapes.

How can this be resolved so I can reclaim these tapes.

Tim Brown
Systems Specialist
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: [EMAIL PROTECTED]
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255

Message ANR1163W during Copy Storage Pool Recamation

[Tim Brown]

Receive this messsage during copy storage pool reclamation.

ANR1163W Offsite volume A02096 still contains files which could not be
moved.

It displays for 19 different tapes.

How can this be resolved so I can reclaim these tapes.

Tim Brown
Systems Specialist
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: [EMAIL PROTECTED]
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255

Cloning clients / retaining existing backups

[Zoltan Forray/AC/VCU]

What are the factors that determine if a file/filesystem is "new" vs
"already there - this is just a new backup".

Given the following scenario:

1.  Box "A" has existing backups.
2.  Create a clone of box "A" - call it "B" .  "B" is identical in *EVERY*
way as far as the filesystem/OS is concerned. Only required changes are
the IP address and hostname.  The DSM.SYS is copied from  box "A".
3.  We turn off box "A" backups and now want to backup box "B"

Would the first backup of "B" consider everything "brand new" and
ignore/flush all existing backups or would it not notice anything
different and just think it is a normal, daily backup?

How can we accomplish this without flushing existing backups or doing a
complete "first pass" backup of everything ?

The boxes in question are Solaris and/or Linux.

Re: Can't restore when tape in overflow area

[Orin Rehorst]

Thanks. That worked.

Regards, 
Orin

Orin Rehorst

* e-mail:  [EMAIL PROTECTED] 
( Phone:  (713)670-2443 
7Fax:  (713)670-2457 

 


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Tuesday, February 13, 2007 12:43 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Can't restore when tape in overflow area

On Feb 13, 2007, at 12:21 PM, Orin Rehorst wrote:

> Restore won't work when tape called is in overflow area. It's marked
> unavailable. What am I missing please?

That would be the result of failing to respond to a Request in time,
such that it timed out and marked the volume Unavailable.  When using
overflow tape storage locations, solid procedures need to be in place
to assure the timely servicing of mount requests.  Change the volume
to Read/Write and give the procedures an observed test.

 Richard Sims

Re: Pricing model for 5.4

[Kauffman, Tom]

I don't even bother with manual spreadsheet; I do scribble on small
yellow pad once a year. We've gone from 'node-level' licensing that made
no sense -- an SP-frame is a node, with up to 32 CPUs in 16 boxes under
ADSM 2.x (needs 16 node registrations at the server); to node-level
where a box is a node (but you may need to set it up under several IDs,
each of which looks like a separate node on the server); to CPU-based
licensing (and we paid about 60% of list on each node to convert to
cpu-based licenses) where you may still need to define the system
multiple times to TSM, but at least it isn't trying to count any more;
to the current 'processor value base' -- and I'm not going to try
counting systems until renewal time (Novemeber, for us).

And I see I left out the cpu-based pricing where server cpus cost more
than client cpus, and if someone's laptop had an accessable file share
it was a server . . .

My over-all cpu count has been constant for the last few years; we
picked up a few extra licenses when we did the node to cpu conversion,
and I've a few systems (SAP App servers) that don't need to be backed
up, so those cpu licenses get used elsewhere.

But -- until the product does a better job of tracking -- I'm going to
stick to my once per year scratch-pad audit and reconciliation; I'm not
paid for, nor does my job description cover, vendor licensing
compliance.

Tom Kauffman
NIBCO, Inc

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Allen S. Rout
Sent: Wednesday, February 14, 2007 9:19 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Pricing model for 5.4

I was a little surprised at Steve's cautious response to my
post. Looking over it I think I understand it now, and it makes me
want to emphasize that I'm not advocating just ignoring the issue
("Don't worry about it too much").  Focus on the "too much", not the
"don't worry". :)

If you develop a measure by which you understand your licensure, (and
good lord I hope it's automated instead of manual spreadsheet
nonsense) then apply it and pay by it.  Operate in good faith, but
don't angst yourself too much about getting the next significant
figure right.  We're accustomed to being able to report activity to 10
sig-figs: (TB measures, down to the byte).. it feels odd to have 2.
If you try for 4, you'll go insane, and you still won't get it.

To bring the conversation back around, if we had a better licensure
measure in the server, we could at least have consistent numbers... :)



- Allen S. Rout
CONFIDENTIALITY NOTICE:  This email and any attachments are for the 
exclusive and confidential use of the intended recipient.  If you are not
the intended recipient, please do not read, distribute or take action in 
reliance upon this message. If you have received this in error, please 
notify us immediately by return email and promptly delete this message 
and its attachments from your computer system. We do not waive  
attorney-client or work product privilege by the transmission of this
message.

Re: Pricing model for 5.4

[Allen S. Rout]

I was a little surprised at Steve's cautious response to my
post. Looking over it I think I understand it now, and it makes me
want to emphasize that I'm not advocating just ignoring the issue
("Don't worry about it too much").  Focus on the "too much", not the
"don't worry". :)

If you develop a measure by which you understand your licensure, (and
good lord I hope it's automated instead of manual spreadsheet
nonsense) then apply it and pay by it.  Operate in good faith, but
don't angst yourself too much about getting the next significant
figure right.  We're accustomed to being able to report activity to 10
sig-figs: (TB measures, down to the byte).. it feels odd to have 2.
If you try for 4, you'll go insane, and you still won't get it.

To bring the conversation back around, if we had a better licensure
measure in the server, we could at least have consistent numbers... :)



- Allen S. Rout

SQL date convert

[Ronald Le Large]

Hi everybody,
   
  The last time when I posted a question I received a few very useful and quick 
replies. Thx for that. Hopefully this question is also easy for a few of you to 
answer.
   
  Case:
  A client want's to know how big the daily backup is for a Lotus client 
backedp up via TDP.
  I can embed a "query actlog begind=-1 node=[nodename] msg=4991 " in a script 
but the output is useless (even with grep) because TDP reports a summary for 
every *.nfs its backing up and I am only interested in the total bytes 
transferred. (which is also reported with msg 4991 at the end of the log). 
  The alternative (which has my preference ) is an sql query: 
  select START_TIME,ACTIVITY,ENTITY from summary where ENTITY='[nodename]' and 
ACTIVITY='BACKUP'
  but I struggle with the date.
  The format TSM is using in its table is
  2007-01-15 21:08:34.00
  I am only interested in the backupsize of last night so I use " 
START_TIME='2007-02-14%' but that is obviously not the correct syntax. 
  Does anyone of you know how I must convert the date ? Or is there a  
possibility to use something like "today-1" like you use with a q actlog.
   
  Your advise would be highly appreciated.
  Thx in advance,
  Abulifia


-
 New Yahoo! Mail is the ultimate force in competitive emailing. Find out more 
at the Yahoo! Mail Championships. Plus: play games and win prizes.

Re: What is the licensing model for TSM?

[Richard Sims]

On Feb 14, 2007, at 4:40 AM, Douglas Currell wrote:


 BTW. What is a "managed processor"?


Douglas -

Search on that term at www.ibm.com, which turns up various
announcements (206-037 is one), wherein there is a small glossary of
the IBM sales terminology.  Such definitions should give you a sense
of how your computer is measured according to the latest marketing
metrics.

Richard Sims

Re: Pricing model for 5.4

[Allen S. Rout]

>> On Wed, 14 Feb 2007 08:22:28 +1000, Steven Harris <[EMAIL PROTECTED]> said:


> I'm not so sure about this.  One of our customers took a rather cavalier
> attitude to TSM licencing, and were using about 3 times as many licences
> as they'd paid for.  IBM via PriceWaterhouseCoopers came in one day
> (possibly triggered by the fact that there had been no new orders for
> licences in a couple of years) and demanded an audit.  Said company then
> had to pony up for all the extra licences *at FULL LIST price*.  No
> negotiation  and no questions accepted.  The alternative would have
> involved lawyers and therefore cost a lot more.

I think I can understand this response out of IBM; no growth at all
over several years seems odd.


- Allen S. Rout

Re: How to query the volume name when I need restore

[Richard Sims]

Wira -

There is no way to determine what volumes will be needed for a
restoral before starting the restoral.  (See "Restoral preview" in
ADSM QuickFacts".)

TSM is an "enterprise" software product, where commensurate hardware
resources are expected to be in place, which includes a library with
all primary volumes in it.  Unfortunately, your company is not
committing hardware resources to meet the scale of the product and
your site needs, leaving you caught in the middle.  The active data
storage pool facility in TSM 5.4 could possibly help your situation;
but, again, it seems unlikely that your company would commit to the
cost of TSM 5.4, either.  Your only alternative is to fully implement
the procedures necessary to support "overflow", as described under
topic "Managing a Full Library" in the Admin Guide manual, which
includes operators responding to mount requests.

   Richard Sims

Re: 5.4 TDP for MSSql Heads up.

[Del Hoobler]

Steve,

I agree with you.  I will take this comment back to the
packaging team and try to get this resolved in the future.
I am sorry for the problems this caused you.

Thanks,

Del



"ADSM: Dist Stor Manager"  wrote on 02/13/2007
10:03:36 PM:

> Many thanks Del, Your continued assistance and participation  on this
> forum is much appreciated.
>
> As to the explanation  while it may make some sense to someone in
> accounting or maybe marketing, it makes no sense to me.  I go to a new
> site to do a TSM install, I download all the *latest* packages from
> Passport Advantage.  I unpack the package and it says 5.4, but when I
> install the banner says 5.2.1.0 and a fix that's has been out for a year
> isn't there, so I have to debug, find the maintenance, download and
> install it taking a good couple of hours that I hadn't expected when I
> quoted on this job.
>
> To my mind, if a new PA package is to be released that says 5.4, then
> re-release the most current maintenance level, with a code change to
> just modify the version number in the banner to match the envelope.  To
> do otherwise makes it look like a packaging error in the passport
> advantage code and undermines confidence in the whole process.  The IT
> business is hard enough without these sorts of illogical spanners in the
> works.
>
> No criticism of the development team here, but whoever decided on this
> packaging of releases needs a size 9 in the backside.
>
> Regards
>
> Steve
>
> Steven Harris
> AIX and TSM Admin
> Brisbane Australia
>
>
>
>
> Del Hoobler wrote:
> > The Data Protection for SQL product was not refreshed in the
> > 5.4 timeframe. That means the most recent Data Protection for SQL
> > "Paid license" package was shipped with the "5.4" packages.
> > That happens to be the 5.2.1.0 package for x32 and ia64
> > and the 5.3.3.0 package for x64.
> >
> > Confusing, I know... it has to do with the fact that many
> > of the DP clients do no need to be refreshed as often as the BA
Client.
> >
> > Either way... if you already have 5.2.1.06 for x32 or ia64
> > or 5.3.3.01 for x64 installed, the older "paid" package
> > should not have installed over the newer one.
> >
> > Thanks,
> >
> > Del
> >
> > 
> >
> >
> > "ADSM: Dist Stor Manager"  wrote on 02/13/2007
> > 05:50:10 PM:
> >
> >
> >> Just a heads up for the list
> >>
> >> I downloaded the 5.4 TDP for Databases for MSSQL from passport
advantage
> >> for a new client - brand new TSM install.  It appears that support
for
> >> SQL Server 2005 has been regressed.  Reverting to the last 5.3
> >> maintenance fixed the problem,
> >>
> >> Regards
> >>
> >> Steve
> >>
> >> Steve Harris
> >> AIX and TSM Admin
> >> Brisbane Australia
> >>
> >
> >
> >

What is the licensing model for TSM?

[Douglas Currell]

Need some help understanding aboyt TSM 5.3 licensing. Thanks...

We run TSM 5.2.2 on Linux (Suse) with one dual drive tape library and our 
licensing looks like this:

(lines containing "0" edited out)

Last License Audit: 02/14/2007 04:08:08 AM
  
   Is Tivoli Disaster Recovery Manager in use ?: No
 Is Tivoli Disaster Recovery Manager licensed ?: No
  Is Library Sharing in use: No
Is Library Sharing licensed: No
Number of Managed System for LAN in use: 52
  Number of Managed System for LAN licensed: 57
 Number of Managed Libraries in use: 1
   Number of Managed Libraries licensed: 1
   Tivoli Data Protection for NDMP in use ?: No
 Tivoli Data Protection for NDMP licensed ?: No
 Is Tivoli Storage Manager for Data Retention in use ?: No
Is Tivoli Storage Manager for Data Retention licensed ?: No
  Server License Compliance: Valid


The plan is to upgrade to 5.3 and add another nearly identical library. 
Incidentally, +95% of out TSM clients use a single processor. BTW. What is a 
"managed processor"?

Should we be charged by processor or by client or by both? what about the TSM 
server?


-
The best gets better. See why everyone is raving about the All-new Yahoo! Mail. 
 

SV: [ADSM-L] Failed Exckange Restore ACN5798E..

[Nielsen, Bo]

Thanks for all the reply.

I didn't have added the DB to the Recovery Group.
When I did, it work. 

Regards 

Bo

-Oprindelig meddelelse-
Fra: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] På vegne af Del Hoobler
Sendt: 13. februar 2007 15:03
Til: ADSM-L@VM.MARIST.EDU
Emne: Re: [ADSM-L] Failed Exckange Restore ACN5798E..

Bo,

Are you restoring to a Recovery Storage Group?
If so, did you add the database to the Recovery Storage Group before performing 
the restore?

If not, does the storage group name AND database name EXACTLY match (including 
casing and and all characters) the one that was in the backup?
The Exchange Server will fail the backup if either of those two things is not 
true when restoring.

Thanks,

Del




"ADSM: Dist Stor Manager"  wrote on 02/13/2007
08:29:04 AM:

> Hi
>
> In a Exchange MSCluster, I try to restore a DB, but get the Errorcode:
>
> ACN5798E MS Exchange API HRESERESTOREADDDATABASE() failed with HRESULT:
> 0xc7fe1f42 -
>
> I have made a failover to the other node, but it doesn't work.
>
> TSM server 5.3.4
> TDP vers.  5.2.1
>
> aOaRegards
> Bo Nielsen

Re: How to query the volume name when I need restore

[Robert Ouzen Ouzen]

Hi Wira

Maybe this script will help you:

select node_name , volume_name, stgpool_name, filespace_name from volumeusage 
where node_name=upper('$1')

Say you name it: Restore_vol 

Run restore_vol nodename

Regards
Robert Ouzen
Haifa University
Israel

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Wira 
Chinwong
Sent: Wednesday, February 14, 2007 10:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] How to query the volume name when I need restore

Hi,
   I used TSM for long time. Until now I'm still feel bad every time
when I have to restore data especially when restore data from API (TDP
for oracle and backup image). The restore data size is very huge so they
need more than one volume to restore. Unfortunable I cannot maintain all
backup volumes in the library. So there are some volumes place out of
library. Every time I plan to setup restore schedule in the night but I
cannot reliably that the restore will be compeleted because I don't know
which volume should checked in before. Any idea please suggest.
 
Best Regards,
 
Wira Chinwong
Engineering Department Manager
 
SCSI Co., Ltd.   
719 KPN Tower Bldg., 11th Floor, Bangkapi, 
Huaykwang, Bangkok 10310
Tel 02-7171066-7  Fax 0-27171068
E-mail: [EMAIL PROTECTED]
  
  
 
 

How to query the volume name when I need restore

[Wira Chinwong]

Hi,
   I used TSM for long time. Until now I'm still feel bad every time
when I have to restore data especially when restore data from API (TDP
for oracle and backup image). The restore data size is very huge so they
need more than one volume to restore. Unfortunable I cannot maintain all
backup volumes in the library. So there are some volumes place out of
library. Every time I plan to setup restore schedule in the night but I
cannot reliably that the restore will be compeleted because I don't know
which volume should checked in before. Any idea please suggest.
 
Best Regards,
 
Wira Chinwong
Engineering Department Manager
 
SCSI Co., Ltd.   
719 KPN Tower Bldg., 11th Floor, Bangkapi, 
Huaykwang, Bangkok 10310
Tel 02-7171066-7  Fax 0-27171068
E-mail: [EMAIL PROTECTED]