| IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...
Help & Support Forums for IBM Mainframe computers Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7, CA-11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, VSAM, ISPF, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
ap_mainframes
Joined: 29 Dec 2005
Posts: 137
Location: Canada
|
| Posted: Thu Jul 03, 2008 6:40 pm Post subject: Why more than 1 PSB?? |
|
|
Hi,
Can anybody explain why and when we would need to create more than one PSB for a DB ??
Thanks,
ap_mainframes |
|
| Back to top |
|
Bharath Nadipally
Joined: 24 Jun 2008
Posts: 20
Location: Hyderabad
|
| Posted: Thu Jul 03, 2008 7:50 pm Post subject: Reply to: Why more than 1 PSB?? |
|
|
| PSB is a logical collection of databases which an application(program) will use. A database(or segments) can be used by n number of programs, so a database can be used by n number of PSB's. |
|
| Back to top |
|
Sandy Zimmer
Joined: 13 Jun 2007
Posts: 419
Location: Wilmington, DE
|
| Posted: Thu Jul 03, 2008 8:47 pm Post subject: |
|
|
| Expanding on what Bharath had to say. Most shop standards dictate that each application program have their very own PSB - unique to what that application will be doing. The PSB should also have the same name as the program. Global PSBs are NOT a good idea at all! |
|
| Back to top |
|
Mahendran3784
Joined: 04 May 2007
Posts: 12
Location: INDIA
|
| Posted: Tue Jul 15, 2008 10:39 pm Post subject: |
|
|
| what are the expected problems of having Global PSBs for various programs? |
|
| Back to top |
|
Sandy Zimmer
Joined: 13 Jun 2007
Posts: 419
Location: Wilmington, DE
|
| Posted: Wed Jul 16, 2008 12:05 am Post subject: |
|
|
| Well, CONTENTION for number 1. Why should an application that only needs 1 database use a PSB accessing 20? A PSB that gets STOPPED for any reason will impact a multitude of application. As I've said, most fast transaction processing installations INSIST that a PSB be unique to a particular program. |
|
| Back to top |
|
Mahendran3784
Joined: 04 May 2007
Posts: 12
Location: INDIA
|
| Posted: Wed Jul 16, 2008 9:02 am Post subject: |
|
|
Thanks Sandy.
Is it that contention of DBs used in the PSB? And what are the scenarios a PSB get STOPPED?
- Mahendran[/quote] |
|
| Back to top |
|
Sandy Zimmer
Joined: 13 Jun 2007
Posts: 419
Location: Wilmington, DE
|
| Posted: Wed Jul 16, 2008 3:48 pm Post subject: |
|
|
| Normally a PSB gets stopped when there is an abend. Please just think this thru - 1 PSB per program. Think about how easy this is. Aside from the contention issues, etc, your linkage and entry statements will only contain the databases that you need. A PSB is a program specification block - exactly that - it is not based on a particular database. It is based on an application. |
|
| Back to top |
|
dick scherrer
Joined: 23 Nov 2006
Posts: 8022
Location: 221 B Baker St
|
| Posted: Wed Jul 16, 2008 9:19 pm Post subject: |
|
|
Hello,
A single psb per program will also reduce resources needed for execution of each program.
Another place a single psb per program can help is impact analysis.
FWIW. . . |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|