Home > Chapters & Articles > Education & Certification > DB2 > Using Database Tools and Utilities in DB2

Using Database Tools and Utilities in DB2

Chapter Description

How do you work with DB2? How do you issue SQL and/or XQuery statements and enter DB2 commands? Are there graphical tools that can make your administration tasks easier? This chapter provides the answers to all of these questions. DB2 provides a wide range of tools, both graphical and command-driven, to help you work with DB2.

In this chapter, you learn about

  • DB2 command line tools
  • IBM Data Studio
  • IBM Data Studio Web Console
  • Set up tools
  • DB2 information tools
  • DB2 problem determination tools

Database Tools: The Big Picture

DB2 comes with a comprehensive and complimentary set of tools for you to perform basic database administration and development tasks. Figure 4.1 shows a high level overview of tools available with DB2. They are categorized into command line tools, graphical tools, and other tools to assist you with setup. In most cases you can perform the same DB2 commands, SQL statements, and XQuery statements using the command line and graphical tools.

Figure 4.1

Figure 4.1 Database tools the big picture

2. IBM Data Studio | Next Section

Search Related Safari Books

Safari Books