Re: Getting and using time values with sql

2007-01-31 Thread Steven Harris
Lee, Gary D. wrote: Tsm server 5.2.9.0, running on solaris 2.8. I would like to restrict a tsm script from running between the hours of 4:00 and 9:00 aa.m.. I haven't figured out how to test the value of time in a script, and branch on that test. Any pointers would be helpful. Gary Lee Senior

Antwort: Re: tdp for exchange, clarification needed for expiration of full/incr/copy backups

2007-01-31 Thread TSM
thanks del, so i had misunderstood the behaviour of full/copy backup, i thought it was something like dbbackup/dbsnapshot behaviour. with best regards stefan savoric

Re: tdp for exchange, clarification needed for expiration of full/incr/copy backups

2007-01-31 Thread Del Hoobler
When you take a DP/Exchange "FULL" backup, it will "expire" all previous versions of ALL backups types for that storage group. You should adjust your policy settings to take that into consideration if you want to base it on "number of versions". However.. in looking at what you are trying to do, i

tdp for exchange, clarification needed for expiration of full/incr/copy backups

2007-01-31 Thread TSM
Hello, our environment tsm server 5.2.4.0 tsm client 5.2.2.5 TDP for Exchange 5.2.1.1 Exchange 2003, SP1, OS=w2k we have theese copygroups PolicyPolicyMgmt Copy Versions Versions Retain Retain DomainSet Name Class Group Data DataExtraOnly Name

Re: Getting and using time values with sql

2007-01-31 Thread Colwell, William F.
Gary, I have this sql in a script I am using right now to move the database to new volumes. upd scr add-dbcopy 'select ''ok'' from status where hour(current_time) - 7> 0' upd scr add-dbcopy 'if(rc_notfound) goto do_moves' To do what you want I suggest - upd scr add-dbcopy 'select ''ok'' from s

Re: exporting scripts

2007-01-31 Thread David E Ehresman
I learned about "q script format=macro" either on this list or at Share. I also could not find it documented in the TSM doc so I opened a PMR with TSM support. Matthew Armstrong eventually reported that " The product is considered working as designed and there is essentially nowhere further we can

export node toserver= , slow.. on AIX

2007-01-31 Thread Tom Tann{s
Hi! This is probaly not an itsm-issue, but anyway..: both tsm-servers, 5.3.4, running on the same P650, AIX5.3-box. Shared memory is used (lo0), but performance is useless. (about 140KB/sek on average, 70KB in, 70KB out) This used to work fine on our old S7A, the numbers where usually 100MB/s a

Re: Moving Data

2007-01-31 Thread Bell, Charles (Chip)
Try the 'move node' command which has a 'from' and 'to' parameter for your stgpools. Hope that helps. Run a 'help move node' to get more info. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Kinder Sent: Wednesday, January 31, 2007 1:35 PM To:

Re: Moving Data

2007-01-31 Thread Gilbert, Guillaume
Try move nodedata. Guillaume Gilbert Storage Architect Storage Group, Sun Microsystems [EMAIL PROTECTED] 514.285-8440 Office 514.290.6526 Cell -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Kinder Sent: January 31, 2007 14:35 To: ADSM-L@V

Moving Data

2007-01-31 Thread Kevin Kinder
I'm struggling through a bit of a blind spot. My goal is to move all the data belonging to a node from one active tape storage pool to another. Over time, with deletions and additions, the firs pool has become populated with much more data than the second, and as a result migrations are occurin

Re: TSM Operating Report for Linux

2007-01-31 Thread Skylar Thompson
Christian Svensson wrote: > Hi, > > Does anyone know if Operating Report exists for Linux86? > > Or is there anything similar that is freeware? > > Are you talking about the manager console? If so, then I haven't seen a product. It's a Windows server MMC snap-in, but you can point it at any TSM se

Re: size of each node on TSM

2007-01-31 Thread Thorneycroft, Doug
Q occ and Q AUDITOCCUPANCY (Before you run q auditoccupancy, you should run 'audit license') -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Avy Wong Sent: Wednesday, January 31, 2007 9:30 AM To: ADSM-L@VM.MARIST.EDU Subject: size of each node on TSM

Re: TSM jbb on aix

2007-01-31 Thread Remco Post
On Wed, 2007-01-31 at 09:09 -0500, Allen S. Rout wrote: > >> On Wed, 31 Jan 2007 12:53:01 +0100, Remco Post <[EMAIL PROTECTED]> said: > > > > I've been playing with the Journal based backups on aix. I've > > installed the 5.4 (and before that the 5.3.4) client and tried to > > start the tsmjbbd but

Re: size of each node on TSM

2007-01-31 Thread Robert Ouzen Ouzen
Avy Try q occ ... Regards Robert ouzen -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Wednesday, January 31, 2007 7:30 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] size of each node on TSM Hello, I understand q node f=

AW: [ADSM-L] size of each node on TSM

2007-01-31 Thread Thomas Rupp
Have a look at "Query AUDITOCC". To get a list of all nodes and their data on all primary stgpools use: qu auditocc pooltype=primary To get the number of files see: Q OCC HTH Thomas Rupp -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Avy

size of each node on TSM

2007-01-31 Thread Avy Wong
Hello, I understand q node f=d gives me a bunch of stats of each of the nodes registered on the TSM. But it does not say how much space it takes up on TSM. How do I go about getting the space size each node occupies on TSM? Thanks. Avy Wong Business Continuity Administrator Mohegan Sun 1 Moh

Re: TSM jbb on aix

2007-01-31 Thread Remco Post
On Wed, 2007-01-31 at 07:07 -0700, Andrew Raibeck wrote: > Hi Remco, > > It is possible that this is related to the environment variables, as > Richard suggested. > > > IBM support is unable to reproduce the problem, and thus > > unwilling to help me > > Wow, I am sorry that this is the impression.

Online manuals reminder

2007-01-31 Thread Richard Sims
Just a reminder: The TSM documentation Web area: http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp is set up to display the latest version/release manuals, by default - now, 5.4. (Implicit marketing. ;-) To see the doc appropriate to your "earlier" release, refer to the "Prev

Script to auto-stop reclamation

2007-01-31 Thread Paul Roth
In an attempt to free up tape drives when migration occurs due to primary disk pool filled, I am looking for a script to check if reclamation is running and cancel the process automatically. Does anyone have any ideas (or a script) how to accomplish this easily. Paul Roth

Re: Help! Trying to define a devclass of type: file and it keeps failing

2007-01-31 Thread Joni Moyer
Thanks Richard! I was looking at the manual online and when I went to the hardcopy I found that limitation. Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] ***

Re: Help! Trying to define a devclass of type: file and it keeps failing

2007-01-31 Thread Allen S. Rout
>> On Wed, 31 Jan 2007 08:49:49 -0500, Joni Moyer <[EMAIL PROTECTED]> said: > I guess I had thought that in order to do a database backup to disk > I would need the maxcapacity to be the size of my current database > backup which is actually 122 GB, but I thought I would allow it some > space for

Re: TSM jbb on aix

2007-01-31 Thread Allen S. Rout
>> On Wed, 31 Jan 2007 12:53:01 +0100, Remco Post <[EMAIL PROTECTED]> said: > I've been playing with the Journal based backups on aix. I've > installed the 5.4 (and before that the 5.3.4) client and tried to > start the tsmjbbd but: Be very very careful with JBB. The crash-to-service-processor

Re: Help! Trying to define a devclass of type: file and it keeps failing

2007-01-31 Thread Richard Sims
On Jan 31, 2007, at 8:49 AM, Joni Moyer wrote: Hi Richard, I have looked in the manual and the only thing it references is that the default is 2 G. I do not see a maximum limit for a file device class. I have looked in the Reference Guide and the Admin Guide. I guess I had thought that in or

Re: TSM jbb on aix

2007-01-31 Thread Andrew Raibeck
Hi Remco, It is possible that this is related to the environment variables, as Richard suggested. > IBM support is unable to reproduce the problem, and thus > unwilling to help me Wow, I am sorry that this is the impression. I reviewed your PMR, and it looks like IBM support was trying to reach

Re: Help! Trying to define a devclass of type: file and it keeps failing

2007-01-31 Thread Joni Moyer
Hi Richard, I have looked in the manual and the only thing it references is that the default is 2 G. I do not see a maximum limit for a file device class. I have looked in the Reference Guide and the Admin Guide. I guess I had thought that in order to do a database backup to disk I would need t

Re: Help! Trying to define a devclass of type: file and it keeps failing

2007-01-31 Thread Richard Sims
What does the manual say is the highest allowed value for MAXCAPacity?

Re: Getting and using time values with sql

2007-01-31 Thread Richard Sims
On Jan 31, 2007, at 8:02 AM, Lee, Gary D. wrote: Tsm server 5.2.9.0, running on solaris 2.8. I would like to restrict a tsm script from running between the hours of 4:00 and 9:00 aa.m.. Hello, Gary - One technique is to have a schedule do like: DEFine SCRipt SCRIPT1_DONOTRUN "exit" at 04:

Re: Getting and using time values with sql

2007-01-31 Thread Choudarapu, Ramakrishna (GTI)
Gary, How you are planning to run the script? If it is through an Admin Schedule, the schedule can be controlled based on time... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lee, Gary D. Sent: Wednesday, January 31, 2007 8:03 AM

Help! Trying to define a devclass of type: file and it keeps failing

2007-01-31 Thread Joni Moyer
Hello everyone, I am trying this from an AIX 5.2.7.1 TSM server and I'm not quite sure what I'm doing wrong? I want to define a file devclass that is 150 GB. 01/31/07 08:05:42 ANR2017I Administrator LIDZR8V issued command: DEFINE DEVCLASS DBBFILE DEVTYPE=FILE MOUNTLIMI

Re: TSM jbb on aix

2007-01-31 Thread Richard Sims
On Jan 31, 2007, at 6:53 AM, Remco Post wrote: statx("/usr/lib/nls/loc/uconvTable/ISO8859-1", 0x2FF1DEE0, 76, 0) = 0 access("/en_US/dsmclientV3.cat", 04)Err#2 ENOENT access("/en_US/dsmclientV3.cat", 04)Err#2 ENOENT kioctl(1, 22528, 0x, 0x)= 0 ANS

Getting and using time values with sql

2007-01-31 Thread Lee, Gary D.
Tsm server 5.2.9.0, running on solaris 2.8. I would like to restrict a tsm script from running between the hours of 4:00 and 9:00 aa.m.. I haven't figured out how to test the value of time in a script, and branch on that test. Any pointers would be helpful. Gary Lee Senior System Programmer Ball

TSM jbb on aix

2007-01-31 Thread Remco Post
Hi, I've been playing with the Journal based backups on aix. I've installed the 5.4 (and before that the 5.3.4) client and tried to start the tsmjbbd but: statx("/usr/lib/nls/loc/uconvTable/ISO8859-1", 0x2FF1DEE0, 76, 0) = 0 access("/en_US/dsmclientV3.cat", 04)Err#2 ENOENT access("/e

Re: [SPAM: 12.500] [ADSM-L] Error running Image Backup online

2007-01-31 Thread Robert Ouzen Ouzen
Leigh You made me in the right way the user I used was not an administrator after testing with an administrator the errors vanished Thanks Robert -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Leigh Reed Sent: Wednesday, January 31, 2007 11:

Re: TSM 5.4 cautions

2007-01-31 Thread PAC Brion Arnaud
Rainer, You're definitively right ! Just tested this on a brand new server I've installed, everything works fine ... Just amazing : tried this on another system some weeks ago without success (but the OS was not brand new, and had been upgraded several times : maybe some fileset was slightly diff

Re: TSM 5.4 cautions

2007-01-31 Thread Rainer Tammer
Hello, PAC Brion Arnaud wrote: > Hi Rainer, > > >>> I just installed TSM 5.4 on AIX and ... the old WEB interface is >>> > running > > I'm really curious to know which version of AIX you have : is it the > last one (5.3 TL 05) ? > The test server is running on AIX 5.2 TL09 SP2. > The "transition"

Re: TSM 5.4 cautions

2007-01-31 Thread PAC Brion Arnaud
Hi Rainer, >> I just installed TSM 5.4 on AIX and ... the old WEB interface is running I'm really curious to know which version of AIX you have : is it the last one (5.3 TL 05) ? The "transition" version of web interface was not supposed to run with AIX 5.3 ML > 02 if I remember properly ... If

Re: [SPAM: 12.500] [ADSM-L] Error running Image Backup online

2007-01-31 Thread Leigh Reed
Robert, Do you have any disk quota s/w running on this machine that may restrict the size of a file written to disk? Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Ouzen Sent: 31 January 2007 09:36 To: ADSM-L@VM.MARIST.EDU Subje

Error running Image Backup online

2007-01-31 Thread Robert Ouzen Ouzen
Hi to all When trying to backup with the image feature a windows 2003 client online I got the following error: 01/31/2007 11:20:44 ANS1259E The image snapshot operation failed. Diagnostic text: SnapshotCallback: snapStatus = 1, snapRc = 6. 01/31/2007 11:20:44 ANS1425E The image operation

Re: TSM 5.4 cautions

2007-01-31 Thread Rainer Tammer
Hello, Allen S. Rout wrote: >>> On Mon, 29 Jan 2007 18:15:33 +0100, Remco Post <[EMAIL PROTECTED]> said: >>> > > > >> indeed. In my nim-environment these don't show up in the fileset >> selection, so it took me some time to get them installed. After that, >> everything is fine. I guess there are s

Re: 3592 Path Failover for Dual Ports

2007-01-31 Thread PAC Brion Arnaud
Hi Boris, Datapath failover is possible, on condition having bought the feature with your 3584 library. First of all, check if you got the necessary key to enable the feature (should be written on a sticker on the inside of rear side of your library) Then, to enable datapath failover, in AIX is

Re: 3592 Path Failover for Dual Ports

2007-01-31 Thread Stef Coene
On Wednesday 31 January 2007 08:37, Herrmann, Boris wrote: > Hi everyone, > > we have a complete new TSM evironment: > > -AIX 5.3 > -TSM 5.3.4 > -Library 3584 > -8 x 3592 Tape Drives with Dual Port (recommendend from our Sales > Assistant to handle Failovers of Cables, Ports, ...) > -Atape Driver 1