SV: Not seeing a console screen for the renamed DSMCAD.NLM

2004-06-29 Thread Hougaard.Flemming FHG
Hi Timothy It seems to me you have an error in you DSM.OPT file... do you use the statement "NWWAITONERROR"?? If you do this could be your problem (seen that a lot ;o) )! Regards Flemming -Oprindelig meddelelse- Fra: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] vegne af Timothy Hug

DDS4 drive cleaning problem

2004-06-29 Thread Gottfried Scheckenbach
Hi all, I have: TSM-Server 5.2.2.5 on Win2003 tsmscsi.sys version 5.2.2.5123 DDS4 Autoloader (HP C5713A) regulary checked in cleaning cartridge On "clean drive" I get: ANR8300E I/O error on library LBDDS4 (OP=8401C058, CC=306, KEY=02, ASC=3A, ASCQ=00, SENSE=70.00.02.00.00.00.00.0E.0- 0.00.00.00.3A.

tcpadminport

2004-06-29 Thread Remco Post
Hi all, I just thought I found _the_ solution in preventing admin access to our tsm server from just any system that can connect to port 1500 by setting tcpadminport on our server to something different from tcpport. Well, great now we have 2!!! ports that allow admin connections (tcpport and tcp

Speeding up my SQL statement

2004-06-29 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! I'm using the following SQL statement to retrieve obsolete Oracle backup files: select node_name, filespace_name, ll_name, date(backup_date) from backups where ((days(current_date) - days(backup_date) >= 100)) and hl_name='//' This returns all Oracle backup files, created more than 10

Re: Speeding up my SQL statement

2004-06-29 Thread Lambelet,Rene,VEVEY,GLOBE Center CSC
hi Eric, you could add node_name like '%ORC' to the where clause... best regards, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center SD/ESN Av. Nestlé 55 CH-1800 Veve

Re: SV: Not seeing a console screen for the renamed DSMCAD.NLM

2004-06-29 Thread Timothy Hughes
Hi Hougaard, We added the statement (nwexitnlmprompt no) yesterday it did not make a difference. I believe the (nwexitnlmprompt option) replaced the nwwaitonerror "Hougaard.Flemming FHG" wrote: > Hi Timothy > > It seems to me you have an error in you DSM.OPT file... do you use the statement >

Re: Speeding up my SQL statement

2004-06-29 Thread Loon, E.J. van - SPLXM
Hi Rene! I thought about that, but would that help? If TSM still has to scan every object for a match, it wouldn't help much... That's the problem, I don't know how SQL works... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Lambelet,Rene,VEVEY,GLOBE Cent

Re: Speeding up my SQL statement

2004-06-29 Thread Richard Sims
>I thought about that, but would that help? If TSM still has to scan every >object for a match, it wouldn't help much... That's the problem, I don't know >how SQL works... Eric - Your perception is correct: if you scan a table, it will traverse the whole thing. Whereas the Backups table is

Advice needed - different backup's from same node ?

2004-06-29 Thread Brian Ipsen
Hi, I need an advice on how to handle backup from a specific node... On weekdays, the backup should run "normally", but ignore specific file-types, e.g. .pst The .pst files should be backup during the weekend instead... Is this possible without installing 2 instances of the scheduler - or do I

Re: Speeding up my SQL statement

2004-06-29 Thread Loon, E.J. van - SPLXM
Hi Richard! > Sometimes, the best thing to do is perform Query Backup from the client side, where dedicated logic gets results faster. It is often possible to accomplish that by masquerading as each defined TSM node, via VIRTUALNodename. True, but since the Oracle backups are made through the TDP

File location

2004-06-29 Thread Joni Moyer
Hello! If the options file for the tsm server is located at /usr/tivoli/tsm/server/bin, then where would be the recommended location for the device configuration and volume history file? The database and recovery log will be located at /tsmdev/log/** and /tsmdev/db/** and the storage pools will b

raw partitions

2004-06-29 Thread Joni Moyer
Hello all! I was reading the performance tuning guide and it states that we should use raw partitions for server db, log and disk storage pool volumes for an AIX server and I was just wondering if this is true and what the benefits are of configuring volumes in this manner? As I understand it, if

Re: File location

2004-06-29 Thread Lloyd Dieter
Joni, There probably isn't a "correct" location. If using filesystems, I usually put my primary db copy under "/tsmdbpri", with the mirror copy under "/tsmdbmir", and the recovery log under "/tsmlogpri" and "/tsmlogmir" respectively. I also have customers that stick them under "/usr/tivoli/tsm/s

Re: File location

2004-06-29 Thread Richard van Denzel
Joni, Perferably you want to store de devconfig en volhist on multiple locations, so you can put multiple stanzas in dsmserv.opt (one for de deafult location and one for e.g. /tsmdev/db). Also you don't want to have the TSM DB and TSM LOG on the same set of disks. Put the log on a seperate set of

Re: Speeding up my SQL statement

2004-06-29 Thread Prather, Wanda
Hi Guys, The SQL tables we have to play with in TSM are indeed indexed. If you do select * from syscat.columns, you will see there is a field called INDEX-KEYSEQ and INDEX-ORDER. The BACKUPS table is indexed on NODE_NAME, then FILESPACE_NAME, then FILESPACE-ID, then STATE, in that order. Speakin

Scheduled restore not working

2004-06-29 Thread Troy Frank
I've got a schedule that backups up certain "ServerA" directories at noon. Another schedule is supposed to then restore those directories to "ServerB" at 1PM. The restore seems to be going to ServerA , instead of ServerB. Server A & B are both Netware6. However, serverA is Traditional Volumes,

Re: DDS4 drive cleaning problem

2004-06-29 Thread Joe Crnjanski
We had before IBM dds4 6 tape autoloader. I remember the biggest challenge is to tell TSM that one of the tapes is cleaning tape. Are you sure when you checked in cleaner that TSM knows it is cleaning tape. If you issue "q libv" under status column for cleaning tape you should see "Cleaner" Maybe

Summary database not containing all information

2004-06-29 Thread Cain, Jason (Corporate)
I have the Activity for Summary Retention period set to 30 days, however when I run an archive or backup the information does not show up. It does however, show up sometimes. Is there something I must run to update the summary table? Also, what kind of extra space or overhead is needed to kee

From An ATL7100 to a P3000

2004-06-29 Thread Argeropoulos, Bonnie
Hello, We are planning on changing our tape library from an ATL7100 to a P3000 and from four DLT7000 tape drives to six DLT8000 tape drives on an F50 running AIX 4.3.3 and TSM 5.1.62. We are currently looking at putting our process for this change together and have found we have a few questions.

Remove

2004-06-29 Thread De La Uz, Jose
Please remove me from the list. Thanks! Jose E. de la Uz LAN/Mac Administrator Jackson National Life Insurance Denver Office 303.846.3813 [EMAIL PROTECTED]

Re: From An ATL7100 to a P3000

2004-06-29 Thread Bos, Karel
Hi, The database will still know the tapes (and the content of the tapes). But you will have to do a checkin libv stat=scratch before doing checkin libv stat=priv. ITSM will let you checkin empty volumes as private, but will not accept private tapes being checked in as scratch. Regards, Karel

Re: Summary database not containing all information

2004-06-29 Thread Prather, Wanda
Jason, What level is your server and what level are your clients? There was a bug that caused TSM V4 clients to not update the summary table, or always record as 0 bytes. Is it possible that your "sometimes" data is coming from later level clients, and your "missing" information is from older cli

Re: File location

2004-06-29 Thread Remco Post
On Tue, 29 Jun 2004 09:13:18 -0400 Joni Moyer <[EMAIL PROTECTED]> wrote: > Hello! > > If the options file for the tsm server is located at > /usr/tivoli/tsm/server/bin, then where would be the recommended > location for the device configuration and volume history file? The > database and recovery

Re: Scheduled restore not working

2004-06-29 Thread Stapleton, Mark
NetWare is notorious for not allowing files backed up with NSS or compressed volumes to restore to volumes that are otherwise. Try running the process manually and see what happens, and also take a look at the schedule log dsmsched.log. -- Mark Stapleton >-Original Message- >From: ADSM:

Backup copygroups

2004-06-29 Thread Moses Show
Hi people, I have a burning question which hopefully somebody can provide an answer to. Have been asked to backup SQL servers daily using TSM . The details and instructions for how these backups are performed and any characteristics are contained in the respective management class of the po

Re: Summary database not containing all information

2004-06-29 Thread Cain, Jason (Corporate)
Verson 5.2.0.1, and most of our clients are at that level also. Do you know what kind of degragation would be caused to set the summary info to around a year. I don't know how much DB overhead is involved. Jason -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTE

about db2 online restore

2004-06-29 Thread jianyu he
Hi, Need your help! When I restored the database online, I got the following information. db2 => rollforward database hjy218 to end of logs and stop SQL0956C Not enough storage is available in the database heap to process the statement. SQLSTATE=57011 So, my database hjy218 always is rollforwa

Re: DDS4 drive cleaning problem

2004-06-29 Thread Gottfried Scheckenbach
Thanks Joe! > If you issue "q libv" under status column for cleaning tape you should > see "Cleaner" Yes, the tape status is "cleaner"... I checked it in with "checkin libvol lbdds4 clean stat=clean checklabel=no cleanings=50". Ok, I'll get the tape checked tomorrow by someone who is onsite... Rega

Re: Backup copygroups

2004-06-29 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Moses Show >Have been asked to backup SQL servers daily using TSM . The >details and instructions for how these backups are performed and any >characteristics are contained in the respective management class of the >policy set in

Re: Backup copygroups

2004-06-29 Thread Del Hoobler
Mark, Data Protection for SQL does not support ARCHIVE. It only supports BACKUP. You can use a second NODENAME like you suggested or... you can also look into using SET type backups which get a unique name and can be bound to a separate management class. Thanks, Del ---

Re: From An ATL7100 to a P3000

2004-06-29 Thread Argeropoulos, Bonnie
Hello, I don't understand...why would I want to check the tapes in as scratch if they already have data on them...why wouldn't I just physcially move them and then run an audit library. At first you say to checkin my data tapes as scratch, but then you say that private tapes cannot be checked in

Re: Strange LTO2 behaviour on Linux

2004-06-29 Thread Ben Bullock
Hmmm I'll hazard a guess...Seeing tapes fill up before they should typically has to do with the way the drive is defined. We had similar problems on an initial installation. I don't have an LTO library at this site to compare, but I believe we had to set the read and write formats to "U

Re: raw partitions

2004-06-29 Thread asr
==> In article <[EMAIL PROTECTED]>, Joni Moyer <[EMAIL PROTECTED]> writes: > Hello all! > I was reading the performance tuning guide and it states that we should use > raw partitions for server db, log and disk storage pool volumes for an AIX > server and I was just wondering if this is true and

automation for drive cleaning

2004-06-29 Thread Luc Beaudoin
Hi everybody I have TSM 5.2.0.2 server on win2k. I have a IBM library 3583-R72 with 6 drives . Is there a easy way to schedule a job to let say clean all drives every 2 weeks or Thanks Luc Beaudoin Network Administrator/SAN/TSM Hopital General Juif S.M.B.D. Tel: (514) 340-8222 ext:8254

Re: automation for drive cleaning

2004-06-29 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin >I have TSM 5.2.0.2 server on win2k. >I have a IBM library 3583-R72 with 6 drives . > >Is there a easy way to schedule a job to let say clean all >drives every 2 >weeks or 3583 libraries are designed to be se

Re: automation for drive cleaning

2004-06-29 Thread Coats, Jack
sure, put a schedued administrative commands in for each drive whenever you want. the command is clean drive LIBRARY TAPEDRIVE0 Make sure and do them so there is enough time between commands for the drive to clean. Or put them in a command script with a wait (or 10 minutes of expiration

TSM CLUSTER?

2004-06-29 Thread Tae Kim
Hi guys I was wondering if any of you are clustering your tsm servers. Other HA solution you guys using other than HACMP in AIX?

Re: Scheduled restore not working

2004-06-29 Thread Troy Frank
Yeah, I've run into that before. It's actually not really netware's fault. They have a switch in the SMS modules so that backup software can tell SMS to force an uncompress of files before they get backed up. That way, the files can get restored anywhere. Arcserve, for instance, supports this.

Re: From An ATL7100 to a P3000

2004-06-29 Thread Bos, Karel
Hi, If you delete a library all volumes are deleted from the inventory (no library=no inventory). If you define your new library, this will be an empty one (new library=no inventory). Audit library will not checkin volumes, it will only remove missing volumes from the library inventory. Now yo

LTO estimated capacity drops

2004-06-29 Thread Gordon Woodward
Just analysing our TSM install today as tapes have been getting chewed up quicker then normal, despite no confuration changes being made at server or client side. We have client-side compression turned on (hardware off) and we were getting about 140-180Gb of data on each tape before they being m