Bug 779039 (SOA-1450)

Summary:	schema tool -DB2- jUDDI needs at least 8k page size table space add this note in the documentation
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Jim Ma <ema>
Component:	Documentation	Assignee:	David Le Sage <dlesage>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.3 CP01
Target Milestone:	---
Target Release:	4.3 CP04 ER1
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-1450
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-03-25 08:54:20 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-08-18 10:19:15 UTC

Affects: Documentation (Ref Guide, User Guide, etc.)
Date of First Response: 2009-08-19 04:21:04
project_key: SOA

When use schema tool to switch the database to DB2, the juddi needs at least 8k page size table space to create tables. We can add this content to alert user when configure databse to DB2:
The SOA platform (or jUUDI registry) needs at least 8k page size table space to create tables. Ask your database administrator to check if there is  need to create the large page size table space.

Comment 1 Jim Ma 2009-08-18 10:35:24 UTC

Link: Added: This issue depends SOA-1204

Comment 2 Jim Ma 2009-08-18 10:53:04 UTC

Link: Removed: This issue depends SOA-1204

Comment 3 Jim Ma 2009-08-18 10:53:46 UTC

Link: Added: This issue related SOA-1204

Comment 4 Dana Mison 2009-08-19 08:21:04 UTC

"needs at least 8k page size table space to create tables" doesn't parse too well

is "requires a tablespace with at least an 8 kilobyte pagesize" valid ?

Also I'm assuming kilobyte , not kilobit ?

Comment 5 Jim Ma 2009-08-19 08:50:07 UTC

Yes.  Kilobyte. It should be : 8-KB page size table space.

Comment 6 Dana Mison 2009-08-27 04:26:26 UTC

added as known issue to 4.3.CP02 release notes:

When using DB2 as the database for jUDDI, DB2 must be configured with at least an eight kilobyte pagesize for the creation of tables. You 
need to confirm with your database administrator that this has been done before starting the SOA Platform server using DB2 for jUDDI.

Comment 7 Dana Mison 2009-08-27 04:32:48 UTC

Hi Jim, 

I'm not familar with DB2 & wanted to fill in some additional details

1 - can you supply the SQL command/s that will be required to set this?

Comment 8 Jim Ma 2009-08-27 04:55:55 UTC

Darrin ,I tested the following db2 scripts to create the 8-KB pagesize table space, could be an example for user :

create bufferpool soabp immediate size 1000 pagesize 8k;
create tablespace soats pagesize 8k managed by AUTOMATIC STORAGE BUFFERPOOL soabp;
create temporary tablespace soatempts pagesize 8k managed by AUTOMATIC STORAGE BUFFERPOOL soabp;

Comment 9 Dana Mison 2009-08-28 08:23:00 UTC

Affects: Added: [Documentation (Ref Guide, User Guide, etc.)]

Comment 10 Dana Mison 2009-09-03 00:29:49 UTC

moved FIX version to 4.3.CP03 as per SOA-1357 

removed text regarding this JIRA from the 4.3.CP02 release notes

Comment 11 David Le Sage 2010-02-23 02:10:28 UTC

This information has been added to the Administration Guide for SOA 4.3.CP03.

Comment 12 Jiri Pechanec 2010-03-25 08:54:20 UTC

Verified
http://downtown.englab.bne.redhat.com/drafts/JBoss_Enterprise_SOA_Platform/4.3.CP03/Administration_Guide/html-single/#database_configuration

Comment 14 Len DiMaggio 2011-03-01 19:40:56 UTC

Link: Added: This issue is related to SOA-2951