federated mdbs with multiple sql instances
DESCRIPTION
Federated MDBs with Multiple SQL Instances. Last Revision Date: September 6, 2006. Glossary. The following terms and abbreviations are used in this presentation: “HA” = Highly Available “UAPM” – Unicenter Asset Management Portfolio “USD” = Unicenter Service Desk - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/1.jpg)
Federated MDBs with Multiple SQL Instances
Last Revision Date: September 6, 2006
![Page 2: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/2.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Glossary- The following terms and abbreviations are used in this presentation:- “HA” = Highly Available- “UAPM” – Unicenter Asset Management Portfolio- “USD” = Unicenter Service Desk- “DSM” – Unicenter Desktop Server Management- “eIAM” = CA eTrust Embedded Identity and Access Management
- “MSCS” = Microsoft Cluster Server- “NSM” = Unicenter Network System Management
![Page 3: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/3.jpg)
Overview
![Page 4: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/4.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Objectives- The objective of this document is not to discuss MDB
Federation or what products should share MDB. For a detailed discussion of MDB federation and deployment choices consult the MDB Federation presentation instead
- The main objective of this presentation is to review the implications of installing multiple SQL MDBs on a single server having multiple SQL instances. Additional information is provided regarding the install of multiple SQL MDBs in a Microsoft cluster environment
- These discussions assume that you have already reviewed the MDB Federation presentation and wish to pursue federation on the same server or same cluster
![Page 5: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/5.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Why use multiple SQL instances?- Reduce cost of ownership
- If correctly planned, the normal mode of operation in a Microsoft Cluster environment can include active SQL instances on different nodes of the cluster. This provides federation without overloading single cluster node.
- In the event of a failover both SQL instances can potentially be active on the same node. - This would not be classified as “normal” mode of
operation
![Page 6: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/6.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Default SQL Instance- Some products do not support named SQL instances. DSM is one of these, but it is targeted to support named instances soon.- Although DSM will install correctly using named SQL instances, there are some issues with named SQL instances
- Therefore, if DSM is being installed in an environment using multiple SQL instances, one of the SQL instances should be the default instance.
![Page 7: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/7.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Multiple MDBs – one Product- Installing multiple MDBs for the same product on the same server can cause the product to malfunction and, in some cases, the install process will prevent it from being installed.
- NSM install process prevents multiple MDBs from being created on different SQL instances running on the same server.- Several NSM components caches repository (MDB) details. If MDB location is changed password and MDB details must be updated for all of these components
![Page 8: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/8.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
NSM and Multiple MDBs- NSM MDB has been locked down with named SQL instance (SQLINSTA)
- Install processes attempts to create another NSM MDB on a default instance
- Install process for subsequent NSM MDBs will prevent override of the database server or SQL instance details
![Page 9: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/9.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
NSM and Multiple MDBs
This shows multiple NSM MDBs cannot be created on the same server
![Page 10: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/10.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
SQL Instances
This shows default and named SQL instances – each with an MDB
![Page 11: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/11.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Multiple SQL Instances
This shows cluster setup with default and named SQL instances each having an MDB spread across different products
![Page 12: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/12.jpg)
Install Summary for Cluster and Non-cluster
Configurations
![Page 13: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/13.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Single Server - Multiple MDB Instances
USD MDBDSM MDBNSM MDB
NSM Managers
Default InstanceMDB
Database Server
Named SQL Instance
SQL Named InstanceSQLINSTA
NSMMDB
SQL Default InstanceDSMUSD
MDB
NSM WorldviewEnterprise MgtWV Provider
eIAM – Ingres Instance
Multiple MDB instancesThis shows non-cluster setup with multiple SQL MDBs
![Page 14: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/14.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Single Server: USD – Default Instance- Here USD MDB is installed on a default SQL instance while NSM MDB exists on the named SQL instance
- In addition, eIAM is selected (this will install Ingres ET instance, as well)
![Page 15: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/15.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Single Server: NSM – Named Instance- Here NSM MDB is created on named SQL instance while USD MDB already exists in the default SQL instance
![Page 16: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/16.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Single Server: SQL Instances
This shows two MDBs on different SQL instances installed on the same server
![Page 17: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/17.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Single Server: SQL Instances Services
![Page 18: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/18.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Cluster Setup- This shows two SQL instances - default and named. Each instance will have MDB based on the MDB deployment choices discussed in the Federation presentation
![Page 19: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/19.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Cluster Setup: DSM MDB Install- This shows DSM MDB installed on the default SQL Instance which it shares with USD and UAPM. NSM MDB will be installed on a named instance
![Page 20: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/20.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Cluster Server: SQL Setup- This shows two SQL instances, each with an MDB in a Microsoft Cluster setup
![Page 21: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/21.jpg)
Gotchas
![Page 22: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/22.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Considerations- There should not be any special considerations for installing multiple MDBs on the same server using different SQL instances or for installing in a Microsoft Cluster environment using multiple SQL instances.
- The considerations listed in this section are not specific to multiple MDBs on the same cluster or server
![Page 23: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/23.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
USD and DSM Install order- If USD and DSM will share an MDB, install DSM first. Otherwise, you may experience 1603 error (The setup here was USD 11.2 and DSM 11.1a without C1 fix)
![Page 24: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/24.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
DSM Install MDB- DSM may identify existence of previous MDB and generate a dialog box which may be irrelevant for SQL MDB
![Page 25: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/25.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
System Path- Unicenter NSM install validates the system path length, computing the length of system path entry based on NSM products selected. If the computed length exceeds 1024 bytes the install will not continue
- If multiple products are installed, it is likely the system path length will be exceeded
![Page 26: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/26.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
System Path Prior to Install
This shows system path prior to installing any NSM components. The path entries listed above include pre-installed DSM Agent + Software delivery plug-in, eTrust Antivirus option, and USD eIAM option
![Page 27: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/27.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Path Length Exceeded
![Page 28: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/28.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Circumvention- To circumvent this potential problem, change the location of
CA Common Services from “\Program Files\CA\SharedComponents” to “\CA\SharedComponents”
- Alternatively, shorten path length by changing existing entries to short name (8dot3 format). For example: - C:\Program Files\CA\eTrust Directory\dxserver\bin to- C:\Progra~1\CA\eTrust~2\dxserver\bin
- User dir /X to option convert to 8dot3 format- Remove duplicate entries
![Page 29: Federated MDBs with Multiple SQL Instances](https://reader036.vdocuments.us/reader036/viewer/2022081507/56816335550346895dd3bfc9/html5/thumbnails/29.jpg)
Copyright ©2006 CA. All rights reserved. All trademarks, trade names, services marks and logos referenced herein belong to their respective companies.
Directory Name Shortened
Changed CA Common Services location from \Program Files\CA\SharedComponents to \CA\SharedComponents