sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ruiming Zhou (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (SENTRY-260) Add support to use DB2 as database for sentry metastore
Date Mon, 07 Jul 2014 22:25:34 GMT

    [ 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)

Mime
View raw message