What are the advantages of using a PACKAGE?

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

What are the advantages of using a PACKAGE?

Post by Krishna » Sun Mar 29, 2009 11:07 pm

What are the advantages of using a PACKAGE?

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Sun Mar 29, 2009 11:07 pm

1. Avoid having to bind a large number of DBRM members into a plan

2. Avoid cost of a large bind

3. Avoid the entire transaction being unavailable during bind and automatic rebind of a plan

4. Minimize fallback complexities if changes result in an error.

colakyngo
Member
Posts: 2
Joined: Sun Oct 02, 2011 6:40 pm

Post by colakyngo » Sun Oct 02, 2011 7:06 pm

Hi,

Thanks very much for this comment. It help me to think about my ideals.

Tks again and pls keep posting.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others