Overview

This document explains how to check situations where the system is started using incorrect libraries or with incorrect resource limit values during operation.

Method

Problem CASES

• CASE1: Checking Environment Variables During Data Operations
  Used when you want to check the client's CHARSET while performing large data operations using the tbloader or tbSQL utility (tbCLI).
   

• CASE2: Checking Library Paths When Using Tibero Engine and ProSync Engine Together
  Used to verify which library paths the Tibero process is using after installation.
   

• CASE3: Checking ulimit Values of Running Tibero Processes
  Used to check the resource limit values of Tibero processes.
   

• CASE4: Checking Environment Variables and ulimit Values of Non-Tibero Processes
  Used to verify whether proper environment variable paths are applied to Tibero processes by checking the environment variables and ulimit values of related processes.

Verification Methods by CASE

CASE1 & 2: Checking Environment Variables During Data Operations / Checking Library Paths

$ ps -ef |grep tbsvr
tibero    411295       1  2 17:30 pts/13   00:00:00 tbsvr          -t NORMAL -SVR_SID TEST
tibero    411299  411295  0 17:30 pts/13   00:00:00 tbsvr_MGWP     -t NORMAL -SVR_SID TEST
tibero    411300  411295  0 17:30 pts/13   00:00:00 tbsvr_FGWP000  -t NORMAL -SVR_SID TEST
tibero    411301  411295  0 17:30 pts/13   00:00:00 tbsvr_FGWP001  -t NORMAL -SVR_SID TEST
tibero    411302  411295  0 17:30 pts/13   00:00:00 tbsvr_PEWP000  -t NORMAL -SVR_SID TEST
tibero    411303  411295  0 17:30 pts/13   00:00:00 tbsvr_PEWP001  -t NORMAL -SVR_SID TEST
tibero    411304  411295  0 17:30 pts/13   00:00:00 tbsvr_PEWP002  -t NORMAL -SVR_SID TEST
tibero    411305  411295  0 17:30 pts/13   00:00:00 tbsvr_PEWP003  -t NORMAL -SVR_SID TEST
tibero    411306  411295  0 17:30 pts/13   00:00:00 tbsvr_PEWP004  -t NORMAL -SVR_SID TEST
tibero    411307  411295  5 17:30 pts/13   00:00:00 tbsvr_AGNT     -t NORMAL -SVR_SID TEST
tibero    411308  411295  0 17:30 pts/13   00:00:00 tbsvr_DBWR     -t NORMAL -SVR_SID TEST
tibero    411309  411295  0 17:30 pts/13   00:00:00 tbsvr_RCWP     -t NORMAL -SVR_SID TEST

$ strings /proc/411295/environ
LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.zst=01;31:*.tzst=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.wim=01;31:*.swm=01;31:*.dwm=01;31:*.esd=01;31:*.jpg=01;35:*.jpeg=01;35:*.mjpg=01;35:*.mjpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.m4a=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.oga=01;36:*.opus=01;36:*.spx=01;36:*.xspf=01;36:
LD_LIBRARY_PATH=/tibero/user/seungah_ham/test/unixODBC-2.3.12/unixODBC/lib:/tibero/user/seungah_ham/test/tibero7/lib:/tibero/user/seungah_ham/test/tibero7/client/lib:
ODBCINI=/tibero/user/seungah_ham/test/unixODBC-2.3.12/unixODBC/config/odbc.ini
MODULES_RUN_QUARANTINE=LD_LIBRARY_PATH LD_PRELOAD
LANG=en_US.UTF-8
HISTCONTROL=ignoredups
HOSTNAME=ENT-ROCKY8
OLDPWD=/tibero/user/seungah_ham
S_COLORS=auto
which_declare=declare -f
MODULES_CMD=/usr/share/Modules/libexec/modulecmd.tcl
USER=tibero
PWD=/tibero/user/seungah_ham/test
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/tibero/user/seungah_ham/test
TB_HOME=/tibero/user/seungah_ham/test/tibero7
XDG_DATA_DIRS=/home/tibero/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share
ODBCSYSINI=/tibero/user/seungah_ham/test/unixODBC-2.3.12/unixODBC/config
LOADEDMODULES=
MAIL=/var/spool/mail/tibero
TERM=xterm
SHELL=/bin/bash
TBINARY_PATH=/tibero/user/seungah_ham/tbinary
UNIXODBC_HOME=/tibero/user/seungah_ham/test/unixODBC-2.3.12/unixODBC
TBCLI_WCHAR_TYPE=UCS2
SHLVL=1
MANPATH=:
MODULEPATH=/etc/scl/modulefiles:/usr/share/Modules/modulefiles:/etc/modulefiles:/usr/share/modulefiles
LOGNAME=tibero
MODULEPATH_modshare=/usr/share/Modules/modulefiles:2:/etc/modulefiles:2:/usr/share/modulefiles:2
TB_SID=TEST
PATH=/tibero/user/seungah_ham/test/unixODBC-2.3.12/unixODBC/bin:.:/tibero/user/seungah_ham/test/tibero7/bin:/tibero/user/seungah_ham/test/tibero7/client/bin:.:/tibero/tbinary:/home/tibero/.local/bin:/home/tibero/bin:/usr/share/Modules/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/tibero/user/seungah_ham/test/.local/bin:/tibero/user/seungah_ham/test/bin
DEBUGINFOD_URLS=https://debuginfod.centos.org/ 
MODULESHOME=/usr/share/Modules
HISTSIZE=1000

CASE3 & 4: Checking ulimit Values of Processes

1. ULIMIT values for processes running in the current session
$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 158653
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 300000
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 116384
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

2. ULIMIT values for Tibero process
$ cat /proc/411295/limits
Limit                     Soft Limit           Hard Limit           Units     
Max cpu time              unlimited            unlimited            seconds   
Max file size             unlimited            unlimited            bytes     
Max data size             unlimited            unlimited            bytes     
Max stack size            8388608              unlimited            bytes     
Max core file size        0                    unlimited            bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             116384               163840               processes 
Max open files            300000               300000               files     
Max locked memory         65536                65536                bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       158653               158653               signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Max realtime timeout      unlimited            unlimited            us