Re: Recovery of mirrored db and log volumes

2005-06-21 Thread Farren Minns
Hi all Regarding the reply below (thanks to Jop), I have managed to create new db volumes and get them all synched up, so that's good. However, the log volume that got lost was Copy 1 (see below), so what do I do now? Do I try and make a copy of the remaining good copy (Copy 2), or do I use

Re: Recovery of mirrored db and log volumes

2005-06-21 Thread Jop de Graaf
Hi Farren, as copy 1 is still off-line you can handle the LOG the same as the DB. It works fine, no problem. After creating the space on OS and doing the logcopy it fills the new volume from the one that's still online. Good luck. Jop de Graaf Certified Tivoli Consultant/Instructor

Failed WEOF

2005-06-21 Thread Matthew Large
Chaps, During the backup stgpool of a 1.7TB file, I got this message in the actlog: ANR8341I End-of-volume reached for LTO volume ACO215L2. ANR8311E An I/O error occurred while accessing drive DRV01 (mt1.0.0.2) for WEOF operation, errno = 1117. ANRD pvrntp.c(2648): ThreadId63 Error writing

Re: Failed WEOF

2005-06-21 Thread Warren, Matthew (Retail)
The QuickFacts mentions the following; - pvrntp.c(1838): Error writing E OT to Ntp Volume xx Encountered when someone opens the cap door and Ejects a cartridge that is in the Process of being written. Has someone been opening the library and ejecting tapes? --:-- Matthew Warren. [EMAIL

NetWare backup question

2005-06-21 Thread David Browne
I Is there a command to automatically exit upon completion of the command line backup, and not leave the window sitting at Press any key to continue? The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you

MountPoints within MountPoints

2005-06-21 Thread Matthew Large
Hi, We perform weekly image backups and daily incrementals of a large fileserver, and there are plans to expand the disk available to this server. We've been informed that when TSM finds a new mountpoint within a drive, TSM will perform a complete (full) incremental of the file system before it

Re: Failed WEOF

2005-06-21 Thread Matthew Large
Yeah, I found that and quickly dismissed it - no chance. TSMWIKI is my first port of call :) Warren, Matthew (Retail) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 21/06/2005 11:58 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To

Re: Failed WEOF

2005-06-21 Thread Richard Sims
LTO drive microcode may be a factor in this. (See IBM site Readme http://www-1.ibm.com/support/docview.wss?uid=ssg1S1002360 for a summary of microcode levels.) You didn't mention your environment, but the 1117 errno would be a Windows System Error number (rather than a Unix errno). There may be

Re: NetWare backup question

2005-06-21 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Browne Is there a command to automatically exit upon completion of the command line backup, and not leave the window sitting at Press any key to continue? Consult the NetWare client manual. Look up the parameter

Re: NetWare backup question

2005-06-21 Thread Troy Frank
As far as I know, there are two ways to do a command-line backup in netware... 1. Type dsmc at the server command line. At the dsmc prompt that comes up, type i , or something like backup vol1:\dir1\* 2. At the novell command prompt type dsmc backup vol1:\dir1\* The 1st way will keep you in

Data protection

2005-06-21 Thread Meadows, Andrew
With the latest problems that have come out with backup tapes being stolen my CIO is concerned with TSM's security. Does anyone know where I could print off something to show him on the security of TSM, meaning if you don't have the database you can't get to the data, etc. Also is anyone using

Using DISKPART to mount drive in directories on Wintel

2005-06-21 Thread Matthew Large
OK, Second attempt at this question. Our fileserver is accessed by one drive letter, F. There is a wish to move one of the directories to another disk, but keep it mounted in the same place in the directory structure. F:\dirA\dirAA \dirAB - this directory is to be moved to another disk

Re: Data protection

2005-06-21 Thread Lepre, James
Show them the planfile. It tells you what tapes you are going to need to restore the data, and it includes the DB tape -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Meadows, Andrew Sent: Tuesday, June 21, 2005 10:07 AM To: ADSM-L@VM.MARIST.EDU

Backing up mail: mbox vs. maildir

2005-06-21 Thread Peter Duempert
Hi TSM'ers, currently we're backing up mail which is stored in mbox-format, i.e. any tiny change to a folder results in a complete backup of the resp. folder. This is currently tolerable with my site, but we consider using the maildir format, where every message is stored in an individual file.

Re: Using DISKPART to mount drive in directories on Wintel

2005-06-21 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Large Our fileserver is accessed by one drive letter, F. There is a wish to move one of the directories to another disk, but keep it mounted in the same place in the directory structure. F:\dirA\dirAA \dirAB

Re: Using DISKPART to mount drive in directories on Wintel

2005-06-21 Thread Richard Sims
On Jun 21, 2005, at 10:19 AM, Stapleton, Mark wrote: ...The nice thing is that the old locations of all these affected files will eventually expire away, because the old file locations don't exist anymore. Just to supplement Mark's observations... Keep in mind that relocating files may

Re: Using DISKPART to mount drive in directories on Wintel

2005-06-21 Thread Matthew Large
I think I may have been misunderstood.. not the first time Thanks though Mark. The whole point of this operation is to keep the files in 'what appears to be' the same place. F:\dirA\dirAA \dirAB - this directory is to be moved to another disk The directory \dirAB\ logically will not

Re: BackupStgpool preparation

2005-06-21 Thread Allen S. Rout
== On Mon, 20 Jun 2005 08:20:30 -0500, Stapleton, Mark [EMAIL PROTECTED] said: backup stg pool1 pool2 preview=yes So, I was wondering: How do you folks deal with the desire to automatically answer the question Are my copy pools up to date ? In order to automate the above-quoted query,

Re: BackupStgpool preparation

2005-06-21 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout How do you folks deal with the desire to automatically answer the question Are my copy pools up to date In order to automate the above-quoted query, it is necessary that the logged-in ID have storage authority

Re: TSM Operational reporting

2005-06-21 Thread William Colwell
Hi, I am using TSMOR and like it a lot, but as far as I can see It is only for reporting on tsm servers. So I don't know what you Want OR to do with your clients. Bill Colwell -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark

Re: Rename filespace to associate to a different node?

2005-06-21 Thread Prather, Wanda
There is no command to do that. There is a way to do it, if you are willing/able to export and re-import the filespace: Assume you want the filespace from node SOURCE to be reassociated with node TARGET. 1) Export the filespace. 2) Rename node SOURCE TEMP. 3) Rename node TARGET SOURCE 4) Import

Re: MountPoints within MountPoints

2005-06-21 Thread Andrew Raibeck
TSM will back up the mount point (junction) and its attributes, but will not traverse into it. It will, however, treat the mounted volume as a separate file space and back it up. For example, suppose E: is mounted under C:\somedir\mp. When TSM backs up C:, it will back up C:\somedir, any files

Re: BackupStgpool preparation

2005-06-21 Thread Prather, Wanda
If you want a query, you can just use a query (my resident DBA gets credit for constructing this one): select sum(case when q.pooltype = 'PRIMARY' then o.num_files else -o.num_files end) as net_files from occupancy o, stgpools q where o.stgpool_name = q.stgpool_name and q.pooltype in(

Re: TSM Operational reporting

2005-06-21 Thread Prather, Wanda
Same here; use it a lot and its terrific. But all it does is run queries against the server. Are you sure you are using the current version? I thought driver7 was the old beta version. A LOT of things have been fixed/cleaned up in versions after the Beta. If you have a windows TSM server at

Need backup dates of files on a specific tape...

2005-06-21 Thread George, Jason
Hello All- My team lead posted this question to ADSM.org with no results- so I'll warn you now, it's a stumper! I have a situation where a tape has been destroyed and cannot be restored from offsite tapes. I need to know the backup date of the file on the tape. Does anyone have a select

Re: TSM Operational reporting

2005-06-21 Thread Lawrence Clark
Did they drop the net detect and web detect to discover pc and servers on the network to allow adding client so they can be configured from one location? What is the ftp site? Yep. my TSM server is AIX but I should haver the NT CD around here someplace. [EMAIL PROTECTED] 06/21/2005 1:59:39 PM

Re: Data protection

2005-06-21 Thread Andrew Raibeck
The requirement for a TSM database to restore the files is not in and of itself a security feature. There was some discussion on this subject a while back. Check the archives for criterion: Reading client data from a storage pool tape Here is a specific link that includes a good portion of

Re: TSM Operational reporting

2005-06-21 Thread Prather, Wanda
Sorry, I'm not familiar with net detect and pc detect. It won't be on the NT CD unless you have the 5.2.2 (not 5.2.0) CD, but it's a very quick download (10.2MB). Go here (this is the 5.2.4 version:) ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena

Re: TSM Operational reporting

2005-06-21 Thread Lawrence Clark
Looked on TSM for Windows V 5.2 Part # LCD7-0425-02 Saw no reference to a TSMCON executable. [EMAIL PROTECTED] 06/21/2005 1:59:39 PM Same here; use it a lot and its terrific. But all it does is run queries against the server. Are you sure you are using the current version? I

Re: Need backup dates of files on a specific tape...

2005-06-21 Thread Andrew Raibeck
There's no such query that I can think of, since the CONTENTS table does not include the object ID of the files in that table, so you can't tie anything directly to the BACKUPS table. However, another possible approach: Assuming you know the file name you are looking for (and it sounds like you

Re: Need backup dates of files on a specific tape...

2005-06-21 Thread Richard Sims
On Jun 21, 2005, at 1:59 PM, George, Jason wrote: Hello All- My team lead posted this question to ADSM.org with no results- so I'll warn you now, it's a stumper! I have a situation where a tape has been destroyed and cannot be restored from offsite tapes. I need to know the backup date of the

Re: Data protection

2005-06-21 Thread Pugliese, Edward
I did some tests backing up/restoring a 4GB file with an AIX TSM client and TSM server and found the following: Backup to diskpool unencrypted: 400 seconds Backup to diskpool encrypted: 600 seconds Restore unencrypted file from tape: 400 seconds Restore encrypted file from tape: 600 seconds.

Re: Need backup dates of files on a specific tape...

2005-06-21 Thread Ben Bullock
Ahh, Ok adding to that query... With a 'q content tape f=d you get the file name and the size. This is tedious, but assuming that you are only looking for the date of a certain file or just a few files, you should be able to go to the client that backed it up and do a q backup

Re: Need backup dates of files on a specific tape...

2005-06-21 Thread Richard Sims
On Jun 21, 2005, at 2:41 PM, Richard Sims wrote: SELECT * FROM CONTENTS WHERE NODE_NAME='' AND FILESPACE_NAME='' AND HL_NAME='' AND LL_NAME='' Duh... that should have said: SELECT * FROM BACKUPS WHERE NODE_NAME='' AND FILESPACE_NAME='' AND HL_NAME='' AND

Re: Need backup dates of files on a specific tape...

2005-06-21 Thread Andrew Raibeck
I think you meant to select from the BACKUPS table... the CONTENTS table doesn't have BACKUP_DATE, HL_NAME, or LL_NAME columns. But even then, if there are multiple versions, you can't easily distinguish which one is on a given volume. Regards, Andy Andy Raibeck IBM Software Group Tivoli

MS SQL database with images

2005-06-21 Thread Thomas Denier
We are trying to estimate the resource requirements for TSM backups of a new clinical system. The system will have a MicroSoft SQL database. Most of the space used by the database will be occupied by scanned images of paper charts and digital images from diagnostic equipment. According to the

Re: MS SQL database with images

2005-06-21 Thread Ung Yi
Hello, TDP will just backup the pointers. TSM will need to backup the images. Yi -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: Tuesday, June 21, 2005 3:23 PM To: ADSM-L@VM.MARIST.EDU Subject: MS SQL database with images We

Re: MS SQL database with images

2005-06-21 Thread Lawrence Clark
Well, it backs up databases. So it will backup the pointers and not the flat files the contents of the DB points to. But those flat files will be backed up by the normal incremental, and if they remain static, should not be a lot of overhead. [EMAIL PROTECTED] 06/21/2005

ANR1134W

2005-06-21 Thread James Choate
Can someone give me a little insight on resolving this warning? ANR1134W. How do I make more mount points available? I updated a the hi/lo threshold on a storage pool to 0/0 to force a migration. I received the following warning message. ANR1134W. Here is the resolution from the

Re: ANR1134W

2005-06-21 Thread Barnes, Kenny
Look at your device class settings to make sure the number of mount points equal the total number of drives available. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of James Choate Sent: Tuesday, June 21, 2005 3:37 PM To: ADSM-L@VM.MARIST.EDU

Re: ANR1134W

2005-06-21 Thread Lawrence Clark
3494BTAPESequential 83590 DRIVE 40,960.0 DRIVES Mount Limit: DRIVES q devc f=d upd devc devclassname mountlimit=drives you can set it to drives... [EMAIL PROTECTED] 06/21/2005 3:36:50 PM Can someone give me a little insight on resolving this warning?

Re: Need backup dates of files on a specific tape...

2005-06-21 Thread Prather, Wanda
I would go at it in the opposite direction. First Richard's query: SELECT * FROM BACKUPS WHERE NODE_NAME='' AND FILESPACE_NAME='' AND HL_NAME='' AND LL_NAME='' That will give you a list of the backup versions of the file, including the DATE and the OBJECT_ID. You can use the

Backup Information

2005-06-21 Thread Debbie Bassler
I was looking at the database tables and trying to find a way to get the node names, backup start and end times and the amount of data backed up, into an excel spread sheet. We backup over 100 servers a night and the operations people manually go throught the activity log to find, and record,

Re: Backup Information

2005-06-21 Thread Curtis Stewart
Try this on for size. select entity as Node_Name, Schedule_name, substr(cast(start_time as char(26)),1,19) as Start_Time, substr(cast(end_time as char(26)),1,19) as End_Time, (end_time - start_time) minutes as Duration, examined as Examined, affected as Backed_Up, failed as Failed,

Re: Backup Information

2005-06-21 Thread David W Litten
Debbie, we use the TSM ODBC client and Microsoft Access to get this information, though I think MS Excel can also user SQL queries against the TSMODBC client. You can download the ODBC client from: