DB2 with BLU Acceleration integrates innovative new techniques for outlining and process column-organized table that speed news queries by an element of 10 xs to 50x with a compression issue of up to 10x, compared to ancient row-organized tables, while not having to create indexes or materialized tables/views. You can piece a BLU setting by setting many configuration parameters. If you set the instance aggregate register variable DB2_WORKLOAD=ANALYTICS, all databases created with this setting in situ can have the subsequent parameters:
Degree of parallelism (DFT_DEGREE) = ANY Default tablespace extent size (pages) (DFT_EXTENT_SZ) = 4 Default table organization (DFT_TABLE_ORG) = COLUMN Database page size = 32768
DB2 BLU Acceleration …Cont.
The 3 important info configuration settings for BLU workloads are
• SHEAPTHRES_SHR
• SORTHEAP
• DATABASE_MEMORY
• SHEAPTHRES_SHR
• SORTHEAP
• DATABASE_MEMORY
Of the 3 DATABASE_MEMORY is about to AUTOMATIC. The DB2 info configuration
the manager can set the initial values for SHEAPTHRES_SHR and SORTHEAP supported server
resources at the time of info creation.On a sixty-four GB RAM server, set the info manager configuration, as follows:
the manager can set the initial values for SHEAPTHRES_SHR and SORTHEAP supported server
resources at the time of info creation.On a sixty-four GB RAM server, set the info manager configuration, as follows:
SHEAPTHRES_SHR = 1266237 SORTHEAP = 63311DATABASE_MEMORY = AUTOMATIC (9729422)
 |
| www.Troytec.com |
DB2 BLU Implementation Techniques
1. Produce a DB2 instance
2. Set the written record variables
2. Set the written record variables
DB2COMM=TCPIP
DB2_WORKLOAD=ANALYTICS
This mass written record variable implicitly sets
DB2_WORKLOAD=ANALYTICS
DB2_USE_ALTERNATE_PAGE_CLEANING=ON [DB2_WORKLOAD]
DB2_ANTIJOIN=EXTEND [DB2_WORKLOAD]
DB2_WORKLOAD=ANALYTICS
This mass written record variable implicitly sets
DB2_WORKLOAD=ANALYTICS
DB2_USE_ALTERNATE_PAGE_CLEANING=ON [DB2_WORKLOAD]
DB2_ANTIJOIN=EXTEND [DB2_WORKLOAD]
3. Stop and begin DB2 instance
DB2 BLU Implementation Techniques … Cont.
4. Set INSTANCE_MEMORY
Set INSTANCE_MEMORY to wherever is ninetieth of the server memory if the
a server dedicated to just one columnar info instance and has 128GB RAM or additional.
If the server is multiple instances of DB2, choose associate degree acceptable proportion supported the
workload. What’s associate degree acceptable number? Choose a proportion that may use the obtainable RAM
without inflicting system paging and monitor the system paging on the server.
a server dedicated to just one columnar info instance and has 128GB RAM or additional.
If the server is multiple instances of DB2, choose associate degree acceptable proportion supported the
workload. What’s associate degree acceptable number? Choose a proportion that may use the obtainable RAM
without inflicting system paging and monitor the system paging on the server.
DB2 BLU Implementation Techniques … Cont.
4. Set Utility Heap to an oversized variety Set UTIL_HEAP_SZ to an oversized worth with AUTOMATIC
5. Before you begin building databases, take into account these points. BLU and pure Scale need
databases with ASM enabled. Each conjointly needs Unicode code sets and IDENTITY or
IDENTITY_16BIT collation. For column-organized tables, you need to outline table areas with
automatic area reclaim enabled.
databases with ASM enabled. Each conjointly needs Unicode code sets and IDENTITY or
IDENTITY_16BIT collation. For column-organized tables, you need to outline table areas with
automatic area reclaim enabled.
CREATE DATABASE DB_COL ON '/db/ts01','/db/ts02','/db/ts03','/db/ts04'
DBPATH ON '/db/home' USING CODESET UTF-8 TERRITORY en_US COLLATE USING
IDENTITY
DB20000I The CREATE DATABASE command completed successfully.
for more information visit @Troytec.
Comments
Post a Comment