Re: TSM Operational Reporting - Custom Summary Report

2004-05-04 Thread Mike Bantz
I believe that the GB backed up only references clients, not the backup stgpool command. In that case, you could assume that whatever storage size your stgpool is, your copy pool will be same (unless there were any errors in executing an admin command schedule, which would also show in that report

TSM DB growing, but number of files remains the same ...

2004-05-04 Thread PAC Brion Arnaud
Hi *SM'ers, I'm facing a strange problem, in that my DB began to grow at an abnormal rate, a couple of weeks ago. I tried to find out the reason why, and build a query based on the occupancy table, which was counting the number of files found for all existing storage pools. Problem is that I

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Richard Sims
I'm facing a strange problem, in that my DB began to grow at an abnormal rate, a couple of weeks ago. I tried to find out the reason why ... As we keep advising List members: Run regular TSM accounting reports and review the results, both for quick detection of runaway clients and for long term

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread PAC Brion Arnaud
Richard, As a relatively experienced ADSM/TSM user, I entirely agree with what you said, but, as told in my mail, I doubt that any of my client has begun sending more files than usually, because following query select sum(num_files) from occupancy returns a relatively constant value. From my

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread John Naylor
Arnaud, Have you queried the activity log over the last week As your database is increasing so raoidly the client session stats should show clients with large numbers of objects backed up PAC Brion Arnaud [EMAIL PROTECTED] alpina.com

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Lawrence Clark
has someone increased the number of days that activity is retained in the db? [EMAIL PROTECTED] 05/04/2004 9:04:27 AM Arnaud, Have you queried the activity log over the last week As your database is increasing so raoidly the client session stats should show clients with large numbers of objects

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Hart, Charles
Depending on the server version (4.2.x) there was an issue where Win2k System objects were not expiring based on the retention policies. Try and run cleanup backupgroups Keep an eye as it can run the log up rather quickly. Once this process completed for us we saw or 120GB DB go from 80% to

Re: ANR1163W. Bug?!

2004-05-04 Thread Yury Us
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Sent: Monday, May 03, 2004 6:02 PM To: [EMAIL PROTECTED] Subject: Re: ANR1163W. Bug?! On Tuesday, May 4, 2004, at 06:58 Australia/Sydney, Yury Us wrote: Hi ALL, I have found bunch strange messages recently in

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Coats, Jack
is that run with TSM up or down? Up I assume. -Original Message- From: Hart, Charles [SMTP:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 8:19 AM To: [EMAIL PROTECTED] Subject: Re: TSM DB growing, but number of files remains the same ... Depending on the server version

Re: ANR1163W. Bug?!

2004-05-04 Thread Yury Us
Actually q cont gives me a bunch of files from different nodes. I checked few filesystems, they have been removed a while ago. I assuming that all files like that, but it would be more reliable to be sure about it. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Richard Sims
As a relatively experienced ADSM/TSM user, I entirely agree with what you said, but, as told in my mail, I doubt that any of my client has begun sending more files than usually, because following query select sum(num_files) from occupancy returns a relatively constant value. From my perception, if

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread PAC Brion Arnaud
John : nope, I hoped to find another way doing it, something easier, but I'll be olbliged to follow your advice ! Lawrence : I thought to that one too, but it's not the case ... Charles : As we're actually running a 5.2 version, this should not be a problem : even when we where with 4.2, I never

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread PAC Brion Arnaud
Richard, Many thanks for that clarification, I really appreciate ! I believe what I have to do now is to build some solid queries to explore our activity log... Fortunately it has a retention of 30 days, what should allow me to find out where it began to hurt. Wish me good luck, I'll keep you

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Jolliff, Dale
Speaking of the accounting log, what version and patch level actually came out with corrections for problems that were introduced in the 4.x versions? I don't even remember now what version it was that broke. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread goran
oh ! please dont come in situation to see any light at the end of the tunnel :-) - Original Message - From: PAC Brion Arnaud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:54 PM Subject: Re: TSM DB growing, but number of files remains the same ... Richard, Many

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread John Naylor
Lawrence Clark wrote has someone increased the number of days that activity is retained in the db? This is a user controlled value SET ACTLOGRETENTION ** The information in this E-Mail is confidential and may be legally

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Ted Byrne
Arnaud, I believe what I have to do now is to build some solid queries to explore our activity log... Unless I'm mistaken, I believe that you may have misread Richard's advice. (Correct me if I'm wrong, Richard.) His recommendation: I stress accounting log reporting because it is the very best,

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Hart, Charles
While its up and running... just keep an eye on the log... Couldn't hurt to run. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Coats, Jack Sent: Tuesday, May 04, 2004 8:29 AM To: [EMAIL PROTECTED] Subject: Re: TSM DB growing, but number of files

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Hart, Charles
We upgraded from 4.1.c to 5.1 and did not go through the 4.2 Release with that bug, but ran it anyway and it cleaned up Millions and Millions of SysObj... Worth a try. Once you start the process you can watch it to see if it does delete obj... -Original Message- From: ADSM: Dist

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Mr. Lindsay Morris
I heartily agree with Richard's note about using the ACCOUNTING (not the activity) log. We tried several things with Servergraph, and found that: -- activity log messages are sometimes erroneous -- summary table data is sometimes unreliable -- frequent queries against these tables can

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread PAC Brion Arnaud
Ted, Now I realise you where certainly right ! Unfortunately I disabled accounting some times ago, as it leaded us to server crash, because /usr was full. At that time I did not knew how to direct it anywhere else as it's standard path, and afterwards forgot to reactivate it : like allways higher

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Ted Byrne
Arnaud, You could always make the accounting log file a softlink to a more forgiving location... It probably would also make sense to do some kind of regular log rotation with the file. Ted At 10:39 AM 5/4/2004, you wrote: Ted, Now I realise you where certainly right ! Unfortunately I disabled

What ever happened to Group Collocation ?

2004-05-04 Thread Zoltan Forray/AC/VCU
Any one have any idea on what the target is for this much needed feature ? I thought it was originally targeted for 5.2.2 (unless I missed it somewhere !). I have 125 tapes with less than 10% used, due to collocation and a bunch of small nodes and I really need to reduce that number !

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread PAC Brion Arnaud
Charles, No chance that time : 05/04/04 16:55:56 ANR0847I CLEANUP BACKUPGROUPS evaluated 7233 groups, and deleted 0 orphan groups with 0 members deleted. (SESSION: 645615) Thanks anyway ! Arnaud

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ted Byrne You could always make the accounting log file a softlink to a more forgiving location... It probably would also make sense to do some kind of regular log rotation with the file. Once a month, run cd

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread PAC Brion Arnaud
Mark : thanks for the tip, I'll give it a try ! Ted : as per TSM help : The environment variable, DSMSERV_ACCOUNTING_DIR, specifies the directory where the accounting file is located. Now I know this, but as said before, forgot to reactivate accounting ... Arnaud

Re: problem with tdp oracle 5.2 with oracle RMAN 9.2.0.4

2004-05-04 Thread AMHOUCHE Youssef
I've always the same problem: The libobk.a link is well; LIBPATH and LD_LIBRARY_PATH include first the $ORACLE_HOME/lib directory. but the sbttest command give the following errors [EMAIL PROTECTED]:/ sbttest a -libname /usr/tivoli/tsm/client/oracle/bin64/libobk64.a

Re: TSM DB growing, but number of files remains the same ...

2004-05-04 Thread Andrew Raibeck
Hi Arnaud, You can also take a look at the SUMMARY table, which contains a lot of the same information that appears in the account log. Something like this might prove to be a useful starting point: select entity as NODE, date(end_time) as DATE, activity, sum(examined) as

Re: AW: about snapshot

2004-05-04 Thread jianyu he
Hi, Chris I used the method that you told me, but it still has this problem, do you have another method? thanks Andy Christian Wadl [EMAIL PROTECTED] wrote: Hello, Ignore it. The Error tells you that TSM tries to do an snapshot based backup, but cant handle it, so it does a normal backup, as

Re: problem with tdp oracle 5.2 with oracle RMAN 9.2.0.4

2004-05-04 Thread Neil Rasmussen
The 2507 is a return code number that we give back to Oracle which in turn reports it as bsercerrno=2507. You will find that 2507 is: TDP_ORC_LOWER_APIVER ANU2507E Runtime API version is outdated Runtime API is lower than compile time API. Check compile time API level, obtain same or higher

Re: What ever happened to Group Collocation ?

2004-05-04 Thread Joerg Pohlmann
Zoltan, why not set up a SMALL_SERVERS policy domain which has MC definitions the same as your normal server PD with one difference - send the data to a different hierarchy where the tape storage pool is not collocated. The client nodes that are candidates for this PD are nodes that have small

SAP DB Incremental backups.... anyone..... buller?

2004-05-04 Thread Greg
Hi All, We currently have a large 2.6TB (ever growing) SAP database that we perform a full hot archive on each day. The primary DB server sync's a BCV mount, and then we backup the mirror directly on the TSM server. The TSM server is an IBM H80 running AIX 5.1.0.5, TSM Server 5.2.2.0, and connects

about snapshot

2004-05-04 Thread jianyu he
Hi, I tryed to use snapshot image backup my D$, and I have enough storage pool in the TSM server, but I failed when I used this function. it said Server out of data storage space. I don't know why, could you tell me how I can do? Thanks Andy C:\Program Files\Tivoli\TSM\baclientdsmc backup

New Mac Client, dual problems?

2004-05-04 Thread Gretchen L. Thiele
A new Mac client, v5.2.2.10, was just released. Has anyone been able to run the Mac client successfully on a dual G4 or dual G5? OS is 10.3.x. I know one of the duals is an XServe, not sure about any of the others that are having problems. Gretchen Thiele Princeton University

Re: New Mac Client, dual problems?

2004-05-04 Thread Jonathan Siegle
The only big problem I have had with the Mac client was when the Arial font was not installed. This fix solves that problem(IC40043). I have not had a problem running 5.2.2.0 on OSX 10.3.x with a Dual G4 pmac when the Arial font is installed. -Jonathan On Tue, 4 May 2004, Gretchen L. Thiele

Re: What ever happened to Group Collocation ?

2004-05-04 Thread Zoltan Forray/AC/VCU
I have already thought of this idea. I was hoping for GROUP COLLOCATION. The problem with this idea/design is I have to essential duplicate *EVERYTHING*, such as admin processes, operator training, etc. Also, this means I have to set aside disk storage (which is very limited on my zOS system) to

Re: What ever happened to Group Collocation ?

2004-05-04 Thread Rushforth, Tim
If you want to use less tapes, set maxscratch to a smaller value for your storage pool. If you have more nodes than tapes then they will share tapes. -Original Message- From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED] Sent: May 4, 2004 9:54 AM To: [EMAIL PROTECTED] Subject: What ever

Re: What ever happened to Group Collocation ?

2004-05-04 Thread Ted Byrne
One confusion is why do I have so many partially filled tapes ? I don't have this many nodes ? You might want to do some queries against the volumeusage table. That data can be massaged to see what tapes are being used. You could also use q content volume_name count=1 against all of the

AIX question (off topic possibly)

2004-05-04 Thread Gill, Geoffrey L.
Hi all, This may be a little off topic as it relates to TSM specifically but I do have a reason for asking. I'd like to see how the TSM server is running during different periods of processing. With that said.. I was wondering if anyone has a favorite GUI tool that can be run locally or

Re: AIX question (off topic possibly)

2004-05-04 Thread CORP Rick Willmore
snmp customization and mrtg ? R. -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 1:30 PM To: [EMAIL PROTECTED] Subject: AIX question (off topic possibly) Hi all, This may be a little off topic as it relates to TSM specifically but I do

Re: AIX question (off topic possibly)

2004-05-04 Thread Tom Kauffman
Big Brother with the larrd add-in works nicely. See http://bb4.com/ Or contact me directly . . . Tom Kauffman NIBCO, Inc -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:30 PM To: [EMAIL PROTECTED] Subject: AIX question (off topic

Re: What ever happened to Group Collocation ?

2004-05-04 Thread Andrew Raibeck
Zoltan, I don't know what you were specifically told about the new feature, but keep in mind that any such disclosures are usually with the caveats subject to change. :-) To the best of my knowledge this is currently targeted for our next major release this fall. (Caveat: This statement does

Re: What ever happened to Group Collocation ?

2004-05-04 Thread Joerg Pohlmann
The most likely reason for multiple filling tapes for the same node is that a filling tape is in use by reclamation or storage pool backup and migration is starting to run. Migration then cannot add to the filling tape for the node and instead gets itself a new scratch tape. You now have two

Re: What ever happened to Group Collocation ?

2004-05-04 Thread Richard Sims
... One confusion is why do I have so many partially filled tapes ? I don't have this many nodes ? Zoltan, Andy's observations were excellent, as always. I can only add a suggestion to check subject Shrinking (dwindling) number of available scratch tapes in ADSM QuickFacts, where I

Win2K SystemObjects and Backup Group Copy Frequency

2004-05-04 Thread Scott McCambly
Hello there, Has anyone had any experience trying to limit the number of backups of the system state objects in Win2K? I thought the obvious choice was to use the new include.systemobject ALL mgmtclass option and set the backup copygroup in the specified management class to have a non-zero copy