DSXchange

Hi,
Could you please eloborate? Are you saying datastage can integrate with replication server?

Thanks
Dhiraj
P.S. we are using datastage 7.5.2 on UNIX and replication server for z/OS

Hi, we are in need to build a real time data warehouse, there are reporting requirments that need real time data (near real time would not do). The source system is on DB2 on mainframe. The existing environment captures changes occuring to the source database in real time using replication server fo...

We are facing a similar issue when we upgraded from 7.5.1 to 7.5.3. recently. There are no warnings on DS 7.5.1 but warnings produced on DS 7.5.3 while using the same code Warning: APT_CombinedOperatorController,1: Conversion error calling conversion routine date_from_string data may have been lost ...

Hi, The following is my situation I have a datastage server 7.0 running on my desktop(windows) to which couple of other users connects to. Now I also need to connect to a remote data stage server(hp unix) from my desktop through a VPN and secure shell client. Secure shell has been configured to crea...

Hi,
Is it possible to change the port on which datastage server is running?
What are the changes that i might have to do?
I am running on windows

Thanks
Dhiraj

Anto,
The DSN should be created on the server machine.
Create a system DSN on the server machine and the job should run fine.

Regards,
Dhiraj

Craig,
I am getting the same errors now. Can you let us know what was the response from Ascential?

Thanks

Dhiraj

Hello,
I have the same requirement and is clearing of the status file a safe option to do. Is there some thing that i should be aware of. Also should we clear the status file? can i not delete it?

Chris,
How much did the enhancement from ascential cost you? just curious?

Thanks
Dhiraj

Hello, Is it possible to create a secondary index on multiple columns of a hash file that was created using mkdbfile command (that is, in a directory). I have a hashed file, that has been hashed on columns A and B and has data columns C,D,E,F. Now i have a requirement to look up this hash file based...

Hello All,

Can UtilityHashLookUp be used to look up hash files that have been created by specifying a directory path?

Thanks and Regards,

Dhiraj

Thanks Tony.

I am using 7.5 so it's obvious that it is not fixed in it.
Let me trying disabling it. I may not be happy doing so though.

Regards
Dhiraj

Try increasing the parameter array size and transaction size in your target stage.

Also check if there are indexes on the target table. If so consider dropping them before the load and recreate them after the load completes.

IHTH

Dhiraj

Yes the input data is correct. The job completed successfully when i reran it using the same input datafile.

Thanks

Dhiraj

Hello, I recieved the same error today. I am running a multi instance job. And as tony pointed out , when i reran the job it went through just fine. The error message is given below. dsintbuf_getrow() - row has 369 columns when 39 expected. I am running on UNix (HP Super dome). This error occurs ran...

Looks to me that authorities for the users and groups have changed.

Datastage offers a user group based authentication. log in to administrator and check if your user group has the required permissions to edit the datastge jobs.


IHTH

Dhiraj