(12) Umted States Patent (10) Patent No.: US 8,140,565 B2 D’Angelo et al. (45) Date of Patent: Mar. 20, 2012 (54) AUTONOMIC INFORMATION 7,305,427 B2 12/2007 Kaye MANAGEMENT SYSTEM (IMS) 7,328,251 B2 2/2008 Ahmed et al. MAINFRAME DATABASE POINTER ERROR E; IIiji1;’é‘2t1fl‘°;VS(fItl 31' DIAGNOSTIC DATA EXTRACTION 7,805,675 B2 9/2010 Cradick oi al. 2002/0023024 A1 2/2002 Kaimowitz (75) Inventors: Dario D’Angelo, Los Gatos, CA (US); 2005/0114365 Al 5/2005 Tucker Charles E_ Jones Antioch CA (US) 2005/0180038 A1 8/2005 Chikashige et al. - ’- - ’ . ’ 2005/0223283 A1 10/2005 Frey oi al. Km Lau’ M_°uma1.nV1eW’ CA IUS)’ 2005/0240638 A1 * 10/2005 Fisher ......................... .. 707/205 Alan R- smlths GIIFOY’ CA (US) 2006/0026244 A1 2/2006 Watson 2006/0026641 A1 2/2006 Jule et al. (73) Assignee: International Business Machines (Continued) Corporation, Armonk, NY (US) ( * ) Notice: Subject to any disclaimer, the term of this OTHER PUBLICATIONS patent is extended or adjusted under 35 IBM Software Group, IMS problem Investigator, Verson 1.2, AnaU.S.C. l54(b) by 549 days. lyzing the IMS, CQS, and Connect logs to investigate problems, Jul. 2005, IBM Corporation and Fundi Software.* (21) Appl. No.: 12/356,394 (C t_ d) on 1nue 22 F1 d: J . 20 2009 ( ) 1 e an , Primary Examiner * Apu Mofiz (65) Prior Publication Data Assistant Examiner * Mohammad Rahman Us 2010/0185590 A1 Jul‘ 22’ 2010 (74) Attorney, Agent, or Firm * Kunzler Needham Massey & Thorpe (51) 1‘7/00 (2006.01) (57) ABSTRACT G06F 17/30 (200601) A method and system for autonomic Information Manage(52) U.S. Cl. ...................................... .. 707/769; 714/799 mem System (IMS) mainframe database Pointer error diag(58) Field of Classification Search ................. .. 707/769 1105110 data extraction- A receiving module may recei“? a See application file for Complete Search history database name and an error detection time. An error detection module may locate database pointer errors on the failed IMS (56) References Cited database. A list module may generate an Image Copy (IC) list
5,995,980 A 11/1999 Olson et al.
6,092,085 A 7/2000 Keene
6,154,753 A 11/2000 McFarland
6,574,671 B1 6/2003 Haynes
6,816,863 B2 11/2004 Bates et al.
6,934,949 B2 * 8/2005 Srnit11 et al. ................. .. 718/101 6,952,805 B1 10/2005 Tafoya et al.
6,961,925 B2 11/2005 Callahan, II et al.
corresponding to the failed database. A code generation module may generate Job Control Language (JCL) code for the selected entries in the IC list. An execution module executes the JCL code Which operates a pointer checker utility on each clean IC. A log list module locates log data sets recorded in the time betWeen the error and When the error Was detected and an extraction module extracts an evaluation log list Which comprises evaluation log data sets.
6 Claims, 3 Drawing Sheets
2006/0031267 A1 2/2006 Lim et al. 2006/0036691 A1 2/2006 Schultz 2006/0080270 A1 4/2006 Mori 2006/0150163 A1 7/2006 Chandane 2006/0156210 A1 7/2006 Ranson et al. 2006/0235820 A1 10/2006 Hoth et al. 2006/0277162 A1 12/2006 Srr1it11 2007/0005598 A1 1/2007 Okamoto et al. 2007/0043775 A1 2/2007 Moriet al. 2007/0055687 A1 3/2007 Josten et al. 2007/0078865 A1 4/2007 Srr1it11 2007/0136082 A1 6/2007 Jackson et al. 2007/0250576 A1 10/2007 Kumar et al. 2007/0282878 A1 12/2007 Marshall 2008/0040435 A1 2/2008 Buschiet al. 2008/0109736 A1 5/2008 Itoh 2008/0147816 A1 6/2008 Dammetal. 2008/0168352 A1 7/2008 Mehrotra et al. 2008/0313283 A1 12/2008 Cohen et al. 2009/0100347 A1 4/2009 Schemers et al. 2009/0125596 A1 5/2009 Naick et al. 2010/0003948 A1 1/2010 Ray
IMS Version 9, Knowledge Based Log Analysis KBLA, IBM Corp, 2005*
Harper, John, “IMS Full Function Database Log Record Analysis”, IBM Information on Demand 2006, Anaheim Convention Center, Oct. 15-20, 2006. 42 Pages.
Nystrom, Dag, et al., “Snapshots in Real-Time Databases using Database Pointer Transactions”, Proceedings of the 11t11 IEEE International Conference on Embedded and Real-Time Computer Systems and Applications, 2005. 7 Pages.
“IBM IMS Database Analysis Tools”, IBM, Apr. 2003.
“Pointer Checker Plus”, BMC Software, Release Notes, Version 4.4. 01, Jul. 30, 2004.
Jones et al., “Management of Data Needed to Resolve Pointer Errors in Hierarchical Database Management System”, Aug. 27, 2007. Underhill, Rachel, Effective Emails, Web and Information Manager, Mar. 19, 2008.
Oluwa, Lola, Dynamic Determination of e-mail recipient, Apr. 24, 201 1.
IBM Software Group-IMS: IMS Problem Investigator, Version 1.2. Analyzing the IMS, CQS, and Connect logs to investigate problems, Juy 2005.
Wikipedia, IBM Information Management System, Retrieved Sep. 22, 2009.
Jantti, Jouko et al., IBM, IMS Version 9 Implementation Guide: A Technical Overview, Redbooks, Dec. 2004.
IBM Corporation, Knowledge Based Log Analysis, KBLA, IMS Version 9, Jan. 2005.
Office Action received from USPTO, U.S. Appl. No. 12/201,393, Notification Date Sep. 2, 2010.
Office Action received from USPTO, U.S. Appl. No. 12/201,393, Notification Date Feb. 22, 2011.
Office Action received from USPTO, U.S. Appl. No. 11/845,710, Notification Date Oct. 1, 2009.
Information Disclosure Statement, U.S. Appl. No. 12/645,403, Filed Oct. 13,2011.
100 JCL M 104 \ V Terminals ‘ m IMS MPP BMP Control Region Region Region M m @ Databases ‘ m I Z Online Log Data DBRC Sets (OLDS) M m it v . . System Log Data > DFSUARCO Utlt Recon Data Sets 124 I I y > Sets (SLDS) Q < — E Operating System E
U.S. Patent Mar. 20,2012 Sheet 2 013 US 8,140,565 B2 200 IMS E Network M 208 Diagnostic Server \ E Receiving Error Detection List M E M IC Extraction Code Generation Execution E M 22_0 Log Llst Log Extraction Output 2 A E
|
