DSXchange

Hi, I'm having very strange situation. The job status in Datastage Director indicatd the job is still running, but when I asked Datastage Administrator, he told me he did not see anything running at all. I tried to stop the job, it does not work, and Clear Status File Menu is grayed out. When I use ...

Hi, I have a very strange problem. After change uvtemp parameter in uvconfig, the datastage service is recycled, then, I found out I was not able to log in to datastage (director, manager etc.) with my original account. The message I got is like 'Failed to connect to host: fosentsvr02, proect PROD_G...

Sorry, I should have provided more details. I used datastage director to schedule the job, and I keep all parameter values as default. The problems I' m having are 1. value of paramter which has single quotation. The default is '0', but when the job gets run, it stripped the the quotation, the value...

Hi, I'm having a very strange problem regarding to scheduled job. In the scheduling, I specified the correct values for parameters. ( I already verified in the schedule) But when the job gets running, it keeps picking wrong values. Couldn't figure out why? Has anybody experienced same situations? Ho...

djhigh wrote:This could be due to Operating System restrictions. What OS is on the server? Is Datastage on the same server as DB2?

DB2 and Datastage are installed on different servers. The OS is AIX 5.1 and 5.2

Hi, I have a DB2 table, one field in this table is double type. When I dumped this table into file through datastage, it seems it loses precision. For example: a value '3.29999995231628' becomes '3.299999952', even though the column definition is specified as double. Has anyone evern experienced sam...

Hi, I have a very strange error happening during my job execution. The error message is look like this: DataStage Job 2157 Phantom 24831 Unable to open "/dstemp/capture57472aa" file. Attempting to Cleanup after ABORT raised in stage I had similar problem before, and I increased uvtemp dire...

Hi Kim,

I'm not quite familiar with the command you were using. Can you tell me where I can get this kind of refernece marterial for those commands?

Regards,

Carol

Thanks a lot for your quick response.

I'm little bit confused about your solution. Shall I ran those query in Administrator/command window? What does @Record mean?

It there any manuals about those System tables such as DS_JOBS etc? I could find it in Admistrator Guide.

Thanks again.

Carol

Hi, I have this headache problem. We're in the process of promoting our DS Jobs to production, but we found out there are lots of messy jobs in the project. Those are the test jobs created by developer during their development and tesing. Some jobs do not have very good naming standards, by looking ...

Hi, I had a very strange problem. We had a project created on production box, today, we want to do add some changes. But we could not access this project any more. The message stated sth. like 'The directory is not a valid uv account or the directory does not exist'. But when we tried to create this...

Hi, I want to get some input regarding to version control? If you have mutiple developers in one team, how do you control the same job would not be editted by mutiple developers at the same time. Does Asentail provide its own version control? Or do you use third-party product? Any recommendations? T...

Hi, I have a very strange problem. I have a BCP job which loads 3 million records from SQL Server to DB2. The first time it ran, it took less than 2 hours to finish. The second time, it hangs there for almost 6 hours, there is no activity going on SQL side or DB2 side, and there is no output file ge...

Hi, We're are in the middle process of moving to produciton. One of task is to prepare disaster recovery plan. I am wondering how to backup and hash files in case there is a problem with server? Is it enough to backup the folder which stores hash file? Or we have to use different mechanism? thanks a...

Hi, I have a problem regarding to DB2 table name. Initially, when we deleveloped datastage jobs, we did not put schema name in front of table name, and the user we used to access this table is the owner of this table, so we did not experience any problems. Now our new hired DBA suggested us that we ...