Maximo Archiving with InfoSphere Optim Data Growth Solution, Version 7.6

Editing the access definitions files

The access definitions contain placeholder strings that represent the owner names and aliases of the production and reporting databases. The placeholder strings must be replaced with the aliases and owner names of your databases before you can archive or restore data.

Before you begin

In each access definition, the database aliases are represented by two placeholder strings:

<DBALIASNAME>: Replace this string with the alias name for your production database.

<DBALIASNAMEB>: Replace this string with the alias name for your reporting (backup) database.

In each access definition, the database owners are represented by two placeholder strings:

<DBOWNERNAME>: Replace this string with the name of the database owner of the production database.

<DBOWNERNAMEB>: Replace this string with the name of the database owner of the reporting database.

Note: Remember to remove the angle brackets as well when editing the placeholder strings.

The owner name depends on which database you use:

For IBM® DB2® databases, the owner name is the name of the Maximo® Asset Management schema owner in each database. This name is often maximo.
In Microsoft SQL Server databases, the database owner is the user who owns the Maximo Asset Management tables. In Microsoft SQL Server configurations, this name is often dbo.
For Oracle databases, the database owner name is the name of the Maximo Asset Management schema owner in each database. This name is often maximo.

About this task

You need to edit only the templates that you use. If you use IBM DB2 as your database, edit the files that have DB2 in the file name. Edit the other templates if you use a different database. You need to edit only the templates for the objects that you archive or restore.

Procedure

Back up the original template files.
Open each template in a text editor application.
Search for all occurrences of <DBALIASNAME>.<DBOWNERNAME>, and replace these names with the alias name and owner name for the production database.
For example, if the alias for your production database is PROD_DB and the schema owner name is MAXIMO, replace <DBALIASNAME>.<DBOWNERNAME> with PROD_DB.MAXIMO.
Search for and replace all occurrences of the <DBALIASNAMEB>.<DBOWNERNAMEB> with the alias name and owner name for the reporting database.
Save each file.

Feedback