This chapter provides reference information for Oracle Communications Billing and Revenue Management (BRM) Account Migration utilities.
Use this utility to migrate accounts from a source database schema to a destination database schema in the same BRM database.
When you use Oracle IMDB Cache in your environment, this utility also migrates account objects from the source Oracle IMDB Cache (associated with the source BRM database schema) to the destination Oracle IMDB Cache (associated with the destination BRM database schema).
You define which accounts to migrate in the account search configuration file in the BRM_home/apps/amt directory. See "Creating the Account Search Configuration File".
Note:
To connect to the BRM database, the pin_amt utility needs a configuration file in the BRM_home/sys/amt directory. For information on how to create this file, see "Connecting AMM to Your Database Schemas".pin_amt [-f ConfigFileName] [-a ControllerID] [-c start | stop | pause | continue | status | log] [-s AccountSearchFile] [-d JobID] [-r list_jobs | job_details | group_details] [-p SourceDatabaseSchema] [-e JobID][-b JobID:BatchNumber][-h]
Specifies the name of the configuration file that defines how to connect to each database schema in your system. By default, the pin_amt utility looks in the BRM_home/sys/amt directory. If your configuration file is located in a different directory, you must specify the entire path for the file.
If you use the BRM_home/sys/amt/Infranet.properties file, you can ignore this parameter.
Specifies the AMM Controller to use.
Use this option only with the -c option and only when your system contains multiple AMM Controllers. If your system contains only one AMM Controller, ignore this option.
Sets the AMM Controller. When your system contains multiple AMM Controllers, you must also use the -a option.
Use one of these options with the parameter:
-c start starts the AMM Controller.
-c stop stops the AMM Controller. If you stop the AMM Controller while it is processing a batch, it finishes processing the batch before stopping.
-c pause pauses the processing of a job in the queue. If you pause the Controller while it is processing a batch, it finishes processing the batch before pausing.
-c continue restarts processing a job that was paused.
-c status displays the current status of the AMM Controller.
-c log displays all AMM Controller transactions in real time through an Xterm window. To use this option, you must set the DISPLAY environment variable correctly.
Specifies the name of the configuration file that defines which accounts to migrate. For information on how to create the file, look at the sample account search configuration file (BRM_home/apps/amt/account_search.cfg).
By default, the pin_amt utility looks in the current working directory. If your configuration file is located in a different directory, you must specify the entire path for the file.
Deletes the specified job from the job management tables. When deleting a job that migrated successfully, this option also purges all migrated accounts from the source database schema.
Enables the specified job in the queue.
Runs the preconfigured report. Use one of these options with the parameter:
-r list_jobs displays the status of all jobs currently in the queue.
-r job_details displays the details of the specified job.
-r group_details displays the details of the specified account group.
Purges all accounts that were successfully migrated from the source database schema. For example, to purge invalid objects from your primary schema, enter the following:
pin_amt -p 0.0.0.1
Displays the syntax and parameters for this utility.
Changes the status of the batch from FAILED to NOT PROCESSED, and the job from FINISHED to DISABLED. For information, see "About Batch Status Flags" and "About Job Status Flags".
The pin_amt utility notifies you when it successfully completes a command.
For error information about each job, run a report or look in the AMM Mover log file. The log file is in the directory specified by the 0.0.0.x_mover_log_file_dir entry in the Infranet.properties file.
For error information about the AMM Controller, look in the AMM Controller log file. The log file is in the directory specified by the controller_N_log_directory entry in the Infranet.properties file.
The history of all pin_amt commands is located in the pin_amt log file.
Use this utility to test your custom BRM account search criteria. This utility safely executes your search criteria against a source database schema and displays either a SQL SELECT statement or a list of account POIDs meeting your search criteria.
You define which custom search criteria to test in the account search configuration file (BRM_home/apps/amt/account_search.cfg). See "Creating the Account Search Configuration File".
Note:
To connect to the BRM database, the pin_amt_test utility needs a configuration file in the BRM_home/sys/amt directory. For information on how to create this file, see "Connecting AMM to Your Database Schemas".Specifies the name of the configuration file that defines how to connect to each database schema in your system. By default, the pin_amt_test utility looks in the BRM_home/sys/amt directory. If your configuration file is located in a different directory, you must specify the entire path for the file.
If you use the BRM_home/sys/amt/Infranet.properties file, you can ignore this parameter.
Displays the SQL SELECT statement generated with the account search criteria specified in AccountSearchFile.
By default, the pin_amt_test utility looks in the current working directory. If your account search file is located in a different directory, you must specify the entire path for the file.
Executes the SQL SELECT statement for the specified search criteria against the source database schema and displays the list of account POIDs meeting the search criteria.
By default, the pin_amt_test utility looks in the current working directory. If your account search file is located in a different directory, you must specify the entire path for the file.
Displays the syntax and parameters for this utility.
Use this utility to migrate accounts from one logical partition to another logical partition in the same Oracle IMDB Cache grid.
You define which accounts to migrate in the account search configuration file in the BRM_home/apps/amt_tt directory. See "Configuring the pin_amt_tt Utility".