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
 

 

Naming standard for db2 collections

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jerryte

Active User


Joined: 29 Oct 2010
Posts: 183
Location: Toronto, ON, Canada

PostPosted: Fri Oct 21, 2011 6:43 pm    Post subject: Naming standard for db2 collections
Reply with quote

I am in the process of converting plan-dbrm binds into package-dbrm binds. This is required for upgrade to version 10. To do this I have to setup some new collections. I would like to hear from others if they follow a naming standard for their db2 collections.

I was thinking of using a name that consists of the table creator id followed by a string that indicates the level of the program ie. development, QA test, or production. That way I know which database the packages will access. It also allows us to have 3 versions of a program. (note: we are not using package versioning at this time).

Please share your thoughts or ideas.
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1753
Location: Bloomington, IL

PostPosted: Fri Oct 21, 2011 7:15 pm    Post subject:
Reply with quote

Our development, system test, and production systems are on different sysplexes. On our development sysplex (which spend 99.9% of my time logged into, and on which 99% of my code is used -- I am a Tool(TM) Developer icon_wink.gif -- we have a generic production collection and regional office collections (because each regional office has its own LPAR and DB2 subsystem). When a developer is going to unit test a change, he will create the necessary objects and bind the necessary packages into his own collection (name = primary authid), and then create a plan from his collection, the regional collection, and the generic collection, in that order (all this will usually be done with my team's tools; the developer may not actually know how to write DDL or JCL).

This, of course, may be completely unsuitable to your needs icon_smile.gif
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Plan, Package and collections. shankarm DB2 1 Fri Jan 23, 2015 1:50 pm
This topic is locked: you cannot edit posts or make replies. Get latest file with specific naming ... JAYESHBALAN JCL & VSAM 1 Thu Jun 13, 2013 8:55 pm
No new posts character limit in file naming jayy_mr All Other Mainframe Topics 6 Thu May 16, 2013 10:22 pm
No new posts Copy variable length input file to a ... santoshks0611 DFSORT/ICETOOL 7 Fri Apr 19, 2013 10:33 am
No new posts File Naming Ed Goodman JCL & VSAM 11 Fri Apr 13, 2012 2:19 pm


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