SHow

The SHOW command displays information contained in the Global Directory about names, regions, and segments.

The format of the SHOW command is:

SH[OW] -C[OMMAND] -F[ILE]=[gde-command-file]
SH[OW] -N[AME] [name-space]
SH[OW] -R[EGION] [region-name]
SH[OW] -S[EGMENT] [segment-name]
SH[OW] -M[AP] [R[EGION]=region-name]
SH[OW] -T[EMPLATE] 
SH[OW] -A[LL]

-COMMAND: Displays GDE commands that recreate the current Global Directory state.

-F[ILE]=gde-command-file: Optionally specifies a file to hold the GDE commands produced by -COMMAND. -FILE must must always appear after -COMMAND.

-NAME, -REGION, -SEGMENT, -MAP, -TEMPLATE, and -ALL are qualifiers that cause GDE to display selected portions of the Global Directory as follows:

-MAP: Displays the current mapping of all names, regions, segments, and files. This qualifier corresponds to the section of the SHOW report titled ***MAP***. The output of a SHOW -MAP may be restricted to a particular region by specifying a -REGION qualifier with a region name argument.

-TEMPLATE: Displays the current region and segment templates. This qualifier corresponds to the section of the SHOW report titled:

***TEMPLATES***

-ALL: Displays the entire Global Directory. This qualifier corresponds to displaying "all" sections of the SHOW report:

***TEMPLATES***, ***NAMES***, ***REGIONS***, ***SEGMENTS***,  ***MAP***.

By default, SHOW displays -ALL.

If you want to print the Global Directory, create a log file by executing LOG -ON= before executing the SHOW command. The -LOG command captures all the commands entered and output. You can print the log file if you want a hard copy record.

If you want to export the current Global Directory state, create a GDE command file with the SHOW -COMMAND -FILE=gde-command-file and run it in the target environment.

Example:

GDE> show -template

                               *** TEMPLATES ***
                                             Def   Rec   Key Null       Standard
Region                                     Coll  Size  Size Subs       NullColl  Journaling
--------------------------------------------------------------------------------------------
<default>                                     0  4080   255 NEVER      Y         Y
                  Jnl File (def ext: .mjl)  Before  Buff      Alloc Exten
------------------------------------------------------------------------------
<default>        <based on DB file-spec>   Y        128       2048  2048


Segment          Active              Acc Typ Block      Alloc Exten Options
------------------------------------------------------------------------------
<default>          *                 BG  DYN  4096       5000 10000 GLOB =1000
                                                                     LOCK = 40
                                                                     RES  =   0
                                                                     ENCR = OFF
<default>                            MM  DYN  4096       5000 10000 DEFER
                                                                     LOCK = 40

This displays only the TEMPLATES section of the Global Directory.

GDE>SHOW -command 

TEMPLATE -SEGMENT -ACCESS_METHOD=MM -BLOCK_SIZE=4096 -ALLOCATION=5000 -EXTENSION_COUNT=10000 
-LOCK_SPACE=40 -RESERVED_BYTES=0-DEFER

TEMPLATE -SEGMENT -ACCESS_METHOD=BG -BLOCK_SIZE=4096 -ALLOCATION=5000 -EXTENSION_COUNT=10000 
-LOCK_SPACE=40 -RESERVED_BYTES=0 -GLOBAL_BUFFER_COUNT=1000
TEMPLATE -REGION -RECORD_SIZE=4080 -KEY_SIZE=255 -NULL_SUBSCRIPTS=NEVER -STDNULLCOLL
TEMPLATE -REGION -JOURNAL=(BEFORE_IMAGE,BUFFER_SIZE=128,ALLOCATION=2048,EXTENSION=2048)
!
LOCKS -REGION=DEFAULT

CHANGE -REGION DEFAULT -DYNAMIC=DEFAULT -COLLATION_DEFAULT=0 -RECORD_SIZE=4080 -KEY_SIZE=255 
-NULL_SUBSCRIPTS=NEVER -STDNULLCOLL -JOURNAL=(BEFORE_IMAGE,BUFFER
_SIZE=128,ALLOCATION=2048,EXTENSION=2048,FILE="$gtmdir/$gtmver/g/gtm.mjl")
!
CHANGE -SEGMENT DEFAULT -ACCESS_METHOD=BG -BLOCK_SIZE=4096 -ALLOCATION=5000 -EXTENSION_COUNT=10000 
-LOCK_SPACE=40 -RESERVED_BYTES=0 -GLOBAL_BUFFER_COUNT=1000 
-FILE=$gtmdir/$gtmver/g/gtm.dat
!

This command displays the GDE commands to recreate the current global directory state.

Example:

GDE> show -template
           *** TEMPLATES ***
                                             Def   Rec   Key Null       Standard
Region                                     Coll  Size  Size Subs       NullColl  Journaling
--------------------------------------------------------------------------------------------
<default>                                     0   256    64 NEVER      N         N
 
Segment          Active              Acc Typ Block      Alloc Exten Options
------------------------------------------------------------------------------
<default>          *                 BG  DYN  1024        100   100 GLOB =1024
                                                                     LOCK = 40
<default>                            MM  DYN  1024        100   100 DEFER
                                                                     LOCK = 4

This displays only the TEMPLATES section of the Global Directory.