Bug 778916 (SOA-1357)

Summary:	Add the content when switch database to DB2 in SOA_ESB_Administrators_Guide
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Jim Ma <ema>
Component:	Documentation	Assignee:	Jim Ma <ema>
Status:	CLOSED WONTFIX	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.3 CP01
Target Milestone:	---
Target Release:	FUTURE
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-1357
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-02-22 19:56:37 UTC	Type:	Task
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Jim Ma 2009-06-05 03:36:00 UTC

Date of First Response: 2009-06-18 03:17:08
project_key: SOA

Large tablespace size is needed when running JBPM on DB2,  so we need to add something to describe the following thing in the switching database section :

If  the configured database is DB2 , please ask database administrator have SYSCTRL or SYSADM authority to execute these statements on this database : 

create bufferpool jbpmbp immediate size 1000 pagesize 32k;
create tablespace jbpmts pagesize 32k managed by AUTOMATIC STORAGE BUFFERPOOL jbpmbp;
create temporary tablespace jbpmtempts pagesize 32k managed by AUTOMATIC STORAGE BUFFERPOOL jbpmbp;

Comment 1 Jim Ma 2009-06-05 03:36:44 UTC

Link: Added: This issue related SOA-1204

Comment 2 Dana Mison 2009-06-18 07:17:08 UTC

According to https://jira.jboss.org/jira/browse/SOA-1237 support for DB2 (and MySQL) is on-hold currently.

You might want to check on that status of that & set this JIRA to fix in the same version as they will be supported.

Comment 3 Jim Ma 2009-06-18 07:55:41 UTC

Certification for DB2 is deferred .Move it to the next release.

Comment 4 Jim Ma 2009-08-18 10:27:45 UTC

Since this the JBPM alread fixed this issue SOA-1437, It does not need to add in documentation.

Comment 5 Jim Ma 2009-08-18 10:31:34 UTC

Link: Added: This issue related SOA-1437

Comment 6 Len DiMaggio 2009-08-27 18:37:44 UTC

We will need these statements documented for the users, but, since DB2 is not supported/certified in CP02, we should delay making the doc change.  Changed the fixed in field to CP03.

Comment 7 Jim Ma 2009-08-28 02:42:23 UTC

Hi Len , 
This issue is initially created for JBPM DB2 support.  Could you clarify if we still need this for JBPM ?
I found JUDDI also needs the large page size table space to create tables , should we also move the SOA-1450 to 4.3 CP03 ?

Thanks

Jim

Comment 8 Jiri Pechanec 2010-03-25 08:58:00 UTC

Does jBPM require 32k pages or not now? If yes then the requirement should be merged with SOA-1450 and the documentation to be updated properly.

Comment 10 trev 2010-03-31 12:46:15 UTC

moved out as DB2 not intended for this release

Comment 11 Len DiMaggio 2011-02-22 19:56:37 UTC

DB2 is not supported with 4.3