Re: q actlog
use SET ACTLOGRETENTION command [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30.05.2002 09:11 Please respond to ADSM-L To: [EMAIL PROTECTED] cc: Subject: q actlog Simple question: if I do q actlog and give date 14th may it gets me actlog from 20th may so it's keeping only 2 weeks old. Where do I have to look if I need 4 weeks old log - a flat file may be ! can someone help me. WIth regards CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR.
Re: q actlog
Hi, The reason why you get only 2 weeks old act log records, probably, is the retention period defined for activity log is 14 days. So, there are no more records in act log. Try to use SET ACTLOGRETENTION admin command to change it. Take into account that it influences DB size, because act log is actually a DB table. Boris Slutsky E-mail: [EMAIL PROTECTED] -Original Message- From: Ruksana Siddiqui [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 07:06 To: [EMAIL PROTECTED] Subject: q actlog Simple question: if I do q actlog and give date 14th may it gets me actlog from 20th may so it's keeping only 2 weeks old. Where do I have to look if I need 4 weeks old log - a flat file may be ! can someone help me. WIth regards CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR.
Re: TSM monitored by TME
We do not intend to monitor clients with TME. Just Media and Library issues. So we actually want to see all occurences. The default RLS does not compile. We are working on it. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:14 AM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME Nice to have some partners out there But I am talking about the hard way... Rules, man, Rules... Suppose you get a message like a hundred times - connection refusal or something like that. I don't want my operators to get lost in the forest... I am trying to write some. Will share when I'm done. Ran. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:54 PM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME We are in the process of implementing. Should be this week. We are doing message control from the TSM Server point of view by turning on which ones we want to see. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 7:43 AM To: [EMAIL PROTECTED] Subject: TSM monitored by TME Hello TSMers. Does any of you monitor his TSM with TME10 TEC ? I have TSM servers version 4.1, TME version 3.7 I happen to find the ibmtsm.baroc and the ibmtsm.rls files shipped with tsm 4.1 to be quite useless since they contain very few rules. Also they don't match - the rls file is still matched to an old version of baroc file in which every message has it's own class. Does anyone there has a nice set of baroc and rls files that I can use, before I'm doing a mass developement of my own? I'll appreciate it !!! Ran.
Re: q actlog
Boris, Can I grab old actlog from my db backup , if so how - With regards, -Original Message- From: Slutsky, Boris [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 4:31 PM To: [EMAIL PROTECTED] Subject: Re: q actlog Hi, The reason why you get only 2 weeks old act log records, probably, is the retention period defined for activity log is 14 days. So, there are no more records in act log. Try to use SET ACTLOGRETENTION admin command to change it. Take into account that it influences DB size, because act log is actually a DB table. Boris Slutsky E-mail: [EMAIL PROTECTED] -Original Message- From: Ruksana Siddiqui [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 07:06 To: [EMAIL PROTECTED] Subject: q actlog Simple question: if I do q actlog and give date 14th may it gets me actlog from 20th may so it's keeping only 2 weeks old. Where do I have to look if I need 4 weeks old log - a flat file may be ! can someone help me. WIth regards CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR. CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR.
Re: BACKUP to TAPE, PERFORMANCE
This is likely not a tape issue. 52GB/hr is about 14.8MB/sec. I am betting your disk cannot read the data any faster than that. Unless the data is not compressable at all the typical rates for a SCSI Magstar drive are 25+MB/sec and can get as high as 34 on Ultra SCSI if the cables are real short. Fibre Channel easily gets 33. What kind of disk is the source? Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Gianluca Perilli [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 1:02 PM To: [EMAIL PROTECTED] Subject: Re: BACKUP to TAPE, PERFORMANCE HI Francisco, as far as I know the maximun native throughput of a 3590 drive is 12 MB/s. If you want something to refer to as a rule of thumb,these are the performance of the 3590 library: (Embedded image moved to file: pic19254.pcx) so you can check if you are having good performance in your environment. For more information about 3590 tape performances you can refer to this whitepaper: http://www.storage.ibm.com/hardsoft/tape/3590/prod_data/3590wp6.pdf Cordiali saluti / Best regards Gianluca Perilli Gianluca Perilli Tivoli Customer Support Via Sciangai n° 53 - 00144 Roma (Italy) Tel. 06/5966 - 4581 Cell. 335/7840985 Francisco Molero [EMAIL PROTECTED]To: [EMAIL PROTECTED] M cc: Sent by: ADSM: Subject: BACKUP to TAPE, PERFORMANCE Dist Stor Manager [EMAIL PROTECTED] .EDU 05/29/2002 12:00 PM Please respond to ADSM: Dist Stor Manager Hi everybody, My question is simple. We are running selective backup through Gigabit, and my STGpool is 3590 Tape Pool. I want to know, how many Gigabytes you backup per hour?? For bigger files I get a 52 GByte/hour. And I think these is very slow. This test is only 1 client and no other clients are accessing to Server. Any Ideas Thanks, Fran. ___ Copa del Mundo de la FIFA 2002 Disfruta en vmdeo de los mejores momentos desde tu ordenador. http://fifaworldcup.yahoo.com/fc/es/
Re: SQL statement
Is the Q OCC command insufficient? If not try this: select node_name, stgpool_name from occupancy group by node_name, stgpool_name You can also add a where clause if you would like. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Joel Fuhrman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Re: SQL statement search www.adsm.org and will find hundreds of SQL examples. On Wed, 29 May 2002, Bernard Rosenbloom wrote: I have an immediate need to create a list of all my registered nodes and the storage pool(s) each node backs up to. I know almost nothing about creating an SQL statement so if anyone can assist, I would appreciate it very much. Thank You Bernard Rosenbloom [EMAIL PROTECTED]
Re: NT Cluster TSM
Don't forget to check the Client Option Set as well. You may have an option in there for DOMAIN ALL-LOCAL and it may even be set to NOT allow overrides from clients (been there). ;) -Original Message- From: Zlatko Krastev [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 1:47 AM To: [EMAIL PROTECTED] Subject: Re: NT Cluster TSM Can you be sure that since you've set it up nothing has changed. It would be interesting to see current dsm.opt of local cluster node. Also the way how schedules are started may sched some light. Also check file backup dates on those unnecessary filespaces - maybe someone manually invoked dsmc with local option file and this is not done by regular schedules. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: NT Cluster TSM The way I have set this up is to use the CLUSTER name in TSM for the shared storage, and the two local computer names for the local drives. nodename Cluster - controls the F,G,H,I,J drives (CLUSTERNODE YES option) Server1 - controls c and d drive (Domain C, Domain D...) Server2 - controls c and d drive (Domain C, Domain D...) I have 2 schedules on each node - one for local backps and one for cluster backups. I created a group in the cluster admin to control backups service for the shared drives and keep the local node backups to automatic Joe -Original Message- From: Zlatko Krastev [mailto:[EMAIL PROTECTED]] Sent: Fri 24/05/2002 4:55 PM To: [EMAIL PROTECTED] Cc: Subject: Re: NT Cluster TSM The only explanation is that server1 somehow is getting DOMAIN ALL-LOCAL. Check carefully which dsm.opt is used when cluster instance goes to server1 and are there any DOMAIN options in a optionset associated to that node. If domain all-local gets somehow into local node then is have two current copies of shared files. But if cluster resources are backed up as server1 instead of cluster the only way to distinguish which version is the current is checking the date or very-very carefully follow failovers. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:NT Cluster TSM Hello, I'd like to ask a question about NT cluster with TSM.. I have got an NT Cluster and the backup is made with TSM. On the TSM server side I've got defined 2 server, each one for each real server: server1 and server2. There are another two server defined for shared disks: disk1(disk f:) and disk2 (disk g:). There are four file spaces: FileSpace Name Node Name \\server1\c$server1 \\server2\c$server2 \\cluster\f$disk1 \\cluster\g$disk2 The DOMAIN option in the opt files are Server1 DOMAIN C: Server2 DOMAIN C: disk1 DOMAIN F: disk2 DOMAIN G: From the backup point of view it works fine, the problem arises when the shared disks are moved from one real server to the other. In this situation the shared disks are considered as local disks for the real servers and a full backup of those disks are made, and the file spaces are as follows FileSpace Name Node Name \\server1\c$server1 \\server1\f$server1 \\server1\g$server1 \\server2\c$server2 \\cluster\f$disk1 \\cluster\g$disk2 The creation of the two new file spaces is normal? Is this situation ok? Another problem arises when there is a need of restoring a file: where is the backup of one file residing in disk f:? in \\server1\f$ or in \\cluster\f$ or in both? Which one is the most recent? and other than the last one? Can anyone help me in clarifing those questions? Angel Antsn E-Mail : [EMAIL PROTECTED]
Re: TSM monitored by TME
The problem with the default rls is that the baroc does not match the rls: The old approach for TSM adapter was to create an event class for each message, which ment thousands of classes resulted with heavy load on TME. The new approach is one Server event class and one Client event class and one for each TDP. The problem is that the baroc file is built for the new approach and the rls file matches the old approach. This is on my opinion a bug or something. maybe there is a fix out there, bu I couldn't find it. Anyway, either add the classes which appear in the rls file to the baroc file or change every rule in the rls file to meet with the new approach. The first way is easier... Ran. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 9:30 AM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME We do not intend to monitor clients with TME. Just Media and Library issues. So we actually want to see all occurences. The default RLS does not compile. We are working on it. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:14 AM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME Nice to have some partners out there But I am talking about the hard way... Rules, man, Rules... Suppose you get a message like a hundred times - connection refusal or something like that. I don't want my operators to get lost in the forest... I am trying to write some. Will share when I'm done. Ran. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:54 PM To: [EMAIL PROTECTED] Subject: Re: TSM monitored by TME We are in the process of implementing. Should be this week. We are doing message control from the TSM Server point of view by turning on which ones we want to see. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 7:43 AM To: [EMAIL PROTECTED] Subject: TSM monitored by TME Hello TSMers. Does any of you monitor his TSM with TME10 TEC ? I have TSM servers version 4.1, TME version 3.7 I happen to find the ibmtsm.baroc and the ibmtsm.rls files shipped with tsm 4.1 to be quite useless since they contain very few rules. Also they don't match - the rls file is still matched to an old version of baroc file in which every message has it's own class. Does anyone there has a nice set of baroc and rls files that I can use, before I'm doing a mass developement of my own? I'll appreciate it !!! Ran.
ANR9999D Error message: Do you how to figure out this message?
--- O/S: SunOS 5.6 TSM: Version 4, Release 2, Level 1.15 Tape library: scalar 1000 from ADIC Tape drive: AIT2 drive Tape : AIT2 (50GB~100GB) --- Dear All, Situation we face I am wondering where I can get more detailed information about ANRD error message. Actually we have been suffering from so many problems including robot, drive problems and so on. Also we've got many times ANR8300E Changer Failure error msg and then TSM just died...T_T But funny thing is there is no tape stuck in the drive even though the library LCD screen says for example Element 1212(drive12) is obstructed. Last night we had the same problem again and I tried to update the drive12 onlin=no then all the other drives are working fine no more changer failure since the last reboot. So I think this error msg is misled by something else. Please if you had faced similar situation before please get back to me. Questions As you see the log below, I found something going wrong with space reclamation on c3(copy pool for offsite). As soon as I did update stg c3 recl=60 from recl=100( basically no space reclamation), I've got the ANR999D error message. This error msg just never stopped!! Scared and put it back. Then I tried it again after set CONTEXTMESSAGING on to get details. You can see the red marked detailed information about ANR999D msg below but simply I don't know what it means. Can you let me know good reference or any documents? Thanks, Meensun from Tokyo - Activity Log - 05/30/02 16:06:35 ANR2017I Administrator AHNME issued command: UPDATE STGPOOL c3 recl=60 05/30/02 16:06:35 ANR2202I Storage pool C3 updated. 05/30/02 16:06:35 ANR0984I Process 36 for SPACE RECLAMATION started in the BACKGROUND at 16:06:35. 05/30/02 16:06:36 ANR1040I Space reclamation started for volume 005086, storage pool C3 (process number 36). . . . 05/30/02 16:06:36 ANR1040I Space reclamation started for volume 005691, storage pool C3 (process number 36). 05/30/02 16:06:36 ANR1040I Space reclamation started for volume 005973, storage pool C3 (process number 36). 05/30/02 16:06:36 ANRD ssrecons.c(2391): ThreadId50 Actual: Magic=80B93C01, SrvId=-219899260, SegGroupId=14301299977853604355, SeqNum=2031456424, converted=T. 05/30/02 16:06:36 ANRD ssrecons.c(2405): ThreadId50 Expected: Magic=53454652, SrvId=0, SegGroupId=5855761. SeqNum=80. 05/30/02 16:06:38 (50) Context report 05/30/02 16:06:38 (50) SsAuxReconSrcThread : ANRD calling thread 05/30/02 16:06:38 (50) Generating TM Context Report: (struct=tmTxnDesc) (slots=256) 05/30/02 16:06:38 (50) *** no transactions found *** 05/30/02 16:06:38 (50) Generating Database Transaction Table Context: 05/30/02 16:06:38 (50) Tsn=0:37757505 -- Valid=1, inRollback=0, endNTA=0, State=2, Index=7, LatchCount=0, SavePoint=0, TotLogRecs=0, TotLogBytes=0, UndoLogRecs=0, UndoLogBytes=0, LogReserve=0, PageReserve=0, Elapsed=230 (ms), MinLsn=0.0.0, MaxLsn=0.0.0, LastLsn=0.0.0, UndoNextLsn=0.0.0, logWriter=False, backupTxn=False 05/30/02 16:06:38 (50) Open objects: 05/30/02 16:06:38 (50)name -SS.Volume.Names- (sp=0) 05/30/02 16:06:38 (50) *** no transactions found *** 05/30/02 16:06:38 (50) Generating SM Context Report: 05/30/02 16:06:38 (50) *** no sessions found *** 05/30/02 16:06:38 (50) Generating AS Vol Context Report: 05/30/02 16:06:38 (50) No mounted (or mount in progress) volumes. 05/30/02 16:06:38 (50) Generating ssSession Context Report: 05/30/02 16:06:38 (50) No storage service sessions active. 05/30/02 16:06:38 (50) Generating ssOpenSeg Context Report: 05/30/02 16:06:38 (50) Storage Service Segments: 05/30/02 16:06:38 (50) VolId=1250, Start=64757, Offset=0, SessId=612, Locked=False, Deallocated=False 05/30/02 16:06:38 (50) Generating BF Copy Control Context Report: 05/30/02 16:06:38 (50) No global copy control blocks. 05/30/02 16:06:38 05/30/02 16:06:38 (50) End Context report 05/30/02 16:06:38 (50) Context report 05/30/02 16:06:38 (50) SsAuxReconSrcThread : ANRD calling thread 05/30/02 16:06:38 (50) Generating TM Context Report: (struct=tmTxnDesc) (slots=256) 05/30/02 16:06:38
Re: q actlog
Yes you can ! All u need to have is restore your 'db' on development box. You must note as long as you have ACTLOGRETNETION set to 14 days or so, your earlier db also contains 14days of logs only. only thing you can have form the old db is back 14days from the date you restore your db. Thanks and regards, Sreekumar P.Pothula Strategic Outsourcing IBM Global Services Notes ID : [EMAIL PROTECTED] , Voice : Office : (65) 6840 2637 Mobile : (65) 9271 0345 Ruksana Siddiqui Ruksana.Siddiqui@AMTo: [EMAIL PROTECTED] COR.COM.AU cc: Sent by: ADSM: DistSubject: Re: q actlog Stor Manager [EMAIL PROTECTED] U 05/30/2002 15:13 Please respond to ADSM: Dist Stor Manager Boris, Can I grab old actlog from my db backup , if so how - With regards, -Original Message- From: Slutsky, Boris [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 4:31 PM To: [EMAIL PROTECTED] Subject: Re: q actlog Hi, The reason why you get only 2 weeks old act log records, probably, is the retention period defined for activity log is 14 days. So, there are no more records in act log. Try to use SET ACTLOGRETENTION admin command to change it. Take into account that it influences DB size, because act log is actually a DB table. Boris Slutsky E-mail: [EMAIL PROTECTED] -Original Message- From: Ruksana Siddiqui [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 07:06 To: [EMAIL PROTECTED] Subject: q actlog Simple question: if I do q actlog and give date 14th may it gets me actlog from 20th may so it's keeping only 2 weeks old. Where do I have to look if I need 4 weeks old log - a flat file may be ! can someone help me. WIth regards CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR. CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR.
Query Backupsetcontent
Hello TSMers. I generated a backupset on a tsm server a a remote site. I then brought the tape back to our local tsm site and I am trying to query the contents of the backupset but it hangsDoes anyone know how I can view what is on the tape Your assistance will be greatly appreciated. Thanks Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, the BoE Group does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.nbs.co.za/emaildisclaim.htm
Re: delete specific data.
Leijnse, Finn F SITI-ITDSES31 wrote: Someone has decided to archive 1.5 TB (oracle DB) to a management class with 5 years retention period. Some ** idea of a manager. What has happened is that that archive has abended halfway. Is there a way to delete that data? I have not got an idea of what TSM does with that failed archive. Is the archive visible in the retrieve window of the GUI? If not I would assume that the server has discarded the data. If it is visible there you can use the GUI to delete that specific archive. Regards, Alexander --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
Re: SQL statement
Q OCC gives me for info then I need but your SQL statement is exactly what I was looking for...thanks Seay, Paul wrote: Is the Q OCC command insufficient? If not try this: select node_name, stgpool_name from occupancy group by node_name, stgpool_name You can also add a where clause if you would like. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Joel Fuhrman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Re: SQL statement search www.adsm.org and will find hundreds of SQL examples. On Wed, 29 May 2002, Bernard Rosenbloom wrote: I have an immediate need to create a list of all my registered nodes and the storage pool(s) each node backs up to. I know almost nothing about creating an SQL statement so if anyone can assist, I would appreciate it very much. Thank You Bernard Rosenbloom [EMAIL PROTECTED]
Re: select formatting
select node_name as + Node Name+++ from nodes. Put in as many fill chars as you need to force the output to be as wide as your widest node name. -Original Message- From: Gerald Wichmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 7:16 PM To: [EMAIL PROTECTED] Subject: select formatting The below output is from a simple select statement. I hate to ask this again but its been a while since I've done it and I forget how to format the columns. What I need to do is extract the node names from the backup server so that I can then perform operations on them. How do I increase the width of the column to get the desired effect? I suppose set sqldisplaymode would do it but I'm actually running the select query from a perl script via a dsmadmc command. i.e.: @RESULT = `/opt/Tivoli/tsm/client/admin/bin/dsmadmc -id=admin -pa=admin select node_name from nodes`; returns the below when what I want is to store the node names in an array Obtaining list of nodes on backup server.. Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server SERVER1: Solaris 7/8 Server Version 4, Release 2, Level 2.0 Server date/time: 05/29/02 23:05:26 Last access: 05/29/02 22:54:56 ANS8000I Server command: 'select node_name from nodes' NODE_NAME -- ORION-41.8-10.0.1- 04.1 ORION-41.8-10.0.1- 72.1 ORION-41.8-10.0.1- 72.3 ORION-41.8-10.0.1- 72.4 ORION-41.8-10.0.1- 72.5 ORION-41.8-10.0.1- 72.7 ORION-41.8-10.0.2- 04.1 ORION-41.8-10.0.2- 04.2 ORION-41.8-10.0.2- 04.3 ORION-41.8-10.0.2- 04.4 ORION-41.8-10.0.2- 04.5 ORION-41.8-10.0.2- 04.7 ANS8002I Highest return code was 0. Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w)
Re: Storage Pool Size
The answer is IT DEPENDS, and different people have different opinions, depending on what you are optimizing for. If you will go to www.adsm.org and click CURRENT MONTH, this topic was discussed at length over the past 2 days under the topic: allocating disk volumes on RAID5 array -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:32 AM To: [EMAIL PROTECTED] Subject: Storage Pool Size I am planning a TSM Server move from OS390/MVS to AIX. My largest storage pool is about 73gig and is spread across 32 volumes of about 2.3gig each. On AIX I will have a 128gig file system so I could put that storage pool into a single volume if that makes sense. My question is should I spread the storage pool across multiple tms volumes and if so what size should I make them? So should I allocate it as one large volume? David
Re: SQL statement
I hope this is what you are looking for. select node_name,stgpool_name from occupancy similar to q occup Sung Y. Lee 512-823-1012 Bernard Rosenbloom To: [EMAIL PROTECTED] brosenbl@OPTONLIcc: NE.NET Subject: SQL statement Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/29/2002 10:04 AM Please respond to ADSM: Dist Stor Manager I have an immediate need to create a list of all my registered nodes and the storage pool(s) each node backs up to. I know almost nothing about creating an SQL statement so if anyone can assist, I would appreciate it very much. Thank You Bernard Rosenbloom [EMAIL PROTECTED]
Re: SQL statement
Hi, If you install the TSM ODBC Driver and point it at your TSM Server's IP Address and Port 1500, you can do this query in Excel or MS Access. In MS Excel click on Data, Get external data, new database query, Click on the Data Source name that is your ODBC connection Name, and log in to your TSM Server. This will give you a list of tables in your TSM Database. Tom Ammann Server Specialist Purdue Pharma LP (203) 588-8117 -Original Message- From: Bernard Rosenbloom [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: SQL statement I have an immediate need to create a list of all my registered nodes and the storage pool(s) each node backs up to. I know almost nothing about creating an SQL statement so if anyone can assist, I would appreciate it very much. Thank You Bernard Rosenbloom [EMAIL PROTECTED]
Re: Magstar Tape capabilities
Check the IBM web site for the current numbers: http://www.storage.ibm.com/hardsoft/tape/3590/prod_data/g225-6824.html 3590 tape drive performance depends on the model. The latest E1x models write at 14 MB/sec raw, with a maximum sustained rate on SCSI of 34 MB/sec (with compression) and 42 MB/sec of FC with compression. Burst rates are higher, 40 and 100. Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) 121 Cheshire Lane #700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] Gabriel Wiley [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 05/29/02 08:39 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Magstar Tape capabilities An excerpt from the Magstar Redbook. SG24-2594-02 The Magstar tape drive is capable of reading and writing data at a rate of 9 MB/sec. This is three times the rate at which IBM 3490E devices can read and write data. The IBM 3590 High Performance Tape Subsystem can transfer data between the host and the tape subsystem at a rate of 20 MB/sec for hosts attached through small computer systems interface (SCSI), and a rate of 17 MB/sec for hosts attached through Enterprise System Connection (ESCON) channels. Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza
select formatting
The below output is from a simple select statement. I hate to ask this again but its been a while since I've done it and I forget how to format the columns. What I need to do is extract the node names from the backup server so that I can then perform operations on them. How do I increase the width of the column to get the desired effect? I suppose set sqldisplaymode would do it but I'm actually running the select query from a perl script via a dsmadmc command. i.e.: RESULT = `/opt/Tivoli/tsm/client/admin/bin/dsmadmc -id=admin -pa=admin select node_name from nodes`; returns the below when what I want is to store the node names in an array Obtaining list of nodes on backup server.. Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server SERVER1: Solaris 7/8 Server Version 4, Release 2, Level 2.0 Server date/time: 05/29/02 23:05:26 Last access: 05/29/02 22:54:56 ANS8000I Server command: 'select node_name from nodes' NODE_NAME -- ORION-41.8-10.0.1- 04.1 ORION-41.8-10.0.1- 72.1 ORION-41.8-10.0.1- 72.3 ORION-41.8-10.0.1- 72.4 ORION-41.8-10.0.1- 72.5 ORION-41.8-10.0.1- 72.7 ORION-41.8-10.0.2- 04.1 ORION-41.8-10.0.2- 04.2 ORION-41.8-10.0.2- 04.3 ORION-41.8-10.0.2- 04.4 ORION-41.8-10.0.2- 04.5 ORION-41.8-10.0.2- 04.7 ANS8002I Highest return code was 0. Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w)
Re: Mirror Recovery Log DB with RAID-5
See http://msgs.adsm.org/cgi-bin/get/adsm/864.html Along with multiple others (http://search.adsm.org/) -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:39 AM To: [EMAIL PROTECTED] Subject: Mirror Recovery Log DB with RAID-5 Hello! The environment at my company is that we have Hitachi RAID-5 and I was wondering why I need to mirror the DB and recovery log if we have this technology implemented. Does anyone have justification for this? Thanks Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338
ANU2508E Wrong write state- any ideas?
Hello *SMers,
On one of our production boxes (data warehouse) this error occurred
yesterday during a hot backup with TDPO 2.2.0.2 (most current patch
available on the ftp site). I can't find anything in the activity log or in
the errpt for the TSM server and the client that correlates with this
error. The message for ANU2508 is:
ANU2508E Wrong write state
Explanation: The operation must be in WRITE state.
System Action: The system returns to the calling
procedure.
User Response: Contact TSM support.
and I am asking for the list's help before I call support. Any one have
any ideas? The storage pool target is ESS disk, with no limit on the size.
Recovery Manager: Release 8.1.6.3.0 - Production
RMAN-06005: connected to target database: HII9 (DBID=1656096066)
RMAN-06008: connected to recovery catalog database
RMAN run {
2 allocate channel c1 type 'sbt_tape' parms
3 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4 allocate channel c2 type 'sbt_tape' parms
5 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
6 allocate channel c3 type 'sbt_tape' parms
7 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
8 allocate channel c4 type 'sbt_tape' parms
9 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
10 backup incremental level = 2
11 format 'df_%U'
12 (database);
13 release channel c1;
14 release channel c2;
15 release channel c3;
16 release channel c4;
17 }
18
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=16 devtype=SBT_TAPE
RMAN-08526: channel c1: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c2
RMAN-08500: channel c2: sid=9 devtype=SBT_TAPE
RMAN-08526: channel c2: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c3
RMAN-08500: channel c3: sid=20 devtype=SBT_TAPE
RMAN-08526: channel c3: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c4
RMAN-08500: channel c4: sid=8 devtype=SBT_TAPE
RMAN-08526: channel c4: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting incremental level 2 datafile backupset
RMAN-08502: set_count=1835 set_stamp=463068016 creation_time=28-MAY-02
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=4
name=/u91/oradata/HII9/fmsdm/fmsdmindex0313.dbf
RMAN-08522: input datafile fno=00019
name=/u90/oradata/HII9/fmsdm/fmsdmdata047.dbf
RMAN-08522: input datafile fno=00023
name=/u90/oradata/HII9/fmsdm/fmsdmdata0410.dbf
RMAN-08522: input datafile fno=00027
name=/u90/oradata/HII9/fmsdm/fmsdmdata049.dbf
RMAN-08522: input datafile fno=00042
name=/u91/oradata/HII9/fmsdm/fmsdmindex023.dbf
RMAN-08522: input datafile fno=00047
name=/u91/oradata/HII9/fmsdm/fmsdmindex025.dbf
RMAN-08522: input datafile fno=00051
name=/u91/oradata/HII9/fmsdm/fmsdmindex032.dbf
RMAN-08522: input datafile fno=00055
name=/u91/oradata/HII9/fmsdm/fmsdmindex031.dbf
RMAN-08522: input datafile fno=00059
name=/u91/oradata/HII9/fmsdm/fmsdmindex036.dbf
RMAN-08522: input datafile fno=00063
name=/u91/oradata/HII9/fmsdm/fmsdmindex042.dbf
RMAN-08522: input datafile fno=00075
name=/u91/oradata/HII9/fmsdm/fmsdmindex0316.dbf
RMAN-08522: input datafile fno=00032
name=/u90/oradata/HII9/fmsdm/fmsdmdata052.dbf
RMAN-08522: input datafile fno=00016
name=/u90/oradata/HII9/fmsdm/fmsdmdata033.dbf
RMAN-08522: input datafile fno=00039
name=/u91/oradata/HII9/fmsdmfl/fmsdmflindex020.dbf
RMAN-08522: input datafile fno=00071
name=/u91/oradata/HII9/fmsdmpm/fmsdmpmindex020.dbf
RMAN-08522: input datafile fno=00012
name=/u90/oradata/HII9/fmsdm/fmsdmdata012.dbf
RMAN-08522: input datafile fno=1
name=/u90/oradata/HII9/dbsys/system01.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00037
name=/u91/oradata/HII9/fmsdmfl/fmsdmflindex010.dbf
RMAN-08522: input datafile fno=00072
name=/u90/oradata/HII9/fmsdmpm/fmsdmpmdata010.dbf
RMAN-08008: channel c2: starting incremental level 2 datafile backupset
RMAN-08502: set_count=1836 set_stamp=463068018 creation_time=28-MAY-02
RMAN-08010: channel c2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00015
name=/u90/oradata/HII9/fmsdm/fmsdmdata030.dbf
RMAN-08522: input datafile fno=00021
name=/u90/oradata/HII9/fmsdm/fmsdmdata043.dbf
RMAN-08522: input datafile fno=00025
name=/u90/oradata/HII9/fmsdm/fmsdmdata042.dbf
RMAN-08522: input datafile fno=00029
name=/u90/oradata/HII9/fmsdm/fmsdmdata044.dbf
RMAN-08522: input datafile fno=00044
name=/u91/oradata/HII9/fmsdm/fmsdmindex021.dbf
RMAN-08522: input
Re: BACKUP to TAPE, PERFORMANCE
I thought it was 16MB/sec B1A model type, and up to 24MB for E1A Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza |-+ | | Gianluca | | | Perilli/Italy/IBM| | | @IBMIT | | | Sent by: ADSM: | | | Dist Stor| | | Manager | | | [EMAIL PROTECTED]| | | .EDU| | || | || | | 05/30/2002 01:02 | | | PM | | | Please respond to| | | ADSM: Dist Stor | | | Manager | | || |-+ --| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: BACKUP to TAPE, PERFORMANCE | | | | | --| HI Francisco, as far as I know the maximun native throughput of a 3590 drive is 12 MB/s. If you want something to refer to as a rule of thumb,these are the performance of the 3590 library: (Embedded image moved to file: pic19254.pcx) so you can check if you are having good performance in your environment. For more information about 3590 tape performances you can refer to this whitepaper: http://www.storage.ibm.com/hardsoft/tape/3590/prod_data/3590wp6.pdf Cordiali saluti / Best regards Gianluca Perilli Gianluca Perilli Tivoli Customer Support Via Sciangai n° 53 - 00144 Roma (Italy) Tel. 06/5966 - 4581 Cell. 335/7840985 Francisco Molero [EMAIL PROTECTED]To: [EMAIL PROTECTED] M cc: Sent by: ADSM: Subject: BACKUP to TAPE, PERFORMANCE Dist Stor Manager [EMAIL PROTECTED] .EDU 05/29/2002 12:00 PM Please respond to ADSM: Dist Stor Manager Hi everybody, My question is simple. We are running selective backup through Gigabit, and my STGpool is 3590 Tape Pool. I want to know, how many Gigabytes you backup per hour?? For bigger files I get a 52 GByte/hour. And I think these is very slow. This test is only 1 client and no other clients are accessing to Server. Any Ideas Thanks, Fran. ___ Copa del Mundo de la FIFA 2002 Disfruta en vmdeo de los mejores momentos desde tu ordenador. http://fifaworldcup.yahoo.com/fc/es/ pic19254.pcx has been removed from this note on May 29 2002 by Gabriel Wiley
Symbolic Links
What is the correct way to backup Symbolic links for AIX. TSM server V 4.2.1.11 AIX client V 4.2.1.23 The client wants to backup all the folders pointed by the Link and also restore the folders pointed to by symbolic links. Should I be able to see the link in the Backup GUI ? Thanks Rajesh Oak Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus
Re: allocating disk volumes on RAID5 array
Hmm... All of our disk storage pools are larger than 2 GB and have large files enabled because we do see files larger than 2GB come in from clients... I'm quite sure I'm not going to want to slice up a 36Gb disk into 18 2GB filesystems just to use direct I/O. I think the drive head contention would eat me alive. I'm not sure where they expect this functionality to be used when they have those 2 limitations on direct I/O... Ben -Original Message- From: Paul Zarnowski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 6:54 AM To: [EMAIL PROTECTED] Subject: Re: allocating disk volumes on RAID5 array I'm curious if anyone feels that the new AIXDIRECTIO option in TSM 5.1 affects their opinions about how to utilize disk for storage pools. TSM 5.1 also has an Async I/O option (AIX). For more info, refer to http://www.redbooks.ibm.com/redpieces/pdfs/sg246554.pdf, starting at about page 107. The AIXDIRECTIO option does not work with large-file-enabled filesystems, so the filesystem must be 2GB or smaller. This option bypasses VMM file cache.
Re: about DRM
You are correct. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Luscombe John (HS) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 2:40 AM To: [EMAIL PROTECTED] Subject: AW: about DRM Burak, As far as I understand it, the reclamation of offsite copy pool carts is not a DRM function, reclamation is a standard part of TSM where a new tape is produced locally that consolidates the carts offsite that are partly full. The thing that DRM does for you is to manage the movement of which carts to send offsite and which ones to bring back because they have been reclaimed. I think that's right. John. Hi, I am trying to understand DRM concept especially the reclamation part. As the volumes become FULL they will be reclaimed when the data is low (define in pool's RECLAIM value) even if they are offsite copies. The primary pool volumes onsite will be used and reclaimed EMPTY copy pool volumes will be returned. Now my point comes. I have a schedule to backup primary pool every day to copy pool. I have one FILLING volume everyday to send to offsite. Then, there will be 20 volumes offsite (with FILLING status, and very little data on it) What is the DRM's solution to reclaim such volumes? Is it to bring them onsite and use MOVE DATA command?
Magstar Tape capabilities
An excerpt from the Magstar Redbook. SG24-2594-02 The Magstar tape drive is capable of reading and writing data at a rate of 9 MB/sec. This is three times the rate at which IBM 3490E devices can read and write data. The IBM 3590 High Performance Tape Subsystem can transfer data between the host and the tape subsystem at a rate of 20 MB/sec for hosts attached through small computer systems interface (SCSI), and a rate of 17 MB/sec for hosts attached through Enterprise System Connection (ESCON) channels. Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza
Re: Running a Windows Batch file on my Windows server
Thanks Bill. Great idea, I've modified ours and hope it runs tomorrow morning! Tim Rushforth City of Winnipeg -Original Message- From: Bill Boyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 10:51 AM To: [EMAIL PROTECTED] Subject: Re: Running a Windows Batch file on my Windows server Instead of deleting and re-defining the schedule , we've changed our procedures to just update the schedule with a new starttime/startdate of NOW+hh:ss and TODAY. Saves having to del/define/associate everything. This way you can manually define the schedule the way you want before creating the script. And then change the association if need be without script changes. You can't update a script if the server is currently running that script. Our daily storage pool backup script runs with lots of WAIT=YES, so it's difficult to update that script. We've tried to move as much OUT of the script as we can to ease changes. Unfortunately, UPDATEing the schedule also seems to remove any event history. Just like deleting a schedule, all event history is removed, too. Bill Boyer DSS, Inc.
BACKUP to TAPE, PERFORMANCE II
Hi again, I only use one drive. This is important. Sorry for my previous mail. Client Options: nodename IBM_TEST ERRORLOGRETENTION 5 PASSWORDACCESS GENERATE SCHEDLOGRETENTION 5 SCHEDMODE PROMPTED TCPB32 TCPNYES TCPPORT 1500 TCPSERVERADDRESSTSMSERVER TCPW64 TXNB1048576 largecommbufno Server Options : SELFTUNEBUFpoolsize yes SELFTUNETXNsize yes COMMmethod TCPIP COMMmethod SHAREDMEM COMMmethod HTTP TCPPort 1500 HTTPPort 1580 LOGPoolsize 2048 LANGuage en_US DATEformat 1 TIMEformat 1 MIRRORWRITE DB SEQUENTIAL MSGINTerval 1 MAXSESSIONS 5000 ENABLE3590LIBRARY YES COMMTIMEOUT 600 IDLETIMEOUT 600 bufpoolsize 262144 tcpwindowsize 64 TXNGroupmax 256 TCPBufsize 32 MOVEBatchsize 1000 MoveSizethresh500 USELARGEBUFFERS Yes LOGPoolsize 2048 HW: FC DISKS ( COMPAQ ARRAY) - TSM CLIENT TRU64 (4 PROC and 4GB RAM) - GIGABIT ETH - TSM SERVER 1GB RAM AND 1 PROCESSOR - 3494 with on drive 3590E FC. ___ Copa del Mundo de la FIFA 2002 El znico lugar de Internet con vmdeos de los 64 partidos. !Apzntante ya! en http://fifaworldcup.yahoo.com/fc/es/
ANU2508E Wrong write state- any ideas?
Hello *SMers,
On one of our production boxes (data warehouse) this error occurred
yesterday during a hot backup with TDPO 2.2.0.2 (most current patch
available on the ftp site). I can't find anything in the activity log or in
the errpt for the TSM server and the client that correlates with this
error. The message for ANU2508 is:
ANU2508E Wrong write state
Explanation: The operation must be in WRITE state.
System Action: The system returns to the calling
procedure.
User Response: Contact TSM support.
and I am asking for the list's help before I call support. Any one have
any ideas? The storage pool target is ESS disk, with no limit on the size.
Recovery Manager: Release 8.1.6.3.0 - Production
RMAN-06005: connected to target database: HII9 (DBID=1656096066)
RMAN-06008: connected to recovery catalog database
RMAN run {
2 allocate channel c1 type 'sbt_tape' parms
3 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4 allocate channel c2 type 'sbt_tape' parms
5 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
6 allocate channel c3 type 'sbt_tape' parms
7 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
8 allocate channel c4 type 'sbt_tape' parms
9 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
10 backup incremental level = 2
11 format 'df_%U'
12 (database);
13 release channel c1;
14 release channel c2;
15 release channel c3;
16 release channel c4;
17 }
18
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=16 devtype=SBT_TAPE
RMAN-08526: channel c1: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c2
RMAN-08500: channel c2: sid=9 devtype=SBT_TAPE
RMAN-08526: channel c2: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c3
RMAN-08500: channel c3: sid=20 devtype=SBT_TAPE
RMAN-08526: channel c3: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c4
RMAN-08500: channel c4: sid=8 devtype=SBT_TAPE
RMAN-08526: channel c4: Tivoli Data Protection for Oracle: version 2.2.0.2
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting incremental level 2 datafile backupset
RMAN-08502: set_count=1835 set_stamp=463068016 creation_time=28-MAY-02
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=4
name=/u91/oradata/HII9/fmsdm/fmsdmindex0313.dbf
RMAN-08522: input datafile fno=00019
name=/u90/oradata/HII9/fmsdm/fmsdmdata047.dbf
RMAN-08522: input datafile fno=00023
name=/u90/oradata/HII9/fmsdm/fmsdmdata0410.dbf
RMAN-08522: input datafile fno=00027
name=/u90/oradata/HII9/fmsdm/fmsdmdata049.dbf
RMAN-08522: input datafile fno=00042
name=/u91/oradata/HII9/fmsdm/fmsdmindex023.dbf
RMAN-08522: input datafile fno=00047
name=/u91/oradata/HII9/fmsdm/fmsdmindex025.dbf
RMAN-08522: input datafile fno=00051
name=/u91/oradata/HII9/fmsdm/fmsdmindex032.dbf
RMAN-08522: input datafile fno=00055
name=/u91/oradata/HII9/fmsdm/fmsdmindex031.dbf
RMAN-08522: input datafile fno=00059
name=/u91/oradata/HII9/fmsdm/fmsdmindex036.dbf
RMAN-08522: input datafile fno=00063
name=/u91/oradata/HII9/fmsdm/fmsdmindex042.dbf
RMAN-08522: input datafile fno=00075
name=/u91/oradata/HII9/fmsdm/fmsdmindex0316.dbf
RMAN-08522: input datafile fno=00032
name=/u90/oradata/HII9/fmsdm/fmsdmdata052.dbf
RMAN-08522: input datafile fno=00016
name=/u90/oradata/HII9/fmsdm/fmsdmdata033.dbf
RMAN-08522: input datafile fno=00039
name=/u91/oradata/HII9/fmsdmfl/fmsdmflindex020.dbf
RMAN-08522: input datafile fno=00071
name=/u91/oradata/HII9/fmsdmpm/fmsdmpmindex020.dbf
RMAN-08522: input datafile fno=00012
name=/u90/oradata/HII9/fmsdm/fmsdmdata012.dbf
RMAN-08522: input datafile fno=1
name=/u90/oradata/HII9/dbsys/system01.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00037
name=/u91/oradata/HII9/fmsdmfl/fmsdmflindex010.dbf
RMAN-08522: input datafile fno=00072
name=/u90/oradata/HII9/fmsdmpm/fmsdmpmdata010.dbf
RMAN-08008: channel c2: starting incremental level 2 datafile backupset
RMAN-08502: set_count=1836 set_stamp=463068018 creation_time=28-MAY-02
RMAN-08010: channel c2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00015
name=/u90/oradata/HII9/fmsdm/fmsdmdata030.dbf
RMAN-08522: input datafile fno=00021
name=/u90/oradata/HII9/fmsdm/fmsdmdata043.dbf
RMAN-08522: input datafile fno=00025
name=/u90/oradata/HII9/fmsdm/fmsdmdata042.dbf
RMAN-08522: input datafile fno=00029
name=/u90/oradata/HII9/fmsdm/fmsdmdata044.dbf
RMAN-08522: input datafile fno=00044
name=/u91/oradata/HII9/fmsdm/fmsdmindex021.dbf
RMAN-08522: input
/VAR File System on AIX 4.3.3 and TSM Error
I am getting this error message on my TSM Server and was not sure if these files are cached and replaced with new files causing the ANE4005E error below. Also, is there a specific reason that the /VAR file system should be backed up on a regular basis. Thanks. ANE4005E (Session: 13772, Node: HNAB) Error processing '/var/ha/run/haem.STRT_OH_PROD/Rcache_local/68598,10227- 34875,992213634,0,0.0.0.0': file not found Adam
Question about port configuration...
Hello, When the tsm client talks to the server it uses 1500. Is there a way to tell the server what port to talk to the client on? Thanks, Keith
Re: SQL statement
Here's an alternate . . . select distinct node_name,stgpool_name from occupancy Also, if you type . . . select * from occupancy . . . you'll get the entire table. Hope this helps. Mahesh [EMAIL PROTECTED] 05/29/02 11:18AM I hope this is what you are looking for. select node_name,stgpool_name from occupancy similar to q occup Sung Y. Lee 512-823-1012 Bernard Rosenbloom To: [EMAIL PROTECTED] brosenbl@OPTONLIcc: NE.NET Subject: SQL statement Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/29/2002 10:04 AM Please respond to ADSM: Dist Stor Manager I have an immediate need to create a list of all my registered nodes and the storage pool(s) each node backs up to. I know almost nothing about creating an SQL statement so if anyone can assist, I would appreciate it very much. Thank You Bernard Rosenbloom [EMAIL PROTECTED]
frame relay nodes-- can I avoid another full backup?
Hello again, here's the deal- we have approximately 50 frame relay nodes that backup to TSM servers. These NT boxes' drives are almost full (max is 16G on these) and partitions were created to hold data (D:\) and app shares (E:\). We are getting replacements (80G and expandable), and will be xcopying data from the old to the new, but the OS will be 2000. The plan right now is to just create a big D:\ drive and xcopy the files from the old D: and E: drives to this new D: drive. Host names may remain the same, but maybe not-- since we won't be a full 2000 enterprise, and 2000 can't emulate an old NT BDC, the old boxes may remain in the remote locations to serve as the BDCs-- without changing their hostnames. How can I tell/trick TSM to not backup up these new files on a different drive again and to know about previous versions of files with the old drive letter? Or is this issue moot due to the OS change? I can rename the node data and resolve the issue with a full backup due to the change in hostname, but I don't see any way to rename the filespace names to keep from having to do a full backup. I am not up to speed on 5.1, maybe the ability is there with the new code? tia lisa
Re: select formatting
Add the '-tab' command line parameter. We do this with Perl scripts and then split(/\t/,$RESULT) it. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Wichmann Sent: Wednesday, May 29, 2002 7:16 PM To: [EMAIL PROTECTED] Subject: select formatting The below output is from a simple select statement. I hate to ask this again but its been a while since I've done it and I forget how to format the columns. What I need to do is extract the node names from the backup server so that I can then perform operations on them. How do I increase the width of the column to get the desired effect? I suppose set sqldisplaymode would do it but I'm actually running the select query from a perl script via a dsmadmc command. i.e.: @RESULT = `/opt/Tivoli/tsm/client/admin/bin/dsmadmc -id=admin -pa=admin select node_name from nodes`; returns the below when what I want is to store the node names in an array Obtaining list of nodes on backup server.. Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server SERVER1: Solaris 7/8 Server Version 4, Release 2, Level 2.0 Server date/time: 05/29/02 23:05:26 Last access: 05/29/02 22:54:56 ANS8000I Server command: 'select node_name from nodes' NODE_NAME -- ORION-41.8-10.0.1- 04.1 ORION-41.8-10.0.1- 72.1 ORION-41.8-10.0.1- 72.3 ORION-41.8-10.0.1- 72.4 ORION-41.8-10.0.1- 72.5 ORION-41.8-10.0.1- 72.7 ORION-41.8-10.0.2- 04.1 ORION-41.8-10.0.2- 04.2 ORION-41.8-10.0.2- 04.3 ORION-41.8-10.0.2- 04.4 ORION-41.8-10.0.2- 04.5 ORION-41.8-10.0.2- 04.7 ANS8002I Highest return code was 0. Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w)
SQL/scripts
Hello! I don't have a reporting package and I was wondering if any on you could tell me some useful scripts that you run on a daily basis? Thanks!!! Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338
Re: BACKUP to TAPE, PERFORMANCE
Francisco, those numbers are normal. 3590 drives have a native transfer rate of 12MB/s. that makes around the 50GB/h mark. to have more than that you have to compress your data, and the 3590 can compress up to 3:1. whether you can do that or not depends on your data (3:1 compression ratios are generally achieved only in mainframe world; in open systems you would expect something closer to 2:1). other than that, it depends on the number of tape drives used, and the bandwidth occupancy at backup time if you are in a LAN environment as it would seem to be your case. Cordiali saluti Gianluca Mariani Tech Support SSD Via Sciangai 53, Roma phones : +39(0)659664598 +393351270554 (mobile) [EMAIL PROTECTED] Francisco Molero [EMAIL PROTECTED]To: [EMAIL PROTECTED] M cc: Sent by: ADSM: Subject: BACKUP to TAPE, PERFORMANCE Dist Stor Manager [EMAIL PROTECTED] .EDU 05/29/2002 12:00 PM Please respond to ADSM: Dist Stor Manager Hi everybody, My question is simple. We are running selective backup through Gigabit, and my STGpool is 3590 Tape Pool. I want to know, how many Gigabytes you backup per hour?? For bigger files I get a 52 GByte/hour. And I think these is very slow. This test is only 1 client and no other clients are accessing to Server. Any Ideas Thanks, Fran. ___ Copa del Mundo de la FIFA 2002 Disfruta en vmdeo de los mejores momentos desde tu ordenador. http://fifaworldcup.yahoo.com/fc/es/
Re: BACKUP to TAPE, PERFORMANCE II
Fran, one parameter you can change is Bufpoolsize on the server. for 1GB of real RAM you should put it to 131072. the other thing is to turn compression off, in a single client, fast client, fast server, fast network it gives better performance. then on the AIX server try no -o rfc1323=1 no -o thewall=131072 no -o sb_max=1310720 use vmtune to view virtual memory settings. if the filesystem is jfs you should put maxpgahead to maximum (-R256). stop virtual memory paging by modifying minperm/maxperm parameters (default is -P80, lower it to -P50 but watch minperm). on the client check if compression actually makes files bigger, and check how many retries there are when sending data to server. put TxnGroupMax to the maximum (256) if retries are rare. you can raise TxnByteLimit (maximum is 2097152). MoveBatchSize should be 1000, MoveSizeThresh 500 (2048 for TSM 5.1), set ExpInterval to 0. then pray... Cordiali saluti Gianluca Mariani Tech Support SSD Via Sciangai 53, Roma phones : +39(0)659664598 +393351270554 (mobile) [EMAIL PROTECTED] Francisco Molero [EMAIL PROTECTED]To: [EMAIL PROTECTED] M cc: Sent by: ADSM: Subject: BACKUP to TAPE, PERFORMANCE II Dist Stor Manager [EMAIL PROTECTED] .EDU 05/30/2002 12:33 PM Please respond to ADSM: Dist Stor Manager Hi again, I only use one drive. This is important. Sorry for my previous mail. Client Options: nodename IBM_TEST ERRORLOGRETENTION 5 PASSWORDACCESS GENERATE SCHEDLOGRETENTION 5 SCHEDMODE PROMPTED TCPB32 TCPNYES TCPPORT 1500 TCPSERVERADDRESSTSMSERVER TCPW64 TXNB1048576 largecommbufno Server Options : SELFTUNEBUFpoolsize yes SELFTUNETXNsize yes COMMmethod TCPIP COMMmethod SHAREDMEM COMMmethod HTTP TCPPort 1500 HTTPPort 1580 LOGPoolsize 2048 LANGuage en_US DATEformat 1 TIMEformat 1 MIRRORWRITE DB SEQUENTIAL MSGINTerval 1 MAXSESSIONS 5000 ENABLE3590LIBRARY YES COMMTIMEOUT 600 IDLETIMEOUT 600 bufpoolsize 262144 tcpwindowsize 64 TXNGroupmax 256 TCPBufsize 32 MOVEBatchsize 1000 MoveSizethresh500 USELARGEBUFFERS Yes LOGPoolsize 2048 HW: FC DISKS ( COMPAQ ARRAY) - TSM CLIENT TRU64 (4 PROC and 4GB RAM) - GIGABIT ETH - TSM SERVER 1GB RAM AND 1 PROCESSOR - 3494 with on drive 3590E FC. ___ Copa del Mundo de la FIFA 2002 El znico lugar de Internet con vmdeos de los 64 partidos. !Apzntante ya! en http://fifaworldcup.yahoo.com/fc/es/
Storage Pool Size
I am planning a TSM Server move from OS390/MVS to AIX. My largest storage pool is about 73gig and is spread across 32 volumes of about 2.3gig each. On AIX I will have a 128gig file system so I could put that storage pool into a single volume if that makes sense. My question is should I spread the storage pool across multiple tms volumes and if so what size should I make them? So should I allocate it as one large volume? David
Re: SQL/scripts
You should try the archives (http://www.adsm.org) and also the Scripts Depot at Coderelief (http://www.coderelief.com/depot.htm) Lots of good stuff people on this list have posted there. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Joni Moyer Sent: Wednesday, May 29, 2002 12:33 PM To: [EMAIL PROTECTED] Subject: SQL/scripts Hello! I don't have a reporting package and I was wondering if any on you could tell me some useful scripts that you run on a daily basis? Thanks!!! Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338
special offer: IBM 3590 - 10GB cartridges (450 pcs.)
Hi TSMers, there is a special offer of IBM3590 10GB cartridges (amount approx. 450). Some of them were used for tests (only for a short period of time). The majority of them have never been used. All cartridges have been erased and are therefore useable. The cartridges will be available by mid of June. Interested people from Germany should request more information directly via mail. Regards Moritz Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13
Re: SQL/scripts
I'm not prepared to post our scripts yet but will tell you some of the things that we run daily: Report on failed client schedules - q event * * enddate=today begintime=NOW-23:59 endtime=NOW f=d - filter and report on anything other than completed Report on Client errors (mostly failed files) - select MESSAGE,DOMAINNAME,NODENAME,DATE_TIME from actlog where - (date_timecurrent_timestamp - 1 days and originator='CLIENT' AND SEVERITY='E') - ORDER BY DOMAINNAME,NODENAME - Report on file spaces not backed up in over x days q fi f=d - filter and report on specific nodes and days, depending on complexity could be easier done with SQL - Report on all server error messags and some warning messages reported over last 24 hours - we just do a q actlog then filter for specific messages - we stated with all error messages then slowly filtered out ones we didn't want - we started with no warning\informational and then slowly added ones we wanted - this might be easier with sql but we are using a perl script! - we also run an online error monitor that emails, net sends, or pages us on various errors throughout the day - Daily\weekly processing report - client report from accounting log, reports on gb, transfer rate, media wait ... for backup/restore, archive/retrieve - TSM Health Check every 5 minutes - email and page if TSM is down - TSM System check - checks for things like DB %utilization, # of scratch tapes, stgpool %, db and log volumes synched, db cache hit 98%, log %, disk volumes all online and available, no tapes in error state or specific ones in read only that should not be, cleaning cart close to no uses - report of tapes not written to in over x amount of time (we then reclaim these) Tim Rushforth City of Winnipeg -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: SQL/scripts Hello! I don't have a reporting package and I was wondering if any on you could tell me some useful scripts that you run on a daily basis? Thanks!!! Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338
Re: Question about port configuration...
If asking about prompted mode when server connects to client to tell it to start a schedule, see client option TCPCLIENTPORT -Original Message- From: Keith Kwiatek [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:10 AM To: [EMAIL PROTECTED] Subject: Question about port configuration... Hello, When the tsm client talks to the server it uses 1500. Is there a way to tell the server what port to talk to the client on? Thanks, Keith
Re: /VAR File System on AIX 4.3.3 and TSM Error
/var on AIX can have a lot of temporary files, print files and mail spool files etc. A file is there when TSM gets list of files to back up and is gone when actually tries to backup. I don't worry about. I like to backup up /var anyhow as there is stuff there worth saving (cron jobs, for instance). David Longo [EMAIL PROTECTED] 05/30/02 01:17PM I am getting this error message on my TSM Server and was not sure if these files are cached and replaced with new files causing the ANE4005E error below. Also, is there a specific reason that the /VAR file system should be backed up on a regular basis. Thanks. ANE4005E (Session: 13772, Node: HNAB) Error processing '/var/ha/run/haem.STRT_OH_PROD/Rcache_local/68598,10227- 34875,992213634,0,0.0.0.0': file not found Adam MMS health-first.org made the following annotations on 05/30/02 17:24:30 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==
Re: frame relay nodes-- can I avoid another full backup?
Haven't looked at 5.1 yet, I know there is a new command something like move nodedata. However as you are upgrading OS and rearranging disks, I would take your last option - Rename nodes (rename NODE NODE_OLD), then register new node names and do full backup of new machines. After comfortable period, you can delete old nodes data. (Remember to check schedules, associations follow rename node. Need to delete assoc and associate with new node). David Longo [EMAIL PROTECTED] 05/30/02 01:56PM Hello again, here's the deal- we have approximately 50 frame relay nodes that backup to TSM servers. These NT boxes' drives are almost full (max is 16G on these) and partitions were created to hold data (D:\) and app shares (E:\). We are getting replacements (80G and expandable), and will be xcopying data from the old to the new, but the OS will be 2000. The plan right now is to just create a big D:\ drive and xcopy the files from the old D: and E: drives to this new D: drive. Host names may remain the same, but maybe not-- since we won't be a full 2000 enterprise, and 2000 can't emulate an old NT BDC, the old boxes may remain in the remote locations to serve as the BDCs-- without changing their hostnames. How can I tell/trick TSM to not backup up these new files on a different drive again and to know about previous versions of files with the old drive letter? Or is this issue moot due to the OS change? I can rename the node data and resolve the issue with a full backup due to the change in hostname, but I don't see any way to rename the filespace names to keep from having to do a full backup. I am not up to speed on 5.1, maybe the ability is there with the new code? tia lisa MMS health-first.org made the following annotations on 05/30/02 17:29:16 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==
Changing Storage Pools/Management Classes
Currently, we backup everything either to DISKPOOL (which migrates to LTOTAPE), or directly to LTOTAPE. Files (backup/archive client), databases (TDP for Domino, and TDP for SQL), everything is eventually stored into LTOTAPE. The databases get backed up FULL every time. The largest database we have is ~75GB. The TDP SQL databases are in a different set of management classes from the other files (TDP Domino databases have their own management class, as well). Soon, we will be creating an application that will have a 500GB database. FULL backups for SQL databases will be changing over to FULL with DIFFs (for the larger databases, FULLs on the smaller ones). I would like to segregate the SQL databases into their own tape storage pool. There will be no reclamation on the tapes in this storage pool, and collocation will be turned on, because I will be doing some striped backups. (I don't see the sense in reclaiming tapes when the major databases range in size from 10% to 400% of a tape, but give me a reason to consider it, and I will) What is the best way to handle moving/changing the storage location of my SQL databases from the LTOTAPE storage pool to the LTOSQLTAPE storage pool (I just made that name up). Should I modify the existing management classes to start using the new storage pool? If so, what happens to the files in the current storage pool? Should I create a new management class pointing to the new storage pool and change the INCLUDE statements to point to the new management class? If so, what happens to the files in the current storage pool and the current management class? Is there another way to do this? Thanks in advance for your help. Todd Lundstedt Technical Specialist Via Christi Information Management Services [EMAIL PROTECTED]
Re: select formatting
Select node_name as Node Name from Nodes You may have to add -tab to your dsmadmc command. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Gerald Wichmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 7:16 PM To: [EMAIL PROTECTED] Subject: select formatting The below output is from a simple select statement. I hate to ask this again but its been a while since I've done it and I forget how to format the columns. What I need to do is extract the node names from the backup server so that I can then perform operations on them. How do I increase the width of the column to get the desired effect? I suppose set sqldisplaymode would do it but I'm actually running the select query from a perl script via a dsmadmc command. i.e.: @RESULT = `/opt/Tivoli/tsm/client/admin/bin/dsmadmc -id=admin -pa=admin select node_name from nodes`; returns the below when what I want is to store the node names in an array Obtaining list of nodes on backup server.. Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 2.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server SERVER1: Solaris 7/8 Server Version 4, Release 2, Level 2.0 Server date/time: 05/29/02 23:05:26 Last access: 05/29/02 22:54:56 ANS8000I Server command: 'select node_name from nodes' NODE_NAME -- ORION-41.8-10.0.1- 04.1 ORION-41.8-10.0.1- 72.1 ORION-41.8-10.0.1- 72.3 ORION-41.8-10.0.1- 72.4 ORION-41.8-10.0.1- 72.5 ORION-41.8-10.0.1- 72.7 ORION-41.8-10.0.2- 04.1 ORION-41.8-10.0.2- 04.2 ORION-41.8-10.0.2- 04.3 ORION-41.8-10.0.2- 04.4 ORION-41.8-10.0.2- 04.5 ORION-41.8-10.0.2- 04.7 ANS8002I Highest return code was 0. Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w)
Re: ANR9999D Error message: Do you how to figure out this message?
ANRD is generic error message handling unknown situations. Usually such problems can be resolved only by IBM support due to their rare occurences. The large output is tracing information to help support and developers to analyse the root cause. The only hint I can give you is to perform AUDIT DB but it may show nothing useful. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:ANRD Error message: Do you how to figure out this message? --- O/S: SunOS 5.6 TSM: Version 4, Release 2, Level 1.15 Tape library: scalar 1000 from ADIC Tape drive: AIT2 drive Tape : AIT2 (50GB~100GB) --- Dear All, Situation we face I am wondering where I can get more detailed information about ANRD error message. Actually we have been suffering from so many problems including robot, drive problems and so on. Also we've got many times ANR8300E Changer Failure error msg and then TSM just died...T_T But funny thing is there is no tape stuck in the drive even though the library LCD screen says for example Element 1212(drive12) is obstructed. Last night we had the same problem again and I tried to update the drive12 onlin=no then all the other drives are working fine no more changer failure since the last reboot. So I think this error msg is misled by something else. Please if you had faced similar situation before please get back to me. Questions As you see the log below, I found something going wrong with space reclamation on c3(copy pool for offsite). As soon as I did update stg c3 recl=60 from recl=100( basically no space reclamation), I've got the ANR999D error message. This error msg just never stopped!! Scared and put it back. Then I tried it again after set CONTEXTMESSAGING on to get details. You can see the red marked detailed information about ANR999D msg below but simply I don't know what it means. Can you let me know good reference or any documents? Thanks, Meensun from Tokyo - Activity Log - 05/30/02 16:06:35 ANR2017I Administrator AHNME issued command: UPDATE STGPOOL c3 recl=60 05/30/02 16:06:35 ANR2202I Storage pool C3 updated. 05/30/02 16:06:35 ANR0984I Process 36 for SPACE RECLAMATION started in the BACKGROUND at 16:06:35. 05/30/02 16:06:36 ANR1040I Space reclamation started for volume 005086, storage pool C3 (process number 36). . . . 05/30/02 16:06:36 ANR1040I Space reclamation started for volume 005691, storage pool C3 (process number 36). 05/30/02 16:06:36 ANR1040I Space reclamation started for volume 005973, storage pool C3 (process number 36). 05/30/02 16:06:36 ANRD ssrecons.c(2391): ThreadId50 Actual: Magic=80B93C01, SrvId=-219899260, SegGroupId=14301299977853604355, SeqNum=2031456424, converted=T. 05/30/02 16:06:36 ANRD ssrecons.c(2405): ThreadId50 Expected: Magic=53454652, SrvId=0, SegGroupId=5855761. SeqNum=80. 05/30/02 16:06:38 (50) Context report 05/30/02 16:06:38 (50) SsAuxReconSrcThread : ANRD calling thread 05/30/02 16:06:38 (50) Generating TM Context Report: (struct=tmTxnDesc) (slots=256) 05/30/02 16:06:38 (50) *** no transactions found *** 05/30/02 16:06:38 (50) Generating Database Transaction Table Context: 05/30/02 16:06:38 (50) Tsn=0:37757505 -- Valid=1, inRollback=0, endNTA=0, State=2, Index=7, LatchCount=0, SavePoint=0, TotLogRecs=0, TotLogBytes=0, UndoLogRecs=0, UndoLogBytes=0, LogReserve=0, PageReserve=0, Elapsed=230 (ms), MinLsn=0.0.0, MaxLsn=0.0.0, LastLsn=0.0.0, UndoNextLsn=0.0.0, logWriter=False, backupTxn=False 05/30/02 16:06:38 (50) Open objects: 05/30/02 16:06:38 (50)name -SS.Volume.Names- (sp=0) 05/30/02 16:06:38 (50) *** no transactions found *** 05/30/02 16:06:38 (50) Generating SM Context Report: 05/30/02 16:06:38 (50) *** no sessions found *** 05/30/02 16:06:38 (50) Generating AS Vol Context Report: 05/30/02 16:06:38 (50) No mounted (or mount in progress) volumes. 05/30/02 16:06:38 (50) Generating ssSession Context Report: 05/30/02 16:06:38 (50) No storage service sessions active. 05/30/02 16:06:38 (50) Generating ssOpenSeg Context Report: 05/30/02 16:06:38 (50) Storage Service Segments: 05/30/02
Getting events formatted better????
Hello, I have been using a q event * * node=* begindate=today-1 enddate=today begintime=08:00 endtime=06:30 format=detailed command for quite a while. I output the info into a web page for Operations staff to read. I am tired of having to move the page to the right to see the status. I've got it so that COMPLETED is green and MISSED is red and other conditions are blue. I can use the select node_name from events . for a different output but I don't like the missing info from the q events command. I am looking for a script that rearranges the columns from the q events command to put the node name first and the status second and whatever order I want the rest. I've tried using awk and while it works I can't get the columns lined up nice and neat. Any help out there for this?? -- -- |Mark Brown| |Operations Supervisor | | | |Networking and Communications Services| |Operations| == |Tel --- 514-398-2321| |Fax --- 514-398-6876| |E-mail --- [EMAIL PROTECTED]| --
