We have a habit of calling the machine a database server, because that's its primary purpose. However, the machine is just a computer system that runs a software server that hosts a database. If you keep that distinction in mind, then BMC's recommendation makes a lot of sense. The actual physical machine is a ComputerSystem. The running database software (SQL Server, Oracle, etc.) is a SoftwareServer. Each database instance hosted by a particular software server is a Database.
The way you decide to model it really depends on how you view it and what level of detail you want to track. If each physical server only hosts a single instance of a database server, and you don't care about tracking the details about the database software (e.g., version, patch level, etc.), then it can be convenient to effectively put the two together and track both as simply a Computer System. However, if you have a single physical server that hosts multiple database servers, and you want to track that fact as well as additional information about those servers, then you need to separate things out into different classes. In that case, your class list would probably look more like what I outlined above. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Wednesday, January 06, 2010 2:52 PM To: arslist@ARSLIST.ORG Subject: Re: CMDB 2.0 & Class ** I made all servers (including DB servers) part of BMC_ComputerSystem My databases are under BMC_Database Yes, BMC recommends using BMC_SoftwareServer for database servers. Not sure the logic here.. I imported my assets to the BMC.CORE:BMC_xxxx forms (join). This join form will join the BMC_BaseElement form w/ the correct form. I did NOT use AST:xxxx forms. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Wednesday, January 06, 2010 3:18 PM To: arslist@ARSLIST.ORG Subject: CMDB 2.0 & Class ** Hello All, I have a list of database instances that I will be associating with servers. What table would database instances be stored in? Would the database instance be stored in AST:SoftwareServer table? I read that database servers are modeled a an instance of the BMC_SoftwareServer class. It is getting confusing. Are databases servers considered software servers? I am not sure how to classify the database instances. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"