Merge lp:~kwmonroe/charms/trusty/db2/deprecate into lp:~ibmcharmers/charms/trusty/db2/trunk

Proposed by Kevin W Monroe
Status: Merged
Merged at revision: 5
Proposed branch: lp:~kwmonroe/charms/trusty/db2/deprecate
Merge into: lp:~ibmcharmers/charms/trusty/db2/trunk
Diff against target: 182 lines (+6/-158)
2 files modified
README.md (+3/-153)
metadata.yaml (+3/-5)
To merge this branch: bzr merge lp:~kwmonroe/charms/trusty/db2/deprecate
Reviewer Review Type Date Requested Status
Suchitra Venugopal Approve
Review via email: mp+285972@code.launchpad.net

Description of the change

Please merge this deprecation notice since this charm should be replaced by ibm-db2.

To post a comment you must log in.
Revision history for this message
Suchitra Venugopal (suchvenu) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'README.md'
2--- README.md 2015-08-18 06:30:00 +0000
3+++ README.md 2016-02-13 18:13:12 +0000
4@@ -1,153 +1,3 @@
5-Charm for IBM DB2 10.5
6-
7-Overview
8---------
9-
10-IBM DB2
11-
12-IBM DB2 Express Server Edition is an entry level database system designed
13-for transaction processing and handling complex query workloads.
14-DB2 Server is provided as part of this charm.
15-
16-For details on DB2, as well as information on purchasing, please visit:
17-[Product Page][product-page]
18-There is product information there and contact information to obtain a
19-quote and arrange the DB2 packages provided by IBM or you can purchase
20-and download directly there.
21-
22-More information available at the [IBM Knowledge Center][ibm-db2]
23-
24-Usage
25-------
26-To install DB2, you need to download the packages for Ubuntu and create a
27-apt repository. To acquire and download DB2, follow instructions available at the [Product Page][product-page]
28-The Part Number used is CIXV0ML for X86-64 platform and that for Power is CN3YQML .
29-
30-To install the downloaded binaries you must agree to the IBM license. You can view the full license for DB2 by visiting the [Software license agreements search website][license-info]. Search for "DB2 Enterprise Server Edition 10.5.0.5" and choose the license that applies to the version you are using.
31-
32-#Creating the repositories
33-Run steps below with admin access
34-
35-Install needed packages
36- apt-get install dpkg-dev apache2
37-
38-Create the repository on apache server
39-Under your apache repository directory
40- cd <apache-repository-directory>
41- mkdir DB2
42-Place the downloaded tar.gz file in the above directory
43-
44-Configure apache server to allow access to the repository
45-Configure config.yaml with the repository url
46-db2_url: "http://<server-name>/<REPOSITORY_DIR>/DB2"
47-
48-
49-Verify repository is set correctly otherwise charm might throw errors.
50-
51- Deploy
52--------
53-To deploy DB2 charm run the following command:
54-
55-For that either use an existing machine, or create a new machine using
56-
57- juju add-machine
58- juju deploy --to <machine number> --repository=<path_to_charms_folder> local:trusty/db2
59-
60-At this point DB2 install will wait for you to accept the License. To install the downloaded binaries you must agree to the IBM license. The license file(s) can be found in the product binaries you downloaded.
61-
62-If you agree to the license, run the following command (without accepting License DB2 cannot be installed):
63-
64-If the URL and package is configured in the config.yaml:
65-
66- juju set db2 accept-ibm-db2-license=True
67-If not,
68-
69- juju set db2 accept-ibm-db2-license=True db2_url=<DB2 URL> db2_package_name=<DB2 Package name>
70-
71-Juju deploy command will install db2 and will expose the hostname, portnumber, db2 instance and userid to the users.
72-Setting the accept-ibm-db2-license to False will uninstall the product.
73-
74- juju set db2 accept-ibm-db2-license=False
75-
76-If the user wants to set a different file path used to create databases and logs it can be set using the config value dftdbpath. Use the following command to set it
77-
78- juju set db2 dftdbpath=<new-path-to-set>
79-
80-
81-Configuration
82--------------
83-See config.yaml file for more information.
84-
85- `db2_url` : The web server URL from which IBM DB2 packages can be downloaded.
86-
87- `db2_package_name` : The db2 package name to be installed. This name can be got from the b2_url path in the repository. If not set, it is assigned the value "DB2_Svr_10.5.0.3_Linux_x86-64.tar.gz" for x86_64 based machine.
88-
89- `accept-ibm-db2-license`: True to accept license Before you can use or install IBM DB2, you must accept the terms of International License Agreement for Non-Warranted Programs and additional license information. Please read the license agreement carefully. The license file(s) can be found under the server/db2/license directory after downloading and extracting IBM DB2 there. Set the value of accept-ibm-db2-license to True if you agree to IBM DB2 license.
90-
91- `sha` : Checksum value to check integrity of IBM DB2 package. The Charm uses sha1sum to check the integrity. If empty, it does not carry out the integrity check.Cryptographic value should be altered by the user only when the package name is changed. Else it should not be altered.The command to find the checksum is sha1sum <Package Name> | cut -d" " -f1.
92-
93- `dftdbpath` : This parameter contains the default file path used to create databases under the database manager. If no path is specified when a database is created, the database is created under the path specified by the dftdbpath parameter.
94-
95-Memory and Disk Requirements
96-----------------------------
97-Memory requirements are affected by the size and complexity of your database system, the extent of database activity, and the number of clients accessing your system. At a minimum, a DB2 database system requires 256 MB of RAM. For a system running just a DB2 product and the DB2 GUI tools, a minimum of 512 MB of RAM is required. However, 1 GB of RAM is recommended for improved performance.
98-
99-On Linux and UNIX operating systems, 2 GB of free space in the /tmp directory is recommended. On Linux and UNIX operating systems, you must install your DB2 product in an empty directory. If the directory that you have specified as the install path contains subdirectories or files, your DB2 installation might fail. More information on this can be found in [db2-memory-disk-requirement]
100-
101-Enabling BLU acceleration for DB2 Advanced Enterprise Server Edition
102----------------------------------------------------------------------
103-The same DB2 charm(DB2 Enterprise Server Edition) can be extended to enable the BLU acceleration(DB2 Advanced Enterprise Server Edition with BLU acceletaion) by following the below section. The DB2 charm has to be deployed first and then few settings needs to be done to enable the BLU feature.
104-
105-To upgrade DB2 Enterprise Server Edition (DB2 ESE) to DB2 Advanced Enterprise Server Edition(DB2 AESE) the user need to accept the license for the same. Run the following command for accepting the AESE license which the user procure when he buy the product.
106-
107- db2licm -a </path/to/license/file/db2aese_u.lic>
108-
109-db2licm -l command will show the license details once you apply the license.
110-Now to enable the BLU feature the DB2_WORKLOAD registry variable has to be set to ANALYTICS and then the DB has to be restarted. The following commands will help the user for this.
111-
112- db2set DB2_WORKLOAD=ANALYTICS
113- db2stop force
114- db2start
115-
116-To test that DB2 AESE with BLU acceleration is enabled run the following command:
117-
118- db2 get db cfg | grep DFT_TABLE_ORG
119-
120-The output Default table organization (DFT_TABLE_ORG) = COLUMN confirms that the DB2 AESE with BLU is enabled. If the pre requisites for DB2 for AESE is not set (accepting the proper license and setting the registry varaible DB2_WORKLOAD) the above command would return Default table organization (DFT_TABLE_ORG) = ROW. Column-organized tables store each column on a separate set of pages on disk. Organizing data by column on disk reduces the amount of I/O needed for processing queries because only columns that are referenced in a query need to be accessed.
121-
122-Once this is set all the tables created will be by default COLUMN organised where as without BLU acceleration the tables will be ROW organised. Also without proper license we cannot create COLUMN organised tables. Once we enable COLUMN organised tables, we can create either ROW enabled or COLUMN enabled tables using the option ORGANIZE BY COLUMN or ORGANIZE BY ROW while creating the tables.
123-
124-The following command will convert the ROW organised tables to COLUMN organised if the proper license is accepted. Without having valid license the following command will error out.
125-
126- db2convert -d <db_name>
127-
128-More details on BLU feature can be found in the link [db2-BLU-acceleration]
129-
130-IBM DB2 Information
131--------------------
132-
133-(1) General Information
134-Information on IBM DB2 available at the [DB2 Knowledgecenter][db2-knowledgecenter]
135-
136-(2) Download Information
137-Information on procuring DB2 product is available at the [Passport Advantage Site][passport-db2]
138-
139-(3) Contact Information
140-For issues with this charm, please contact <jujusupp@us.ibm.com>
141-
142-
143-<!-- Links -->
144-
145-[product-page]: http://www-03.ibm.com/software/products/en/db2-express-server-edition
146-
147-[ibm-db2]: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.kc.doc/welcome.html
148-
149-[license-info]: http://www-03.ibm.com/software/sla/sladb.nsf/search
150-
151-[passport-db2]: http://www-01.ibm.com/software/passportadvantage/
152-
153-[db2-knowledgecenter]: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.kc.doc/welcome.html
154-
155-[db2-memory-disk-requirement]: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/doc/r0008877.html?cp=SSEPGG_9.7.0%2F2-0-2-0-4
156-
157-[db2-BLU-acceleration]: http://www.ibm.com/developerworks/data/library/techarticle/dm-1309db2bluaccel/
158+# DEPRECATED
159+
160+This charm is no longer being maintained. Please use `ibm-db2` instead.
161
162=== modified file 'metadata.yaml'
163--- metadata.yaml 2015-07-22 09:37:07 +0000
164+++ metadata.yaml 2016-02-13 18:13:12 +0000
165@@ -1,14 +1,12 @@
166 name: db2
167-summary: IBM DB2
168+summary: IBM DB2 (deprecated, use ibm-db2)
169 maintainer: IBM Juju Support Team <jujusupp@us.ibm.com>
170 description: |
171- IBM DB2 Express Server Edition is an entry level database system designed for transaction
172- processing and handling complex query workloads.
173+ DEPRECATED: please use ibm-db2 instead.
174 tags:
175 - misc
176- - database
177+ - database
178 subordinate: false
179 provides:
180 db:
181 interface: db2
182-

Subscribers

People subscribed via source and target branches