Browse Prior Art Database

Get Table Location Information Utility

IP.com Disclosure Number: IPCOM000109505D
Original Publication Date: 1992-Sep-01
Included in the Prior Art Database: 2005-Mar-24
Document File: 1 page(s) / 39K

Publishing Venue

IBM

Related People

Buquoi, GH: AUTHOR [+4]

Abstract

A method is described which gives the user an easy means of locating all the files belonging to each table in a database.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 93% of the total text.

Get Table Location Information Utility

       A method is described which gives the user an easy means
of locating all the files belonging to each table in a database.

      If a user uses the Span Utility to move and/or span table
objects, the database is no longer physically contained in one sub-
directory.  Database files may be located in many different
subdirectories on different drives.  In order to efficiently manage
the system resources, the user needs an easy means of locating all
the files belonging to each table in the database.

      The Get Table Location Information Utility solves this problem.
This utility returns to the user a list of all the paths that contain
files for table objects.  The user may request the information for a
particular table in the database or for the entire database.

      For example, if the user requests information about one of the
system catalogs, SYSIBM.SYSTABLES, the data returned may include:
      Database Table Location Information for SYSIBM.SYSTABLES
                     Filename = SQL00002.DAT
                       Directory 1 = C:\SQL00001
                     Filename = SQL00002.LF
                       Directory 1 = C:\ABC
                       Directory 2 = D:\DEF
                     Filename = SQL00002.INX
                       Directory 1 = ...