You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by "Ruiming Zhou (JIRA)" <ji...@apache.org> on 2014/07/08 00:25:34 UTC
[jira] [Comment Edited] (SENTRY-260) Add support to use DB2 as
database for sentry metastore
[ 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: skyapus@yahoo.com):
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)