Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Why more than 1 PSB??

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Thu Jul 03, 2008 6:40 pm    Post subject: Why more than 1 PSB??
Reply with quote

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
View user's profile Send private message

Bharath Nadipally

New User


Joined: 24 Jun 2008
Posts: 22
Location: Hyderabad

PostPosted: Thu Jul 03, 2008 7:50 pm    Post subject: Reply to: Why more than 1 PSB??
Reply with quote

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
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Jul 03, 2008 8:47 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Mahendran3784

New User


Joined: 04 May 2007
Posts: 20
Location: INDIA

PostPosted: Tue Jul 15, 2008 10:39 pm    Post subject:
Reply with quote

what are the expected problems of having Global PSBs for various programs?
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Jul 16, 2008 12:05 am    Post subject:
Reply with quote

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
View user's profile Send private message
Mahendran3784

New User


Joined: 04 May 2007
Posts: 20
Location: INDIA

PostPosted: Wed Jul 16, 2008 9:02 am    Post subject:
Reply with quote

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
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Jul 16, 2008 3:48 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 16, 2008 9:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:



Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us