This documentation applies to the 8.0 version of Remedy Action Request System, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

Database column types used for AR System fields

In this topic:

The following sections list the column types used for AR System fields in each database type supported by BMC Remedy AR System.

Note

Control, display-only, page, page holder, table, table column, trim, and view fields do not require storage in database tables, so they are not listed in this section.

DB2 column types used for AR System fields

The following table shows the DB2 column types used for each AR System field type whose values are stored in database tables.


DB2 column types used for AR System fields

AR System field type

DB2 column type

Attachment

blob (up to 1 GB)

Character with a maximum length of 4000 or fewer bytes

varchar

Character with an unlimited length or a maximum length of more than 4000 bytes

clob (up to 1 MB)

Currency (a group of columns composed of a combination of the specified column types)

decimal, varchar, and integer

Date

integer

Date/Time (time stamp)

integer

Decimal

decimal

Diary

clob (up to 1 MB)

Integer

integer

Real

float

Selection

integer

Time

integer

Note

Previously created fields that use longvarchar types continue to use longvarchar.

Microsoft SQL Server column types used for AR System fields

The following table shows the Microsoft SQL Server column types used for each AR System field type whose values are stored in database tables.




Microsoft SQL Server column types used with AR System fields

AR System field type

SQL Server column type

Attachment up to 2 GB

image

Character with a maximum length of 8000 or fewer bytes

varchar

Character with an unlimited length or a maximum length of more than 8000 bytes

text

Currency (a group of columns composed of a combination of the specified column types)

decimal, varchar, and int

Date

int

Date/Time (time stamp)

int

Decimal

decimal

Diary

text

Integer

int

Real

float

Selection

int

Time

int

Oracle column types used for AR System fields

Configuring process administrator capabilities shows the Oracle column types used for each AR System field type whose values are stored in database tables.




Oracle column types used with AR System field types

AR System field type

Oracle column type

Attachment up to 4 GB

blob For the Oracle RDBMS, the default maximum attachment size is 2 GB. (This was increased from 1 MB to 2 GB.) To adjust the maximum attachment size, update the Db-Max-Attach-Size configuration parameter in the ar.conf (ar.cfg ) file. For more information about these files, see ar.conf (ar.cfg). The maximum value is limited by your server operating system and configuration.

Note

Attachment fields created by a pre-7.0 BMC Remedy AR System server remain a long raw data type. New attachment fields use the Oracle blob type.

Character with a maximum of 4000 or fewer bytes

varchar

Character with an unlimited length or a maximum length of more than 4000 bytes

clob The AR_SERVER_INFO_ORACLE_CLOB_STORE_INROW server information setting controls Oracle CLOB storage. It takes these values:

  • TRUE --- CLOBs are created "in row."

Large in-row CLOBs can degrade CPU performance, but small CLOBs can improve performance because the CLOB data can be fetched with the row from the database. AR System in-house application developers convert any character field designed to contain more than 255 bytes into a CLOB (database input length = 0). Typically, such fields are not expected to hold large amounts of data. Therefore, unless you expect to store unusually large amounts of data in CLOBs, set this option to TRUE before installing AR System applications so that all database tables for applications are created in-row.

  • FALSE (default) --- CLOBs are created "out row."

Out-row CLOBs can cause the database to grow rapidly. Use out-row CLOBs only when your database storage is not limited and your CLOBs are expected to hold large amounts of data.

Note

If a field contains more than 4000 characters, the CLOB is stored out row no matter which value is specified for this server setting.

For more information about the storage and performance effects of using in-row versus out-row CLOBs, see Using Oracle CLOBs with BMC Remedy AR System. The corresponding setting in the AR System server configuration file is Oracle-Clob-Storage-In-Row. |

Currency (a group of columns composed of a combination of the specified column types)

decimal, varchar, and number (15, 0 )

Date

number (15, 0 )

Date/Time (time stamp)

number (15, 0 )

Decimal

decimal

Diary

clob For more information, see the preceding Oracle data type description for character fields with unlimited length.

Integer

number (15, 0 )

Real

float

Selection

number (15, 0 )

Time

number (15, 0 )

Sybase column types used for AR System fields

The following table shows the Sybase column types used for each AR System field type whose values are stored in database tables.




Sybase column types used with AR System fields

AR System field type

Sybase column type

Attachment up to 2 GB

image

Character with a maximum length of 255 or fewer bytes

varchar

Character with an unlimited length or a maximum length of more than 255 bytes

text

Currency (a group of columns composed of a combination of the specified column types)

decimal, varchar, and int

Date

int

Date/Time (time stamp)

int

Decimal

decimal

Diary

text

Integer

int

Real

float

Selection

int

Time

int

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments