Invite Friends to Join You!

Only available on StudyMode
  • Topic: IBM, IBM DB2, Linux
  • Pages : 12 (1946 words )
  • Download(s) : 212
  • Published : February 13, 2013
Open Document
Text Preview
Getting started with Data Studio
IBM Information Management – Cloud Computing Center of Competence IBM Canada Labs 1
© 2011 IBM Corporation

1

Agenda
■ ■ ■ ■ ■

DB2 tools general overview Data Studio overview Touring the workbench (demo) Managing connections (demo) Working with SQL and SQL scripts (demo)

05/24/2011
2

Template Documentation
© 2011 IBM Corporation

2

Supporting reading material & videos
• Reading materials • Getting started with IBM Data Studio for DB2 eBook • Chapter 1: Overview and installation • Chapter 2: Managing your database environment • Chapter 3, section 3.2.1: Creating table spaces

• Videos • db2university.com course AA001EN
• Lesson 3: Getting started with Data Studio

05/24/2011
3

Template Documentation
© 2011 IBM Corporation

3

Agenda
■ ■ ■ ■ ■

DB2 tools general overview Data Studio overview Touring the workbench (demo) Managing connections (demo) Working with SQL and SQL scripts (demo)

05/24/2011
4

Template Documentation
© 2011 IBM Corporation

4

DB2 tools

Most of these tools are now deprecated in favor of IBM Data Studio 05/24/2011
5

Template Documentation
© 2011 IBM Corporation

This figure shows all the tools that come with DB2. The same tools (except the Command Window) are available in Linux and Windows. As shown in the chart, most of these tools will not be enhanced in the future and will eventually disappear in favor of IBM Data Studio. The Command Line Processor and First Steps tools are likely to remain.

5

Agenda
■ ■ ■ ■ ■

DB2 tools general overview Data Studio overview Touring the workbench (demo) Managing connections (demo) Working with SQL and SQL scripts (demo)

05/24/2011
6

Template Documentation
© 2011 IBM Corporation

6

What is IBM Data Studio?
• Free tool for database administration and database development • Based on Eclipse • Can work with: • DB2 for Linux, UNIX, or Windows • DB2 for iSeries • DB2 for z/OS • Informix Dynamic Server

7

© 2011 IBM Corporation

IBM Data Studio is a FREE tool for database administration and development. The latest version is 2.2.1. It is based on Eclipse 3.4.2 and can work with: • • • • DB2 for Linux, UNIX, or Windows (DB2 LUW) DB2 for iSeries DB2 for z/OS and Informix Dynamic Server

Note that though Data Studio is based on Eclipse and it's free, it is NOT open source.

7

Related products

InfoSphere Data Architect Optim Database Administrator (ODA)** Optim Development Studio (ODS)** Optim Query Tuner Optim Performance Manager Data Studio ** Optim Database Administrator and Optim Development Studio are now included with most priced DB2 Editions 8

© 2011 IBM Corporation

There are several fee-based products related to IBM Data Studio, most are Eclipsebased. We have, for example, InfoSphere Data Architect (IDA) which provides a complete solution for database design.Data Studio has a limit set of features from IDA, like the one to graph relationships between tables. Then we have Optim Database Administrator (ODA). ODA provides a complete solution for database administration. Data Studio has most of the features available with ODA except "Change Management". Change Management is useful when your database structure needs to be modified affecting many tables that are related between each other. With this feature, ODA takes care of propagating changes and keeping the data consistent. We also have, Optim Development Studio (ODS). provides an environment for database developers to work on functions, develop stored procedures, SQL scripts, Web services, and so on. Data Studio provides this same functionality, but it does not have pureQuery support. pureQuery is a new Java API from IBM that allows Java developers to code in a simpler way.It also helps DBAs improve performance of applications without modifying any code. Note the two asterisks at the bottom indicate that Optim Database Administrator and Optim Development Studio are now included...
tracking img