Please reply anyone !! -- ANR2020E QUERY CONTENT: Invalid parameter - NAMETYPE and Other one is CODETYPE

2004-07-30 Thread Muhammad Sadat
Dear All,
I have just installed TSM Extended Edition 5.2.2.
Taken a backup and even restored it.
While I am trying to Query the contents of a storage pool volume I am
getting this error

ANR2020E  QUERY CONTENT: Invalid parameter - NAMETYPE
ANR2020E  QUERY CONTENT: Invalid parameter - CODETYPE

Whereas the same in TSM Standard Edition 5.2 was  working.

Yes I understand there is some required combination like Filespace and File
Space Nmae Type and File Space Code Page Type.

In File space i put \\tivoli\d$ as seen in Clients' file spaces.
leaving the rest default as:
FileSpace Name type = Server
FileSpace Code page type = BOTH

The error:
ANR2020E  QUERY CONTENT: Invalid parameter - NAMETYPE
appears when i don't give the filespace.

The error:
ANR2020E  QUERY CONTENT: Invalid parameter - CODETYPE
appears when i give the filespace.

Please help!

Kind Regards
Muhammad SaDaT Anwar
Product Specialist
Systems Management  Data Management Products

Info Tech (Pvt) Limited
108, Business Avenue,
Main Shahrah-e-Faisal,
Karachi, Pakistan
Ph: +92-21-111-427-427 Fax: +92-21-4310569
Cell: +92-21-300-8211943



Re: TSM Client migration

2004-07-30 Thread Gilles
Hi,

You can export a node directly to another server using the following commands:

EXPORT ADMIN (Export Administrator Information)
EXPORT NODE (Export Client Node Information)
if needed: EXPORT POLICY (Export Policy Information)

On Fri, 30 Jul 2004 00:37:10 -0500, Pan, Sanjoy [EMAIL PROTECTED] wrote:
 Dear all,
 Please let me know how I can migrate a client's(Win2k,Linux  Solaris)
 data from one server(TSM 5.1.8.1) to another.

 Thanks  best regards,
 Sanjoy



Réf. : 3494 Scratch Categories

2004-07-30 Thread Francois Chevallier
On aix it's possible with th mtlib command (I suppose you can find the same
command on others platforms)

Pour avoir la catégorie d'une cartouche :
mtlib -l /dev/lmcp0 -qV -V volser

Pour la changer de catégorie

mtlib  -l /dev/lmcp0  -C -V volser  (-s catégorie source)  -t catégorie
(target) (-n) -n = no wait time


Cordialement

François Chevallier
Parc Club du Moulin à Vent
33 av G Levy
69200 - Vénissieux
tél : 04 37 90 40 56  / 06 10 68 15 50



|-+
| |   David E Ehresman |
| |   [EMAIL PROTECTED]|
| |   LLE.EDU |
| |   Envoyé par : |
| |   ADSM: Dist Stor |
| |   Manager |
| |   [EMAIL PROTECTED]|
| |   .EDU|
| ||
| ||
| |   29/07/2004 17:20 |
| |   Veuillez répondre|
| |   à ADSM: Dist|
| |   Stor Manager|
| ||
|-+
  
--|
  |
  |
  |   Pour :[EMAIL PROTECTED]  
   |
  |   cc : 
  |
  |   Objet :   3494 Scratch Categories
  |
  
--|




Is there a way to change the value of the 3494 scratchcategory and
privatecategory without deleting the library, drive and path definitions
and redefining them?

David





Informix XPS not respecting mount points limit

2004-07-30 Thread PAC Brion Arnaud
Hi list,

Could anybody tell me if following behaviour is normal :

I have a node which was attributed a mount point limit of 2. This node
has Informix XPS installed, with 4 workers activated. 
Problem is that an onbar backup automatically mounts 4 tapes on TSM
server, therefore not respecting TSM defined mount limit !
Environment : 
server : TSM 5.2.2.1 on AIX 5.2
client : TSM BA 5.2.0.0 (32 bit), TDP for informix : 5.1.5.0 (64 bit),
API : 5.1.5.0 (64 bit) - informix XPS 8.40 ud1 (64 bit)

Anyone faced this before, or having an explanation/solution ?
Thanks in advance ! 

Arnaud 


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

**


Library Configuration and Device Drivers

2004-07-30 Thread Joni Moyer
Hello everyone!

A little background of our new environment would be 2 TSM servers, 1
development and 1 production, are AIX 5.2 at the TSM 5.2.2.5 level.  They
will be attached, through a McData 6064 director, to an STK SL8500 library
with 18 LTO2 tape drives.

I am not sure what device drivers to use for our environment.  I was
looking at the TSM Implementation Guide on pg. 89 and it stated that if we
use LTO drives we should use the IBMTape device driver instead of TSM's
device driver.  Is this correct?  Also, when I used the link from that site
it didn't exist, but if I used  ftp://ftp.software.ibm.com/storage/devdrvr

then it worked and I found the links to the device drivers for the AIX TSM
servers would be ATape device drivers and the Solaris LAN-free client
servers would be IBMTape device drivers.

Also,  with our configuration and 2 TSM servers using Gresham EDT and
ACSLS7.1, what type of library do I define in TSM?  I have defined an
external library, but now I'm wondering if I need an automated library
along with a shared library defined  with our production TSM server being
the primary library manager?  We will be sharing all 18 drives and the tape
pool.  As far as I know the scratch tape pool is defined within ACSLS.  For
the definition of the automated library it states that this is for SCSI
libraries only, which ours is fibre.  My thoughts on this are that I would
define the external library (with Lan-free capabilities) and then define a
shared library, but you don't give the master library the same name as the
shared library.  I guess I'm just a little confused on how this works and
will be set up in our environment.  Any suggestions would be appreciated!
Thanks!



Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]



Re: Library Configuration and Device Drivers

2004-07-30 Thread Guillaume Gilbert
You wre correct on the drivers. As for Gresham, just the external library
wil be ok. The library will be managed by ACSLS. You will need
DistribuTape on any client using Lanfree capabilities. They are set up the
same way your server will be.

Congratulations on the L8500, this things looks amazing.

Guillaume Gilbert
IT Specialist - TSM
Infrastructure Services Delivery
IBM Global Services
Tel.:  (514) 964-2795
[EMAIL PROTECTED]



Joni Moyer [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
2004-07-30 07:28
Please respond to
ADSM: Dist Stor Manager


To
[EMAIL PROTECTED]
cc

Subject
Library Configuration and Device Drivers






Hello everyone!

A little background of our new environment would be 2 TSM servers, 1
development and 1 production, are AIX 5.2 at the TSM 5.2.2.5 level.  They
will be attached, through a McData 6064 director, to an STK SL8500 library
with 18 LTO2 tape drives.

I am not sure what device drivers to use for our environment.  I was
looking at the TSM Implementation Guide on pg. 89 and it stated that if we
use LTO drives we should use the IBMTape device driver instead of TSM's
device driver.  Is this correct?  Also, when I used the link from that
site
it didn't exist, but if I used  ftp://ftp.software.ibm.com/storage/devdrvr

then it worked and I found the links to the device drivers for the AIX TSM
servers would be ATape device drivers and the Solaris LAN-free client
servers would be IBMTape device drivers.

Also,  with our configuration and 2 TSM servers using Gresham EDT and
ACSLS7.1, what type of library do I define in TSM?  I have defined an
external library, but now I'm wondering if I need an automated library
along with a shared library defined  with our production TSM server being
the primary library manager?  We will be sharing all 18 drives and the
tape
pool.  As far as I know the scratch tape pool is defined within ACSLS. For
the definition of the automated library it states that this is for SCSI
libraries only, which ours is fibre.  My thoughts on this are that I would
define the external library (with Lan-free capabilities) and then define a
shared library, but you don't give the master library the same name as the
shared library.  I guess I'm just a little confused on how this works and
will be set up in our environment.  Any suggestions would be appreciated!
Thanks!



Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]



Re: D2D vs. tape backups with TSM?

2004-07-30 Thread Robert R Price
I know that I must be missing something here, but can someone explain why
this D2D backup scheme utilizes what I assume to be the sequential FILE
device type?  Why not just use the (random) DISK storage pool type.  This
would eliminate any co-location issues, reclaims and not waste ANY disk
space with deleted files?  Would someone enlighten me?






This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.






  TSM_User
  tsm_userTo:  [EMAIL PROTECTED]
  @YAHOO.COM  cc:
  Sent by: ADSM:  Subject: Re: D2D vs. tape backups with 
TSM?
  Dist Stor
  Manager ADSM-L


  07/29/04 08:03
  PM
  Please respond
  to ADSM: Dist
  Stor Manager






I aggree about not using collocation but this customer has always
collocated everything offsite and onsite.  Moving to ATA was step one.
Step two is getting them to turn off collocation on all the Large File
data. Step three is going to be turnning off collocation for everything on
disk.

Rushforth, Tim [EMAIL PROTECTED] wrote:We have always used
compression going to Disk. We use exclude.compression
for things like .zip etc. You may want to use compressalways yes to avoid
resending data that grows.

We are not collocating at all - why would you want to? From a restore
perspective (using multi-session restore) it is better to have the data
spread out across multiple volumes.

-Original Message-
From: TSM_User [mailto:[EMAIL PROTECTED]
Sent: July 28, 2004 8:29 PM
To: [EMAIL PROTECTED]
Subject: Re: D2D vs. tape backups with TSM?

We are using 25 GB volumes right now. We are also still collocating the
storage pools that use the file device class by node. This has worked out
fine for us. Sad to admit but I wasn't aware of the Technical Exchange
recommendation. Is there a white paper from that you could refer me to.

We are contemplating turning on node compression everywhere to also help
reduce disk space.

Also, I made mention in a previous post that we were reclaiming down to 50%
and that was fine. Well, like always when you make a comment like that it
makes you think and they you go look. I found that we were using around 16
TB's of ATA space in all when you look at the In Use numbers. When I
looked at the actual disk in use it was closer to 21 TB's of data. I am
currently reclaiming everything down to 40 and I plan to get down to 25
again. At that point I will compare the numbers and see how much I can
reduce the 21 TB's in use.

Also somewhat interesting information. We have found that the I/O
capabilities of the latest and greatest servers can really help push a lot
more data to disk. We have always been told by our disk vendor that the
bottleneck wasn't them. We ruled out many things except them. Finally we
looked at a more detailed performance monitor of our systems and we found
that the we were killing the processor during times when we were pushing a
lot of data to disk. With these new servers we see migrations from Fibre
disk to ATA disk at over 150 GB/hr. We do have 60 TB's of ATA space though
so we have a lot of disks to write to.


Rushforth, Tim wrote:
Just curious what size of file volumes are you using? We were originally
using 25 GB, and then I listened to the Disk Only Backup Strategies
Technical Exchange where they recommended 2-4 GB volumes.

Thanks,

Tim Rushforth
City of Winnipeg

-Original Message-
From: TSM_User [mailto:[EMAIL PROTECTED]
Sent: July 27, 2004 6:41 PM
To: [EMAIL PROTECTED]
Subject: Re: D2D vs. tape backups with TSM?

Funny, we set ours down to 25% as well just to see what would happen. This
worked but we have since set all of the ATA Pools to 50% and we just leave
them there. Theoretically what could happen is we could be wasting twice as
much space but the fact is the volumes were going from 25% to 50% in a
matter of days and when we looked at how many volumes were between 25% and
50% in our environment we determined there was no need to reclaim down that
far. From all outward signs there was no issues with reclaiming down to 25%
we just didn't think it was worth doing the extra work to get back such a
small amount of disk. Disk is cheap, right! lol


Rushforth, Tim wrote:
We've set ours at 25%. We are just piloting an all disk backup pool for
some clients on one of our 

Re: D2D vs. tape backups with TSM?

2004-07-30 Thread Rushforth, Tim
Both can be used, both have advantages and disadvantages.

TSM development is focusing efforts on File Device Class.

Search the archives for some info on which to use
(http://msgs.adsm.org/cgi-bin/get/adsm0406/106.html)

Check out the 5.2 Admin guide - it has a nice table comparing disk vs file.

The biggest drawbacks of disk to me are - no reclamation of aggregates and
no multi-session restore. (See the comparisons for more).

-Original Message-
From: Robert R Price [mailto:[EMAIL PROTECTED]
Sent: July 30, 2004 9:32 AM
To: [EMAIL PROTECTED]
Subject: Re: D2D vs. tape backups with TSM?

I know that I must be missing something here, but can someone explain why
this D2D backup scheme utilizes what I assume to be the sequential FILE
device type?  Why not just use the (random) DISK storage pool type.  This
would eliminate any co-location issues, reclaims and not waste ANY disk
space with deleted files?  Would someone enlighten me?


Re: Please reply anyone !! -- ANR2020E QUERY CONTENT: Invalid parameter - NAMETYPE and Other one is CODETYPE

2004-07-30 Thread Joerg Pohlmann
Muhammad, please upgrade to 5.2.2.5 or even to 5.2.3.0+5.2.3.1 as you are
seeing bugs in 5.2.2.0 that have long been fixed.

Download 5.2.2.5 from

ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/server/

Download 5.2.3.0 from

ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintenance/server/v5r2/

The downloads are accessible to anyone unless your TSM server runs on zOS
or OS/390 in which case you will need a password from IBM service.

Joerg Pohlmann
604-535-0452




Muhammad Sadat [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
2004-07-29 21:45
Please respond to
ADSM: Dist Stor Manager


To
[EMAIL PROTECTED]
cc

Subject
Please reply anyone !! -- ANR2020E  QUERY CONTENT: Invalid parameter -
NAMETYPE and  Other one is CODETYPE






Dear All,
I have just installed TSM Extended Edition 5.2.2.
Taken a backup and even restored it.
While I am trying to Query the contents of a storage pool volume I am
getting this error

ANR2020E  QUERY CONTENT: Invalid parameter - NAMETYPE
ANR2020E  QUERY CONTENT: Invalid parameter - CODETYPE

Whereas the same in TSM Standard Edition 5.2 was  working.

Yes I understand there is some required combination like Filespace and
File
Space Nmae Type and File Space Code Page Type.

In File space i put \\tivoli\d$ as seen in Clients' file spaces.
leaving the rest default as:
FileSpace Name type = Server
FileSpace Code page type = BOTH

The error:
ANR2020E  QUERY CONTENT: Invalid parameter - NAMETYPE
appears when i don't give the filespace.

The error:
ANR2020E  QUERY CONTENT: Invalid parameter - CODETYPE
appears when i give the filespace.

Please help!

Kind Regards
Muhammad SaDaT Anwar
Product Specialist
Systems Management  Data Management Products

Info Tech (Pvt) Limited
108, Business Avenue,
Main Shahrah-e-Faisal,
Karachi, Pakistan
Ph: +92-21-111-427-427 Fax: +92-21-4310569
Cell: +92-21-300-8211943



Tape issue

2004-07-30 Thread Coats, Jack
I have a tape that says it is empty if I do a 'q content', but it will not
go back into scratch.
If I do a 'delete vol' I am told there is still data on the tape.

I am guessing that a set of files is 'bundled together' (I forget the
official techno speak for this, but it helps cluster lots of small files
into one larger file), and the bundle extends over two tapes, and this is
the second tape.  But that is ONLY A GUESS.

Is there a way to verify this?

... Jack


Re: Tape issue

2004-07-30 Thread Levi, Ralph
Try doing:  audit vol xxx fix=yes

Ralph

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Coats, Jack
Sent: July 30, 2004 1:09 PM
To: [EMAIL PROTECTED]
Subject: Tape issue


I have a tape that says it is empty if I do a 'q content', but it will
not
go back into scratch.
If I do a 'delete vol' I am told there is still data on the tape.

I am guessing that a set of files is 'bundled together' (I forget the
official techno speak for this, but it helps cluster lots of small files
into one larger file), and the bundle extends over two tapes, and this
is
the second tape.  But that is ONLY A GUESS.

Is there a way to verify this?

... Jack


Re: Tape issue

2004-07-30 Thread Doug Thorneycroft
Have you tried running audit volume ?



-Original Message-
From: Coats, Jack [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 10:09 AM
To: [EMAIL PROTECTED]
Subject: Tape issue


I have a tape that says it is empty if I do a 'q content', but it will not
go back into scratch.
If I do a 'delete vol' I am told there is still data on the tape.

I am guessing that a set of files is 'bundled together' (I forget the
official techno speak for this, but it helps cluster lots of small files
into one larger file), and the bundle extends over two tapes, and this is
the second tape.  But that is ONLY A GUESS.

Is there a way to verify this?

... Jack


Re: Tape issue

2004-07-30 Thread Coats, Jack
Ralph and Doug have a good idea.  I'll give it a try!

They both suggested doing an 'audit volume'.

-Original Message-
From: Levi, Ralph [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 12:12 PM
To: [EMAIL PROTECTED]
Subject: Re: Tape issue


Try doing:  audit vol xxx fix=yes

Ralph

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Coats, Jack
Sent: July 30, 2004 1:09 PM
To: [EMAIL PROTECTED]
Subject: Tape issue


I have a tape that says it is empty if I do a 'q content', but it will
not
go back into scratch.
If I do a 'delete vol' I am told there is still data on the tape.

I am guessing that a set of files is 'bundled together' (I forget the
official techno speak for this, but it helps cluster lots of small files
into one larger file), and the bundle extends over two tapes, and this
is
the second tape.  But that is ONLY A GUESS.

Is there a way to verify this?

... Jack


Re: Tape issue

2004-07-30 Thread Mike Bantz
What's your reusedelay set to?

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Coats, Jack
Sent: Friday, July 30, 2004 11:09 AM
To: [EMAIL PROTECTED]
Subject: Tape issue

I have a tape that says it is empty if I do a 'q content', but it will not
go back into scratch.
If I do a 'delete vol' I am told there is still data on the tape.

I am guessing that a set of files is 'bundled together' (I forget the
official techno speak for this, but it helps cluster lots of small files
into one larger file), and the bundle extends over two tapes, and this is
the second tape.  But that is ONLY A GUESS.

Is there a way to verify this?

... Jack


TDP SQL errors backing up SQLSERVER Cluster on Windows2003

2004-07-30 Thread Bill Boyer
Windows2003 Cluster running SQL Server
TDP SQLServer 5.1.5.0
TSM Client 5.2.2.10
TSM Server on Windows2003 5.2.2.5


We were doing TDP backups of the SQLDatabases just fine, until the cluster
was re-addressed for IP. Now when the TDP backup runs, right at the end it
fails with a DBNETLIB error. It's looking like Microsoft #827452, but it was
working. What could have changed, or not changed, when the IP addresses were
changed? The Ipaddress of both cluster nodes as well as the cluster IP
resource were changed. TSM PROMPTED scheduling works, the B/A backups of the
C: drives on each node work, but the TDP backups fail.

I opened a PMR and they just pointed us to the Microsoft problem.

Anyone having problems or have some suggestions???

Bill Boyer
An Optimist is just a pessimist with no job experience.  - Scott Adams


Re: Tape issue

2004-07-30 Thread David Longo
I occasionally get one of these.  Doing a move data on it
moves the little bit of data and frees up the tape.



David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5509
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 07/30/04 01:09PM 
I have a tape that says it is empty if I do a 'q content', but it will
not
go back into scratch.
If I do a 'delete vol' I am told there is still data on the tape.

I am guessing that a set of files is 'bundled together' (I forget the
official techno speak for this, but it helps cluster lots of small
files
into one larger file), and the bundle extends over two tapes, and this
is
the second tape.  But that is ONLY A GUESS.

Is there a way to verify this?

... Jack

##
This message is for the named person's use only.  It may
contain confidential, proprietary, or legally privileged
information.  No confidentiality or privilege is waived or
lost by any mistransmission.  If you receive this message
in error, please immediately delete it and all copies of it
from your system, destroy any hard copies of it, and notify
the sender.  You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient.  Health First reserves
the right to monitor all e-mail communications through its
networks.  Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of
a particular entity;  and (2) the sender is authorized by
the entity to give such views or opinions.
##


Restoring the oldest version

2004-07-30 Thread David DeCuir
A customer wants restored the oldest version of every fileTSM has for a
certain node. What's the best way to do this?

Example:
If there is only one copy of a file and it is active, they want that one.
If there are 2 inactives and 1 active, they want the oldest inactive.

Thanks,
David


Re: TDP SQL errors backing up SQLSERVER Cluster on Windows2003

2004-07-30 Thread Del Hoobler
Bill,

All I can say is that Microsoft found a problem
in MDAC that they had to fix. Every time we have seen the
[DBNETLIB]ConnectionRead (WrapperRead()) error
when backing up with Data Protection for SQL,
it has turned out to be KB827452. I think I remember
something about registry entries being invalid...
or something like that. Microsoft should be able
to tell you more details on what they fixed.
Here is the link to the KB article:

   http://support.microsoft.com/default.aspx?scid=kb;EN-US;827452

Thanks,

Del



ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 07/30/2004
02:15:50 PM:

 Windows2003 Cluster running SQL Server
 TDP SQLServer 5.1.5.0
 TSM Client 5.2.2.10
 TSM Server on Windows2003 5.2.2.5


 We were doing TDP backups of the SQLDatabases just fine, until the
cluster
 was re-addressed for IP. Now when the TDP backup runs, right at the end
it
 fails with a DBNETLIB error. It's looking like Microsoft #827452, but it
was
 working. What could have changed, or not changed, when the IP addresses
were
 changed? The Ipaddress of both cluster nodes as well as the cluster IP
 resource were changed. TSM PROMPTED scheduling works, the B/A backups of
the
 C: drives on each node work, but the TDP backups fail.

 I opened a PMR and they just pointed us to the Microsoft problem.

 Anyone having problems or have some suggestions???

 Bill Boyer
 An Optimist is just a pessimist with no job experience.  - Scott Adams


Re: TDP SQL errors backing up SQLSERVER Cluster on Windows2003

2004-07-30 Thread Bill Boyer
Doing some more research on Microsoft and talking with the client, they
re-addressed the cluster on 7/26 when they moved it into their new CISCO
switch with VLAN's configured. I think they changed all the IP addresses
except for the IP address of the SQL Server virtual instance. I found a
couple articles on Microsoft about TCP not binding to the correct port after
an IP change to the cluster. I forwarded those articles to the client, but I
don't know if this is the problem either. The TDP backups worked before the
IP address change, so I'm hopeful!

This box is going production in a week and the backups dont' work now! Even
though it's a SQL error that is being returned, the DBA's point to TSM. So
it's up to me to fix it.

This is the KB article that level-2 referred to in my PMR. The DBA says
that's not the problem. They are using TCP, not named-pipes. The DBA says he
can back up the database via SQL Server manager, so it's not a SQL problem!

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Del Hoobler
Sent: Friday, July 30, 2004 4:08 PM
To: [EMAIL PROTECTED]
Subject: Re: TDP SQL errors backing up SQLSERVER Cluster on Windows2003


Bill,

All I can say is that Microsoft found a problem
in MDAC that they had to fix. Every time we have seen the
[DBNETLIB]ConnectionRead (WrapperRead()) error
when backing up with Data Protection for SQL,
it has turned out to be KB827452. I think I remember
something about registry entries being invalid...
or something like that. Microsoft should be able
to tell you more details on what they fixed.
Here is the link to the KB article:

   http://support.microsoft.com/default.aspx?scid=kb;EN-US;827452

Thanks,

Del



ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 07/30/2004
02:15:50 PM:

 Windows2003 Cluster running SQL Server
 TDP SQLServer 5.1.5.0
 TSM Client 5.2.2.10
 TSM Server on Windows2003 5.2.2.5


 We were doing TDP backups of the SQLDatabases just fine, until the
cluster
 was re-addressed for IP. Now when the TDP backup runs, right at the end
it
 fails with a DBNETLIB error. It's looking like Microsoft #827452, but it
was
 working. What could have changed, or not changed, when the IP addresses
were
 changed? The Ipaddress of both cluster nodes as well as the cluster IP
 resource were changed. TSM PROMPTED scheduling works, the B/A backups of
the
 C: drives on each node work, but the TDP backups fail.

 I opened a PMR and they just pointed us to the Microsoft problem.

 Anyone having problems or have some suggestions???

 Bill Boyer
 An Optimist is just a pessimist with no job experience.  - Scott Adams


Re: TDP SQL errors backing up SQLSERVER Cluster on Windows2003

2004-07-30 Thread Del Hoobler
Bill,

Did you try this?

   tdpsqlc backup dbname full /sqlserver=tcp:server-name.abc.com

for example:

   tdpsqlc backup master full /sqlserver=tcp:couples.endicott.ibm.com

What happens?

If you can't get it working, please ask that the PMR be forwarded
to IBM Level 2 support. Level 2 can gather traces and work
with Microsoft support to identify the problem.

Thanks,

Del



ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 07/30/2004
04:19:31 PM:

 Doing some more research on Microsoft and talking with the client, they
 re-addressed the cluster on 7/26 when they moved it into their new CISCO
 switch with VLAN's configured. I think they changed all the IP addresses
 except for the IP address of the SQL Server virtual instance. I found a
 couple articles on Microsoft about TCP not binding to the correct port
after
 an IP change to the cluster. I forwarded those articles to the client,
but I
 don't know if this is the problem either. The TDP backups worked before
the
 IP address change, so I'm hopeful!

 This box is going production in a week and the backups dont' work now!
Even
 though it's a SQL error that is being returned, the DBA's point to TSM.
So
 it's up to me to fix it.

 This is the KB article that level-2 referred to in my PMR. The DBA says
 that's not the problem. They are using TCP, not named-pipes. The DBA
says he
 can back up the database via SQL Server manager, so it's not a SQL
problem!

 Bill Boyer
 DSS, Inc.


Re: TDP SQL errors backing up SQLSERVER Cluster on Windows2003

2004-07-30 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of Bill Boyer
This box is going production in a week and the backups dont' 
work now! Even
though it's a SQL error that is being returned, the DBA's 
point to TSM. So it's up to me to fix it.

This is the default behavior of application owners. It's not my fault!

This is the KB article that level-2 referred to in my PMR. The DBA says
that's not the problem. They are using TCP, not named-pipes. 
The DBA says he can back up the database via SQL Server manager, so 
it's not a SQL problem!

I've read somewhere (can't remember where, but it wasn't from Microsoft)
that the best practice when you want to change static addresses for a MS
cluster is to backup the data, blow away and rebuild Windows and the
app(s), and restore the data. Changing the IP address at the NIC level
leaves not-so-easily-found registry entries unchanged.

One suggestion (FWIW) is to determine what the virtual interface's
address was prior to the address change, and look for that address with
regedit. I don't know whether you should manually change that registry
entry, but you can at least show the SQL-heads that something didn't get
updated correctly.

--
Mark Stapleton


Delete file space by description

2004-07-30 Thread Greg
Hi,
Is there a way to delete file space based on the description used to
archive it? I have several file systems that have been archived from
time to time. However last week by mistake the file systems were
archived for seven years. These archives we spread amongst 6 file
systems and total over 2TB. So I would like to get the tape space back.
The only way I can find to delete the archives is by file space.
However if I delete file space for the file systems I am worried that
it will delete all archives for the FSID, not just the one archive I
want to delete.
TSM Server - AIX 4.3.3 running 5.1.6.5
Client - OS X 10.3.4 running 5.2.2
The OS X box is headless.. so all admin work is done via the shell.
Thanks in advance for any insight!
Greg


Re: Tape issue

2004-07-30 Thread Coats, Jack
I tried the move data.  But the tape also has a write error on it, so I am
guessing it cannot get to a fragment of a spanned file.

-Original Message-
From: David Longo [mailto:[EMAIL PROTECTED]
Subject: Re: Tape issue

I occasionally get one of these.  Doing a move data on it
moves the little bit of data and frees up the tape.


Re: Tape issue

2004-07-30 Thread Richard Sims
I tried the move data.  But the tape also has a write error on it, so I am
guessing it cannot get to a fragment of a spanned file.

Jack - Standard recourse, then: Restore Volume.

If that isn't possible for some reason, and you've tried Move Data multiple
times, on all your drives, then do a Query Content on the volume and see if
the file might still be present on the client for a fresh backup to reinstate
it in the TSM storage pool after a Delete Volume...Discard=Yes.

  Richard Sims


Help! TSM SysBack 5632 on AIX 5.2 with HACMP problem

2004-07-30 Thread Ameerul Mazli
Hi Anyone,
Got a genuine problem, I think.

Environment is:
TSM Svr (running on 1 LPAR of p690)-
-AIX 5.2
-TSM Svr 5.2.3
-TSM Client 5.2.2
-TSM Sysback 5.6.1
-Tape library: 3584LTO (4 drives)

TSM Client (running on 1 LPAR of p690)-
-AIX 5.2 with HACMP
-TSM Client 5.2.3
-TSM Sysback 5.6.3.2

The TSM Sysback on the TSM server runs fine.I can
create the TSM volume with no problems/errors.

The problem is on the TSM Sysback on the client. When
I try to create a TSM volume thru the SMIT menus, it
gives an error when I set the password:

BMR0026E Signal 11 received. Program terminating.
Could not set password for TSM server
kuldb11p_sysback

I tried setting back the password on the TSM svr using
the update node and then try again but still same
problem.

The funny thing is it only happens on the TSM clients
that is running HACMP. Both servers on the same pair
will have the problems.

PLS can anyone help me here.

Ameerul
Kuala Lumpur.


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


Help! TSM SysBack 5632 on AIX 5.2 with HACMP problem

2004-07-30 Thread Ameerul Mazli
Hi Anyone,
Got a genuine problem, I think.

Environment is:
TSM Svr (running on 1 LPAR of p690)-
-AIX 5.2
-TSM Svr 5.2.3
-TSM Client 5.2.2
-TSM Sysback 5.6.1
-Tape library: 3584LTO (4 drives)

TSM Client (running on 1 LPAR of p690)-
-AIX 5.2 with HACMP
-TSM Client 5.2.3
-TSM Sysback 5.6.3.2

The TSM Sysback on the TSM server runs fine.I can
create the TSM volume with no problems/errors.

The problem is on the TSM Sysback on the client. When
I try to create a TSM volume thru the SMIT menus, it
gives an error when I set the password:

BMR0026E Signal 11 received. Program terminating.
Could not set password for TSM server
kuldb11p_sysback

I tried setting back the password on the TSM svr using
the update node and then try again but still same
problem.

The funny thing is it only happens on the TSM clients
that is running HACMP. Both servers on the same pair
will have the problems.

PLS can anyone help me here.

Ameerul
Kuala Lumpur.




__
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now.
http://messenger.yahoo.com