Mission Critical Computing Blog
Your source for the latest insights on HP Integrity, mission critical computing, and other relevant server and technology topics from the BCS team.

Defrag NonStop Database the Easy Way and Improve Application Performance and Disk Space Utilization

You must have experienced on your Windows PC that the disks, as they get used, become fragmented over time, which also results in poor application performance. There are tools to determine when the disks are fragmented and to reorganize the data to improve disk space utilization and application performance.

 

On a database system, the same general concept applies. Over time, the data has to be reloaded to improve application performance and disk space utilization. The question is - when is the right time to reload the data?

 

On HP Integrity NonStop systems, FUP RELOAD physically reorganizes key-sequenced Enscribe files as well as SQL/MP and SQL/MX tables and indexes that are disorganized. However, FUP RELOAD is not a procedure that should be used indiscriminately. Determining when to reload is difficult.

 

Reload Analyzer (TRA) is a database management tool for NonStop systems that determines when to reload files, tables, indexes or partitions. TRA performs data-block chaining and fragmentation analysis, and generates FUP RELOAD commands, if the percentage of average blocks per chain is below a user-specified threshold (for example, if the percentage of average blocks per chain is under 5%).

 

TRA performs both vertical analysis of index blocks and horizontal analysis of data blocks, as explained later. TRA supports NonStop Enscribe, SQL/MP and SQL/MX databases. It supports all index and data block sizes, including 32kb block size tables. It can be run any time to analyze a single file, a single partition, all partitions, or a user-specified batch list of files.

 

What does Reload Analyzer compute?

Reload Analyzer computes and displays the following statistics:

  • Total number of data-block chains
  • Length of longest data-block chain
  • Length of shortest data-block chain
  • Histogram of blocks per chain
  • Average number of blocks per chain

 

Ideally, the percentage of total blocks in average chain should be 100%. One physical chain is optimum.

 

Reload Analyzer performs vertical index-block analysis

Too many vertical index-blocks cause poor random access. Reload Analyzer performs vertical index-block analysis to make the random access performance better.

 

Reload Analyzer performs horizontal data-block analysis

Too many short, broken (non-adjacent) horizontal data-block chains cause excessive physical I/O and/or seeks, and thus, very poor sequential access (up to 128 times slower). Disorganized files cannot take advantage of bulk reads for sequential pre-fetch and bulk writes for sequential updates in files. Reload Analyzer performs in-depth horizontal data-block analysis to make the sequential access performance better.

 

If you are not already using TRA, I strongly advise you to try it out, and see how it can improve your application performance and disk space utilization by determining when files and tables must be organized. 

Leave a Comment

We encourage you to share your comments on this post. Comments are moderated and will be reviewed
and posted as promptly as possible during regular business hours

To ensure your comment is published, be sure to follow the community guidelines.

Be sure to enter a unique name. You can't reuse a name that's already in use.
Be sure to enter a unique email address. You can't reuse an email address that's already in use.
Type the characters you see in the picture above.Type the words you hear.
Search
About the Author
Vinay Gupta is an HP Distinguished Technologist and the NonStop Manageability Architect. He joined Tandem in 1994 after graduating from Indi...
About the Author(s)
  • I work as a Master Architect in HP Servers R & D group. I work with teams spread across the lab and outside to build solutions which are highly available on HP-UX, OpenVMS and Mission Critical Linux platforms. In particular I contribute to develop HP Serviceguard clusters, HP-UX Security and Middleware products. I have been with HP for last 17 years and have exposure to HA/DR field from both R & D and customer perspectives.
  • Kirk Bresniker is the Vice President/Chief Technologist for HP Business Critical Systems where he has technical responsibility for all things Mission Critical, including HP-UX, NonStop and scalable x86 platforms. He joined HP in 1989 after graduating from Santa Clara University and has been an HP Fellow since 2008.
  • I’m the worldwide marketing manager for HP NonStop. I’ll be blogging and tweeting out news as it relates to NonStop solutions – you can find me here and on twitter at @CarolynatHP
  • Cynthia is part of the HP ExpertOne team. ExpertOne offers professional IT training and certifications from infrastructure refresh to areas that span across the datacenter like Cloud and Converged Infrastructure.
  • Hi, I work on the HP Servers team as HP-UX worldwide product marketing manager. I´m interested in how customers use our technology and will be blogging about their stories and on how our products evolve to help their businesses be always on.
  • I have worked with NonStop systems since 1982. I am a Master Technologist for HP and am part of the IT SWAT organization, the Cloud SWAT and work with HP Labs. I report into the Enterprise Solutions and Architecture organization.
  • Joe Androlowicz is a Technical Communications and Marketing manager in HP’s NonStop Product Division. Joe is a 25 year journeyman in information systems design, instructional technologies and multimedia development. He left Apple Computer for Tandem Computers to help launch G03 and hasn’t looked back yet. He previously managed the program management team for the NonStop Education and Training Center and drove the development and growth of the NonStop Certification programs.
  • Hello! I am a social media manager for servers, so my posts will be geared towards HP server-related news & info.
  • HP Servers, Converged Infrastructure, Converged Systems and ExpertOne
  • Luke Oda is a member of the HP's BCS Marketing team. With a primary focus on marketing programs that support HP's BCS portfolio. His interests include all things mission-critical and the continuing innovation that HP demonstrates across the globe.
  • I am the Superdome 2 Product Manager. My interest is to learn how mission critical platform helps customers and would also like to share my thoughts on how Superdome has been helping customers and will continue to do so.
  • I work in the HP Servers marketing group, managing a marketing team responsible for marketing solutions for enterprise customers who run mission-critical workloads and depend on HP to keep their business continuously running.
  • Mohan Parthasarathy is a Technical Architect in the HP-UX lab. His primary focus currently is in the core kernel, platform enablement and virtualization areas of HP-UX. Mohan has worked on various modules of HP-UX, including networking protocol stacks, drivers, core kernel and virtualization
  • I’m the Worldwide Product Marketing Manager for HP Serviceguard Solutions for Linux in BCS. I’ll be blogging about the latest news and enhancements as it relates to this product.
  • Greetings! I am on the HP Enterprise Group marketing team. Topics I am interested in include Converged Infrastructure, Converged Systems and Management, and HP BladeSystem.
  • As a Managing Consultant for HP’s Enterprise Solution & Architecture group, I collaborate with client business and IT senior management to understand, prioritize and architect advanced use of data and information, drawing insights required to make informed business decisions. My current focus leverages event-driven business intelligence design techniques and technologies to identify patterns, anticipate outcomes and proactively optimize business response creating a differentiated position in the marketplace for the client.
  • Wendy Bartlett is a Distinguished Technologist in HP’s NonStop Enterprise Division, and focuses on dependability – security and availability - for the NonStop server line. She joined Tandem in 1978. Her other main area of interest is system architecture evolution. She has an M.S. degree in computer science from Stanford University.
  • I am part of the integrated marketing team focused on HP Moonshot System and HP Scale-up x86 and Mission-critical solutions.


Follow Us