Overview

A license is required in advance to install Tibero DB, and the following items are needed to issue the license.

• hostname
• Tibero version
• NCPU (cpu * core * thread)

NCPU information can be checked using OS commands, but it can be easily confirmed using the system_check.sh shell script provided in the Tibero binary. This script allows you to check CPU, Memory, and OS Parameter settings.

Caution

It operates stably on versions with patch 346249a applied.

The patch is applied through technical support provided by Tmax Tibero.

Method

Location of system_check.sh

The script is located in the $TB_HOME/scripts directory.

$ cd $TB_HOME/scripts
$ ls -alrt system_check.sh
-rwxr-xr-x. 1 tibero dba 14788 Nov 10 17:06 system_check.sh

Executing system_check.sh

1. Linux

NCPU information can be confirmed under the Active cores item.

$ sh system_check.sh

CPU Info.
- Model                 : 12th Gen Intel(R) Core(TM) i7-12700
- Clock                 : 
- Sockets               : 1
- Core                  : 12
- Thread                : 20
- Active cores          : 20

Memory Info.
- Physical Size         : 31605.3 MB
- Swap Total            : 4096 MB
- Shmem                 : 14548.1 MB
- HugePage Size         : 2048 kB
- HugePage Total        : 0 kB

cat: /proc/sys/net/core/rmem_max: No such file or directory
cat: /proc/sys/net/core/wmem_max: No such file or directory

Parameter Info.

 IPC
 - shm size             : 17592186044400 MB
 - sem count            : 32000 1024000000 500 32000

 File
 - AIO max              : 5516057
 - file max             : 9223372036854775807
 - inode max            : 94371840

  Network
 - Recv Mem max         : 
 - Send Mem max         : 
 - Port range           : 32768 - 60999

Limit Info.
- open files            : 1048576
- max user proc         : unlimited
- stack size(KB)        : unlimited
- core file(block)      : unlimited
- file size(block)      : unlimited
- max memory size(KB)   : unlimited

2. AIX

NCPU information can be confirmed under the Active cores item.

$ sh system_check.sh

lsattr is /usr/sbin/lsattr
lscfg is /usr/sbin/lscfg
lsdev is /usr/sbin/lsdev
 
CPU Info.
- Model                 : PowerPC_POWER7
- Clock                 : 3 GHz
- Sockets               : 2
- Core                  : 16
- Thread                : 64
- Active cores          : 64
 
prtconf is /usr/sbin/prtconf
lsps is /usr/sbin/lsps
vmo not found.

system_check.sh[25]: vmo: 0403-006 Execute permission denied.
system_check.sh[26]: vmo: 0403-006 Execute permission denied.
system_check.sh[27]: huge_page_total_size=huge_page_size*huge_page_total_size/1024/1024: 0403-009 The specified number is not valid for this command.
  
Memory Info.
- Physical Size         : 63488 MB
- Swap Total            : 1024MB
- Shmem                 : N/A
- HugePage Size         : 
- HugePage Total        : 0 MB
 
no is /usr/sbin/no

Parameter Info.
 
 IPC 
 - shm size             : N/A 
 - sem count            : N/A
 
 File 
 - AIO max              : N/A 
 - file max             : N/A 
 - inode max            : N/A

 Network
 - Recv Mem max         : 65536
 - Send Mem max         : 65536
 - Port range           : 32768 - 65535
 
Limit Info.
- open files            : unlimited
- max user proc         : unlimited
- stack size(KB)        : unlimited
- core file(block)      : unlimited
- file size(block)      : unlimited
- max memory size(KB)   : unlimited