MVSFORUMS.com

[pkarthik@email.com]

In VSAM we know If a file is acessed in DISP=SHR same file can be used simultaneously by many JCLS and Programs.Can any one can let me know is there any limit for this.i.e No of pgms or Jcls that can access a same file.
Simultaneously to how much extent a DB2 table can be acessed by different programs
_________________
For any type of complex problems there will be multiple easiest solutions

[Phantom]

Pkarthik,

There is no-limit for concurrent READs unless some job is going to update the contents of VSAM/DB2.

Thanks,
Phantom

[Manas Biswal]

pkarthik@email.com,

For DB2, there is no single figure 'X' that can access a DB2 tablespace at a time. It depends on a lot of factors, parameters and configuration settings. It's too complicated to explain everything as a post here. I would suggest you do a simple google search on the following topics and try to understand. Let me know if you have doubts on any particular topic and I will be glad to explain further.
DB2 on S/390 -
Tablespace parameters - LOCKSIZE, LOCKMAX
DSNZPARM Parameters - NUMLKTS, NUMLKUS

DB2 UDB on Win -
DB CFG Parameters - LOCKLIST, MAXLOCKS

HTH...Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)