System Wide Catalog

Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

In V3R1, a new feature in DB2/400, the System Wide Catalog, contains information for each physical file, logical file, SQL table, and SQL view stored on a given AS/400. The System Wide Catalog provides one central place on an AS/400 for the attributes and characteristics of all the above file types existing on a system.

In V3R1, this new catalog is used to implement and support referential integrity, client/server application development tools, and client/server applications. It can also be used by software/application providers to install their packages and avoid naming convention conflicts with files already on a system.

When V3R1 is installed on a system, this new System Wide Catalog must be created and updated with the information for all files existing on the system. This update task is CPU intensive and will increase the amount of time and disk space required to install V3R1 from about two minutes and an additional 22MB of disk space for 1,500 files to about three hours and an additional 220MB of disk space for 15,000 files. You need to do this only with the installation of V3R1.

Any new file added to a system after V3R1 is installed will cause the catalog update task to be triggered. This is a CPU intensive task that may run at the highest priority on the system (priority number of 10 or less). So if you restore a new or existing library that contains a large number of files not currently existing on the system, or if you rename an existing library that has a large number of files in it, the catalog update task can be triggered. This will have a serious performance impact on the system.

If you must restore libraries with a large number of new files or rename existing libraries, it is wise to do it during off-peak operations.

- Skip Marchesani

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  •  

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: