Previous Topic: DB2 Package Library Code Set-up FormNext Topic: User Exits

Forms › CA-PanAPT Forms › CA-PanAPT DB2 Option Forms › DB2 Plan Library Code Set-up Form

DB2 Plan Library Code Set-up Form

DB2 PLAN LIBRARY CODE SET-UP FORM (Page 1 of 6)
 
This form helps you to determine which characteristics to give each Library Code. Make one copy of all six pages of this form for each Library Code and an additional copy of page 5 for each Move level defined to your system beyond the starting point test level. View the information on this form using reports APCS5102-01 and APCS5102-02


Library Code:  __ __ __ __ / __ __ __


Description:   ______________________                                                                    	


DB2 Type:   PLAN


From/To names  may / must / may not be equal. (Circle one.)
 

Lengths allowed (1-8):              Minimum: ____        Maximum: ____


User-data lengths (0-8):  From data Minimum: ____        Maximum: ____


                            To data Minimum: ____        Maximum: ____



DB2 PLAN LIBRARY CODE SET-UP FORM (Page 2 of 6)
 

Inventory Processing Options:
 

	Inventory enabled?  . . . . . . . . . . . . . . . . . . . . . . . . . yes   no


	Inventory Qualifier:  ____________


	Auto create at assignment time: . . . . . . . . . . . . . . . . . . . yes   no


	Auto approve at creation? . . . . . . . . . . . . . . . . . . . . . . yes   no


	Require approved inventory records? . . . . . . . . . . . . . . . . . yes   no


	Edit exit program:  _______________________   parameter:  _____________________



Assignment Processing Options:
 

	Assignment enabled? . . . . . . . . . . . . . . . . . . . . . . . . . yes   no


	Auto Assignment with Move Request?  . . . . . . . . . . . . . . . . . yes   no


	Auto Release at Prod move time? . . . . . . . . . . . . . . . . . . . yes   no


	Retrieve enabled? . . . . . . . . . . . . . . . . . . . . . . . . . . yes   no


	Auto Retrieve at assignment . . . . . . . . . . . . . . . . . . . . . yes   no

DB2 PLAN LIBRARY CODE SET-UP FORM (Page 3 of 6)
 
Inventory Defaults:
 
	Owned by:____________________________________________
 
	Description:______________________________________________________________
 
	Comments:_________________________________________________________________
 
	Environment:__________________________________________
 
	Application:__________________________________________
 
	Language:_____________________________________________
 
	Compiler Options:__________________________________________________________
 
	Link Edit Options:_________________________________________________________
 
	User0001:________________   User0006:________________
 
	User0002:________________   User0007:________________
 
	User0003:________________   User0008:________________
 
	User0004:________________   User0009:________________
 
	User0005:________________   User0010:________________
 
	User0011:__________________________________________________________________
 
	User0012:__________________________________________________________________
 
	User0013:__________________________________________________________________
 
	User0014:__________________________________________________________________
 
	User0015:__________________________________________________________________
 
	User0016:__________________________________________________________________
 
	User0017:__________________________________________________________________
 
	User0018:__________________________________________________________________
 
	User0019:__________________________________________________________________
 
	User0020:__________________________________________________________________
 



DB2 PLAN LIBRARY CODE SET-UP FORM (Page 4 of 6)
 
Starting Test Level Details


DB2 Subsystem ID (1‑4 characters):________
 

DB2 Owner (1‑8 characters):________________
 

DB2 Qualifier (1‑8 characters):________________
 

Security (typically blank):________________
 

Access Method (0‑2 characters, typically blank):____
 

Member existence exit: (Circle one)	APCS0225   or   None


Member existence exit parm: (Circle one)	APCS0225   or   ________________


Member Select List exit: (typically blank):________________
 

Member Select List exit parm (typically blank):____________________________________
 

Verifications required before Close (Circle as many as desired):
 
	1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20
DB2 PLAN LIBRARY CODE SET-UP FORM (Page 5 of 6)
 
Make as many copies of this page as you have target move levels in your system.
 
Destination _____ Level Details


Target:
    Subsystem ID (1‑4 characters):________
 
    Owner (1‑8 characters):________________
 
    Qualifier (1‑8 characters):________________
 
    Security (typically blank):________________
 
    Access Method (0‑2 characters, typically blank):  ____


Move Control:	Copy


Backout Control (Circle one):	Restore without backout   /   Prohibited


Member existence exit: (Circle one)	APCS0225   or   None


Member existence exit parm: (Circle one)	APCS0225   or   ________________


Member Select List exit: (typically blank):________________
 

Member Select List exit parm (typically blank):____________________________________
 

Verifications required before Move (Circle as many as desired):
 
	1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20


Approvals required before Move (Circle as many as desired):
 
	1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20


Approvals required before Backout (Circle as many as desired):
 
	1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20

DB2 PLAN LIBRARY CODE SET-UP FORM (Page 6 of 6)
 

Modeling

Model Base (1 to 4 characters):  ________ 
(The Model Base controls the order in which Library Codes are presented to Move Modeling. If this is not important, leave it blank and it will default).
 
Move Model Specification(s):
 
______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________


Retrieve Model Specification(s):
 
______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________

______________________________________________________________________________________