Check Teradata database (AMP,GTW,Node,PE,RSG,TVS) Status using Vprocmanager
The Vproc Manager utility, vprocmanager, allows you to manage the virtual processors (vprocs) in a Teradata Database system. Vprocs are a set of software processes that run under Teradata Parallel Database Extensions (PDE) within the multitasking environment of the operating system. Vprocs are the heart of Teradata Database, managing the basic functions of the system.
Example:
# vprocmanager
_______
| | |
| ___ __ ____ | ____ __|__ ____
| / |/ \ ____| ____| ____| | ____|
| --- | / | / | / | | / |
| \___ | \____| \____| \____| |__ \____|
Release 15.10.07.11 Version 15.10.07.11
VprocManager Utility (Sep 98)
Enter a command, HELP or QUIT:
status
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:19:40
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 No 0 ONLINE Online AMP 0 On 28671
1 2 1-01 No 0 ONLINE Online AMP 0 On 28671
2 3 1-01 No 0 ONLINE Online AMP 1 On 28671
3 4 1-01 No 0 ONLINE Online AMP 1 On 28671
4 5 1-01 No 0 ONLINE Online AMP 2 On 28671
5 6 1-01 No 0 ONLINE Online AMP 2 On 28670
6 7 1-01 No 0 ONLINE Online AMP 3 On 28670
7 8 1-01 No 0 ONLINE Online AMP 3 On 28670
8 9 1-01 No 0 ONLINE Online AMP 4 On 28670
9 10 1-01 No 0 ONLINE Online AMP 4 On 28670
10 11 1-01 No 0 ONLINE Online AMP 5 On 28669
11 12 1-01 No 0 ONLINE Online AMP 5 On 28669
12 13 1-01 No 0 ONLINE Online AMP 6 On 28669
13 14 1-01 No 0 ONLINE Online AMP 6 On 28669
14 15 1-01 No 0 ONLINE Online AMP 7 On 28669
15 16 1-01 No 0 ONLINE Online AMP 7 On 28668
16 17 1-01 No 0 ONLINE Online AMP 8 On 28668
17 18 1-01 No 0 ONLINE Online AMP 8 On 28668
18 19 1-01 No 0 ONLINE Online AMP 9 On 28668
19 20 1-01 No 0 ONLINE Online AMP 9 On 28668
26623 24 1-01 No 0 ONLINE N/A RSG 0 N/A N/A
22528 23 1-01 No 0 ONLINE N/A GTW 1 COP N/A
28668 25 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
28669 26 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
28670 27 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
28671 28 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
30718 21 1-01 No 0 ONLINE Online PE 1 COP N/A
30719 22 1-01 No 0 ONLINE Online PE 1 COP N/A
--------------------------------------------------------------------------------
* DBS Control AMP
DBS State: Logons are enabled - Users are logged on
DBS RestartKind: COLD
PDE PHYSICAL CONFIGURATION
--------------------------
Node Node Clique Memory
ID State Number CPUs (MB) CHANs LANs AMPs Node Name
------- ------- ------ ---- ------ ----- ---- ---- ---------------------------
1-01 ONLINE 0 64 257818 0 1 20 localhost
------------------------------------------------------------------------------
PDE State: RUN/STARTED
Enter a command, HELP or QUIT:
STATUS DBS
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:21:42
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 No 0 ONLINE Online AMP 0 On 28671
1 2 1-01 No 0 ONLINE Online AMP 0 On 28671
2 3 1-01 No 0 ONLINE Online AMP 1 On 28671
3 4 1-01 No 0 ONLINE Online AMP 1 On 28671
4 5 1-01 No 0 ONLINE Online AMP 2 On 28671
5 6 1-01 No 0 ONLINE Online AMP 2 On 28670
6 7 1-01 No 0 ONLINE Online AMP 3 On 28670
7 8 1-01 No 0 ONLINE Online AMP 3 On 28670
8 9 1-01 No 0 ONLINE Online AMP 4 On 28670
9 10 1-01 No 0 ONLINE Online AMP 4 On 28670
10 11 1-01 No 0 ONLINE Online AMP 5 On 28669
11 12 1-01 No 0 ONLINE Online AMP 5 On 28669
12 13 1-01 No 0 ONLINE Online AMP 6 On 28669
13 14 1-01 No 0 ONLINE Online AMP 6 On 28669
14 15 1-01 No 0 ONLINE Online AMP 7 On 28669
15 16 1-01 No 0 ONLINE Online AMP 7 On 28668
16 17 1-01 No 0 ONLINE Online AMP 8 On 28668
17 18 1-01 No 0 ONLINE Online AMP 8 On 28668
18 19 1-01 No 0 ONLINE Online AMP 9 On 28668
19 20 1-01 No 0 ONLINE Online AMP 9 On 28668
26623 24 1-01 No 0 ONLINE N/A RSG 0 N/A N/A
22528 23 1-01 No 0 ONLINE N/A GTW 1 COP N/A
28668 25 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
28669 26 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
28670 27 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
28671 28 1-01 No 0 ONLINE N/A TVS 0 N/A N/A
30718 21 1-01 No 0 ONLINE Online PE 1 COP N/A
30719 22 1-01 No 0 ONLINE Online PE 1 COP N/A
--------------------------------------------------------------------------------
* DBS Control AMP
DBS State: Logons are enabled - Users are logged on
DBS RestartKind: COLD
Enter a command, HELP or QUIT:
STATUS DBS ORDERBY CN
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:22:57
DBS LOGICAL CONFIGURATION
-------------------------
ONLINE AMP Vprocs ordered by Cluster No. -
Vproc-Ids Crash CN Vproc-Ids Crash CN
Range Cnt NO Range Cnt NO
-------------------------- --- ---- -------------------------- --- ----
0*-1 0 0 2-3 0 1
4-5 0 2 6-7 0 3
8-9 0 4 10-11 0 5
12-13 0 6 14-15 0 7
16-17 0 8 18-19 0 9
--------------------------------------------------------------------------------
* DBS Control AMP
DBS State: Logons are enabled - Users are logged on
DBS RestartKind: COLD
Enter a command, HELP or QUIT:
STATUS DBS ORDERBY HN
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:25:12
DBS LOGICAL CONFIGURATION
-------------------------
ONLINE PE Vprocs ordered by Host No. -
Vproc-Ids Crash Host Host
Range Cnt Movable Number Type
-------------------------- --- ------- ------ ------
30718-30719 0 No 1 COP
--------------------------------------------------------------------------------
DBS State: Logons are enabled - Users are logged on
DBS RestartKind: COLD
Enter a command, HELP or QUIT:
STATUS DBS ORDERBY NODEID
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:27:56
DBS LOGICAL CONFIGURATION
-------------------------
ONLINE AMP and PE Vprocs ordered by Node ID -
Vproc-Ids Crash Node Vproc-Ids Crash Node
Range Cnt IDs Range Cnt IDs
-------------------------- --- ------ -------------------------- --- ------
0*-19, 30718-30719 0 1-01
--------------------------------------------------------------------------------
ONLINE TVS Vprocs ordered by Node ID -
Vproc-Ids Crash Node Vproc-Ids Crash Node
Range Cnt IDs Range Cnt IDs
-------------------------- --- ------ -------------------------- --- ------
28668-28671 0 1-01
--------------------------------------------------------------------------------
* DBS Control AMP
DBS State: Logons are enabled - Users are logged on
DBS RestartKind: COLD
Enter a command, HELP or QUIT:
STATUS NOTONLINE
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:34:13
All DBS vprocs are fully online.
All PDE nodes are fully online.
Enter a command, HELP or QUIT:
STATUS ONLINE;
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:34:50
All DBS vprocs are fully online.
All PDE nodes are fully online.
Enter a command, HELP or QUIT:
STATUS PDE
SYSTEM NAME: DWTSAWSDBS03 18/07/09 10:35:40
PDE PHYSICAL CONFIGURATION
--------------------------
Node Node Clique Memory
ID State Number CPUs (MB) CHANs LANs AMPs Node Name
------- ------- ------ ---- ------ ----- ---- ---- ---------------------------
1-01 ONLINE 0 64 257818 0 1 20 localhost
------------------------------------------------------------------------------
PDE State: RUN/STARTED
Enter a command, HELP or QUIT:
STATUS RESTART
DBS RestartKind: COLD
Enter a command, HELP or QUIT:
STATUS SYSSTATE
DBS State: Logons are enabled - Users are logged on
PDE State: RUN/STARTED
Enter a command, HELP or QUIT:
Status 0-20
SYSTEM NAME: DWTSAWSDBS03 18/07/09 11:00:22
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 No 0 ONLINE Online AMP 0 On 28671
1 2 1-01 No 0 ONLINE Online AMP 0 On 28671
2 3 1-01 No 0 ONLINE Online AMP 1 On 28671
3 4 1-01 No 0 ONLINE Online AMP 1 On 28671
4 5 1-01 No 0 ONLINE Online AMP 2 On 28671
5 6 1-01 No 0 ONLINE Online AMP 2 On 28670
6 7 1-01 No 0 ONLINE Online AMP 3 On 28670
7 8 1-01 No 0 ONLINE Online AMP 3 On 28670
8 9 1-01 No 0 ONLINE Online AMP 4 On 28670
9 10 1-01 No 0 ONLINE Online AMP 4 On 28670
10 11 1-01 No 0 ONLINE Online AMP 5 On 28669
11 12 1-01 No 0 ONLINE Online AMP 5 On 28669
12 13 1-01 No 0 ONLINE Online AMP 6 On 28669
13 14 1-01 No 0 ONLINE Online AMP 6 On 28669
14 15 1-01 No 0 ONLINE Online AMP 7 On 28669
15 16 1-01 No 0 ONLINE Online AMP 7 On 28668
16 17 1-01 No 0 ONLINE Online AMP 8 On 28668
17 18 1-01 No 0 ONLINE Online AMP 8 On 28668
18 19 1-01 No 0 ONLINE Online AMP 9 On 28668
19 20 1-01 No 0 ONLINE Online AMP 9 On 28668
--------------------------------------------------------------------------------
* DBS Control AMP
Enter a command, HELP or QUIT:
status 19
SYSTEM NAME: DWTSAWSDBS03 18/07/09 12:02:27
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
------ ------ ------ ----- ----- ------- -------- ------ -------- ----- -----
19 20 1-01 No 0 ONLINE Online AMP 9 On 28668
--------------------------------------------------------------------------------