DataStage使用手册

Ascential DataStageDirector Guide Version 7.5.1Part No. 00D-007DS751December 2004his document, and the software described or referenced in it, are confidential and proprietary to Ascential Software Corporation ("Ascential"). They are provided under, and are subject to, the terms and conditions of a license agreement between Ascential and the licensee, and may not be transferred, disclosed, or otherwise provided to third parties, unless otherwise permitted by that agreement. No portion of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of Ascential. The specifications and other information contained in this document for some purposes may not be complete, current, or correct, and are subject to change without notice. NO REPRESENTATION OR OTHER AFFIRMATION OF FACT CONTAINED IN THIS DOCUMENT, INCLUDING WITHOUT LIMITATION STATEMENTS REGARDING CAPACITY, PERFORMANCE, OR SUITABILITY FOR USE OF PRODUCTS OR SOFTWARE DESCRIBED HEREIN, SHALL BE DEEMED TO BE A WARRANTY BY ASCENTIAL FOR ANY PURPOSE OR GIVE RISE TO ANY LIABILITY OF ASCENTIAL WHATSOEVER. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL ASCENTIAL BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. If you are acquiring this software on behalf of the U.S. government, the Government shall have only "Restricted Rights" in the software and related documentation as defined in the Federal Acquisition Regulations (FARs) in Clause52.227.19 (c) (2). If you are acquiring the software on behalf of the Department of Defense, the software shall be classified as "Commercial Computer Software" and the Government shall have only "Restricted Rights" as defined in Clause 252.227-7013 (c) (1) of DFARs.This product or the use thereof may be covered by or is licensed under one or more of the following issued patents: US6604110, US5727158, US5909681, US5995980, US6272449, US6289474, US6311265, US6330008,US6347310, US6415286; Australian Patent No. 704678; Canadian Patent No. 2205660; European Patent No. 799450; Japanese Patent No. 11500247.© 2005 Ascential Software Corporation. All rights reserved. DataStage®, EasyLogic®, EasyPath®, Enterprise Data Quality Management®, Iterations®, Matchware®, Mercator®, MetaBroker®, Application Integration, Simplified®, Ascential™, Ascential AuditStage™, Ascential DataStage™, Ascential ProfileStage™, Ascential QualityStage™, Ascential Enterprise Integration Suite™, Ascential Real-time Integration Services™, Ascential MetaStage™, and Ascential RTI™ are trademarks of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions.The software delivered to Licensee may contain third-party software code. See Legal Notices (legalnotices.pdf) for more information.How to Use this Guide Ascential DataStage™ is a powerful software suite that is used todevelop and run DataStage jobs. A DataStage job can extract fromdifferent sources, and then cleanse, integrate, and transform the dataaccording to your requirements. The clean data is ready to beimported into a data warehouse for analysis and processing bybusiness information software.This manual describes the DataStage Director, the DataStagecomponent that is used to validate, schedule, run, and monitorDataStage server jobs and parallel jobs. For information about how toperform these tasks for DataStage mainframe jobs, refer to thedocumentation supplied with the mainframe computer. (For a briefexplanation of server, parallel, and mainframe jobs, refer to"DataStage Projects and Jobs" on page1-3.)To use this manual you should be familiar with the Windows 2000 orWindows XP interface, but no other special skills or knowledge arerequired.To find particular topics you can:Use the Guide’s contents list (at the beginning of the Guide).Use the Guide’s index (at the end of the Guide).Use the Adobe Acrobat Reader bookmarks.Use the Adobe Acrobat Reader search facility (select Edit ➤Search).The guide contains links both to other topics within the guide, and toother guides in the DataStage manual set. The links are shown in blue.Note that, if you follow a link to another manual, you will jump to thatmanual and lose your place in this manual. Such links are shown initalics.Director Guide iiiOrganization of This Manual How to Use this Guide iv Director GuideOrganization of This ManualThis manual contains the following:Chapter 1 contains an overview of DataStage ® and its componentparts.Chapter 2 describes the DataStage Director and how to use it.Chapter 3 covers how to validate, run, delete, schedule, andadminister DataStage server jobs.Chapter 4 describes job batches.Chapter 5 describes how to monitor a running server job.Chapter 6 describes the job log file and the Job Log view.The Glossary defines terms that have specific meaning inDataStage. Documentation ConventionsThis manual uses the following conventions: ConventionUsage Bold In syntax, bold indicates commands, function names, keywords,and options that must be input exactly as shown. In text, boldindicates keys to press, function names, and menu selections.UPPERCASE In syntax, uppercase indicates BASIC statements and functionsand SQL statements and keywords.Italic In syntax, italic indicates information that you supply. In text,italic also indicates UNIX commands and options, file names,and pathnames.Plain In text, plain indicates Windows commands and options, filenames, and path names.Lucida Typewriter The Lucida Typewriter font indicates examples of source codeand system output.Lucida Typewriter In examples, Lucida Typewriter bold indicates characters thatthe user types or keys the user presses (for example,<Return>).[ ]Brackets enclose optional items. Do not type the brackets unlessindicated.{ }Braces enclose nonoptional items from which you must selectat least one. Do not type the braces.How to Use this Guide DataStage DocumentationDirector Guide v DataStage DocumentationDataStage documentation includes the following:DataStage Director Guide : This guide describes the DataStageDirector and how to validate, schedule, run, and monitorDataStage server jobs.DataStage Manager Guide : This guide describes the DataStageManager and describes how to use and maintain the DataStageRepository.DataStage Designer Guide : This guide describes the DataStageDesigner, and gives a general description of how to create, design,and develop a DataStage application.DataStage Server: Server Job Developer’s Guide : This guidedescribes the tools that are used in building a server job, and itsupplies programmer’s reference information.DataStage Enterprise Edition: Parallel Job Developer’sGuide : This guide describes the tools that are used in building aparallel job, and it supplies programmer’s reference information.DataStage Enterprise Edition: Parallel Job AdvancedDeveloper’s Guide : This guide gives more specializedinformation about parallel job design.DataStage Enterprise MVS Edition: Mainframe JobDeveloper’s Guide : This guide describes the tools that are usedin building a mainframe job, and it supplies programmer’sreference information.DataStage Administrator Guide : This guide describesDataStage setup, routine housekeeping, and administration.itemA | itemBA vertical bar separating items indicates that you can choose only one item. Do not type the vertical bar....Three periods indicate that more of the same type of item can optionally follow.➤ A right arrow between menu commands indicates you should choose each command in sequence. For example, “Choose File➤ Exit” means you should choose File from the menu bar, then choose Exit from the File pull-down menu.This line ➥ continuesThe continuation character is used in source code examples toindicate a line that is too long to fit on the page, but must beentered as a single line on screen.ConventionUsageDataStage Documentation How to Use this Guidevi Director GuideDataStage Install and Upgrade Guide . This guide containsinstructions for installing DataStage on Windows and UNIXplatforms, and for upgrading existing installations of DataStage.DataStage NLS Guide . This Guide contains information aboutusing the NLS features that are available in DataStage when NLSis installed.These guides are also available online in PDF format. You can readthem using the Adobe Acrobat Reader supplied with DataStage. SeeInstall and Upgrade Guide for details on installing the manuals andthe Adobe Acrobat Reader.You can use the Acrobat search facilities to search the wholeDataStage document set. To use this feature, select Edit ➤ Searchthen choose the All PDF documents in option and specify theDataStage docs directory (by default this is C:\ProgramFiles\Ascential\DataStage\Docs).Extensive online help is also supplied. This is particularly useful whenyou have become familiar with DataStage, and need to look upspecific information.ContentsHow to Use this GuideOrganization of This Manual . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .ivDocumentation Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .ivDataStage Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-v Chapter 1Introducing DataStageWhat Is a Data Warehouse? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1Why Do I Need One? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1What Does DataStage Do? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2How Is DataStage Packaged? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2DataStage Projects and Jobs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3 Chapter 2The DataStage DirectorStarting the DataStage Director . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1The DataStage Director Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-3 Job Category Pane. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-3Display Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-3Menu Bar. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-4Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-5Status Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-5 Job Status View. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-6 Job States. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-7Job Status Details. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-7 Director Guide viiContentsShortcut Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-8 Shortcut Menus in the Job Status View. . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-9Shortcut Menus in the Job Log View. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-9Shortcut Menus in the Job Schedule View . . . . . . . . . . . . . . . . . . . . . . . . 2-10Shortcut Menus in the Job Category Pane . . . . . . . . . . . . . . . . . . . . . . . . 2-10Shortcut Menu in the Monitor Window. . . . . . . . . . . . . . . . . . . . . . . . . . . 2-10 Filtering the Job Status or Job Schedule View. . . . . . . . . . . . . . . . . . . . . . . . 2-11 Examples of Filtering by Job Name. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-12 Finding Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-13Sorting Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-15Printing the Current View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-15 What Is in the Printout?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-16Changing the Printer Setup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-17 Director Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-17 General Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-18Limits Page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-19View Page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-20Priority Page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-21 Choosing an Alternative Project. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-22 Viewing Jobs in Another Project . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-22Viewing Jobs on a Different Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-22 Exiting the DataStage Director. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-23Chapter 3Running DataStage JobsSetting Job Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-1Validating a Job. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-3Running a Job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-4Stopping a Job. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-5Resetting a Job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-5Restarting Job Sequences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-6Setting Default Job Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-6Job Scheduling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-7 Job Schedule View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8Viewing Details of a Job Schedule. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-9Scheduling a Job. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-11Unscheduling a Job. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12Rescheduling a Job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12 viii Director GuideContentsDeleting a Job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-13Job Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-14 Cleaning Up Job Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-14Clearing a Job Status File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17 Multiple Job Invocations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17Setting Tracing Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20Generating Operational Meta Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-21Disabling Message Handlers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-21 Chapter 4Job BatchesWhat Is a Job Batch?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1Creating a Job Batch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1Running a Job Batch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3Scheduling a Job Batch. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-4Unscheduling a Job Batch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-5Rescheduling a Job Batch. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-5Job Schedule Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-6Editing a Job Batch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-6Copying a Job Batch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-7Deleting a Job Batch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-7 Chapter 5Monitoring JobsThe Monitor Window. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-1 Monitor Shortcut Menu. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4Setting the Server Update Interval. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-5 Switching Between Monitor Windows. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6The Stage Status Window. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6 Chapter 6The Job Log FileJob Log View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1The Event Detail Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-3Viewing Related Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5Filtering the Job Log View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-5 Director Guide ixContentsPurging Log File Entries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-7 Purging Log Entries Immediately. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-8Purging Log Entries Automatically. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-8 Message Handlers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-9 Adding Rules to Message Handlers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-10Managing Message Handlers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-12 Glossaryx Director Guide1Introducing DataStage Many organizations want to make better use of their data. But thatdata may be stored in different formats in different types of database.Some data sources may be dormant archives, others may be busyoperational databases. Extracting and cleaning data from these variedsources has always been time-consuming and costly – until now.DataStage makes it simple to design and develop efficientapplications that make data warehousing a reality where it wasimpossible before.What Is a Data Warehouse?A data warehouse is a central database containing copies of data fromall the operational sources and archive systems in an organization.But the database does not have to be large. Instead of storing detailsof every transaction, order, or set of sales figures, the data warehousestores totals, averages, area figures, and so on. This data is structuredto make it easy to query and to generate reports.Inside the data warehouse you can perform analyses that would beimpractical on a working database. This means that anyone whoneeds access to the data gets all the information they want, and onlythe information they want. The data warehouse can be created orupdated at any time, with minimum disruption to working systems.Why Do I Need One?Working databases are busy. It is hard to gain an accurate picture ofthe contents of the database at any time because it changesWhat Does DataStage Do?Introducing DataStage frequently. By transferring working data into a data warehouse, youcan take snapshots of what is going on. Also, working databasescontain dirty data – records in different formats, with key valuesmissing or out of range, and so on. In a fast-moving working databaseit is difficult to trap mistakes or incomplete entries. Using DataStage,you can cleanse data before loading it into a data warehouse,ensuring that your business decisions are based only on validinformation.As well as a working database, you may have archive systems orincompatible data sources that you have inherited. These may bestatic, but inaccessible because their format is different from yourworking system. You can use DataStage to transform this data intocompatible formats that can be stored in the data warehouse.What Does DataStage Do?DataStage comes in between your data and your data warehouse.DataStage jobs process the data to meet your needs, including:Extraction – DataStage takes data from indexed files, sequential files, networked databases, archives, and external data sourcesand stores it in the data warehouse.Aggregation – DataStage takes your working data, calculatestotals and averages, then stores it in the data warehouse. Thismeans you have to store much less data, which is quicker andeasier to access.Transformation – DataStage converts inconsistent data into the required format and loads it into the data warehouse.How Is DataStage Packaged?DataStage is client/server software. The server holds the data while itis being processed. The client is the interface to DataStage that is usedfor designing and running jobs, or managing the data in theRepository. The client components include:DataStage Designer, for creating DataStage server andmainframe jobs. Server jobs are compiled into executableprograms that are scheduled by the DataStage Director and run bythe DataStage Server. Mainframe jobs are downloaded from theDesigner to mainframe computers, where they are compiled andrun by mainframe tools.DataStage Director, for running DataStage server jobs.Introducing DataStage DataStage Projects and JobsDataStage Manager, for viewing and editing the contents of the Repository.DataStage Administrator, for administering DataStage projects and conducting housekeeping on the server.The client and server components installed depend on the edition ofDataStage you have purchased. DataStage is packaged in two ways:Developer’s Edition,used by developers to design, develop,and create executable DataStage jobs. The Developer’s Editioncontains all the client components described earlier and theserver. The developer’s role, DataStage Designer, and DataStageManager are described in DataStage Designer Guide andDataStage Manager Guide.Operator’s Edition,used by operators to validate, schedule, run, and monitor DataStage jobs that have been developed elsewhere.The Operator’s Edition contains DataStage Director, DataStageAdministrator, and DataStage Server components only. DataStage Projects and JobsYou always enter DataStage through a DataStage project. When youstart a DataStage client you are prompted to attach to a project. Eachproject contains DataStage jobs and the components required todevelop or run them.DataStage jobs are made up of individual stages. A stage represents adata source or a process. For example, one stage may extract datafrom a data source, while another transforms it. The data required ateach stage and how it is handled is specified in the job design. Whenthe job is run, the processing described in the job design isperformed. Variable parameters such as file names, dates, and so on,can be specified when the job is run. DataStage jobs can be exportedfor use on other DataStage systems.DataStage supports three types of job:Server jobs are both developed and compiled using DataStage client tools. Compilation of a server job creates an executable thatis scheduled and run from the DataStage Director.Parallel jobs. These are compiled and run on the DataStageserver in a similar way to server jobs, but support parallelprocessing on SMP, MPP, and cluster systems.Mainframe jobs are developed using the same DataStage client tools as for server jobs, but compilation and execution occur on amainframe computer. The DataStage Designer generates aCOBOL source file and supporting JCL script, then lets you uploadDataStage Projects and Jobs Introducing DataStage them to the target mainframe computer. The job is compiled andrun on the mainframe computer under the control of nativemainframe software.There are also:Job Sequences. A job sequence allows you to specify asequence of DataStage jobs to be executed, and actions to takedepending on results.2The DataStage Director The DataStage Director is the client component that validates, runs,schedules, and monitors jobs run by the DataStage Server. It is thestarting point for most of the tasks a DataStage operator needs to doin respect of DataStage jobs.Note DataStage mainframe jobs run on a mainframe computer,and use mainframe-specific tools. These jobs are not visiblein the DataStage Director. In this manual the term jobtherefore refers to DataStage server and parallel jobs only.For information about running DataStage mainframe jobs,consult the documentation supplied with your mainframesoftware.This chapter describes the interface to the DataStage Director andhow to use it, including:Starting the DataStage DirectorUsing the DataStage Director windowFinding text in the DataStage Director window, sorting data, and printing out the displaySetting options and defaults for the DataStage Director windowand for jobs you want to runSwitching between projects and exiting the DataStage Director Starting the DataStage DirectorTo start the DataStage Director:Starting the DataStage Director The DataStage Director1Choose Start ➤Programs ➤Ascential DataStage ➤DataStage Director, or choose the appropriate program folder ifyou installed DataStage elsewhere. The Attach to Project dialogbox appears:2Enter the name of your host in the Host system field. This is the name of the system where the DataStage Server is installed.3Enter your user name in the User name field. This is your username on the server system.4Enter your password in the Password field. If you are connecting to a Windows server via LAN Manager, you can select the Omitcheck box. The User name and Password fields gray out and youlog on to the server using your current Windows account details.Warning Think carefully before using the Omit option to logon to DataStage. If you use this option, note that:–You cannot specify UNC pathnames in DataStage clients.–You must specify the host name in uppercase.–You cannot access remote files.–You may get errors if you import meta data from an ODBC datasource if you are not logged on to the same domain as theserver.5Enter the name of the project you want to use or choose one from the Project list, which displays all the projects installed on theserver.6Click OK. The DataStage Director window appears.Note You can also start the DataStage Director from theDataStage Designer or the DataStage Manager bychoosing Tools➤Run Director. You are automaticallyattached to the same project and you do not see theAttach to Project dialog box. For more informationabout the DataStage Designer and Manager, see。