Posts Tagged ‘Tool’

Usage of DBA Extensions with BMC Remedy

May 4th, 2010

Note: Usage of DBA Extensions is an advanced tuning technique which may cause more harm than good if used without proper care. Knowledge RDBMS is required to take advantage with this feature. Contact your DBA for more help!!!

Database (DBA) Extensions –

In general DBA Extensions are used to take advantage of RDBMS and SQL statements to create Forms, indexes and allocate space to them. Creating DBA extensions is a advance performance tuning mechanism very few of Remedy Admins does, when they run out of all other possible ways to fine tune the system.

DBA extensions are mainly used to manage database space and improve overall system performance.

DBA extensions provide:

> Vast control over location and size allocation for tables and indexes

> Automatically referenced by the AR System during initial table and index creation

> Automatically referenced by the AR System during table rebuild operations

> Allows for Vendor specific customization.

DBA Extensions are implemented using a database configuration file (ardb)

This file is normally located in the following directory:

  • Unix – /etc/ardb.conf
  • Windows – AR_System_Install\Conf\ardb.cfg

Source: BMC Remedy AR System 7.x: Performance Tuning & Troubleshooting course material

AR System Remedy Change Tracking Tool

April 9th, 2010

Thanks to PVB for this wonderful tool

What is AR System Change Tracking Tool?

AR System Change Tracking Tool will record all changes that are done to the Remedy applications.For ex, whenever a user creates a form/modifies a filter etc., the change information will be recorded in this tool.

This tool have been developed to address the following problems,

  • Currently we do not have a perfect mechanism to record all the changes.
  • Whenever multiple users are working on same application, it is very hard to find out who made the changes to the application objects.
  • No proper version tracking information in Remedy applications.
  • At the deployment time there is a possiblity that we might miss out some required workflows.

How to view the recorded information?

ARS Change Tracking tool comes with powerful reporting feature through which you can either execute the change details or download the details for version tracking purpose.

Please go through the user manual attached for the complete details about this tool.

Installation Steps:-

  1. Import the ARS-CTT-Def.def using AR Import feature in the admin tool.
  2. Import all the entries defined in ARS-Pilot-Entries.arx file using Remedy Tool.
  3. You need to enable the server events in the server in order to view the change logs. You can do this by navigating through, File->Server Information->Server Events Tab. Enable, Active Link, Field, Filter, Form, Escalation, View.
  4. Then the tool will start recording events starting from the time you have enabled the server events.
  5. Launch the ARS:CTT-Master form through the Remedy User tool for viewing the server events.

Mail author Vijay Bhaskar, at bhaskarvrips@gmail.com if you face any problems in installing this application.

Download it here!!