Posts Tagged ‘database’

BMC Remedy Architecture in 5 min

June 14th, 2010

This is continuation to the previous post http://remediesforremedy.com/2009/08/remedy-101-bmc-ar-system-remedy-architecture/

 Remedy Architecture:

 1.Presentation Layer-

 As I said we have Remedy Administrator Tool/Developer Studio(Remedy IDE), we handle all the Form/Workflow creations in this-(Admin/Development activities),

 Form creation would be a kind of drag and drop as you do it in VB, wherein we have Form Object listed aside like Character/Text Field,Drop Down,Integer Fields,Borders,Labels……

 Once you design our Form Structure through drag and drop, the same structure would be saved/represented in the DEF File format in the Remedy Server.We don have to code as you do in Java for creating Forms here.(using Admin Tool/Developer Studio Remedy IDE’s-connecting to Remedy Server, through simple click and drag method to create Forms).

 

2.Business Layer-

 To define Business Layer, in Remedy IDE itself we have seperate Windows to create ARSystem Objects(Active Links,Filters and Escalations) through which again a simple drag and drop with your logical operators to build the Remedy Workflows.

 Again this will be represented in the DEF File, which Remedy Server can interpret and execute it.

 

3.Database Layer-

 The data which is being shown in the Presentation Layer and the operations which are being performed in the Business Layer will ultimately goes to the Relational Database(like Oracle,DB2,My SQL).

 The End user will be interacting with the Remedy User(thick client)-exe, or through Browser(thin client), the Remedy Forms and Workflows which you designed in the Remedy IDE will be viewed in these two client tools,

 On performing actions in the User Tools by the End User, there will be an API communication from these Client to the Remedy Server and through which the Forms will be loaded and the Workflows will be executed in the Client and Server Environment.

 There is no coding of any programming languages required to create Standalone Applications(Set of Forms and Workflows) on Remedy Platform-All you need to know is to understand the Remedy Workflows and Tools.

 With this platform, BMC has powered ITSM applications to automate the Service Management(you can go through ITIL to understand what is being done in the Incident and Problem framework, but through this platform you can build any kind of ticketing/enterprise applications(as mentioned earlier) which you may want to represent in the Web with out core programming.

 Thanks to Ashwanth for this detailed explanation on BMCDN.

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