Antwort: Re: missing data in summary table

2004-11-30 Thread Karin Dambacher
Hi, that there were problems in the past with the summary table, I know. But I have not seen one in the last time, so I wonder about this. TSM Server is 5.2.1.3 AIX 5 TSM Client is 5.2.3.4 Windows 2003 We saw the problem in the daily e-mail of tsmm, the server is missing sometimes. And then we

Re: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2

2004-11-30 Thread goc
- Original Message - From: Peter Hadikin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 29, 2004 11:26 PM Subject: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2 Hello TSMers We are planning to finally update the AIX version on our RS6000 that is running our TSM server.

TSM 5.2, Solaris 8 w/ STK L700 9940B drive.

2004-11-30 Thread Ruengrit Changkwanyuen
Hi Guys, Currently I'm having problem configuring TSM mt driver on Solaris 8 with STK 9940B tape drive. I tried many different mt.conf configuration but I still got the following error: # add_drv -v /usr/kernel/drv/mt exit status = 0 devfsadm: driver failed to attach: mt exit status = 11

TSM Exteneded Edition ver5.2 and TSM ver 5.1.5

2004-11-30 Thread nghiatd
Dear all, I 'm using TSM ver 5.1.5 and I want to upgrade to TSM Extended Edition ver 5.2. I know TSM Ext Edit support creating recovery plan file and disaster recovery automatically (that TSM ver 5.1.5 doesn't have), larger library. I also visited web site IBM but I haven't found additional

auto reply for checkin and checkout

2004-11-30 Thread Mark Strasheim
Aloha, is there is possibility to avoid the need of reply(ing) to checkout and checkin processes. with regrads Mark Strasheim -- definitiv! business applications GmbH Co. KG Fresnostrasse 14 - 18 · DE-48159

Re: Scheduling time problem

2004-11-30 Thread Bos, Karel
Hi, The duration of the schedule is something to check as well as the client scheduling mode (polling/prompted). Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of chithirai selvan Sent: maandag 29 november 2004 21:37 To: [EMAIL

Re: auto reply for checkin and checkout

2004-11-30 Thread Henrik Wahlstedt
Hi, Try: checkout libv library tape remove=bulk checkl=n checkin libv library search=bulk checkl=barcode status=pri. Med vänlig hälsning

Re: Select Statement Help for Volume Breakdown

2004-11-30 Thread Matt Chan
Hello all, Related to this in a way then, can anyone help me with how to determine which of all my defined tapes are scratch, for audit purposes ? Matt Chan Stapleton, Mark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 23/11/2004 07:23 AM Please respond to ADSM: Dist

SQL Help

2004-11-30 Thread David E Ehresman
I'm trying to get a count of tapes pending by date. I'm using: select date(pending_date),count(*) from volumes where status='PENDING' - group by date(pending_date) but I get the error message: ANR2904E Unexpected SQL key word token - 'DATE'. pointing to the date in the group by

Re: Select Statement Help for Volume Breakdown

2004-11-30 Thread Richard Sims
Matt - Do select * from volumes where scratch='Yes' That is, a volume which is in use in a storage pool, which came from the Scratch tape pool, will have its SCRATCH column set to Yes. A storage pool volume which is in the storage pool because of a Define Volume will have a SCRATCH column value

Re: SQL Help

2004-11-30 Thread James Choate
Try this. select date(pending_date), count(*) from volumes where - status='PENDING' - group by pending_date From: ADSM: Dist Stor Manager on behalf of David E Ehresman Sent: Tue 11/30/2004 6:10 AM To: [EMAIL PROTECTED] Subject: SQL Help I'm trying to get

Re: Select Statement Help for Volume Breakdown

2004-11-30 Thread James Choate
Matt, The scratch column is case sensitive. Looks like the yes no are capitalized. The status column is YES|NO|NULL james From: ADSM: Dist Stor Manager on behalf of Richard Sims Sent: Tue 11/30/2004 6:13 AM To: [EMAIL PROTECTED] Subject: Re: Select

Re: Select Statement Help for Volume Breakdown

2004-11-30 Thread Richard Sims
On Nov 30, 2004, at 8:40 AM, James Choate wrote: The scratch column is case sensitive. Looks like the yes no are capitalized. The status column is YES|NO|NULL Such things are prone to change over time: in some releases only the initial character is capitalized. We often have to find out the

Re: SQL Help

2004-11-30 Thread David E Ehresman
That groups things by a time stamp which results in a count of one for each time stamp. I'm trying to get a count by date, not by minute/second. David [EMAIL PROTECTED] 11/30/2004 8:16:10 AM Try this. select date(pending_date), count(*) from volumes where - status='PENDING' - group by

Re: Select Statement Help for Volume Breakdown

2004-11-30 Thread David E Ehresman
The use of upper/lower functions in SQL statements can save a lot of grief! [EMAIL PROTECTED] 11/30/2004 8:47:29 AM On Nov 30, 2004, at 8:40 AM, James Choate wrote: The scratch column is case sensitive. Looks like the yes no are capitalized. The status column is YES|NO|NULL Such things

Re: SQL Help

2004-11-30 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman I'm trying to get a count of tapes pending by date. I'm using: select date(pending_date),count(*) from volumes where status='PENDING' - group by date(pending_date) but I get the error message:

LAN-free Data transfer

2004-11-30 Thread Joni Moyer
Hello All! TSM 5.2.2.5 server AIX 5.2 Sun Solaris Lan-Free client 5.2.2.5 Once the lan-free data transfer fails it is stated that you must recycle the storage agent. I was just wondering what everyone has in place to accomplish this once lan-free has failed? Do you look at the system every 1/2

Re: LTO Media

2004-11-30 Thread Kauffman, Tom
It may not clean the drive, but the library updated the usage counter for the tape evry time we loaded it. Tom -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stef Coene Sent: Tuesday, November 30, 2004 1:32 AM To: [EMAIL PROTECTED] Subject: Re:

Re: auto reply for checkin and checkout

2004-11-30 Thread Bill Boyer
Not until TSM 5.3. When you use SEARCH=BULK you get the reply. For a Unix box you could use this small shell script. I think someone on this list posted it..I don't lay claims to it. For our Windows servers, we have a small Perl script that does the same thing. # set the admin username and

Re: size of active vs. inactive?

2004-11-30 Thread Johnson, Milton
We have been using a VTL for 3-4 months and we consider it a success. Environment: * OS: AIX 4330-11 * TSM: Version 4, Release 2, Level 1.7 * Physical Library:

Re: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2

2004-11-30 Thread Bill Boyer
You will need to uninstall the current TSM filesets. There are different versions for AIX5 in the TSM filesets..plus if you're turning on 64-bit. When we did this we did: 1. BA DB T=FULL 2. Halt TSM 3. Uninstall TSM (SMITTY) 4. We saved the files DSMSERV.DSK, DSMSERV.OPT, DEVCONFIG and VOLHISTORY

Re: size of active vs. inactive?

2004-11-30 Thread Richard Sims
On Nov 30, 2004, at 9:58 AM, Johnson, Milton wrote: ...Needless to say, I disagree with the statement that TSM doesn't appear to be a good fit for a VTL. Remember a VTL is just a library that can mount/unmount a tape in less than one second and read/write to the tape at disk speeds. Why wouldn't

Re: tsm server and nas client

2004-11-30 Thread Killam, Perpetua
Hi 1. we have tsm 5.2 running on sun 5.8, our nas tsm client is on hp11 tsm 5.1 version,Everytime we tried to backup, we are getting these errors and no backup PrivIncrFileSpace: Received rc=106 from fioGetDirEntries: error message And no backup performed, any ideas would be helpful. 2. we

Re: size of active vs. inactive?

2004-11-30 Thread Prather, Wanda
A lot of the earlier discussions on the list were related to the IBM 3494 VTL, which was designed for handling small chunks of seldom-used sequential data. It is prone to performance issues when handling LARGE chunks of sequential data, so it is not a good fit for backup products like TSM, which

IMAGE backups on AIX

2004-11-30 Thread Zoltan Forray/AC/VCU
What is the minimum client level to perform IMAGE backups on AIX ?

scheduled SQL log backup question

2004-11-30 Thread Luc Beaudoin
Hi all I'm doing SQL LOG backup every 6 hours and a full backup every day ... I got a failed status everytime cause I can not take theLOG backup of the master DB ... This is the command that I launch ... %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqllog.log

Re: size of active vs. inactive?

2004-11-30 Thread Johnson, Milton
I agree with your comments and yes if your server/client can stream data fast enough to the tape drive you may be able to out-pace a disk drive. If you can not keep up with the tape drive then you can take a serious performance hit when the tape stops, repositions and restarts. This performance

Overflow location

2004-11-30 Thread Sandra
Dear All, today i ran into something on : TSM 5.2.3 on Windows 2000 server. I have 3582 Library and my sequential storage poool is setup with 9 volumes for collocation. No as per the policies of various servers' data retention, these are not enough for this amount of data and my backups fail

Re: ANR0781E

2004-11-30 Thread Thomas Denier
Well, the HELP for ANR0781E indicates this: ANR0781E Export/import command: Process aborted - server sign on failed. Explanation: The server export/import process encounters an internal error in establishing an intermemory communications session with other server components. System

tsm client for netware and netware file compression

2004-11-30 Thread Steve Bennett
We are considering use of client side compression on some of our netware tsm 5.2 clients. Netware is set to compress files that haven't been used in 7 days. I found some doc that said even with compress yes the tsm client will not compress netware compressed files before sending. But what about

Re: tsm client for netware and netware file compression

2004-11-30 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Steve Bennett We are considering use of client side compression on some of our netware tsm 5.2 clients. Netware is set to compress files that haven't been used in 7 days. I found some doc that said even with compress yes the

Re: tsm client for netware and netware file compression

2004-11-30 Thread Rushforth, Tim
There used to be an option for Netware called: NWIGNORECOMpressbit I have not worked with NetWare for a while but this option would do what it sounds like it does - not re-backup the file when NetWare compresses it. Tim Rushforth City of Winnipeg -Original Message- From: Steve Bennett

Re: scheduled SQL log backup question

2004-11-30 Thread Joe Crnjanski
I think you cannot take log backup of master db; only full; that doesn't matter, it is small database (but very important) In your script put tdpsqlc backup db1,db2,db3,db4 log . Db1,db2... are database names (don't include master) Joe Crnjanski - Partner Infinity Network Solutions Inc.

Re: scheduled SQL log backup question

2004-11-30 Thread Luc Beaudoin
Thanks Joe . I thought of that one but I was hopping for a nice exetp option ... cool .. I will do that way... thanks again Luc Joe Crnjanski [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2004-11-30 01:35 PM Please respond to ADSM: Dist Stor Manager To:

Re: tsm client for netware and netware file compression

2004-11-30 Thread Steve Bennett
Mark, First, let me say I don't do netware. My netware admins indicate that compression happens at the file level but then maybe we're both confused. We are going to client compression because of a few clients with network restrictions but more because we are replacing most of our primary tape

Re: scheduled SQL log backup question

2004-11-30 Thread Del Hoobler
Luc, This is a known requirement that has been submitted and being prioritized for a future release, i.e. allowing you to exclude certain databases from a command. Thanks, Del ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/30/2004

Re: tsm client for netware and netware file compression

2004-11-30 Thread Andrew Raibeck
Check out the NWIGNORECOMPRESSBIT option. 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] The only dumb question is the one that goes unasked. The command

Read Only Script

2004-11-30 Thread Meadows, Andrew
I am attempting to create a script with little success for taking our LTO tapes that are in read only status and moving the data to other tapes in the same storage pool, then sending an e mail to a human for the tape to be removed from the library. Does anyone currently have a script that does

Re: scheduled SQL log backup question

2004-11-30 Thread Steve Schaub
Del/Luc, I just finished setting up our TDP environment and hit this as well - the easiest way out is to code a client option set for your TDP-SQL nodes that excludes the log backups from master. Mine looks like this: compression yes inclexcl include '\...\*' STD_SQLDB

Re: Read Only Script

2004-11-30 Thread Lawrence Clark
I don't know ...copies take a long time If you have a copy pool you can do a select to generate a list and then: - check them out -mark them destroyed - execute a restore stgpool, assuming your copypool volumes are in a library But below is an outline for what you want to do a script

Re: scheduled SQL log backup question

2004-11-30 Thread Joe Crnjanski
After I sent my last post I remembered this (from dsm.smp) *==* * The following include statements assign all meta objects to * * management class SqlDbMetaMgmtClass and all data objects to * *

Re: scheduled SQL log backup question

2004-11-30 Thread Del Hoobler
Luc, Steve, Joe, Yes, this will work, and it will show up as an excluded database in the statistics at the end. There is a similar requirement for from some customers to remove a database from being examined at all. Data Protection will examine (get status and other details) all databases, even

Re: Overflow location

2004-11-30 Thread Steve Harris
Sandra, There is a section in the Admin Guide on dealing with a full library. Regards Steve. [EMAIL PROTECTED] 01/12/2004 3:27:52 Dear All, today i ran into something on : TSM 5.2.3 on Windows 2000 server. I have 3582 Library and my sequential storage poool is setup with 9 volumes for

Adding TSM instances to MS Cluster environment

2004-11-30 Thread Graham Trigge
Fellow TSMers, I am setting up TSM 5.2.3 on a two node, W2K active/active cluster (no shared libraries as all backups are running to disk only). I have successfully created my first virtual server on both cluster nodes with no problems. I have successfully created the first half of the second