Re: (Silly?) DB2 Backup question

2002-09-21 Thread MUSTAFA BAYTAR
Hi Bill, Yes you will be able to restore the database from online backup but before online db restore you must restore db logs that have been active during online backup into log_dir directory and after restore you must rollforward db to end of logs .for successful restore you need only

Re: DB Volume Reorg using Delete DBVOLUME

2002-09-21 Thread Roger Deschner
I have tried this, and I observed the same thing as Wayne. DELETE DBVOLUME will not force any reorganization. It runs too fast to be attempting any beneficial reorganization. It just moves whole pages, without regard to what parts of the B-tree shrubbery are in them. But also I have not seen it

q act says *No match found*

2002-09-21 Thread Chetan H. Ravnikar
Any help is appreciated, I am wondering how can this happen, a fully functional server now does not give any activity log please help thanks tsm: server1q act ANR2034E QUERY ACTLOG: No match found using this criteria. ANS8001I Return code 11. tsm: server1

Re: q act says *No match found*

2002-09-21 Thread Bob Booth - UIUC
Hard to tell whats going on. Is this a fresh install of TSM? What version? What platform is it? Do a 'q stat' and check to see what your activity log retention period is.. It is possible to set the ACTLOGRETENTION to 0, thereby turning it off. hope this helps, bob On Sat, Sep 21, 2002 at

Re: q act says *No match found*

2002-09-21 Thread Chetan H. Ravnikar
Bob thanks for the response. I am running TSM 4.2.20 and this is not a new install.. a production server which has been working for a few months. is this to do with space issues.. q stat says Accounting: On Activity Log Retention Period: 14 Day(s)

RAW volumes or not

2002-09-21 Thread Arni Snorri Eggertsson
Hiya, I've been reading about using RAW volumes for database and diskpool volumes, my impression is that when running AIX and using JFS the benefits are trivial. However I've seen people talking about 200-300% performance increase when running TSM on Solaris. What I am wondering is if

Re: RAW volumes or not

2002-09-21 Thread Bob Booth - UIUC
I have used both on AIX, and really have never seen a difference either way. I use LVM raw volumes for both, since I find them easier to deal with. TSM mirrors the database/log volumes, and AIX mirrors the storage pool volumes. TSM V5 can utilize AIO for JFS under with AIX, and this is a

Re: RAW volumes or not

2002-09-21 Thread Seay, Paul
There have been recommendations to never use VxFS for TSM Database and Storage Volumes posted on this list that I never quite understood. However, I am suspecting that the issue has to do with setting up VxFS correctly, similar to the file system maxperm issues on AIX. I am not sure how JFS and

Re: q act says *No match found*

2002-09-21 Thread Seay, Paul
I have seen this problem before. When I saw it, it was because we had tape drives getting a lot of fibre channel SCSI errors and causing all kinds of locking apparently. You may want to check to make sure something like that is not happening. Paul D. Seay, Jr. Technical Specialist Naptheon