DSXchange

Sorry Sir,It is DB2

ArndW wrote:Avik - you neglected to tell us what database you wish to connect to. ...

Hi,

I will be intalling a Datastage server in a fresh system.

I want to know where can I specify whether ODBC or direct native connection will be used for connecting to remote database.


Thanks and Regards

Avik Dasgupta

Hi All, My datastage server was preveiously pointing to a DB2 database which was installed in a separate system. Now the same database will be installed in the same machine where the datastage server is installed.Everything regarding the database will remain the same i.e database name ,database inst...

Hi, We faced following error while running a job. Join_36,5: The current soft limit on the data segment (heap) size (805306368) is less than the hard limit (2147483647), consider increasing the heap size limit Join_36,5: Current heap size: 276,559,192 bytes in 13,936 blocks Join_36,5: Failure during...

Thanks a lot .
The problem is solved

ray.wurlod wrote:The largest possible (signed) integer is 2147483647. Any decimal value coming from Oracle that is bigger than this will cause the error to be generated. You may need to use a BigInt data type. ...

Hi, We are extracting data from OLTP oracle table into Dataset. In oracle table some columns are their which are of Decimal data type. There is a transformer stage between oracle stage and dataset stage. In the transformer we are converting decimal data type to intrger data type. Though every thing ...

Hi, Previously our datastage server was accessing another db2 server. Now it will access a separete db2 database. We have user ,necessary privilleges . We are also able to connect to the new db server from our datastage server from OS level. But when we are trying to access the db2 server from DB2 e...

Hi, But I am not able to login to Dastage Director.I want to get the process id directly from operating systems from datastage director goto cleanup resources there u can get the procees ids for particular jobs.due to those ids u can kill the jobs. Hi, I want to kill all running jobs in a project. B...

Hi, I want to kill all running jobs in a project. But I am unable to login to datastage client,if any case I am able to log in and trying to abort the job the server is not responding. So I want to kill the jobs from operating system. How can I get the process Ids of running jobs. I want to go in fo...

Hi All, Can you plz explain what is repository indexing and why rebuilding of index is required? This topic I could not find in the manual.I tried to find in this forum also, but could not find the detail explanation.I need to know this because I need to reindex for a project.Plz help. Thanks in adv...

Hi, I have a project named RAS_PH1_WLESS_ADM. Whenever I am trying to log in to the project though it is opening it is showing a error: Error Calling Subroutine:DSR_EXECJOB(Action=5);check datastage is set up correctly in project RAS_PH1_WLESS_ADM (Subroutine failed to complete successfully(30107))....

Thanks a lot

Avik

ray.wurlod wrote:Enterprise Edition ...

Hi,
Will you plz tell what does EE stand for?Just to be sure about the answer.

Thanks and Regard
Avik Dasgupta

ArndW wrote:If you mean a EE Configuration file, then there is no problem at all to have the files shared across projects. ...

Hi,

Will there be any problem if one configuration file is used for multiple
projects in a single Datastage server?

Hi , Thanks for your reply. You have suggested that we can unlock all CLOSE_WAIT states logging as dsadm.Does it mean releasing all the tcp sockets in CLOSE_WAIT state? Regards Avik Definitely not the right way of restarting datastage. CLOSE_WAIT states are waiting to close. You could wait a while a...