Information Systems:Important files on Bart

Overview

This page is a list of important or commonly used files (physical or logical) in our DB2 database on Bart, categorized by area of relevance. To do your own digging, remember that IBM provides a file/table that lists and provides detailed info for all files in the system (all objects that are of type *FILE). This file is 'SYSTABLES' in QSYS2. Query it using SQL, filtering by table_schema and/or table_text

SQL and IBM i DB2 terminology

It is very important to be aware of the differences in the way database elements are referred to between the SQL and IBM worlds. Otherwise, it can be very confusing when you hear these terms, especially if you come from a PC background, where a file has always been something you can click on in Windows Explorer that has an extension, and can be opened with whatever associated program is specified for that extension. Take the time to understand the following table:

IBM	SQL	! Layman's terms
Physical file	Table	Contains data. It's where the stuff is. Object type is PF.
Logical file	View	An alternate organization of the data in a PF/table, according to an index. "Points" to the data, does not contain the actual data. Modifying a logical file will thus affect the physical file.
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example
Example	Example

Important Libraries

UP1480BFVA UWDASWPRDD

Important Files

Carrier Interface

File	Library
Example	Example	Example
Example	Example	Example
Example	Example	Example
Example	Example	Example
Example	Example	Example

WebSmart: Infonet and Web Orders

• • XXITEMP