MDB Install OverviewforFederated and Shared MDBs.ppt

MDB Install OverviewforFederated and Shared MDBs Revised June 19, 2006 Glossary The following terms and abbreviations are used in this presentation: “HA” = Highly Available “USD” = Unicenter Service Desk “eIAM” = CA eTrust Embedded Identity and Access Management “Federated MDB” = Multiple MDB spread around different servers or multiple sql instances “Shared MDB” = MDB shared by multiple products Objectives The main objective of this presentation is to demonstrate Federated SQL MDB installs of DSM, UAPM, NSM and USD products. DSM and UAPM will the share same MDB. There is no enterprise DSM MDB in this setup Separate NSM MDB will be shared by one or multiple NSM managers. USD MDB will be installed on a separate server. As this is ITIL-based , it will be used as Enterprise (top tier) MDB for all products. In addition, second NSM MDB will be shared with the USD MDB. WV manager will also be installed on the USD MDB server to enable critical objects from NSM MDB to be Bridged to this USD MDB. Federated Shared SQL 2005 MDBs Ingres vs. SQL – which and when Ingres is geared for small to low-medium deployments. It is expected to be used for small sites who have issues with SQL licenses. If SQL licensing is not an issue, then select SQL. It is more scalable and typically requires no additional DB skills Most SQL sites will already have db housekeeping processes in place. This will simplify the implementation as no additional housekeeping process will need to be defined for the MDB Ingres vs. SQL – Platforms Unicenter Desktop and Server Management (DSM) 11.1 supports SQL 2005, SQL 2000 and Ingres Unicenter NSM 11.1 will support SQL 2005 and SQL 2000 Unicenter NSM 11.0 supports Ingres Unicenter Service Desk (USD) 11.2 supports SQL 2005, SQL 2000, Ingres and Oracle Unicenter Asset Portfolio Management (UAPM) 11.1 supports SQL , Ingres and Oracle Oracle ? NSM – No plan date DSM – No plan date DB Users Ingres MDB includes DB users for all products For SQL, the db users are