MACHINE

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(255)

Yes

DESCRIPTION

VARCHAR2(255)

No

DHCPENABLED

NUMBER(1)

Yes

DHCPNAME

VARCHAR2(255)

Yes

IPADDRESS

VARCHAR2(15)

Yes

AGENTPORT

NUMBER

Yes

SERVERPORT

NUMBER

No

OPERATINGSYSTEM

NUMBER

No

LOCKED

NUMBER(1)

No

JOBLIMIT

NUMBER

No

TRANSPORTERPROTOCOLOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: MACHINE_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the Machine.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(255)

DESCRIPTION

Description for the Machine.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

DHCPENABLED

Indication whether or not the Machine is DHCP-enabled.

Key NULL Column Type (Size)

No

DHCPENABLED

NUMBER(1)
Value List

0 = no

1 = yes

DHCPNAME

The Machine’s DHCP Name.

In case the DHCP Enabled option is selected, the IKAN ALM Server will try to set up a connection with this DHCP Name (using XML-RPC).

Key NULL Column Type (Size)

Yes

DHCPNAME

VARCHAR2(255)

IPADDRESS

The Machine’s IP Address.

In case the DHCP Enabled option is not selected, the IKAN ALM Server will try to set up a connection with this IP Address (using XML-RPC).

Key NULL Column Type (Size)

Yes

IPADDRESS

VARCHAR2(15)

AGENTPORT

The Port number (between 0 and 65536) on which the IKAN ALM Agent on this Machine will listen for communication with the IKAN ALM Server (using XML-RPC).

If you leave this field empty, the default value of 20020 will be used.

If you define a value different from the default value, be sure to define the same value when running the Agent install wizard on this Machine.

Key NULL Column Type (Size)

Yes

AGENTPORT

NUMBER

SERVERPORT

The Port number (between 0 and 65536) on which the IKAN ALM Server will listen for communication with the IKAN ALM Agents (using XML-RPC). This port number was defined during the initial installation of the IKAN ALM Server.

If the IKAN ALM Server uses the default value of 20021, you can also leave this field empty.

Key NULL Column Type (Size)

Yes

SERVERPORT

NUMBER

OPERATINGSYSTEM

The selected Operating System.

Key NULL Column Type (Size)

No

OPERATINGSYSTEM

NUMBER
Value List

0 = Windows

1 = Unix

2 = Linux

3 = OS/390 MVS

LOCKED

Indication whether or not the Machine is locked for future use.

Key NULL Column Type (Size)

No

LOCKED

NUMBER(1)
Value List

0 = no

1 = yes

JOBLIMIT

The number of maximum Deploys that may be run at the same time.

Key NULL Column Type (Size)

No

JOBLIMIT

NUMBER
Value List

ANY = Only this specified number of Deploys will run concurrently. Starting at number 2.

0 = All deploys will run concurrently

1 = All deploys will run sequentially

TRANSPORTERPROTOCOLOID

OID identifying the Transporter used by the Machine. Refers to the primary key of the appropriate Transporter table: FILECOPY, FTP or SECURESHELL.

Key NULL Column Type (Size)

No

TRANSPORTERPROTOCOLOID

NUMBER

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

MACHINE_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

BUILDENVIRONMENT

Refer to the chapter BUILDENVIRONMENT for a detailed description of the table.

Foreign Key Referencing Column

BUILDENVIRONMENT_FK_2

MACHINEOID
DEPLOYENVIRONMENT

Refer to the chapter DEPLOYENVIRONMENT for a detailed description of the table.

Foreign Key Referencing Column

DEPLOYENVIRONMENT_FK_2

MACHINEOID
MACHINEPARAMETER

Refer to the chapter MACHINEPARAMETER for a detailed description of the table.

Foreign Key Referencing Column

MACHINEPARAMETER_FK_1

MACHINEOID
SYSTEMSETTINGS

Refer to the chapter SYSTEMSETTINGS for a detailed description of the table.

Foreign Key Referencing Column

SYSTEMSETTINGS_FK_3

MACHINEOID

Report Labels

MACHINE_AGENTPORT_LABEL

English:

Agent Port

French:

Port de l’Agent

German:

Agent Port

MACHINE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

MACHINE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

MACHINE_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

MACHINE_DHCPENABLED_LABEL

English:

DHCP Enabled

French:

DHCP activé

German:

DHCP-aktiviert

MACHINE_DHCPNAME_LABEL

English:

DHCP Name

French:

Nom DHCP

German:

DHCP-Name

MACHINE_IPADDRESS_LABEL

English:

IP Address

French:

Adresse IP

German:

IP-Adresse

MACHINE_JOBLIMIT_LABEL

English:

Concurrent Deploy Limit

French:

Limite Déploiements concurrents

German:

Limit der parallelen Auslieferungen

MACHINE_LOCKED_LABEL

English:

Locked

French:

Verrouillée

German:

Gesperrt

MACHINE_NAME_LABEL

English:

Name

French:

Nom

German:

Name

MACHINE_OID_LABEL

English:

OID

French:

OID

German:

OID

MACHINE_OPERATINGSYSTEM_LABEL

English:

Operating System

French:

Système d’exploitation

German:

Betriebssystem

MACHINE_SERVERPORT_LABEL

English:

Server Port

French:

Port du Serveur

German:

Server Port

MACHINE_TRANSPORTERPROTOCOLOID_LABEL

English:

OID

French:

OID

German:

OID

MACHINE_VERSION_LABEL

English:

Version

French:

Version

German:

Version