WLCG Service Interventions Log - Weekly View

A web-based tool for logging the the service intervention details gleaned from announcements in a database and dynamically generating the  interactive weekly view of scheduled and unscheduled WLCG (T0/T1) Service Interventions from the database.

The primary source of information is EGEE Broadcast. Other sources include LCG3D (DB) Service Announcements,
CIC Operations Portal, CERN Daily/Weekly OPS Meetings, and IT Service Status Board.

Software Components

  1. Module for management of service interventions Database with web front-end

    It provides options to
    - Add service intervention records
    - Modify existing records
    - Delete unwanted records
    - View all service intervention records

    File(s):   DBFRONT.HTM

                   DBUPDATE.PHP => Performs back-end add, delete, or modify operations in the DB
                   DBDISPLAY.PHP => Fetches all records from DB for Display
     
  2. Module to dynamically extract and view the recorded service interventions on weekly basis

    It displays the current week's service interventions in tabular form with intervention types (Scheduled, Unscheduled &  Extended) indicated in different colors and grouped by site name. In addition it shows dynamic ScreenTips containing more specific details on intervention at the footer when the cursor is placed over the cell displaying affected service. Also week chain of service interventions can be viewed through previous and next links.

    File(s):   WEEKLY.HTM

                   HEADER.PHP => Displays table header for the current/selected week
                   WEEKLYST.PHP => Extracts and Displays the service interventions for specific week
     


 

Implementation Overview of WLCG Service Interventions Viewer Software

 

Service Intervention DB Structure

DataBase Name : servint     Table Name : bcm

Field
Type
Key
site
enum( 'CERN', 'ASGC', 'BNL', 'INFN/CNAF',
'FNAL', 'FZK/GRIDKA', 'IN2P3/CC', 'NDGF',
'PIC', 'RAL', 'SARA', 'TRIUMF', 'US-ALICE')
PRI
id
smallint(6)                                                  [Auto Increment]
PRI
service
char(12)
 
itype
enum('SCHEDULED','UNSCHEDULED','EXTENDED')
 
fromdt
datetime
 
todt
datetime
 
descr
varchar(255)
 


System/Software Requirements

Server:   Apache Webserver (ver. 2.2) or any webserver
                MySQL Database (ver. 5.0)
                PHP (ver. 5.2)

Client:     HTML Browser supporting DHTML and JavaScript
                (Compatible with IE, Mozilla, Opera Browsers)

Platforms:  Windows and Linux
 

R. Jehadeesan   jeha@igcar.gov.in
25-Jul-2007