IC78180: DBACCESS ERROR -23101 "UNABLE TO LOAD LOCALE CATEGORIES" locale file .lco is missing

APAR status

• Closed as program error.

Error description

• Environment:
  Informix SE 7.25.UC6R1 / Linux
  ILS 3.50.MC5
  
  Error -23101 comes up when accessing a database with dbaccess
  with these locale settings:
  
  First create a test database with DB_LOCALE en_US.8859-1.
  CLIENT_LOCALE=lt_LT.8859-13
  SERVER_LOCALE=lt_LT.8859-13
  DB_LOCALE=lt_LT.8859-13
  
  With DBACCESS -> Query-language -> SELECT DATABASES
  
  error -23101 "Unable to load locale categories" comes up
  
  The tool strace shows in case 2
  21408 open("/opt/IBM/se-7.25.uc6r1/gls/lc11/en_us/0333.lco",
  O_RDONLY|O_LARGEFILE) = 6
  21408 open("/opt/IBM/se-7.25.uc6r1/gls/lc11/lt_lt/0333.lco",
  O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
  
  
  The locale file for codepage 8859-1 (0333.lco) is missing in
  $INFORMIXDIR/gls/lc11/lt_lt/
  
  
  Lithuanian language is also affected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * lt_LT.8859-13 users of ILS 3.50 MC5                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * User unable to use databases created in different locales    *
  * with dbaccess                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Install ILS 3.50 MC6 when available                          *
  ****************************************************************
  

Problem conclusion

• Could not reproduce with ILS 3.50 MC6.   dbs created with
  different locales accessible through dbaccess when corresponding
  locale active in environment
  

Temporary fix

Comments

• For download information, go to:
  http://www.ibm.com/support/fixcentral
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP

• RB15 PSY

     UP