Chapter 4. Using Database Tools and Utilities

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 ...

Get DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.