Configuring the Archive Utility


Overview

Tasks

Included with

Tivoli Problem Management

Overview

Configuring the Archive Utility

This help topic explains the process for configuring the Archive Utility. This help topic assumes that you have already installed the Archive Utility along with other Tivoli Service Desk components.

To configure the Archive Utility you must do the following:

Open Custom Script dialog box The Open Custom Script dialog box is used to select the build script associate with the version of Tivoli Problem Management to be archived and your DBMS.

Tasks

Parsing the Archive Utility files

After installing the Archive Utility, you must parse it.

Parsing is an action that translates a file from ASCII text format into the binary format that an TSD Script run-time system can interpret. Parsing translates the commands and structures entered by the programmer into machine language. You must parse the source files for TSD Script programs or utilities after you install or customize them.

The following procedure explains how to parse the Archive Utility.

  1. Use this table to determine your first action.
  2. If you are using... then...
    Windows 95, Windows 98, or Windows NT 4.0
    1. From the taskbar, choose Start.
    2. From the Start menu, point to Programs, point to Tivoli Service Desk, point to Parse Utility, then choose Parse TPM Archive Utility.
    OS/2
    1. Choose the Tivoli Problem Management Archive Utility folder.
    2. When the folder opens, choose the Parse Archive Utility icon.
    UNIX
    1. Change to the directory where the Archive Utility program resides.
    2. At the command line, type kml eaaprs.
    3. Press Enter.
  3. In the Tivoli Archive Database Logon dialog box, in the Logon box, type your database logon ID.
  4. In the Password box, type your password if one is required.
  5. Choose OK.
  6. When the TSD Script Parser appears, choose Run.
  7. As the TSD Script Parser runs, use this table to interpret the information under Build Status.
    Column Description
    Current Totals for the current .kb file being parsed
    Totals Cumulative totals for all .kb files parsed during the current session

    When the parse finishes, information appears in the Errors and Warnings box.

    • If there are no errors, go to step 6.
    • If there are errors, go to step 4.
  8. Verify the following information:
    • The location of your Tivoli directories is correct
    • A valid Tivoli Problem Management data source is selected.
  9. Return to step 1 and repeat this procedure. Contact the Tivoli Customer Support Center if you continue to have difficulties parsing the Archive Utility.
  10. Choose Close.

    You have successfully parsed the Archive Utility.

If you intend to archive data to a database, proceed with Creating and modifying archive tables.

If you intend to archive data to a flat file or to delete archived data, you are ready to proceed with Archive Utility Interface.

Creating and modifying archive tables

After you successfully parse the Archive Utility, you are ready to create or modify archive tables.

The actions you must take depend on several different factors. Use the following guide to determine which of the following procedures must be completed before you can use the Archive Utility.

  1. Do you intend to archive a database?
    • If yes, go to step 2.
    • If no, you do not need to complete any of these procedures. Go to step 9.
  2. Are you installing the Archive Utility for the first time?
    • If yes, go to step 3.
    • If no, go to step 6.
  3. Have you customized any of these tables in Tivoli Problem Management?
      • PROBLEMS
      • SESION
      • CALL
      • PROBLEM_HISTORY
      • WORK_HISTORY
    • If yes, go to step 4.
    • If no, go to step 5.
  4. Procedures 1, 2, and 4 must be completed.
  5. Procedures 2 and 4 must be completed.
  6. Is Tivoli Problem Management installed?
    • If yes, go to step 7.
    • If no, you do not need to complete any of these procedures. Go to step 9.
  7. Have you already used an eaartxxx.alt script to modify the archive tables for use with Tivoli Problem Management?
    • If yes, you do not need to complete any of these procedures. Go to step 9.
    • If no, go to step 8.
  8. Procedures 3 and 4 must be completed.
  9. Proceed with Archive Utility Interface.

Procedures

  1. Customize the build scripts and the eaacust.kb file to match any Tivoli Problem Management customizations.
  2. Create destination database tables for the archived data.
  3. Modify the archive database tables for use with Tivoli Problem Management.
  4. Parse the Archive Utility.

The following sections provide instructions for completing each of these procedures.

Procedure 1: Customizing build scripts and eaacust.kb

If you intend to archive to a database and you have customized the tables in the Tivoli Problem Management database, you must customize the Archive Utility build scripts to reflect those changes. This is only necessary if you have modified any of the following tables:

  • PROBLEMS
  • SESION
  • CALL
  • PROBLEM_HISTORY
  • WORK_HISTORY

Customizing the Archive Utility for table changes is a two step process:

  • Modify the build script that corresponds to your particular DBMS and version of Tivoli Problem Management. The list of scripts can be found in Creating destination database tables. Contact the Tivoli Customer Support Center for instructions on modifying build scripts.
  • Edit the eaacust.kb file, using a text editor, and make the changes that correspond to the changes you made in the build script. Refer to Tivoli Problem Management customizations for instructions on editing the eaacust.kb file.

After making these modifications, you are ready to proceed with Creating destination database tables.

Procedure 2: Creating destination database tables

If you installed the Archive Utility for the first time and you choose to archive data to a database, destination database tables must be created before the data is archived. Because this is the location in which all the archived data is stored, the archive database tables must:

  • Include all of the tables to be archived
  • Reflect all the customizations performed on the production database

Archive tables must be created on the same database as the Tivoli Problem Management database. The Archive Utility does not allow users to choose a separate destination data source.

The procedure to create the destination database tables follows.

  1. Use the following table to determine your first action.
  2. If you are using... then...
    Windows 95, 98 or Windows NT 4.0
    1. From the taskbar, choose Start.
    2. From the Start menu, point to Programs, point to Tivoli Service Desk 6.0, point to Tivoli Service Desk, then choose Table Builder.
    Windows NT 3.5.1
    1. Choose the Tivoli Service Desk Table Builder program group icon.
    2. From the program group, choose the TSD Build icon.
    OS/2
    1. Choose the Tivoli Service Desk Table Builder folder.
    2. From the Tivoli Service Desk folder, choose the TSD Build icon.
    UNIX
    1. Change to the directory where the Tivoli Service Desk Table Builder program resides.
    2. At the command line, enter kml esmbuild.
  3. In the Tivoli Service Desk Table Builder window, from the Configure menu, choose the appropriate database server.
    Result: The Configure for database dialog box appears, with boxes appropriate to the database you selected.
  4. Verify that all information is correct.
  5. Choose OK.
  6. From the Action menu, choose Execute Script File.
  7. In the Open Custom Script dialog box, change to the directory where the Archive Utility is installed.
  8. From the list of files, select the build script associated with the version of Tivoli Problem Management to be archived and your DBMS.
    Note: Use this table to determine which file to select.
  9. Product Name Oracle 7.x DB2 MS-SQL Server Sybase 10.x Informix
    Expert Advisor 3.0 eaa30or7.tab eaa30db2.tab eaa30mss.tab eaa30syb.tab not supported
    Expert Advisor 3.1 eaa31or7.tab eaa31db2.tab eaa31mss.tab eaa31syb.tab eaa31inf.tab
    Expert Advisor 3.5 eaa35or7.tab eaa35db2.tab eaa35mss.tab eaa35syb.tab eaa35inf.tab
    Expert Advisor 3.5 with DDM eaartor7.tab eaartdb2.tab eaartmss.tab eaartsyb.tab eaartinf.tab
    Expert Advisor 5.0 eaa50or7.tab eaa50db2.tab eaa50mss.tab eaa50syb.tab eaa50inf.tab
    Expert Advisor 5.0 with DDM eaartor7.tab eaartdb2.tab eaartmss.tab eaartsyb.tab eaartinf.tab
    Tivoli Problem Managmenent 6.0 tpmaora.tab tpmadb22.tab

    For DB2 Mainframe: tpmadb2.tab

    tpmamss.tab tpmasyb.tab tpminf.tab
  10. Choose Open.
  11. In the TSD Build Database Login dialog box, in the Login box, type your database logon ID, or leave the current information as is.
  12. In the Password box, type your database password, if one is required.
  13. Choose OK.
  14. When a Warning message appears which prompts you to confirm the database script, choose OK.
  15. When the script file finishes running, a message appears in the Tivoli Service Desk Table Builder window which indicates whether the action was successful.
    If the script file did not run successfully, check the database configuration information and repeat steps 2 through 13.
    Otherwise, go to the next step.
  16. Quit the TSD Build utility.

Procedure 3: Modifying archive tables for use with Tivoli Problem Management

If you archive to a database, and you install DDM for use with Tivoli Problem Management, you must ensure that the archive tables are compatible with DDM.

Refer to the guide to determine whether you need to perform this step, modifying archive tables for use with DDM. In brief, you only need to perform this procedure if the following statements are true:

  1. You archive to a database
  2. You installed Tivoli Problem Management after you installed the Archive Utility and after you created destination database tables
  3. You have not already run an eaartxxx.alt script to modify archive tables for use with Tivoli Problem Management

If all these statements are true, you must modify the archive tables for use with Tivoli Problem Management. The procedure for modifying the archive tables follows.

  1. Use the following table to determine your first action.
  2. In the Tivoli Service Desk Table Builder window, from the Configure menu, choose the appropriate database server.
  3. The Configure for database dialog box appears, with boxes appropriate to the database you selected.
  4. Verify that all information is correct.
  5. Choose OK.
  6. From the Action menu, choose Execute Script File.
    Result: The Open Custom Script dialog box appears.
  7. Change to the directory where the Archive Utility is installed.
    From the list of files, select the build script associated with your DBMS.
    Use this table to determine which file to select.
  8. If your DBMS is... then run this script file...
    Oracle 7.x eaartor7.alt
    DB2 eaartdb2.alt
    MS-SQL Server eaartmss.alt
    Sybase 10.x eaartsyb.alt
    Informix eaartinf.alt
  9. Choose Open.
  10. In the TSD Build Database Login dialog box, in the Login box, type your database logon ID, or leave the current information.
  11. In the Password box, type your database password, if one is required.
  12. Choose OK.
  13. When a Warning message appears which prompts you to confirm the database script, choose OK.
  14. When the script file finishes running, a message appears in the Tivoli Service Desk Table Builder window which indicates whether the action was successful.
    If the script file did not run successfully, check the database configuration information and repeat steps 2 through 13.
    Otherwise, go to the next step.
  15. Quit the TSD Build utility.

Procedure 4: Re-parsing the Archive Utility

After customizing build scripts or creating or modifying archive tables, you must re-parse the Archive Utility.

Refer to Parsing the Archive Utility files for instructions for this procedure.

After you re-parse the Archive Utility, you are ready to proceed with Archive Utility Interface.