The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Managing and scheduling database jobs with the Data Studio Web Console

Dimple Bhatia (dimple@us.ibm.com), Advisory Software Engineer, IBM　　

Dimple Bhatia is an advisory software engineer at the IBM Silicon Valley Lab in San Jose, Calif. She is currently the lead on the Data Studio Web Console which is a web-based tool, including health monitoring and job management. She is also working on the web tooling infrastructure used for all web-based tools in the Optim umbrella. Before joining the InfoSphere Warehouse tooling team, she worked as the lead on the Federation Catalog and on migration in WebSphere Federation Server. She holds a master's degree in computer engineering from Syracuse University in New York.

Hassi Norlen (hnorlen@us.ibm.com), Optim Tools Senior Information Developer, IBM

Hassi Norlen is an information developer with IBM's Costa Mesa lab. He has worked extensively with database management and monitoring software such as InfoSphere Optim Performance Manager, IBM Data Studio, and IBM Data Studio web console. His subject of expertise is up-and-running and installation documentation, as well as UI development using the progressive-disclosure methodology. He started his IBM career 10 years ago in Enterprise Content Management, working on IBM FileNet P8 Application Engine/Workplace XT and IBM Enterprise Records. He holds a master's degree in physics and a degree in journalism from Sweden's Uppsala University, and worked as a science and technology journalist and a science teacher before joining IBM.

Quddus Chong (qchong@us.ibm.com), Optim Tools Information Developer, IBM

Quddus Chong joined IBM in 2003 after an internship with IBM Extreme Blue. He worked with the Informix team in Lenexa for three years as an infrastructure software engineer. In 2006, he joined IBM Silicon Valley Lab to work as a software accessibility specialist, then as the lead programming writer for IMS application development. Currently, he is an information developer for InfoSphere Optim Query Tuner products and the IBM Data Studio web console.

Summary: As the number of databases increase in many organizations, many DBAs are facing a major challenge in automating and scheduling their database operations. The new job management capability in IBM® Data Studio provide DBAs with a simple and flexible way to create and manage database jobs, and to schedule command scripts to run automatically.

Date: 12 Jan 2012
Level: Intermediate
PDF: A4 and Letter (1541 KB | 23 pages)Get Adobe® Reader®

Activity: 18469 views
Comments:

Before you start

About this tutorial

Scheduling and automating database operations by using existing solutions such as cron, batch programming, or script automation programs can be a complex operation for many DBAs. Rather than creating and maintaining the scripts and schedules separately, it is easier and more reliable for a DBA to group these database operations into jobs, then manage and execute the jobs from a single tool.

A job is a container that contains all the necessary information required to run a script or command against one or more databases according to a user-defined schedule. The job does not directly contain any information about which databases that the job will run against. Instead, you associate database information when you create one or more schedules for a job. This flexible approach allows you to run the same scripts or commands against different databases and schedule them for execution at different times.

The Job Manager in the Data Studio web console provides the tools needed to create and schedule script-based jobs on your DB2® for Linux®, UNIX®, and Windows® and DB2 for z/OS® databases. When you create a job, you can schedule it to run on one or more databases. A job can also be run manually from the Job Manager user interface. You can also configure multiple jobs to run sequentially by adding a chain of jobs to the job you are creating.

Objectives

After completing this tutorial, you will have learned how to:

Create and manage script-based jobs
Set up schedules to run jobs against DB2 databases
Monitor the success or failure of jobs
Check the job execution history
Manage privileges for job scheduling and execution

Prerequisites

To use the new job-management capability, you will need to have one of the following software components installed and configured:

The IBM Data Studio web console
An IBM Data Studio Eclipse-based client (either the full or administration client); if you use the Data Studio client to access the Job Manager, you must install and configure the web console first

To learn about installing these components and getting started with them, see the Getting Started topic in the Data Studio Information Center.

You also need a compatible web browser, such as Firefox V3.6 or higher, or Internet Explorer V8 or higher.

Comments