7.1 DBs - installation and sizing

Please excuse the duplication. I posted this same question in the Installation forum last week and got a handful of views but no responses - so I thought it may get more action in the TeamSite forum.

Hi DevNetters -
We're building out a new test 7.1 TeamSite installation on a Solaris LDOM. After looking through the various installation-related materials, we're at the point that, just about first thing, we need to install a few (Oracle 10i) database schemas. Here are a few questions about that process:

1) Are there any size estimates available on how large iwcommon, iwevents and iwsitepub dbs will grow, given a medium amount of development activity?

2) Is there a way to test the o/jdbc connectivity from the dev server to the new dbs before executing the install process and just 'seeing if it works?'

3) Are db 'pruning' processes provided - assuming that the dbs will continue to grow? For the one existing db we use with our 6.7.1 prod install (OpenDeploy Reporting), we needed to look into the db itself (no ERD or table info was provided), figure out the relationships between the table and then build our own SQL statements to periodically run and clean out old rows of content. If that's what we have to do with these new dbs, we have to allocate some time for this work.

If you have any input / experiences on these above points, any help is appreciated.

Thanks!
Wally
Nike, Inc.

Find more posts tagged with

Comments

ISCBorisB

Please excuse the duplication. I posted this same question in the Installation forum last week and got a handful of views but no responses - so I thought it may get more action in the TeamSite forum.

Hi DevNetters -
We're building out a new test 7.1 TeamSite installation on a Solaris LDOM. After looking through the various installation-related materials, we're at the point that, just about first thing, we need to install a few (Oracle 10i) database schemas. Here are a few questions about that process:

1) Are there any size estimates available on how large iwcommon, iwevents and iwsitepub dbs will grow, given a medium amount of development activity?

2) Is there a way to test the o/jdbc connectivity from the dev server to the new dbs before executing the install process and just 'seeing if it works?'

3) Are db 'pruning' processes provided - assuming that the dbs will continue to grow? For the one existing db we use with our 6.7.1 prod install (OpenDeploy Reporting), we needed to look into the db itself (no ERD or table info was provided), figure out the relationships between the table and then build our own SQL statements to periodically run and clean out old rows of content. If that's what we have to do with these new dbs, we have to allocate some time for this work.

If you have any input / experiences on these above points, any help is appreciated.

Thanks!
Wally
Nike, Inc.

Contact Support. The request is reasonable - and it seems that not many Forum Contributors have your HW/SW combination
(TS 7.1 + Solaris + Oracle 10i)

Migrateduser

Good idea - I went ahead and put in a Support request.

On the other hand, I'm doubtful that the db size / functionality will be significantly different from platform to platform.

Generally, it looks like any of the platforms can select any of the dbs and I bet the schemas created are pretty much the same and the number of calls to the various dbs are similar also.

So any information, regardless of platform, is appreciated!

Thanks,
Wally

Migrateduser

After a few months of waiting for Engineering responses from Support, I closed my Support ticket on this issue with no resolution. Basically, we're mostly on our own to understand / administer the back end db. Smiley Sad

Crsb

yep, that is a typical way of how interwoven handles that type of requests. they don't mention anything in docs about DB sizing or configurations. they wont provide that info even if you requested it. the only time you might get some answer is if you were really lucky and your ticket was handled by an experienced engineer or tech support who can answer from their experience and give you some guidelines. But don't expect a specific answer or numbers since the envs and usage differ greatly between customers.

1) Are there any size estimates available on how large iwcommon, iwevents and iwsitepub dbs will grow, given a medium amount of development activity?

events DB doesn't usually grow much over time since the messages get deleted as they are processed, i would allocated 2GB for this. you have sitepublisher DB and reporting DB, this really depends on the amount of content and activities you generate every day. i have no formula behind this but i would allocate 15GB to be in safest

2) Is there a way to test the o/jdbc connectivity from the dev server to the new dbs before executing the install process and just 'seeing if it works?'

the installer will test the connection for you and it won't move forward if the DB connection is not working.

-- again there are no official guidelines or best practices when it comes to sizing and configuring the DBs for TeamSite. you should just go with safest route possible and watch your DBs to learn how they grow and how to handle them in the future.

msrinivas

the installer will test the connection for you and it won't move forward if the DB connection is not working.

Unfortunately, this is not entirely true. It does that when you are supplying the credentials as part of the installer.

But in the post-install configuration, the installer has a 10min timeout for the IR Database connection used by Application Container/JBoss and if there are issues it will quit saying the post-install steps were unsuccessful. You have to sift through the install log to see what went wrong.