DSXchange

Hi Friends, We have datastage installed in one server LPAR and db2 istalled in another LPAR in a Unix pseries machine. this is our production environment. The Jobs which used to run with over 7000 rows/sec speed now have slowed dowm to 1- 100 rows/sec, all of a sudden. There is no space issue in the...

hi,

I am not able to use any buttons. they have been disabled .
Activities like rating the posts, using emoticans, marking the post as resolved, or moving to next page of posts are also not possible.

*Note: Topic Relocated - Content Editor*

hi friends,

Even after the jobs are stopped the query executed by the jobs
carry on and utilize CPU resources. Any option in Datastge to ensure all the processes end when jobs are stopped?

Hi All, The problem is resolved. i found out that there was a file inpdata.dat in the directory for data and command files . the job was failing because of this file. when i deleted then the bulk load job ran fine. Though the problem is resolved can anyone tell me how this inpdata.dat file is create...

Hi,

Please help me to solve this problem as this has become very critical.
Even after changing the directory for 'data and command files'.

is it datastage problem or OS problem? the folder is having privileges to the user running the jobs and also enough space is allocated to this.

hi Thanks Ray,

thats right. actually files were not changed properly. the datastage was not recognizing these files after changes had been done. now its working fine.

Hi all,

i need information on premium membership other than that is availabl on DSXchange. i mailed to membership.director@dsxchange.com. but got no responce. give me a faster medium where i can ask questions on mode of payments to DSXchange.

Waiting for response.

Hi,

Sorry for the Confusion
Actually the job runs fine if the directory is changed.
You may be right. i'll try to find what is the problem with the old directory and reply back.

hi Friends, We have shifted our datastage jobs to a different server where a new project is created. i have created all the SQl DSNs that were present in the old server in the new server by editing uvodbc.config and odbc.ini files. but the jobs are failig giving the following error : Load_Ora_Opmet...

Hi,

I am using stage DB2_UDB load. We can run the job if the directory for

data and command files is changed. the folders have full privileges.

but still the error exists.

Hi Friends, i am getting following error: Load_PA0000..TgtPA0000Tbl: Invalid pointer to stage user data Internal Error: Function 'get_stage_prop' failed Error opening file in 'Directory for Data and Command Files' this is a bulk load job. can somebody tell me what can be the reason ans solution? Sea...

hi ,

Is there any way to change the NLS settings of all the jobs in a project from Default(NONE) to NONE at once?
Presently i have to go to each job manually and make the changes.

HI, i have set the NLS settings for a project as NONE. when i see the NLS settings in all the job it shows project default(none) selected by default. but the job fails to run with this default settings. But the jobs run fine when i change the NLS settings from Project Default(none) to NONE. What can...

hi Good day ,

i am migrating the job categories using DS Version Control component.
there is no problem while migrating the jobs using DS Manager -> export and import options. but this problem arises when i use Version control.

hi, i get the following error when i try access data from a table in the orale database using oracle oci stage: Job_Exception_Report..Tbl_Exception_Tbl: ORA-00936: missing expression Job_Exception_Report..Tbl_Exception_Tbl.DSLink1: DSP.Open GCI $DSP.Open error -100. but when i run this query in sqlp...