1 fundamentals certification exam 610 prep Part 1 Planning Page 15 of 41 As

1 fundamentals certification exam 610 prep part 1

This preview shows page 15 - 17 out of 41 pages.

DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning Page 15 of 41 As stated earlier, DB2 pureScale is a paid-separately, add-on product that can be used with DB2 WSE (free-of-charge), DB2 ESE and DB2 AESE. Its use is restricted to a specific hardware and can only be run on some versions of IBM AIX (AIX 6.1 and 7.1) and Linux (SUSE and Red Hat Enterprise Linux - RHEL). For more information, refer to the links provided at the end of this tutorial. Every member of a pureScale cluster requires a DB2 license, as well as a pureScale license. 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 changes are necessary when migrating from traditional DB2 to DB2 pureScale. In fact, to applications, it appears as if traditional DB2 is being used, but that performance has improved significantly. DB2 tools DB2 comes equipped with a set of tools that enable you to access, query, operate, and manage your DB2 database environment, either locally or remotely. Many of these tools are stand-alone with graphical user interfaces (like Data Studio and Replication Center) while others are command line tools; we’ll look at both types in more detail in this section. Command line tools DB2 Command Line Processor (CLP) The Command Line Processor (CLP) is a command-line interface that can be used to interact with DB2 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 applications In non-interactive mode, however, the same command would be executed like this: db2 list applications When using non-interactive mode, you can execute operating system’s commands whenever you want. 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 => !dir On Windows, to enable use of DB2 CLP in interactive and non-interactive modes, you must click on the DB2 Command Window icon or run the db2cmd command. When the db2cmd command
developerWorks® ibm.com/developerWorks/ DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning Page 16 of 41 is 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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture