Select the FM/Db2 Object List utility by typing '3.4' on the FM/Db2
main menu panel and press Enter.
Type 'FMN0I*' in the Name field
and change the Object type value to '1'. This will show all databases
that start with FMN0I.
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 . . . . . . . . . FMN0I* +
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 ****
FMN0IVD 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
Type '?' against the FMN0IVD database entry and press Enter. See Object List Line Commands panel. Figure 3. Object List Line Commands panel
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 FMN0IVD
panel. Figure 4. Database Structure for FMN0IVD
panel
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Database Structure for FMN0IVD 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--- FMN0IVD---------------- PERTHAP 16716 0 0
S FMN0IVSC PERTHAP 16716 6 0
T Employee-Detail-Copy FMN0USR 16716 0 24
S FMN0IVSD PERTHAP 16716 2 0
T Department-Information FMN0USR 16716 0 9
I Dept Info Index N2 FMN0USR 16716 0 13
I Dept Info Index N3 FMN0USR 16716 0 15
I Dept Info Index U1 FMN0USR 16716 0 11
S FMN0IVSE PERTHAP 16716 4 0
T Employee-Detail FMN0USR 16716 0 16
I Employee Index N2 FMN0USR 16716 0 23
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F7=Up
F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Press PF3 repeatedly to return to the FM/Db2 main menu.