Using relational databases with BMC Remedy AR System
BMC Remedy AR System can use any of the following database platforms :
- IBM DB2
- Microsoft SQL Server
- Sybase ASE
For the most accurate information about supported platforms and software, Checking system requirements and supported configurations.
Each type of relational database behaves differently with regard to search qualifications, wildcards, and so forth. The following topics describe these differences.
- Using IBM DB2 Universal Database with BMC Remedy AR System
- Using Microsoft SQL Server with BMC Remedy AR System
- Using Oracle with BMC Remedy AR System
- Using Sybase with BMC Remedy AR System
In general, BMC Remedy AR System hides the underlying database from the user. The AR System server interacts with the database and provides information to the user independent of the underlying database. All access through the API supplied with the product goes through this server and is independent of the database.
If you upgrade from a previous version of BMC Remedy AR System, the data dictionary is restructured. This chapter describes changes that occur during installation and changes that occur as new data is stored in the database.
BMC Remedy AR System supports read access directly from the tables but does not support update access to any of the AR System tables directly through SQL. You must go through the AR System API for update access.
BMC Remedy reserves the right to change the structure of the AR System database in any release. If the structure is changed, the database version number is updated to indicate a change.
Other than AR System data, BMC Remedy AR System and its installation do not interact with or affect other data in the database. The only exception is data referenced by using the Direct SQL capability within workflow or by using a view form. For more information about this function, see the Developing section.
Because BMC Remedy AR System passes SQL commands to the database without checking the syntax, all commands are submitted to the database. Make sure all submitted commands achieve the desired result. Your SQL commands should comply with ANSI SQL standards so that single quotation marks are reserved for strings and double quotation marks are reserved for use with database object names only.
When you install BMC Remedy AR System over a relational database, an AR System database is created. By default, this database is named ARSystem, and the user ARAdmin is defined. You can choose other values during installation. This document refers to the default values, so if you changed them during installation, substitute your database and user names for ARSystem and ARAdmin. The characteristics of the AR System database vary depending on the type of underlying relational database.
You can perform any system administrator activity on the database or on any of the tables it contains. This includes performing regular backups, creating more tablespaces to be added to the AR System database, and adding more containers to tablespaces. With a Sybase or Microsoft SQL Server database, flush the transaction log (or configure it to autoflush) as part of your regular backup strategy.
After the AR System database is created, BMC Remedy AR System creates a series of tables that form its data dictionary. See The AR System data dictionary.
For information about different behaviors and requirements for installing BMC Remedy AR System with specific databases, see Preparing your database.
For information about configuration options and parameters associated with specific databases, see ar.cfg or ar.conf.