Pushing the Limit: Using Very Large Database Capabilities with DB2 for i

An IBM Redpaper publication

Published 07 March 2014

cover image

IBM Form #: REDP-5084-00
(10 pages)

More options

Rate and comment

Authors: Tracy Schramm

Abstract

In IBM® i 7.1 with the latest Technology Refresh updates, the maximum size of an SQL index increased to 1.7 TB, allowing users to take advantage of Very Large Database (VLDB) capabilities. This IBM Redpaper™ publication shows you how to view your IBM i 7.1 database file sizes from both a graphical user interface using IBM i Navigator and by using a stored procedure to help you identify when you are getting close to these system limits.

Table of contents

Using IBM i Navigator to display system limits
Using a stored procedure to display system limits
Comparing SYSLMTBL to IBM i Navigator Health Center

Follow IBM Redbooks

Follow IBM Redbooks