Posted: Thu Oct 14, 2004 9:15 am Post subject: Using Same GSAM Database for 10 Jobs
Hi,
I am using GSAM files. But According to some constraints in our system, DBA has defined only 10 Databases which we need to use as GSAM databases. Let these Databases be DDB0001,DDB0002 ..... DDB0010.
In my program I need to write 4 output files. So I used DDB0001 to DDB0004.
Sample Lines of Proc for using GSAM are as follows
I am calling the above proc overriding NUMB with 1.
The job is working very fine.
Now, in production I need to run 10 jobs in parallel. (Job1 will run with NUMB as 1, Job2 will run with NUMB as 2 and so on Job10 will run with NUMB as 10). Since I am using the same DBD name for GSAM will there be any problem regarding efficiency?
PS:- Here I am using different Datasets, but DBD name is same.
Can any one advice me?
If it is a performance issue i need to ask for other DBD definitions.
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Thu Oct 14, 2004 9:33 am Post subject:
Siva,
Quote:
Now, in production I need to run 10 jobs in parallel. (Job1 will run with NUMB as 1, Job2 will run with NUMB as 2 and so on Job10 will run with NUMB as 10). Since I am using the same DBD name for GSAM will there be any problem regarding efficiency?
As long as you have different PSB's DBD name does not matter. I am guessing that you have one program and you want to run it as 10 jobs in parallel. You will need 10 psb's to do that. you cannot use the same PSB. You will not have any problem if you are invoking 10 programs with 10 different psb's with the same DBD names.
Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
Posted: Thu Oct 14, 2004 12:53 pm Post subject:
Many programs can access the same DBD at the same time. Only one can access the PSB if you are running as a BMP. If you are running DL/I, it should not matter. If you are getting data from the same database for all 10 jobs, you should seriously consider your database locking scheme (PROCOPTS, Checkpoint Frequency etc)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
