Can we simultaneously load a table using db2 stage in PX

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ItsVikas
Participant
Posts: 12
Joined: Tue Mar 11, 2008 3:19 am

Can we simultaneously load a table using db2 stage in PX

Post by ItsVikas »

We need to transfer a project from one server to another server.
Currently the project is in production.So we are testing that the project runs smoothly from the new server
The table is being loaded in production and it will run for hours
It is being loaded from a dataset and a db2 stage is used(append mode)
My question is that while the table is being loaded can we load the same table from another server.The job in this server is same as the production server.
Will it cause any lock.
Regards
Vikas Agarwal
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The answer is "it depends". Probably best to talk to your DBA and get their opinion on the matter.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply