[
https://issues.apache.org/jira/browse/SENTRY-260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14054245#comment-14054245
]
Ruiming Zhou edited comment on SENTRY-260 at 7/7/14 10:25 PM:
--------------------------------------------------------------
Jarek,
I refresh the patch and it remains about same like the last patch. although it
sounds appealing to make the db2 script smart enough to not relying on the
target database, we think it might not be an issue in practice:
1. First of all, DB2 administrator usually pick a bigger pagesize such as 32K
rather picking a default pagesize 8K in production.
2. If it is not case 1, DB2 administrator can create a another tablespace using
bigger pagesize and move the sentry tables to the feasible table space.
Using the following DB2 statement to create target database for a bigger
pagesize.
CREATE DATABASE TEST1C AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US
COLLATE USING IDENTITY PAGESIZE 32 K
was (Author: [email protected]):
Jarek,
I refresh the patch and it remains about same like the last patch. although it
sounds appealing to make the db2 script smart enough to not relying on the
target database, we think it might not be an issue in practice:
1. First of all, DB2 administrator usually pick a bigger pagesize such as 32K
rather picking a default pagesize 8K in production.
2. If it is not case 1, DB2 administrator can create a another tablespace using
bigger pagesize and move the sentry tables to the feasible table space.
> 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-2.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)
