DB2 10.1 fundamentals certification exam 610 prep, Part 1:PlanningPage 15 of 41As stated earlier, DB2 pureScale is a paid-separately, add-on product that can be used with DB2WSE (free-of-charge), DB2 ESE and DB2 AESE. Its use is restricted to a specific hardware andcan only be run on some versions of IBM AIX (AIX 6.1 and 7.1) and Linux (SUSE and Red HatEnterprise Linux - RHEL). For more information, refer to the links provided at the end of thistutorial. Every member of a pureScale cluster requires a DB2 license, as well as a pureScalelicense. However, no additional license is needed for the CF server(s) used.Before DB2 10.1, if you wanted to use DB2 pureScale, a special release of DB2 was necessary:DB2 9.8. (This version was the first implementation of DB2 pureScale.) Now, with DB2 10.1,pureScale has been integrated to DB2’s core. It’s important to note that no application changesare necessary when migrating from traditional DB2 to DB2 pureScale. In fact, to applications, itappears as if traditional DB2 is being used, but that performance has improved significantly.DB2 toolsDB2 comes equipped with a set of tools that enable you to access, query, operate, and manageyour DB2 database environment, either locally or remotely. Many of these tools are stand-alonewith graphical user interfaces (like Data Studio and Replication Center) while others are commandline tools; we’ll look at both types in more detail in this section.Command line toolsDB2 Command Line Processor (CLP)The Command Line Processor (CLP) is a command-line interface that can be used to interact withDB2 instances and databases. You’ll find it with every DB2 edition, as well as with each DB2 client(but not with driver packages).The DB2 CLP can be run in interactive mode (by executing the command db2 once) or in non-interactive mode (by prefixing commands run from a system command prompt with the keyword"db2").For example, in interactive mode, a DB2 command would be executed like this:db2 => list applicationsIn non-interactive mode, however, the same command would be executed like this:db2 list applicationsWhen using non-interactive mode, you can execute operating system’s commands whenever youwant. But if you need to execute an operating system command while running in interactive mode,you must prefix the command with an exclaimation mark (!). For example:db2 => !dirOn Windows, to enable use of DB2 CLP in interactive and non-interactive modes, you must clickon the DB2 Command Windowicon or run the db2cmd command. When the db2cmd command
developerWorks®ibm.com/developerWorks/DB2 10.1 fundamentals certification exam 610 prep, Part 1:PlanningPage 16 of 41is invoked from another command terminal, Windows will create a new window for DB2 CLP non-interactive use. Figure 6 illustrates how the DB2 CLP is run in interactive mode.