A guided tour of IBM Database Patterns, Part 3: Database workload standards

IBM® Database Patterns provides solutions to easily provision and manage databases on IBM Workload Deployer (IWD) in a private cloud. A database workload standard in IBM Database Patterns is a set of configuration settings used to create database patterns or databases directly. Learn the concepts of database workload standards and related details, including how to create database workload standards, how to manage their life cycles, and how to deploy databases with them.

Jinzhu Zhang (jinzhuz@cn.ibm.com), Software Engineer, IBM

Jinzhu Zhang is a software engineer working on the IBM Database Patterns development team. She joined IBM in 2009 in IBM China Software Development Lab. Jin Zhu is in charge of workload standard for IBM Database Patterns in IBM PureApplication System and IBM Workload Deployer.



Jian Hui Huang (jianhuih@cn.ibm.com), Staff Software Engineer, IBM

Jian Hui Huang is a staff software engineer working on the IBM Database Patterns development team. He joined IBM in 2009 in IBM China Software Development Lab. Jian Hui is a developer of IBM Database Patterns in IBM PureApplication System and IBM Workload Deployer.



28 June 2012

Also available in Chinese Russian

Database workload standards overview

Database workload standards enable users to provision databases with a standardized deployment approach. They are used to create databases, tune instance configurations, tune databases, load initial data, etc.

There are two kinds of database workload standards: default database workload and customized database workload. The Default database workload standard includes Departmental Transactional and Data Mart they are pre-defined to meet customers' common requirements. Customized database workload standards provide the capability to create databases and tune databases to meet specific requirements or corporate standards.

This article introduces database workload standards in IBM Database Patterns 1.1.0.1.


Deploy databases with database workload standards

Users can deploy databases with a default database workload standard or a customized one. To deploy a database with a default database workload standard, in the dialog for creating databases, choose Departmental Transactional or Data Mart in the workload standards table. And with proper values for other parameters, users can get a running database.

Figure 1. Deploy a database with default database workload standard
Figure shows how to deploy a database with default database workload standard

Users can use customized database workload standards to deploy databases. In the workload standards table, if users choose one customized workload standard (see Figure 2), the database will be deployed using the customized workload standard.

In the deploying dialog (see Figure 2), there is no Database compatibility mode or Schema file fields. That is because customized database workload standards are self-contained. The related setting for Database compatibility mode and Schema file are supposed to be in customized database workload standard.

Figure 2. Deploy a database with a customized database workload standard
Figure shows how to deploy a database with a customized database workload standard

After the deployment, users can get their own databases, as shown in Figure 3.

Figure 3. One running database
Figure shows a running database

Create database workload standards

To meet required tuning or corporate standards, users can create customized database workload standards. To create customized database workload standards, users must be logged in with cloud administration permission.

Figure 4. Entry of database workload standards
Figure shows the entry of database workload standards

On the Database Workload Standards page, click New (+), the dialog shown in Figure 5 pops up.

Figure 5. Create customized database workload standards
Figure shows how to a create customized database workload standards

In the dialog, for Workload type, options are Departmental Transactional and Data Mart.

Initial disk size is the disk size reserved for IBM Database Patterns on the machine hosting deployed database. The valid range is 0-500 and must be an integer.

Storage multiplier is the ratio of user data to physical disk. The range of permitted values is 1.0 to 3.0.

The uploading package file is a ZIP file. It contains the following first-level 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 files create_db directory and create_db.sh script are mandatory.

Following are some constraints for the uploading file:

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

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


List and view database workload standards

On the Database Workload Standards page, users with cloud administration permission could see a list of database workload standards on the left of the screen. Selecting one, they will see its detail information on the right of the screen, as shown in Figure 6.

Figure 6. Detail information of one database workload standard
Figure shows the detailed information of one database workload standard

Download database workload standards

Users can download the database workload standards. To do this, they must be logged in with cloud administration permission.

Figure 7. Download database workload standards
Figure shows how to download database workload standards

Select one database workload standard and click the Export button on the top-right corner, as shown in Figure 7, then the selected database workload standard can be downloaded. Users can download default database workload standards directly, and they can download customized database workload standards after they are created.


Edit database workload standards

Users with cloud administration permission can edit existing database workload standards. On the Database Workload Standards page, click Open to edit the selected database workload standard, as shown in Figure 8.

Default database workload standards are built in and cannot be edited. When users select one default database workload standard, the Open button is disabled.

Figure 8. Edit database workload standards
Figure shows how to edit database workload standards

The dialog shown above is like the dialog for creating customized database workload standards, but all parameters are already filled with previous values. Users can modify each parameter, update the uploading package file, and click Save, then this database workload standard is updated.


Delete database workload standards

Users can delete database workload standard from the list by clicking Delete on the top right, then the confirmation dialog will show up as shown in Figure 9. If users click Yes, the database workload standard will be deleted. Only users with cloud administration permission can delete database workload standards.

Figure 9. Delete database workload standards
Figure shows how to delete database workload standards

Two default database workload standards cannot be deleted. When users select one default database workload standard, the Delete button is disabled.


Conclusion

This article introduces concepts of database workload standards and related details, including how to create database workload standards, how to manage their life cycles, and how to deploy databases with them.


Acknowledgement

Special thanks to Ning Wang, IBM Database Patterns architect, for his review and advice.

Resources

Learn

Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.
  • Now you can use DB2 for free. Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edition and provides a solid base to build and deploy applications.

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=822455
ArticleTitle=A guided tour of IBM Database Patterns, Part 3: Database workload standards
publish-date=06282012