RICS - Database health check, performance review and consultancy.

RICS (The Royal Institute of Chartered Surveyors) is the global body qualifying and setting standards for members working in construction, land, property and on related environmental issues.

RICS was implementing a new member portal to provide members with 24x7 online access to their information from anywhere in the world. With members in 146 countries supported by a network of regional offices around the world, RICS need a highly robust IT infrastructure.

The Challenge
RICS was implementing a new member portal to provide members with 24x7 online access to their information from anywhere in the world. The new system utilised an IBM tool, EDA, designed to convert their Unidata files to DB2. Significant DB2 expertise was required and so the initial brief was for Triton to perform a database health check.

The Solution
Triton worked closely with RICS on the database project providing consultancy, services and DB2 education. It was vital that Triton worked closely with the RICS IT team as DB2 was a new technology within the organisation.
After the initial database health check Triton conducted a performance review and follow-up consultancy including:
• Installation of DB2 v8.2 and the latest FixPaks
• Design and implementation of DB2 Backup strategy
• Design and implementation of DB2 logging strategy
• Review and maintenance of database and instance level configurations
• Design and implementation of Data Placement (Tablespace and Bufferpool) strategy
• Design and Implementation of Housekeeping strategy (Runstats, Reorgs)
• Implementation of Remote Administration Server and Test Server.

After the completion of the project, DB2 education was provided for the team of DBA's. The education program was designed to enable the RICS DBA team with the DB2 knowledge and skills they needed to continue with the day to day administration of the database.

Following on from this RICS then decided to take out both Remote DBA and Consultancy on Demand from Triton. Having a Remote DBA managed services contract means that RICS benefits from proactive, remote database support and database performance management from Triton's team of DB2 specialists. RICS also purchased 50 hours of Consultancy on Demand; these hours can be used as and when needed on anything from consultancy to DB2 education.
Back to Case Studies