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 logs

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 ma

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: server1>q 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 10:

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 anyon

Re: q act says *No match found*

2002-09-21 Thread Chetan H. Ravnikar
Ok I bounced the server and things look OK, :) On Sat, 21 Sep 2002, Bob Booth - UIUC wrote: > Date: Sat, 21 Sep 2002 13:04:05 -0500 > From: Bob Booth - UIUC <[EMAIL PROTECTED]> > Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: q act says *No match

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 differ

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 Inc.

Re: q act says *No match found*

2002-09-21 Thread gwichman
Is the TSM db full? Do a q DB.. if the DB fills up I believe no more activity log entries can be entered in the DB. Also keep in mind a simple "q act" only shows activity for the past hour. It's possible nothing happened in the past hour.. try "q act begind=today-1" for the past 24 hours. -Geral