codepage setting informatica

1. the error you may get

LM_36011
Code page mismatch. Service process is running in code page [UTF-8 encoding of Unicode] whereas the service is configured in the Admin Console to run in code page [ISO 8859-1 Western European]


2. system variable used to set codepage

Use LANG and LC_ALL to set the UNIX code page for the installer.
Set the LANG and LC_ALL environment variables to the following values for the
language that you use:
- English: C
- Japanese: ja_JP.SJIS or ja_JP.PCK
- Portuguese: pt_BR.ISO8859-1, pt_BR.8859-15, or pt_BR
After you install, update the locale setting to one that is compatible with the code
page of the repository.

3. another vairable used to set codepage
INFA_CODEPAGENAME


4. there are three place you have code page set up

4.1 the informatica server process
4.2 the power center repository service
4.3 the power center integration service

5. the requirements is
5.1 both service must have superset or same of codepage as the server process
5.2 Repository service must have superset or same of codepage as the integration service.

6. situation cause the error
6.1 set INFA_CODEPAGENAME=UTF-8
repository = [UTF-8 encoding of Unicode]
integration = [ISO 8859-1 Western European]

6.2 repository = [ISO 8859-1 Western European]
integration = [UTF-8 encoding of Unicode]
if INFA_CODEPAGENAME is not set, default is [ISO 8859-1 Western European]

there are other situations,which may cause the error. It should be fixed after assign correct code page.

reference:
http://dbcrusade.blogspot.com/2009/06/informatica-setting-codepage.html
Informatica 9.0.1 administrator Guide
Power center 9.0.1 Hotfix 1 Installation and Configuration Guide