Using Database Tools and Utilities in DB2
␡
- Database Tools: The Big Picture
- IBM Data Studio
- IBM Data Studio Web Console
- Set-Up Tools
- Information Tools
- Problem Determination Tools
- Case Study 1
- Case Study 2
- Summary
- Review Questions
Page 1 of 10
Next >
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.
This chapter is from the book
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 Database tools the big picture
Page 1 of 10
Next >