DSXchange

Yes, password was same for both.

ray.wurlod wrote:Look in the job logs - job starting event - for the successful and failed attempts. Is the password, as encrypted, the same for both? ...

Our DBA increased the number of concurrent connections from datastage to database 100 to 200. That solved the problem. So I am marking this post as resolved.

ray.wurlod wrote:Look in the job logs - job starting event - for the successful and failed attempts. Is the password, as encrypted, the same for both? ...

it should be easy for your DBA to find out the difference between dev and test box. Involve him. Hi Priya, So far I am thinking it may be the limited number of connection issues from datastage to database. Currently, Dev and Test both have same number of connections. I already requested our DBA to ...

Hi Nitin, We are using parameter sets, so username/password is not an issue. Thanks. Hello, When I run my sequence in Dev Environment it's running fine. But, when I run in Test Environment sequence aborted. When I run the job individually in test, that runs successfully. Following error I am getting...

Hello, When I run my sequence in Dev Environment it's running fine. But, when I run in Test Environment sequence aborted. When I run the job individually in test, that runs successfully. Following error I am getting: ORA-12537: TNS:connection closed Connect failed: ORA-12537: TNS:connection closed A...

Your question is very vague. If you want to know either SCD stage supports both type 1 and type 2, then the answer is yes.

Thanks

If you define schema at User defined variable section in DataStage Admin, schema will become $schema.

Thanks

#test.schema# schema should start with $. So that could look like:
#test.$schema#

Thanks

Ray, I used TO_CHAR function in Oracle Enterprise stage successfully. Though TO_CHAR is not a datastage function, we can safely use it in Oracle Enterprise Stage.

Thanks Ray for your valuable opinion. Please correct me if I am wrong. Sort stage stores all data to memory space and then sorts. The most expensive part of the sort stage is storing data into memory space. Once all data is in the memory space, sorting operation does not take that much time compared...

I don't think so. Unless you need case-insensitive, you may keep that option.

Thanks

Contract with IBM customer service, they will be happy to give all information. Once you buy the license, you may download everything from IBM website.

Thanks

Remove the unnecessary columns from the source sides.

Thanks

Create tab delimited sequential file, and make data type varchar.

Thanks

This is happening because you are trying to load null value in primary key column field. You have to either remove the those null value rows or change that primary key constraint and made that field nullable.

Thanks