Select the FM/Db2 Object List utility by typing '3.4' on the FM/Db2 main menu panel and press Enter.
Type 'FMNCI*' in the Name field and change the Object type value to
'1'. This will show all databases that start with FMNCI. See
Object List Utility panelFigure 1. Object List Utility panel
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Object List Utility
Command ===>
More: +
blank Display object list P Print object list
Object Identification Criteria:
Location . . . . . . . Enter * for list
Owner . . . . . . . . . +
Name . . . . . . . . . FMNCI* +
Database/collect/schema +
Additional Selection Criteria:
. . . . . . . . . . . . . . . . . . . . . . . Enter * to list catalog columns
Column . . . . . . . . +
Operator . . . . . . .
Value . . . . . . . . . +
Processing Options:
Object Type Enter ? to list all object types
1 1. Database 8. Package 15. Trigger
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
Press Enter to display the list of databases. See Databases panelFigure 2. Databases panel
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Databases Top of 1
Command ===> Scroll CSR
1 rows fetched Format TABL
STORAGE BUFFER INTERNAL AUTHID
DATABASE DATABASE GROUP POOL DATABASE THAT TYPE OF GROU+
SEL NAME CREATOR NAME NAME IDENTIFIER CREATED DATABASE MEMB+
* * * * ** * *
---- #1--+--- #2--+--- #3--+--- #4--+--- ----#5 #7--+--- #23-+--- #11-+
**** Top of data ****
FMNCIVD PERTHAP SYSDEFLT BP0 16716 PERTHAP
**** End of data ****
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F7=Up
F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Object List Line Commands Row 1 of 15
Command ===> Scroll CSR
Type S against the required line command and press Enter.
Sel Command Description
A Alter database
CR Create a database
CRS Create a table space
DR Drop database
DS Show database structure
G Grant privileges GEN Generate SQL for database from Db2 catalog I Details about database
ICS Show recovery information (image copies)
P Show privileges
ROW Show all columns for this row
S Show table spaces
SG Show storage group
F1=Help F2=Split F3=Exit F4=CRetriev F7=Backward F8=Forward
F9=Swap F10=Actions F12=Cancel
Type an 'S' against the "DS" entry to show the database structure. Press Enter. See Database Structure for FMNCIVD panel. Figure 4. Database Structure for FMNCIVD panel
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Database Structure for FMNCIVD Top of 15
Command ===> Scroll CSR
15 rows fetched Format TABL
OBJECT OBJECT
SEL TYPE NAME OWNER DBID PSID OBID
* * * * * *
---- #10- #12-+----1----+----2----+- #13-+--- ----#5 ---#19 ---#20
**** Top of data ****
D--- FMNCIVD---------------- PERTHAP 379 0 0
S FMNCIVSC PERTHAP 379 6 0
T Employee-Detail-Copy FMNCUSR 379 0 26
S FMNCIVSD PERTHAP 379 2 0
T Department-Information FMNCUSR 379 0 11
I Dept Info Index N2 FMNCUSR 379 0 15
I Dept Info Index N3 FMNCUSR 379 0 17
I Dept Info Index U1 FMNCUSR 379 0 13
S FMNCIVSE PERTHAP 379 4 0
T Employee-Detail FMNCUSR 379 0 18
I Employee Index N2 FMNCUSR 379 0 25
I Employee Index U1 FMNCUSR 379 0 23
S FMNCIVSR PERTHAP 379 8 0
T Department-Info-Errors FMNCUSR 379 0 29
S FMNCIVSS PERTHAP 379 10 0
T Employee-Detail-Errors FMNCUSR 379 0 30
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F7=Up
F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Press PF7/PF8 to scroll the content and PF3 repeatedly to return to the FM/Db2 main menu.