Author: reschke
Date: Tue Feb 26 13:57:14 2019
New Revision: 1854380
URL: http://svn.apache.org/viewvc?rev=1854380&view=rev
Log:
OAK-8080: RDB*Store: move DB-specific config hints from Javadoc into oak-doc -
hints for DB2
Modified:
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
Modified:
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
URL:
http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md?rev=1854380&r1=1854379&r2=1854380&view=diff
==============================================================================
---
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
(original)
+++
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
Tue Feb 26 13:57:14 2019
@@ -75,6 +75,21 @@ the correct operation:
The subsections below give examples that have been found to work during the
development of `RDBDocumentStore`.
+### <a name="database-creation-db2"></a> DB2
+
+Creating a database called `OAK`:
+~~~
+create database oak USING CODESET UTF-8 TERRITORY DEFAULT COLLATE USING
IDENTITY;
+~~~
+
+To verify, check that INFO level log message written by `RDBDocumentStore`
+upon startup. For example:
+
+~~~
+14:47:20.332 INFO [main] RDBDocumentStore.java:1065 RDBDocumentStore
(SNAPSHOT) instantiated for database DB2/NT64 SQL11014 (11.1), using driver:
IBM Data Server Driver for JDBC and SQLJ 4.19.77 (4.19), connecting to:
jdbc:db2://localhost:50276/OAK, properties: {DB2ADMIN.CODEPAGE=1208,
DB2ADMIN.COLLATIONSCHEMA=SYSIBM, DB2ADMIN.COLLATIONNAME=IDENTITY}, transaction
isolation level: TRANSACTION_READ_COMMITTED (2), DB2ADMIN.NODES: ID
VARCHAR(512), MODIFIED BIGINT, HASBINARY SMALLINT, DELETEDONCE SMALLINT,
MODCOUNT BIGINT, CMODCOUNT BIGINT, DSIZE BIGINT, VERSION SMALLINT, SDTYPE
SMALLINT, SDMAXREVTIME BIGINT, DATA VARCHAR(16384), BDATA BLOB(1073741824) /*
{BIGINT=-5, BLOB=2004, SMALLINT=5, VARCHAR=12} */ /* index DB2ADMIN.NODES_MOD
on DB2ADMIN.NODES (MODIFIED ASC) other (#0, p0), unique index DB2ADMIN.NODES_PK
on DB2ADMIN.NODES (ID ASC) clustered (#0, p0), index DB2ADMIN.NODES_SDM on
DB2ADMIN.NODES (SDMAXREVTIME ASC) other (#0, p0), index DB2ADMIN.NODES_SDT on
DB2ADMIN.NODES (SDT
YPE ASC) other (#0, p0), index DB2ADMIN.NODES_VSN on DB2ADMIN.NODES (VERSION
ASC) other (#0, p0) */
+~~~
+
+
### <a name="database-creation-mysql"></a> MySQL
Creating a database called `OAK`:
@@ -89,7 +104,7 @@ To verify, check that INFO level log mes
upon startup. For example:
~~~
-13:40:46.637 INFO [main] RDBDocumentStore.java:1065 RDBDocumentStore
(SNAPSHOT) instantiated for database MySQL 8.0.15 (8.0), using driver: MySQL
Connector/J mysql-connector-java-8.0.15 (Revision:
79a4336f140499bd22dd07f02b708e163844e3d5) (8.0), connecting to:
jdbc:mysql://localhost:3306/oak?serverTimezone=UTC, properties:
{character_set_database=utf8mb4, character_set_client=utf8mb4,
character_set_connection=utf8mb4, character_set_results=,
max_allowed_packet=8388608, collation_database=utf8mb4_unicode_ci,
character_set_system=utf8, collation_server=utf8mb4_0900_ai_ci,
collation=utf8mb4_unicode_ci, character_set_filesystem=binary,
character_set_server=utf8mb4, collation_connection=utf8mb4_0900_ai_ci},
transaction isolation level: TRANSACTION_REPEATABLE_READ (4), .dstest_nodes: ID
VARBINARY(512), MODIFIED BIGINT(20), HASBINARY SMALLINT(6), DELETEDONCE
SMALLINT(6), MODCOUNT BIGINT(20), CMODCOUNT BIGINT(20), DSIZE BIGINT(20),
VERSION SMALLINT(6), SDTYPE SMALLINT(6), SDMAXREVTI
ME BIGINT(20), DATA VARCHAR(16000), BDATA LONGBLOB(2147483647) /* {BIGINT=-5,
LONGBLOB=-4, SMALLINT=5, VARBINARY=-3, VARCHAR=12} */ /* unique index
oak.PRIMARY on dstest_nodes (ID ASC) other (#0, p0), index oak.dstest_NODES_MOD
on dstest_nodes (MODIFIED ASC) other (#0, p0), index oak.dstest_NODES_SDM on
dstest_nodes (SDMAXREVTIME ASC) other (#0, p0), index oak.dstest_NODES_SDT on
dstest_nodes (SDTYPE ASC) other (#0, p0), index oak.dstest_NODES_VSN on
dstest_nodes (VERSION ASC) other (#0, p0) */
+13:40:46.637 INFO [main] RDBDocumentStore.java:1065 RDBDocumentStore
(SNAPSHOT) instantiated for database MySQL 8.0.15 (8.0), using driver: MySQL
Connector/J mysql-connector-java-8.0.15 (Revision:
79a4336f140499bd22dd07f02b708e163844e3d5) (8.0), connecting to:
jdbc:mysql://localhost:3306/oak?serverTimezone=UTC, properties:
{character_set_database=utf8mb4, character_set_client=utf8mb4,
character_set_connection=utf8mb4, character_set_results=,
max_allowed_packet=8388608, collation_database=utf8mb4_unicode_ci,
character_set_system=utf8, collation_server=utf8mb4_0900_ai_ci,
collation=utf8mb4_unicode_ci, character_set_filesystem=binary,
character_set_server=utf8mb4, collation_connection=utf8mb4_0900_ai_ci},
transaction isolation level: TRANSACTION_REPEATABLE_READ (4), .nodes: ID
VARBINARY(512), MODIFIED BIGINT(20), HASBINARY SMALLINT(6), DELETEDONCE
SMALLINT(6), MODCOUNT BIGINT(20), CMODCOUNT BIGINT(20), DSIZE BIGINT(20),
VERSION SMALLINT(6), SDTYPE SMALLINT(6), SDMAXREVTIME BIGI
NT(20), DATA VARCHAR(16000), BDATA LONGBLOB(2147483647) /* {BIGINT=-5,
LONGBLOB=-4, SMALLINT=5, VARBINARY=-3, VARCHAR=12} */ /* unique index
oak.PRIMARY on nodes (ID ASC) other (#0, p0), index oak.NODES_MOD on nodes
(MODIFIED ASC) other (#0, p0), index oak.NODES_SDM on nodes (SDMAXREVTIME ASC)
other (#0, p0), index oak.NODES_SDT on nodes (SDTYPE ASC) other (#0, p0), index
oak.NODES_VSN on nodes (VERSION ASC) other (#0, p0) */
~~~
