IBMDatabasePatterns guide, Part 1: Database Workload standards

Free Download: IBMDB2Express-C10.1 free version or DB210.1forLinux, UNIX, andWindows trial version download more IBM software trial version, and join the IBM software download and technical exchange group, participate in online communication. Database workload standards overview database workload standards enable users to use a standardized deployment

Download for free: the free version of IBM DB2 Express-C 10.1 or the trial version of DB2 10.1 for Linux, UNIX, and Windows downloads more trial versions of IBM software and joins the IBM software download and technical exchange group, participate in online communication. Database workload standards overview database workload standards enable users to use a standardized deployment

Free Download: IBM®DB2®Express-C 10.1 free version or DB2®10.1 for Linux®, UNIX®, And Windows®Trial version
Download more IBM software trial versions and join the IBM software download and technical exchange group to participate in online communication.

Overview of database Workload standards

Database workload standards allow users to use a standardized deployment method to equip databases. You can use these standards to create databases, tune instance configurations, optimize databases, and load initial data.

There are two types of database workload standards: default database workload and custom database workload. The default database workload standards include Departmental Transactional and Data Mart, which are predefined to meet common customer needs. Custom database workload standards provide the ability to create databases and optimize databases to meet specific requirements or enterprise standards.

This article describes the Database workload standards in IBM Database Patterns 1.1.0.1.

Back to Top

Use Database workload standards to deploy Databases

You can use a default database workload standard or custom standard to deploy a database. To deploy a database using the default database workload standard, selectDepartmental TransactionalOrData Mart. After selecting the appropriate value for other parameters, you can get a database that can run normally.

Figure 1. Use the default database workload standard to deploy the database

You can deploy a database using a custom database workload standard. In the workload standard table, if you select to use the custom workload standard (see figure 2), the custom workload standard is used to deploy the database.

In the deployment dialog box (see figure 2), there is no database compatibility mode or mode file field. This is because the custom database workload standards are self-contained. The settings for the database compatibility mode and mode file should be in the custom database workload standard.

Figure 2. Use the custom database workload standard to deploy the database

After the database is deployed, users can obtain their own databases, such as 3.

Figure 3. a running database

Back to Top

Create Database Workload standards

To meet the required tuning or enterprise standards, you can create custom database workload standards. To create a custom database workload standard, you must use the cloud management permission to log on.

Figure 4. Database workload standard entries

On the Database Workload Standards page, clickNew(+), As shown in the pop-up window in dialog box 5.

Figure 5. Create a custom workload standard

In the dialog box, options available for Workload type include Departmental Transactional and Data Mart.

Initial disk sizeIs the disk size reserved for IBM Database Patterns on the host that hosts the deployed Database. Valid range: 0-500, and must be an integer.

Storage multiplierIs the ratio of user data to physical disks. The value range is 1.0 to 3.0.

The upload package file is a ZIP file. It contains the following level-1 directories and entry files:

• Create_db/create_db.sh
• Tune_inst/tune_inst.sh
• Post_start_inst/post_start_inst.sh
• Tune_db/tune_db.sh
• Init_db/init_db.sh

The create_db directory and the create_db.sh script are mandatory.

The following are some restrictions on file upload:

• The package file must be a ZIP file (the name contains the. zip extension ).
• The package name must be 1-18 alphanumeric characters and cannot begin with a number or underline.

Note:If the package file is larger than 2 GB, you are advised to use CLI to upload it.

Back to Top

List and view database Workload standards

On the Database Workload Standards page, users with cloud management permissions can see a set of Database Workload Standards on the left side of the screen. Select a standard and they will see its details on the right side of the screen, as shown in 6.

Figure 6. Detailed information of a database workload standard

Back to Top

Download database Workload standards

Users can download database workload standards. To do this, they must use cloud management permissions to log on.

Figure 7. Download database Workload standards

Select a database workload standard and clickExportButton, as shown in figure 7, then you can download the selected database workload standard. You can download the default database workload standards directly or after creating custom database workload standards.

Back to Top

Edit database Workload standards

Users with cloud management permissions can edit existing database workload standards. InDatabase Workload StandardsOn the page, clickOpenEdit the selected database workload tag, as shown in figure 8.

By default, database workload standards are built in and cannot be edited. When you select a default database workload standard,OpenThe button is disabled.

Figure 8. edit database Workload standards

The preceding dialog box is similar to the create custom database workload standard dialog box, but all parameters have been filled with previous values. You can modify each parameter, update the upload package file, and clickSaveThen the database workload standard will be updated.

Back to Top

Delete database Workload standards

You can delete a database workload standard from the list. You only need to clickDeleteThe confirmation dialog box shown in "9" is displayed. If you clickYesWill delete the database workload standard. Only users with cloud management permissions can delete database workload standards.

Figure 9. delete database Workload standards

Two default database workload standards cannot be deleted. When you select a default database workload standard,DeleteThe button is disabled.

Back to Top

Conclusion

This article introduces the concept and details of database workload standards, including how to create database workload standards, how to manage their lifecycles, and how to use them to deploy databases.

Back to Top

Thank you

We are particularly grateful to Ning Wang (IBM Database Patterns architect) for his review and suggestions.