Re: DB Backup in v5 TSM (5.1.1.6, 5.1.5.2, 5.1.5.4)

2002-12-11 Thread Andy Carlson
I should have mentioned that I tried it unmirrored (log and db) also.


Andy Carlson|\  _,,,---,,_
Senior Technical Specialist   ZZZzz /,`.-'`'-.  ;-;;,_
BJC Health Care|,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri   '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html


On Tue, 10 Dec 2002, Seay, Paul wrote:

 My database saves at about 22,000,000 pages an hour.  I have taken the
 messages from the log and they are consistently the same.  I do not know
 what is causing this.  There were some performance problems with mirrored
 databases, but I thought they were fixed at your level.

 Paul D. Seay, Jr.
 Technical Specialist
 Naptheon Inc.
 757-688-8180


 -Original Message-
 From: Andy Carlson [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, December 10, 2002 2:43 PM
 To: [EMAIL PROTECTED]
 Subject: DB Backup in v5 TSM (5.1.1.6, 5.1.5.2, 5.1.5.4)


 I have a strange problem that I have been working with IBM on, but was told
 it's working as designed.  I have a new TSM server, which started life as
 5.1.1.6, upgraded to 5.1.5.2 at IBM's request, then just did 5.1.5.4 today
 after seeing it had been released.  I back up the database, which is only
 124000 pages since it is a new server.  It backs up the first 9 pages in
 a couple of minutes.  The last 34000 pages take over an hour.  While this is
 happening, there is very little CPU and I/O going on.  I have tried the
 database on SCSI, and on FastT700, the backup file on each, etc.  I can make
 it go away temporarily if I unload and reload, but once this database gets
 bigger, that will not be an option.  Any ideas?  Thanks.


 Andy Carlson|\  _,,,---,,_
 Senior Technical Specialist   ZZZzz /,`.-'`'-.  ;-;;,_
 BJC Health Care|,4-  ) )-,_. ,\ (  `'-'
 St. Louis, Missouri   '---''(_/--'  `-'\_)
 Cat Pics: http://andyc.dyndns.org/animal.html




Re: DB Backup in v5 TSM (5.1.1.6, 5.1.5.2, 5.1.5.4)

2002-12-10 Thread Seay, Paul
My database saves at about 22,000,000 pages an hour.  I have taken the
messages from the log and they are consistently the same.  I do not know
what is causing this.  There were some performance problems with mirrored
databases, but I thought they were fixed at your level.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Andy Carlson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 2:43 PM
To: [EMAIL PROTECTED]
Subject: DB Backup in v5 TSM (5.1.1.6, 5.1.5.2, 5.1.5.4)


I have a strange problem that I have been working with IBM on, but was told
it's working as designed.  I have a new TSM server, which started life as
5.1.1.6, upgraded to 5.1.5.2 at IBM's request, then just did 5.1.5.4 today
after seeing it had been released.  I back up the database, which is only
124000 pages since it is a new server.  It backs up the first 9 pages in
a couple of minutes.  The last 34000 pages take over an hour.  While this is
happening, there is very little CPU and I/O going on.  I have tried the
database on SCSI, and on FastT700, the backup file on each, etc.  I can make
it go away temporarily if I unload and reload, but once this database gets
bigger, that will not be an option.  Any ideas?  Thanks.


Andy Carlson|\  _,,,---,,_
Senior Technical Specialist   ZZZzz /,`.-'`'-.  ;-;;,_
BJC Health Care|,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri   '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html