Re: Restoring Database to new Location

2006-10-20 Thread Ribeiro, Ricardo
The best thing to do is to mirror the database volumes in the new
location and then delete the originals 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Jason Lee
Sent: Friday, October 20, 2006 10:52 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Restoring Database to new Location

HI there,

could anyone confirm that if one takes a backup of the database, then
changes the location of the database files in devconfig and then does a
restore of the db, it'll do the right thing and restore to the new
locations... assuming you have dbvs dsmfmt'd in place?

I have a 1/2 TB database to move, and going the delete dbv route will
take days to complete - hence the question.


Thanks


Jason


--
Jason Lee
DreamWorks Animation
(818) 695-3782


Re: Restoring Database to new Location

2006-10-20 Thread Ribeiro, Ricardo
Here is the commands...
DEFine DBCopy--volume_name--copy_volume_name->

>--++--><
   |   .-Wait--=--No--. |
   '-Formatsize--=--megabytes--+--+-'
   '-Wait--=--+-No--+-'
  '-Yes-'

Then delete the original ones when the sync process finishes 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Jason Lee
Sent: Friday, October 20, 2006 11:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Restoring Database to new Location

Interesting, what does that mean, exactly?

I have the databases, create a mirror copy, and then do a delete dbv?


Thanks for your  help.



Jason



On Oct 20, 2006, at 10:59 AM, Ribeiro, Ricardo wrote:

> The best thing to do is to mirror the database volumes in the new 
> location and then delete the originals
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf 
> Of Jason Lee
> Sent: Friday, October 20, 2006 10:52 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Restoring Database to new Location
>
> HI there,
>
> could anyone confirm that if one takes a backup of the database, then 
> changes the location of the database files in devconfig and then does 
> a restore of the db, it'll do the right thing and restore to the new 
> locations... assuming you have dbvs dsmfmt'd in place?
>
> I have a 1/2 TB database to move, and going the delete dbv route will 
> take days to complete - hence the question.
>
>
> Thanks
>
>
> Jason
>
>
> --
> Jason Lee
> DreamWorks Animation
> (818) 695-3782


TSM DB occupied space

2006-10-25 Thread Ribeiro, Ricardo
Hello, 
Can somebody please tell me if the TSM DB occupy's more space if a node
has more data then a node that has more files?
Example:
Node A has 200 files but 1 TB of storage on the TSM pool
Node B has 2 files but 200 GB of storage on the TSM pool
Which occupies more space on the TSM DB?
 
Thanks!


Re: How do you verify the Completion and Accuracy of Backups and Restores?

2006-11-08 Thread Ribeiro, Ricardo
Try ServerGraph or Bocada, they both do a good job on reporting 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Wesley Smith
Sent: Wednesday, November 08, 2006 8:41 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] How do you verify the Completion and Accuracy of
Backups and Restores?

 
Hi All,

I've just joined this group and I am pleased to see a lot of
healthy discussion going on.  The main reason I joined the group has to
do with trying to find some way to help out the people who are
responsible for dealing with Tivoli Storage Manager at a neighboring
agency.  I represent a State agency in Louisiana.  We do a lot of large
applications for Statewide users as well as departmental support.  We do
not have to deal with the H/W  and OS issues.  That's someone else's
job.  That also means that they are responsible for the backup and
recovery procedures for our application servers.  That's where Tivoli
and you guys come in.

My problem is that they (that sister agency) do not seem to have
a reliable way of verifying that all backups have been properly
completed.  They don't even seem to have a way to know that all files
(that need to be backed up) are being backed up.  I've seen the reports
that get generated during the backup process and I am definitely
unimpressed.  Backups start and backups complete.  There doesn't seem to
be anything that says how many rows are copied or how large the files
are or anything else that could be used for verifying the accuracy of
the backups.  They tell my folks that we should trust Tivoli is doing
the job correctly.  Trust is the problem

We have needed to have restores done on just a few databases in
the past and the restores were not complete and up to date.  In each
case we were able to rebuild the data using logs maintained within the
applications but that should not have been necessary.  Each recovery was
done at a point after a backup and before additional processing had been
done within the apps so they should have been complete.  In each case,
the folks who run Tivoli for us were able to track down and show that
problems had occurred during the processing of the backups.  They did
this through circumstantial evidence and in each case once again said
that they have no way of verifying that the backups are actually good.
I hear a lot about the difficulty of trying to write a program to
process the Tivoli log files.

I think I'm at wit's end with these folks and the product.  I
know that the people are competent and I suspect that the product (like
other things available from IBM) really is weak on the reporting and
verification issue.  I'm hoping that someone out there in the Big Wide
World has already solved this problem with an in-house or third-party
solution.  Sorry for being so long winded.  Any ideas...?

Wesley Smith


Re:

2006-11-08 Thread Ribeiro, Ricardo
You could try pointing your web browser to the TCP/IP address of the
library and use the gui there to find the physical count of empty slots
then check against TSM and see if there is a mismatch, and if so, try
running audit library

select volume_name from libvolumes where status='Scratch' 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Martinez, Matt
Sent: Wednesday, November 08, 2006 9:23 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L]

Hi all,

I am having problems writing a TSM Script or command finding the
number of empty slots in an IBM 3584 Library, I am running TSM 5.2.4 on
Win2K, and any help will be appreciated.

Thank You,
Matt Martinez
Systems Administrator
IDEXX Laboratories, Inc.
Phone:207-856-0656
Fax:207-856-8320
[EMAIL PROTECTED]


Re:

2006-11-08 Thread Ribeiro, Ricardo
I forgot to give you the other command that displays the number



select count(volume_name) from libvolumes where status='Scratch' 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Martinez, Matt
Sent: Wednesday, November 08, 2006 9:23 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L]

Hi all,

I am having problems writing a TSM Script or command finding the
number of empty slots in an IBM 3584 Library, I am running TSM 5.2.4 on
Win2K, and any help will be appreciated.

Thank You,
Matt Martinez
Systems Administrator
IDEXX Laboratories, Inc.
Phone:207-856-0656
Fax:207-856-8320
[EMAIL PROTECTED]


Q DRMEDIA

2006-11-28 Thread Ribeiro, Ricardo
Hello,
Has anybody seen this issue
 
q drmedia
ANR2032E QUERY DRMEDIA: Command failed - internal server error detected.
ANRD ThreadId<27> issued message 2032 from:  <-0x0001007bb104
AdmQueryDRMedia <-0x0001001e9e58 AdmCommandLocal
<-0x0001001ead98
admCommand <-0x000100507694 SmAdminCommandThread
<-0x0001e9dc
StartThread <-0x092a72dc _pthread_body
ANS8001I Return code 4.
 
Activity log output...
11/28/06   11:48:47  ANR8769E External media management function QUERY
returned
  result=**Undefined**.(SESSION: 76853)
11/28/06   11:48:47  ANR2032E QUERY DRMEDIA: Command failed - internal
server
  error detected.(SESSION: 76853)
11/28/06   11:48:47  ANRD ThreadId<27> issued message 2032 from:
  <-0x00010001bfdc outTextf <-0x0001007bb104
  AdmQueryDRMedia <-0x0001001e9e58
AdmCommandLocal
  <-0x0001001ead98 admCommand
<-0x000100507694
  SmAdminCommandThread <-0x0001e9dc
StartThread
  <-0x092a72dc _pthread_body (SESSION:
76853)
 
I am running TSM server version 5.3.3.0 on AIX with 5.3 ML1.
 
Ricardo Ribeiro
Sr. Storage Administrator 
Charles Schwab & Co., Inc
Phone 602-977-4629
Cell 623-217-4139
Pager  877-478-7623
 


TSM support for NoSQL database

2014-05-29 Thread Ribeiro, Ricardo
Hello,
Does TSM support NoSQL database from a backup/restore point of view?
I have not been able to find any publications on this.
Thank you!


Re: TSM support for NoSQL database

2014-05-29 Thread Ribeiro, Ricardo
Thanks for the info, but I was thinking more from a "hot" backup mode, with 
some kind of agent.
Thanks!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar 
Thompson
Sent: Thursday, May 29, 2014 8:42 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM support for NoSQL database

It seems like this would depend on the NoSQL database in question...

Even if it does not, you have a variety of options:

1. You could backup the files on disk, assuming the DB supports some kind of 
write-head logging that allows you to snapshot it safely.

2. You could get some kind of serialized dump out of it, and backup the dump.

On Thu, May 29, 2014 at 03:38:45PM +0000, Ribeiro, Ricardo wrote:
> Hello,
> Does TSM support NoSQL database from a backup/restore point of view?
> I have not been able to find any publications on this.
> Thank you!

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


Re: TSM support for NoSQL database

2014-05-29 Thread Ribeiro, Ricardo
Right, I saw that link too, but I did not see anything specific to TSM and 
native support for NoSQL or Big Data in general.
Regardless of the version of NoSQL, I just wanted to know if TSM has support 
for "Hot" backup modes or native support without exporting the data as most of 
these types of big data can be in the TB's range and exporting it will not be 
something we can support easily and the same for using tools like hardware base 
snaphosts or anything like that...
Thanks!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ryder, 
Michael S
Sent: Thursday, May 29, 2014 9:16 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM support for NoSQL database

Ricardo - which NoSQL DB are you concerned about?

This article might help:
http://nosql.mypopescu.com/post/73955584612/quick-links-for-how-to-backup-different-nosql

Best regards,

Mike, x7942
RMD IT Client Services


On Thu, May 29, 2014 at 11:44 AM, Ribeiro, Ricardo < 
ricardo.ribe...@schwab.com> wrote:

> Thanks for the info, but I was thinking more from a "hot" backup mode, 
> with some kind of agent.
> Thanks!
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf 
> Of Skylar Thompson
> Sent: Thursday, May 29, 2014 8:42 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] TSM support for NoSQL database
>
> It seems like this would depend on the NoSQL database in question...
>
> Even if it does not, you have a variety of options:
>
> 1. You could backup the files on disk, assuming the DB supports some 
> kind of write-head logging that allows you to snapshot it safely.
>
> 2. You could get some kind of serialized dump out of it, and backup 
> the dump.
>
> On Thu, May 29, 2014 at 03:38:45PM +, Ribeiro, Ricardo wrote:
> > Hello,
> > Does TSM support NoSQL database from a backup/restore point of view?
> > I have not been able to find any publications on this.
> > Thank you!
>
> --
> -- Skylar Thompson (skyl...@u.washington.edu)
> -- Genome Sciences Department, System Administrator
> -- Foege Building S046, (206)-685-7354
> -- University of Washington School of Medicine
>


Re: Upgrade from 5.5 to 7.1 Extractdb/insertdb seems to pause?

2014-07-22 Thread Ribeiro, Ricardo
I didn't think it was possible to go from 5.5 to 7.1 without first going to 6...

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill 
Boyer
Sent: Tuesday, July 22, 2014 12:33 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Upgrade from 5.5 to 7.1 Extractdb/insertdb seems to pause?

What I think the problem is that the server was ordered with 7200RPM NLSAS 
volumes. The customer went back and bought 15K SAS drives. I'm re-doing the 
whole thing starting tomorrow.

When the extract/insert phase was "paused" we could watch the disk usage on the 
7.1 system going crazy. It just wasn't performing well.

Bill

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Michael Roesch
Sent: Friday, July 11, 2014 6:51 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Upgrade from 5.5 to 7.1 Extractdb/insertdb seems to pause?

Hi Bill,

are all DB volumes online or do you have some of them varied offline? We had 
this on our site, where not all DB volume copies were online when we started 
the upgrade.


On Thu, Jul 10, 2014 at 8:48 PM, Bill Boyer  wrote:

> The extractdb and insertdb phase of the upgrade seems to be paused. 
> It's been 40 min and the # bytes read and # records inserted/extracted 
> haven't changed. The disk is being hit hard by the db2syscs process to 
> the database volumes. I've never seen the extract phase do this 
> before. This is my first time for a production upgrade. The source is 
> 30GB at 50% used. During the
> 3:20 the extract has been running this pause has occurred twice. First 
> time for about 50-min and now fo the past 40-min.
>
>
>
> Is this normal now for V7.1 upgrades from V5? It's almost like it's 
> doing the update phase during the extract/insert phase.
>
>
>
> Bill Boyer
> DSS, Inc.
> (610) 927-4407
> "Enjoy life. It has an expiration date." - ??
>


Re: persistent binding T10000D drives on RedHat 6.4

2014-10-06 Thread Ribeiro, Ricardo
I think for non IBM devices, you go here...

For the Tivoli Storage Manager devices: 
Users can issue autoconf, the Tivoli Storage Manager device driver auto 
configure script. This script resides in the /opt/tivoli/tsm/devices/bin 
directory (or in the same directory as the tsmscsi file) to be able to 
configure devices and get all the current special file names and device 
information. The device special file name is /dev/mtX for tape devices and 
/dev/lbX for medium changers.
Tip: Special file name: dev/tsmscsi/mt0, /dev/tsmscsi/lb0
Note: Alternatively, reinstalling the IBM device driver. Tivoli Storage Manager 
device driver updates all the current special file names.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS 
Kurt
Sent: Monday, October 6, 2014 7:51 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] persistent binding T1D drives on RedHat 6.4

Hello everybody,

I'm in the process of configuring Oracle T1D tape drives on RedHat 6.4 
using the TSM device driver 7.1.1 (LAN-free backup), the TSM server 7.1.1 
itself is running on AIX 7.1 .

The autoconf and tsmdlst do show all the drives on the Redhat nodes  but I 
would like to add them to the udev rules so that the device files are 
persistent whenever the server requires a reboot.

Until now, we were using IBM LTO drives and had the following entry in the 
98-lin_tape.rules file for them:

KERNEL=="IBMtape*", ATTRS{serial_num}=="1068100xyz", 
SYMLINK="lin_tape/tsm_drive"

But what is the equivalent entry for a T1D drive? I've tried the following:

KERNEL=="sg*", ATTRS{serial_num}=="57900400abcd", SYMLINK="lin_tape/t10d_drive"

But that doesn't seem to do the trick.  Can anybody assist me towards the 
correct entry?

Many thanks!

Best regards,
Kurt



*** Disclaimer ***
Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel

nv van publiek recht
BTW BE 0244.142.664
RPR Brussel
http://www.vrt.be/gebruiksvoorwaarden


Re: v7 upgrade woes

2016-06-07 Thread Ribeiro, Ricardo
These are the steps that will let you monitor the progress...


nohup /opt/tivoli/tsm/server/bin/dsmserv insertdb sesswait=60 >insert.out 2>&1 &

Monitor the output of the process. Verify that the DSMSERV INSERTDB process has 
issued the following message before continuing to the next step:
ANR1336I INSERTDB: Ready for connections from the source server
Issue the following command to monitor the process output in the insert.out 
file: 
tail -f insert.out





(12)  Start the extraction from the original server. Specify the TCP/IP address 
and port for the V6.3 server. Direct the output of the process to a file for 
monitoring:
run as root ID
nohup /usr/tivoli/tsm/upgrade/bin/dsmupgrd extractdb hladdress=10.xxx.xxx.xxx 
lladdress=1500 >extract.out 2>&1 &
nohup /usr/tivoli/tsm/upgrade/bin/dsmupgrd extractdb hladdress=127.0.0.1 
lladdress=1500 >extract.out 2>&1 &

Monitor the processes for errors and warning messages, and for items that you 
might need to take action on:
tail -f extract.out

(13) Ensure you get something similar to this message:
ANR0900I Processing options file /home/tsminst1/dsmserv.opt.
ANR0921I Tracing is now active to file server.trace.
ANR7811I Using instance directory /home/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0200I Recovery log assigned capacity is 13052 megabytes.
ANR0201I Database assigned capacity is 143352 megabytes.
ANR0306I Recovery log volume mount in progress.
ANR0353I Recovery log analysis pass in progress.
ANR0354I Recovery log redo pass in progress.
ANR0355I Recovery log undo pass in progress.
ANR0352I Transaction recovery complete.
ANR1635I The server machine GUID, 
00.00.00.00.9f.fb.11.db.94.98.08.63.0a.65.cd.15, has initialized.
ANR2283I Database backup trigger defined, but is disabled.
ANR4726I The NAS-NDMP support module has been loaded.
ANR8440E Initialization failed for SCSI library DD565LIB; will retry in 2 
minute(s).
ANR8440E Initialization failed for SCSI library LANFREELIB; will retry in 2 
minute(s).
ANR4029I EXTRACTDB: Database checkpoint started.
ANR4030I EXTRACTDB: Database checkpoint completed.
ANR0610I EXTRACTDB started by ADMINISTRATOR as process 1.
ANR8214E Session open with 10.xxx.xxx.xxx failed due to connection refusal.
ANR0454E Session rejected by server $UPGRADETARGET$, reason: Communication 
Failure.
ANR1396E EXTRACTDB: Process 1, database extract, has completed with errors.
ANR1383I EXTRACTDB: Found 0 database objects.
ANR1384I EXTRACTDB: Processed 0 database objects.
ANR1385I EXTRACTDB: Skipped 0 empty database objects.
ANR1386I EXTRACTDB: Failed to process 0 database objects.
ANR1387I EXTRACTDB: Processed 0 database records.
ANR1388I EXTRACTDB: Read 0 database pages.
ANR1389I EXTRACTDB: Wrote 0 bytes.
ANR1390I EXTRACTDB: Elapsed time was 0:00:01.
ANR1391I EXTRACTDB: Throughput was 0.00 megabytes per hour.
ANR1394E EXTRACTDB: Failed to start or failed to complete successfully.
s0017pdv root@/home/tsminst1
->

ANR0478W Session request refused. Server is running in standalone mode.
ANR1336I INSERTDB: Ready for connections from the source server. Remaining 
time: 0:56:00
ANR1337I A DBBACKUP trigger has been removed.
ANR1379I INSERTDB: Read 86,445,332 bytes and inserted 378,967 database entries 
in 0:00:00 (0.00 megabytes per hour).
___
Database Upgrade.
ANR1305I Disk volume /dev/rtsmcxdsklv1 varied online.
ANR0409I Session 1 ended for server $UPGRADETARGET$ (AIX).
ANR1382I EXTRACTDB: Process 1, database extract, has completed.
ANR1383I EXTRACTDB: Found 118 database objects.
ANR1384I EXTRACTDB: Processed 59 database objects.
ANR1385I EXTRACTDB: Skipped 59 empty database objects.
ANR1386I EXTRACTDB: Failed to process 0 database objects.
ANR1387I EXTRACTDB: Processed 788,564 database records.
ANR1388I EXTRACTDB: Read 35,110 database pages.
ANR1389I EXTRACTDB: Wrote 140,828,690 bytes.
ANR1390I EXTRACTDB: Elapsed time was 0:02:30.
ANR1391I EXTRACTDB: Throughput was 3216.00 megabytes per hour.
_


Good luck!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick 
Marouf
Sent: Tuesday, June 7, 2016 12:46 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] v7 upgrade woes

Sorry to hear that. I just went through this similar upgrade without a hitch, 
and I'm planning two more.

On Tue, Jun 7, 2016 at 1:31 PM, Rhodes, Richard L. < 
rrho...@firstenergycorp.com> wrote:

> This is half plea for help and half rant (grr).
>
> For the past two months we've been trying to test a TSM v6.3.5 to
> v7.1.4/v7.1.5 upgrade . . . . and have completely failed!
>
> TSM v6.3.5
> AIX 6100-09
> upgrade to TSM v7.1.4 and/or v7.1.5
>
> When we run the upgrade it runs to this status message:
> Installing: [(99%) com.tivoli.dsm.server.db2.DB2PostInstall ] Then 
> it sits, doing nothing.  AIX sees no db2 activity, no java activity, 

Re: Splitting the TSM Database into three

2007-07-09 Thread Ribeiro, Ricardo
The only way that I know to split then TSM db is to create a new TSM
server and export clients to it.
Good luck! :) 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Daad Ali
Sent: Monday, July 09, 2007 11:54 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Splitting the TSM Database into three

Hi All,
   
  We are discussing a way of splitting our TSM database. It is become
very big and slow.
  We want to split it into 2 or 3(one will be the manager of the other
two)
  I don't know how to split it so I am looking for a procedure/steps on
how to do that.
  Also, after splitting the database, can I assign different platforms
(AIX/Windows) to the two DBs.
   
   
   
  My db is about 200 GBs now and the server is version 5.2.6.0
   
  >q db f=d
  Available Space (MB): 180,000
Assigned Capacity (MB): 180,000
Maximum Extension (MB): 0
Maximum Reduction (MB): 14,824
 Page Size (bytes): 4,096
Total Usable Pages: 46,080,000
Used Pages: 34,660,427
  Pct Util: 75.2
 Max. Pct Util: 75.4
  Physical Volumes: 9
 Buffer Pool Pages: 272,144
 Total Buffer Requests: 293,217,483
Cache Hit Pct.: 99.05
   Cache Wait Pct.: 0.00
   Backup in Progress?: No
Type of Backup In Progress:
  Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 5,818.36
Percentage Changed: 4.30
Last Complete Backup Date/Time: 07/09/07   01:15:44

  ==
   
  tsm: BRDTSM01>q log f=d
   Available Space (MB): 12,000
 Assigned Capacity (MB): 10,020
 Maximum Extension (MB): 1,980
 Maximum Reduction (MB): 10,000
  Page Size (bytes): 4,096
 Total Usable Pages: 2,564,608
 Used Pages: 4,369
   Pct Util: 0.2
  Max. Pct Util: 68.3
   Physical Volumes: 6
 Log Pool Pages: 128
 Log Pool Pct. Util: 8.54
 Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 4,768,612.50
Consumption Reset Date/Time: 12/07/05   14:37:35

  Thanks as always.
   
  Daad

   
-
Be smarter than spam. See how smart SpamGuard is at giving junk email
the boot with the All-new Yahoo! Mail  


Simultaneous Write

2007-08-08 Thread Ribeiro, Ricardo
Hello,
I would like to know if someone has experience using the "Simultaneous
Write" feature of TSM 5.4?
We are thinking about creating a copy_pool on a remote site tape library
and enable this feature to see if we can create the copy tapes at a
remote site directly.
Has anybody done this?
Thanks!
 
Ricardo Ribeiro
Sr. Storage Administrator 
Charles Schwab & Co., Inc
Phone 602-977-4629
Cell 623-217-4139
Pager  877-478-7623
 


Oracle RMAN issue

2007-10-08 Thread Ribeiro, Ricardo
Hello,
I am running this version of TDP under Linux and getting this error
message, any ideas? Thanks!
 
TIVsm-API-5.3.2-0
TIVsm-stagent-5.3.3-0
TIVsm-BA-5.3.2-0
TIVsm-tsmscsi-5.3.3-0
TIVsm-API64-5.3.2-0
[TDP-Oracle.Utility-5.2.4-0
TDP-Oracle-5.2.4-0
 
TDP Error
10/08/07   08:59:07  ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE)
TDPO
  LinuxAMD64 ANU0599 TDP for Oracle: (28168): =>
  (s0147bdc-oracle) ANS1301E (RC1)Server
detected
  system error (SESSION: 1129697)
 
Activity Log entries for this
 
  (TDPO LinuxAMD64) (Tcp/Ip 10.104.58.29(53869)).
(SESSION:
  1129697)
10/08/07   08:59:05  ANRD smnode.c(16241): ThreadId <111> Unexpected
rc=19
  from imGetNextBackup (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111> issued message  from:
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x000100025aec
outDiagf
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001002d6b6c
DoBackQry
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001002e9114
SmNodeSession
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001001a620c
  HandleNodeSession  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001001a9ed4
DoNodeGeneral
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001001ab98c
  smExecuteSession  (SESSION: 1129697)
more...   ( to continue, 'C' to cancel)
 
10/08/07   08:59:05  ANRD ThreadId <111>  0x00010036f578
SessionThread
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001fdfc
StartThread
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x09411448
_pthread_body
  (SESSION: 1129697)
10/08/07   08:59:07  ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE)
TDPO
  LinuxAMD64 ANU0599 TDP for Oracle: (28168): =>
  (s0147bdc-oracle) ANS1301E (RC1)Server
detected
  system error (SESSION: 1129697)
10/08/07   08:59:07  ANR0403I Session 1129697 ended for node
S0147BDC-ORACLE
  (TDPO LinuxAMD64). (SESSION: 1129697)
10/08/07   09:10:44  (111) Context report (SESSION: 1129697)
10/08/07   09:11:05  (111) Thread AcceptorThread (59) is a parent thread
  related to: 111 (SESSION: 1129697)
10/08/07   09:11:36  (59) Failed attempt #1 to get TMV->mutex (SESSION:
  1129697)
10/08/07   09:14:20  (59) Failed attempt #2 to get TMV->mutex (SESSION:
  1129697)
10/08/07   09:17:12  (59) Generating TM Context Report:
(struct=tmTxnDesc)
  (slots=256)(SESSION: 1129697)
10/08/07   09:17:15  (59)  *** no transactions found *** (SESSION:
1129697)
more...   ( to continue, 'C' to cancel)
 
10/08/07   09:17:18  (59) Generating Database Transaction Table Context:
  (SESSION: 1129697)
10/08/07   09:17:19  (59)  *** no transactions found *** (SESSION:
1129697)
10/08/07   09:17:20  (59) Generating SM Context Report:  (SESSION:
1129697)
10/08/07   09:17:21  (59)  *** no sessions found *** (SESSION: 1129697)
10/08/07   09:17:23  (59) Generating AS Vol Context Report:  (SESSION:
1129697)
10/08/07   09:17:27  (59)  No mounted (or mount in progress) volumes.
(SESSION:
  1129697)
10/08/07   09:17:31  (59) Generating ssSession Context Report:
(SESSION:
  1129697)
10/08/07   09:17:35  (59)  No storage service sessions active. (SESSION:
  1129697)
10/08/07   09:17:38  (59) Generating ssOpenSeg Context Report:
(SESSION:
  1129697)
10/08/07   09:17:44  (59)  No storage service segments found. (SESSION:
  1129697)
10/08/07   09:17:47  (59) Failed attempt #1 to get BFV->mutex (SESSION:
  1129697)
10/08/07   09:19:14  (59) Generating BF Copy Control Context Report:
(SESSION:
  1129697)
10/08/07   09:19:19  (59)  No global copy control blocks. (SESSION:
1129697)
10/08/07   09:19:23   (SESSION: 1129697)
more...   ( to continue, 'C' to cancel)
 
10/08/07   09:19:35  (111) SessionThread : ANRD calling thread
(SESSION:
  1129697)
10/08/07   09:19:42  (111) Generating TM Context Report:
(struct=tmTxnDesc)
  (slots=256)(SESSION: 1129697)
10/08/07   09:19:49  (111) slot -> 145: (SESSION: 1129697)
10/08/07   09:19:52  (111) Tsn=0:1679522705, Resurrected=False,
InFlight=True,
  Distributed=False (SESSION: 1129697)
10/08/07   09:19:57  (111)  Participants=1, summaryVote=ReadOnly
(SESSION:
  1129697)
10/08/07   09:20:02  Pa

Re: Oracle RMAN issue

2007-10-09 Thread Ribeiro, Ricardo
Not using Lan-Free... 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Wira Chinwong
Sent: Monday, October 08, 2007 7:41 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Oracle RMAN issue

Did you have used the Lan-free feature? If so, try to check your
lan-free setting.

Wira

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Ribeiro, Ricardo
Sent: Tuesday, October 09, 2007 12:46 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Oracle RMAN issue

Hello,
I am running this version of TDP under Linux and getting this error
message, any ideas? Thanks!

TIVsm-API-5.3.2-0
TIVsm-stagent-5.3.3-0
TIVsm-BA-5.3.2-0
TIVsm-tsmscsi-5.3.3-0
TIVsm-API64-5.3.2-0
[TDP-Oracle.Utility-5.2.4-0
TDP-Oracle-5.2.4-0

TDP Error
10/08/07   08:59:07  ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE)
TDPO
  LinuxAMD64 ANU0599 TDP for Oracle: (28168): =>
  (s0147bdc-oracle) ANS1301E (RC1)Server
detected
  system error (SESSION: 1129697)

Activity Log entries for this

  (TDPO LinuxAMD64) (Tcp/Ip 10.104.58.29(53869)).
(SESSION:
  1129697)
10/08/07   08:59:05  ANRD smnode.c(16241): ThreadId <111> Unexpected
rc=19
  from imGetNextBackup (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111> issued message  from:
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x000100025aec
outDiagf
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001002d6b6c
DoBackQry
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001002e9114
SmNodeSession
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001001a620c
  HandleNodeSession  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001001a9ed4
DoNodeGeneral
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001001ab98c
  smExecuteSession  (SESSION: 1129697)
more...   ( to continue, 'C' to cancel)

10/08/07   08:59:05  ANRD ThreadId <111>  0x00010036f578
SessionThread
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x0001fdfc
StartThread
  (SESSION: 1129697)
10/08/07   08:59:05  ANRD ThreadId <111>  0x09411448
_pthread_body
  (SESSION: 1129697)
10/08/07   08:59:07  ANE4994S (Session: 1129697, Node: S0147BDC-ORACLE)
TDPO
  LinuxAMD64 ANU0599 TDP for Oracle: (28168): =>
  (s0147bdc-oracle) ANS1301E (RC1)Server
detected
  system error (SESSION: 1129697)
10/08/07   08:59:07  ANR0403I Session 1129697 ended for node
S0147BDC-ORACLE
  (TDPO LinuxAMD64). (SESSION: 1129697)
10/08/07   09:10:44  (111) Context report (SESSION: 1129697)
10/08/07   09:11:05  (111) Thread AcceptorThread (59) is a parent thread
  related to: 111 (SESSION: 1129697)
10/08/07   09:11:36  (59) Failed attempt #1 to get TMV->mutex (SESSION:
  1129697)
10/08/07   09:14:20  (59) Failed attempt #2 to get TMV->mutex (SESSION:
  1129697)
10/08/07   09:17:12  (59) Generating TM Context Report:
(struct=tmTxnDesc)
  (slots=256)(SESSION: 1129697)
10/08/07   09:17:15  (59)  *** no transactions found *** (SESSION:
1129697)
more...   ( to continue, 'C' to cancel)

10/08/07   09:17:18  (59) Generating Database Transaction Table Context:
  (SESSION: 1129697)
10/08/07   09:17:19  (59)  *** no transactions found *** (SESSION:
1129697)
10/08/07   09:17:20  (59) Generating SM Context Report:  (SESSION:
1129697)
10/08/07   09:17:21  (59)  *** no sessions found *** (SESSION: 1129697)
10/08/07   09:17:23  (59) Generating AS Vol Context Report:  (SESSION:
1129697)
10/08/07   09:17:27  (59)  No mounted (or mount in progress) volumes.
(SESSION:
  1129697)
10/08/07   09:17:31  (59) Generating ssSession Context Report:
(SESSION:
  1129697)
10/08/07   09:17:35  (59)  No storage service sessions active. (SESSION:
  1129697)
10/08/07   09:17:38  (59) Generating ssOpenSeg Context Report:
(SESSION:
  1129697)
10/08/07   09:17:44  (59)  No storage service segments found. (SESSION:
  1129697)
10/08/07   09:17:47  (59) Failed attempt #1 to get BFV->mutex (SESSION:
  1129697)
10/08/07   09:19:14  (59) Generating BF Copy Control Context Report:
(SESSION:
  1129697)
10/08/07   09:19:19  (59)  No global copy control blocks. (SESSION:
1129697)
10/08/

Re: Mixing LTO2 LTO4 in 3584 libr

2007-11-12 Thread Ribeiro, Ricardo
Yes... Do you have a specific question about the mix? 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Michael Green
Sent: Saturday, November 10, 2007 9:07 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Mixing LTO2 LTO4 in 3584 libr

Curious to find out if anyone has a mix of LTO2 (or maybe LTO3) and
LTO4 drives in the same virtual library (3584)?

--
Warm regards,
Michael Green


Re: Is their a way to find out - when was the last time a restore was performed for a TSM node.

2007-11-12 Thread Ribeiro, Ricardo
Just run this statement...
SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of CAYE PIERRE
Sent: Monday, November 12, 2007 8:23 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a 
restore was performed for a TSM node.

Sorry I miss a word... It is for backup only, not restore 

> -Message d'origine-
> De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la part 
> de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : 
> ADSM-L@VM.MARIST.EDU Objet : Re: [ADSM-L] Is their a way to find out - 
> when was the last time a restore was performed for a TSM node.
> 
> I am sure I must be missing something obvious, else I am going to 
> learn a new trick... how do you determine from QUERY FILESPACE F=D 
> when a node last performed a restore?
> 
> Regards,
> 
> Andy
> 
> Andy Raibeck
> IBM Software Group
> Tivoli Storage Manager Client Product Development Level 3 Team Lead 
> 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/IBMTivoli
> StorageManager.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 11/12/2007
> 07:49:17 AM:
> 
> > That did the trick. Thanks for the tip
> > 
> > Regards,
> > 
> > Kamran
> > 
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]
> On Behalf
> > Of CAYE PIERRE
> > Sent: Monday, November 12, 2007 4:07 AM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: Re: [ADSM-L] Is their a way to find out - when was
> the last
> > time a restore was performed for a TSM node.
> > 
> > You can also query filespaces : q fi f=d
> > 
> > > -Message d'origine-
> > > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la 
> > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À :
> > > ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] Is their a way to
> find out -
> > > when was the last time a restore was performed for a TSM node.
> > > 
> > > Hello,
> > > 
> > > 
> > > 
> > > Just curious to know if their a way to find out - when
> was the last
> > > time a restore was performed for a particular TSM node.
> > > 
> > > 
> > > 
> > > Regards,
> > > 
> > > 
> > > 
> > > Kamran H. Rao
> > > 
> 


Re: Is their a way to find out - when was the last time a restore was performed for a TSM node.

2007-11-12 Thread Ribeiro, Ricardo
Run this statement...
SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kamran Rao
Sent: Monday, November 12, 2007 8:25 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a 
restore was performed for a TSM node.

It is for a restore. 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of CAYE PIERRE
Sent: Monday, November 12, 2007 10:23 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a 
restore was performed for a TSM node.

Sorry I miss a word... It is for backup only, not restore 

> -Message d'origine-
> De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la part 
> de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : 
> ADSM-L@VM.MARIST.EDU Objet : Re: [ADSM-L] Is their a way to find out - 
> when was the last time a restore was performed for a TSM node.
> 
> I am sure I must be missing something obvious, else I am going to 
> learn a new trick... how do you determine from QUERY FILESPACE F=D 
> when a node last performed a restore?
> 
> Regards,
> 
> Andy
> 
> Andy Raibeck
> IBM Software Group
> Tivoli Storage Manager Client Product Development Level 3 Team Lead 
> 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/IBMTivoli
> StorageManager.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 11/12/2007
> 07:49:17 AM:
> 
> > That did the trick. Thanks for the tip
> > 
> > Regards,
> > 
> > Kamran
> > 
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]
> On Behalf
> > Of CAYE PIERRE
> > Sent: Monday, November 12, 2007 4:07 AM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: Re: [ADSM-L] Is their a way to find out - when was
> the last
> > time a restore was performed for a TSM node.
> > 
> > You can also query filespaces : q fi f=d
> > 
> > > -Message d'origine-
> > > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la 
> > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À :
> > > ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] Is their a way to
> find out -
> > > when was the last time a restore was performed for a TSM node.
> > > 
> > > Hello,
> > > 
> > > 
> > > 
> > > Just curious to know if their a way to find out - when
> was the last
> > > time a restore was performed for a particular TSM node.
> > > 
> > > 
> > > 
> > > Regards,
> > > 
> > > 
> > > 
> > > Kamran H. Rao
> > > 
> 


Select statement

2008-01-04 Thread Ribeiro, Ricardo
Hello,
Does anyone has a select statement I can use to find out how many tapes
I used on a daily basis?
Thanks!
 
 


Re: Select statement

2008-01-04 Thread Ribeiro, Ricardo
No, I need one that tells me how many I used and not how many I have...
Thanks! 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Choudarapu, Ramakrishna (GTI)
Sent: Friday, January 04, 2008 11:17 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement

We use this to find out the scratch counts:

select library_name, status, count(*) as VOL_COUNT from libvolumes group
by library_name,status

Is this the one, you are looking for?

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Ribeiro, Ricardo
Sent: Friday, January 04, 2008 1:12 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select statement


Hello,
Does anyone has a select statement I can use to find out how many tapes
I used on a daily basis?
Thanks!


This message w/attachments (message) may be privileged, confidential or
proprietary, and if you are not an intended recipient, please notify the
sender, do not use or share it and delete it. Unless specifically
indicated, this message is not an offer to sell or a solicitation of any
investment products or other financial product or service, an official
confirmation of any transaction, or an official statement of Merrill
Lynch. Subject to applicable law, Merrill Lynch may monitor, review and
retain e-communications (EC) traveling through its networks/systems. The
laws of the country of each sender/recipient may impact the handling of
EC, and EC may be archived, supervised and produced in countries other
than the country in which you are located. This message cannot be
guaranteed to be secure or error-free. This message is subject to terms
available at the following link:
http://www.ml.com/e-communications_terms/. By messaging with Merrill
Lynch you consent to the foregoing.



Re: Select statement

2008-01-04 Thread Ribeiro, Ricardo
Thank you! 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Friday, January 04, 2008 12:47 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement

On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote:

> Hello,
> Does anyone has a select statement I can use to find out how many 
> tapes I used on a daily basis?
> Thanks!

Most commonly, tapes automatically come from the scratches collection
and return to scratch when emptied (rather than being assigned to a
storage pool via DEFine Volume).  And, UPDate Volume is rarely performed
on volumes such that the administrative change timestamp remains that of
when the volume was taken from scratch to be used in a storage pool.
For basic reporting you can thus employ a variant of a Select statement
like:

select * from volumes where DAYS(CURRENT_DATE)-DAYS(CHG_TIME)<2 and
DATE(LAST_WRITE_DATE)=DATE(CURRENT_TIMESTAMP)

 From that point of departure you can play with timestamps for desired
intervals, and further select on STATUS value as desired.

Richard Sims  http://people.bu.edu/rbs/


Re: Select statement

2008-01-05 Thread Ribeiro, Ricardo
Good idea, thanks
Ricardo Ribeiro
Storage Administrator
623-217-4139

- Original Message -
From: ADSM: Dist Stor Manager 
To: ADSM-L@VM.MARIST.EDU 
Sent: Fri Jan 04 16:38:41 2008
Subject: Re: [ADSM-L] Select statement

You could also look at volhistory where use(?)='STGNEW' and date =desired range.



From: ADSM: Dist Stor Manager on behalf of Ribeiro, Ricardo
Sent: Fri 1/4/2008 2:51 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement



Thank you!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Friday, January 04, 2008 12:47 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement

On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote:

> Hello,
> Does anyone has a select statement I can use to find out how many
> tapes I used on a daily basis?
> Thanks!

Most commonly, tapes automatically come from the scratches collection
and return to scratch when emptied (rather than being assigned to a
storage pool via DEFine Volume).  And, UPDate Volume is rarely performed
on volumes such that the administrative change timestamp remains that of
when the volume was taken from scratch to be used in a storage pool.
For basic reporting you can thus employ a variant of a Select statement
like:

select * from volumes where DAYS(CURRENT_DATE)-DAYS(CHG_TIME)<2 and
DATE(LAST_WRITE_DATE)=DATE(CURRENT_TIMESTAMP)

 From that point of departure you can play with timestamps for desired
intervals, and further select on STATUS value as desired.

Richard Sims  http://people.bu.edu/rbs/


Re: TDP Compression

2010-08-02 Thread Ribeiro, Ricardo
Also, you can run ./tdpoconf showenv, this output will tell you if
compression is enabled.  


Ricardo Ribeiro
Charles Schwab & Co,. Inc.
PHXDC-02-2178
PO Box 61863
Phoenix, AZ 85082-1863

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Hart, Charles A
Sent: Monday, August 02, 2010 1:04 PM
To: ADSM-L@vm.marist.edu
Subject: Re: [ADSM-L] TDP Compression

1) Q node  f=d   see if Compression set to Yes ort Client if
client then check dsm.sys options

2) Your act log TDP summary job will. Let uyou know it says compressed
at the end

08/02/10   14:03:08  ANE4991I (Session: 8215330, Node:
DBSS-ORACLUSTER)
  TDP Oracle SUN ANU0599  TDP for Oracle:
(2645): =>() 
  ANU2526I Backup details for backup piece

  /ora_db//c-611266183-20100802-1c (database
"ancprr").
  Total bytes sent: 53739520. Total processing
time:   
  00:00:01. Throughput rate: 52480.00Kb/Sec.
Compressed: No


 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Huebner,Andy,FORT WORTH,IT
Sent: Monday, August 02, 2010 2:50 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP Compression

Is there an easy way to see which TDP backups (SQL, Oracle) are using
client compression?
These jobs are all client initiated jobs through a batch process.
I need to gather this information from the TSM side.
I have searched the activity log and cannot find anything for TDP
compression.

Andy Huebner



This e-mail (including any attachments) is confidential and may be
legally privileged. If you are not an intended recipient or an
authorized representative of an intended recipient, you are prohibited
from using, copying or distributing the information in this e-mail or
its attachments. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and delete all copies of
this message and any attachments.

Thank you.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.


Anybody using SANergy out there

2008-02-27 Thread Ribeiro, Ricardo
I would like to know if you guys have ran into any problems, issues,
etc
Thanks!
 
Ricardo Ribeiro
TSM Architect (Distributed Storage Group)
Charles Schwab & Co., Inc
BlackBerry  623-217-4139
Phone 602-977-4629
 
 


Re: Restore performance puzzler

2008-06-25 Thread Ribeiro, Ricardo
Shawn,
Based on this information it appears that the VTL is only attached to
the TSM server correct? So, the data to the client is not going to be as
fast as restoring to the TSM server. Things to consider are...
What is the LAN speed and duplex settings for the client?
How is the LAN traffic when you are trying to restore? 
Is compression enabled on the TSM client side?
How many channels/threads/mount points are you allowing the client to
use?
What type of data are you restoring, compress, database data, etc?
Can you ping the TSM server from the client?
Can you ping the Client from the TSM server?

Anyway, I hope this helps!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Shawn Drew
Sent: Wednesday, June 25, 2008 2:47 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Restore performance puzzler

5.4.1 AIX Server
5.3.4 AIX 5.1 Client

Performing a 12 gB restore.  (6x2gB files) The restore is performing at
a rate of about  250-500 KB/s with bursts up to a whopping 750KB/s
(Looking at the VTL drive monitor)

If we perform the restore locally to the TSM server's file system, it is
fast. (20-30 MB/sex) We can FTP the data to the client fast as well,
10-15MB/sec

A restore of the same files performed at the client crawls.   We are
upgrading to 5.3.6, which looks to be the newest AIX 5.1 client we can
use.  Any ideas?


Regards,
Shawn


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


Re: Tricky conversion problem

2008-07-08 Thread Ribeiro, Ricardo
One idea that you can try is to use the "GENERATE BACKUPSET" command and
store this media for as long as you want.
That way you can tell him that you have a saved copy of his data then
move him to the new server and it should run a full backup of all his
data anyway onto the new media. My two cents! :) 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Martha McConaghy
Sent: Tuesday, July 08, 2008 11:09 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Tricky conversion problem

We are moving to a new TSM server on a Pseries box with an IBM 3592 tape
system from a very old mainframe based TSM server.  We had not planned
on moving any of the old data over to the new server as there was no
requirement for it.  However, we run into a single user who wants to
have all of his previous backups moved to the new server, even though
most are no longer usable (we are talking about old OS2 systems,
etcevery PC he has ever used in the last 20 years).  Since this user
is our 2nd line manager, we have no choice to try and figure something
out.

The main problem is that the two servers are not compatible.  The old
server can only talk to 3590 tape drives, whose tapes are not usable in
the new 3592s.  So, I can't just export the data to tape and then import
into the new server. (Ah if only life were that easy!).

On a hunch, I've tried creating a server connection between old and new
TSM server.  Then, I exported a filespace to a virtual volume
(devclass=server) on the new server.  It sits on a 3592 tape right now.
However, the new server will not allow me to import this tape, as it
belongs to a pool and it thinks it is in use.

Is there any way to make this work?  I'm at a loss for ideas at this
point.
I could create a virtual volume on disk and move the old filespaces to
it, but then I'll have to keep the old server running "forever" or at
least until it will run no longer.

Anyone have any ideas?

Martha McConaghy
Strategic Planner/Project Manager
Marist College IT


Re: Deletion of onsite tape

2008-07-18 Thread Ribeiro, Ricardo
Rich, 
My guess is that TSM expired some of the data that was on that volume,
so when it restored it only restored non-expired data I guess if you
have the database backup volume from when you would like to restore, you
can try and do a point in time restore, that should work on your mini DR
server. 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Mochnaczewski
Sent: Friday, July 18, 2008 7:19 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Deletion of onsite tape

Hi *,

I have a scenario. We had an onsite tape that got mangeled by a drive.
The tape showed 75% usage initially. When we did the restore from
offsite tapes, TSM reported that it completed successfully but there was
still 15% left on the tape. The user went ahead and did a del vol
discarddata=yes ( yes , I already hear the groans ) and looking through
the  logs see the following message :

14.07.2008 10:28:05  ANR1256W Volume C60255 contains files that could
not be   
  restored. (SESSION: 130878)

What we would like to do is setup TSM on a test server and perform a
mini-DR. That is, restore the database prior to the del and do a query
content on the volume and check against the current database to see what
data is missing.

My questions :

1) Why would TSM report the restore being successful when there was
still data on it ? Could it be that running an audit vol would have
fixed the volume against database and there was no data lost, just a
volume messing up the TSM database pointers ?

2) We have the volumes that were used for the restore. Is there any way
of restoring the data and then importing it back into the current
environment ?


TSM Server :
TSM 5.3.6.3 ( being upgrading to TSM 5.4 shortly )
AIX5.3

Rich

  
Standard Life : 175 ans au coeur de nos vies Standard Life: Part of our
lives for 175 years
 


Re: Server looking for volume in wrong library

2008-10-17 Thread Ribeiro, Ricardo
I wonder if you could have a label problem on that tape, you may want to
re-label it.
Also, when you run the command "q libvol  TJULIB01_1120" what is the
status of that one tape?


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Thomas Denier
Sent: Friday, October 17, 2008 12:59 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Server looking for volume in wrong library

We have a 5.4.2.0 server running under mainframe Linux. We are seeing an
annoying error approximately once per month.

We have three libraries defined in the TSM database. All three are
really a single 3494 physical library. Library TJULIB01_3592 contains
3592 media formatted for an uncompressed capacity of 300 GB. It is used
for primary storage pools. Library TJULIB01_1120 contains 3592 media
formatted for an uncompressed capacity of 500 GB. It is used for copy
storage pools. Library TJULIB01 contains 3590 media for copy storage
pools. We have stopped writing to this type of media and will delete
this library once we have a complete set of copies on 3592 media.

We run reclamation for our new offsite storage pool with five concurrent
processes. Approximately once per month TSM tries to find an input tape
in library TJULIB01_1120. When this happens TSM displays a long series
of messages requesting that the input tape involved be inserted into
library TJULIB01_1120 and then reports a mount failure.
When we investigate these failures, 'q libvol' commands always show that
the volume is in TJULIB01_3592, as it should be, and 'mtlib'
commands issued from a shell prompt show that the volume is in the
physical library and has the right category. Searches of the activity
log have never turned up any sign of 'checkin' and 'checkout' commands
being used to shift the volume between libraries between the failure and
the investigation.

Searches for some of the message numbers that show up when the problem
occurs turned up APAR IC48313, which does cause TSM to look for volumes
in the wrong libraries. However, that APAR is only supposed to apply to
TSM 5.3, and the APAR description indicates that the problem occurs when
two reclamation processes try to access the same volume. The activity
log for the last occurance of the problem shows no sign of concurrent
requests. The volume was used and dismounted almost 14 hours before the
problem occured, and the volume was not mentioned in the activity log
again until TSM started asking that it be inserted into the wrong
library.


Re: Server looking for volume in wrong library

2008-10-17 Thread Ribeiro, Ricardo
The only other suggestion I have is to query the volume history and see
what library used it last. "q volhist"
Good luck. 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Thomas Denier
Sent: Friday, October 17, 2008 1:34 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Server looking for volume in wrong library

-Ricardo.Ribeiro wrote: -

>I wonder if you could have a label problem on that tape, you may want 
>to re-label it.

The tape involved in the latest occurance of the problem was loaded,
read, and unloaded without incident about 14 hours before the problem
occurred, and again about 10 hours after the problem occurred. In any
case, TSM finds out which library a tape is in by consulting the TSM
database, not by reading the tape label.

>Also, when you run the command "q libvol  TJULIB01_1120" what is the 
>status of that one tape?

The tape does not appear in the output from such a query. This is what I
would expect; the tape was never supposed to be in the TJULIB01_1120
library, and I have found no evidence that it was ever put into that
library erroneously. A similary query for the TJULIB01_3592 library
shows a status of 'Private' and last use of 'Data' for the volume.
This is exactly the result I would expect.


Re: IBM TS3310 Checkin/Checkout Tape Operational Question

2008-11-05 Thread Ribeiro, Ricardo
Use the web interface of the library and assign the tapes to the logical
library, that should work. 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Wanda Prather
Sent: Wednesday, November 05, 2008 9:37 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] IBM TS3310 Checkin/Checkout Tape Operational
Question

NO that's not normal.  Something is hosed up in the config.
The TS3310 should work just like a 3584 responding to a CHECKIN.
(Your SEARCH=BULK should NOT have worked after you manually moved the
tapes to storage slots.)

What you didn't say is which I/O slots you are using.
The 3310 can be configured with 6 I/O slots in the base unit, or with
the 6 slots plus the (12? don't remember) slots in the expansion unit.
Which are you using?  I've seen some flaky problems trying to use the
lower slots if things weren't configured properly.  Never seen any
issues using the top 6.

-If you have changed the config of the logical library, make sure you
stop and restart TSM.  It has to pick up the number of slots & I/O slots
when it starts.

-Also:  this is really weird, but make sure your HBA drivers are
current.  I actually saw a 3310 that has a problem with the I/O slots
until the HBA drivers were updated to a level that included the correct
tape I/O support..




On Wed, Nov 5, 2008 at 10:43 AM, Lamb, Charles P. <[EMAIL PROTECTED]>
wrote:

> Hi.
>
> We have just installed a brand new TS3310 ==> IBM 3576-L5B ATL.
Atape
> version is 11.2.7.0 and ATL version is 500GS002 which appears to be 
> current.  TSM version is 5.4.3.2 and IBM 7026-H70 AIX V5.3.8.3.  We 
> have an IBM 3584-L32/D32 ATL which works differently concerning the 
> checkin/checkout tapes via I/O slots.  Does the TS3310 I/O slots work 
> differently as oppose to the IBM 3584-L32/D32 ATL I/O slots.  See 
> below for the TS3310 operational tasks.
>
> We have run tapeutil -f /dev/smc0 inventory which shows robot, I/O 
> slots, drives and library slots.
>
> Step one of this morning.
> 1)  Placed tapes into I/O slots
> 2)  IBM 3576 screen asked where the tapes should go system or
cgoatl03
> - hit cgoatl03 button and OK button
> 3)  Ran label libv 3576lib checkin=scr overwrite=yes search=bulk
> labelsource=barcode
> 4)  We found in activity log anr8386w messages -- slot xx of
library
> 3576lib is inaccessible, slot xx are the I/O slots
>
> Step two this morning.
> 1)  Placed tapes into I/O slots
> 2)  IBM 3576 screen asked where the tapes should go system or
cgoatl03
> - hit cgoatl03 button and OK button
> 3)  We went into IBM 3576 web GUI and manually moved the tapes
from I/O
> slots to IBM 3576 library open slots
> 4)  Ran label libv 3576lib checkin=scr overwrite=yes search=bulk
> labelsource=barcode
> 5)  Ran q libv and showed the tapes as scratch tapes
>
> Why do we need step #3 above??  Is this normal??
>


Re: NDMP restore

2008-11-10 Thread Ribeiro, Ricardo
We use the regular TSM client GUI, it works pretty good so far...
The other option is to use the command line, but you will need to know
the path of the file(S) you are restoring.
I have not try the ISC GUI yet. 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Huebner,Andy,FORT WORTH,IT
Sent: Monday, November 10, 2008 2:50 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] NDMP restore

We are new to the NDMP side of TSM.  One of the things we found out was
that ISC cannot load a TOC with 545K objects.  This is an IBM confirmed
limitation of the ISC and is based on the size of the TOC.
For those with NDMP, how do you handle file restores if the user is
unsure of a file's name or date from which to restores?  Do you dump the
TOC, or is there a command I have missed?
It all works fine from the command line if we know the file name and
date.

TSM - AIX 5.4.2.0
NDMP - EMC Celerra
ISC - 6.0.1
Frustration - 10.0


Andy Huebner



This e-mail (including any attachments) is confidential and may be
legally privileged. If you are not an intended recipient or an
authorized representative of an intended recipient, you are prohibited
from using, copying or distributing the information in this e-mail or
its attachments. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and delete all copies of
this message and any attachments.
Thank you.


Re: TSM cmd after library has been defined again..

2012-11-27 Thread Ribeiro, Ricardo
Here is an easier one...

Syntax for a SCSI library

>>-LABEl LIBVolume--library_name>
more...   ( to continue, 'C' to cancel)


>+-volume_name+
 '-SEARCH--=--+-Yes--| A |--+--LABELSource--=--+-Barcode+-'
  '-Bulk--| A |-'  +-Prompt-+
   '-Vollist--| B |-'

.-OVERWRITE--=--No--.
>--+-+--+---+--->
   '-CHECKIN--=--+-SCRatch-+-'  '-OVERWRITE--=--+-No--+-'
 '-PRIvate-''-Yes-'




-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of Remco 
Post
Sent: Tuesday, November 27, 2012 11:55 AM
To: ADSM-L@vm.marist.edu
Subject: Re: [ADSM-L] TSM cmd after library has been defined again..

checkin libv  search=y stat=scr checkl=[bar|yes] checkin libv  
search=y stat=priv checkl=[bar|yes]

in that order


On 27 nov. 2012, at 19:37, "Swartz, Jerome"  
wrote:

> Hi All,
> 
> Haven't touched TSM in a while. Needed to delete the paths, drives and 
> library. 
> 
> I just defined those again and there is a command that I need to run so that 
> TSM can see the tapes in the library.
> 
> Just can't get to it! Q libv doesn't return any results..
> 
> Thanks in  advance!
> 
> Jerome
> 
> 
> 
> **
> COMPUTACENTER PLC is registered in England and Wales with the 
> registered number 03110569.  Its registered office is at Hatfield 
> Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW 
> COMPUTACENTER (UK) Limited is registered in England and Wales with the 
> registered number 01584718.  Its registered office is at Hatfield 
> Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW 
> COMPUTACENTER (Mid-Market) Limited is registered in England and Wales 
> with the registered number 3434654. Its registered office is at 
> Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 
> 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales 
> with the registered number 3798091. Its registered office is at 
> Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 
> 9TW
> 
> The contents of this email are intended for the named addressee only.
> It contains information which may be confidential and which may also be 
> privileged.
> Unless you are the named addressee (or authorised to receive mail for the 
> addressee) you may not copy or use it, or disclose it to anyone else.
> If you receive it in error please notify us immediately and then destroy it.
> Computacenter information is available from: 
> http://www.computacenter.com
> **

--
Met vriendelijke groeten/Kind Regards,

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