select events table

2006-11-07 Thread goc
hi, when i make select * from events i get data only for current date , i know with q event you can get back as defined in server options but i would like to make some count(*) and stuff on events data, so my question is can i get further in past with direct select statement to events table ?

TSM 5.3 - A part of Domain

2006-11-07 Thread Pranav Parikh
Hi, Please respond below query. We executes backup through Tivoli Storage Manager V5.3 (Windows based). We are planning to re-join existing TSM server to a new domain. We would like to know: What impact will it have if the existing TSM server rejoins another domain (in separate forest) Will it

Re: select events table

2006-11-07 Thread Rainer Tammer
Hello, goc wrote: hi, when i make select * from events i get data only for current date , i know with q event you can get back as defined in server options but i would like to make some count(*) and stuff on events data, so my question is can i get further in past with direct select

Re: TSM 5.3 - A part of Domain

2006-11-07 Thread Henrik Wahlstedt
Hi, TSM does not really care about Windows domains. (Dont change your DNS- or IP-address on your TSM server, if you change, remember to change TcpServerAddress in dsm.opt on the clients) //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of

Re: select events table

2006-11-07 Thread Matthew Warren
Odd, how can it be that select * from events returns different to select * from events where scheduled_start'1900-01-01' How is the table 'special'? Matt. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rainer Tammer Sent: 07 November 2006

Default management class

2006-11-07 Thread Smith, I (Ian)
I have a Windows host that was moved between domains. It is still trying to backup a directory into an old management class. There is no statement in the option file or in any global option set. The problem is the files in the directory are going to the new default management class- 37 days and

Re: select events table

2006-11-07 Thread Henrik Wahlstedt
Nope, see the explanation in 'Why does it Work that Way (Andy Raibeck).pdf' from TSM Symposoium in Oxford 2005. Events table is calculated at runtime... etc Cheers Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Warren Sent: den 7

Major NAS NDMP Backup issues: please help if you can...

2006-11-07 Thread Joni Moyer
Hi Everyone, I am having major issues trying to backup my NAS filesystems. I seem to be getting a lot of the messages below. I am trying to use NDMP backups with my EMC NS704G. I am still trying to find what this exact issue is, but was wondering if anyone has ever seen this before? Any help

Re: select events table

2006-11-07 Thread Matthew Warren
Ahh, I see. I knew that TSM tables were built 'on the fly'; but had't realised that the events table is essentially unbounded, hence the need for the 'special' behaviour. Thanks, Matt. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik

select statement for All active files for a node

2006-11-07 Thread Fawad Baig
Hi I need a select statement to calculate total GB for all the ACTIVE files backed up for a node. any thoughts anyone? -- Regards, Fawad Baig

Repost-3 Copypool tapes with no data-Want to use them as scratch

2006-11-07 Thread Rao, Kamran
Hello, TSM 5.1.6.2 running on AIX 5.1 ML04 I have 3 LTO2 volumes, which belong to a copypool and they currently are in vault state. Pct Util on 2 of the volumes is 0 and 1 of them is 0.1. When I query contents on any of these 3 volumes I don't get anything on them. I would like to use these

Re: select statement for All active files for a node

2006-11-07 Thread Matthew Warren
I'm not sure if you can do this with a select. One thing you could try would be an export node, with filedata=ALLActive and preview=yes. Matt. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Fawad Baig Sent: 07 November 2006 15:09 To:

I need small help :)

2006-11-07 Thread Ahmed Al-Saidi
TDP for Oracle backup does not show up when query backup is run. The backup is successful and the files can be seen when query occupancy is run. What command can we use from the client to see what files are backed up?

Re: Repost-3 Copypool tapes with no data-Want to use them as scratch

2006-11-07 Thread Andrew Carlson
Try auditing the volumes. If they are offsite, you will have to make them readonly or readwrite. We have had volumes like these before - it doesn't even mount the tape, it just fixes something in the database. On 11/7/06, Rao, Kamran [EMAIL PROTECTED] wrote: Hello, TSM 5.1.6.2 running on

How can we verify which management class is being used?

2006-11-07 Thread Ahmed Al-Saidi
Hello, The dirmc option is specified in the options file, but query backup shows that the default management class is bing used instead. How can we verify which management class is being used? Ahmed Al Saidi

msg ANR4502W - TSM server 5.3.4.4 on AIX

2006-11-07 Thread Rainer Holzinger
Hello all, within our first TSM 5.3 server is running on level 5.3.3.4 under AIX. ISC is at level 6.0.1 and AC is 5.3.3.0 on Windows. Whenever there's a need to modify the volume history (STGNEW, STGDEL, TSM server database backup) I'm receiving the TSM server warning message.

Reclamation and large files

2006-11-07 Thread Hans Christian Riksheim
Hi, I am trying to understand what TSM does with reclamation of large files. We have a filepool of 10G-volumes and I see the TSM-server moving a 64G file during reclamation. This file is from an Exchange-backup. It seems to me that TSM moves the whole file to other volumes and not just the

Re: Reclamation and large files

2006-11-07 Thread Thomas Denier
- Hans Christian Riksheim wrote: - I am trying to understand what TSM does with reclamation of large files. We have a filepool of 10G-volumes and I see the TSM-server moving a 64G file during reclamation. This file is from an Exchange-backup. It seems to me that TSM moves the whole file

Domain ALL-LOCAL client option set

2006-11-07 Thread L'Huillier, Denis (GTI)
When using ALL-LOCAL in the domain statement of a client option set it doesn't seem to work. When I issue dsmc q opt from the client the domain states ALL-LOCAL instead of the translated local filesystems. The system is AIX. The local dsm.opt file contains DOMAIN / to back up the root

remove me from your mailing list

2006-11-07 Thread Frank Natterer
Please remove me from your mailing list.

Re: Domain ALL-LOCAL client option set

2006-11-07 Thread Richard Sims
On Nov 7, 2006, at 12:35 PM, L'Huillier, Denis (GTI) wrote: When using ALL-LOCAL in the domain statement of a client option set it doesn't seem to work. Referring to topic Using options with commands in the client manual, what value did you use for the Force operand of DEFine CLIENTOpt?

Fwd: Domain ALL-LOCAL client option set

2006-11-07 Thread Richard Sims
My error... Cancel that - additive options are not affected by the Force parameter. Begin forwarded message: From: Richard Sims [EMAIL PROTECTED] Date: November 7, 2006 1:56:10 PM EST To: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Subject: Re: Domain ALL-LOCAL client option set On Nov 7,

Re: Domain ALL-LOCAL client option set

2006-11-07 Thread L'Huillier, Denis (GTI)
I found my problem.. Looks like it's a problem with my TSM client level.. http://www-1.ibm.com/support/docview.wss?rs=1019context=SSSQWCcontext= SSGSG7q1=domainq2=ALL-LOCALq3=option+setq4=IC43694uid=swg1IC43694l oc=en_UScs=utf-8lang=en -Original Message- From: ADSM: Dist Stor Manager

Checking in new tapes on new TSM tape library

2006-11-07 Thread Paul Dudley
I am trying to check in a new LTO3 tape in our new IBM 3582 TSM tape library that was installed a month ago. However it keeps failing. I would like to know if I am doing it correctly before logging a fault call with IBM. I am placing the new tape with the barcode label on it, in the IO slot on

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread Lepre, James
Try the checkin command with search=bulk I think that is it - Original Message - From: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU ADSM-L@VM.MARIST.EDU Sent: Tue Nov 07 21:39:34 2006 Subject: [ADSM-L] Checking in new tapes on new TSM tape library I am trying to

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread Paul Dudley
OK - I tried the command label libvol lb1.1.0.3 checkin=scratch search=bulk labels=barcode and got the errors: 11/08/2006 13:54:24 ANR0984I Process 594 for LABEL LIBVOLUME started in the BACKGROUND at 13:54:24. (SESSION: 7295, PROCESS: 594) 11/08/2006

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread David Longo
Maybe this is a silly question, but have you placed the tape in the I/O slot correctly? With the barcode facing in? David Longo Paul Dudley [EMAIL PROTECTED] 11/07/06 9:59 PM OK - I tried the command label libvol lb1.1.0.3 checkin=scratch search=bulk labels=barcode and got the errors:

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread Paul Dudley
It may not be a silly question as this is the first time I have tried to load a new tape in the new 3582 unit. We have an older 3582 unit that uses LTO2 tapes. For that unit I check in tapes using the IO slot on the right side of the unit, loading the tape with the barcode facing out (towards the

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread Bob Booth
On Wed, Nov 08, 2006 at 01:59:34PM +1100, Paul Dudley wrote: OK - I tried the command label libvol lb1.1.0.3 checkin=scratch search=bulk labels=barcode and got the errors: Check to see if the I/O slot is configured as a 'storage slot' in the library. 11/08/2006 13:54:24 ANR8826E No

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread Wira Chinwong
Make sure that the barcode on new tape in IO slot is read correctly. May perform confirmation via tape console. Wira. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dudley Sent: Wednesday, November 08, 2006 10:21 AM To: ADSM-L@VM.MARIST.EDU

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread Sujay Dinakar R.
Check whethe the IO slot is confiureeged coreectly, as the error message says, it cant move the tape from 4112 to 257, the IO and library is not able to see the 4112 slot correctly. 11/08/2006 13:28:10 ANR8942E Could not move volume 818ACFL2 from slot-element 4112 to slot-element 257.

Re: Checking in new tapes on new TSM tape library

2006-11-07 Thread Paul Dudley
Taking a different approach and avoiding the IO slot I have put 5 new tapes into the left cartridge. I then ran the command: label libvol lb1.1.0.3 search=bulk labels=barcode checkin=scratch The same error appeared in the activity log: 11/08/2006 16:06:38 ANR0984I Process 596 for LABEL

Expanding the UNIX filesystem (TSM)

2006-11-07 Thread Gopinathan, Srinath
Hi, I am getting an error stating that The percentage of available space in the file system /apps/tsm/file is low (0.04769113860967792 percent). Hence, we allocated 100GB of space to the Unix server where /apps/tsm/ is located. Now the Unix server team is not able to expand the filesystem as

Re: Expanding the UNIX filesystem (TSM)

2006-11-07 Thread Stephen Mackereth
Hi Srinath, Try chfs -a size=+size increased byG filesystem mount point So something like chfs -a size=+50G /apps/tsm Will increase the /apps/tsm filesystem by 50Gb (if there is enough space in the Volume Group.) Regards, Stephen. -Original Message- From: ADSM: Dist Stor Manager

Re: Expanding the UNIX filesystem (TSM)

2006-11-07 Thread Bob Booth
On Wed, Nov 08, 2006 at 04:41:11PM +1100, Stephen Mackereth wrote: Hi Srinath, Try chfs -a size=+size increased byG filesystem mount point So something like chfs -a size=+50G /apps/tsm Will increase the /apps/tsm filesystem by 50Gb (if there is enough space in the Volume Group.)

Re: Expanding the UNIX filesystem (TSM)

2006-11-07 Thread Stephen Mackereth
Yes OK I should have said that But then again AIX is the REAL UNIX! :) Mmmm AIX -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bob Booth Sent: Wednesday, 8 November 2006 16:45 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Expanding the

Re: Expanding the UNIX filesystem (TSM)

2006-11-07 Thread Gopinathan, Srinath
Bob, Thanks for the update. The OS which is running here is Solaris 5.9 Thanks in advance. Srinath G -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bob Booth Sent: 08 November 2006 05:45 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Expanding

Re: Expanding the UNIX filesystem (TSM)

2006-11-07 Thread Bob Booth
On Wed, Nov 08, 2006 at 06:37:59AM -, Gopinathan, Srinath wrote: Bob, Thanks for the update. The OS which is running here is Solaris 5.9 Well, if it is a VXFS filesystem, you can use the Veritas LVM to extend the FS. You may also be running Soltice which is basically VXFS under the