IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to setup DB2 development environment?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Mon May 23, 2011 9:07 pm
Reply with quote

In my shop, DB2 has been installed, but some preparations are needed before application can run smoothly.

So, can anybody please give me a guide on how to setup the environment for DB2 application?
I will apprecaite it very much if you can provide me some redbook or material on this.


THanks in advance.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon May 23, 2011 9:14 pm
Reply with quote

is this the first db2 installation in that shop ?

the whole shebang for establishing a development environment
is not something people will be happy to share with You on a forum,
for two main reasons
the complexity of the task
the work done by each one of us to acquire that knowledge
and ...
setting up a complete and well oiled development environment is a task for an hefty consulting contract
BTDTGTTS ( did not get the tee shirt/the money, just a silver plate )

also the title does not completely agree with
Quote:
... but some preparations are needed before application can run smoothly.


whatever <thing/environment> will be used, having applications run smoothly needs preparation and planning

some question to ask

what change management tool will be used
what will be the promotion and deployment process
how will the production data be processed to get the test data
( f the customer is a financial institution and maybe anyway , all the data except the one used for system certification must be obfuscated )

and so on and so on ...
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Mon May 23, 2011 9:34 pm
Reply with quote

Hello,

Quote:
but some preparations are needed before application can run smoothly.

There is no book or manual that will tell you how to configure for smoothly. Also, this is ongoing. As discoveries are made, adjustments will have to be made.

As you have been told many, many times, your organization needs an experienced DB2 dba. . .
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Tue May 24, 2011 6:26 am
Reply with quote

hi, dick,

I am trying to play the DBA's role. As the company cannot offer too much salary, no DBA will come. If I can get the task done, the company no longer need to hire a new DBA, which is a great save of budget.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue May 24, 2011 7:59 am
Reply with quote

Hello,

Quote:
I am trying to play the DBA's role.
Yes, several of us are quite aware of this.

Quote:
As the company cannot offer too much salary,
Nonsense. . . If the company wants a reasonable implementation they will pay to build and support it.

Quote:
If I can get the task done, the company no longer need to hire a new DBA, which is a great save of budget.
Look at how long this has been going on and "the company" has not even provided proper dba training. There is no "great saving" if the environment will not support the needed processing. . .
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue May 24, 2011 12:13 pm
Reply with quote

A good dba is worth every penny icon_smile.gif
Without our team, this company would consume at least 20% more MSU.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


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

PostPosted: Tue May 24, 2011 3:32 pm
Reply with quote

dejunzhu wrote:
I am trying to play the DBA's role. As the company cannot offer too much salary, no DBA will come. If I can get the task done, the company no longer need to hire a new DBA, which is a great save of budget.

That is an excellent summary of everything wrong with outsourcing.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Tue May 24, 2011 7:37 pm
Reply with quote

IBM has installation manuals that come with each software release and the installation manuals are excellent guidelines as to how to set up the software environment. If you cannot find the DB2 installation manual for your site, then you're probably going to be out of luck as far as setting up an environment -- unless you can hire a consultant.

There are times when paying the cost for consultants is vastly cost effective. The situation you are describing sounds like one of those.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Wed May 25, 2011 6:59 am
Reply with quote

hi, enrico,

thanks for your kind reply.

enrico-sorichetti wrote:
is this the first db2 installation in that shop ?


Yes, it is.

enrico-sorichetti wrote:
what change management tool will be used
what will be the promotion and deployment process

We are planning to buy Changeman, and the promotion/deployment process will be implemented by changeman.

enrico-sorichetti wrote:
how will the production data be processed to get the test data

we have not decided it yet. Hope you can provide me some valuable suggestions according to your experience.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Wed May 25, 2011 7:58 am
Reply with quote

If you cannot provide me some guide or sample proposal, then please just give me some considering points on this.
thanks.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Wed May 25, 2011 8:03 am
Reply with quote

Robert Sample wrote:
IBM has installation manuals that come with each software release and the installation manuals are excellent guidelines as to how to set up the software environment. If you cannot find the DB2 installation manual for your site, then you're probably going to be out of luck as far as setting up an environment -- unless you can hire a consultant.

There are times when paying the cost for consultants is vastly cost effective. The situation you are describing sounds like one of those.

hi, Robert,
Thanks for your suggestion.

I've scanned the DB2 installation guide, it seems that the guide just provides the process of installing DB2.
Now, DB2 has been installed in our shop,what I need to do is just establishing the DB2 environment for applications.

Unfortunately, perhaps my boss has no intention to hire a consultant.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed May 25, 2011 8:12 am
Reply with quote

Hello,

Quote:
I've scanned the DB2 installation guide, it seems that the guide just provides the process of installing DB2.
Why would anyone expect the installation manual to do something else?
Quote:
Now, DB2 has been installed in our shop,
If the "installers" were not people who knew how to install/configure db2, it may have to be re-installed. . .

The same concerns exist for Changeman. Whoever installs and supports Changeman (or Endevor or any other such product) needs to understand configuration management and how they intend to manage this environment. . .
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed May 25, 2011 11:35 am
Reply with quote

again a forum is not the place for a long term questions and answers sessions !
( AKA consultancy icon_biggrin.gif )

establishing a proper Development environment and provide for smooth processing is not related just to DB2
it the 90% of the technicalities involved when starting a software develpment company icon_biggrin.gif

meditate on Your organization intellectual/organizational/financial/... capabilities/resources
for tackling complex projects, which given the premises are unfortunately bound to fail or at least be very painful

and beware about the personal career issues in being involved in such activities

I am worried about Your poor understanding of things
when I asked
Quote:
what will be the promotion and deployment process

You gave the simplycistic reply ... changeman
that' not the reply that would be expected from an IT professional

changeman is not a process ... is the low level tool
did You consider the administrative issues
- setting the standards
- auditing the results
- quality control
- ....
- who does what ( people ... people )

and if Your organization is tight on money why waste it on buying a change management tool.

SCLM is there is free and if properly I mean properly customized it will provide the most cost effective solution
and I can tell that from experience

the bad impact You had from SCLM was not SCLM fault ... meditate on it

also consider that long range projects need a continuos and consistent feed of information ( and You cannot expect that on a forum ) and unified approach , not a speckled one

As usually You did not completely understand my initial answer

remember answering is
ON OUR OWN TIME
FREE OF CHARGE

and to give proper answers to issues like this one
PUTS TOO MUCH STRAIN ON OUR RESOURCES,

and please, please no whining icon_evil.gif

this is a mild form of cease and desist, no reason to whack bushes for nothing
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Need COBOL COPY Help in MVS Environment COBOL Programming 4
No new posts COBOL400 SET ENVIRONMENT COBOL Programming 1
No new posts CICS / JAVA - Setup of definitions CICS 0
No new posts How to setup MQ panel TSO/ISPF 3
No new posts TSO initial setup / problems TSO/ISPF 9
Search our Forums:

Back to Top