Remote job execution In many cases, it is necessary to run maintenance jobs and database changes after hours. By selecting the location, you can view the results sets for only that environment, as shown in Figure 2.Ģ. After execution, you can see if the run was successful. In the case of SQL selects, the results sets can even be compared to reveal any discrepancies. Review the script output from the individual locations. Toad will automatically connect to the selected locations and run the script. Check the databases and subsystems you wish to execute against. Sending a script to the Remote Execution Wizardġ. Viewing the output of group execution for a selected locationįigure 3. The group execute feature allows you to easily select the environments where you wish to run the script (see Figure 1).įigure 2. Many times, a SQL statement or DDL script needs to be executed in Group execute The group execute functionality in Toad is a very useful productivity feature. Executing group execute from the SQL editorġ. Toad’s group execute feature allows you to easily select multiple environments where you wish to run a script.įigure 1. This tech brief will reveal some of the unique database administration features found in Toad for IBM DB2 that greatly enhances the DBA’s productivity. Toad for IBM DB2 provides all the features required for managing your DB2 objects, performing maintenance, and conducting performance tuning.
Whether you are managing DB2 running on Linux, UNIX, Windows or z/OS, Toad for IBM DB2 provides the functionality you need to perform your day-to-day administration tasks with increased speed and accuracy. It is also important to understand that the current Toad for IBM DB2 is not just a developer’s tool, but also a very robust tool for database administrators. Product family has branched out to support not only Oracle, but also SQL Server and DB2. As a matter of fact, the name Toad was originally an acronym: Tool for Oracle Application Developers. Historically, Toad was known primarily as a tool for Oracle developers. For those of you who are working exclusively within the DB2 platform, the name Toad may not have much resonance. Introduction Those of you working with DB2 who also have Oracle experience most likely have heard of Toad. This tech brief highlights some of its newer and lesser known features that provide great productivity benefits in the DBA’s day-to-day work. Written by Jeff Podlasek, senior product architect, Dell SoftwareĪbstract Toad™ for IBM® DB2® is a powerful tool for the database administrator. The Top 10 Things DBAs Should Know About Toad for IBM DB2 ™
0 kommentar(er)
