DSXchange

Hi I would like to purge or clean-up from the Data stage director automatically for Multi instance jobs logs and instance also. I hope multi-instance job will append with Invocation id. Like: Ld_Exe_Metric.8699687 Ld_Exe_Metric.8699688 Ld_Exe_Metric.8699689 So I don't want to keep the entire instanc...

I have fixed this issue.

There some issue with LDAP and IP address config issue.


Thanks
Man

we are using oracle EE stage as source and Target. Now we are able to connect Oracle EXADATA but recently they have added more rack for Exadata storage,after that very slow for Oracle EE stage but if I use ORACLE Connector stage there is no slow. Is this anything I have to do for ORACLE EE Stage. Th...

Hi

The 8.5 and 8.7 onwards you can able to set RTLogging or ORLogging from Datastage Admin.

Thanks
Man

Hi We are using Datastage 8.7 with AIX OS. I would like to prevent edit or update the DSParams file from all other developers. We have dstage UNIX group but all other users is part of 'dstage' group so any one able to change the values from DSParams. I am thinking we can create a new UNIX group and ...

Thanks Roy,

I have fixed this issue.

I have cleared RT_LOG,RT_STATUS files for that job and reboot the whole Datastage server.


Thanks
Man

Thanks Ray.

I am not about ISA Lite. Can you please point me where and how I will do this?

Thanks
Man

Hi I am going to close this. I hope IBM tightened up metadata checking between DataStage and the Database considerably since 8.1. So I have re-import the metadata for this table using Orchestrate into 8.7(Since we are using ORACLE EE stage), delete the metadata from the stage and reload it. And then...

Hi I have issue with one job, so I am trying to delete and rename it, but my job deleted and it is not showing in Designer but still it is showing in Director. And also it is not allow importing and renaming. I have cleared all the RT_LOG & RT_STATUS too. Is this any issue with Repository? Thank...

Thanks Ray & Wiles, I have imported metadata from Orchestrate, there defined as Decimal 38 ,10. But inside lookup they changed Decimal 38,10 to Bigint. Actually there is no decimal value all are whole Integer values. I am not sure why it is convert into Decimal 38,10 from NUMBER datatype after i...

Hi


I would to like to convert from Decimal to Bigint.

Is this anything I have to do from Transformer stage?


Thanks
Man

Welcome !!

Thanks Ray

So you are saying in oracle if defined as NUMBER and then if import into Datastage it will automatically convert into DECIMAL.

Is this correct ?


Thanks
Man

Hi All I have able to fix this issue. It looks like we brought the following two environments variable from 8.1 into 8.7 . They aren't needed in Data stage versions 8.5 and greater. So I have removed these environment variables from the project (DataStage Administrator) level and job level. $DATASTA...

Thanks Ray.

Why I am getting data-type conversation?


Thanks
Man