How can I find job failures in LSF9?

Welcome to LawsonTalk. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it.

Join our community!

If you're already a member please log in to your account to access all of our features:

How can I find job failures in LSF9?; Looking for a way to find failed jobs.
Topic Started: Jun 18 2009, 11:57 AM (495 Views)
jecraton	Jun 18 2009, 11:57 AM Post #1
Member Posts: 13 Group: Members Member #14,788 Joined: April 27, 2009	I'd like to write an application that finds job failures under LSF9 and presents them in a web page. I can't seem to find a good place for locating job failures in this environment. My gut says to go through GEN or LOGAN and look for entries there. Has anyone else had any success with this issue? Disclosure: we are running on a Windows / Websphere / SQL2005 / AD/AM environment. Edited by jecraton, Jun 18 2009, 11:59 AM.



dczarny	Jun 18 2009, 12:16 PM Post #2
Member Posts: 19 Group: Members Member #14,855 Joined: June 8, 2009	This is a query that I use to monitor the Job queue. The QUEUEDJOB table is in the GEN Database. I also didn't want to be alerted of jobs that were in the waiting queue because of invalid parameters. IF EXISTS (SELECT * FROM QUEUEDJOB with(nolock) WHERE STATUS NOT IN (63,80) and ACTSTARTDATE = ?) BEGIN SELECT CONVERT(VARCHAR(2),STATUS) AS STATUS, JOBNAME,JOBQUEUE,ACTSTARTDATE,CONVERT(VARCHAR(6),ACTSTARTTIME) AS ACTSTARTTIME, PRODUCTLINE,TOKEN FROM QUEUEDJOB with(nolock) WHERE STATUS NOT IN (63,80) and ACTSTARTDATE = ? END ELSE BEGIN SELECT '' AS STATUS, '' AS JOBNAME, '' AS JOBQUEUE, GETDATE() AS ACTSTARTDATE,'' AS ACTSTARTTIME,'' AS PRODUCTLINE, 'SUCCESS' AS TOKEN END



jecraton	Jun 18 2009, 12:48 PM Post #3
Member Posts: 13 Group: Members Member #14,788 Joined: April 27, 2009	Works great, thanks!



schroncd	Jun 23 2009, 11:47 AM Post #4
Lawson Technorati Posts: 689 Group: Members Member #13 Joined: January 11, 2006	Download and install LEM, the Lawson Environment Monitor - Web based, email notifications, 3 levels of escalation, extendable with simple API, lots of goodies... FREE http://www.schronce.net/lawson



jecraton	Jun 23 2009, 04:34 PM Post #5
Member Posts: 13 Group: Members Member #14,788 Joined: April 27, 2009	Will LEM work against a Windows stack? The last time I looked it up, it was AIX/UNIX only.



schroncd	Jun 26 2009, 07:54 AM Post #6
Lawson Technorati Posts: 689 Group: Members Member #13 Joined: January 11, 2006	Some of you actually still run Windows?!? No.. LEM is Unix only, but it works on HP-UX, Solaris and AIX



Cindy	Jul 2 2009, 07:58 AM Post #7
Super Member Posts: 151 Group: Members Member #262 Joined: January 13, 2006	schroncd Jun 26 2009, 07:54 AM Some of you actually still run Windows?!? Funny. I can't even imagine using anything else. :-) Edited by Cindy, Jul 2 2009, 07:58 AM.



schroncd	Jul 8 2009, 05:22 AM Post #8
Lawson Technorati Posts: 689 Group: Members Member #13 Joined: January 11, 2006	Quote: Funny. I can't even imagine using anything else. :-) You see Virginia, there really ARE masochists in this world! :banghead: I tried to rewrite LEM for Windows, but the utilities that I use on Unix simply aren't available on the Windows platform - either from the Lawson or the Win/MKS side. Once again I'll offer to work with any savvy Windows Admin/developer to create a Windows version of LEM - so if you've got the chops let me know..



jecraton	Jul 29 2009, 10:24 AM Post #9
Member Posts: 13 Group: Members Member #14,788 Joined: April 27, 2009	Hi Schron: What utilities are missing? Is this basic stuff like GREP, LS, DIFF, sync, etc? Or is this more os-specific stuff like fstab or ifconfig?



schroncd	Jul 30 2009, 09:26 AM Post #10
Lawson Technorati Posts: 689 Group: Members Member #13 Joined: January 11, 2006	First off, understand that "I don't do Windows" - even on my personal computers I only access Windows when absolutely required - so there is a likelihood I'll make an idiot of myself in any Windows discussion.. MKS seems to handle most of the Unix utilities. The utilities I need most are the Lawson utilities.. Things like 'cv' don't exist, so I would have to create some way to load environment variables. LEM is designed to report on multiple environments on a single machine - is that even possible on a Windows setup? - as well as reporting across multiple machines. Also, many of the other Lawson utilities I know and love on Unix either don't exist, have another name or react differently on Windows. Essentially, it was enough for me to throw up my hands and say "It ain't worth it!" - but perhaps in collaboration with a Windows Lawson admin we could decipher the differences and work through them.



Milo	Sep 1 2009, 01:16 PM Post #11
Rebmem Member Posts: 361 Group: Members Member #424 Joined: February 9, 2006	Dave - sorry I can't help out now, but back a few years ago when I was working on a Windows-based Lawson system, there were all sorts of ways to get what we wanted via batch and script files. I remember that our scripts were batch files that called a standard batch file that loaded the environment - quite different from cv, but did essentially the same thing - and then moved on to call scripts that were executed via MKS. In Windows you have the potential to use Windows utilities as well. For instance, you can query the status of Windows 'environment variables'. Any good Windows-based Lawson admin 'worth their salt' should be able to help you out.



MichaelLandis	Sep 28 2009, 11:02 AM Post #12
Member Posts: 17 Group: Members Member #14,907 Joined: July 14, 2009	Dave, et al - Are there any tricks to wrapping up the LEM start/stop scripts in wrappers so that they can be invoked via a token/recdef? I'm having partial success. The stop works fine. The start appears to hang. If I run it from the F8 token execute it works fine, but if I start it from recdef, it stays in "active/batch" mode forever. If I kill it in the jobschd with F9, then it completes the start and shows up as running. It appears as though the nohup may be hanging things up. My wrapper start script simply does "nohup lem_start.sh &". I'd be grateful for any tips, as it will be troublesome for me to have this set up in cron (red-tape stuff).



schroncd	Sep 28 2009, 07:24 PM Post #13
Lawson Technorati Posts: 689 Group: Members Member #13 Joined: January 11, 2006	Hmmmm.. I've not tried running it from recdef. Have you tried it without the nohup or the "&" ? Since recdef already puts jobs in the background, it looks like you may be trying to do it twice.. Of course this is all speculation - give it a shot..



georgegraham	Oct 13 2009, 08:18 AM Post #14
Super Member Posts: 121 Group: Members Member #529 Joined: March 29, 2006	Dave - if I download the LEM does it have all of the source for me to look at helping with developing a Windows version of the product?



mivankovich	Oct 14 2009, 05:07 AM Post #15
Advanced Member Posts: 78 Group: Members Member #1,427 Joined: May 10, 2007	Hi George - I'd be happy to help you with this as a side project. We're a windows shop as well and would love to use the LEM. I can help you test stuff. We run a test environment on VMware. Seperate application, web and db servers. Two productlines 8.0.3 and 9.0.0.6. Virtual servers are slow, but it works. Our users are actively testing on it right now for the 9.0 apps upgrade, but i'm sure i can squeeze some time in at night. Let me know your thoughts... Thanks! Mark



MichaelLandis	Oct 14 2009, 07:48 AM Post #16
Member Posts: 17 Group: Members Member #14,907 Joined: July 14, 2009	Followup to my earlier post - I never could get the LEM to start successfully from recdef, so put in cron. Works great. George/Mark (hi Mark!) - the LEM is a suite of ksh scripts, and comes with all "source". I'm not familiar enough with the Windows platform to tell you what challenges you'll face trying to tweak it to run with MKS. Mark, feel free to drop me private notes if you need help interpreting what the ksh scripts are doing. Michael



mivankovich	Oct 15 2009, 08:57 AM Post #17
Advanced Member Posts: 78 Group: Members Member #1,427 Joined: May 10, 2007	Hi Michael! Thanks...I'll definitely send you questions...I've been able to create a couple simple ksh scripts (thanks to your mentoring in the past) to run great in MKS. I aslo installed a recent updated version which has a few more shell commands added, fixes, etc. I'll find some time and download LEM and get started.



schroncd	Oct 16 2009, 07:27 AM Post #18
Lawson Technorati Posts: 689 Group: Members Member #13 Joined: January 11, 2006	Your challenges will be these to start.. I make heavy use of 'cv' to change between environments. i have no idea how that's done on windows, but I know that 'cv' it's it. You could write a 'cv' to handle those env changes i use the unix 'mailx' commandline mail ystem to perform notifications. i THINK I've seen Windows commandline programs that have similar functionality - you'll need to find and incorporate them into the lem_email.sh script Source is all included - they are shell scripts - even the html output is generated from shell programs. Download is free but requires registration - just so I can keep you updated on bug fixes, new features - new releases, etc.. Mailing list is EXTREMELY low volume.. Email addresses are not shared.


« Previous Topic · System Admin · Next Topic »