Difference between revisions of "Information Systems:Important files on Bart"

From uniWIKI
Jump to navigation Jump to search
m
m
Line 1: Line 1:
 
=Overview=
  
=Overview=
−
This page is a list of important files (physical or logical) residing in the DB2 database on Bart. A simple SQL query of QSYS2.SYSTABLES would provide insight into just how many files are in the database. Some are files that are central to ASW processes, others are part of extensions, and others are purely custom-built and serve various functions. Of the thousands of files, some naturally are more important - perhaps because they are touched by many processes, or simply because they contain a lot of vital information. As they are discovered, they will be listed and described/summarized here.
 +
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
   
  +
=Important Libraries=
⚫
=Files=
  
−
* UP1480BFVA
 +
UP1480BFVA
  ⚫
UWDASWPRDD
−
*ATLARCHP
  
  +
⚫
* UWDASWPRDD
  
  ⚫
=Important Files=
  +
==Accounting==
  +
  +
==Carrier Interface==
  +
{| class="wikitable sortable"
  +
|-
  +
! File !! Library !!
  +
|-
  +
| Example || Example || Example
  +
|-
  +
| Example || Example || Example
  +
|-
  +
| Example || Example || Example
  +
|-
  +
| Example || Example || Example
  +
|-
  +
| Example || Example || Example
  +
|}
  +
  +
==WebSmart: Infonet and Web Orders==
 
**XXITEMP
  
**XXITEMP
  +
  +
   
 
[[Category: IBM i]]
  
[[Category: IBM i]]
  +
[[Category: DB2 Query]]
  +
[[Category: SQL]]
  +
[[Category: Troubleshooting]]

Revision as of 13:26, 10 January 2017

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

Important Libraries

UP1480BFVA UWDASWPRDD

Important Files

Accounting

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
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Important_files_on_Bart&oldid=6307"