IBM® DB2® Universal Database ™ (UDB) for Linux™, UNIX® and Windows® is a very powerful database with many functionalities and capabilities. You can administer IBM DB2 UDB either from the command line or through IBM DB2 UDB's lineup of GUI interfaces. If you really want to learn and understand how IBM DB2 UDB works, you will probably want to use the command line to work with IBM DB2 UDB.
Have you ever looked at a command syntax diagram and wondered how it would work in your environment? Have you ever looked up the syntax for a particular command, found it, read it, and still wished that there were some examples to make it more clear and easier to understand? If you answered "yes" to both questions, then you have come to the right place.
The purpose of the cheat sheets is to provide comprehensive examples for every single system and command line processor (CLP) command available for IBM DB2 UDB V8.2. The best way to learn and understand a concept is to learn BY EXAMPLE. However, note that the cheat sheets are not intended to replace the IBM DB2 UDB Command Reference. These examples should be used as complementary reference material to the IBM DB2 UDB manuals. If used properly, these examples can go a long way in helping you understand DB2 and can improve your efficiency with IBM DB2 UDB commands.
|Command Line Processor examples (PDF)||CLPCommands_v8.1.pdf ( HTTP | FTP )||546KB|
|DB2 system command examples (PDF)||systemCommands.pdf ( HTTP | FTP )||371KB|
Dig deeper into Information management on developerWorks
Get samples, articles, product docs, and community resources to help build, deploy, and manage your cloud apps.
Experiment with new directions in software development.
Software development in the cloud. Register today to create a project.
Evaluate IBM software and solutions, and transform challenges into opportunities.