[
https://issues.apache.org/jira/browse/SENTRY-260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14036717#comment-14036717
]
Ruiming Zhou edited comment on SENTRY-260 at 6/19/14 12:22 AM:
---------------------------------------------------------------
Your DB2 (express) version may be ok. It is the database set up. the default
pagesize can be specified at database creation time. If they are not, a default
page size (4k) will be taken for the database by DB2, which is too small in
this sentry schema because it use a previllege_name column size 4k for index,
that required a big pagesize more than the default.
example to specify the pagesize for database, which I use 32K pagesize.
CREATE DATABASE TEST1C AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US
COLLATE USING IDENTITY PAGESIZE 32 K
However, we are thinking about including the bufferpool and pagesize DDL in the
db2 script instead of using the default one. Will add another patch later once
I have it.
was (Author: [email protected]):
Your DB2 (express) version may be ok. It is the database set up. the default
pagesize can be specified at database creation time. If they are not, a default
page size (4k) will be taken for the database by DB2, which is too small in
this sentry schema because it use a previllege_name column has size 4k for
index, that required a big pagesize more than the default.
example to specify the pagesize for database, which I use 32K pagesize.
CREATE DATABASE TEST1C AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US
COLLATE USING IDENTITY PAGESIZE 32 K
However, we are thinking about including the bufferpool and pagesize DDL in the
db2 script instead of using the default one. Will add another patch later once
I have it.
> Add support to use DB2 as database for sentry metastore
> --------------------------------------------------------
>
> Key: SENTRY-260
> URL: https://issues.apache.org/jira/browse/SENTRY-260
> Project: Sentry
> Issue Type: Bug
> Affects Versions: 1.4.0
> Reporter: Ruiming Zhou
> Assignee: Ruiming Zhou
> Labels: newbie
> Fix For: 1.4.0
>
> Attachments: SENTRY-260-1.patch, SENTRY-260.patch
>
>
> Currently Sentry supports derby, mysql, oracle, postgres to back its
> Metastore. We like to have DB2 database to be supported.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
