How to check number of CPU in Teradata System

There are several ways to check the number of CPU. Options are as follows:

1.      Using Command tosgetpma we can check the number of CPU in the system. Also, we can check how many CPU are enable to use because based on the license agreement sometimes you might use less CPU than the system have.

# tosgetpma

System:

  Name: XXXXXX

Processor:

  Type: Xeon (code 7)

  CPUs: 72

  TD-Enabled CPUs: 72

  Max CPUs: 72

  Memory: 516291 Mb

Node:

  ID: 001-06

  Type: TPA

  Vproc: 30720

  Clique: 0

  Type: 7011 (code 118)

  Scale Factor: 44.64

PDE:

  State: RUN/STARTED

  Status: Normal

Connections:

  Channels: 0

  Lans: 2

Timestamp:

  09/30/2020 11:16:42.38

 

 

2.      We can also check the number of CPU by using “machinetype” command

# machinetype

Model:     7011 (S2600WFT)

Productid: Platform=Rx2yzWFT Series=Rx2yzWFT Type=MPP-SM3G NodeVendor=INTEL

Class:     Unknown

Node:      TPA

Memory:    512GB

BIOS:      SE5C620.86B.02.01.5010.C0T07.031920200357

SCSI:      Intel RMS3CC080, NETAPP INF-01-00

Drivers:   teradata-multipath intel-megaraid_sas mpt2sas

OS:        Teradata SLES11 SP3 3.0.101-0.230.TDC.1.R.0-default

 

Processor In Socket 0: Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz

 

    Core  0 Thread 0 : Linux Logical CPU  0

    Core  0 Thread 1 : Linux Logical CPU 36

    Core  1 Thread 0 : Linux Logical CPU  1

  ……………………………………………………………….

  ……………………………………………………………….

    Core 26 Thread 1 : Linux Logical CPU 70

    Core 27 Thread 0 : Linux Logical CPU 35

    Core 27 Thread 1 : Linux Logical CPU 71

3.      Number of CPU also can be check using “diagnostic help profile session” command after login to a session.

diagnostic help profile session;

 *** Help information returned. 1293 rows.

 *** Total elapsed time was 3 seconds.

 

Cost Profile Parameters

---------------------------------------------------------------------------

 

SESSION: TD15 [Id =    40, Type = 2] TLE is not enabled

……………………………………………………………………

……………………………………………………………………

NumCpusPerNode        = 7.200e+01

……………………………………………………………………

……………………………………………………………………

 

Results can be used to identify each TCore Level.  TCore 1 in this example. 

7.200e+01 = 72 CPUS which is equivalent to TCore 1.
5.600e+01 = 56 CPUS which is equivalent to TCore 2.
4.000e+01 = 40 CPUS which is equivalent to TCore 3.

 

Following way we can also check the TCore level:

# tcore-activation -c

Current TCore Level: 1

Comments