Difference between revisions of "Information Systems:DB2 for i Database"
Jump to navigation
Jump to search
(Created page with "Data files are grouped together into libraries (like folders on PC’s, but only with a single level). These data libraries are - '''P...") |
m (Norwinu moved page Information Systems:DB2 (Data Base) to Information Systems:DB2 for i Database) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 18: | Line 18: | ||
Display Spooled File |
Display Spooled File |
||
| − | File . . . . . : QPDSPFD |
+ | File . . . . . : QPDSPFD Page/Line 1/1 Control . . . . . Columns 1 - 130 Find . . . . . . |
| ⚫ | |||
| − | Control . . . . . Columns 1 - 130 |
||
| + | DSPFD Command Input |
||
| − | Find . . . . . . |
||
| + | File . . . . . . . . . . . . . . . . . . . : FILE SR2ITR |
||
| ⚫ | |||
| − | + | Library . . . . . . . . . . . . . . . . . : *LIBL |
|
| ⚫ | |||
| − | DSPFD Command Input |
||
| − | File |
+ | File attributes . . . . . . . . . . . . . . : FILEATR *ALL |
| − | + | System . . . . . . . . . . . . . . . . . . : SYSTEM *LCL |
|
| + | File Description Header |
||
| ⚫ | |||
| − | File |
+ | File . . . . . . . . . . . . . . . . . . . : FILE SR2ITR |
| − | + | Library . . . . . . . . . . . . . . . . . . : UP1480BFPL |
|
| − | + | '''Type of file . . . . . . . . . . . . . . . : Logical''' |
|
| − | File |
+ | File type . . . . . . . . . . . . . . . . . : FILETYPE *DATA |
| − | + | Auxiliary storage pool ID . . . . . . . . . : 00001 |
|
| + | Data Base File Attributes |
||
| − | '''Type of file . . . . . . . . . . . . . . . : Logical''' |
||
| − | + | Externally described file . . . . . . . . . : Yes |
|
| − | + | File level identifier . . . . . . . . . . . : 1050129085518 |
|
| ⚫ | |||
| − | Data Base File Attributes |
||
| − | Externally described file . . . . . . . . . : Yes |
||
| − | File level identifier . . . . . . . . . . . : 1050129085518 |
||
| ⚫ | |||
Text 'description' . . . . . . . . . . . . : TEXT Item/date/time/ |
Text 'description' . . . . . . . . . . . . : TEXT Item/date/time/ |
||
stockroom/text/batch/qty |
stockroom/text/batch/qty |
||
| − | Distributed file . . . . . . . . . . . . . : No |
+ | Distributed file . . . . . . . . . . . . . : No |
| − | Partitioned SQL Table . . . . . . . . . . . : No |
+ | Partitioned SQL Table . . . . . . . . . . . : No |
| − | DBCS capable . . . . . . . . . . . . . . . : No |
+ | DBCS capable . . . . . . . . . . . . . . . : No |
| − | Maximum members . . . . . . . . . . . . . . : MAXMBRS 1 |
+ | Maximum members . . . . . . . . . . . . . . : MAXMBRS 1 |
| − | Number of triggers . . . . . . . . . . . . : 0 |
+ | Number of triggers . . . . . . . . . . . . : 0 |
| − | Number of members . . . . . . . . . . . . . : 1 |
+ | Number of members . . . . . . . . . . . . . : 1 |
| − | Access path maintenance . . . . . . . . . . : MAINT *IMMED |
+ | Access path maintenance . . . . . . . . . . : MAINT *IMMED |
| − | Access path recovery . . . . . . . . . . . : RECOVER *NO |
+ | Access path recovery . . . . . . . . . . . : RECOVER *NO |
| − | Force keyed access path . . . . . . . . . . : FRCACCPTH *NO |
+ | Force keyed access path . . . . . . . . . . : FRCACCPTH *NO |
| − | Preferred storage unit . . . . . . . . . . : UNIT *ANY |
+ | Preferred storage unit . . . . . . . . . . : UNIT *ANY |
| − | Record format selector program . . . . . . : FMTSLR *NONE |
+ | Record format selector program . . . . . . : FMTSLR *NONE |
| − | Records to force a write . . . . . . . . . : FRCRATIO *NONE |
+ | Records to force a write . . . . . . . . . : FRCRATIO *NONE |
| − | Maximum file wait time . . . . . . . . . . : WAITFILE *IMMED |
+ | Maximum file wait time . . . . . . . . . . : WAITFILE *IMMED |
| − | Maximum record wait time . . . . . . . . . : WAITRCD 60 |
+ | Maximum record wait time . . . . . . . . . : WAITRCD 60 |
| − | With check option . . . . . . . . . . . . . : NONE |
+ | With check option . . . . . . . . . . . . . : NONE |
| − | Allow read operation . . . . . . . . . . . : Yes |
+ | Allow read operation . . . . . . . . . . . : Yes |
| − | Allow write operation . . . . . . . . . . . : Yes |
+ | Allow write operation . . . . . . . . . . . : Yes |
| − | Allow update operation . . . . . . . . . . : ALWUPD *YES |
+ | Allow update operation . . . . . . . . . . : ALWUPD *YES |
| − | Allow delete operation . . . . . . . . . . : ALWDLT *YES |
+ | Allow delete operation . . . . . . . . . . : ALWDLT *YES |
| − | Record format level check . . . . . . . . . : LVLCHK *YES |
+ | Record format level check . . . . . . . . . : LVLCHK *YES |
| − | Access path . . . . . . . . . . . . . . . . : Keyed |
+ | Access path . . . . . . . . . . . . . . . . : Keyed |
| − | Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB |
+ | Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB |
| − | Access path logical page size . . . . . . . : PAGESIZE *KEYLEN |
+ | Access path logical page size . . . . . . . : PAGESIZE *KEYLEN |
| − | Maximum key length . . . . . . . . . . . . : 98 |
+ | Maximum key length . . . . . . . . . . . . : 98 |
| − | Maximum record length . . . . . . . . . . . : 208 |
+ | Maximum record length . . . . . . . . . . . : 208 |
| + | Access Path Description |
||
| − | Access Path Description |
||
| − | Access path maintenance . . . . . . . . . . : MAINT *IMMED |
+ | Access path maintenance . . . . . . . . . . : MAINT *IMMED |
| − | Unique key values required . . . . . . . . : UNIQUE No |
+ | Unique key values required . . . . . . . . : UNIQUE No |
| − | Key order . . . . . . . . . . . . . . . . . : Not specified |
+ | Key order . . . . . . . . . . . . . . . . . : Not specified |
| − | Select/omit specified . . . . . . . . . . . : No |
+ | Select/omit specified . . . . . . . . . . . : No |
| − | Access path journaled . . . . . . . . . . . : No |
+ | Access path journaled . . . . . . . . . . . : No |
| − | Access path . . . . . . . . . . . . . . . . : Keyed |
+ | Access path . . . . . . . . . . . . . . . . : Keyed |
| − | Number of key fields . . . . . . . . . . . : 7 |
+ | Number of key fields . . . . . . . . . . . : 7 |
| − | Record format . . . . . . . . . . . . . . . : ITR |
+ | Record format . . . . . . . . . . . . . . . : ITR |
| − | Key field . . . . . . . . . . . . . . . . : ITPRDC |
+ | Key field . . . . . . . . . . . . . . . . : ITPRDC |
| − | Sequence . . . . . . . . . . . . . . . : Ascending |
+ | Sequence . . . . . . . . . . . . . . . : Ascending |
| − | Sign specified . . . . . . . . . . . . : UNSIGNED |
+ | Sign specified . . . . . . . . . . . . : UNSIGNED |
| − | Zone/digit specified . . . . . . . . . : *NONE |
+ | Zone/digit specified . . . . . . . . . : *NONE |
| − | Alternative collating sequence . . . . : No |
+ | Alternative collating sequence . . . . : No |
| − | Key field . . . . . . . . . . . . . . . . : ITDATE |
+ | Key field . . . . . . . . . . . . . . . . : ITDATE |
| − | Sequence . . . . . . . . . . . . . . . : Ascending |
+ | Sequence . . . . . . . . . . . . . . . : Ascending |
| − | Sign specified . . . . . . . . . . . . : SIGNED |
+ | Sign specified . . . . . . . . . . . . : SIGNED |
| − | Zone/digit specified . . . . . . . . . : *NONE |
+ | Zone/digit specified . . . . . . . . . : *NONE |
| − | Alternative collating sequence . . . . : No |
+ | Alternative collating sequence . . . . : No |
| − | Key field . . . . . . . . . . . . . . . . : ITTIME |
+ | Key field . . . . . . . . . . . . . . . . : ITTIME |
| − | Sequence . . . . . . . . . . . . . . . : Ascending |
+ | Sequence . . . . . . . . . . . . . . . : Ascending |
| − | Sign specified . . . . . . . . . . . . : SIGNED |
+ | Sign specified . . . . . . . . . . . . : SIGNED |
| − | Zone/digit specified . . . . . . . . . : *NONE |
+ | Zone/digit specified . . . . . . . . . : *NONE |
| − | Alternative collating sequence . . . . : No |
+ | Alternative collating sequence . . . . : No |
| − | Key field . . . . . . . . . . . . . . . . : ITSROM |
+ | Key field . . . . . . . . . . . . . . . . : ITSROM |
| − | Sequence . . . . . . . . . . . . . . . : Ascending |
+ | Sequence . . . . . . . . . . . . . . . : Ascending |
| − | Sign specified . . . . . . . . . . . . : UNSIGNED |
+ | Sign specified . . . . . . . . . . . . : UNSIGNED |
| − | Zone/digit specified . . . . . . . . . : *NONE |
+ | Zone/digit specified . . . . . . . . . : *NONE |
| − | Alternative collating sequence . . . . : No |
+ | Alternative collating sequence . . . . : No |
| − | Key field . . . . . . . . . . . . . . . . : ITTEXT |
+ | Key field . . . . . . . . . . . . . . . . : ITTEXT |
| − | Sequence . . . . . . . . . . . . . . . : Ascending |
+ | Sequence . . . . . . . . . . . . . . . : Ascending |
| − | Sign specified . . . . . . . . . . . . : UNSIGNED |
+ | Sign specified . . . . . . . . . . . . : UNSIGNED |
| − | Zone/digit specified . . . . . . . . . : *NONE |
+ | Zone/digit specified . . . . . . . . . : *NONE |
| − | Alternative collating sequence . . . . : No |
+ | Alternative collating sequence . . . . : No |
| − | Key field . . . . . . . . . . . . . . . . : ITBATC |
+ | Key field . . . . . . . . . . . . . . . . : ITBATC |
| − | Sequence . . . . . . . . . . . . . . . : Ascending |
+ | Sequence . . . . . . . . . . . . . . . : Ascending |
| − | Sign specified . . . . . . . . . . . . : UNSIGNED |
+ | Sign specified . . . . . . . . . . . . : UNSIGNED |
| − | Zone/digit specified . . . . . . . . . : *NONE |
+ | Zone/digit specified . . . . . . . . . : *NONE |
| − | Alternative collating sequence . . . . : No |
+ | Alternative collating sequence . . . . : No |
| − | Key field . . . . . . . . . . . . . . . . : ITQTY |
+ | Key field . . . . . . . . . . . . . . . . : ITQTY |
| − | Sequence . . . . . . . . . . . . . . . : Ascending |
+ | Sequence . . . . . . . . . . . . . . . : Ascending |
| − | Sign specified . . . . . . . . . . . . : SIGNED |
+ | Sign specified . . . . . . . . . . . . : SIGNED |
| − | Zone/digit specified . . . . . . . . . : *NONE |
+ | Zone/digit specified . . . . . . . . . : *NONE |
| − | Alternative collating sequence . . . . : No |
+ | Alternative collating sequence . . . . : No |
| − | '''Files accessed by logical file PFILE |
+ | '''Files accessed by logical file PFILE |
| − | File Library LF Format |
+ | File Library LF Format |
| − | SROITR UP1480BFPL ITR''' |
+ | SROITR UP1480BFPL ITR''' |
| − | Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX |
+ | Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX |
| − | Language identifier . . . . . . . . . . . . : LANGID ENU |
+ | Language identifier . . . . . . . . . . . . : LANGID ENU |
| + | Member Description |
||
| − | Member Description |
||
| − | Member . . . . . . . . . . . . . . . . . . : MBR SR2ITR |
+ | Member . . . . . . . . . . . . . . . . . . : MBR SR2ITR |
| − | Member level identifier . . . . . . . . . : 1050129085518 |
+ | Member level identifier . . . . . . . . . : 1050129085518 |
| − | Member creation date . . . . . . . . . . : 01/29/05 |
+ | Member creation date . . . . . . . . . . : 01/29/05 |
Text 'description' . . . . . . . . . . . : TEXT Item/date/time/ |
Text 'description' . . . . . . . . . . . : TEXT Item/date/time/ |
||
stockroom/text/batch/qty |
stockroom/text/batch/qty |
||
| − | Expiration date for member . . . . . . . : EXPDATE *NONE |
+ | Expiration date for member . . . . . . . : EXPDATE *NONE |
| − | Access path maintenance . . . . . . . . . : MAINT *IMMED |
+ | Access path maintenance . . . . . . . . . : MAINT *IMMED |
| − | Access path recovery . . . . . . . . . . : RECOVER *NO |
+ | Access path recovery . . . . . . . . . . : RECOVER *NO |
| − | Preferred storage unit . . . . . . . . . : UNIT *ANY |
+ | Preferred storage unit . . . . . . . . . : UNIT *ANY |
| − | Record format selector program . . . . . : FMTSLR *NONE |
+ | Record format selector program . . . . . : FMTSLR *NONE |
| − | Records to force a write . . . . . . . . : FRCRATIO *NONE |
+ | Records to force a write . . . . . . . . : FRCRATIO *NONE |
| − | Share open data path . . . . . . . . . . : SHARE *YES |
+ | Share open data path . . . . . . . . . . : SHARE *YES |
| − | Access Path Activity Statistics . . . . . : |
+ | Access Path Activity Statistics . . . . . : |
| − | Access path logical reads . . . . . . . : |
+ | Access path logical reads . . . . . . . : |
| − | Access path physical reads . . . . . . : |
+ | Access path physical reads . . . . . . : |
| − | Index size . . . . . . . . . . . . . . : 3315630080 |
+ | Index size . . . . . . . . . . . . . . : 3315630080 |
| − | Access path valid . . . . . . . . . . . : Yes |
+ | Access path valid . . . . . . . . . . . : Yes |
| − | Implicit access path sharing . . . . . : Yes |
+ | Implicit access path sharing . . . . . : Yes |
| − | Access path journaled . . . . . . . . : Yes |
+ | Access path journaled . . . . . . . . : Yes |
| − | Number of unique partial key values . . : |
+ | Number of unique partial key values . . : |
| − | Key field 1 . . . . . . . . . . . . . : 66959 |
+ | Key field 1 . . . . . . . . . . . . . : 66959 |
| − | Key fields 1 - 2 . . . . . . . . . . : 11624772 |
+ | Key fields 1 - 2 . . . . . . . . . . : 11624772 |
| − | Key fields 1 - 3 . . . . . . . . . . : 23585801 |
+ | Key fields 1 - 3 . . . . . . . . . . : 23585801 |
| − | Key fields 1 - 4 . . . . . . . . . . : 23742851 |
+ | Key fields 1 - 4 . . . . . . . . . . : 23742851 |
| − | File owning access path . . . . . . . . : UP1480BFPL/SR18ITR |
+ | File owning access path . . . . . . . . : UP1480BFPL/SR18ITR |
| − | Member . . . . . . . . . . . . . . . . : SR18ITR |
+ | Member . . . . . . . . . . . . . . . . : SR18ITR |
| − | Shared access path attributes |
+ | Shared access path attributes |
| − | Maintenance . . . . . . . . . . . . . : *IMMED |
+ | Maintenance . . . . . . . . . . . . . : *IMMED |
| − | Access path recovery . . . . . . . . : *NO |
+ | Access path recovery . . . . . . . . : *NO |
| − | Force keyed access path . . . . . . . : *NO |
+ | Force keyed access path . . . . . . . : *NO |
| − | Keys must be unique . . . . . . . . . : No |
+ | Keys must be unique . . . . . . . . . : No |
| − | Last change date/time . . . . . . . . . . : 01/17/15 15:29:30 |
+ | Last change date/time . . . . . . . . . . : 01/17/15 15:29:30 |
| − | Last save date/time . . . . . . . . . . . : 01/17/15 01:06:20 |
+ | Last save date/time . . . . . . . . . . . : 01/17/15 01:06:20 |
| − | Last restore date/time . . . . . . . . . : 01/17/15 14:49:33 |
+ | Last restore date/time . . . . . . . . . : 01/17/15 14:49:33 |
| − | Last used date . . . . . . . . . . . . . : 02/12/15 |
+ | Last used date . . . . . . . . . . . . . : 02/12/15 |
| − | Days used count . . . . . . . . . . . . . : 1 |
+ | Days used count . . . . . . . . . . . . . : 1 |
| − | Reset date . . . . . . . . . . . . . . : |
+ | Reset date . . . . . . . . . . . . . . : |
| − | Number of data members . . . . . . . . . : 1 |
+ | Number of data members . . . . . . . . . : 1 |
| − | Based on file . . . . . . . . . . . . . . : SROITR |
+ | Based on file . . . . . . . . . . . . . . : SROITR |
| − | Library . . . . . . . . . . . . . . . . : UP1480BFPL |
+ | Library . . . . . . . . . . . . . . . . : UP1480BFPL |
| − | Member . . . . . . . . . . . . . . . . : SROITR |
+ | Member . . . . . . . . . . . . . . . . : SROITR |
| − | Logical file format . . . . . . . . . . : ITR |
+ | Logical file format . . . . . . . . . . : ITR |
| − | Number of index entries . . . . . . . . : 23756196 |
+ | Number of index entries . . . . . . . . : 23756196 |
| + | Record Format List |
||
| − | Record Format List |
||
| − | Record Format Level |
+ | Record Format Level |
| − | Format Fields Length Identifier |
+ | Format Fields Length Identifier |
| − | ITR 36 208 3CDDB9F4542D1 |
+ | ITR 36 208 3CDDB9F4542D1 |
| − | Text . . . . . . . . . . . . . . . . . . . : |
+ | Text . . . . . . . . . . . . . . . . . . . : |
| − | Total number of formats . . . . . . . . . . : 1 |
+ | Total number of formats . . . . . . . . . . : 1 |
| − | Total number of fields . . . . . . . . . . . : 36 |
+ | Total number of fields . . . . . . . . . . . : 36 |
| − | Total record length . . . . . . . . . . . . : 208 |
+ | Total record length . . . . . . . . . . . . : 208 |
| + | Member List |
||
| − | Member List |
||
| − | Source Creation Last Change |
+ | Source Creation Last Change |
| − | Member Size Type Date Date Time |
+ | Member Size Type Date Date Time |
| − | SR2ITR 3315630080 01/29/05 01/17/15 15:29:30 |
+ | SR2ITR 3315630080 01/29/05 01/17/15 15:29:30 |
| − | Text: Item/date/time/stockroom/text/batch/quantity |
+ | Text: Item/date/time/stockroom/text/batch/quantity |
| − | Total number of members . . . . . . . . . : 1 |
+ | Total number of members . . . . . . . . . : 1 |
| − | Total number of members not available . . : 0 |
+ | Total number of members not available . . : 0 |
| − | Total of member sizes . . . . . . . . . . : 3315630080 |
+ | Total of member sizes . . . . . . . . . . : 3315630080 |
This shows that SR2ITR is a logical file that is for the physical file SROITR. |
This shows that SR2ITR is a logical file that is for the physical file SROITR. |
||
| + | |||
| + | [[Category:Database Query]] |
||
| + | [[Category: IBM i]] |
||
Latest revision as of 09:29, 20 July 2016
Data files are grouped together into libraries (like folders on PC’s, but only with a single level). These data libraries are -
Production Development
ASW UP1480BFVA UP1480BFPL
Extension UWDASWPRDD UWDASWVOLD
Web (web orders, InfoNet) WEBPRDD WEBDEVD
There are two types of data files; physical and logical. A physical file contains the actual data records. A logical file is not data, but an index to the data.
Logical files are defined to allow different programs to access the data in different ways; or to optimise SQL (see Programming / SQL – Structure Query Language for an explanation of this).
For example, SROITR (Inventory Transactions) is a physical file. Records are accessed in the sequence in which they were written. Some of the logical files, or indexes, are SRBITR (keyed by inventory event code, order number, line number), SR1ITR (item, warehouse, date, time, text, batch, quantity), SR2ITR (item, date, time, text, batch, quantity), SR12ITR (accounting period, item, warehouse), and SRYITR (warehouse, inventory event code, date, handler).
In ASW, the first two characters indicate the system (in this example 'Stock Room'). An ‘O’ for the third character means it is a physical file; ‘B’ or a number means logical file; other letters working backwards from Z are logical files we have built. The rest of the name indicates the type of data. In the extensions, the last character(s) indicate the type; P for physical, or L and a number for logical.
To find out if a particular file is physical or logical, and it logical what the physical file is, key in DSPFD SR2ITR and press enter. Notice 'Type of file' 10 lines down, and 'Files accessed by logical file' in about the middle.
Display Spooled File
File . . . . . : QPDSPFD Page/Line 1/1 Control . . . . . Columns 1 - 130 Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2.... 3/26/15 Display File Description
DSPFD Command Input
File . . . . . . . . . . . . . . . . . . . : FILE SR2ITR
Library . . . . . . . . . . . . . . . . . : *LIBL
Type of information . . . . . . . . . . . . : TYPE *ALL
File attributes . . . . . . . . . . . . . . : FILEATR *ALL
System . . . . . . . . . . . . . . . . . . : SYSTEM *LCL
File Description Header
File . . . . . . . . . . . . . . . . . . . : FILE SR2ITR
Library . . . . . . . . . . . . . . . . . . : UP1480BFPL
Type of file . . . . . . . . . . . . . . . : Logical
File type . . . . . . . . . . . . . . . . . : FILETYPE *DATA
Auxiliary storage pool ID . . . . . . . . . : 00001
Data Base File Attributes
Externally described file . . . . . . . . . : Yes
File level identifier . . . . . . . . . . . : 1050129085518
Creation date . . . . . . . . . . . . . . . : 01/29/05
Text 'description' . . . . . . . . . . . . : TEXT Item/date/time/
stockroom/text/batch/qty
Distributed file . . . . . . . . . . . . . : No
Partitioned SQL Table . . . . . . . . . . . : No
DBCS capable . . . . . . . . . . . . . . . : No
Maximum members . . . . . . . . . . . . . . : MAXMBRS 1
Number of triggers . . . . . . . . . . . . : 0
Number of members . . . . . . . . . . . . . : 1
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . . : RECOVER *NO
Force keyed access path . . . . . . . . . . : FRCACCPTH *NO
Preferred storage unit . . . . . . . . . . : UNIT *ANY
Record format selector program . . . . . . : FMTSLR *NONE
Records to force a write . . . . . . . . . : FRCRATIO *NONE
Maximum file wait time . . . . . . . . . . : WAITFILE *IMMED
Maximum record wait time . . . . . . . . . : WAITRCD 60
With check option . . . . . . . . . . . . . : NONE
Allow read operation . . . . . . . . . . . : Yes
Allow write operation . . . . . . . . . . . : Yes
Allow update operation . . . . . . . . . . : ALWUPD *YES
Allow delete operation . . . . . . . . . . : ALWDLT *YES
Record format level check . . . . . . . . . : LVLCHK *YES
Access path . . . . . . . . . . . . . . . . : Keyed
Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB
Access path logical page size . . . . . . . : PAGESIZE *KEYLEN
Maximum key length . . . . . . . . . . . . : 98
Maximum record length . . . . . . . . . . . : 208
Access Path Description
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE No
Key order . . . . . . . . . . . . . . . . . : Not specified
Select/omit specified . . . . . . . . . . . : No
Access path journaled . . . . . . . . . . . : No
Access path . . . . . . . . . . . . . . . . : Keyed
Number of key fields . . . . . . . . . . . : 7
Record format . . . . . . . . . . . . . . . : ITR
Key field . . . . . . . . . . . . . . . . : ITPRDC
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : ITDATE
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : SIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : ITTIME
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : SIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : ITSROM
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : ITTEXT
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : ITBATC
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : ITQTY
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : SIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Files accessed by logical file PFILE
File Library LF Format
SROITR UP1480BFPL ITR
Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX
Language identifier . . . . . . . . . . . . : LANGID ENU
Member Description
Member . . . . . . . . . . . . . . . . . . : MBR SR2ITR
Member level identifier . . . . . . . . . : 1050129085518
Member creation date . . . . . . . . . . : 01/29/05
Text 'description' . . . . . . . . . . . : TEXT Item/date/time/
stockroom/text/batch/qty
Expiration date for member . . . . . . . : EXPDATE *NONE
Access path maintenance . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . : RECOVER *NO
Preferred storage unit . . . . . . . . . : UNIT *ANY
Record format selector program . . . . . : FMTSLR *NONE
Records to force a write . . . . . . . . : FRCRATIO *NONE
Share open data path . . . . . . . . . . : SHARE *YES
Access Path Activity Statistics . . . . . :
Access path logical reads . . . . . . . :
Access path physical reads . . . . . . :
Index size . . . . . . . . . . . . . . : 3315630080
Access path valid . . . . . . . . . . . : Yes
Implicit access path sharing . . . . . : Yes
Access path journaled . . . . . . . . : Yes
Number of unique partial key values . . :
Key field 1 . . . . . . . . . . . . . : 66959
Key fields 1 - 2 . . . . . . . . . . : 11624772
Key fields 1 - 3 . . . . . . . . . . : 23585801
Key fields 1 - 4 . . . . . . . . . . : 23742851
File owning access path . . . . . . . . : UP1480BFPL/SR18ITR
Member . . . . . . . . . . . . . . . . : SR18ITR
Shared access path attributes
Maintenance . . . . . . . . . . . . . : *IMMED
Access path recovery . . . . . . . . : *NO
Force keyed access path . . . . . . . : *NO
Keys must be unique . . . . . . . . . : No
Last change date/time . . . . . . . . . . : 01/17/15 15:29:30
Last save date/time . . . . . . . . . . . : 01/17/15 01:06:20
Last restore date/time . . . . . . . . . : 01/17/15 14:49:33
Last used date . . . . . . . . . . . . . : 02/12/15
Days used count . . . . . . . . . . . . . : 1
Reset date . . . . . . . . . . . . . . :
Number of data members . . . . . . . . . : 1
Based on file . . . . . . . . . . . . . . : SROITR
Library . . . . . . . . . . . . . . . . : UP1480BFPL
Member . . . . . . . . . . . . . . . . : SROITR
Logical file format . . . . . . . . . . : ITR
Number of index entries . . . . . . . . : 23756196
Record Format List
Record Format Level
Format Fields Length Identifier
ITR 36 208 3CDDB9F4542D1
Text . . . . . . . . . . . . . . . . . . . :
Total number of formats . . . . . . . . . . : 1
Total number of fields . . . . . . . . . . . : 36
Total record length . . . . . . . . . . . . : 208
Member List
Source Creation Last Change
Member Size Type Date Date Time
SR2ITR 3315630080 01/29/05 01/17/15 15:29:30
Text: Item/date/time/stockroom/text/batch/quantity
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total of member sizes . . . . . . . . . . : 3315630080
This shows that SR2ITR is a logical file that is for the physical file SROITR.