6.20.08 - ncli --help postupgrade - Aster Database

Teradata AsterĀ® Database 6.20 Release Notes

Product
Aster Database
Release Number
6.20.08
Published
November 2019
Language
English (United States)
Last Update
2019-11-12
dita:mapPath
vux1500568440584.ditamap
dita:ditavalPath
External-only.ditaval

Syntax

# ncli --help postupgrade

This is run after performing the upgrade.

ncli postupgrade command
Command Help Text
checkConfigFileAndRestore Check if config files are intact after upgrade
checkQos Check if QOS is same for both preupgrade and postupgrade
checkThreshold Check if the threshold is same for both preupgrade and postupgrade
cleanup Do the clean up
verifySqlhConnectivity Check if you are connected to your Hadoop cluster
verifyTdConnectivity Check if you are connected to your Teradata box

Example: checkConfigFileAndRestore command

ncli postupgrade checkConfigFileAndRestore
postgresql.conf                                 100%   20KB  20.1KB/s   00:00    
hosts                                           100%  128     0.1KB/s   00:00    
resolv.conf                                     100%  132     0.1KB/s   00:00    
coordinator.cfg                                 100% 9889     9.7KB/s   00:00    
loader.cfg                                      100% 3351     3.3KB/s   00:00    
queen-replacement.cfg                           100%   20     0.0KB/s   00:00    
worker.cfg                                      100% 5752     5.6KB/s   00:00    
coordinator.profile                             100% 1498     1.5KB/s   00:00    
loader.profile                                  100%  290     0.3KB/s   00:00    
worker.profile                                  100% 1174     1.2KB/s   00:00    
ntp.conf                                        100% 1833     1.8KB/s   00:00    
beehiveparams.cfg                               100%  501     0.5KB/s   00:00    
cgconfig.conf                                   100%  812     0.8KB/s   00:00    
pg_hba.conf                                     100% 3386     3.3KB/s   00:00    
postgresql.conf                                 100%   20KB  20.1KB/s   00:00    
postgresql.conf                                 100%   20KB  20.1KB/s   00:00    
hosts                                           100%  128     0.1KB/s   00:00    
resolv.conf                                     100%  155     0.2KB/s   00:00    
coordinator.cfg                                 100% 9889     9.7KB/s   00:00    
loader.cfg                                      100% 3351     3.3KB/s   00:00    
queen-replacement.cfg                           100%   20     0.0KB/s   00:00    
worker.cfg                                      100% 5752     5.6KB/s   00:00    
coordinator.profile                             100% 1498     1.5KB/s   00:00    
loader.profile                                  100%  290     0.3KB/s   00:00    
worker.profile                                  100% 1174     1.2KB/s   00:00    
ntp.conf                                        100% 1833     1.8KB/s   00:00    
beehiveparams.cfg                               100%  501     0.5KB/s   00:00    
cgconfig.conf                                   100%  812     0.8KB/s   00:00    
pg_hba.conf                                     100% 3386     3.3KB/s   00:00    
postgresql.conf                                 100%   20KB  20.1KB/s   00:00    
ConfigFileCheck
+--------+---------------------------------------------------+
| Node   | Status                                            | 
+--------+---------------------------------------------------+
| queen  | All the Config files are intact after upgrade     | 
| worker | All the Config files are intact after upgrade     | 
+--------+---------------------------------------------------+

Example: checkQos command

ncli postupgrade checkQos
QOS concurrency has not changed after upgrade

Example: checkThreshold command

ncli postupgrade checkThreshold
Threshold has not changed

Example: cleanup command

ncli postupgrade cleanup
clean up done

Example: verifySqlhConnectivity command

Bolded words are user input, which can be seen either at command call or while output is generated.
ncli postupgrade verifySqlhConnectivity
Please enter table name: someTable
Please enter user : someUser

####### Started to pre-check input parameters ########


========= Started sqlh config validation test =========

========= Passed: sqlh config validation test =========

========= Started: hcatalog server hostname validation test=========

========= Passed: hcatalog server hostname validation test=========

========= Started: hiveserver2 hostname validation test=========

========= Passed: hiveserver2 hostname validation test=========

========= Started queen hive metastore access validation test =========

========= Passed: metastore access test =========

========= Started standalone program validation test =========

========= Passed standalone program validation test =========

========= Started clean up =========
========= clean up finished =========

####### Successfully validated sqlh config for server someRemoteSystem #######

Example: verifyTdConnectivity command

Bolded words are user input, which can be seen either at command call or while output is generated.
ncli postupgrade verifyTdConnectivity
Please enter tdpid: someTeradataSystem



*** Diagnosis from 111.222.333.444 ***
Checking Connectivity

Checking Connectivity with TDPID: someTeradataSystem
someTeradataSystem resolvable on the network
someTeradataSystem:1025 connection successful
Looking for cop entries
someTeradataSystemcop1 resolvable on the network
someTeradataSystemcop1:1025 connection successful
someTeradataSystemcop2 is not reachable

*** Diagnosis from 222.333.444.555 ***
Checking Connectivity

Checking Connectivity with TDPID: lnx2038
someTeradataSystem resolvable on the network
someTeradataSystem:1025 connection successful
Looking for cop entries
someTeradataSystemcop1 resolvable on the network
someTeradataSystem:1025 connection successful
someTeradataSystemcop2 is not reachable