DB2 with BLU Acceleration speeds analytics and reporting using dynamic in-memory columnar technologies. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex. So you can connect with the information you need at breakthrough speed and volume.
BLU Acceleration combines advanced, innovative capabilities to accelerate analytic workloads for databases and data warehouses.DB2 with BLU Acceleration also integrates with IBM Cognos® Business Intelligence to provide reporting and deeper analysis. You can analyze key facts and freely explore information from multiple angles and perspectives to make more informed decisions all from within DB2.
Less data storage required -DB2 with BLU Acceleration dynamically moves data from storage. Database tuning, indexes and aggregates are not needed, which improves storage efficiency and helps lower your storage space requirement. In fact, clients have reported compression rates of 10 times that of un-compressed tables.The system uses available hardware such as memory, I/O and CPU to help reduce memory latency and processing. Hardware optimization streamlines administration and maintenance, putting less load on resources.
Simplicity - BLU Acceleration is fully integrated with DB2. It does not require SQL or schema changes to implement. Just load and go. Enhancements such as automation, optimization and self-tuning help to further simplify overall use.
Below are steps to create the BLU database -
- Set the DB2_WORKLOAD registry variable to ANALYTICS
2. Stop and Start the instance db2inst1
- Create the BLU enabled database
db2 create database BLU_DB
- Connect to the TEST database
db2 connect to db BLU_DB
- Check out the database configuration file
db2 get db cfg | grep –I dft
You will observe that default table organization is set to COLUMN
These posts are my opinions and do not necessarily represent IBM’s positions, strategies, or opinions
mailto :- ramyeles@in[dot]ibm[dot]com