Re: many ANR5024W (servermon) messages in actlog
Hi Stefan, You don't need to configure Servermon, at least not the built-in version included at 8.1.7 and above. It's your choice to run it or not and you can also use "setopt alwaysonservermon off" to stop it. However, I'd recommend you address the warning rather than stop it altogether instead. I'm not sure if you are familiar with Servermon or not. It started out as a Perl script outside the server, we have been using this for years for data collection for various types of problems from performance to long running issues where we need data captured at frequent intervals to see the progression of a process or session. The idea behind having it running it all the time is that if you open a case with IBM with a problem that occurred yesterday, support will ask for Servermon from that day, instead of waiting for a reoccurrence of the problem. It's even possible that the problem that occurred yesterday really started 2 weeks ago, so they could go back to that point. There will still be some problems that will require additional data capture, but Servermon will often be the starting point. The warning you are seeing appears to be because the Servermon executable has stopped running. Check if there's a Servermon running, if not you can restart it. You can also use "setopt alwaysonservermon off" to stop it, and set it again to ON to start it. - Thanks, Marc... Marc Lanteigne Spectrum Protect Specialist AVP / SRT 416.478.0233 | marclantei...@ca.ibm.com Office Hours: Monday to Friday, 7:00 to 16:00 Eastern Latest Servermon for Spectrum Protect: http://www-01.ibm.com/support/docview.wss?uid=swg21432937 Performance Mustgather for Spectrum Protect: http://www-01.ibm.com/support/docview.wss?uid=swg22013355 Spectrum Protect Blueprint: https://ibm.biz/BdHc6b Follow me on: Twitter, developerWorks, LinkedIn -Original Message- From: Tsm Tsm Sent: Thursday, April 4, 2019 03:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] many ANR5024W (servermon) messages in actlog hello, every 10 minutes this message appears in actlog. so we do not want to run servermon or even configure it on our spectrum protect server. i only found alwaysonservermon yes as parameter in dsmserv.opt. so i tested alwaysonservermon no and it seems to work. am i right? with best regards stefan savoric
many ANR5024W (servermon) messages in actlog
hello, every 10 minutes this message appears in actlog. so we do not want to run servermon or even configure it on our spectrum protect server. i only found alwaysonservermon yes as parameter in dsmserv.opt. so i tested alwaysonservermon no and it seems to work. am i right? with best regards stefan savoric
Re: full actlog filesystem and IBM support
Sergio, In your email, you have not mentioned the size of the 'archive log'. Depending of the size of the data deduplicated you may need to setup a very large 'archive log'. IBM give some guidelines about the size of the 'actlog' and 'archlog' when using deduplication. Here is the link. http://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.1/com.ibm.itsm.srv.install.doc/c_srv_inst_active_log_space_dedup-linux.html Hope this will help. Paul-André __ *Paul-André Chassé*, B. Sc. Analyste de l'informatique - Centre de calcul scientifique (John-S.-Bourque) Service des technologies de l'information Université de Sherbrooke Tél. : 819 821-8000, poste 62582 Courriel : paul-andre.cha...@usherbrooke.ca Le 2015-08-28 11:50, Sergio O. Fuentes a écrit : I've been working with IBM support on a particular issue that is difficult to recreate and so everytime it happens I have to reopen a new ticket where Level 1 support tells me that it's working by design and then there's no further follow-up. Then I have to argue with them that this needs to be escalated to level 2 and then I still get an update that it's working by design and there's no escalation. So I'm reaching out to this group to see if anyone has experienced this following scenario. Further, I'm hoping IBM developers that monitor this listserv might be able to have my PMR escalated to level 2 and have a closer look taken at it: TSM server 7.1.1.100 Deduplication turned Average about 5-7 TB of nightly backup Replication turned on replicates about 4 TB's of data Issue that I can anecdotally say triggers the behavior: Millions of objects in the dedupdel threads. Anything over 50 million. dsmserv.opt has actlog size to be 128GB actlog filesystem is 256GB TSM should only allocate 128GB of actlog space in the filesystem. After an expiration triggers this dedupdel queue to blow up I see the actlog filesystem filling up to 100%. However q log f=d reports only a small amount of actlog space used. The TSM server is responsive for hours after the filesystem fills up but my OS guys hate me cause they're getting filesystem full alerts. Hours later the dsmserv application will die but db2 remains up. To resolve the issue none of the technotes that exist on IBM's websites help. There's no need to increase the actlog space, but rather what I do is start db2 on its own, let it keep trying to flush the logs for a little while. Then after about 2 hours, I bring up TSM which operates fine since it thinks it's only using a small amount of actlog and we proceed to go back to operations. No problems. But the actlog remains full for several hours or even days later. This happens for us on a monthly basis as we have to purge a lot of dedup data monthly. Any similar issues from anyone? Thanks! Sergio
full actlog filesystem and IBM support
I've been working with IBM support on a particular issue that is difficult to recreate and so everytime it happens I have to reopen a new ticket where Level 1 support tells me that it's working by design and then there's no further follow-up. Then I have to argue with them that this needs to be escalated to level 2 and then I still get an update that it's working by design and there's no escalation. So I'm reaching out to this group to see if anyone has experienced this following scenario. Further, I'm hoping IBM developers that monitor this listserv might be able to have my PMR escalated to level 2 and have a closer look taken at it: TSM server 7.1.1.100 Deduplication turned Average about 5-7 TB of nightly backup Replication turned on replicates about 4 TB's of data Issue that I can anecdotally say triggers the behavior: Millions of objects in the dedupdel threads. Anything over 50 million. dsmserv.opt has actlog size to be 128GB actlog filesystem is 256GB TSM should only allocate 128GB of actlog space in the filesystem. After an expiration triggers this dedupdel queue to blow up I see the actlog filesystem filling up to 100%. However q log f=d reports only a small amount of actlog space used. The TSM server is responsive for hours after the filesystem fills up but my OS guys hate me cause they're getting filesystem full alerts. Hours later the dsmserv application will die but db2 remains up. To resolve the issue none of the technotes that exist on IBM's websites help. There's no need to increase the actlog space, but rather what I do is start db2 on its own, let it keep trying to flush the logs for a little while. Then after about 2 hours, I bring up TSM which operates fine since it thinks it's only using a small amount of actlog and we proceed to go back to operations. No problems. But the actlog remains full for several hours or even days later. This happens for us on a monthly basis as we have to purge a lot of dedup data monthly. Any similar issues from anyone? Thanks! Sergio
Re: Best practices on filesystem for DB and ACTLOG on RHEL7
Robert: According to this document: http://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.1/com.ibm.itsm.perf.doc/t_perf_diskos_lnx.html - Use Linux Logical Volume Manager (LVM) to create logical volumes on the disk LUNs for all disks that are used for Tivoli Storage Manager components. Set the LVM read-ahead to 0 for all logical volumes on disk systems that provide adaptive read-ahead capabilities, for example, enterprise-type disk systems. If more space is needed, the logical volumes provide an easy way to extend the volumes and file systems. LVM also provides striping, which can be used to improve sequential I/O performance. - For the Tivoli Storage Manager database and logs, use either the ext3 or ext4 file system. As a best practice, use the following file system that is appropriate for your operating system and level: - For Red Hat Enterprise Linux x86_64, use the ext3 or ext4 file system. Use the ext4 file system only if Red Hat Enterprise Linux 6.4 or later is installed. - For SUSE Linux Enterprise Server and for Red Hat Enterprise Linux ppc64, use the ext3 file system. - For Tivoli Storage Manager storage pools, use the ext4 file system. The ext4 file system has the following advantages for use with storage pools: - You do not have to write out each block I/O to allocate the storage pool volume, which improves the performance of the DEFINE VOLUME command. - You can avoid file and free space fragmentation, which improves read and write performance. - When you define new volumes, the Tivoli Storage Manager server activities that are running are not negatively affected. Best regards, Mike, x7942 RMD IT Client Services On Sun, Mar 22, 2015 at 5:04 PM, Robert Lejtorp wrote: > Hi > > I'm about to install a new TSM 7.1.1 server on RHEL7 and would like to > have some input on what file system to use, and if I should consider any > special options. > > My first concerns is about the volumes where I intend place the DB and the > actlog. > We have an IBM x3650 M4 and five 400 GB SSD-drives (SATA-connector) in an > hw-RAID5 setup to be used by TSM-DB and the actlog. > The OS, arch-log and some space to be used for meta-data from TSM4VE > backups is located on another hw-RAID5 of five SAS-volumes. > > Default file system in RHEL7 is now xfs, and my question is if I should > stick to what RedHat suggests or if I should go for EXT4 for some reason. > Are there any special concerns to keep in mind for performance (like > allocation group size and stripe units on xfs) or will "standard" do the > work equally good ? > > The blueprint for TSM server on Linux_x86 specifies ext4, but it's for > TSM7.1 and RHEL6.4 > > Best regards > Robert Lejtorp > Compose IT >
Re: Best practices on filesystem for DB and ACTLOG on RHEL7
SSDs should work well for the DB and active log. As for the filesystem, you'll want to use ext4. I don't know that IBM has documented filesystem restrictions for DB2 wrt TSM, but certainly for standalone DB2 they recommend only ext2/3 (and presumably now ext4) and reiserfs due to their direct I/O implementations: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0051304.html On Sun, Mar 22, 2015 at 09:04:08PM +, Robert Lejtorp wrote: > Hi > > I'm about to install a new TSM 7.1.1 server on RHEL7 and would like to have > some input on what file system to use, and if I should consider any special > options. > > My first concerns is about the volumes where I intend place the DB and the > actlog. > We have an IBM x3650 M4 and five 400 GB SSD-drives (SATA-connector) in an > hw-RAID5 setup to be used by TSM-DB and the actlog. > The OS, arch-log and some space to be used for meta-data from TSM4VE backups > is located on another hw-RAID5 of five SAS-volumes. > > Default file system in RHEL7 is now xfs, and my question is if I should stick > to what RedHat suggests or if I should go for EXT4 for some reason. > Are there any special concerns to keep in mind for performance (like > allocation group size and stripe units on xfs) or will "standard" do the work > equally good ? > > The blueprint for TSM server on Linux_x86 specifies ext4, but it's for TSM7.1 > and RHEL6.4 > > Best regards > Robert Lejtorp > Compose IT -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
Best practices on filesystem for DB and ACTLOG on RHEL7
Hi I'm about to install a new TSM 7.1.1 server on RHEL7 and would like to have some input on what file system to use, and if I should consider any special options. My first concerns is about the volumes where I intend place the DB and the actlog. We have an IBM x3650 M4 and five 400 GB SSD-drives (SATA-connector) in an hw-RAID5 setup to be used by TSM-DB and the actlog. The OS, arch-log and some space to be used for meta-data from TSM4VE backups is located on another hw-RAID5 of five SAS-volumes. Default file system in RHEL7 is now xfs, and my question is if I should stick to what RedHat suggests or if I should go for EXT4 for some reason. Are there any special concerns to keep in mind for performance (like allocation group size and stripe units on xfs) or will "standard" do the work equally good ? The blueprint for TSM server on Linux_x86 specifies ext4, but it's for TSM7.1 and RHEL6.4 Best regards Robert Lejtorp Compose IT
AW: Disabling the library sharing actlog messages
Hallo Grant, you could do this kind of filtering also with the TSM Power Administrator. In your case you could filter the q act output so that ANR0408I and ANR0409I messages are not displayed. If you want more information, pls contact me offline this list. Thanks and rgds mikel. michael.mal...@mm-it.at -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Grant Street Gesendet: Mittwoch, 20. Juni 2012 10:31 An: ADSM-L@VM.MARIST.EDU Betreff: Disabling the library sharing actlog messages Hello I was wondering if anyone had an idea on how to disable the "library sharing" messages from the actlog? here's some stats I have dsmserv redirect stdout and stderr to a log file. This log file is currently 158811 lines for less than 8 hours. If I remove the ANR0409I and ANR0408I lines I get 1645 lines. So these library sharing messages account for 99% of the actlog's content. I continually get the following ANR0408I Session 54932 started for server (Linux/x86_64) (Tcp/Ip) for library sharing. ANR0409I Session 54932 ended for server (Linux/x86_64). This makes it nigh on impossible to use q actlog without capturing 1000 library sharing messages, and the log file does not contain the timestamps. It doesn't look like I can use ! as a not etc. Any other help full information? Grant
Re: Disabling the library sharing actlog messages
On 06/20/2012 08:38 AM, Neil Schofield wrote: I personally wouldn't choose to do this, because for troubleshooting purposes I rely on my actlog to be an authoritative source of everything the server has done. I mainly use it to prevent messages I don't care about (such as ANR0944E) from going to other receivers such as the Windows application event log. What he said, with enlargement: I'm a firm fan of keeping the activity logs essentially forever. I would reframe your problem description, Grant, as a query-interface issue, not a data storage issue. The q actlog interface is Not Intended For That, and I think they're right not to try to get a whole analytic engine in there at the command line. Here's what I do, in a nutshell: Every day, for every server instance, at about 00:05, I drop "yesterday's" actlog into a compressed file. They compress really well, more than 10x just with gzip. Well enough that I haven't bothered going back and making them do bz2. Then, I have a script which walks through the actlogs. 1) it applies an extensive list of "I don't really care much about this sort of line", with reasons. These get dumped. my $ignore = { 'ANE4952I' => "Client session postmortem", 'ANE4953I' => "Client session postmortem", [...] 'ANR0402I' => "Server session start", [...] 'ANR0811I' => "Expiration Processing", } 2) it identifies lines which I want to forward to those responsible for a TSM artifact, with regexps for how to extract the artifact in question. These get filed, and at the end of the log run, they get emailed to the responsible parties. my $collect = { '' => "Node: (\\S+)\\\)\\s", [...] 'ANR0425W' => "node (\\S+)\\s", 'ANR0479W' => "server (\\S+)\\s", [...] 'ANR2716E' => "client (\\S+)\\s", } 3) All the rest of the messages get sent to "Central TSM admins" (aka me and some folks who don't read it. ;) ) So: In Grant's case, I'd put those messages... (looks..) Aha. In fact, I _have_ those messages in my ignore list. :) but they're still in my actlog repository, so when I e.g. want to analyze frequency of mount actions per-server since inception, to support an assertion about my infrastructure, I can still do it. Here. Yesterday I was working on an occupation graph dating to the point I adopted my current architecture. http://open-systems.ufl.edu/static/asr-pub/servers-5000.pdf Incredibly useful to keep the data. I can do the same thing for mount behavior. - Allen S. Rout
Re: Disabling the library sharing actlog messages
Grant I've not tried it, but I imagine you can disable specific events from appearing in either the console or the activity log using, for example DISABLE EVENTS ACTLOG ANR0408 DISABLE EVENTS ACTLOG ANR0409 I personally wouldn't choose to do this, because for troubleshooting purposes I rely on my actlog to be an authoritative source of everything the server has done. I mainly use it to prevent messages I don't care about (such as ANR0944E) from going to other receivers such as the Windows application event log. But in terms of the problem you stated, I would imagine you can tweak it to meet you requirements. Regards Neil Schofield Technical Leader Yorkshire Water Spotted a leak? If you spot a leak please report it immediately. Call us on 0800 57 3553 or go to http://www.yorkshirewater.com/leaks Get a free water saving pack Don't forget to request your free water and energy saving pack, it could save you money on your utility bills and help you conserve water. http://www.yorkshirewater.com/savewater The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House, Halifax Road, Bradford, BD6 2SZ Registered in England and Wales No 2366682
Re: Disabling the library sharing actlog messages
Please remove me from the email distribution list. Thanks The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: Disabling the library sharing actlog messages
Use the "disable events" command to specify the messages that you no longer want to see. There are many options to remove particular event messages from the activity log, computer event log, etc. Reference the help section from the CLI for all options. ~Rick Adamson Jax, Fl. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Grant Street Sent: Wednesday, June 20, 2012 4:31 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Disabling the library sharing actlog messages Hello I was wondering if anyone had an idea on how to disable the "library sharing" messages from the actlog? here's some stats I have dsmserv redirect stdout and stderr to a log file. This log file is currently 158811 lines for less than 8 hours. If I remove the ANR0409I and ANR0408I lines I get 1645 lines. So these library sharing messages account for 99% of the actlog's content. I continually get the following ANR0408I Session 54932 started for server (Linux/x86_64) (Tcp/Ip) for library sharing. ANR0409I Session 54932 ended for server (Linux/x86_64). This makes it nigh on impossible to use q actlog without capturing 1000 library sharing messages, and the log file does not contain the timestamps. It doesn't look like I can use ! as a not etc. Any other help full information? Grant
Disabling the library sharing actlog messages
Hello I was wondering if anyone had an idea on how to disable the "library sharing" messages from the actlog? here's some stats I have dsmserv redirect stdout and stderr to a log file. This log file is currently 158811 lines for less than 8 hours. If I remove the ANR0409I and ANR0408I lines I get 1645 lines. So these library sharing messages account for 99% of the actlog's content. I continually get the following ANR0408I Session 54932 started for server (Linux/x86_64) (Tcp/Ip) for library sharing. ANR0409I Session 54932 ended for server (Linux/x86_64). This makes it nigh on impossible to use q actlog without capturing 1000 library sharing messages, and the log file does not contain the timestamps. It doesn't look like I can use ! as a not etc. Any other help full information? Grant
Re: TSM 5.5 actlog size..
i copy records daily to a MySQL database, where i keep a year's worth of data. i can then keep the retention period low on the TSM database. MySQL is running on a salvaged box from the trash pile (it actually took several boxes to make up one good one), running CentOS Linux. reporting is done using Perl and Apache, with no impact on the TSM server and zero cost. On 11/17/2011 03:35 PM, Ajay Patel wrote: > Hi, > > On one of my tsm server Activity Log Size: 3,742 M so it is very > difficult to get information from actlog - response time for 24 hour is > too high and if we query for more then 24 hr then not sure on output... > > Could you please suggest the solution without touching retention period > ?.. TSM server version - 5.5 .4.3 on AIX > > > Regards, > Ajay Patel - NOTICE: This communication is intended only for the person or entity to whom it is addressed and may contain confidential, proprietary, and/or privileged material. Unless you are the intended addressee, any review, reliance, dissemination, distribution, copying or use whatsoever of this communication is strictly prohibited. If you received this in error, please reply immediately and delete the material from all computers. Email sent through the Internet is not secure. Do not use email to send us confidential information such as credit card numbers, PIN numbers, passwords, Social Security Numbers, Account numbers, or other important and confidential information.
Antwort: Re: [ADSM-L] TSM 5.5 actlog size..
One of our customers run a cron job every four hours that dumps the activity log to disk using SQL statement "select date(date_time) date, time(date_time) time, msgno, process, session, message from actlog where date(current_timestamp)=date(date_time) and cast((current_timestamp-date_time) hours as integer)<4". Results are analysed in batch and archived (with delete) automatically to TSM on a daily basis. Works much faster than "q actlog". And makes it easy to minimize space used by the actlog in TSM - by now, only 7 days are kept online and the customer thinks about reducing it again... regards Ullrich - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil: +49 170 7678434 Fax: +49 69 38013500 10 Web: http://www.fum.de Amtsgericht Ulm, Handelsregister-Nummer: HRB 1936 Geschäftsführer: Heribert Fritz, Oliver Schallhorn, Frank Haines Inhaber: Imtech N.V., Gouda, Niederlande Referenzen finden Sie auf unserer Website, Rubrik 'News'. Von:James Choate An: ADSM-L@VM.MARIST.EDU Datum: 18.11.2011 17:07 Betreff:Re: [ADSM-L] TSM 5.5 actlog size.. Gesendet von: "ADSM: Dist Stor Manager" Upgrade to 6.2.3. Much faster :) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ajay Patel Sent: Thursday, November 17, 2011 1:35 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM 5.5 actlog size.. Hi, On one of my tsm server Activity Log Size: 3,742 M so it is very difficult to get information from actlog - response time for 24 hour is too high and if we query for more then 24 hr then not sure on output... Could you please suggest the solution without touching retention period ?.. TSM server version - 5.5 .4.3 on AIX Regards, Ajay Patel
Re: TSM 5.5 actlog size..
Upgrade to 6.2.3. Much faster :) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ajay Patel Sent: Thursday, November 17, 2011 1:35 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM 5.5 actlog size.. Hi, On one of my tsm server Activity Log Size: 3,742 M so it is very difficult to get information from actlog - response time for 24 hour is too high and if we query for more then 24 hr then not sure on output... Could you please suggest the solution without touching retention period ?.. TSM server version - 5.5 .4.3 on AIX Regards, Ajay Patel
TSM 5.5 actlog size..
Hi, On one of my tsm server Activity Log Size: 3,742 M so it is very difficult to get information from actlog - response time for 24 hour is too high and if we query for more then 24 hr then not sure on output... Could you please suggest the solution without touching retention period ?.. TSM server version - 5.5 .4.3 on AIX Regards, Ajay Patel
TSM v6 How to SELECT output sequence of actlog (summary) in true date time sequence?
I don't see an exposed unique key on actlog/summary/events. I would like to get it in the same order TSM v3,4,5 did by default- in the sequence the rows were posted. In particular, I would like to see the start session at the top and the end session at the bottom. I realize the "events" can be posted in slightly different sequence, due to multi-threading/multi-tasking. Maybe a unique key column, or use that .00 at the end of the date_time to actually mean something. Or maybe I am missing something in the manuals. Thanks for any pointers. Select w/o order by: dsmadmc -id=rcowen -pa=pxx -comma select * from actlog where DATE_TIME between '05/05/2009 07:00:00' and '05/06/2009 07:00:00' > f:\actlog.csv F:\>find "2650" actlog.csv -- ACTLOG.CSV 2009-05-05 13:48:33.00,4958,I,ANE4958I Total number of objects updated: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4960,I,ANE4960I Total number of objects rebound: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4957,I,ANE4957I Total number of objects deleted: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4970,I,ANE4970I Total number of objects expired: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,403,I,ANR0403I Session 2650 ended for node LAB-1750-151 (WinNT). (SESSION: 2650),SERVER,,,2650, 2009-05-05 13:48:33.00,4953,I,ANE4953I Total number of objects archived:81 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:29.00,406,I,ANR0406I Session 2650 started for node LAB-1750-151 (WinNT) (Tcp/Ip LAB-1750-151(4007)). (SESSION: 2650),SERVER,,,2650, 2009-05-05 13:48:33.00,4952,I,ANE4952I Total number of objects inspected: 81 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4959,I,ANE4959I Total number of objects failed: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4961,I,ANE4961I Total number of bytes transferred: 17.50 MB (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4963,I,ANE4963I Data transfer time: 0.92 sec (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4966,I,"ANE4966I Network data transfer rate: 19,419.35 KB/sec (SESSION: 2650)",CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,26 50, 2009-05-05 13:48:33.00,4967,I,"ANE4967I Aggregate data transfer rate: 5,911.63 KB/sec (SESSION: 2650)",CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,26 50, 2009-05-05 13:48:33.00,4968,I,ANE4968I Objects compressed by: 0% (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4964,I,ANE4964I Elapsed processing time: 00:00:03 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,2507,I,ANR2507I Schedule ARCHIVE_HOURLY for domain STANDARD started at 05/05/2009 13:48:18 for node LAB-1750-151 completed successfully at 05/05/2009 13:48:33. (SESSION: 2650),SERVER,,,2650, Select with order by: dsmadmc -id=rcowen -pa=xx -comma select * from actlog where DATE_TIME between '05/05/2009 07:00:00' and '05/06/2009 07:00:00' order by date_time > f:\actlog.csv F:\>find "2650" actlog.csv -- ACTLOG.CSV 2009-05-05 13:48:29.00,406,I,ANR0406I Session 2650 started for node LAB-1750-151 (WinNT) (Tcp/Ip LAB-1750-151(4007)). (SESSION: 2650),SERVER,,,2650, 2009-05-05 13:48:33.00,4958,I,ANE4958I Total number of objects updated: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4960,I,ANE4960I Total number of objects rebound: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4957,I,ANE4957I Total number of objects deleted: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,4970,I,ANE4970I Total number of objects expired: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.00,403,I,ANR0403I Session 2650 ended for node LAB-1750-151 (WinNT). (SESSION: 2650),SERVER,,,2650, 2009-05-05 13:48:33.00,4953,I,ANE4953I Total number of objects archived:81 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,2
Re: Search actlog for issued messages
On Feb 10, 2009, at 1:05 PM, Tim Brown wrote: Have script that needs to issue a message like "Daily Migration of Storage Pool SERVER_DISK Complete" In the same script want to q the actlog to see if it was issued. ... Have a look at the ISSUE MESSAGE command description in the Admin Ref manual. Richard Sims
Re: Search actlog for issued messages
Look at the ANR codes related to the messages and include a "msg= for just the activity related to the script. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tim Brown Sent: Tuesday, February 10, 2009 1:06 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Search actlog for issued messages Have script that needs to issue a message like "Daily Migration of Storage Pool SERVER_DISK Complete" In the same script want to q the actlog to see if it was issued. Even when its not issued the query commands finds it anyway since it was part of a search commmand" How can I check for the message only if it was issued and not get find results back just because I issued the search command for it. Tim Brown Systems Specialist - Project Leader Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com <mailto:tbr...@cenhud.com> Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please notify the sender immediately by replying to this note and deleting all copies and attachments. Thank you. IMPORTANT: E-mail sent through the Internet is not secure and timely delivery of Internet mail is not guaranteed. Legg Mason therefore, recommends that you do not send any action-oriented or time-sensitive information to us via electronic mail, or any confidential or sensitive information including: social security numbers, account numbers, or personal identification numbers. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Search actlog for issued messages
Have script that needs to issue a message like "Daily Migration of Storage Pool SERVER_DISK Complete" In the same script want to q the actlog to see if it was issued. Even when its not issued the query commands finds it anyway since it was part of a search commmand" How can I check for the message only if it was issued and not get find results back just because I issued the search command for it. Tim Brown Systems Specialist - Project Leader Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com <mailto:tbr...@cenhud.com> Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please notify the sender immediately by replying to this note and deleting all copies and attachments. Thank you.
ANR8213E error in actlog
TSMee 5.3.6 on RHEL 4.5 on x86_64 Spotted this error in actlog ANR8213E Socket 150 aborted due to send error; error 32. It has been logged on numerous occasions during different times. I have yet to find out if it has any ill effects on the server. Quick google lookup brought this: <http://www-1.ibm.com/support/docview.wss?rs=663&context=SSGSG7&dc=DB550&uid=swg1IC54174&loc=en_US&cs=UTF-8&lang=en&rss=ct663tivoli> but it doesn't appear the same error message.. So I'm not sure how to act... Anyone can enlighten me maybe with respect to this error? -- Warm regards, Michael Green
Re: Query actlog
Thanks everybody > -Message d'origine- > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De > la part de Choudarapu, Ramakrishna (GTI) > Envoyé : jeudi 11 octobre 2007 14:16 > À : ADSM-L@VM.MARIST.EDU > Objet : Re: [ADSM-L] Query actlog > > Q ACTLOG can be searched using MSGno, Search string, > nodename, client or server originated messages, by > domain/sched/session... > If you wish to search by multiple strings, I think it is > better to dump it to a file and play around using your string > handling capabilities... > > Cheers, > Rama > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Andrew Raibeck > Sent: Thursday, October 11, 2007 7:35 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Query actlog > > > If by "multiple criteria" you mean specifying, for example, > multiple MSGNO parameters, then the answer is "no". As an > alternative, you can use SELECT with the ACTLOG table to do > that type of query. > > Regards, > > Andy > > Andy Raibeck > IBM Software Group > Tivoli Storage Manager Client Product Development Level 3 > Team Lead Internal Notes e-mail: Andrew > Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] > > IBM Tivoli Storage Manager support web page: > http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli > StorageMan > ager.html > > The only dumb question is the one that goes unasked. > The command line is your friend. > "Good enough" is the enemy of excellence. > > "ADSM: Dist Stor Manager" wrote on 10/11/2007 > 01:55:54 AM: > > > Hi, > > > > Is there a way to associate multiple criterias on a query actlog > search= > > > > Pierre > > > This message w/attachments (message) may be privileged, > confidential or proprietary, and if you are not an intended > recipient, please notify the sender, do not use or share it > and delete it. Unless specifically indicated, this message is > not an offer to sell or a solicitation of any investment > products or other financial product or service, an official > confirmation of any transaction, or an official statement of > Merrill Lynch. Subject to applicable law, Merrill Lynch may > monitor, review and retain e-communications (EC) traveling > through its networks/systems. The laws of the country of each > sender/recipient may impact the handling of EC, and EC may be > archived, supervised and produced in countries other than the > country in which you are located. This message cannot be > guaranteed to be secure or error-free. This message is > subject to terms available at the following link: > http://www.ml.com/e-communications_terms/. By messaging with > Merrill Lynch you consent to the foregoing. > >
Re: Query actlog
Q ACTLOG can be searched using MSGno, Search string, nodename, client or server originated messages, by domain/sched/session... If you wish to search by multiple strings, I think it is better to dump it to a file and play around using your string handling capabilities... Cheers, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Thursday, October 11, 2007 7:35 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Query actlog If by "multiple criteria" you mean specifying, for example, multiple MSGNO parameters, then the answer is "no". As an alternative, you can use SELECT with the ACTLOG table to do that type of query. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan ager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 10/11/2007 01:55:54 AM: > Hi, > > Is there a way to associate multiple criterias on a query actlog search= > > Pierre This message w/attachments (message) may be privileged, confidential or proprietary, and if you are not an intended recipient, please notify the sender, do not use or share it and delete it. Unless specifically indicated, this message is not an offer to sell or a solicitation of any investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Merrill Lynch. Subject to applicable law, Merrill Lynch may monitor, review and retain e-communications (EC) traveling through its networks/systems. The laws of the country of each sender/recipient may impact the handling of EC, and EC may be archived, supervised and produced in countries other than the country in which you are located. This message cannot be guaranteed to be secure or error-free. This message is subject to terms available at the following link: http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you consent to the foregoing.
Re: Query actlog
If by "multiple criteria" you mean specifying, for example, multiple MSGNO parameters, then the answer is "no". As an alternative, you can use SELECT with the ACTLOG table to do that type of query. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 10/11/2007 01:55:54 AM: > Hi, > > Is there a way to associate multiple criterias on a query actlog search= > > Pierre
Query actlog
Hi, Is there a way to associate multiple criterias on a query actlog search= Pierre
Re: Actlog file location
The actlog doesn't exist as a separate entity. All entries are stored in the TSM database, for a length of time specified by 'set actlgoretention' If you are after the entire contents of you activity log as a file, you could Q actlog begind=-999 endd=today >> outputfile (I'm assuming you havent currently got actlogretention higher than 999!) Matt. www.tsmwiki.com/tsmwiki/setactlogretention > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Gopinathan, Srinath > Sent: 31 October 2006 11:55 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Actlog file location > > Hi Karel, > > Thanks for the prompt reply. > > It would be great if you could let me know on how to find it. > > Regards, > Srinath G > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of > Bos, Karel > Sent: 31 October 2006 11:46 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Actlog file location > > Hi, > > Its in de ITSM server database. > > Regards, > > Karel > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of > Gopinathan, Srinath > Sent: dinsdag 31 oktober 2006 12:41 > To: ADSM-L@VM.MARIST.EDU > Subject: Actlog file location > > Hi All, > > Can anybody let me know where the actlog files are stored > > Regards, > Srinath G > > > > This e-mail has been scanned for viruses by the Cable & > Wireless e-mail security system - powered by MessageLabs. For > more information on a proactive managed e-mail security > service, visit http://www.cw.com/uk/emailprotection/ > > The information contained in this e-mail is confidential and > may also be subject to legal privilege. It is intended only > for the recipient(s) named above. If you are not named above > as a recipient, you must not read, copy, disclose, forward or > otherwise use the information contained in this email. If you > have received this e-mail in error, please notify the sender > (whose contact details are above) immediately by reply e-mail > and delete the message and any attachments without retaining > any copies. > > > > This email is confidential and may be privileged. If you are not the intended recipient please notify the sender immediately and delete the email from your computer. You should not copy the email, use it for any purpose or disclose its contents to any other person. Please note that any views or opinions presented in this email may be personal to the author and do not necessarily represent the views or opinions of Digica. It is the responsibility of the recipient to check this email for the presence of viruses. Digica accepts no liability for any damage caused by any virus transmitted by this email. UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK Reception Tel: + 44 (0) 115 977 1177 Support Centre: 0845 607 7070 Fax: + 44 (0) 115 977 7000 http://www.digica.com SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535, South Africa Tel: + 27 (0) 21 957 4900 Fax: + 27 (0) 21 948 3135 http://www.digica.com
Re: Actlog file location
QUERY ACTLOG Try HELP Q ACTLOG, for syntax... Regards, Ramakrishna -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: Tuesday, October 31, 2006 6:55 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Actlog file location Hi Karel, Thanks for the prompt reply. It would be great if you could let me know on how to find it. Regards, Srinath G -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bos, Karel Sent: 31 October 2006 11:46 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Actlog file location Hi, Its in de ITSM server database. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: dinsdag 31 oktober 2006 12:41 To: ADSM-L@VM.MARIST.EDU Subject: Actlog file location Hi All, Can anybody let me know where the actlog files are stored Regards, Srinath G This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: Actlog file location
Hi Karel, Thanks for the prompt reply. It would be great if you could let me know on how to find it. Regards, Srinath G -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bos, Karel Sent: 31 October 2006 11:46 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Actlog file location Hi, Its in de ITSM server database. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: dinsdag 31 oktober 2006 12:41 To: ADSM-L@VM.MARIST.EDU Subject: Actlog file location Hi All, Can anybody let me know where the actlog files are stored Regards, Srinath G This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.
Re: Actlog file location
Hi, Its in de ITSM server database. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: dinsdag 31 oktober 2006 12:41 To: ADSM-L@VM.MARIST.EDU Subject: Actlog file location Hi All, Can anybody let me know where the actlog files are stored Regards, Srinath G This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. ÿþD i t b e r i c h t i s v e r t r o u w e l i j k e n k a n g e h e i m e i n f o r m a t i e b e v a t t e n e n k e l b e s t e m d v o o r d e g e a d r e s s e e r d e . I n d i e n d i t b e r i c h t n i e t v o o r u i s b e s t e m d , v e r z o e k e n w i j u d i t o n m i d d e l l i j k a a n o n s t e m e l d e n e n h e t b e r i c h t t e v e r n i e t i g e n . A a n g e z i e n d e i n t e g r i t e i t v a n h e t b e r i c h t n i e t v e i l i g g e s t e l d i s m i d d e l s v e r z e n d i n g v i a i n t e r n e t , k a n A t o s O r i g i n n i e t a a n s p r a k e l i j k w o r d e n g e h o u d e n v o o r d e i n h o u d d a a r v a n . H o e w e l w i j o n s i n s p a n n e n e e n v i r u s v r i j n e t w e r k t e h a n t e r e n , g e v e n w i j g e e n e n k e l e g a r a n t i e d a t d i t b e r i c h t v i r u s v r i j i s , n o c h a a n v a a r d e n w i j e n i g e a a n s p r a k e l i j k h e i d v o o r d e m o g e l i j k e a a n w e z i g h e i d v a n e e n v i r u s i n d i t b e r i c h t . O p a l o n z e r e c h t s v e r h o u d i n g e n , a a n b i e d i n g e n e n o v e r e e n k o m s t e n w a a r o n d e r A t o s O r i g i n g o e d e r e n e n / o f d i e n s t e n l e v e r t z i j n m e t u i t s l u i t i n g v a n a l l e a n d e r e v o o r w a a r d e n d e L e v e r i n g s v o o r w a a r d e n v a n A t o s O r i g i n v a n t o e p a s s i n g . D e z e w o r d e n u o p a a n v r a a g d i r e c t k o s t e l o o s t o e g e z o n d e n . T h i s e - m a i l a n d t h e d o c u m e n t s a t t a c h e d a r e c o n f i d e n t i a l a n d i n t e n d e d s o l e l y f o r t h e a d d r e s s e e ; i t m a y a l s o b e p r i v i l e g e d . I f y o u r e c e i v e t h i s e - m a i l i n e r r o r , p l e a s e n o t i f y t h e s e n d e r i m m e d i a t e l y a n d d e s t r o y i t . A s i t s i n t e g r i t y c a n n o t b e s e c u r e d o n t h e I n t e r n e t , t h e A t o s O r i g i n g r o u p l i a b i l i t y c a n n o t b e t r i g g e r e d f o r t h e m e s s a g e c o n t e n t . A l t h o u g h t h e s e n d e r e n d e a v o u r s t o m a i n t a i n a c o m p u t e r v i r u s - f r e e n e t w o r k , t h e s e n d e r d o e s n o t w a r r a n t t h a t t h i s t r a n s m i s s i o n i s v i r u s - f r e e a n d w i l l n o t b e l i a b l e f o r a n y d a m a g e s r e s u l t i n g f r o m a n y v i r u s t r a n s m i t t e d . O n a l l o f f e r s a n d a g r e e m e n t s u n d e r w h i c h A t o s O r i g i n s u p p l i e s g o o d s a n d / o r s e r v i c e s o f w h a t e v e r n a t u r e , t h e T e r m s o f D e l i v e r y f r o m A t o s O r i g i n e x c l u s i v e l y a p p l y . T h e T e r m s o f D e l i v e r y s h a l l b e p r o m p t l y s u b m i t t e d t o y o u o n y o u r r e q u e s t
Actlog file location
Hi All, Can anybody let me know where the actlog files are stored Regards, Srinath G This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.
Re: Sessions in Actlog
Aravind - As I alluded, the essence of the sessions is recorded in the dsmaccnt.log file, which everyone should have turned on, for historical reporting. I provide a sample reporting program in my Web area for processing, if you have nothing else, which you can readily modify to expose all the info you want. Or, you can simply examine its textual content. Session numbers are not recorded in the accounting file, but whereas the Producer's life encompasses that of its Consumer "children", the association is rather apparent within the timespan for the client - particularly for scheduled processes, in that client scheduling is serial. See the Admin Guide manual for the authoritative documentation on the accounting log, and my dsmaccnt.log notes in ADSM QuickFacts for accumulated notes on contents. Richard Sims http://people.bu.edu/rbs On Oct 30, 2006, at 2:11 PM, Aravind Kurapati wrote: Richard, An initial test shows that the commands return data only for active sessions. Is this maintained historically anywhere? Also, how can I determine which "Producer" process the various "Consumer" processes are tied to? Thanks Aravind -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Monday, October 30, 2006 2:50 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Sessions in Actlog On Oct 30, 2006, at 8:02 AM, Aravind Kurapati wrote: Is there any way to query the relationship between Session numbers in actlog and a TSM job? It is quite common to find multiple sessions for the same job Aravind - There's no ready way that I know of to relate the Producer and Consumer sessions resulting from RESOURceutilization > 1. The Producer, being the session in charge, will show a start time (in 'select * from sessions') which is as early or earliest of any session for that node, and will typically show a LAST_VERB of Ping, rather than BackInsNormEnhanced or the like. In 'SHow SESSions' output, the Producer will show SessType=5 for a scheduled process, with its Consumer "children" being SessType=4; and the Producer will not transfer data, so its Backup and Archive object count will be zero. (But, in a manual 'dsmc', the sessions will all be SessType=4.) You will also see these session type numbers in the dsmaccnt.log records. So, to the best of my knowledge, this is all a matter of discerning, rather than readily determining. Richard Sims
Re: Sessions in Actlog
Richard, An initial test shows that the commands return data only for active sessions. Is this maintained historically anywhere? Also, how can I determine which "Producer" process the various "Consumer" processes are tied to? Thanks Aravind -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Monday, October 30, 2006 2:50 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Sessions in Actlog On Oct 30, 2006, at 8:02 AM, Aravind Kurapati wrote: > Is there any way to query the relationship between Session numbers > in actlog > and a TSM job? It is quite common to find multiple sessions for the > same job Aravind - There's no ready way that I know of to relate the Producer and Consumer sessions resulting from RESOURceutilization > 1. The Producer, being the session in charge, will show a start time (in 'select * from sessions') which is as early or earliest of any session for that node, and will typically show a LAST_VERB of Ping, rather than BackInsNormEnhanced or the like. In 'SHow SESSions' output, the Producer will show SessType=5 for a scheduled process, with its Consumer "children" being SessType=4; and the Producer will not transfer data, so its Backup and Archive object count will be zero. (But, in a manual 'dsmc', the sessions will all be SessType=4.) You will also see these session type numbers in the dsmaccnt.log records. So, to the best of my knowledge, this is all a matter of discerning, rather than readily determining. Richard Sims
Re: Sessions in Actlog
On Oct 30, 2006, at 8:02 AM, Aravind Kurapati wrote: Is there any way to query the relationship between Session numbers in actlog and a TSM job? It is quite common to find multiple sessions for the same job Aravind - There's no ready way that I know of to relate the Producer and Consumer sessions resulting from RESOURceutilization > 1. The Producer, being the session in charge, will show a start time (in 'select * from sessions') which is as early or earliest of any session for that node, and will typically show a LAST_VERB of Ping, rather than BackInsNormEnhanced or the like. In 'SHow SESSions' output, the Producer will show SessType=5 for a scheduled process, with its Consumer "children" being SessType=4; and the Producer will not transfer data, so its Backup and Archive object count will be zero. (But, in a manual 'dsmc', the sessions will all be SessType=4.) You will also see these session type numbers in the dsmaccnt.log records. So, to the best of my knowledge, this is all a matter of discerning, rather than readily determining. Richard Sims
Sessions in Actlog
Is there any way to query the relationship between Session numbers in actlog and a TSM job? It is quite common to find multiple sessions for the same job Thanks Aravind
Re: actlog errors since upgrade to 5.3.3
Hi Lawrence The message is quite self-explanatory: Session 1807 client is down-level - apply IC34693. This APAR can be found at: http://www-1.ibm.com/support/docview.wss?uid=swg1IC34693 Just like Brian suggested, you should upgrade the client to a higher level than 5.1.5.0. The error was fixed in 5.1.5.2, but if I were you, I would jump to the highest maintenance level available for Windows NT, which is 5.1.7.0. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: dinsdag 23 mei 2006 17:58 To: ADSM-L@VM.MARIST.EDU Subject: actlog errors since upgrade to 5.3.3 Here are new error messages that have showed up since the upgrade to 5.3.3. Anyone have an idea what they involve? 05/23/06 11:17:46 ANRD smutil.c(13314): ThreadId<33> Session 1807 (SCANIMG, 277, WinNT, 5.1.5.0) attempted to associate itself with nodeid 345 - aborting session(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId<33> issued message from: <-0x1001bb44 outDiagf <-0x1014c064 SmAddSessionToAffinityCluster <-0x104c234c SmNodeSession <-0x1053086c SmSchedSession <-0x104dd780 HandleNodeSession <-0x104e3ba0 smExecuteSession <-0x10577404 SessionThread <-0x1000e9e0 StartThread <-0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANRD smutil.c(13327): ThreadId<33> Session 1807 client is down-level - apply IC34693(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId<33> issued message from: <-0x1001bb44 outDiagf <-0x1014c0b4 SmAddSessionToAffinityCluster <-0x104c234c SmNodeSession <-0x1053086c SmSchedSession <-0x104dd780 HandleNodeSession <-0x104e3ba0 smExecuteSession <-0x10577404 SessionThread <-0x1000e9e0 StartThread <-0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANR0484W Session 1807 for node SCANIMG (WinNT) terminated - protocol violation detected.(SESSION: 1807) The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: actlog errors since upgrade to 5.3.3
I have received this error when the TSM client level was no longer supported at the server level. I upgraded the client and problem was solved. Brian Robinson -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Tuesday, May 23, 2006 11:58 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] actlog errors since upgrade to 5.3.3 Here are new error messages that have showed up since the upgrade to 5.3.3. Anyone have an idea what they involve? 05/23/06 11:17:46 ANRD smutil.c(13314): ThreadId<33> Session 1807 (SCANIMG, 277, WinNT, 5.1.5.0) attempted to associate itself with nodeid 345 - aborting session(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId<33> issued message from: <-0x1001bb44 outDiagf <-0x1014c064 SmAddSessionToAffinityCluster <-0x104c234c SmNodeSession <-0x1053086c SmSchedSession <-0x104dd780 HandleNodeSession <-0x104e3ba0 smExecuteSession <-0x10577404 SessionThread <-0x1000e9e0 StartThread <-0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANRD smutil.c(13327): ThreadId<33> Session 1807 client is down-level - apply IC34693(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId<33> issued message from: <-0x1001bb44 outDiagf <-0x1014c0b4 SmAddSessionToAffinityCluster <-0x104c234c SmNodeSession <-0x1053086c SmSchedSession <-0x104dd780 HandleNodeSession <-0x104e3ba0 smExecuteSession <-0x10577404 SessionThread <-0x1000e9e0 StartThread <-0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANR0484W Session 1807 for node SCANIMG (WinNT) terminated - protocol violation detected.(SESSION: 1807) The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
actlog errors since upgrade to 5.3.3
Here are new error messages that have showed up since the upgrade to 5.3.3. Anyone have an idea what they involve? 05/23/06 11:17:46 ANRD smutil.c(13314): ThreadId<33> Session 1807 (SCANIMG, 277, WinNT, 5.1.5.0) attempted to associate itself with nodeid 345 - aborting session(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId<33> issued message from: <-0x1001bb44 outDiagf <-0x1014c064 SmAddSessionToAffinityCluster <-0x104c234c SmNodeSession <-0x1053086c SmSchedSession <-0x104dd780 HandleNodeSession <-0x104e3ba0 smExecuteSession <-0x10577404 SessionThread <-0x1000e9e0 StartThread <-0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANRD smutil.c(13327): ThreadId<33> Session 1807 client is down-level - apply IC34693(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId<33> issued message from: <-0x1001bb44 outDiagf <-0x1014c0b4 SmAddSessionToAffinityCluster <-0x104c234c SmNodeSession <-0x1053086c SmSchedSession <-0x104dd780 HandleNodeSession <-0x104e3ba0 smExecuteSession <-0x10577404 SessionThread <-0x1000e9e0 StartThread <-0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANR0484W Session 1807 for node SCANIMG (WinNT) terminated - protocol violation detected.(SESSION: 1807) The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
Re: NAS Report through the ACTLOG table
Welcome to my world. A world where I'm unable to find any good reporting tools for NDMP backups. I asked a question like this about 2 weeks ago on the forum. I had a few responses but not exactly what I was looking for. I've started on my own query and this is what I have come up with so far. The actlog is useless, as the volume is not listed at the completion, I have gone with the backup table: A report that will list the q-trees that have not been backed up in the last 24 hours. Name: MISSED_NETAPP_BACKUPS Line Number: 1 Command: select backups.node_name, backups.filespace_name, vfsmappings.filespace_name, backups.type, backups.backup_date as "Last Backup Date" from backups, vfsmappings where backups.filespace_name like vfsmappings.virtual_fs_name and backups.type<>'TOC' and BACKUP_DATE < current_timestamp -1 day and STATE='ACTIVE_VERSION' You will notice that we are backing up at the qtree level, so we are looking at the vfsmappings table, if you are backing up at the volume level, it would have to be a little different. It's a work in progress, as the format is still not quite what I'm looking for. Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Tuesday, May 10, 2005 9:09 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: NAS Report through the ACTLOG table Hi Iain, Yes, it's very beneficial. Thanks! Here is my output. I am just trying to get the name of the filesystem that is being backed up for this process to be reported within this script as well and I can't seem to figure out how to join this select statement with the actlog to associate it and find the filesystem info. I'm pretty positive that it can be done, but I haven't been successful so far. Thank you for your help! NODE_NAME: NAS_SERVER_2_OFFSITE DATE: 2005-05-10 ACTIVITY: NAS Backup START: 00:15:14 END: 00:16:26 length: 00:01:12 MB: 46 FILES: 0 SUCCESSFUL: YES Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] "Iain Barnetson" <[EMAIL PROTECTED] ALLIBURTON.COM> To Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: NAS Report through the ACTLOG table 05/10/2005 10:52 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> Joni, Is this any use to you: select entity as node_name, date(start_time) as date, cast(activity as - varchar(10)) as activity, - time(start_time) as start,time(end_time) as end, - cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as "Length", - cast(bytes/1024/1024 as decimal(6,0)) as - megabytes,cast(affected as decimal(7,0)) as files, successful from summary where - start_time>=current_timestamp - 1 day and (entity like 'ABZ%' or entity like 'NAS%') - and (activity='BACKUP' or activity='NAS Backup') - order by start, node_name Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 10 May 2005 15:38 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] NAS Report through the ACTLOG table Hello Everyone, If the previous message concerning a select statement cannot be run, then I found the message numbers within the activity log that contain the information that I need: 1064 & 988. I ran the following: select date(date_time) as "Date",time(date_time) as "Time",message,process from actlog where date_time>(current_timestamp - 1 day) and msgno in (1064,988) order by process and received this: 2005-05-09 19:00:29 ANR1064I Differen 5684 tial backup of N AS node NAS_SERV ER_3, file system /.etc_common, st arted as process 5684 by adminis trator LID3QE9.
Re: NAS Report through the ACTLOG table
No worries, I got it from someone else on the mail list. I'd like to be able to add the FS name to the query as well but haven't managed to figure it out yet either. Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 10 May 2005 16:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] NAS Report through the ACTLOG table Hi Iain, Yes, it's very beneficial. Thanks! Here is my output. I am just trying to get the name of the filesystem that is being backed up for this process to be reported within this script as well and I can't seem to figure out how to join this select statement with the actlog to associate it and find the filesystem info. I'm pretty positive that it can be done, but I haven't been successful so far. Thank you for your help! NODE_NAME: NAS_SERVER_2_OFFSITE DATE: 2005-05-10 ACTIVITY: NAS Backup START: 00:15:14 END: 00:16:26 length: 00:01:12 MB: 46 FILES: 0 SUCCESSFUL: YES Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] "Iain Barnetson" <[EMAIL PROTECTED] ALLIBURTON.COM> To Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: NAS Report through the ACTLOG table 05/10/2005 10:52 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> Joni, Is this any use to you: select entity as node_name, date(start_time) as date, cast(activity as - varchar(10)) as activity, - time(start_time) as start,time(end_time) as end, - cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as "Length", - cast(bytes/1024/1024 as decimal(6,0)) as - megabytes,cast(affected as decimal(7,0)) as files, successful from summary where - start_time>=current_timestamp - 1 day and (entity like 'ABZ%' or entity like 'NAS%') - and (activity='BACKUP' or activity='NAS Backup') - order by start, node_name Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 10 May 2005 15:38 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] NAS Report through the ACTLOG table Hello Everyone, If the previous message concerning a select statement cannot be run, then I found the message numbers within the activity log that contain the information that I need: 1064 & 988. I ran the following: select date(date_time) as "Date",time(date_time) as "Time",message,process from actlog where date_time>(current_timestamp - 1 day) and msgno in (1064,988) order by process and received this: 2005-05-09 19:00:29 ANR1064I Differen 5684 tial backup of N AS node NAS_SERV ER_3, file system /.etc_common, st arted as process 5684 by adminis trator LID3QE9. (SESSION: 294768, PROCESS: 5684) 2005-05-09 19:05:47 ANR0988I Process 5684 5684 for BACKUP NAS (DIFFERENTIA L) running in the FOREGROUND proce ssed 65,536 bytes with a completion state of SUCCESS at 19:05:47. (S ESSION: 294768, PROCESS: 5684) Is there a way to pull information out of the following output to just look like a table with the following information: Date Begin Time End Time NAS_Server_# Filesystem Process# Differential/Full MB Backed up Completion State Thank you in advance! I am really trying to get an exact way to receive a detailed NDMP backup report and just can't seem to get what I want. Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] -- This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, d
Re: NAS Report through the ACTLOG table
Hi Iain, Yes, it's very beneficial. Thanks! Here is my output. I am just trying to get the name of the filesystem that is being backed up for this process to be reported within this script as well and I can't seem to figure out how to join this select statement with the actlog to associate it and find the filesystem info. I'm pretty positive that it can be done, but I haven't been successful so far. Thank you for your help! NODE_NAME: NAS_SERVER_2_OFFSITE DATE: 2005-05-10 ACTIVITY: NAS Backup START: 00:15:14 END: 00:16:26 length: 00:01:12 MB: 46 FILES: 0 SUCCESSFUL: YES Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] "Iain Barnetson" <[EMAIL PROTECTED] ALLIBURTON.COM>To Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: NAS Report through the ACTLOG table 05/10/2005 10:52 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> Joni, Is this any use to you: select entity as node_name, date(start_time) as date, cast(activity as - varchar(10)) as activity, - time(start_time) as start,time(end_time) as end, - cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as "Length", - cast(bytes/1024/1024 as decimal(6,0)) as - megabytes,cast(affected as decimal(7,0)) as files, successful from summary where - start_time>=current_timestamp - 1 day and (entity like 'ABZ%' or entity like 'NAS%') - and (activity='BACKUP' or activity='NAS Backup') - order by start, node_name Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 10 May 2005 15:38 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] NAS Report through the ACTLOG table Hello Everyone, If the previous message concerning a select statement cannot be run, then I found the message numbers within the activity log that contain the information that I need: 1064 & 988. I ran the following: select date(date_time) as "Date",time(date_time) as "Time",message,process from actlog where date_time>(current_timestamp - 1 day) and msgno in (1064,988) order by process and received this: 2005-05-09 19:00:29 ANR1064I Differen 5684 tial backup of N AS node NAS_SERV ER_3, file system /.etc_common, st arted as process 5684 by adminis trator LID3QE9. (SESSION: 294768, PROCESS: 5684) 2005-05-09 19:05:47 ANR0988I Process 5684 5684 for BACKUP NAS (DIFFERENTIA L) running in the FOREGROUND proce ssed 65,536 bytes with a completion state of SUCCESS at 19:05:47. (S ESSION: 294768, PROCESS: 5684) Is there a way to pull information out of the following output to just look like a table with the following information: Date Begin Time End Time NAS_Server_# Filesystem Process# Differential/Full MB Backed up Completion State Thank you in advance! I am really trying to get an exact way to receive a detailed NDMP backup report and just can't seem to get what I want. Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] -- This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message.
Re: NAS Report through the ACTLOG table
Joni, Is this any use to you: select entity as node_name, date(start_time) as date, cast(activity as - varchar(10)) as activity, - time(start_time) as start,time(end_time) as end, - cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as "Length", - cast(bytes/1024/1024 as decimal(6,0)) as - megabytes,cast(affected as decimal(7,0)) as files, successful from summary where - start_time>=current_timestamp - 1 day and (entity like 'ABZ%' or entity like 'NAS%') - and (activity='BACKUP' or activity='NAS Backup') - order by start, node_name Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 10 May 2005 15:38 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] NAS Report through the ACTLOG table Hello Everyone, If the previous message concerning a select statement cannot be run, then I found the message numbers within the activity log that contain the information that I need: 1064 & 988. I ran the following: select date(date_time) as "Date",time(date_time) as "Time",message,process from actlog where date_time>(current_timestamp - 1 day) and msgno in (1064,988) order by process and received this: 2005-05-09 19:00:29 ANR1064I Differen 5684 tial backup of N AS node NAS_SERV ER_3, file system /.etc_common, st arted as process 5684 by adminis trator LID3QE9. (SESSION: 294768, PROCESS: 5684) 2005-05-09 19:05:47 ANR0988I Process 5684 5684 for BACKUP NAS (DIFFERENTIA L) running in the FOREGROUND proce ssed 65,536 bytes with a completion state of SUCCESS at 19:05:47. (S ESSION: 294768, PROCESS: 5684) Is there a way to pull information out of the following output to just look like a table with the following information: Date Begin Time End Time NAS_Server_# Filesystem Process# Differential/Full MB Backed up Completion State Thank you in advance! I am really trying to get an exact way to receive a detailed NDMP backup report and just can't seem to get what I want. Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] -- This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message.
NAS Report through the ACTLOG table
Hello Everyone, If the previous message concerning a select statement cannot be run, then I found the message numbers within the activity log that contain the information that I need: 1064 & 988. I ran the following: select date(date_time) as "Date",time(date_time) as "Time",message,process from actlog where date_time>(current_timestamp - 1 day) and msgno in (1064,988) order by process and received this: 2005-05-09 19:00:29 ANR1064I Differen 5684 tial backup of N AS node NAS_SERV ER_3, file system /.etc_common, st arted as process 5684 by adminis trator LID3QE9. (SESSION: 294768, PROCESS: 5684) 2005-05-09 19:05:47 ANR0988I Process 5684 5684 for BACKUP NAS (DIFFERENTIA L) running in the FOREGROUND proce ssed 65,536 bytes with a completion state of SUCCESS at 19:05:47. (S ESSION: 294768, PROCESS: 5684) Is there a way to pull information out of the following output to just look like a table with the following information: Date Begin Time End Time NAS_Server_# Filesystem Process# Differential/Full MB Backed up Completion State Thank you in advance! I am really trying to get an exact way to receive a detailed NDMP backup report and just can't seem to get what I want. Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Error in actlog for windows nodes
Hi *SM-ers! I see the following error on a daily basis in my actlog for 3 different Windows nodes: ANRD smnode.c(7035): ThreadId<109> Internal Error - invalid insert length (21615) for event insert 0 received for event number 4952 from (WinNT)AF05053. The local client logs however do not show any errors, no failed backups and no entries in the dsmerror.log. Has anybody seen this before? Thank you very much for any reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: select from actlog VS query actlog performance
BEGINT=-08:00 starts searching the activity log as of 8 hours from the present time (as opposed to the default, which is 1 hour from the present time). Leave out the '-' if you really mean 08:00 (8:00 AM). The raw TSM server database tables are not row-column format, but more like a B-tree, and were not originally designed to support SQL. The only methods for interrogating the database were those provided by the QUERY commands (QUERY ACTLOG, QUERY FILESPACE, etc.). The QUERY commands are optimized for accessing the raw tables of the TSM database, and thus perform quite well. Because customers wanted more query flexibility than what the TSM server already provided, and creating individual QUERY commands for each possible query was not practical (effectively an unbounded list), the SQL interface was created. The tables presented by the SQL interface are not those of the raw internal TSM tables; rather, they are virtualized versions of the internal tables that are created dynamically when you run the SELECT command (hence the need for available space in the database to run SELECT). While SELECT gives you more flexibility in the types of queries you can run, those queries tend to run more slowly. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/19/2004 07:55:02: > Hello TSM'ers > > > > I'm doing some scripting that is using actlog queries fairly heavily, I > have noticed that > > Select * from actlog where cast(date_time as date)=current_date and > process=1234 > > Is a lot slower than > > Q actlog begint=-08:00 se=1234 (say, its 8am in the morning...) > > > Although you need to be carefull you are actually getting what you want > with the latter version. > > > Is TSM doing anything internally to generate a SQL statement that works > quicker than mine but gives the same/similar result? - I am assuming > that internally TSM takes q actlog (and other q commands) and generates > a SQL statement it then processes against the TSM DB, formatting the > result to generate the query output as non-tables. > > > Thanks, > > Matt. > > > > > > ___ Disclaimer Notice __ > This message and any attachments are confidential and should only be read by > those to whom they are addressed. If you are not the intended recipient, > please contact us, delete the message from your computer and destroy any > copies. Any distribution or copying without our prior permission is prohibited. > > Internet communications are not always secure and therefore Powergen Retail > Limited does not accept legal responsibility for this message. The recipient > is responsible for verifying its authenticity before acting on the contents. > Any views or opinions presented are solely those of the author and do not > necessarily represent those of Powergen Retail Limited. > > Registered addresses: > > Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. > Registered in England and Wales No: 3407430 > > Telephone +44 (0) 2476 42 4000 > Fax +44 (0) 2476 42 5432
Re: select from actlog VS query actlog performance
Rather the other way round. The SQL is being converted to a native database call. I would presume most query commands would be quicker than their equivalent "SQL" queries. For tuning SQL queries you can look at the indexing of the columns in a table: select tabname, colname, colno, index_keyseq, index_order from columns where tabname='ACTLOG' TABNAME COLNAME COLNO INDEX_KEYSEQ INDEX_ORDER -- -- -- ---- --- ACTLOG DATE_TIME 1 1 A ACTLOG MSGNO 2 ACTLOG SEVERITY 3 ACTLOG MESSAGE 4 ACTLOG ORIGINATOR 5 ACTLOG NODENAME 6 ACTLOG OWNERNAME 7 ACTLOG SCHEDNAME 8 ACTLOG DOMAINNAME 9 ACTLOG SESSID 10 ACTLOG SERVERNAME 11 Here you can see it is only indexed on DATE_TIME. Other tables have more indexed columns. Running functions on where clause columns may well cause the query to do a full table scan anyway (not using the index.) but that's just a guess. (I notice that you are using process=1234 in your where clause, so maybe you have a later release of TSM, I'm on 5.1 and don't have that column!) Remember as well that SQL queries use the free space in your database, so make sure you have plenty if you're doing big queries. Paul. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Warren, Matthew (Retail) Sent: Friday 19 November 2004 15:55 To: [EMAIL PROTECTED] Subject: select from actlog VS query actlog performance Hello TSM'ers I'm doing some scripting that is using actlog queries fairly heavily, I have noticed that Select * from actlog where cast(date_time as date)=current_date and process=1234 Is a lot slower than Q actlog begint=-08:00 se=1234 (say, its 8am in the morning...) Although you need to be carefull you are actually getting what you want with the latter version. Is TSM doing anything internally to generate a SQL statement that works quicker than mine but gives the same/similar result? - I am assuming that internally TSM takes q actlog (and other q commands) and generates a SQL statement it then processes against the TSM DB, formatting the result to generate the query output as non-tables. Thanks, Matt. ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432 Any e-mail message from the European Central Bank (ECB) is sent in good faith but shall neither be binding nor construed as constituting a commitment by the ECB except where provided for in a written agreement. This e-mail is intended only for the use of the recipient(s) named above. Any unauthorised disclosure, use or dissemination, either in whole or in part, is prohibited. If you have received this e-mail in error, please notify the sender immediately via e-mail and delete this e-mail from your system.
select from actlog VS query actlog performance
Hello TSM'ers I'm doing some scripting that is using actlog queries fairly heavily, I have noticed that Select * from actlog where cast(date_time as date)=current_date and process=1234 Is a lot slower than Q actlog begint=-08:00 se=1234 (say, its 8am in the morning...) Although you need to be carefull you are actually getting what you want with the latter version. Is TSM doing anything internally to generate a SQL statement that works quicker than mine but gives the same/similar result? - I am assuming that internally TSM takes q actlog (and other q commands) and generates a SQL statement it then processes against the TSM DB, formatting the result to generate the query output as non-tables. Thanks, Matt. ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
Re: error message in my actlog ....
You are correct these files are created by the System Monitor (http://www.jsiinc.com/SUBG/TIP3300/rh3343.htm). We exclude them from our backups. Louis -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Luc Beaudoin Sent: Tuesday, July 20, 2004 9:48 AM To: [EMAIL PROTECTED] Subject: error message in my actlog Hi everyone I have a lot of those in the actlog of my TSM server ANE4987E Error processing '\\003123a\c$\WINNT\system32\Perflib_Perfdata_5b0.dat': the object is in use by another process anybody knows what R those files (Perflib_perfdata ...) I think it's the performance monitor but I'm not sure Should I exclude them from all my WIN2K server ... thanks ** The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. **
Re: error message in my actlog ....
Hi, If you take a look at the dsm.smp in the config dir of the baclient than you would see some default excludes. One of these is: *Exclude *:\...\system32\Perflib*.dat. I would exclude them. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Luc Beaudoin Sent: dinsdag 20 juli 2004 15:48 To: [EMAIL PROTECTED] Subject: error message in my actlog Hi everyone I have a lot of those in the actlog of my TSM server ANE4987E Error processing '\\003123a\c$\WINNT\system32\Perflib_Perfdata_5b0.dat': the object is in use by another process anybody knows what R those files (Perflib_perfdata ...) I think it's the performance monitor but I'm not sure Should I exclude them from all my WIN2K server ... thanks
error message in my actlog ....
Hi everyone I have a lot of those in the actlog of my TSM server ANE4987E Error processing '\\003123a\c$\WINNT\system32\Perflib_Perfdata_5b0.dat': the object is in use by another process anybody knows what R those files (Perflib_perfdata ...) I think it's the performance monitor but I'm not sure Should I exclude them from all my WIN2K server ... thanks
actlog output ahh
I'm running an admin script which will do an: "issue message XXX" which sends a message to the actlog unfortunately it also records the: "ADMIN ISSUED command: ISSUE MESSAGE" in the actlog and the actual message in the actlog. BRUTAL, I see both messages and it's annouying. Does anyone know of a way to stop admin/user "admin issued command" messages from being directed to the actlog?. Thanks in advance. --Justin Richard Bleistein Unix/TSM Systems Administrator (Sungard Availability Services)
Re: Q ACTLOG oddities
Yes Chris, this APAR is being closed as DOC. The reason for this is that event log records have the originating server name associated with it. Even if it isn't displayed in the QUERY ACTLOG output, it is searchable with the QUERY ACTLOG command. Hence the seemingly odd behavior. I understand that doesn't "fix" the problem for you, but I hope it at least explains the behavior. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Chris Murphy <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/09/2004 15:27 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Re: Q ACTLOG oddities I saw the APAR. Thanx Andy, that be the problem. It's existed since version 3.7 it appears, so its surprising it is still a "bug". But, if that's the worst of the "bugs" I have to deal with, I'm one happy prop-head! Chris -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 2:37 PM To: [EMAIL PROTECTED] Subject: Re: Q ACTLOG oddities Check out APAR IC32293 (go to www.ibm.com and put the APAR number is as a search criterion) to see if that might be the problem. Is BOISE5 by any chance the name (or part of the name) of a TSM server? Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Chris Murphy <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/09/2004 13:18 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Q ACTLOG oddities Hello all, Enviro: TSM Server V5.1.7.0 on Win2k Sp4 If I enter the following command: Q ACT BEGIND=-4 SEARCH=BOISE5 I would expect this to return all the entries containing the string "BOISE5" (a computer name in this case). However, below is a snipped paste of the actual results. Any ideas why the vast majority of the results do *NOT* include the string anywhere within them? I tried placing the string in " and ' marks to no avail. 02/05/2004 20:01:21 ANR0406I Session 1142 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2330)). 02/05/2004 20:01:30 ANE4037E (Session: 1136, Node: BOISE4) File '\\boise4\c$- \Program Files\Tivoli\TSM\baclient\dsmsched.log' changed during processing. File skipped. 02/05/2004 20:01:33 ANR0406I Session 1146 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2331)). 02/05/2004 20:01:33 ANR0406I Session 1147 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2332)). 02/05/2004 20:01:50 ANE4952I (Session: 1125, Node: BOISE2) Total number of objects inspected:7,613 02/05/2004 20:01:50 ANE4954I (Session: 1125, Node: BOISE2) Total number of objects backed up: 39 02/05/2004 20:20:19 ANE4952I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects inspected:3,050 02/05/2004 20:20:19 ANE4954I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects backed up:2,619 02/05/2004 20:20:19 ANE4958I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects updated: 0 02/05/2004 20:20:19 ANE4960I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects rebound: 0 02/05/2004 20:20:19 ANE4957I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects deleted: 0 02/05/2004 20:20:19 ANE4970I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects expired:154 02/09/2004 10:50:56 ANE4963I (Session: 5313, Node: BOISE5) Data transfer time: 315.74 sec 02/09/2004 10:50:56 ANE4966I (Session: 5313, Node: BOISE5) Network data transfer rate: 20.50 KB/sec 02/09/2004 10:50:56 ANE4967I (Session: 5313, Node: BOISE5) Aggregate data transfer rate: 1.06 KB/sec 02/09/2004 10:50:56 ANE4964I (Session: 5313, Node: BOISE5) Elapsed processing time:01:41:40 02/09/2004 11:24:53 ANR0403I Session 5313 ended for node BOISE5 (WinNT). 02/09/2004 13:13:00 ANR2017I Admini
Re: Q ACTLOG oddities
Whoa, I don't have anything constructive to add but I must say it freaked me out when I see a host name of BOISE5. "~I~ have a host by that name?!?!" Who is this guy? I guess that's one of the hazards of being based in Boise Id. :-) Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, February 09, 2004 2:37 PM To: [EMAIL PROTECTED] Subject: Re: Q ACTLOG oddities Check out APAR IC32293 (go to www.ibm.com and put the APAR number is as a search criterion) to see if that might be the problem. Is BOISE5 by any chance the name (or part of the name) of a TSM server? Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Chris Murphy <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/09/2004 13:18 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Q ACTLOG oddities Hello all, Enviro: TSM Server V5.1.7.0 on Win2k Sp4 If I enter the following command: Q ACT BEGIND=-4 SEARCH=BOISE5 I would expect this to return all the entries containing the string "BOISE5" (a computer name in this case). However, below is a snipped paste of the actual results. Any ideas why the vast majority of the results do *NOT* include the string anywhere within them? I tried placing the string in " and ' marks to no avail. 02/05/2004 20:01:21 ANR0406I Session 1142 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2330)). 02/05/2004 20:01:30 ANE4037E (Session: 1136, Node: BOISE4) File '\\boise4\c$- \Program Files\Tivoli\TSM\baclient\dsmsched.log' changed during processing. File skipped. 02/05/2004 20:01:33 ANR0406I Session 1146 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2331)). 02/05/2004 20:01:33 ANR0406I Session 1147 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2332)). 02/05/2004 20:01:50 ANE4952I (Session: 1125, Node: BOISE2) Total number of objects inspected:7,613 02/05/2004 20:01:50 ANE4954I (Session: 1125, Node: BOISE2) Total number of objects backed up: 39 02/05/2004 20:20:19 ANE4952I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects inspected:3,050 02/05/2004 20:20:19 ANE4954I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects backed up:2,619 02/05/2004 20:20:19 ANE4958I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects updated: 0 02/05/2004 20:20:19 ANE4960I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects rebound: 0 02/05/2004 20:20:19 ANE4957I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects deleted: 0 02/05/2004 20:20:19 ANE4970I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects expired:154 02/09/2004 10:50:56 ANE4963I (Session: 5313, Node: BOISE5) Data transfer time: 315.74 sec 02/09/2004 10:50:56 ANE4966I (Session: 5313, Node: BOISE5) Network data transfer rate: 20.50 KB/sec 02/09/2004 10:50:56 ANE4967I (Session: 5313, Node: BOISE5) Aggregate data transfer rate: 1.06 KB/sec 02/09/2004 10:50:56 ANE4964I (Session: 5313, Node: BOISE5) Elapsed processing time:01:41:40 02/09/2004 11:24:53 ANR0403I Session 5313 ended for node BOISE5 (WinNT). 02/09/2004 13:13:00 ANR2017I Administrator CMURPHY issued command: QUERY ACTLOG begind=-4 search=boise5 Chris Murphy IT Network Analyst Idaho Dept. of Lands Office: (208) 334-0293 [EMAIL PROTECTED]
Re: Q ACTLOG oddities
I saw the APAR. Thanx Andy, that be the problem. It's existed since version 3.7 it appears, so its surprising it is still a "bug". But, if that's the worst of the "bugs" I have to deal with, I'm one happy prop-head! Chris -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 2:37 PM To: [EMAIL PROTECTED] Subject: Re: Q ACTLOG oddities Check out APAR IC32293 (go to www.ibm.com and put the APAR number is as a search criterion) to see if that might be the problem. Is BOISE5 by any chance the name (or part of the name) of a TSM server? Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Chris Murphy <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/09/2004 13:18 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Q ACTLOG oddities Hello all, Enviro: TSM Server V5.1.7.0 on Win2k Sp4 If I enter the following command: Q ACT BEGIND=-4 SEARCH=BOISE5 I would expect this to return all the entries containing the string "BOISE5" (a computer name in this case). However, below is a snipped paste of the actual results. Any ideas why the vast majority of the results do *NOT* include the string anywhere within them? I tried placing the string in " and ' marks to no avail. 02/05/2004 20:01:21 ANR0406I Session 1142 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2330)). 02/05/2004 20:01:30 ANE4037E (Session: 1136, Node: BOISE4) File '\\boise4\c$- \Program Files\Tivoli\TSM\baclient\dsmsched.log' changed during processing. File skipped. 02/05/2004 20:01:33 ANR0406I Session 1146 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2331)). 02/05/2004 20:01:33 ANR0406I Session 1147 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2332)). 02/05/2004 20:01:50 ANE4952I (Session: 1125, Node: BOISE2) Total number of objects inspected:7,613 02/05/2004 20:01:50 ANE4954I (Session: 1125, Node: BOISE2) Total number of objects backed up: 39 02/05/2004 20:20:19 ANE4952I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects inspected:3,050 02/05/2004 20:20:19 ANE4954I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects backed up:2,619 02/05/2004 20:20:19 ANE4958I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects updated: 0 02/05/2004 20:20:19 ANE4960I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects rebound: 0 02/05/2004 20:20:19 ANE4957I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects deleted: 0 02/05/2004 20:20:19 ANE4970I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects expired:154 02/09/2004 10:50:56 ANE4963I (Session: 5313, Node: BOISE5) Data transfer time: 315.74 sec 02/09/2004 10:50:56 ANE4966I (Session: 5313, Node: BOISE5) Network data transfer rate: 20.50 KB/sec 02/09/2004 10:50:56 ANE4967I (Session: 5313, Node: BOISE5) Aggregate data transfer rate: 1.06 KB/sec 02/09/2004 10:50:56 ANE4964I (Session: 5313, Node: BOISE5) Elapsed processing time:01:41:40 02/09/2004 11:24:53 ANR0403I Session 5313 ended for node BOISE5 (WinNT). 02/09/2004 13:13:00 ANR2017I Administrator CMURPHY issued command: QUERY ACTLOG begind=-4 search=boise5 Chris Murphy IT Network Analyst Idaho Dept. of Lands Office: (208) 334-0293 [EMAIL PROTECTED]
Re: Q ACTLOG oddities
Check out APAR IC32293 (go to www.ibm.com and put the APAR number is as a search criterion) to see if that might be the problem. Is BOISE5 by any chance the name (or part of the name) of a TSM server? Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Chris Murphy <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/09/2004 13:18 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Q ACTLOG oddities Hello all, Enviro: TSM Server V5.1.7.0 on Win2k Sp4 If I enter the following command: Q ACT BEGIND=-4 SEARCH=BOISE5 I would expect this to return all the entries containing the string "BOISE5" (a computer name in this case). However, below is a snipped paste of the actual results. Any ideas why the vast majority of the results do *NOT* include the string anywhere within them? I tried placing the string in " and ' marks to no avail. 02/05/2004 20:01:21 ANR0406I Session 1142 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2330)). 02/05/2004 20:01:30 ANE4037E (Session: 1136, Node: BOISE4) File '\\boise4\c$- \Program Files\Tivoli\TSM\baclient\dsmsched.log' changed during processing. File skipped. 02/05/2004 20:01:33 ANR0406I Session 1146 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2331)). 02/05/2004 20:01:33 ANR0406I Session 1147 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2332)). 02/05/2004 20:01:50 ANE4952I (Session: 1125, Node: BOISE2) Total number of objects inspected:7,613 02/05/2004 20:01:50 ANE4954I (Session: 1125, Node: BOISE2) Total number of objects backed up: 39 02/05/2004 20:20:19 ANE4952I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects inspected:3,050 02/05/2004 20:20:19 ANE4954I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects backed up:2,619 02/05/2004 20:20:19 ANE4958I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects updated: 0 02/05/2004 20:20:19 ANE4960I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects rebound: 0 02/05/2004 20:20:19 ANE4957I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects deleted: 0 02/05/2004 20:20:19 ANE4970I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects expired:154 02/09/2004 10:50:56 ANE4963I (Session: 5313, Node: BOISE5) Data transfer time: 315.74 sec 02/09/2004 10:50:56 ANE4966I (Session: 5313, Node: BOISE5) Network data transfer rate: 20.50 KB/sec 02/09/2004 10:50:56 ANE4967I (Session: 5313, Node: BOISE5) Aggregate data transfer rate: 1.06 KB/sec 02/09/2004 10:50:56 ANE4964I (Session: 5313, Node: BOISE5) Elapsed processing time:01:41:40 02/09/2004 11:24:53 ANR0403I Session 5313 ended for node BOISE5 (WinNT). 02/09/2004 13:13:00 ANR2017I Administrator CMURPHY issued command: QUERY ACTLOG begind=-4 search=boise5 Chris Murphy IT Network Analyst Idaho Dept. of Lands Office: (208) 334-0293 [EMAIL PROTECTED]
Q ACTLOG oddities
Hello all, Enviro: TSM Server V5.1.7.0 on Win2k Sp4 If I enter the following command: Q ACT BEGIND=-4 SEARCH=BOISE5 I would expect this to return all the entries containing the string "BOISE5" (a computer name in this case). However, below is a snipped paste of the actual results. Any ideas why the vast majority of the results do *NOT* include the string anywhere within them? I tried placing the string in " and ' marks to no avail. 02/05/2004 20:01:21 ANR0406I Session 1142 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2330)). 02/05/2004 20:01:30 ANE4037E (Session: 1136, Node: BOISE4) File '\\boise4\c$- \Program Files\Tivoli\TSM\baclient\dsmsched.log' changed during processing. File skipped. 02/05/2004 20:01:33 ANR0406I Session 1146 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2331)). 02/05/2004 20:01:33 ANR0406I Session 1147 started for node BOISE5 (WinNT) (Tcp/Ip 10.222.2.8(2332)). 02/05/2004 20:01:50 ANE4952I (Session: 1125, Node: BOISE2) Total number of objects inspected:7,613 02/05/2004 20:01:50 ANE4954I (Session: 1125, Node: BOISE2) Total number of objects backed up: 39 02/05/2004 20:20:19 ANE4952I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects inspected:3,050 02/05/2004 20:20:19 ANE4954I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects backed up:2,619 02/05/2004 20:20:19 ANE4958I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects updated: 0 02/05/2004 20:20:19 ANE4960I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects rebound: 0 02/05/2004 20:20:19 ANE4957I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects deleted: 0 02/05/2004 20:20:19 ANE4970I (Session: 1117, Node: BOI-SHAREPT2) Total number of objects expired:154 02/09/2004 10:50:56 ANE4963I (Session: 5313, Node: BOISE5) Data transfer time: 315.74 sec 02/09/2004 10:50:56 ANE4966I (Session: 5313, Node: BOISE5) Network data transfer rate: 20.50 KB/sec 02/09/2004 10:50:56 ANE4967I (Session: 5313, Node: BOISE5) Aggregate data transfer rate: 1.06 KB/sec 02/09/2004 10:50:56 ANE4964I (Session: 5313, Node: BOISE5) Elapsed processing time:01:41:40 02/09/2004 11:24:53 ANR0403I Session 5313 ended for node BOISE5 (WinNT). 02/09/2004 13:13:00 ANR2017I Administrator CMURPHY issued command: QUERY ACTLOG begind=-4 search=boise5 Chris Murphy IT Network Analyst Idaho Dept. of Lands Office: (208) 334-0293 [EMAIL PROTECTED]
Re: Inconsistency between summary and actlog
I have been struggling with this issue recently myself, Richard was kind enough to answer my stupid questions several weeks ago too *8<). I originally looked at the accounting file, but it did not contain all of the info that my management and customers wanted so I wrote my own script that pulls from the actlog and from the events table to get backup stats and schedule info. If anyone wants a copy of the script, I will let you have it, it's a korn shell script for Solaris though. If you just want the backup stats, you can use the query I started out with (which I pilfered from the Operational reporting tool): select msgno,nodename,sessid,message from actlog where ( msgno=4952 or msgno=4953 or msgno=4954 or msgno=4955 or msgno=4956 or msgno=4957 or msgno=4958 or msgno=4959 or msgno=4960 or msgno=4961 or msgno=4964 or msgno=4967 or msgno=4968 or msgno=4970 ) and (date_time between '2004-01-06 19:42' and '2004-01-07 19:42') order by sessid It dumps out data that looks like: 4952,ALL,60358,"ANE4952I Total number of objects inspected: 50,572 " 4954,ALL,60358,"ANE4954I Total number of objects backed up: 50,572 " 4958,ALL,60358,ANE4958I Total number of objects updated: 0 4960,ALL,60358,ANE4960I Total number of objects rebound: 0 4957,ALL,60358,ANE4957I Total number of objects deleted: 0 4970,ALL,60358,ANE4970I Total number of objects expired: 0 4959,ALL,60358,ANE4959I Total number of objects failed: 0 4961,ALL,60358,ANE4961I Total number of bytes transferred: 2.04 GB 4967,ALL,60358,"ANE4967I Aggregate data transfer rate: 4,602.53 KB/sec " 4968,ALL,60358,ANE4968I Objects compressed by:0% 4964,ALL,60358,ANE4964I Elapsed processing time:00:07:46 With a little manipulation with sed: 4952,ALL,60358,"50,572 " 4954,ALL,60358,"50,572 " 4958,ALL,60358,0 4960,ALL,60358,0 4957,ALL,60358,0 4970,ALL,60358,0 4959,ALL,60358,0 4961,ALL,60358,2.04 GB 4967,ALL,60358,"4,602.53 KB/sec " 4968,ALL,60358,0% 4964,ALL,60358,00:07:46 My final script returns an output like (field headers listed first for reference value): ${NODE},${NODEIPADDRESS},${TSM_SERVER_INFO},${SESSIONID},${SCHEDULENAME} ,${STARTTIME},${ELAPSEDPROCTIME},${NUMOFBYTESXFERRED},${NUMOFOBJECTS},${ NUMOFOBJECTSBACKEDUP},${NUMOFOBJECTSFAILED},${SUCCESSFUL} AD01-IPP,10.81.10.10,TSM3.USSNTC6,10.81.96.22,60633,DAILY_04,01/13/04 00:53:40,00:01:26,348.72MB,37222,885,0,Completed AD02-IPP,10.81.10.12,TSM3.USSNTC6,10.81.96.22,61706,DAILY_05,01/13/04 11:59:16,00:01:27,289.16MB,29793,438,0,Completed ALL,,TSM3.USSNTC6,10.81.96.22,60878,,,00:25:22,2.05GB,50573,50573,0, CMS-DB1-IPP,10.81.215.11,TSM3.USSNTC6,10.81.96.22,61669,DAILY_06,01/13/0 4 11:38:13,00:02:46,827.55MB,101,85,0,Completed DEVSTUDIO-IPP,10.81.215.4,TSM3.USSNTC6,10.81.96.22,61573,DAILY_05,01/13/ 04 10:45:03,00:02:43,550.66MB,1445,824,0,Completed At the end of the report is missed: ${MISSEDNODES},${NODEIPADDRESS},${TSM_SERVER_INFO},,${ASSIGNEDSCHEDULE}, ${ASSIGNEDSTARTTIME},,${STATUS} REPORTDB-IPP,10.81.215.14,TSM3.USSNTC6,10.81.96.22,,DAILY_03,01/13/04 08:00:00,,Missed PCLOBS1-IPP,,TSM3.USSNTC6,10.81.96.22,,DAILY_03,01/13/04 08:00:00,,Missed S216060SC1SW01,,TSM3.USSNTC6,10.81.96.22,,DAILY_05,01/13/04 10:00:00,,Missed Michael French Savvis Communications IDS01 Santa Clara, CA (408)450-7812 -- desk (408)239-9913 -- mobile -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Sent: Wednesday, January 14, 2004 5:19 AM To: [EMAIL PROTECTED] Subject: Re: Inconsistency between summary and actlog Ted By the way I almost always search for subject dealing with the same question , but sometimes the answers are very old and quite not absolutely cleared. So sorry if I ask again . Regards Robert -Original Message- From: Ted Byrne [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 3:02 PM To: [EMAIL PROTECTED] Subject: Re: Inconsistency between summary and actlog Robert, As Richard suggested, the many postings to ADSM-L regarding the summary table's contents (or lack thereof) are very informative. Among other things, the location of the Accounting records is detailed. Repeatedly. (The format is recorded in the Admin Guide.) Before posting a question to ADSM-L, search the message archives on adsm.org to see if the subject that's vexing you has discussed before. It's an invaluable resource, and it can save you considerable time in resolving whatever issue you are facing. Richard's ADSM QuickFacts web page (http://people.bu.edu/rbs/ADSM.QuickFacts) is another invaluable resource for the TSM administrator, whether novice or experienced. Ted At 02:22 PM 1/14/2004 +0200, you wrote: >Richard > >Thanks for the advice . Do you know where I can found the >format/structure of the accounting recor
Re: Inconsistency between summary and actlog
Ted By the way I almost always search for subject dealing with the same question , but sometimes the answers are very old and quite not absolutely cleared. So sorry if I ask again . Regards Robert -Original Message- From: Ted Byrne [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 3:02 PM To: [EMAIL PROTECTED] Subject: Re: Inconsistency between summary and actlog Robert, As Richard suggested, the many postings to ADSM-L regarding the summary table's contents (or lack thereof) are very informative. Among other things, the location of the Accounting records is detailed. Repeatedly. (The format is recorded in the Admin Guide.) Before posting a question to ADSM-L, search the message archives on adsm.org to see if the subject that's vexing you has discussed before. It's an invaluable resource, and it can save you considerable time in resolving whatever issue you are facing. Richard's ADSM QuickFacts web page (http://people.bu.edu/rbs/ADSM.QuickFacts) is another invaluable resource for the TSM administrator, whether novice or experienced. Ted At 02:22 PM 1/14/2004 +0200, you wrote: >Richard > >Thanks for the advice . Do you know where I can found the >format/structure of the accounting records (dsmaccnt.log) > >Regards Robert > > >-Original Message- >From: Richard Sims [mailto:[EMAIL PROTECTED] >Sent: Wednesday, January 14, 2004 2:19 PM >To: [EMAIL PROTECTED] >Subject: Re: Inconsistency between summary and actlog > >Robert - As you go through your professional life administering TSM, keep >one > thing in mind: the Summary table is unreliable. It has >historically >been unreliable. As testament, see the many postings from customers who >have >wasted their time trying to get reliable data from it. > >As we keep saying: Use the TSM accounting records as your principal source >of >data for usage statistics. That's what they are there for, and they >reliably >contain solid, basic data about sessions. Beyond that, use the Activity >Log, >the Events table, and client backup logs. > > Richard Sims, BU
Re: Inconsistency between summary and actlog
Robert, As Richard suggested, the many postings to ADSM-L regarding the summary table's contents (or lack thereof) are very informative. Among other things, the location of the Accounting records is detailed. Repeatedly. (The format is recorded in the Admin Guide.) Before posting a question to ADSM-L, search the message archives on adsm.org to see if the subject that's vexing you has discussed before. It's an invaluable resource, and it can save you considerable time in resolving whatever issue you are facing. Richard's ADSM QuickFacts web page (http://people.bu.edu/rbs/ADSM.QuickFacts) is another invaluable resource for the TSM administrator, whether novice or experienced. Ted At 02:22 PM 1/14/2004 +0200, you wrote: Richard Thanks for the advice . Do you know where I can found the format/structure of the accounting records (dsmaccnt.log) Regards Robert -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: Re: Inconsistency between summary and actlog Robert - As you go through your professional life administering TSM, keep one thing in mind: the Summary table is unreliable. It has historically been unreliable. As testament, see the many postings from customers who have wasted their time trying to get reliable data from it. As we keep saying: Use the TSM accounting records as your principal source of data for usage statistics. That's what they are there for, and they reliably contain solid, basic data about sessions. Beyond that, use the Activity Log, the Events table, and client backup logs. Richard Sims, BU
Re: Inconsistency between summary and actlog
Hi, also please note there is a bug about accounting records, up to version 5.1: as soon as your reach session number 64k, accounting will be erroneous, TSM server has to be restarted, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center SD/ESN Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 924 13 69 local K4-104 mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential. -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Wednesday,14. January 2004 13:39 To: [EMAIL PROTECTED] Subject: Re: Inconsistency between summary and actlog >Richard > >Thanks for the advice . Do you know where I can found the >format/structure of the accounting records (dsmaccnt.log) Sure, Robert: in the Admin Guide manual. See also "ACCOUNTING RECORD FORMAT" toward the bottom of http://people.bu.edu/rbs/ADSM.QuickFacts for further insight on field contents. Also on my http://people.bu.edu/rbs you can find a "professional level" Perl program which produces a report from the dsmaccnt.log file. I'm embarassed to say that the program still needs updating from its ADSMv3 level, but is can certainly form the foundation for tailoring to your site's needs. There are plenty of internal comments to make things apparent. Richard Sims, BU
Re: Inconsistency between summary and actlog
>OK Richard, then why did the propeller heads at IBM decide to use the >summary table for collecting stats for the Operational Reporter? > >I'm now sitting with ten nodes that don't get reported on, and the number is >growing. > >Leigh. Check for there being only one blade on the propeller. :-) Sometimes, development efforts occur outside the main development area, and those developers take things at face value as a premise for their development. I recommend the Dilbert day calendar as causal reference for such things. Richard
Re: Inconsistency between summary and actlog
>Richard > >Thanks for the advice . Do you know where I can found the >format/structure of the accounting records (dsmaccnt.log) Sure, Robert: in the Admin Guide manual. See also "ACCOUNTING RECORD FORMAT" toward the bottom of http://people.bu.edu/rbs/ADSM.QuickFacts for further insight on field contents. Also on my http://people.bu.edu/rbs you can find a "professional level" Perl program which produces a report from the dsmaccnt.log file. I'm embarassed to say that the program still needs updating from its ADSMv3 level, but is can certainly form the foundation for tailoring to your site's needs. There are plenty of internal comments to make things apparent. Richard Sims, BU
Re: Inconsistency between summary and actlog
OK Richard, then why did the propeller heads at IBM decide to use the summary table for collecting stats for the Operational Reporter? I'm now sitting with ten nodes that don't get reported on, and the number is growing. Leigh. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: 14 January 2004 14:19 PM To: [EMAIL PROTECTED] Subject: Re: Inconsistency between summary and actlog Robert - As you go through your professional life administering TSM, keep one thing in mind: the Summary table is unreliable. It has historically been unreliable. As testament, see the many postings from customers who have wasted their time trying to get reliable data from it. As we keep saying: Use the TSM accounting records as your principal source of data for usage statistics. That's what they are there for, and they reliably contain solid, basic data about sessions. Beyond that, use the Activity Log, the Events table, and client backup logs. Richard Sims, BU This communication is subject to specific restrictions and disclaimers. Details are contained at the following link: http://www.omam.com/OMAMSA_E-mail_Disclosure/
Re: Inconsistency between summary and actlog
Richard Thanks for the advice . Do you know where I can found the format/structure of the accounting records (dsmaccnt.log) Regards Robert -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: Re: Inconsistency between summary and actlog Robert - As you go through your professional life administering TSM, keep one thing in mind: the Summary table is unreliable. It has historically been unreliable. As testament, see the many postings from customers who have wasted their time trying to get reliable data from it. As we keep saying: Use the TSM accounting records as your principal source of data for usage statistics. That's what they are there for, and they reliably contain solid, basic data about sessions. Beyond that, use the Activity Log, the Events table, and client backup logs. Richard Sims, BU
Re: Inconsistency between summary and actlog
Robert - As you go through your professional life administering TSM, keep one thing in mind: the Summary table is unreliable. It has historically been unreliable. As testament, see the many postings from customers who have wasted their time trying to get reliable data from it. As we keep saying: Use the TSM accounting records as your principal source of data for usage statistics. That's what they are there for, and they reliably contain solid, basic data about sessions. Beyond that, use the Activity Log, the Events table, and client backup logs. Richard Sims, BU
Inconsistency between summary and actlog
Hello to everyone Run every day a script to collect the amount and time for clients backup as: SELECT ENTITY AS NODE, - CAST(SUM(BYTES/1024/1024) - AS DECIMAL(8,2)) AS "MB", - substr(cast(min(start_time) as char(26)),1,19) as "DATETIME ", - cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as "Length " - FROM SUMMARY - WHERE ACTIVITY IN ('BACKUP','ARCHIVE') - and current date - 1 days = date(Start_time) and time(start_time)>'18:00:00' - GROUP BY ENTITY - ORDER BY MB SELECT ENTITY AS NODE, - CAST(SUM(BYTES/1024/1024) - AS DECIMAL(8,2)) AS "MB", - substr(cast(min(start_time) as char(26)),1,19) as "DATETIME ", - cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as "Length " - FROM SUMMARY - WHERE ACTIVITY IN ('BACKUP','ARCHIVE') - and current date = date(Start_time) and time(end_time)<'08:00:00' - GROUP BY ENTITY - ORDER BY MB The OUTPUT look like: NODEMB DATETIME Length -- ---- - HIGHLEARN2K2766.09 2004-01-13 22:30:06 00:10:30 EXCHANGE1 57807.11 2004-01-13 22:07:16 01:38:54 NODEMB DATETIME Length -- -- -- - WEB2000_DB0.13 2004-01-14 03:30:07 00:00:23 EXCHANGE2 23187.052004-01-14 01:08:48 00:38:03 This script give almost all my clients but a few are missing but when running a query actlog the client missing as an output: 01/13/2004 23:04:02 ANE4952I (Session: 23, Node: IBROWSE2) Total number of objects inspected: 17,827 01/13/2004 23:04:02 ANE4954I (Session: 23, Node: IBROWSE2) Total number of objects backed up: 67 01/13/2004 23:04:02 ANE4958I (Session: 23, Node: IBROWSE2) Total number of objects updated: 0 01/13/2004 23:04:02 ANE4960I (Session: 23, Node: IBROWSE2) Total number of objects rebound: 0 01/13/2004 23:04:02 ANE4957I (Session: 23, Node: IBROWSE2) Total number of objects deleted: 0 01/13/2004 23:04:02 ANE4970I (Session: 23, Node: IBROWSE2) Total number of objects expired: 1 01/13/2004 23:04:02 ANE4959I (Session: 23, Node: IBROWSE2) Total number of objects failed: 0 01/13/2004 23:04:02 ANE4961I (Session: 23, Node: IBROWSE2) Total number of bytes transferred: 1.07 GB The node IBROWSE2 is not shown in my summary query ??? Why is a difference between summary table to actlog table Can I run something else to give me a correct result !!! Tsm Server version 5.1.8.0 on Windows2000 , Tsm client version 5.2.2.0 Regards Robert Ouzen E-mail: [EMAIL PROTECTED]
Inconsistency between summary and actlog
Hello to everyone Run every day a script to collect the amount and time for clients backup as: SELECT ENTITY AS NODE, - CAST(SUM(BYTES/1024/1024) - AS DECIMAL(8,2)) AS "MB", - substr(cast(min(start_time) as char(26)),1,19) as "DATETIME ", - cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as "Length " - FROM SUMMARY - WHERE ACTIVITY IN ('BACKUP','ARCHIVE') - and current date - 1 days = date(Start_time) and time(start_time)>'18:00:00' - GROUP BY ENTITY - ORDER BY MB SELECT ENTITY AS NODE, - CAST(SUM(BYTES/1024/1024) - AS DECIMAL(8,2)) AS "MB", - substr(cast(min(start_time) as char(26)),1,19) as "DATETIME ", - cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as "Length " - FROM SUMMARY - WHERE ACTIVITY IN ('BACKUP','ARCHIVE') - and current date = date(Start_time) and time(end_time)<'08:00:00' - GROUP BY ENTITY - ORDER BY MB The OUTPUT look like: NODEMB DATETIME Length -- ---- - HIGHLEARN2K2766.09 2004-01-13 22:30:06 00:10:30 EXCHANGE1 57807.11 2004-01-13 22:07:16 01:38:54 NODEMB DATETIME Length -- -- -- - WEB2000_DB0.13 2004-01-14 03:30:07 00:00:23 EXCHANGE2 23187.052004-01-14 01:08:48 00:38:03 This script give almost all my clients but a few are missing but when running a query actlog the client missing as an output: 01/13/2004 23:04:02 ANE4952I (Session: 23, Node: IBROWSE2) Total number of objects inspected: 17,827 01/13/2004 23:04:02 ANE4954I (Session: 23, Node: IBROWSE2) Total number of objects backed up: 67 01/13/2004 23:04:02 ANE4958I (Session: 23, Node: IBROWSE2) Total number of objects updated: 0 01/13/2004 23:04:02 ANE4960I (Session: 23, Node: IBROWSE2) Total number of objects rebound: 0 01/13/2004 23:04:02 ANE4957I (Session: 23, Node: IBROWSE2) Total number of objects deleted: 0 01/13/2004 23:04:02 ANE4970I (Session: 23, Node: IBROWSE2) Total number of objects expired: 1 01/13/2004 23:04:02 ANE4959I (Session: 23, Node: IBROWSE2) Total number of objects failed: 0 01/13/2004 23:04:02 ANE4961I (Session: 23, Node: IBROWSE2) Total number of bytes transferred: 1.07 GB The node IBROWSE2 is not shown in my summary query ??? Why is a difference between summary table to actlog table Can I run something else to give me a correct result !!!
Recall: Inconsistency between summary and actlog
רוברט אוזן would like to recall the message, "Inconsistency between summary and actlog".
re> Subject: TSM Server 5.2.2.0 actlog prob {Scanned}
Problem: The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. I see we have written an APAR for this issue, dated 01-06-04 refer to APAR # IC38868 regards -Darrius Darrius Plantz IBM Software Group - Tivoli Solutions Storage (TSM) Field Issues Mgr, Field Input Communications Team [EMAIL PROTECTED] ** Try us out! Our web Support site is at: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
Re: ANR9999D ssrecons.c(2412) & (2398) errors in Actlog
... >o - ANRD ssrecons.c(2412) and (2398) ... David - The numbers in parentheses don't much matter, as they are just the source code line numbers involved with the message for that VRML instance of the software (noted in ADSM QuickFacts). What you need, for a better (but perhaps still limited) sense of the error is the text that should accompany the message number. You may have to do 'Set CONTEXTmessaging ON' to get it. Thereafter, the IBM database can be searched for possible causes and cures. Richard Sims, BU
ANR9999D ssrecons.c(2412) & (2398) errors in Actlog
All, Hmn, funny one this. o - Win2K AS, Compaq/HP DL380 G2, 5.1.6.2 TSM Server, DLT drives. Getting ANRD errors in actlog every 3 to 30 minutes - i.e. *loads* of them: o - ANRD ssrecons.c(2412) and (2398) Had a quick look on the list archive, RBS's substantial-facts and big-blue.com but haven't found any mentions of these specific 'ssrecons.c' numbers. Various other 'ssrecons.c' articles mention everything from 'uselargecommbuffers' to 'errors reading two sided optical media', but nothing that quite fits the error/line number (i.e. 2412 or 2398) I'm seeing. They've been occurring in the actlog for as far back as I can see on this TSM server with a frequency of every 2 or 30 to every 30 or so minutes. I'm feeling that they might be tape-drive related, but I can't see any evidence to back this up... I haven't noticed any other problems on the server, however. Anyone else seen these? Rgds, David McClelland Management Systems Integrator Global Management Systems Reuters 85 Fleet Street London EC4P 4AJ E-mail [EMAIL PROTECTED] Reuters Messaging [EMAIL PROTECTED] --- - Visit our Internet site at http://www.reuters.com Get closer to the financial markets with Reuters Messaging - for more information and to register, visit http://www.reuters.com/messaging Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
Re: TSM Server 5.2.2.0 actlog prob
APAR IC38868 has been opened for thishere's the fix we got from support: The solution is: = 1. Edit dsmserv.idl file: Find following line: ddefine parm actlog query name=domainname type=sellist value="select - domain_name from domains" default="" title=23230 Change the default="" to default=" " (add a space) save file 2. rerun the idl file = Regards, Bob McCole Manager, Computing Services American Management Systems, Inc. 703-267-5347 (voice) 703-267-5380 (fax) John Monahan <[EMAIL PROTECTED]To: [EMAIL PROTECTED] S.COM> cc: Sent by: "ADSM: Subject: TSM Server 5.2.2.0 actlog prob Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 01/08/2004 06:42 PM Please respond to "ADSM: Dist Stor Manager" I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was upgraded from 5.1.6 something. The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. A help query actlog reveals: DOmainname Specifies that the query displays messages logged for a particular policy domain to which a named schedule belongs. This parameter is optional, unless you are specifying a schedule name. I am not specifying a schedule, this is just the default actlog query from a browser. I can't change the domainname field to be blank in the browser, it is a drop down list only. I can make the query work by changing the default originator from ALL to CLIENT. It seems that the domainname field is only valid when the originator is CLIENT anyway, but there is no way to blank the domainname field out in the browser for the originators of ALL or SERVER. Anyone else have 5.2.2.0 installed yet and see this problem? __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com
Re: TSM Server 5.2.2.0 actlog prob
Hello, there is an APAR open (sorry, I dont have the APAR number on hand). Bye Rainer Tammer On Fri, 9 Jan 2004 09:14:11 +0100, Loon, E.J. van - SPLXM wrote: >Hi John! >I see the same resonse here on my AIX 5.2.2.0 server. This really looks like >a bug to me! >Kindest regards, >Eric van Loon >KLM Royal Dutch Airlines > >-Original Message- >From: John Monahan [mailto:[EMAIL PROTECTED] >Sent: Friday, January 09, 2004 00:43 >To: [EMAIL PROTECTED] >Subject: TSM Server 5.2.2.0 actlog prob {Scanned} > > > I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was >upgraded from 5.1.6 something. > >The default activity log query from the web browser is not working. I get: >ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. > >A help query actlog reveals: >DOmainname > Specifies that the query displays messages logged for a > particular policy domain to which a named schedule belongs. > This parameter is optional, unless you are specifying a > schedule name. > >I am not specifying a schedule, this is just the default actlog query from >a browser. I can't change the domainname field to be blank in the browser, >it is a drop down list only. I can make the query work by changing the >default originator from ALL to CLIENT. It seems that the domainname field >is only valid when the originator is CLIENT anyway, but there is no way to >blank the domainname field out in the browser for the originators of ALL or >SERVER. > >Anyone else have 5.2.2.0 installed yet and see this problem? > >__ >John Monahan >Senior Consultant Enterprise Solutions >Computech Resources, Inc. >Office: 952-833-0930 ext 109 >Cell: 952-221-6938 >http://www.computechresources.com > > >** >For information, services and offers, please visit our web site: http://www.klm.com. >This e-mail and any attachment may contain confidential and privileged material >intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e- mail or any attachments, nor responsible for any delay in receipt. >** >
Re: TSM Server 5.2.2.0 actlog prob
Same problem here on a small old RS/6000 E20 test server, AIX 5.1 TSM 5.2.2.0. 'help q act' shows domainname as parameter but omits a description of the parameter... -Marcel On Fri, Jan 09, 2004 at 09:27:31AM +0100, Moonen, LJL (Bert) wrote: > Hello guys, > > we are running on a AIX server M80 (aix version 5.2) with TSM 5.2.2., for us > all works fine. > We don't have any problems. > Probably this only occors when running a windows server. > > ABP / USZO CIS / BS / TB / Storage Management > Telefoon : +31(0)45 579 7773 > Fax : +31(0)45 579 3990 > Email : [EMAIL PROTECTED] > Centrale Mailbox : Centrale Mailbox - BS Storage (eumbx05) > > Tech Support: "Have you made backups of your software and data?" > Customer: "I didn't know it had a reverse." > > > -Oorspronkelijk bericht- > Van: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 9 januari 2004 9:14 > Aan: [EMAIL PROTECTED] > Onderwerp: Re: TSM Server 5.2.2.0 actlog prob > > > Hi John! > I see the same resonse here on my AIX 5.2.2.0 server. This really looks like > a bug to me! > Kindest regards, > Eric van Loon > KLM Royal Dutch Airlines > > -Original Message- > From: John Monahan [mailto:[EMAIL PROTECTED] > Sent: Friday, January 09, 2004 00:43 > To: [EMAIL PROTECTED] > Subject: TSM Server 5.2.2.0 actlog prob {Scanned} > > > I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was > upgraded from 5.1.6 something. > > The default activity log query from the web browser is not working. I get: > ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. > > A help query actlog reveals: > DOmainname >Specifies that the query displays messages logged for a >particular policy domain to which a named schedule belongs. >This parameter is optional, unless you are specifying a >schedule name. > > I am not specifying a schedule, this is just the default actlog query from > a browser. I can't change the domainname field to be blank in the browser, > it is a drop down list only. I can make the query work by changing the > default originator from ALL to CLIENT. It seems that the domainname field > is only valid when the originator is CLIENT anyway, but there is no way to > blank the domainname field out in the browser for the originators of ALL or > SERVER. > > Anyone else have 5.2.2.0 installed yet and see this problem? > > __ > John Monahan > Senior Consultant Enterprise Solutions > Computech Resources, Inc. > Office: 952-833-0930 ext 109 > Cell: 952-221-6938 > http://www.computechresources.com > > > ** > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain confidential > and privileged material intended for the addressee only. If you are not the > addressee, you are notified that no part of the e-mail or any attachment may > be disclosed, copied or distributed, and that any other action related to > this e-mail or attachment is strictly prohibited, and may be unlawful. If > you have received this e-mail by error, please notify the sender immediately > by return e-mail, and delete this message. Koninklijke Luchtvaart > Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be > liable for the incorrect or incomplete transmission of this e-mail or any > attachments, nor responsible for any delay in receipt. > ** > > > =DISCLAIMER= > > De informatie in dit e-mailbericht is vertrouwelijk en uitsluitend bestemd voor de > geadresseerde. Wanneer u dit bericht per abuis ontvangt, verzoeken wij u contact op > te nemen met de afzender per kerende e-mail. Verder verzoeken wij u in dat geval dit > e-mailbericht te vernietigen en de inhoud ervan aan niemand openbaar te maken. Wij > aanvaarden geen aansprakelijkheid voor onjuiste, onvolledige dan wel ontijdige > overbrenging van de inhoud van een verzonden e-mailbericht, noch voor daarbij > overgebrachte virussen. > > The information contained in this e-mail is confidential and may be privileged. It > may be read, copied and used only by the intended recipient. If you have received it > in error, please contact the sender immediately by return e-mail; please delete in > this case the e-mail and do not disclose its contents to any person. We don't accept > liability for any errors, omissions, delays of receip
Re: TSM Server 5.2.2.0 actlog prob {Scanned}
Hi Bert! That's what I thought... But that wasn't Johns question, he stated that he encountered a bug in the web GUI. You're response is something like: "Dear car repair man, my motor doesn't start." "Well sir, your bike is working, isn't it?" ;-) Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Moonen, LJL (Bert) [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:14 To: [EMAIL PROTECTED] Subject: Re: TSM Server 5.2.2.0 actlog prob {Scanned} Hi Eric, I always work with the command line. The q actlog command does work fine, no problems. ABP / USZO CIS / BS / TB / Storage Management Telefoon : +31(0)45 579 7773 Fax : +31(0)45 579 3990 Email : [EMAIL PROTECTED] Centrale Mailbox : Centrale Mailbox - BS Storage (eumbx05) -Oorspronkelijk bericht- Van: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 9 januari 2004 10:11 Aan: [EMAIL PROTECTED] Onderwerp: Re: TSM Server 5.2.2.0 actlog prob {Scanned} Hi Bert! Are you sure? When I select Object View, Server, Activity Log from the Web admin interface I get a screen with the following fields: Begin Date (current date filled) Begin Time (NOW-1:00 filled) End Date (current date filled) End Time (NOW filled) Message number (empty) Search string (empty) Originator (ALL is the default) Session (empty) Node Name (empty) Client Owner (empty) Schedule Name (empty) Policy Domain Name (first Policy domain filled) When you leave all defaults as they are and click the Finish button you will receive the Invalid parameter - DOMAINNAME error. John is right, the default value for the Policy Domain Name field should be blank, but it's not and it's also not available in the pull-down field... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Moonen, LJL (Bert) [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 09:28 To: [EMAIL PROTECTED] Subject: Re: TSM Server 5.2.2.0 actlog prob {Scanned} Hello guys, we are running on a AIX server M80 (aix version 5.2) with TSM 5.2.2., for us all works fine. We don't have any problems. Probably this only occors when running a windows server. ABP / USZO CIS / BS / TB / Storage Management Telefoon : +31(0)45 579 7773 Fax : +31(0)45 579 3990 Email : [EMAIL PROTECTED] Centrale Mailbox : Centrale Mailbox - BS Storage (eumbx05) Tech Support: "Have you made backups of your software and data?" Customer: "I didn't know it had a reverse." -Oorspronkelijk bericht- Van: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 9 januari 2004 9:14 Aan: [EMAIL PROTECTED] Onderwerp: Re: TSM Server 5.2.2.0 actlog prob Hi John! I see the same resonse here on my AIX 5.2.2.0 server. This really looks like a bug to me! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: John Monahan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 00:43 To: [EMAIL PROTECTED] Subject: TSM Server 5.2.2.0 actlog prob {Scanned} I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was upgraded from 5.1.6 something. The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. A help query actlog reveals: DOmainname Specifies that the query displays messages logged for a particular policy domain to which a named schedule belongs. This parameter is optional, unless you are specifying a schedule name. I am not specifying a schedule, this is just the default actlog query from a browser. I can't change the domainname field to be blank in the browser, it is a drop down list only. I can make the query work by changing the default originator from ALL to CLIENT. It seems that the domainname field is only valid when the originator is CLIENT anyway, but there is no way to blank the domainname field out in the browser for the originators of ALL or SERVER. Anyone else have 5.2.2.0 installed yet and see this problem? __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappi
Re: TSM Server 5.2.2.0 actlog prob {Scanned}
Hi Eric, I always work with the command line. The q actlog command does work fine, no problems. ABP / USZO CIS / BS / TB / Storage Management Telefoon : +31(0)45 579 7773 Fax : +31(0)45 579 3990 Email : [EMAIL PROTECTED] Centrale Mailbox : Centrale Mailbox - BS Storage (eumbx05) -Oorspronkelijk bericht- Van: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 9 januari 2004 10:11 Aan: [EMAIL PROTECTED] Onderwerp: Re: TSM Server 5.2.2.0 actlog prob {Scanned} Hi Bert! Are you sure? When I select Object View, Server, Activity Log from the Web admin interface I get a screen with the following fields: Begin Date (current date filled) Begin Time (NOW-1:00 filled) End Date (current date filled) End Time (NOW filled) Message number (empty) Search string (empty) Originator (ALL is the default) Session (empty) Node Name (empty) Client Owner (empty) Schedule Name (empty) Policy Domain Name (first Policy domain filled) When you leave all defaults as they are and click the Finish button you will receive the Invalid parameter - DOMAINNAME error. John is right, the default value for the Policy Domain Name field should be blank, but it's not and it's also not available in the pull-down field... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Moonen, LJL (Bert) [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 09:28 To: [EMAIL PROTECTED] Subject: Re: TSM Server 5.2.2.0 actlog prob {Scanned} Hello guys, we are running on a AIX server M80 (aix version 5.2) with TSM 5.2.2., for us all works fine. We don't have any problems. Probably this only occors when running a windows server. ABP / USZO CIS / BS / TB / Storage Management Telefoon : +31(0)45 579 7773 Fax : +31(0)45 579 3990 Email : [EMAIL PROTECTED] Centrale Mailbox : Centrale Mailbox - BS Storage (eumbx05) Tech Support: "Have you made backups of your software and data?" Customer: "I didn't know it had a reverse." -Oorspronkelijk bericht- Van: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 9 januari 2004 9:14 Aan: [EMAIL PROTECTED] Onderwerp: Re: TSM Server 5.2.2.0 actlog prob Hi John! I see the same resonse here on my AIX 5.2.2.0 server. This really looks like a bug to me! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: John Monahan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 00:43 To: [EMAIL PROTECTED] Subject: TSM Server 5.2.2.0 actlog prob {Scanned} I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was upgraded from 5.1.6 something. The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. A help query actlog reveals: DOmainname Specifies that the query displays messages logged for a particular policy domain to which a named schedule belongs. This parameter is optional, unless you are specifying a schedule name. I am not specifying a schedule, this is just the default actlog query from a browser. I can't change the domainname field to be blank in the browser, it is a drop down list only. I can make the query work by changing the default originator from ALL to CLIENT. It seems that the domainname field is only valid when the originator is CLIENT anyway, but there is no way to blank the domainname field out in the browser for the originators of ALL or SERVER. Anyone else have 5.2.2.0 installed yet and see this problem? __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ** =DISCLAIMER= De informatie in dit e-mailbericht is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Wanneer u dit bericht per abuis ontvangt, verzoeken wij u contact op te nemen met de afzender per
Re: TSM Server 5.2.2.0 actlog prob {Scanned}
Hi Bert! Are you sure? When I select Object View, Server, Activity Log from the Web admin interface I get a screen with the following fields: Begin Date (current date filled) Begin Time (NOW-1:00 filled) End Date (current date filled) End Time (NOW filled) Message number (empty) Search string (empty) Originator (ALL is the default) Session (empty) Node Name (empty) Client Owner (empty) Schedule Name (empty) Policy Domain Name (first Policy domain filled) When you leave all defaults as they are and click the Finish button you will receive the Invalid parameter - DOMAINNAME error. John is right, the default value for the Policy Domain Name field should be blank, but it's not and it's also not available in the pull-down field... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Moonen, LJL (Bert) [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 09:28 To: [EMAIL PROTECTED] Subject: Re: TSM Server 5.2.2.0 actlog prob {Scanned} Hello guys, we are running on a AIX server M80 (aix version 5.2) with TSM 5.2.2., for us all works fine. We don't have any problems. Probably this only occors when running a windows server. ABP / USZO CIS / BS / TB / Storage Management Telefoon : +31(0)45 579 7773 Fax : +31(0)45 579 3990 Email : [EMAIL PROTECTED] Centrale Mailbox : Centrale Mailbox - BS Storage (eumbx05) Tech Support: "Have you made backups of your software and data?" Customer: "I didn't know it had a reverse." -Oorspronkelijk bericht- Van: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 9 januari 2004 9:14 Aan: [EMAIL PROTECTED] Onderwerp: Re: TSM Server 5.2.2.0 actlog prob Hi John! I see the same resonse here on my AIX 5.2.2.0 server. This really looks like a bug to me! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: John Monahan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 00:43 To: [EMAIL PROTECTED] Subject: TSM Server 5.2.2.0 actlog prob {Scanned} I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was upgraded from 5.1.6 something. The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. A help query actlog reveals: DOmainname Specifies that the query displays messages logged for a particular policy domain to which a named schedule belongs. This parameter is optional, unless you are specifying a schedule name. I am not specifying a schedule, this is just the default actlog query from a browser. I can't change the domainname field to be blank in the browser, it is a drop down list only. I can make the query work by changing the default originator from ALL to CLIENT. It seems that the domainname field is only valid when the originator is CLIENT anyway, but there is no way to blank the domainname field out in the browser for the originators of ALL or SERVER. Anyone else have 5.2.2.0 installed yet and see this problem? __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ** =DISCLAIMER= De informatie in dit e-mailbericht is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Wanneer u dit bericht per abuis ontvangt, verzoeken wij u contact op te nemen met de afzender per kerende e-mail. Verder verzoeken wij u in dat geval dit e-mailbericht te vernietigen en de inhoud ervan aan niemand openbaar te maken. Wij aanvaarden geen aansprakelijkheid voor onjuiste, onvolledige dan wel ontijdige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor daarbij overgebrachte virussen. The information contained in this e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in
Re: TSM Server 5.2.2.0 actlog prob
Hello guys, we are running on a AIX server M80 (aix version 5.2) with TSM 5.2.2., for us all works fine. We don't have any problems. Probably this only occors when running a windows server. ABP / USZO CIS / BS / TB / Storage Management Telefoon : +31(0)45 579 7773 Fax : +31(0)45 579 3990 Email : [EMAIL PROTECTED] Centrale Mailbox : Centrale Mailbox - BS Storage (eumbx05) Tech Support: "Have you made backups of your software and data?" Customer: "I didn't know it had a reverse." -Oorspronkelijk bericht- Van: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 9 januari 2004 9:14 Aan: [EMAIL PROTECTED] Onderwerp: Re: TSM Server 5.2.2.0 actlog prob Hi John! I see the same resonse here on my AIX 5.2.2.0 server. This really looks like a bug to me! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: John Monahan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 00:43 To: [EMAIL PROTECTED] Subject: TSM Server 5.2.2.0 actlog prob {Scanned} I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was upgraded from 5.1.6 something. The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. A help query actlog reveals: DOmainname Specifies that the query displays messages logged for a particular policy domain to which a named schedule belongs. This parameter is optional, unless you are specifying a schedule name. I am not specifying a schedule, this is just the default actlog query from a browser. I can't change the domainname field to be blank in the browser, it is a drop down list only. I can make the query work by changing the default originator from ALL to CLIENT. It seems that the domainname field is only valid when the originator is CLIENT anyway, but there is no way to blank the domainname field out in the browser for the originators of ALL or SERVER. Anyone else have 5.2.2.0 installed yet and see this problem? __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ** =DISCLAIMER= De informatie in dit e-mailbericht is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Wanneer u dit bericht per abuis ontvangt, verzoeken wij u contact op te nemen met de afzender per kerende e-mail. Verder verzoeken wij u in dat geval dit e-mailbericht te vernietigen en de inhoud ervan aan niemand openbaar te maken. Wij aanvaarden geen aansprakelijkheid voor onjuiste, onvolledige dan wel ontijdige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor daarbij overgebrachte virussen. The information contained in this e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail; please delete in this case the e-mail and do not disclose its contents to any person. We don't accept liability for any errors, omissions, delays of receipt or viruses in the contents of this message which arise as a result of e-mail transmission.
Re: TSM Server 5.2.2.0 actlog prob
Hi John! I see the same resonse here on my AIX 5.2.2.0 server. This really looks like a bug to me! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: John Monahan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 00:43 To: [EMAIL PROTECTED] Subject: TSM Server 5.2.2.0 actlog prob {Scanned} I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was upgraded from 5.1.6 something. The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. A help query actlog reveals: DOmainname Specifies that the query displays messages logged for a particular policy domain to which a named schedule belongs. This parameter is optional, unless you are specifying a schedule name. I am not specifying a schedule, this is just the default actlog query from a browser. I can't change the domainname field to be blank in the browser, it is a drop down list only. I can make the query work by changing the default originator from ALL to CLIENT. It seems that the domainname field is only valid when the originator is CLIENT anyway, but there is no way to blank the domainname field out in the browser for the originators of ALL or SERVER. Anyone else have 5.2.2.0 installed yet and see this problem? __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
TSM Server 5.2.2.0 actlog prob
I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was upgraded from 5.1.6 something. The default activity log query from the web browser is not working. I get: ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME. A help query actlog reveals: DOmainname Specifies that the query displays messages logged for a particular policy domain to which a named schedule belongs. This parameter is optional, unless you are specifying a schedule name. I am not specifying a schedule, this is just the default actlog query from a browser. I can't change the domainname field to be blank in the browser, it is a drop down list only. I can make the query work by changing the default originator from ALL to CLIENT. It seems that the domainname field is only valid when the originator is CLIENT anyway, but there is no way to blank the domainname field out in the browser for the originators of ALL or SERVER. Anyone else have 5.2.2.0 installed yet and see this problem? __ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.computechresources.com
Re: Messed-up message in actlog
Hi Eric, I'm seeing the same kind of things (double messages in one line), but for informix backups ! I already posted on that topic on 21th of this month (search for informix + hieroglyphs to find my post), without any answer :-( I suppose this is a new "feature" from TSM, but is it due to server, client or API, no idea ! Cheers. Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -Original Message- From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 August, 2003 10:47 To: [EMAIL PROTECTED] Subject: Messed-up message in actlog Hi *SM-ers! Lately I'm seeing more and more of the following lines in the activity log: ANE4994S (Session: 1164403, Node: KL1003VC-ORC) TDP Oracle AIX ANU0599 ANU2602E The object /mount/appl1//c-213141136-20030826-11 was not found on the TSM Server Note the multiple message numbers in just one line! I know the error itself is no problem (just TDP for Oracle preventing duplicate file names before allocating a file) but since the message has been changed my filtering doesn't work no more. Has anybody seen this before? Looks like a bug (or feature ;-) to me... Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Messed-up message in actlog
Hi *SM-ers! Lately I'm seeing more and more of the following lines in the activity log: ANE4994S (Session: 1164403, Node: KL1003VC-ORC) TDP Oracle AIX ANU0599 ANU2602E The object /mount/appl1//c-213141136-20030826-11 was not found on the TSM Server Note the multiple message numbers in just one line! I know the error itself is no problem (just TDP for Oracle preventing duplicate file names before allocating a file) but since the message has been changed my filtering doesn't work no more. Has anybody seen this before? Looks like a bug (or feature ;-) to me... Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
error message in tsm actlog while checking in scratch tape
anyone ever see this before in the actlog while trying to checkin a scratch tape?: ANR2033E QUERY STGPOOL: Command failed - lock conflict. ANR0405I Session 107371 ended for administrator ADMIN (AIX). ANRD mmslib.c(7894): ThreadId<79> Test storage volume failed - rc = 142. ANRD mmslib.c(7815): ThreadId<79> Could not determine if volume VR7649 in library TSMLIB2 is defined to a storage pool. thanks in advance!. --Justin Richard Bleistein Unix/TSM Systems Administrator (Sungard eSourcing) Desk: (856) 566 - 3485 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Re: Difference between results actlog and summary
From: brian welsh [mailto:[EMAIL PROTECTED] > The result of a back-up schedule looks like this in the actlog: > 08/12/03 06:01:52 ANE4952I (Session: 10317, Node: ABC) > Total number of > objects inspected: 132,391 > 08/12/03 06:01:52 ANE4954I (Session: 10317, Node: ABCL) > Total number of > objects backed up:1,666 > > When I query the summary table I get the following results > for the back-up > activity: > START_TIME: 2003-08-12 05:30:03.00 > END_TIME: 2003-08-12 06:01:54.00 > ACTIVITY: BACKUP > NUMBER: 10317 > ENTITY: ABC > COMMMETH: Tcp/Ip > ADDRESS:xxx.xx.xxx.xx:42581 > SCHEDULE_NAME: x > EXAMINED: 132 > AFFECTED: 1 > FAILED: 0 > BYTES: 3008563568 > IDLE: 1902 > MEDIAW: 0 > PROCESSES: 1 > SUCCESSFUL: YES > > Why shows the summary table examined 132 and the actlog > 132,391 inspected? > The same is happening for affected and backed up! This list has discussed this issue *repeatedly* over the last year or so. Please consult the archives at http://search.adsm.org before posting questions. Summary results, particular in the TSM server version 4 range, are notoriously unreliable. -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627
Difference between results actlog and summary
Hello, The result of a back-up schedule looks like this in the actlog: 08/12/03 06:01:52 ANE4952I (Session: 10317, Node: ABC) Total number of objects inspected: 132,391 08/12/03 06:01:52 ANE4954I (Session: 10317, Node: ABCL) Total number of objects backed up:1,666 When I query the summary table I get the following results for the back-up activity: START_TIME: 2003-08-12 05:30:03.00 END_TIME: 2003-08-12 06:01:54.00 ACTIVITY: BACKUP NUMBER: 10317 ENTITY: ABC COMMMETH: Tcp/Ip ADDRESS:xxx.xx.xxx.xx:42581 SCHEDULE_NAME: x EXAMINED: 132 AFFECTED: 1 FAILED: 0 BYTES: 3008563568 IDLE: 1902 MEDIAW: 0 PROCESSES: 1 SUCCESSFUL: YES Why shows the summary table examined 132 and the actlog 132,391 inspected? The same is happening for affected and backed up! Thanks in advance, Brian _ MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
Re: Difference output between table summary and actlog
... >My TSM Server version is 5.1.7.0 ... But what are your client levels? They need to be recent, too. This topic was extensively discussed about four weeks ago. See the List archives. See also "Summary Records Missing for B/A Client Sessions" (search at IBM.COM). Richard Sims, BU
Difference output between table summary and actlog
Hi to all Run this everyday to collect the amount of MB and length of backup nodes. SELECT ENTITY AS NODE, - CAST(SUM(BYTES/1024/1024) - AS DECIMAL(8,2)) AS "MB", - substr(cast(min(start_time) as char(26)),1,19) as "DATETIME ", - cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as "Length " - FROM SUMMARY - WHERE ACTIVITY IN ('BACKUP','ARCHIVE') - and date(Start_time)=current date - 1 days and time(start_time)>'08:00:00' - GROUP BY ENTITY - ORDER BY MB Here the result: NODEMBDATETIME Length -- -- -- - HIGHLEARN0.00 2003-07-18 23:00:01 01:12:20 MARVEL0.00 2003-07-18 18:00:28 00:15:05 NOVMESHEK 0.00 2003-07-18 23:30:13 00:12:06 NOVMINHAL 0.00 2003-07-18 23:50:03 00:26:27 WEB2000 0.00 2003-07-18 23:00:07 00:11:31 NSNEW 854.37 2003-07-18 21:36:02 00:05:01 NOVNDPS 1265.542003-07-18 23:30:14 00:15:59 When i run a q actlog begint=-15 s=marvel I got: 07/18/2003 18:15:33 ANE4952I (Session: 250, Node: MARVEL) Total number of objects inspected: 65,911 07/18/2003 18:15:33 ANE4954I (Session: 250, Node: MARVEL) Total number of objects backed up: 45 07/18/2003 18:15:33 ANE4958I (Session: 250, Node: MARVEL) Total number of objects updated: 0 07/18/2003 18:15:33 ANE4960I (Session: 250, Node: MARVEL) Total number of objects rebound: 0 07/18/2003 18:15:33 ANE4957I (Session: 250, Node: MARVEL) Total number of objects deleted: 0 07/18/2003 18:15:33 ANE4970I (Session: 250, Node: MARVEL) Total number of objects expired: 4 07/18/2003 18:15:33 ANE4959I (Session: 250, Node: MARVEL) Total number of objects failed: 2 07/18/2003 18:15:33 ANE4961I (Session: 250, Node: MARVEL) Total number of bytes transferred: 1.25 GB 07/18/2003 18:15:33 ANE4963I (Session: 250, Node: MARVEL) Data transfer time: 620.25 sec 07/18/2003 18:15:33 ANE4964I (Session: 250, Node: MARVEL) Elapsed processing time:00:15:03 As you see the total number of bytes transferred is: 1.25G and on my select command from summary I got 0:00 . The elapsed processing time is correct on the select command. My TSM Server version is 5.1.7.0 Can someone advise why the difference between the tables summary and actlog ?? Thanks in Advance ... Regards Robert Ouzen Haifa University Israel E-mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
Re: Actlog & the database
I agree with Richard, but instead of q actlog dumps, we use the dsmulog utility (see the TSM/AIX Admin Ref, Appendix A, IBM Tivoli Storage Manager Utilities) to capture all stdout from the server into rotating logs. It date/time stamps. We then have scripts that copy the most recent closed logs into an arc directory. From that directory, we archive/delete those logs after 120 days, archiving for 2 years. To be honest, I don't recall the last time I did a q actlog. vi and grep are much more convenient for me. Oh, two more benefits of this. 1: I use gresham edt elm. All the elm messages go to TSM stdout, so they're captured in my dsmulogs. It greatly eases troubleshooting of issues that may be elm related. 2: Sometimes TSM may lose actlog messages, so you might have gaps (the old too-many-actlog-messages-at-once issue, and sometimes before a crash). This way I always have that information. Hmm... Now that I think about it, I don't recall that happening recently, but I know it was an issue in older versions. Or maybe I don't look at the actlog anymore, so I don't notice whether or not it lost messages? I'll have to keep that in mind. Alex Paschal Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Ben Bullock [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 7:22 AM To: [EMAIL PROTECTED] Subject: Re: Actlog & the database At our site, we run our TSM servers with a 7 day activity log retention. However, we run our TSM servers on AIX and when we start them up we use the nohup command ( nohup dsmserv mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 6:21 AM To: [EMAIL PROTECTED] Subject: Re: Actlog & the database >I have some ideas about the questions I'm about to ask but I need some other >opinions. What is the relationship between the activity log retention period >and the size of the TSM database. For example, the production database that I >work with has a size of 52 GB and the actlog retention period is 90 days. Would >the size of the database noticably decrease if the actlog retention was set to >7 days? (Extraneous info: I piped the output from "q actlog >begindate=01/01/2003" to file and the file is about 500 MB.) You've answered your own question as to space usage, via the astute 'q actlog' experiment. The Activity Log impact on the database is usually modest, depending upon how busy your server is. >Is there a way to "archive" the activity log so that it could be "imported" >later? There's no reason to import it - it's just text. What I - and probably other shops - do is leave about 30 days worth in the db for convenience, but via 'q actlog' capture period images, redirected to an OS file, which is then retained somewhere. In this way I keep five years of server activity logs as individual day files, in HSM. These I can inspect with customary Unix commands: grep, less, etc. As always, I urge sites to retain activity logs for about as long as your oldest still-filled tapes, as your reference for inevitable research into how any given tape ended up the way it is. Your auditors may impose such requirements. Richard Sims, BU
Re: Actlog & the database
At our site, we run our TSM servers with a 7 day activity log retention. However, we run our TSM servers on AIX and when we start them up we use the nohup command ( nohup dsmserv mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 6:21 AM To: [EMAIL PROTECTED] Subject: Re: Actlog & the database >I have some ideas about the questions I'm about to ask but I need some other >opinions. What is the relationship between the activity log retention period >and the size of the TSM database. For example, the production database that I >work with has a size of 52 GB and the actlog retention period is 90 days. Would >the size of the database noticably decrease if the actlog retention was set to >7 days? (Extraneous info: I piped the output from "q actlog >begindate=01/01/2003" to file and the file is about 500 MB.) You've answered your own question as to space usage, via the astute 'q actlog' experiment. The Activity Log impact on the database is usually modest, depending upon how busy your server is. >Is there a way to "archive" the activity log so that it could be "imported" >later? There's no reason to import it - it's just text. What I - and probably other shops - do is leave about 30 days worth in the db for convenience, but via 'q actlog' capture period images, redirected to an OS file, which is then retained somewhere. In this way I keep five years of server activity logs as individual day files, in HSM. These I can inspect with customary Unix commands: grep, less, etc. As always, I urge sites to retain activity logs for about as long as your oldest still-filled tapes, as your reference for inevitable research into how any given tape ended up the way it is. Your auditors may impose such requirements. Richard Sims, BU
Re: Actlog & the database
>I have some ideas about the questions I'm about to ask but I need some other >opinions. What is the relationship between the activity log retention period >and the size of the TSM database. For example, the production database that I >work with has a size of 52 GB and the actlog retention period is 90 days. Would >the size of the database noticably decrease if the actlog retention was set to >7 days? (Extraneous info: I piped the output from "q actlog >begindate=01/01/2003" to file and the file is about 500 MB.) You've answered your own question as to space usage, via the astute 'q actlog' experiment. The Activity Log impact on the database is usually modest, depending upon how busy your server is. >Is there a way to "archive" the activity log so that it could be "imported" >later? There's no reason to import it - it's just text. What I - and probably other shops - do is leave about 30 days worth in the db for convenience, but via 'q actlog' capture period images, redirected to an OS file, which is then retained somewhere. In this way I keep five years of server activity logs as individual day files, in HSM. These I can inspect with customary Unix commands: grep, less, etc. As always, I urge sites to retain activity logs for about as long as your oldest still-filled tapes, as your reference for inevitable research into how any given tape ended up the way it is. Your auditors may impose such requirements. Richard Sims, BU
Re: Actlog & the database
From: Douglas Currell [mailto:[EMAIL PROTECTED] > Is there a way to "archive" the activity log so that > it could be "imported" later? No. -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627
Actlog & the database
I have some ideas about the questions I'm about to ask but I need some other opinions. What is the relationship between the activity log retention period and the size of the TSM database. For example, the production database that I work with has a size of 52 GB and the actlog retention period is 90 days. Would the size of the database noticably decrease if the actlog retention was set to 7 days? (Extraneous info: I piped the output from "q actlog begindate=01/01/2003" to file and the file is about 500 MB.) What is therelationship of between the Activity Log Retention Period and Activity Summary Retention Period. Can I view the summary only? Is there a way to "archive" the activity log so that it could be "imported" later? Thank you... __ Post your free ad now! http://personals.yahoo.ca
Re: looking for a doc which tracks messages format changes for actlog
I don't believe there is any such document. In the case of ANS/ANE4987E, the change was made per APAR IC35141, which called our attention to the blank space. The blank space was not intentional, and thus was corrected; the object name is supposed to be shown as a single entity with no intervening blanks (except for any embedded blanks that are part of the object name itself). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. David Rigaudiere <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 06/24/2003 02:32 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:looking for a doc which tracks messages format changes for actlog Hi *SMers, anyone knows a documentation where we can find the changes about the messages in the actlog ? ie with 5.1.7.0 the ANE4987E message changed. The space between folder and file name has been removed. maybee a CHANGE file ? Best regards -- David Rigaudiere -+- Administration TSM -+- Paris -+- 40, rue de Courcelles -+- 4e étage -+- [EMAIL PROTECTED] -+- 01.5621.7802 --- This message (including any attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. ABN AMRO Bank N.V. (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. --- Le présent message (y compris tous les éléments attachés) est confidentiel et est destiné aux seules personnes qu'il vise. Si vous l'avez reçu par erreur, merci de l'indiquer à son expéditeur par retour et de procéder à sa destruction dans vos systèmes. Toute utilisation ou diffusion non autorisée de son contenu, dans sa totalité ou en partie, est strictement interdite. Merci de noter que les e-mails sont susceptibles d'être altérés. ABN AMRO Bank N.V. (et les entités membres du Groupe ABN AMRO) ne saurait être tenu pour responsable ni de la transmission erronée ou incomplète des informations contenues dans ce message, ni des délais de réception ou des dommages causés à votre système. ABN AMRO Bank N.V. (et les entités membres du Groupe ABN AMRO) ne garantit ni que l'intégrité de la communication ait été maintenue ni que cette transmission soit exempte de virus, d'interceptions ou d'interférences.
Re: looking for a doc which tracks messages format changes for actlog
Hello David, Formally, it seems there is no 'change' of messages between versions A message may be new or no more available (or not documented, explicitly in a chapter of M&Codes, or not explicity) but not modified. But yes, there are 'spaces-blanks variations' around variables (filenames, nodenames, adminnames, drivenames ...) inside messages : between versions, between languages, between operating systems ??? I don't know where or why, but I saw that several times. Maybe Andy will be more accurate about these "variations". But maybe there is no explanation-solution. If you read actlog by program, I think you have to deal with these variations in your code. That's we (try to) do. Best regards Christian Bagard email : [EMAIL PROTECTED] SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France - Original Message - From: "David Rigaudiere" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 11:32 AM Subject: looking for a doc which tracks messages format changes for actlog Hi *SMers, anyone knows a documentation where we can find the changes about the messages in the actlog ? ie with 5.1.7.0 the ANE4987E message changed. The space between folder and file name has been removed. maybee a CHANGE file ? Best regards -- David Rigaudiere -+- Administration TSM -+- Paris -+- 40, rue de Courcelles -+- 4e étage -+- [EMAIL PROTECTED] -+- 01.5621.7802
Re: looking for a doc which tracks messages format changes for actlog
>anyone knows a documentation where we can find the changes about the >messages in the actlog ? >ie with 5.1.7.0 the ANE4987E message changed. >The space between folder and file name has been removed. David - The front matter of the manuals carry a Summary Of Changes, and the Technical Guide redbook for the new version describes new features. And the README file in the download directory has the latest changes. But small tweaks in the product, such as message changes, rarely are announced: they would be reflected in APARs talking of doc changes, at best. We discover minor changes as we use the new software level. Richard Sims, BU
looking for a doc which tracks messages format changes for actlog
Hi *SMers, anyone knows a documentation where we can find the changes about the messages in the actlog ? ie with 5.1.7.0 the ANE4987E message changed. The space between folder and file name has been removed. maybee a CHANGE file ? Best regards -- David Rigaudiere -+- Administration TSM -+- Paris -+- 40, rue de Courcelles -+- 4e étage -+- [EMAIL PROTECTED] -+- 01.5621.7802 --- This message (including any attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. ABN AMRO Bank N.V. (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. --- Le présent message (y compris tous les éléments attachés) est confidentiel et est destiné aux seules personnes qu'il vise. Si vous l'avez reçu par erreur, merci de l'indiquer à son expéditeur par retour et de procéder à sa destruction dans vos systèmes. Toute utilisation ou diffusion non autorisée de son contenu, dans sa totalité ou en partie, est strictement interdite. Merci de noter que les e-mails sont susceptibles d'être altérés. ABN AMRO Bank N.V. (et les entités membres du Groupe ABN AMRO) ne saurait être tenu pour responsable ni de la transmission erronée ou incomplète des informations contenues dans ce message, ni des délais de réception ou des dommages causés à votre système. ABN AMRO Bank N.V. (et les entités membres du Groupe ABN AMRO) ne garantit ni que l'intégrité de la communication ait été maintenue ni que cette transmission soit exempte de virus, d'interceptions ou d'interférences.
Re: Missing Messages from ACTLOG for Drive Offlines
This may be library specific as well, I have never seen this happen on 3494/3590 drives. The ANRD message can come out because they have a message that has no text in dsmserv.cat to parse the message with. We have found this for some new messages. We will see. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 8:00 AM To: [EMAIL PROTECTED] Subject: Re: Missing Messages from ACTLOG for Drive Offlines I have seen this problem and have an apar open with Tivoli. We can't TEC alert, if there's no specific message that a drive went offline... other than perhaps a anrd (we're not going to rightly tec alert on THAT message): IC34067 Item IC34067 APAR Identifier .. IC34067 Last Changed..02/07/10 TSM SERVER TAKES TAPE DRIVE OFFLINE (MAKES IT UNAVAILABLE) BUT NO MESSAGE IS OUTPUT INDICATING THIS ACTION HAS OCCURED. Symptom .. IN INCORROUT Status ... CLOSED PER Severity ... 2 Date Closed . 02/07/10 Component .. 5698TSMAX Duplicate of Reported Release . 420 Fixed Release 999 Component Name TSM AIX SERVER Special Notice Current Target Date .. Flags SCP ... AIXRSC Platform AIX Status Detail: Not Available PE PTF List: PTF List: Release 420 : PTF not available yet Release 410 : No PTF planned Parent APAR: Child APAR list: IC34101 IC34102 IC34103 IC34107 ERROR DESCRIPTION: Customer is attempting to pass all critical messages to the TEC. One message of importance to them are those that indicate a tape drive had been taken offline (made unavailable). Customer has found certain circumstances under which no message appears to be issued when a drive is taken offline. For example the following shows activity log messages about a drive followed by query drive message that show it was taken offline during this time even though no message indicating this action was issue: TSM drive messages: 06/24/02 14:22:27 ANR8469E Dismount of LTO volume 100309 from drive EF2D1 (/dev/rmt18) in library LTOPLANO01 failed. 06/24/02 14:22:27 ANRD mmsscsi.c(1723): ThreadId<66> may still be in the drive EF2D1 (/dev/rmt18). Library Name: LTOPLANO01 Query Drive f=d output at 17:00:08: Drive Name: EF2D1 Device Type: LTO On-Line: Unavailable Since 06/24/02 14:22:27 Device: /dev/rmt18 Element: 269 Allocated to: Last Update (administrator): TWILL1 Last Update Date/Time: 06/18/02 12:55:56 The TSM server needs to issue an ANR message each time it takes a drive offline. LOCAL FIX: PROBLEM SUMMARY: * USERS AFFECTED: Anyone affected by inconsistent messaging* * when drives are taken offline. * * PROBLEM DESCRIPTION: Inconsistent messaging when a drive is * * taken offline. * * RECOMMENDATION: * We display a couple of different messages whenever a drive is taken offline. Moreover, there was a couple of situations when no message was displayed at all and the drive was taken offline. PROBLEM CONCLUSION: Therefore, we added a message anywhere that the drive was taken offline to prompt the user of such action. TEMPORARY FIX: COMMENTS: MODULES/MACROS: NONE SRLS: NONE RTN CODES: CIRCUMVENTION: MESSAGE TO SUBMITTER: -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:52 PM To: [EMAIL PROTECTED] Subject: Missing Messages from ACTLOG for Drive Offlines NO, you probably have your messages setup so these do not come out. Check your eventrules for ACTLOG Do the following command: Q EVENTRULES ACTLOG Ours always works. It even sends them to our TEC console because we have the TIVOLI stuff turned on. Works great. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Zbyszek Borgosz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 5:50 PM To: [EMAIL PROTECTED] Subject: Re: TSM 4.2, Private won't go into scratch Guess what folks! I've got 2 drives. One of them mysteriously went offline I haven't noticed it for a week :) q acctlog did not show it. TSM lacks of proper event logging. Thanks for your help! Best Regards! --- zee
Re: Missing Messages from ACTLOG for Drive Offlines
I have seen this problem and have an apar open with Tivoli. We can't TEC alert, if there's no specific message that a drive went offline... other than perhaps a anrd (we're not going to rightly tec alert on THAT message): IC34067 Item IC34067 APAR Identifier .. IC34067 Last Changed..02/07/10 TSM SERVER TAKES TAPE DRIVE OFFLINE (MAKES IT UNAVAILABLE) BUT NO MESSAGE IS OUTPUT INDICATING THIS ACTION HAS OCCURED. Symptom .. IN INCORROUT Status ... CLOSED PER Severity ... 2 Date Closed . 02/07/10 Component .. 5698TSMAX Duplicate of Reported Release . 420 Fixed Release 999 Component Name TSM AIX SERVER Special Notice Current Target Date .. Flags SCP ... AIXRSC Platform AIX Status Detail: Not Available PE PTF List: PTF List: Release 420 : PTF not available yet Release 410 : No PTF planned Parent APAR: Child APAR list: IC34101 IC34102 IC34103 IC34107 ERROR DESCRIPTION: Customer is attempting to pass all critical messages to the TEC. One message of importance to them are those that indicate a tape drive had been taken offline (made unavailable). Customer has found certain circumstances under which no message appears to be issued when a drive is taken offline. For example the following shows activity log messages about a drive followed by query drive message that show it was taken offline during this time even though no message indicating this action was issue: TSM drive messages: 06/24/02 14:22:27 ANR8469E Dismount of LTO volume 100309 from drive EF2D1 (/dev/rmt18) in library LTOPLANO01 failed. 06/24/02 14:22:27 ANRD mmsscsi.c(1723): ThreadId<66> may still be in the drive EF2D1 (/dev/rmt18). Library Name: LTOPLANO01 Query Drive f=d output at 17:00:08: Drive Name: EF2D1 Device Type: LTO On-Line: Unavailable Since 06/24/02 14:22:27 Device: /dev/rmt18 Element: 269 Allocated to: Last Update (administrator): TWILL1 Last Update Date/Time: 06/18/02 12:55:56 The TSM server needs to issue an ANR message each time it takes a drive offline. LOCAL FIX: PROBLEM SUMMARY: * USERS AFFECTED: Anyone affected by inconsistent messaging* * when drives are taken offline. * * PROBLEM DESCRIPTION: Inconsistent messaging when a drive is * * taken offline. * * RECOMMENDATION: * We display a couple of different messages whenever a drive is taken offline. Moreover, there was a couple of situations when no message was displayed at all and the drive was taken offline. PROBLEM CONCLUSION: Therefore, we added a message anywhere that the drive was taken offline to prompt the user of such action. TEMPORARY FIX: COMMENTS: MODULES/MACROS: NONE SRLS: NONE RTN CODES: CIRCUMVENTION: MESSAGE TO SUBMITTER: -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:52 PM To: [EMAIL PROTECTED] Subject: Missing Messages from ACTLOG for Drive Offlines NO, you probably have your messages setup so these do not come out. Check your eventrules for ACTLOG Do the following command: Q EVENTRULES ACTLOG Ours always works. It even sends them to our TEC console because we have the TIVOLI stuff turned on. Works great. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Zbyszek Borgosz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 5:50 PM To: [EMAIL PROTECTED] Subject: Re: TSM 4.2, Private won't go into scratch Guess what folks! I've got 2 drives. One of them mysteriously went offline I haven't noticed it for a week :) q acctlog did not show it. TSM lacks of proper event logging. Thanks for your help! Best Regards! --- zee
Missing Messages from ACTLOG for Drive Offlines
NO, you probably have your messages setup so these do not come out. Check your eventrules for ACTLOG Do the following command: Q EVENTRULES ACTLOG Ours always works. It even sends them to our TEC console because we have the TIVOLI stuff turned on. Works great. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Zbyszek Borgosz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 5:50 PM To: [EMAIL PROTECTED] Subject: Re: TSM 4.2, Private won't go into scratch Guess what folks! I've got 2 drives. One of them mysteriously went offline I haven't noticed it for a week :) q acctlog did not show it. TSM lacks of proper event logging. Thanks for your help! Best Regards! --- zee
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 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.