Appendix A. Getting Started with DB2

If you have not used DB2 before, this appendix is the perfect place to start. It covers DB2 fundamentals and commands that will prepare you to work with the SQL procedure examples demonstrated in this book.

The first part of this appendix is focused on DB2 LUW. DB2 commands are illustrated to show how to create and manipulate DB2 instances, databases, buffer pools, table spaces, and tables. A set of DB2 graphical tools is also available to accomplish the same tasks, and more information can be found in the Online Help for the DB2 Administration Tools manual. Focus is on the executing from the command line using a DB2 Command window on Windows or a UNIX shell.

The second part of this appendix covers the iSeries ...

Get DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second 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.