New IBM DB2 10.5 UTF-8

pkste · Post by **pkste** » Wed Aug 19, 2015 1:47 am

We re-done our DWH database in UTF-8 mode to use new features (BLUE aceleratio...)

Now we have alot of problem when we write special characters on new DB2.

Our first Datastage version was 7.x so, because of old jobs, we not have enabled NLS feature.

Is there a way to load correctly the records?

I seen, sometime, using API stage (blue stage) instead green stage some field is correct.

Someone have any idea?

Thanks alot

ArndW · Post by **ArndW** » Mon Aug 24, 2015 4:19 am

Are you planning on turning on NLS in DataStage or continuing without it?
Specifically what problems are you having when writing to the database?

chulett · Post by **chulett** » Mon Aug 24, 2015 7:31 am

Sorry but... Blue stage? Green stage? Can we use their proper names, please.

ArndW · Post by **ArndW** » Tue Aug 25, 2015 6:39 am

He meant DB2 "BLU", that is fun to work with and can be incredibly fast or agonizingly slow. We had the latter initially but then got the former after redesigning the load process.

http://www-01.ibm.com/software/data/db2 ... eleration/

chulett · Post by **chulett** » Tue Aug 25, 2015 7:17 am

OK, then... green stage?

pkste · Post by **pkste** » Mon Sep 07, 2015 2:22 am

Hi guys, sorry to not answered, but i was in holiday.

My idea is to NOT implement NLS because, when we did, we had got alot of problems with Data and time Datatype; and we have alot of jobs to check.

The big problems we have with green stage (server edition)

Thanks alot.