Removal of archives

2009-12-21 Thread Geert De Pecker
Hi, We are having problems to remove old archives: On a weekly basis, we are running a script as below: "select node_name, description as \"Archive Description\" ,count(*) as \"#Files\" from archives group by node_name,description" This should give us all archives that are kept by TSM. This list

Visualizing RMAN backups through TDP for Oracle

2009-12-21 Thread Mario Behring
Hi list, How do I check if a RMAN backup operation was successful and the data copied at the TSM Server or TDP for Oracle agent? The TDP is running ok and the backup session occurred without errors. Thanks Mario

Re: Removal of archives

2009-12-21 Thread Richard Sims
There is no inconsistency in the data between the TSM server and client, in that the client maintains no information about archived files: all information is in the TSM server database. The common reasons for not seeing files from the client are that the files belong to a different node or user

Re: TSM 5.3.4 Policy problem

2009-12-21 Thread Richard Sims
On Dec 20, 2009, at 8:46 PM, William ZHANG wrote: > Hi All, > Thanks for your help. > > Do anyone know if I change the setting of TSM , how can I restore my setting > back to before change? You would change your settings back in the same way that you altered them. Be aware when you reduce retent

Re: Visualizing RMAN backups through TDP for Oracle

2009-12-21 Thread Grigori Solonovitch
Try: Select A.node_name, A.filespace_name, A.ll_name as File_Name, A.backup_date, A.state, A.class_name, A.object_id \ from backups A, nodes B \ where A.node_name = '' and A.filespace_name like '' and A.node_name = B.node_name and B.platform_name like 'TDP Oracle%' \ order by A.backup_date Grig

Re: TSM 6.1.2.0 watch-for - EVENTS.SQL table/admin/select problems

2009-12-21 Thread Stephan Boldt
Hello, I had exactly the same problem since upgrading to 6.1.2.1. Today, I upgraded to 6.1.3.0 but it the problem still persisted. Following Jörg's hints I also "reactivated" report creation successfully. Thanks to Jörg for sharing your expirience! That's definitly an annoying bug in TSM... kind

6.1.3 Client and Server now available

2009-12-21 Thread Zoltan Forray/AC/VCU
I guess this is a Merry Christmas present from IBM. Lots of bugs addressed, including a buffer overrun/security issue in the client/CAD.Includes a lot of my favorite problems ;--) Here is the readme for the client http://www-01.ibm.com/support/docview.wss?rs=663&tc=SSGSG7&uid=swg21403384 we

Re: TSM 5.3.4 Policy problem

2009-12-21 Thread William ZHANG
Hi All, The problem has been solved. Many thanks to all of you! Merry Christmas! William -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: Monday, December 21, 2009 8:32 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM 5.3