Cancel
Showing results for 
Search instead for 
Did you mean: 

Database instance size requirements for Teamcenter

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

Where can we find the database instance size requirements for Oracle and MS SQL ?

Colleagues from IT dept want to know this to configure a DB for sandbox testing environment.

6 REPLIES

Re: Database instance size requirements for Teamcenter

Not aware for MSSQL, but for oracle it will show while installing the instance, please find the attached snapsdb1.PNGdb2.PNG

Re: Database instance size requirements for Teamcenter

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

@GaneshDasmalethanks for your reply. 

Probably my question is misleading. I wanted to know:what is the 'required' size of DB instance for Teamcenter  environment ? Does Simens provide any guidelines for this, just like they provide size of RAM/disk space required ?

Re: Database instance size requirements for Teamcenter

Solution Partner Honored Contributor Solution Partner Honored Contributor
Solution Partner Honored Contributor
Negative. Every customer uses Teamcenter slightly differently depending on their business rules and processes which results in different DB instance sizing. Best practice is to let the installer (TEM) create the instance with auto-growth. You can manually create the instance ahead of time by running pre-defined scripts located in the media. There isn't a required sizing. And afaik, they don't provide RAM/disk sizing requirements either for exactly the same reason. They provide recommendations?

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Database instance size requirements for Teamcenter

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

@RandyEllsworth:Thanks for your response. Good to know about the best practice for DB instance creation and auto-growth option, which I didn't know before.

I actually wanted to say "they provide disk space requirements for Teamcenter installation" (as in the attached image).

 

 

Re: Database instance size requirements for Teamcenter

Solution Partner Honored Contributor Solution Partner Honored Contributor
Solution Partner Honored Contributor
Then in that same vein you could say they provide DB instance disk space requirements in the db creation scripts. See:
BASEMEDIA\tc\db_scripts
PATCHMEDIA\tc\db_scripts

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Database instance size requirements for Teamcenter

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

There is no required size for Teamcenter databases, since they grow with the amount of objects stored.

The DB size has been growing to above 60 GiB within the last ten years for us.

You may want to optimize the DB file size periodically to get rid of unused space.

Stefan Pendl, Systemmanager CAx, HAIDLMAIR GmbH
Production: NX10.0.3, VERICUT 8.1, FBM, MRL 3.1.7 | TcUA 10.1 MP7 Patch 0 (10.1.7.0) | TcVis 11.4
Development: C (ITK), .NET, Tcl/Tk Testing: NX12.0 | AWC 3.4 Preparing: NX12.0

Employees of the customers, together we are strong ;)
How to Get the Most from Your Signature in the Community
NX Customization - Best Practice Guide