ESP dSeries Workload Automation

Expand all | Collapse all

Repository Database Upgrade

  • 1.  Repository Database Upgrade

    Posted 08-24-2021 09:45 AM
    Hi all
    We would like to change the OS and DBMS of the DE Manager server to the latest server as follows.
    - DB : Oracle 11.2.0.3 -> 19c (New DB server)
    - OS : AIX 6.1 -> AIX 7.2 (New Server)

    In this case, after installing the WADE Manager on aix 7.2, and export all tables in oracle 11.2.0.3 and import tables to NEW DB (Oracle  19c) ?




  • 2.  RE: Repository Database Upgrade

    Broadcom Employee
    Posted 08-25-2021 08:54 AM
    Hello,
    Are you installing same version of DE in new AIX 7.2?
    If so, then you can use imexutil utility to copy all the artifacts from old server to new server.  The imexutil can only be used between same version of DE servers.  However, this will not move your historical data from ESP_APPLICATION and ESP_GENERIC_JOB.

    If you copy DB tables, then DE will have problem after startup, because DB will have old server information. (Note: Ideally, it's not recommend to copy data like that) . To fix the startup issue, see this KD link
    https://knowledge.broadcom.com/external/article?articleId=198404

    HTH,
    Nitin Pande

    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------