Bookshelf Home | Contents | Index | PDF     

Siebel Data Warehouse Installation and Administration Guide > DAC Quick Start >

Overview of Command Line Access to the DAC Server

NOTE:  This feature is only available if you have installed Siebel Data Warehouse version 7.7.1.1.

This chapter covers accessing the DAC server through a command line. It includes the following topics:

You can access the Siebel DAC server through a command line to start and stop execution plans and to get status information for servers, databases, and execution plans. This feature allows you to access the DAC server using third-party administration or management tools, without using the DAC client.

Command Line Operations

The command line feature allows you to start an execution plan and stop the operation of a running execution plan.

Starting an Execution Plan

When the DAC server receives a request to start an execution plan, it performs a series of checks to verify that the execution plan can be started. It first checks that an execution plan with the requested name exists and that the execution plan is active. Next, it checks the status of the execution plan that last ran. If an execution plan is still running and the DAC server receives a request to start another execution plan, the request will be rejected. If an execution plan failed, a request to run the same execution plan again will be executed; however, a request to run a different execution plan will be rejected. If the execution plan that last ran completed successfully, a request to run a new execution plan will be executed.

When the DAC server receives a request to start an execution plan, it will issue a warning if any of the following conditions are true. (A warning is for informational purposes and does not mean the execution plan will not start.)

  • The Generic task concurrency limit (set in the system properties) is not a positive number.
  • There are no active Informatica servers in the server list.
  • One or more Informatica servers do not have the passwords defined.
  • One or more Informatica servers do not have a maximum number of sessions properly set.
  • One or more data sources do not have the passwords defined.
  • One or more data sources do not have a maximum number of connections properly set.
Stopping the Operation of a Running Execution Plan

When the DAC server receives a request to stop the operation of a running execution plan, the request will fail in the following cases:

  • The name of the execution plan that is running is different from the name in the request.
  • There is no execution plan currently running.

Command Line Status Monitoring Queries

The command line feature allows you to get the following status information:

  • Summary of the requested execution plan. If there are multiple instances of the same execution plan, a summary of the instance that last ran is returned. Below is an example of the information contained in the summary.

    (c) 2003 Siebel Systems, Inc.

    Siebel DAC Server comprising the etl execution-management,
    scheduler, logger, and network server.

    ETL details for the last run:

    ETL Process Id : 255
    ETL Name : Complete ETL
    Run Name : DRY RUN OF Complete ETL: ETL Run - 2004-06-17 18:30:13.201
    DAC Server : (aqamarD510)
    DAC Port : 3141
    Status: Stopped
    Log File Name: Complete_ETL.255.log
    Database Connection(s) Used :

    OLTP jdbc:microsoft:sqlserver://vranganaw8:1433;DatabaseName=OLTP
    Data Warehouse jdbc:microsoft:sqlserver://vranganaw8:1433;DatabaseName=olap

    Informatica Server(s) Used :

    InformaticaServer4-vranganaw8:(4)
    InformaticaServer2-vranganaw8:(2)
    InformaticaServer3-vranganaw8:(3)
    InformaticaServer1-vranganaw8:(10)

    Start Time: 2004-06-17 19:00:06.885
    Message: ETL was interrupted
    Actual Start Time: 2004-06-17 18:30:13.357
    End Time: 2004-06-17 19:05:56.781
    Total Time Taken: 35 Minutes

    Start Time For This Run: 2004-06-17 19:00:06.885
    Total Time Taken For This Run: 5 Minutes

    Total steps: 212
    Running steps: 0
    Complete steps: 142
    Failed/Stopped steps:70

  • Summary of connection status to all active databases and Informatica servers.
    
Siebel Data Warehouse Installation and Administration Guide