Fixing Active Policies
This section includes instructions for the relevant collected subsystems.
EMC Avamar Policies
1. Create a backup table and include the policy IDs that are failing during upgrade.
CREATE TABLE apt_cxml_emc_avamar_bkp AS SELECT * FROM apt_cxml_emc_avamar
WHERE cxml_emc_avamar_id IN (?,?);
2. Delete these failing policies from the original table.
DELETE FROM apt_cxml_emc_avamar WHERE cxml_emc_avamar_id IN (?,?);
COMMIT;
3. Start the Upgrader.
4. If the policy is INVALID as per the pre-check, then delete the policy.
DELETE FROM apt_cxml_emc_avamar_bkp WHERE cxml_emc_avamar_id = ?;
COMMIT;
5. If the policy is not marked as Invalid, then for every cxml_emc_avamar_id that has failed validation, pick up the server_instance_id from the suggestions and update in the table.
ALTER TABLE apt_cxml_emc_avamar_bkp ADD server_instance_id NUMBER(6,0);
UPDATE apt_cxml_emc_avamar_bkp SET server_instance_id = ? WHERE
cxml_emc_avamar_id = ?;
6. Copy the policy back into the main table.
INSERT INTO apt_cxml_emc_avamar SELECT * FROM apt_cxml_emc_avamar_bkp WHERE
cxml_emc_avamar_id = ?;
COMMIT;
7. Find the collectors to which the previous updated policies belong. For every such collector, run the following update statement.
UPDATE apt_collector_properties SET is_dirty = 'Y' WHERE collector_id = ?;
COMMIT;
IBM TSM Policies
1. Create a backup table and include the policy IDs that are failing during upgrade.
CREATE TABLE apt_cxml_tsm_bkp AS SELECT * FROM apt_cxml_tsm WHERE
cxml_tsm_id IN (?,?);
2. Delete these failing policies from the original table.
DELETE FROM apt_cxml_tsm WHERE cxml_tsm_id IN (?,?);
COMMIT;
3. Start the Upgrader.
4. If the policy is INVALID as per the pre-check, then delete the policy.
DELETE FROM apt_cxml_tsm_bkp WHERE cxml_tsm_id = ?;
COMMIT;
5. If the policy is not marked as Invalid, then for every cxml_tsm_id that has failed validation, pick up the server_instance_id from the suggestions and update in the table.
ALTER TABLE apt_cxml_tsm_bkp ADD server_instance_id NUMBER(6,0);
UPDATE apt_cxml_tsm_bkp SET server_instance_id = ? WHERE cxml_tsm_id = ?;
6. Copy the policy back into the main table.
INSERT INTO apt_cxml_tsm SELECT * FROM apt_cxml_tsm_bkp WHERE cxml_tsm_id =?;
COMMIT;
7. Find the collectors to which the previous updated policies belong. For every such collector, run the following update statement.
UPDATE apt_collector_properties SET is_dirty = 'Y' WHERE collector_id = ?;
COMMIT;
EMC NetWorker Policies
1. Create a backup table and include the policy IDs that are failing during upgrade.
CREATE TABLE apt_cxml_emc_networker_bkp AS SELECT * FROM
apt_cxml_emc_networker WHERE cxml_emc_networker_id IN (?,?);
2. Delete these failing policies from the original table.
DELETE FROM apt_cxml_emc_networker WHERE cxml_emc_networker_id IN (?,?);
COMMIT;
3. Start the Upgrader.
4. If the policy is INVALID as per the pre-check, then delete the policy.
DELETE FROM apt_cxml_emc_networker_bkp WHERE cxml_emc_networker_id = ?;
COMMIT;
5. If the policy is not marked as Invalid, then for every cxml_emc_networker_id that has failed validation, pick up the server_instance_id from the suggestions and update in the table.
ALTER TABLE apt_cxml_emc_networker_bkp ADD server_instance_id NUMBER(6,0);
UPDATE apt_cxml_emc_networker_bkp SET server_instance_id = ? WHERE
cxml_emc_networker_id = ?;
6. Copy the policy back into the main table.
INSERT INTO apt_cxml_emc_networker SELECT * FROM apt_cxml_emc_networker_bkp
WHERE cxml_emc_networker_id = ?;
COMMIT;
7. Find the collectors to which the previous updated policies belong. For every such collector, run the following update statement.
UPDATE apt_collector_properties SET is_dirty = 'Y' WHERE collector_id = ?;
COMMIT;
HP Data Protector Policies
1. Create a backup table and include the policy IDs that are failing during upgrade.
CREATE TABLE apt_cxml_hp_dataprotector_bkp AS SELECT * FROM
apt_cxml_hp_dataprotector WHERE cxml_hp_dataprotector_id IN (?,?);
2. Delete these failing policies from the original table.
DELETE FROM apt_cxml_hp_dataprotector WHERE cxml_hp_dataprotector_id IN (?,?);
COMMIT;
3. Start the Upgrader.
4. If the policy is INVALID as per the pre-check, then delete the policy.
DELETE FROM apt_cxml_hp_dataprotector_bkp WHERE cxml_hp_dataprotector_id = ?;
COMMIT;
5. If the policy is not marked as Invalid, then for every cxml_hp_dataprotector_id that has failed validation, pick up the server_instance_id from the suggestions and update in the table.
ALTER TABLE apt_cxml_hp_dataprotector_bkp ADD server_instance_id NUMBER(6,0);
UPDATE apt_cxml_hp_dataprotector_bkp SET server_instance_id = ? WHERE
cxml_hp_dataprotector_id = ?;
6. Copy the policy back into the main table.
INSERT INTO apt_cxml_hp_dataprotector SELECT * FROM
apt_cxml_hp_dataprotector_bkp WHERE cxml_hp_dataprotector_id = ?;
COMMIT;
7. Find the collectors to which the previous updated policies belong. For every such collector, run the following update statement.
UPDATE apt_collector_properties SET is_dirty = 'Y' WHERE collector_id = ?;
COMMIT;
Generic Backup Policies
1. Create a backup table and include the policy IDs that are failing during upgrade.
CREATE TABLE apt_cxml_generic_bkp_bkp AS SELECT * FROM apt_cxml_generic_bkp
WHERE cxml_generic_bkp_id IN (?,?);
2. Delete these bad policies from the original table.
DELETE FROM apt_cxml_generic_bkp WHERE cxml_generic_bkp_id IN (?,?);
COMMIT;
3. Start the Upgrader now. It should succeed.
4. If the policy is INVALID as per the pre-check, then delete the policy.
DELETE FROM apt_cxml_generic_bkp_bkp WHERE cxml_generic_bkp_id = ?;
COMMIT;
5. If the policy is not marked as Invalid, then for every cxml_generic_bkp_id that has failed validation, pick up the server_instance_id from the suggestions and update in the table.
ALTER TABLE apt_cxml_generic_bkp_bkp ADD server_instance_id NUMBER(6,0);
UPDATE apt_cxml_generic_bkp_bkp SET server_instance_id = ? WHERE
cxml_generic_bkp_id = ?;
6. Now copy the policy back into the main table.
INSERT INTO apt_cxml_generic_bkp SELECT * FROM apt_cxml_generic_bkp_bkp
WHERE cxml_generic_bkp_id = ?;
COMMIT;
7. Find the collectors to which the above updated policies belong. For every such collector, run the following update statement.
UPDATE apt_collector_properties SET is_dirty = 'Y' WHERE collector_id = ?;
COMMIT;