22 December 2013

IBM® Data Studio can help you manage DB2.

IBM DB2 Management Tools

DB2® provides a variety of tools that simplify the tasks that you need to do to manage DB2.

IBM Data Studio
IBM® Data Studio can help you manage DB2.

DB2 Administration Tool
The DB2 Administration Tool simplifies many of the administrative tasks that are required to maintain your DB2 subsystem.

DB2 Interactive
DB2 for z/OS® DB2 provides Interactive System Productivity Facility (ISPF) panels that you can use to perform most DB2 tasks interactively.

DB2 command line processor
You can use the command line processor to issue SQL statements, bind DBRMs that are stored in HFS files, and call stored procedures.

This blog post will deal with the IBM Data Studio tool and how it can help you create stored procedures.

IBM DB2 Data Studio

Use of DB2 Data Studio tool to create a stored procedure

Workstation-based development tools can help you create, install, and test stored procedures for DB2® for z/OS®.

Stored procedures are portable across the entire family of DB2 servers including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows. If a DB2 subsystem is configured for the creation of SQL and Java™ stored procedures, you can create these stored procedures with the tools that are available in DB2 Data Studio. These tools also provide steps for building and installing DB2 Java stored procedures on distributed systems. These tools also support read-only access to user-defined functions, triggers, tables, and views.

IBM Data Studio

IBM® Data Studio can help you manage DB2®.

IBM Data Studio is a tool that helps you perform a wide range of daily activities. You can use IBM Data Studio to manage DB2 databases on different operating systems.

You can use IBM Data Studio to administer DB2 instances, DB2 for z/OS® subsystems, databases, and database objects. You can also run utilities that reorganize or load your data in your existing DB2 for z/OS databases.

Working with stored procedures

You can use the workbench to create, test, and deploy stored procedures. You can also debug stored procedures.

Stored procedures contain procedural constructs with SQL statements. Stored procedures are stored in databases and run on servers. An application can call a stored procedure by name and run the SQL statements that are included in the stored procedure. The application can be on the client, while the stored procedure executes its logic on the server. Stored procedures and user-defined functions are sometimes referred to collectively as routines.

  • Before you create stored procedures, you must complete some setup steps.
  • Stored procedure development is not supported for every available data source.
  • To create stored procedures, you must have the required authorities and privileges. 

Creating stored procedures

You can create a stored procedure from the Data Project Explorer, either from a data development project, or by using the toolbar buttons. You can also create a stored procedure from a database connection in the Data Source Explorer view or Administration Explorer view.

Developing DB2 for z/OS stored procedures

There are some stored procedure features in the workbench that are designed specifically for DB2 for z/OS® stored procedures. In addition, there are some setup steps that you should complete.

Here is a webinar about this subject that you can watch at your convenience:



If you do not have enough time to watch the whole webinar, here is the presentation of the webinar:


How to migrate to DB@ Data Studio: How do I migrate to DB@ Data Studio

For more detailed information on IBM DB2 Data Studio take a look at:

IBM DB2 Data Studio product page: IBM DB2 Data Studio Product Page

What is new in IBM DB2 Data Studio: What is new in IBM Data Studio

IBM DB2 Data Studio Info Center: IBM DB2 Data Studio Information Center

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

0 reacties:

Post a Comment