Purpose
Returns the current system configuration.
Syntax
GET CONFIG
Usage Notes
The following table defines the system configuration.
| Component | Description |
|---|---|
| Vproc Number | Uniquely identifies the vproc across the entire system. |
| Rel. Vproc# | Represents the number of the vproc relative to the node upon which the vproc resides. |
| Node ID | Identifies the node upon which the vproc resides. Node ID is formatted as CCC-MM, where CCC denotes the cabinet number and MM denotes the module number. For example, the node ID 003-07 identifies the node in module number 7 of cabinet 3. |
| Movable | Indicates whether the vproc can be migrated to another node in its defined clique if its primary node fails. |
| Crash Count | Represents the number of times the vproc has crashed. The count increments with every attempted system restart. When the system restart succeeds, Crash Count is reset to 0 for all vprocs. |
| Vproc State | Represents the current PDE system state of a vproc.
|
| Config Status | Displays the Teradata Database Logical Configuration Map Status of a vproc.
|
| Config Type | Represents the Teradata Database Logical Configuration Map Type of a vproc. |
| Cluster/Host No. | Displays the Cluster Number if the Config Type is AMP or displays the Host No. if the Config Type is PE. Cluster is the cluster number for the AMP as defined during a system configuration or reconfiguration. The valid range of cluster numbers is 0 to 8099. Host No. is the host number that was assigned to the PE using during a system configuration or reconfiguration. The valid range of host numbers is 1 to 1023. |
| RcvJrnl/Host Type | Displays the RcvJrnl (that is, Recovery Journaling) flag if the Config Type is AMP or the Host Type if the Config Type is PE. The RcvJrnl flag is Off if an AMP is down and the other AMPs in its cluster are not to create a recovery journal for the down AMP. If you anticipate that an AMP will be down for a long period of time, Teradata recommends an offline rebuild of all tables on the AMP (after the RcvJrnl flag has been set to Off).
The Host Type is the host type for the PE as defined during a system configuration or reconfiguration and can be IBM, COP, ATT3B, BULLHN, or OS1100. |
| TVS Vproc | For AMP vprocs, displays the associated TVS vproc. |
The following table defines the node configuration.
| Component | Description |
|---|---|
| Node ID | Defined using PUT. For more information, see Parallel Upgrade Tool (PUT) Reference. The node ID is formatted as CCC-MM, where CCC denotes the cabinet number and MM denotes the module number. For example, the node ID 003-07 identifies the node in module number 7 of cabinet 3. |
| Node State | The current state of the node, which is either ONLINE, DOWN, or STANDBY. |
| Clique Number | The clique number for the node as defined using PUT. For more information, see Parallel Upgrade Tool (PUT) Reference. |
| CPUs | The number of CPUs on the node. |
| Memory (MB) | The total memory size in megabytes for the node (rounded up to the nearest integer). |
| CHANs | The number of channels attached to the node. |
| LANs | The number of LANs attached to the node. |
| AMPs | The number of AMPs running on the node. |
| Node Name | The network name for the node. |
When applicable, a footnote follows the PDE Status Table, indicating which node is defined as a Non-TPA Node (for nodes in STANDBY).
Example: Displaying the current system configuration
The following example shows the current system configuration.
SYSTEM NAME: qpdt23 11/06/12 17:09:05 DBS LOGICAL CONFIGURATION ------------------------- Rcv Jrnl/ Vproc Rel. Node Can Crash Vproc Config Config Cluster/ Host TVS Number Vproc# ID Move Count State Status Type Host No. Type Vproc ------ ------ ------ ----- ----- ------- -------- ------ -------- ----- ----- 0* 1 1-01 Yes 0 ONLINE Online AMP 0 On 10238 1 2 1-01 Yes 0 ONLINE Online AMP 0 On 10237 8192 5 1-01 No 0 ONLINE N/A GTW 1 COP N/A 10237 6 1-01 Yes 0 ONLINE N/A TVS 0 N/A N/A 10238 7 1-01 Yes 0 ONLINE N/A TVS 0 N/A N/A 16382 3 1-01 Yes 0 ONLINE Online PE 1 COP N/A 16383 4 1-01 Yes 0 ONLINE Online PE 1 COP N/A -------------------------------------------------------------------------------- * DBS Control AMP DBS State: Logons are enabled - The system is quiescent DBS RestartKind: COLD PDE PHYSICAL CONFIGURATION -------------------------- Node Node Clique Memory ID State Number CPUs (MB) CHANs LANs AMPs Node Name ------- ------- ------ ---- ------ ----- ---- ---- --------------------------- 1-01 ONLINE 0 1 1337 0 1 2 localhost ------------------------------------------------------------------------------ PDE State: RUN/STARTED