Question & Answer
Question
How can I revoke the changes made to the Object Server after running aggregation_primary.sql?
Cause
Rollback files can be used to undo the changes.
Answer
In order to undo the changes to the object server, the rollback files can be used.
A rollback file will do as the name suggests and undo the modifications the solution delivery SQL file makes to an ObjectServer.
In the $NCHOME/omnibus/extensions/multitier/objectserver directory, the aggregation_rollback.sql script is provided to roll back the changes that the aggregation.sql script makes to the ObjectServer, if required. You can apply this rollback script by using the nco_sql or isql utility with the syntax below for applying the aggregation_rollback.sql script :
$NCHOME/omnibus/bin/nco_sql -server AGG_P -user root –password password < $NCHOME/omnibus/extensions/multitier/objectserver/aggregation_rollback.sql
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"ARM Category":[{"code":"a8m500000008aAKAAY","label":"Core Omnibus->ObjectServer nco_objserv"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"8.1.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Product Synonym
Omnibus
Was this topic helpful?
Document Information
Modified date:
29 April 2020
UID
ibm16202768