Threads in BMC AR System

Today, we can see a brief info about threads

Threads:

1. Individual data channels between the AR Server and the database
2. Each designed for a specific function
3. Certain functions are more efficient with a properly structured thread.

At the server:

Depending on query type the server chooses which data channel; a backup of any due to channel limits can cause server lag.

Thread Types and usage:

• Fast –used for efficient queries
• List –Used for large data transfers
• Admin –used for Administrative functions
• Private –Individual dedicated threads

About AR System Forms in Database

How to go about a list of forms/fields in Database

In order to do this, you need direct SQL Access:

To get the schemaid for a particular form:

• Select schemaid from arschema where name=‘HPD:HelpDesk’

To get a list of forms and corresponding “T” tables:

• Select name,schemaid from arschema order by name

To get a list of all fields for a schema (e.g., schema 120):

• Select fieldname,fielded from field where schemaid=120

To get a list of all forms and fields:

• Select arschema.name,field.fieldname,field.fieldidfrom arschema,fieldwhere (arschema.schemaid=field.schemaid) order by arschema.name,field.fieldname

Please note that this is a brief note and you can go through the bmc docs for in-depth info about this topic.