DSXchange

Thanks for all the effort...I will try some of the suggestions and update you if I am able to fix it. Thanks again !

For the DB the setting are as follows:

DB2 Database:
Database Code Page = 1208
Database Code Set = UTF8

Datastage: Using project default
based on the job log i was able to obtain LANG=en_US.

At the top of the document it is as per following:
<?xml version="1.0" encoding="UTF-8"?>

I shall try using the equivalent decimal value and let u know if there is any change...

The NLS_LANG setting for the DB or Datastage ?

Thanks.

Hi Ray, Thanks for your response. Current value: RTLogging=0 ORLogging=1 We have changed it to the following and the performance is now not bad (its almost the same as in v7.5.2) RTLogging=1 ORLogging=0 I was reccommended to change the MFILES setting from 100 to 200 or 250? any impact in doing so ? ...

Hi All, We upgraded from Datastage v7.5.2 to v8.1 and noticed that there is a delay in the jobs. For e.g if a job completes in 8s in v7.5.2 now it takes around 14s to complete in v8.1. After investigation, it was noted that the slowness is during the finishing stages of the job (during the purging o...

Hi All, We are encountering slow performance when jobs are executed via Datastage v8.1. When compared to executing the jobs via the Previous version (v7.5.2) the jobs are running 3 times slow in when using v8.1. The system meets the required hardware resources. Appreciate if anyone could advise on w...

Hi All,

I am not able to find any documentation on changes to the MQ component between the version 7.5.2 and 8.1.

It would be appreciated if anyone could point me to some documentation on the changes to the MQ portion.

Thanks

Hi I was trying to read a message from a Queue (using the MQ stage) and encountered the following error: Could not retrieve valid value for long property type 'REFRESHTIME'. Using default of 0. During checking, I noticed that 'REFRESHTIME' was not available in the MQ stage properties in version 7.5....

What kind of errors could i expect when testing jobs that were created using v7.5.2 in v8.1 (Specifically due to the 32bit to 64bit change in architecture) ?

Appreciate your advice. Thanks

Hi! We have upgraded from v7.5.2 to v8.1 in our test server. We have some modules where the jobs are pretty similar [extract from text file and load to DB2 with minimal transformations]. In this case is it suffient to test just one module and asssume the rest of the modules will be alright ? what is...

Hi, When we check the logs we noted that this job is not able to connect to the MQ. It seems the reason for this error is when installing the information server when prompted whether to install MQ client or MQ server, we had chosen MQ client. From what we were advised by IBM we need to install the M...

Hi All, We encountered the following error: JB_SendEndMsg_To_InQ..trx_EndofData: C Stage PlugIn function "Put" required This job sends an end messsage from a sequential file to the MQ. The testing was done after installing the datastage version 8.1 in a test environment. The job was workin...

Hi,

We have installed the Information Server 8.1 to a test environment.

I am unable to use the performance analysis tool. Does this option need to be purchased separately or is there that needs to be done before I could use it ?

Please advise.

Thanks.

Thanks a lot for your reply. Would like to also check, if there has been any noticeable difference in performance after the upgrade ?

Thanks.

ArndW wrote:I'd test everything if possible within your project time constraints - particularly if you are in production.

<edit>
I would be surprised if you found any differences if the jobs all ...