Slow Database Response Time
It's me again... Here's the scenario
Windows 2003 environment, Uncompressed catalog totaling 220GB and rising and I have 350 tapes I need to manually expire because I was told to give then an Infinity retention and a year later they've changed their mind and I can now reuse the tapes. Running the bpexpdate command against one piece of media took almost 2 hours for the database to respond. My questions are:
1. Is there an easier/quicker way to do this? The GUI?
2. Why is the database responding so slow? Is it simply the size or might there be other issues?
I've noticed the slow response before but just recently saw what a great place this was for questions so I'm putting the resource to good use.
Thanks in advance,
Helpless in Houston
Windows 2003 environment, Uncompressed catalog totaling 220GB and rising and I have 350 tapes I need to manually expire because I was told to give then an Infinity retention and a year later they've changed their mind and I can now reuse the tapes. Running the bpexpdate command against one piece of media took almost 2 hours for the database to respond. My questions are:
1. Is there an easier/quicker way to do this? The GUI?
2. Why is the database responding so slow? Is it simply the size or might there be other issues?
I've noticed the slow response before but just recently saw what a great place this was for questions so I'm putting the resource to good use.
Thanks in advance,
Helpless in Houston
