Overview 

There is an issue in AIX 7.1 version where awk errors occur due to corrupted strings when the locale is ko_KR.UTF-8 and the month and day are two digits (October, November, December).

Method

Type 1)

$ tbsql sys


tbSQL 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.

awk: Field tibero      pts/0       Dec 24 dawn   is not correct.

 The input line number is 1.

 The source line number is 1.

Enter Password: 

Connected to Tibero.

Type 2)
tbsql scott/tiger@DEV


tbSQL 6  


TmaxData Corporation Copyright (c) 2008-. All rights reserved.


awk: Field tibero      pts/0       Dec 24 dawn  (192.168.134.25) is not correct.

 The input line number is 1.

 The source line number is 1.

Connected to ORACLE GATEWAY using DEV.

$ locale

LANG=ko_KR.UTF-8

LC_COLLATE=ko_KR.UTF-8

LC_CTYPE=ko_KR.UTF-8

LC_MONETARY=ko_KR.UTF-8

LC_NUMERIC=ko_KR.UTF-8

LC_TIME=ko_KR.UTF-8

LC_MESSAGES=ko_KR.UTF-8

LC_ALL=ko_KR.UTF-8

Check whether the 'month' in the login date information of the host performing tbsql is two digits.

$ who

root        lft0        Dec 11 dawn                 

master      pts/0       Jul 05 morning   

sampler1    pts/1       Dec 25 dawn 

root        pts/2       Dec 11 dawn 

root        pts/3       Feb 19 afternoon   

root        pts/6       Jan 25 afternoon   

root        pts/7       Jan 25 afternoon   

master      pts/8       Jun 26 morning   

root        pts/9       Jan 25 afternoon   

master      pts/10      Jun 21 afternoon   

root        pts/11      Jan 25 afternoon   

root        pts/12      Jan 25 afternoon   

root        pts/13      Jan 25 afternoon   

root        pts/14      Jan 25 afternoon  

root        pts/15      Jan 25 afternoon

This is an inherent bug in AIX and cannot be fixed from the DB side. A patch 181354a that processes and cleans the data before awk operations on the AIX machine is required to ensure normal operation even if the string is corrupted.