Bug 778916 (SOA-1357) - Add the content when switch database to DB2 in SOA_ESB_Administrators_Guide
Summary: Add the content when switch database to DB2 in SOA_ESB_Administrators_Guide
Keywords:
Status: CLOSED WONTFIX
Alias: SOA-1357
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Documentation
Version: 4.3 CP01
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: FUTURE
Assignee: Jim Ma
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-06-05 03:36 UTC by Jim Ma
Modified: 2011-02-22 19:56 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2011-02-22 19:56:37 UTC
Type: Task
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 778747 0 high CLOSED schema tool - DB2 setup.sql script includes commands that require SYSCTRL or SYSADM authority 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 779025 0 high CLOSED DB2 and Sybase jBPM database schema incompatibilities 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-1357 0 None None None Never

Internal Links: 778747 779025

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
Note You need to log in before you can comment on or make changes to this bug.