DB2 UDB Enterprise

suneelchallagali · Post by **suneelchallagali** » Fri Jan 08, 2010 8:45 am

While wroking on one job, I stuck on this error, can anybody help me...

file db2_cs.txt either does not exist or contains no values for ICU charset 'ASCL_MS1252;
set the environment variable DB@CODEPAGE or verify that os default can be use

suneelchallagali · Post by **suneelchallagali** » Fri Jan 08, 2010 8:46 am

sorry for typo mistake it is DB2CODEPAGE

chulett · Post by **chulett** » Fri Jan 08, 2010 8:54 am

So... first check - have you verified that the file does in fact exist with that exact name and you're looking for it in the proper location?

suneelchallagali · Post by **suneelchallagali** » Fri Jan 08, 2010 9:36 am

thanks chulett for your reply but problem has been solved.

chulett · Post by **chulett** » Fri Jan 08, 2010 9:42 am

And the resolution was? Always helpful to post that for anyone who comes here with a similar problem in the future.

suneelchallagali · Post by **suneelchallagali** » Fri Jan 08, 2010 9:55 am

That was good one,

Actually When i have installed the infoserver8.1 i have installed NLS also steps i follwed to solved this problem
1.open db2_udb_enterprise stage go to advance tab by default nls will be selecting project default(ASCL_MS1252) instead of that select UTF-8 then run the job it worked fine for me

but in the online they also mention to set db2codepage to 1208 in environment variable in additional to the above one.

but i dint try it.

chulett · Post by **chulett** » Fri Jan 08, 2010 10:13 am

OK, thank you.