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
 

 

Endevor and DB2

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

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Nov 27, 2009 4:13 pm    Post subject: Endevor and DB2
Reply with quote

Hi,

We are planning in the mode for installing ENDEVOR scm, my doubt here is, Is there a need for a separate database for each stage for each system.

Code:

ENDEVOR stage   DEVP      ACPT      QUAL      PROD   
SSID            DB2D      DB2M      DB2M      DB2P   
PLAN/COLLECTION CLIPLANP  CLIACPTP  CLIPLANP  CLIPLANP
Database        CLIDDATP  CLIDACPT  CLIDDATP  CLIDDATP


The ACPT & QUAL stage both are in same subsystem. So, is there a need to create a new database for ACTP stage alone. Currently we have all the objects that is used for QUAL.

Because i don't see a need to creating a new databases. Databases are going to be containing data, the process is about moving sources from one stage to another. It has nothing to do with data.

I am getting ideas like may be a separate new PLAN would work.

Can someone enlight me on this ? So, far i haven't used ENDEVOR ?

Thank You,
Sushanth
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Fri Nov 27, 2009 4:21 pm    Post subject: Reply to: Endevor and DB2
Reply with quote

Quote:
the process is about moving sources from one stage to another.


It depends what You mean by stage...

if by stage You mean level/hierarchy in the development process,
the answer would be a big YES...

at any development level/hierarchy the proper tests should be carried on with the proper data at the proper level

having the same data for different levels will sooner or later yield undesirable results
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Nov 27, 2009 4:35 pm    Post subject:
Reply with quote

Thank You Very Much Enrico,

I meant stage as DEV --> ACPT --> QUAL --> PROD.

Sources i meant as source code, loads, compile listings & DBRM.

Sushanth
Back to top
View user's profile Send private message
kgrimes

New User


Joined: 28 Sep 2009
Posts: 22
Location: Columbia, SC

PostPosted: Mon Nov 30, 2009 8:53 pm    Post subject: Reply to: Endevor and DB2
Reply with quote

Hi Sushanth,

Most Endevor shops handle this situation by varying the DB2 QUALIFIER for each stage of the Endevor life cycle. So that each stage of the Endevor life cycle would point to a different occurrence within the same DB2 database where ever you wish to share databases. Each stage would have it's own set of output libraries such as loadlib, dbrmlib, jcllib, etc. and the Endevor processors bind the DBRM to the correct QUALIFIER for each stage.

Kevin
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Nov 30, 2009 9:20 pm    Post subject:
Reply with quote

Thanks kgrimes,

Can i know what are inputs that endevor will ask when you want to compile & link-edit a DB2 program. Like SYSTEM, SUBSYSTEM, ELEMENT name, ENVIRONMENT, STAGE, DB2 QUALIFIER, COLLECTION.... is there anything like this endevor will ask as an input from the programmer.

Since i haven't seen the endevor screen, i have no idea what are the inputs it will ask.


Sushanth
Back to top
View user's profile Send private message
kgrimes

New User


Joined: 28 Sep 2009
Posts: 22
Location: Columbia, SC

PostPosted: Mon Nov 30, 2009 10:05 pm    Post subject: Reply to: Endevor and DB2
Reply with quote

Hi Sushanth,

Generally speaking, it is not a good idea to ask the programmers for anything that controls the configuration management or change management processes. You should define a consistent and repeatable process. In fact, most compliance programs require it.

Therefore, all required parameters should come from (or be derived from) the Endevor configuration where ever possible. (It is almost always possible if you really try.)

Endevor processor groups are normally used to define all the parameters required for any compile, link, and bind process.

However, it is also possible that the Endevor processors could dynamically create any required parameters based on the inventory classification (System, Subsystem, Type) and location (Environment and Stage).

Regardless of the tools used to manage source code and the change management process, there are many complexities with properly managing DB2 code. If you are not an Endevor Administrator and you have not even seen an Endevor screen, then you should definitely seek assistance from a qualified Endevor consultant who has a successful track record of Endevor implementations that include DB2.

As a Senior Endevor Consultant with 17 years of Endevor Administration experience, I'm available to help my clients plan, design, configure, and implement Endevor to support DB2 processing.

Regards,
Kevin
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Nov 30, 2009 11:31 pm    Post subject:
Reply with quote

Hi Kgrimes,

Quote:
Generally speaking, it is not a good idea to ask the programmers for anything that controls the configuration management or change management processes.

I agree to that.

Quote:
Endevor processor groups are normally used to define all the parameters required for any compile, link, and bind process.

However, it is also possible that the Endevor processors could dynamically create any required parameters based on the inventory classification (System, Subsystem, Type) and location (Environment and Stage).

For Endevor processor group to define all the parameters. I was asked to supply the BIND parameters, since i am one of the member of DB2 group in my project.

Thank You,
Sushanth
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Tue Dec 01, 2009 12:11 am    Post subject: Reply to: Endevor and DB2
Reply with quote

the bind parameters should not change across different db2 instances

the only thing to be changed would be the subsystem name, should not be an issue

build the bind command for each stage/level/db2_environment and let the endevor support integrate them .
Back to top
View user's profile Send private message
kgrimes

New User


Joined: 28 Sep 2009
Posts: 22
Location: Columbia, SC

PostPosted: Tue Dec 01, 2009 3:05 am    Post subject: Reply to: Endevor and DB2
Reply with quote

The DB2 bind parameters may or may not change for each stage of the Endevor life cycle depending on your site standards and configuration. The parameters that are most likely to change include: the DB2 subsystem name, OWNER, QUALIFIER, and EXPLAIN.
Back to top
View user's profile Send private message
kgrimes

New User


Joined: 28 Sep 2009
Posts: 22
Location: Columbia, SC

PostPosted: Tue Dec 01, 2009 3:11 am    Post subject: Reply to: Endevor and DB2
Reply with quote

Sorry, the list of parameters that are most likely to change should also include the DB2 Collection if you are using DB2 packages.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Dec 01, 2009 11:32 am    Post subject:
Reply with quote

Thank You Very Much ENRICO & KGRIMES
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 CA-Endevor Admin - 3 years minimum vasanthz Mainframe Jobs 0 Tue Apr 04, 2017 5:36 am
No new posts Endevor error C1UU999E during cast Musab Ahmed CA Products 3 Wed Jun 29, 2016 12:41 pm
No new posts SE37 while adding element to endevor kalyan.v CA Products 5 Mon Apr 25, 2016 6:05 pm
No new posts Endevor Error mahi CA Products 3 Sun Mar 20, 2016 4:08 pm
No new posts New PROC not reflecting in prod even ... Musab Ahmed CA Products 9 Tue Mar 15, 2016 12:45 pm


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