PDEツール

#目的
各種PDEツールの内容を確認

>並列データベース拡張機能(PDE)は、オペレーティング システムとTeradata Databaseの間にあるソフトウェア インターフェース層です。PDEでは、Teradata Databaseの速度および線形スケーラビリティと関係しているシステム ノード間の並列処理がサポートされます。多くの診断およびトラブルシューティング ユーティリティは、PDEレベルで動作します。

#コマンド

manコマンドやpdehelpで確認可能

| 内容 | コマンド | 実行例・補足 |
|:-:|:-:|:-:|
| amp  | ampload  | Teradata DatabaseでのAMPワーカー タスク(AWT)のAMP vproc使用を表示(各AMP vproc上のロードを示す)  |
| awt  | awtmon  | ローカル ノードまたはすべてのノードに対して、AMPワーカー タスク(AWT)の使用中カウント スナップショットのわかりやすいサマリーを収集して表示  |
| PDEコンソール  | cnscim -s | PDEコンソールの一覧を表示  |
| SuperVisorコマンド実行  | cnsterm 6 | SuperVisorコマンド実行するターミナルに接続  |
| Control GDO  | controlgdo | Control GDOの内容を表示（GDO=グローバル分散オブジェクト）  |
| [Control GDOエディタ](https://docs.teradata.com/r/gjXRKe910A9hOE8O2C3Ufw/M5diOabhtRbYgka~DkUNjQ)  | ctl | PDE Controlプログラム。PDE構成設定値を表示・変更 |
| ログを確認  |  logview | システム ログとダンプ ユーティリティ |
| ノードの状態を分析  | nodecheck  | ローカル ノードからのPDE vital情報を収集して分析  |
| PDE構成情報  | pdeconf  | PDE構成情報  |
| PDEツールヘルプ  | pdehelp | Teradataツールのオンライン ヘルプを表示  |

#実行例
###ampload：AMPワーカー タスク(AWT)のAMP vproc使用を表示
```
TDExpress1620_Sles11:~ # ampload
Vproc    Rel.       Node         Msg     AWT Availability   AWT Inuse
 No.     Vproc#     ID          Count         Count           Count  
-----    ------     ------     -------   ----------------   ---------
    0         1     001-01        0             55              1
    1         2     001-01        0             56              0

```

###awtmon：AMPワーカー タスク(AWT)の使用中カウント スナップショットのサマリー
```
TDExpress1620_Sles11:~ # awtmon
====> Sat Dec 26 09:26:43 2020 <====
Amp 0   : Inuse:  1:  FOUR:  1
```

###controlgdo：Control GDOの内容を表示
```
TDExpress1620_Sles11:~ # controlgdo
restartkind:                     0
onenodeaction:                   0
cliquedown:                      0
minnodesperclique:               1
enablelogons:                    2
cyclecount:                      14
dontstartappl:                   0
startdebug:                      0
breakstopsystem:                 0
restartafterdapowerfail:         1
apparmorprofiles:                0
contigpreload:                   0
syscrashcount:                   0
contigpreloadthreshold:          0
activemaps:                      64
dbsmaps:                         3
temporaldisable:                 0
pdeasyncabort:                   0
tskstopwaittime:                 0
avxflag:                         0
udfdebugging:                    0
minidumptype:                    0
prgtrace:                        0
datacache:                       30
dbschkon:                        0
dbstimeout:                      0
dbschkrate:                      0
dbschkdelay:                     0
dbschklogflush:                  0

```

###ctl ： PDE Controlプログラム。PDE構成設定値を表示・変更
>Control GDOエディター(ctl)は、PDE Controlプログラムとも呼ばれ、PDE構成設定値を表示したり、変更したりできます。
この設定値は、PDEによるTeradataの始動の処理方法、リセットの対応方法、および通常動作時の機能に影響します。

>グローバル分散オブジェクト(GDO)は、Teradata Databaseの構成設定値を格納するバイナリファイル。
システムのすべてのノードに分散され、使用されます。 
Teradata DatabaseのPDE層により、すべての仮想プロセッサでGDOの一貫性が保たれます。

```
TDExpress1620_Sles11:~ # ctl
> help 
For help on a particular command, enter 'help command' 
or enter 'help topics' for a list of the help topics.

CTL Command Syntax Summary

help [<cmd>|topics]

exit [write]
quit [write]

read
write
save [filename]
clear
default
diff

<variable> = [<v>|?]

print <variable> [; <variable> [; <variable>]
print [all|text|labels|scales|buttons|trace|checkbox]
<v> is a value appropriate to the type of variable being assigned,
and <variable> is one of the control gdo variable names.
Most commands and arguments can be abbreviated to two characters.

hardware
screen [version|dbs|debug|rss]

> screen dbs

(0) Minimum Node Action:	Clique-Down
(1) Minimum Nodes Per Clique:	1		(2) FSG cache Percent:	30
(3) Clique Failure:		Clique-Down	(4) Cylinder Read:      On
(5) Restart After DAPowerFail:  On		(6) Cylinder Read Ageing Threshold:  0
(7) Maximum Fatal AMPs:		0

> screen debug

(0) Start DBS:		   On		(1) Break Stop:		  Off
(2) Start With Logons:	   All		(3) Start With Debug:	  Off
(4) Save Dumps:		   Off		(5) Snapshot Crash:	  Off
(6) Maximum Dumps:	   0		(7) Start PrgTraces:	  Off
(8) Restart Dump Type:	   Selective	(9) UDF Debugging:	  Off

> screen rss

(0) Node Logging Rate  : 600 sec

			RSS Table Logging Enable

(1) SPMA : Off     (2) IPMA : Off     (3) SCPU: Off
(4) SVPR : Off     (5) IVPR : Off     (6) SLDV: Off     (7) SHST: Off
(8) SPDSK: Off     (9) SVDSK: Off     (A) SAWT: Off     (B) SPS : Off
(C) SMHM : Off

			RSS Summary Mode Enable

    Summarize SPMA: Off        Summarize IPMA : Off    (D) Summarize SCPU : Off
(E) Summarize SVPR: Off    (F) Summarize IVPR : Off    (G) Summarize SLDV : Off
(H) Summarize SHST: Off    (I) Summarize SPDSK: Off    (J) Summarize SVDSK: Off
(K) Summarize SAWT: Off        Summarize SPS  : Off    (L) Summarize SMHM : Off

```



###cnscim -s ： CNSコンソールの一覧を表示

```
TDExpress1620_Sles11:~ # cnscim -s

CNS Screens

Screen 3  --  qrysessn
   active=True,  enabled fkeys=, help level=0,
   nostop=False,  reading=True, hide=True

Screen 4  --  qrysessn
   active=True,  enabled fkeys=, help level=0,
   nostop=False,  reading=True, hide=True

Screen 5  --  DBS I/O
   active=True,  enabled fkeys=, help level=0,
   nostop=False,  reading=False, hide=False

Screen 6  --  SUPERVISOR
   active=True,  enabled fkeys=, help level=0,
   nostop=False,  reading=True, hide=False
```

###cnsterm 6 ： SuperVisorコマンド実行するターミナルに接続
```
TDExpress1620_Sles11:~ # cnsterm 6

Input Supervisor Command:
> help
help

CNSSUPV Command Summary

 quit
 help

 cnsget

 cnsset lines      <n>
 cnsset statepoll  <n>
 cnsset timeout    <n>

 disable logons
 disable all logons
 enable logons

 enable all logons

 enable dbc logons

 get config
 get extauth
 get logtable {all|spma|ipma|svpr|ivpr|scpu|sldv|spdsk|svdsk|sawt|sps|shst|smhm}
 get sumlogtable {svpr|ivpr|scpu|sldv|spdsk|svdsk|sawt|sps|shst|smhm}
 get activelogtable {all|spma|ipma|svpr|ivpr|scpu|sldv|spdsk|svdsk|sawt|sps|shst|smhm}
 get resource
 get time
 get version
 get permissions <user>@<host>

 grant <unix-user>@<host> <permission-list>
 revoke <unix-user>@<host> <permission-list>

 log <text>
 query state

 abort session sessionid [logoff] [list] [override]
 restart tpa [nodump|dump={yes|no}] [cold|coldwait] <text>
 set extauth {on|off|only}
 set logtable {all|spma|ipma|svpr|ivpr|scpu|sldv|spdsk|svdsk|sawt|sps|shst|smhm} {on|off}
 set sumlogtable {svpr|ivpr|scpu|sldv|spdsk|svdsk|sawt|sps|shst|smhm} {on|off}
 set activelogtable {all|spma|ipma|svpr|ivpr|scpu|sldv|spdsk|svdsk|sawt|sps|shst|smhm} {on|off}
 set resource coll[ection] <n1> [log[ging] <n2>]
 set resource log[ging] <n1> [coll[ection] <n2>]
 set session collect <n>

 start[1|2|3|4]  [,debug|-d] [,vproc=<n>|-v=<n>|-v <n>] <program> <args>
 start [,debug|-d] {-p <part> [ -g <group> | -v <n> ] <program> <args>

 stop {1|2|3|4}
 stop {-p <p> [ -g <group> ] }

The following commands may not be available in all modes:
quit, cnsget, cnsset, start, and stop.  Some options of the
start and stop commands may not be available (-p and -g).


Input Supervisor Command:
> 

```

###logview ： システム ログとダンプ ユーティリティ
```
TDExpress1620_Sles11:~ # logview
(中略)
Dec 26 09:30:01 TDExpress1620_Sles11 /usr/sbin/cron[9792]: (root) CMD (/var/opt/teradata/TASM_Throttle_Enforce.sh  2 1 2)
Dec 26 09:34:20 TDExpress1620_Sles11 syslog-ng[1542]: Log statistics; dropped='pipe(/dev/xconsole)=0', processed='center(queued)=520', processed='center(received)=413', processed='destination(messages)=411', processed='destination(mailinfo)=2', processed='destination(mailwarn)=0', processed='destination(localmessages)=14', processed='destination(mailerr)=0', processed='destination(newserr)=0', processed='destination(warn)=54', processed='destination(netmgm)=0', processed='destination(null)=0', processed='destination(mail)=2', processed='destination(xconsole)=37', processed='destination(firewall)=0', processed='destination(acpid)=0', processed='destination(newscrit)=0', processed='destination(newsnotice)=0', processed='source(src)=413'
Dec 26 09:40:01 TDExpress1620_Sles11 /usr/sbin/cron[10430]: (root) CMD (/var/opt/teradata/TASM_Throttle_Enforce.sh  2 1 2)
Dec 26 09:44:31 TDExpress1620_Sles11 gnome-session[8621]: WARNING: Unable to determine session: Unable to lookup session information for process '8621'
Dec 26 09:48:04 TDExpress1620_Sles11 gnome-session[8621]: WARNING: Unable to determine session: Unable to lookup session information for process '8621'
```

###nodecheck ： ローカル ノードからのPDE vital情報を収集して分析
```
TDExpress1620_Sles11:~ # nodecheck
Reading Node Resources... please wait...
Which Linux are we:  SuSE

FreeMemory(Pages) and FreeSwap(Blocks)
/usr/bin/sar -r 2 5
FREEMEM        1045599   
FREESWAP       30438200  

PDE Msg Daemon Queue length
/usr/pde/bin/pdeglobal msg -knode
MSGEVCOUNT     0         

BNS Block Queue
/usr/pde/bin/puma -D BlockStats/d
BNSBLKQ        0         

Available AMP Worker Tasks
/usr/pde/bin/puma -c
Count   Vproc   
55      0       
56      1       

BNS reject% for different Message types
/usr/pde/bin/tdnstat -a 5 2
Not available at this time: 

Evaluating results... please wait...

No tunables show status of WARN or ALERT

```

###pdeconf ： PDE構成情報
```
TDExpress1620_Sles11:/etc/init.d # pdeconf
User         = 'teradata'
Group        = 'tdtrusted'
UDFUser      = 'tdatuser'
UDFGroup     = 'tdatudf'
SSON         = 'teradata:tdatuser'
LegacyAuth   = '1'
SysAdminUDF  - is not set
AutoStart    = '1'

```

###pdehelp ： Teradataツールのオンライン ヘルプを表示
```
TDExpress1620_Sles11:/etc/init.d # pdehelp
ampload          - Display AWT availability and message counts on AMP VPROC
awtmon           - Amp Worker Task Inuse (or Active) Count monitor tool
bns.mtune        - Master tunable or mtune File for tdntune program
btrace           - Displays an application task's backtrace
cgrouptree       - Displays the TDAT cgroup tree
cnscim           - PDE Console Subsystem
cnscons          - PDE Console Subsystem for running Supervisor commands
cnsrun           - Scripting a Database Utility
cnsterm          - PDE Console Subsystem Terminal
cnstool          - PDE Console Subsystem Tool 
collectd         - Trace collection daemon
controlgdo       - Displays Control GDO contents
csp              - Crashdump Save Program
cspclean         - Clean up Crashdump Save Program's run time environment
cspinfo          - Crashdump Save Program Information display utility
csppeek          - Display useful information from a PDE dump
cspslave         - Crashdump Save Program Slave process
cspstop          - Graceful shut down of the Crashdump Save Program
cspstreamend     - Load stream files from the Crashdump Save Program
cspwake          - Awaken the Crashdump Save Program
ctl              - Mutil GDOs Read/Write utility
dapowerfail      - Shutdown and restart the Teradata database 
                   because of a disk array power failure
dbgcrnr          - System Debugger coroner
dbgok            - script to check the system state prior to attaching to the system debugger.
dbgpidf          - System debugger information utility
dbgsrvr          - System Debugger server
dbgvpcp          - System Debugger Virtual Processor control program
dmp              - Dump PDE specific information during a PDE error
dmpbust          - Decode PDE dump files
dmpconfig        - Tool to configure the new dump device 
emfmkidx         - Converts "emffile" to an indexed file for Teradata
evtool           - Displays the event message text for any event message provided by EMF
exttest          - Teradata Virtual Storage Extent Driver Utility
fragmon          - memory fragmentation monitoring script
fsgagestat       - PDE fsgcache ageout statistic display utility
fsgcacheadjust   - Utility to adjust LRU or VH cache in FSG without restart.
fsgiopstat       - PDE FSG I/O priority statistic display utility
fsgmon           - FSG Subsystem Data Display Utility providing a user interface
fsgstat          - FSG Statistics Display Utility
gdom             - monitor the GDOs' changes and record into history files.
gdomview         - display the history records based on the time range
gdoviewer        - Displays the contents in the GDO
gen_html         - Generates html files from the POD sources
gencachefile     - Local Cache File Setup Script
globaltvam.py    - Global Tvam Aggregator.  
ins_pde          - Creates PDE's running environment for a given version
judbagent        - -Java UDF Debugger Agent
judbsrvr         - JUDF Debugger Server
killtask         - Teradata task kill utility
kpatch           - PDE kernel symbol display/patch tool
logevent         - Log messages to the Unix System Log (Syslog) and/or 
                   to the display
logtpad          - daemon to archive system logs into database.
logview          - System Log and Dump Utility
mboxchk          - DBS well-known mailbox check and monitor tool
memfree          - show free memory on a live Linux node
mm               - Monitors kernel memory
modmpplist       - Modify the mpplist file on local or all system nodes
nodecheck        - Gathers and analyzes PDE vital information from local node
nodepowerfail    - Create file to indicate main power loss to a node
pdcmanager       - PDC Manager component
pdcmaster        - PDC Master component
pdcslave         - PDC Slave component
pdctester        - PDC Tester component
pdeacl           - Display file access control list
pdeclio          - Parallel CLuster IO performance/diagnostic tool
pdeconf          - PDE configuration settings
pdedrv           - PDE device driver load/unload administration command
                   pdedrv - TVSA extent device driver load/unload administration command
pdefixpaths      - Enforce file permissions on Teradata files and directories
pdeglobal        - Displays the PDE global information
pdehelp          - Displays Teradata tools online help
pdeinfo          - Saves system-wide PDE related data
pdemain          - PDE master control program
pdemem           - PDE memory statistic utility
pdepath          - Displays paths of Teradata running environment
pdeperfchk       - Benchmark hardware performance
pdesemfix        - Display and Modify Teradata semaphores
pdestat          - PDE System call Statistics Display Utility
pdestate         - Displays the current PDE state and substate
pdestop          - Brings PDE down immediately on the local node
pdesysfs         - Read the PDE kernel information in sysfs and output the 
                   data as an xml document.
pdewrap          - A front-end utility to run non-PDE executable or PDE tool 
                   written in scripting language under CNS interface.
pgcachedel       - drop page cache for a file
pgcachestat      - Display or drop page cache for a file
pgcachestats     - print page cache statistics for a file
pgnocache        - don't keep or remove Linux page cache on given command
pnetecho         - Find all hosts connected through a network interface
prginv           - PDE program invocation utility
prgreset         - PDE Partition Reset Utility
prgtrace         - Produces detailed traces of actions taken by PDE programs
pschstat         - Parses pcl -s schstat output and gathers stat data for each node
psh              - Parallel SHell (P-SHell)
ptype            - Extracts and displays type information from an ELF object
puma             - Prints PDE information and kernel memory addresses 
rcbview          - RCB Dump Display Utility
recond           - Start Teradata Reconcile 
reconinfo        - Teradata Package Information Collector
reconsh          - Teradata reconcile rule interpreter
resclear         - Reservation clear script.  
rssmon           - RSS Data Monitoring Tool
runcnstool       - Run cnstool with timeout so that perl scripts do not hang
schinfo          - Displays PSF information for a session and/or awt usage
schmon           - Priority Scheduler Utility. Information for SLES10 schmon.
schmonslg        - Priority Scheduler Utility. Information for SLES11 schmon.
schset           - Display and modify Priority Scheduler settings
schstat          - Display Priority Scheduler statistics. Information for SLES10 schstat.
schstatslg       - Display Priority Scheduler statistics
schtracebt       - Display long monitor and fsg lock wait/hold traces
segstat          - SEG subsystem Statistics Display Utility
stpmon           - DBS AMP-step processing trace monitor utility
syscheck         - Gathers and analyzes PDE vital information from system node(s)
sysmsgstat       - DBS message monitor utility
tbimpmon         - Displays TBIMP data
tdapparmor       - Configure the use of Teradata AppArmor profiles
tdatcmd          - Sets up a Teradata command shell or window
tdinfo           - Displays the Teradata system configuration
tdinstall        - Install a Teradata component software package
tdiopstat        - TDSCHED Statistics Display Utility
tdmaint          - Tool for marking the node for maintenance and change it back
tdmem            - Teradata memory information tool 
tdnstat          - Teradata Network (TDN) Statistics Display Utility
tdntune          - TDN dynamic tunables read/write utility
tdoprofile       - Profile the CPU registers across the Teradata system and generate reports for the samples collect from all nodes on control node.
tdpkgrm          - Removes old Teradata software versions
tdpperf          - Monitor Teradata library functions for Path Performance information
tdrmpde          - Removes the current version of PDE
toscrashcount    - TPA Crash Count Utility 
tosgetpma        - Displays the contents of the tosgetpma structure
tpacontrolnode   - Display the PDE control node id, cabinet, and module number in decimal format.  Also displays the node name.
tpanode          - Display the PDE node id, in decimal format, as well as the node type.
tpanodecrash     - Forces an OS-level memory (or panic) dump
tpareset         - TPA reset utility
tpasetcfg        - Cancels PDE's NETCONFIG start-up timeout
tpasumtrace      - Summarizes TPA start-up and restart traces for all nodes
tpatrace         - Displays PDE start-up and restart traces for various 
                   subsystems
tpatracedump     - Extracts and displays TPA traces from a kernel panic dump
tracebit         - Trace selection bit manipulator utility
tracectl         - Trace control function management utility
tracedmp         - Trace dump extraction utility
tracefmt         - Trace data formatting utility
tracemrg         - Trace data file merge utility
tracenum         - Trace configuration data enumeration utility
trext            - Trace data extraction utility
tsklist          - Displays information about PDE processes and their tasks  
tut              - Trace UTility for Teradata software trace subsystem 
tvam             - Teradata Virtual Storage manager
tvsaallocdbg     - Teradata Virtual Storage allocator debug utility
tvsacheckcyl     - Teradata Virtual Storage check cylinder
tvsadeviceinit   - Teradata Virtual Storage device initializer.
tvsadisableciseg - Teradata script used for converting segregated devices back to a non-segregated state. 
tvsadisplaymap   - Teradata Virtual Storage display device map
tvsadisplaytag   - Teradata Virtual Storage display device tag
tvsadisptbuf     - Teradata Virtual Storage display trace buffer
tvsadumpstats    - Teradata Virtual Storage dump statistics
tvsafilterheatmap - Teradata Virtual Storage utility to parse heatmap files
tvsafixtag       - Teradata Virtual Storage fix device tag
tvsainitall      - Teradata Virtual Storage initialize all devices
tvsaiotrace      - Teradata Virtual Storage I/O trace
tvsamapeditor    - Teradata internal testing tool for tvsaallocator
tvsamapzap       - Teradata Virtual Storage tvsaMapZap
tvsaminampspce   - Teradata Virtual Storage minimum AMP space
tvsamodtemps     - Modifies temperatures
tvsanormalize    - Teradata Virtual Storage Utility to normalize extents
tvsaparseprofile - Internal Profile Check
tvsaprofiler     - Teradata Virtual Storage device profiler
tvsaprofilercheck - Teradata internal testing tool for checking pdisk profiles
tvsasegci        - Teradata utility used for a variety of CI Seg related functions including converting segregated devices back to a non-segregated state.
tvsatrashci      - Teradata Virtual Storage trash cylinder index
udbconnect       - UDF Debug Server Connection Manager
udbctrl          - UDF Debugger Controller
udbsrvr          - UDF Debugger Server
uns_pde          - Removes PDE's running environment for a given version
v2pgdo           - Displays the contents of the V2P GDO
vconfig          - Translates configuration definition to VCONFIG GDO  
verify_pdisks    - verifies configuration definition of vconfig.gdo 
                   and matches the configuration on disk.
vprocgdo         - Displays the contents of the VprocConfig GDO
xdbw             - Database Window (DBW)
certlink         - Creates hash links to Certificates and CRLs present in the specified directory. 
cyrus            - SASL
genselfsignedcert - Generates a self-signed certificate and the corresponding private key 
gethost          - display network information for Kerberos configuration
jansson          - License
                   JANSSON License
openldap         - License
tdgssconfig      - TDGSS configuration tool
tdgssfiles       - Display files that comprise the TDGSS configuration
tdgssfixpaths    - Enforces file ownership and permissions on both the Kerberos files and the LDAP files. 
tdgssupdatefix   - Updates Teradata keytab file for Kerberos and enforces file ownership and permissions for both the Kerberos files and the LDAP files. 
tdsbind          - TDGSS binds the user in the directory 
tdspolicy        - TDGSS Policy Query Utility
tdssearch        - TDGSS Directory search utility
updatekeytab     - Creates or updates the Teradata keytab file for Kerberos.
xerces-c         - XML Parser
gtwcontrol       - Teradata Gateway configuration manipulation utility
gtwglobal        - Teradata Gateway session monitor and control utility
```

#参考
[PDEツール • Teradata Vantage™ - データベース ユーティリティ • リーダー • Teradataドキュメント](https://docs.teradata.com/r/gjXRKe910A9hOE8O2C3Ufw/zZ1L9wMPp~Unx2iLa_jCeQ)
[]()
[]()