Hello Guru's,
Good morning. I have a tricky situation and please let me know your suggestions.
Issue: Creating/Inserting a record in a hashed file from one server to another server. Datastage is sitting on a UNIX AIX box.
I'm using and updating surrogate key in a hashed file in a QA server and I have the same hashed file in the QA1 server. QA and QA1 are in different unix boxes. My requirement is whenever there is an update in the hashed file in the QA it has to be reflected in the QA1 hashed file.
Can Datastage update/insert be done across server in diff unix boxes.
Thanks,
Saran
Inserting/Updating hashed file across diff servers
Moderators: chulett, rschirm, roy
Not that I know of. Perhaps a process to export / transport / import the hashed file contents from one server to another as a post process? I'm assuming this is about more than just simultaneous inserts but rather a need to keep them in total sync, yes?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Sure... but it doesn't change my answer that there's no way to do it that I know of. Perhaps Ray or others who are more familiar with the internals and tricky stuffs will know a way.
I think you've taken a bad path here... I would have put the key tracking up in a common database somewhere both could access.
I think you've taken a bad path here... I would have put the key tracking up in a common database somewhere both could access.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This may or may not work - I can't recall whether UV/Net functionality was incorporated into DataStage.
Try using a pathname in field 2 of the hashed file's VOC entry of the form hostname!pathname.
Try using a pathname in field 2 of the hashed file's VOC entry of the form hostname!pathname.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Inserting/Updating hashed file across diff servers
Thanks everyone. I used common unix file server for both the projects to overcome this issue.