Important consideration regarding locales

The user profile named the same as your instance AND all user profiles that perform Content Manager OnDemand data loading functions (such as ADDRPTOND, STRMONOND, arsload or arsdoc add) must have their locale set to the locale of the instance.

If the user profiles that perform Content Manager OnDemand data loading functions are also used for other non-Content Manager OnDemand work on your system, changing their LOCALE value might impact other non-Content Manager OnDemand applications. Consider creating specific Content Manager OnDemand user profiles for data loading instead, so as not to impact your other applications, and then only modify the LOCALE value for the specific Content Manager OnDemand user profiles. If necessary, change the locale of the user profiles using the Change User Profile (CHGUSRPRF) command. You should also make sure that other language-related parameters in the user profiles are correctly set. The SETJOBATR parameter is used to determine which values are obtained from the locale. For Content Manager OnDemand, at a minimum, you must use SETJOBATR(*CCSID). For example, if you are located in Spain and are using the Spanish language with Euro support you would enter the command:

CHGUSRPRF USRPRF(user_profile_name) LANGID(ESP) CNTRYID(ES) 
  CCSID(1145) SETJOBATR(*CCSID *DATFMT *TIMSEP *DATSEP *DECFMT 
  *SRTSEQ) LOCALE('/QSYS.LIB/ES_ES_E.LOCALE')

After setting the correct locale on an IBM® i user profile, you might choose to copy that user profile to create another similar user profile for use with Content Manager OnDemand. The IBM i copy function does not copy the LOCALE parameter value. After the copy is complete, you must issue the CHGUSRPRF command as shown above to set the LOCALE. You can use the Display User Profile (DSPUSRPRF) command to display or verify the locale of an existing user profile.

If you do not have a locale set in the user profile used to load data, the load job fails. The job log for the qshell job, QP0ZSPWP, contains the error message YOU MUST SET A LOCALE.