Bug 779039 (SOA-1450) - schema tool -DB2- jUDDI needs at least 8k page size table space add this note in the documentation
Summary: schema tool -DB2- jUDDI needs at least 8k page size table space add this not...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-1450
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Documentation
Version: 4.3 CP01
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 4.3 CP04 ER1
Assignee: David Le Sage
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-08-18 10:19 UTC by Jim Ma
Modified: 2011-03-01 19:40 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2010-03-25 08:54:20 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 780519 0 high CLOSED Add DB2 database configuration commands to SOA-P 5.1 ESB Admin Guide 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-1450 0 None None None Never

Internal Links: 778747 780519

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