Listing information on the DB configuration (DISPLAY)

 DISPLAY {DB[,RUNID=transaction-id] |
          USERS[,DB=dbname] |
          SUBSCH[,DB=dbname][,LINES={n | ALL}] |
          MAINREF[,STATE=BLOCK] |
          transaction-id |
          REALMS[,DB=dbname][,RN=realm-name][,LINES={n | ALL}] |
          PP |
          FPA [,DB=dbname][,RN=realm-name][,LINES={n | ALL}] |
          INCR [,DB=dbname][,RN=realm-name][,LINES={n | ALL}] |
          DBTT-INCR [,DB=dbname[, RECR=recordref]][,LINES={n | ALL}] |
          PUBSETS |
          ALOG [,DB=dbname] }

transaction-id
	Identifier for a current transaction
dbname
	Name of a database in the DB configuration (or name of a shadow database) In the case of DISPLAY DBTT-INCR, name of the database containing the record type or record types for which the user schema information is to be output. If the DB is not specified then all the record types of all the currently attached databases are output.
realmname
	Name of a realm
recordref
	Number of the user record type for which information is to be output. If the RECR parameter is not specified then all the record types for the user schema in the specified database are output. The DISPLAY DBTT-INCR command with no recordref specification is particularly useful if you want to assign record numbers to record type names. recordref=1 is used internally by UDS/SQL and cannot be specified here.
n	Maximum number of output lines for this DISPLAY command (default: 100). You can specify values between 5 and 999 for n. Limiting the number of output lines helps you prevent the disruption of DBH operation due to the unintentional generation of a very large number of output lines.
ALL	All the output lines are generated.

The DISPLAY command produces a listing on the database administrator’s data display terminal or operator console in accordance with the command specification, i.e.: 

DB	Display all databases in the current DB configuration
DB,RUNID=transaction-id
	Display all databases referenced by the transaction transaction-id
USERS
	Display all transactions currently running in the DB configuration
USERS,DB=dbname
	Display all transactions which reference the database dbname
SUBSCH
	Display all subschemas of the DB configuration
SUBSCH,DB=dbname
	Display all subschemas of database dbname
MAINREF
	Display information on the status of the transaction channels (mainrefs)
MAINREF,STATE=BLOCK
	Display information on status of blocked mainrefs
transaction-id
	Display information on status of transaction transaction-id
REALMS
	Display information on all permanent realms of the DB configuration
REALMS,DB=dbname
	Display information on all permanent realms of database dbname
REALMS,RN=realm-name [,DB=dbname]
	Display information on the permanent realm realm-name [of database dbname]
PP	Display all load parameters under which the DBH is currently running
FPA	Display information on the free pages in all realms of the DB configuration
FPA,DB=dbname
	Display information on the free pages in all realms of database dbname
FPA,RN=realm-name
	[,DB= dbname ] Display information on the free pages in the realm realm-name [of database dbname ]
INCR	Information on the online extensibility of all activated user realms and all DBDIRS in the DB configuration
INCR, DB=dbname
	Information on the online extensibility of all activated user realms and the DBDIR of the database dbname
INCR,RN=realmname [,DB=dbname]
	Information on the online extensibility of the realm realm-name of the database dbname. If realm-name is unique in the database configuration, the specification DB=dbname need not be made.
DBTT-INCR
	Information on the online DBTT extensibility of the record types in the user schemata of the DB configuration
DBTT-INCR, DB=dbname
	Information on the online DBTT extensibility of the record types in the user schema of the database dbname
DBTT-INCR,DB=dbname,RECR=recordref
	Information on the online DBTT extensibility of the record type with record type number recordref in the database dbname
PUBSETS
	Settings of the UDS/SQL pubset declaration
ALOG
	Current ALOG settings on all ALOG files of the DB configuration.
ALOG DB=dbname
	Current ALOG settings of database dbname.
LINES
	Number of output lines for this DISPLAY command.
LINES=n
	Maximum number of output lines for this DISPLAY command. If the maximum number of output lines for a DISPLAY command is not sufficient to output the information for all the objects in question then a corresponding message is output: OUTPUT OF nnnn FURTHER LINES SUPPRESSED There is no command allowing you to resume this interrupted DISPLAY command. To obtain the information for all the associated objects, you must repeat the command, for example with LINES=ALL. In all cases, the following message is then output: UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND
LINES=ALL
	All output lines for this DISPLAY command.

The following sections describe the output of the various DISPLAY commands.

DISPLAY DB - Show all databases and access modes

Input format:              DISPLAY DB

Comment line:  USERID:   DATABASE-NAME:  DB-OPTION:  BUFFER: BUF-ID: PAGE:
Information :  userid    dbname          db-option   bbbb    buffid  pgKB
line(s)
End line:       UDS/SQL Vn.n   nnn  DATABASE(S) IN confname

Explanations:

userid	User ID in which the database concerned is located.
dbname
	Name of the database
db-option
	EXC-UPD EXCLUSIVE-UPDATE: The DBH accesses database dbname exclusively. The application programs can access the database in update mode. SHA-RTR SHARED-RETRIEVAL: All DBHs can have shared access to database dbname, i.e. this database can also be attached to other DBHs (but only in SHA-RTR mode). The application programs of all DBHs have read-only access to the database.
bbbb	Size of the user buffer pool for the database in Mbytes without leading zeros. If no user buffer pool exists, blanks are output.
buffid	Name of the shared user buffer pool If a shared user buffer pool has been assigned to the database. *EXCL indicates that an exclusive user buffer pool has been assigned to the database. *SYSTEM indicates that the system buffer pool has been assigned to the database.
pg	Page format of realm files
Vn.n      UDS/SQL version number
nnn	Number of databases in the DB configuration

Example

//EXECUTE-DAL-CMD CMD=DISPLAY DB

 %  UDS0220 UDS RECEIVED COMMAND: DISPLAY DB (OPOX073,09:28:51/4TMW) 
 4TMW: USERID:   DATABASE-NAME:      DB-OPTION: BUF-SIZE: BUF-ID: PAGE:
 4TMW: -----------------------------------------------------------------
 4TMW: $XXXXXXXX.SHIPPING            EXC-UPD            *SYSTEM  4KB 
 4TMW: $XXXXXXXX.CUSTOMER            EXC-UPD       1    *EXCL    4KB 
 4TMW:
 4TMW: UDS/SQL V2.9  2 DATABASES IN CONFEXMP
 %  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:28:51/4TMW)  

DISPLAY DB,RUNID=transaction-id -
Show all databases referenced by the transaction identifier

Input format:              DISPLAY DB,RUNID=transaction-id

Comment line:   USERID:   DATABASE-NAME:          OPEN-MODE:


Information 
line(s):        userid    dbname                  open-mode

End line:       UDS/SQL Vn.n nnn DATABASE(S) USED FROM transaction-id

Explanations:

transaction-id
	Internal transaction identifier assigned by UDS/SQL.
userid	User ID in which the database concerned is located.
dbname
	Name of the database
open-mode
	Usage mode specified by the transaction transaction-id when opening the realm(s) of the database: UPD UPDATE RTR RETRIEVAL
Vn.n      UDS/SQL version number
nnn	Number of databases referenced by transaction transaction-id

Example

//EXECUTE-DAL-CMD CMD=DISPLAY DB,RUNID=1

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY DB,RUNID=1 (OPOX073,09:28:51/4TMW)  
4TMW: USERID:   DATABASE-NAME:      OPEN-MODE:
4TMW: -----------------------------------------
4TMW: $XXXXXXXX.SHIPPING             RTR
4TMW:
4TMW: UDS/SQL V2.9   1 DATABASE  USED FROM       1
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:28:51/4TMW) 

DISPLAY USERS - Show all transactions currently running

Input format:              DISPLAY USERS

Comment line:      PROGRAM  TSN/TERM  RUNUNIT-ID  STATE  PTC  FC  MR-NR  DLY


Information 
line(s):           progname tsn/term  ta-id       state  ptc  fc  mr-nr  dly
              
End line:              UDS/SQL Vn.n nnn  USER(S) OF confname

Explanations:

PROGRAM
	Application program which started the transaction: progname  Name of application program or of openUTM operand DBKEY or ’UTM’
TSN/TERM
	Task identifier: tsn  Timesharing mode: task serial number under which program progname runs term-name Transaction mode: Logical name of the openUTM client or Partner (LTERM name, LPAP name, OSI-LPAP name) In the case of a distributed transaction, this operand refers to the primary subtransaction (PST), which may be running in another configuration.
RUNUNIT-ID
	ta-id  Internal transaction identifier assigned by UDS/SQL. Transactions are numbered consecutively within a session segment. In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT).
STATE
	state Indicates the present state of the transaction: In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT). STOP The transaction is in the STOP state. AREA Upon execution of the READY statement, the transaction is waiting in the realm queue; at present it cannot access the requested realm. LOCK The transaction is waiting for a locked resource such as a page to be released. DEACT The transaction is deactivated. WAIT-ST The transaction is waiting for a server task to become free. TO-STOP A STOP request is pending for the transaction. TO-CANC A CANCEL request is pending for the transaction. IN-CANC A CANCEL request is being processed for the transaction. USER No DML statement is currently being processed for this transaction; control resides with the application program or, in the case of UDS-D, with the UDS/SQL configuration of the PTT. CONNEC The transaction is under the control of the connection module or, in the case of UDS-D, of the UDS/SQL configuration of an STT. DBH The DBH is currently processing a DML statement for this transaction; the DBH has control.
PTC	ptc YES The distributed transaction is in the Prepared to Commit (PTC) condition, i.e. the transaction FINISH procedure has been initiated but not yet completed. - The distributed transaction is in the Prepared to Commit (PTC) condition. In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT) or a transaction distributed via openUTM.
FC	function-code Function code of the DML statement which is currently being processed or which was last processed (see section “Function codes of the DML statements”) In the case of a distributed transaction, this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT).
MR-NR
	mainref-no  Internal number assigned by the DBH to a transaction at READY; in contrast to transaction-id it is not consecutive (value range: 1 to value of PP TRANSACTION). In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT).
DLY dly
	YES The transaction is preventing the execution of pending requests (DLY corresponds to DELAYING), i.e. it must be terminated before the requests can be executed (see the DAL commands PERFORM in chapter "Performing pending requests (PERFORM)" and RESET ORDERSi n chapter "Canceling pending requests (RESET ORDERS)"). - The transaction is not preventing the execution of pending requests.
Vn.n     UDS/SQL version number
nnn	Number of currently open transactions

DISPLAY USERS,DB=dbname -
Show all transactions currently accessing the database

Input format:              DISPLAY USERS,DB=dbname

Output as under output format DISPLAY USERS for application programs which have opened database dbname by means of READY.

Example

//EXECUTE-DAL-CMD CMD=DISPLAY USERS,DB=SHIPPING

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY USERS,DB=SHIPPING (OPOX073,09:28:53/4TMW)  
4TMW: PROGRAM   TSN/TERM     RUNUNIT-ID  STATE    PTC  FC   MR-NR DLY
4TMW: ---------------------------------------------------------------
4TMW: DMLTEST   TSN 4TPM           1    USER     -    18    1    - 
4TMW:
4TMW: UDS/SQL V2.9     1 USER  OF SHIPPING
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:28:53/4TMW)  

DISPLAY SUBSCH - Show all subschemas

Input format:              DISPLAY SUBSCH

Header line:               n SUBSCHEMA(S) IN confname
Information lines: 
Database line:             DB = dbname    
Schema line:               SCHEMA = schema-name
Subschema line(s):         subschema-name [-NAME AMBIGUOUS]

Explanations:

n	Number of subschemas in the DB configuration
confname
	First eight characters of configuration name
Database line:
	dbname  Database name
Schema line:
	schema-name  Schema name
Subschema line(s):
	One line for each subschema of database dbname; it contains: subschema-name Subschema name (up to 30 characters) NAME AMBIGUOUS Addendum to all subschema names of the current DB configuration which are not unique in the first six characters. A READY to such a subschema would be rejected by the DBH with status code 141.

Example

//EXECUTE-DAL-CMD CMD=DISPLAY SUBSCH

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY SUBSCH (OPOX073,09:28:55/4TMW)  
4TMW:   2 SUBSCHEMAS IN CONFEXMP
4TMW: ===============================================
4TMW: DB     = SHIPPING
4TMW: SCHEMA = MAIL-ORDERS
4TMW: -----------------------------------------------
4TMW: ADMIN
4TMW: ===============================================
4TMW: DB     = CUSTOMER
4TMW: SCHEMA = CUSTOMER-LIST
4TMW: -----------------------------------------------
4TMW: MANAGEMENT
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:28:55/4TMW) 

DISPLAY SUBSCH,DB=dbname -
Show all subschemas in the database

Input format:              DISPLAY SUBSCH,DB=dbname

Header line:               n SUBSCHEMA(S) OF dbname
Information line(s):
Schema line:             SCHEMA = schema-name
Subschema line           subschema-name  

n	Number of subschemas in the database dbname
Schema line:
	schema-name Schema name
Subschema line:
	subschema-name Subschema name (up to 30 characters)

Example

//EXECUTE-DAL-CMD CMD=DISPLAY SUBSCH,DB=SHIPPING

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY SUBSCH,DB=SHIPPING (OPOX073,09:28:57/4TMW)  
4TMW:  1 SUBSCHEMA  OF SHIPPING
4TMW: SCHEMA = MAIL-ORDERS
4TMW: -----------------------------------------------
4TMW: ADMIN
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:28:57/4TMW) 

DISPLAY MAINREF -
Show information on mainref status

Comment line:	MR-NR	STATE	RUNUNIT-ID	TEMP
Information lines:	mainref-no	state	transaction-id	temp

MR-NR
	mainref-no Internal number assigned by the DBH to a transaction at READY; in contrast to the transaction-id it is not consecutive. Value range: 1 to value of PP TRANSACTION
STATE
	state Indicates the current status of the mainref. In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT). FREE: The mainref is not being used by any transaction and is free for a new transaction. STOP-NEW: The mainref is presently locked against use by new transactions. The lock is due to: a DAL command, or a DBH-internal command STOP The mainref is being used by a transaction in the STOP status. USED: The mainref is being used by a transaction. BLOCK: The mainref is locked against use by new transactions for the current session section due to a defect in its temporary realm The STATE values are not mutually exclusive. They are displayed according to the following hierarchy: BLOCK, STOP, STOP-NEW, FREE, USED
RUNUNIT-ID
	transaction-id  Internal transaction identifier assigned by UDS/SQL. Transactions are numbered consecutively within a session segment. In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT).
TEMP
	temp Indicates if the temporary realm is defective. - The temporary realm of this mainref is not defective. DSTR The temporary realm of this mainref has failed. In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT).

If there are permanent defects in a temporary realm, the DBH responds by locking the corresponding mainref.

Example

//EXECUTE-DAL-CMD CMD=DISPLAY MAINREF

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY MAINREF (OPOX073,09:28:59/4TMW)  
4TMW: MR-NR   STATE     RUNUNIT-ID   TEMP
4TMW: ----------------------------------------
4TMW:   1     USED        1          -
4TMW:   2     FREE        -          -
4TMW:   3     FREE        -          -
4TMW:   4     FREE        -          -
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:28:59/4TMW) 

DISPLAY MAINREF, STATE=BLOCK -
Show information on blocked mainrefs

Input format:               DISPLAY MAINREF,STATE=BLOCK 

Comment line:	MR-NR	STATE	RUNUNIT-ID	TEMP
Information line(s):	mainref-no	block	transaction-id	temp

If no mainref is blocked:
Information line: NO MAINREF IS BLOCKED

Explanations:

Only mainrefs locked against reuse by transactions, i.e. blocked, are listed. Otherwise, output is the same as for DISPLAY MAINREF.

Example

//EXECUTE-DAL-CMD CMD=DISPLAY MAINREF,STATE=BLOCK

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY MAINREF,STATE=BLOCK (OPOX073,09:28:59/4TMW)  
4TMW: NO MAINREF IS BLOCKED
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:01/4TMW)  

DISPLAY transaction-id -
Show information on transactions

Input format:              DISPLAY transaction-id

Comment	Information	Explanation
PROGRAM-NAME:	progname	Name of the application program or of the openUTM operand DBKEY or 'UTM'. In the case of a distributed transaction this operand may refer to an application program running in another configuration.
[UTM-TAC/-USER-ID:	utm-tac/utm-userid]	openUTM transaction code/openUTM user ID from the openUTM command KDCSIGN. In the case of a distributed transaction, this operand refers to the relevant primary subtransaction.
TSN:	tsn	In timesharing mode: task sequence number under which the application program runs. In the case of a distributed transaction this operand refers to the PST.
TERMINAL-NAME:	term-name	In transaction mode: logical name of the openUTM client or partner (LTERM name, LPAP name or OSI-LPAP name. In the case of a distributed transaction this operand refers to the PTT. The data display terminal may be attached to a different host.
RUNUNIT-ID / - STATE:	transaction-id/  {STOP |   AREA |   LOCK |   DEACT |   WAIT-ST |   TO-STOP |   TO-CANC |   IN-CANC |   USER |   CONNEC |   DBH}	Transaction identifier; assigned internally by UDS/SQL. Explanation of states as for DISPLAY USERS. In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT).
MAINREF-NR / - STATE:	mainref/  {STOP-NEW   STOP |   USED |   BLOCK}	Mainref number; assigned when READY is issued for the transaction. In the case of a distributed transaction this operand refers to the local subtransaction, irrespective of whether it is a PTT or an STT. For STOP-NEW, STOP, BLOCK and USED, see DIS MAINREF.
FC:	function code	Function code of the current or most recent DML statement of the transaction (see section “Function codes of the DML statements”"). In the case of a distributed transaction, this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction (PTT or STT).
PTT-PROC-NAME:	proc-name	Name of the host on which the primary subtransaction is running.
PTT-CONF-NAME:	confname	The first 8 characters of the configuration name of the primary subtransaction.
PTT-RLOG-DATE:	rlog-time-stamp	Time stamp indicating the date of generation of the associated RLOG file. This operand refers to the RLOG file of the primary subtransaction.
PTT-RUNUNIT-ID:	pst-id	Transaction identifier of the associated PTT.
LOCAL-TT-STATE:	{PTT | STT}[IN PTC]	The local subtransaction (TT) is the PTT or STT of a distributed transaction. IN PTC: The local subtransaction is in the Prepared to Commit (PTC) condition, i.e. the interconfiguration FINISH has been initiated but not yet completed.
[UTM-D-TA:	IN PTC]	The openUTM transaction is in the PTC condition.
TEMP:	DSTR	The temporary realm of this mainref has failed. In the case of a distributed transaction, this operand refers to the local subtransaction, irrespective of whether it is a primary or secondary subtransaction.

Table 16: Input format for the output of information on transactions

Example

//EXECUTE-DAL-CMD CMD=DISPLAY 1

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY 1 (OPOX073,09:29:01/4TMW)  
4TMW: PROGRAM-NAME:        DMLTEST
4TMW: TSN:                4TPM 
4TMW: RUNUNIT-ID / -STATE:        1 / USER
4TMW: MAINREF-NR / -STATE:        1 / USED
4TMW: FC:                  18
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:01/4TMW) 

DISPLAY REALMS -
Show information on all permanent realms

Input format:              DISPLAY REALMS

Comment line:		DATABASE	ACC-USER	ACC-SYS	DB-OPT	DESTR
		(USERID: userid )
Information line(s):		dbname	acc-user	acc-sys	db-opt	destr
Comment line:	CATID	REALM	ACC-USER	ACC-SYS	STATE	DEFECT
Information line(s):	catid	realm-name	acc-user	acc-sys	state	defect

Explanations:

In certain cases realms are deactivated by the DBH. The database administrator can obtain information on the status of the realms.

userid	User ID in which the database concerned is located.
DATABASE
	dbname Name of the database
CATID
	catid BS2000 catalog ID of the realm
REALM
	realm-name  Name of the realm
ACC-USER
	acc-user Indicates the access mode allowed by the database administrator by means of the ACCESS command. UPD read and write access accepted RTR only read access accepted LOCK neither read nor write access accepted
ACC-SYS
	acc-sys Indicates the access mode allowed internally by the DBH. This mode cannot be controlled by means of the ACCESS command. UPD read and write access accepted RTR only read access accepted LOCK neither read nor write access accepted
DB-OPT
	db-opt Indicates the acces to the database. EXC-UPD EXCLUSIVE-UPDATE The DBH accesses database dbname exclusively. The application programs can access the database in update mode. SHA-RTR SHARED-RETRIEVAL All DBHs can have shared access to database dbname, i.e. this database can also be attached to other DBHs (but only in SHA-RTR mode). The application programs of all DBHs have read-only access to the database.
STATE
	state Indicates the status of the realm. TMPRLM The realm is temporary. TO DROP This realm is the subject of a detach request (DROP) which has not yet been processed (completely). SWTOFF The realm has been detached by the DAL command DROP RN =, the BMEND function REMOVE-REALM or DBH error handling. TO ADD This realm is the subject of a rejoin request which has not yet been processed (completely). OPENED The realm is physically open and takes part in the session.
DESTR
	destr Indicates whether or not the database is defective (DESTR=DESTROYED) YES    The database is defective -       The database is not defective
DEFECT
	defect Indicates whether the realm in the DBH is marked as defective YES    The realm is defective -       The realm is not defective

Example

//EXECUTE-DAL-CMD CMD=DISPLAY REALMS

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY REALMS (OPOX073,09:29:01/4TMW)  
4TMW:        DATABASE (USERID: $XXXXXXXX.)  ACC-USER  ACC-SYS  DB-OPT  DESTR 
4TMW: -----------------------------------------------------------------------
4TMW:        SHIPPING                       UPD       UPD      EXC-UPD   -
4TMW: =======================================================================
4TMW: CATID  REALM                          ACC-USER  ACC-SYS  STATE   DEFECT
4TMW: -----------------------------------------------------------------------
4TMW: :IUDS: DATABASE-DIRECTORY             UPD       UPD      OPENED    -
4TMW: :IUDS: CUSTOMER-ORDER-RLM             UPD       UPD      OPENED    -
4TMW: :IUDS: PURCHASE-ORDER-RLM             UPD       UPD      OPENED    -
4TMW: :IUDS: CLOTHING                       UPD       UPD      OPENED    -
4TMW: :IUDS: HOUSEHOLD-GOODS                UPD       UPD      OPENED    -
4TMW: :IUDS: SPORTS-ARTICLES                UPD       UPD      OPENED    -
4TMW: :IUDS: FOOD                           UPD       UPD      OPENED    -
4TMW: :IUDS: LEISURE                        UPD       UPD      OPENED    -
4TMW: :IUDS: STATIONERY                     UPD       UPD      OPENED    -
4TMW: :IUDS: ARTICLE-RLM                    UPD       UPD      OPENED    -
4TMW:   -    SEARCH-RLM                      -         -       TMPRLM    -
4TMW:
4TMW:        DATABASE (USERID: $XXXXXXXX.)  ACC-USER  ACC-SYS  DB-OPT  DESTR 
4TMW: -----------------------------------------------------------------------
4TMW:        CUSTOMER                       UPD       UPD      EXC-UPD   -
4TMW: =======================================================================
4TMW: CATID  REALM                          ACC-USER  ACC-SYS  STATE   DEFECT
4TMW: -----------------------------------------------------------------------
4TMW: :IUDS: DATABASE-DIRECTORY             UPD       UPD      OPENED    -
4TMW: :IUDS: CUSTOMER-RLM                   UPD       UPD      OPENED    -
4TMW: :IUDS: FINANCE-RLM                    UPD       UPD      OPENED    -
4TMW
\
:   -         TEMPRLM                    -         -       TMPRLM    -
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:03/4TMW) 

DISPLAY REALMS,DB=dbname -
Show information on all permanent realms of a database

Input format:	DISPLAY REALMS,DB=dbname
Explanation:	Same as DISPLAY REALMS; output refers to the database dbname only

Example

//EXECUTE-DAL-CMD CMD=DISPLAY REALMS,DB=SHIPPING

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY REALMS,DB=SHIPPING (OPOX073,09:29:07/4TMW)  
4TMW:        DATABASE (USERID: $XXXXXXXX.)  ACC-USER  ACC-SYS  DB-OPT  DESTR 
4TMW: -----------------------------------------------------------------------
4TMW:        SHIPPING                       UPD       UPD      EXC-UPD   -
4TMW: =======================================================================
4TMW: CATID  REALM                          ACC-USER  ACC-SYS  STATE   DEFECT
4TMW: -----------------------------------------------------------------------
4TMW: :IUDS: DATABASE-DIRECTORY             UPD       UPD      OPENED    -
4TMW: :IUDS: CUSTOMER-ORDER-RLM             UPD       UPD      OPENED    -
4TMW: :IUDS: PURCHASE-ORDER-RLM             UPD       UPD      OPENED    -
4TMW: :IUDS: CLOTHING                       UPD       UPD      OPENED    -
4TMW: :IUDS: HOUSEHOLD-GOODS                UPD       UPD      OPENED    -
4TMW: :IUDS: SPORTS-ARTICLES                UPD       UPD      OPENED    -
4TMW: :IUDS: FOOD                           UPD       UPD      OPENED    -
4TMW: :IUDS: LEISURE                        UPD       UPD      OPENED    -
4TMW: :IUDS: STATIONERY                     UPD       UPD      OPENED    -
4TMW: :IUDS: ARTICLE-RLM                    UPD       UPD      OPENED    -
4TMW:   -    SEARCH-RLM                      -         -       TMPRLM    -
4TMW:
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:09/4TMW) 

DISPLAY REALMS,RN=realm-name[,DB=dbname] -
Show information on a permanent realm

Input format:	DISPLAY REALMS,RN=realm-name[,DB=dbname]
Explanation:	Same as DISPLAY REALMS; output refers to the realm realm-name [of database dbname] only The specification of DB=dbname can be omitted if the realm name specified is unambiguous in the configuration.

DISPLAY PP - Show current DBH load parameters

Input format:              DISPLAY PP

Information line(s):	MAXDB	= n 1
	TRANSACTION	= n 2 or (n 2,n 3) for UDS-D
	[SUBTRANSACTION	= n 4]
	SUBSCHEM	= n 5
	SERVERTASK	= n 6
	2KB-BUFFER-SIZE	= n 7a
	4KB-BUFFER-SIZE	= n 7b
	8KB-BUFFER-SIZE	= n 7c
	CP-SIZE	= n 8
	CUP-SIZE	= n 9
	SIP-SIZE	= n 10
	[DIP-SIZE	= n 11] for UDS-D
	[DISDB	= n 12] for UDS-D
	[CHCKTIME	= n 13] for UDS-D
	DEADTIME	= n 14
	DISTRIBUTION	= {NO | STANDBY | START}
	PTCSYNCH	= ({WAIT | ABORT | COMMIT})
	LOG	= {NO | :catid: | PUBLIC |    (priv-vsn-1/device-1[,priv-vsn-2 device-2 [,priv-vsn-3 device-3]]) |  (vsn-1[,vsn-2[,vsn-3]])}
	LOG-2	= {NO |    :catid: |    PUBLIC |    (priv-vsn-1/device-1[,priv-vsn-2 device-2 [, priv-vsn-3 device-3 ]]) | (vsn-1[,vsn-2[,vsn-3]])}
	LOG-SIZE	= (primary,secondary])
	RESERVE	= {NONE | :catid: |   (priv-vsn-1/gerät-1[,priv-vsn-2 gät-2 [,priv-vsn-3 gerät-3]]) |   (vsn-1[,vsn-2[,vsn-3]])}
	WARMSTART	= {STD | FAST | VERY-FAST}
	DEACT	= {YES | NO}
	STDCKPT	= {YES | NO}
	ADM	= {LOCAL | REMOTE}
	CP	= {MONO-PROCESSOR | MULTI-PROCESSOR}
	[SQL	= n 15]
	[SQL-LIMIT	= n 16]
	[DISTABLE	= {NO | [:catid:][$userid.]file-name}] for UDS-D
	TASKLIB	= {NO | [:catid:][$userid.]udsmodlib}
	DUMP	= {STD | ALL}
	MPSEG	= {STD | 64K}
	UCON	= C'{(mn) | <x | nnnn}]'[,{MSG | UDS}]
	SECLEVEL	= {F2 | F2-EXCEPT | NO},NO-AUDIT
	LOCK	= {STD | SHARED | EXCLUSIVE}
	TA-ACCESS	= {STD | SHARED}
	WAIT	= {EVENT | BUSY}
	RESULT-DELAY	= n 17
	SCHEDULING	= {SYMMETRIC | ASYMMETRIC}
	IO	= {ASYNC | SYNC}
	ORDER-DBSTATUS	= {STD | SPECIAL}
	PRIVACY-CHECK	= {STD | NO-KSET | OFF}
	BCAM-PREFIX	= prefix
	CONFNAME	= [$ userid. ] confname
	DATABASES OF CONFIGURATION:
	$userid.dbname,{EXCLUSIVE-UPD [,bbbb][,buffid|SHARED-RTR[,bbbb][,buffid}                 Up to MAXDB lines; empty configuration

n 1	Number of databases in the DB configuration
n 2	Max. number of simultaneously active transactions
n 3	Max. number of transactions simultaneously active for remote application programs
n 4	Number of KDBS logical file names (KDBS only)
n 5	Max. number of subschemas usable simultaneously per database
n 6	Number of server tasks
n 7a	Size of the system buffer pool for databases with a 2-Kbyte page format in Mbytes
n 7b	Size of the system buffer pool for databases with a 4-Kbyte page format in Mbytes
n 7c	Size of the system buffer pool for databases with an 8-Kbyte page format in Mbytes
n 8	Minimum size of a common pool in Kbytes
n 9	Size of the communication pool in Kbytes
n 10	Size of the SSITAB pool in Kbytes
n 11	Size of the distribution pool in Kbytes
n 12	Max. number of remote databases per transaction
n 13	Time, in seconds, for connection and transaction checking by the UDS-D task
n 14	Time, in seconds, for resolving interconfiguration deadlocks or deadlocks involving openUTM
n 15	Number of simultaneously active SQL conversations
n 16	Time for inactive conversations
n 17	Number of request responses to be grouped
bbbb	Size of the user buffer pool of the database in Mbytes without leading zeros; omitted if the system buffer pool has been assigned to the database.
buffid	Name of the shared user buffer pool, if a shared user buffer pool has been assigned to the database. *EXCL indicates that an exclusive user buffer pool has been assigned to the database. *SYSTEM indicates that the system buffer pool has been assigned to the database.
prefix	The BCAM names of the user tasks are formed from prefix and TSN.

Explanations:

The call outputs the current values of the DBH load parameters, including DAL changes.

They are listed in the same form as when PP PARLIST=YES is specified during the start phase.

The load parameters TASKLIB and SECLEVEL are ineffective. They are only still supported for compatibility reasons.

Example

//EXECUTE-DAL-CMD CMD=DISPLAY PP

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY PP (OPOX073,09:29:11/4TMW)  
4TMW: MAXDB          =      2
4TMW: TRANSACTION    = (    4,    1)
4TMW: SUBSCHEMA      =      1
4TMW: SERVERTASK     =      1
4TMW: 2KB-BUFFER-SIZE=      1
4TMW: 4KB-BUFFER-SIZE=      1
4TMW: 8KB-BUFFER-SIZE=      0
4TMW: CP-SIZE        =   1024
4TMW: CUP-SIZE       =   1024
4TMW: SIP-SIZE       =   1024
4TMW: DIP-SIZE       =   1024
4TMW: DISDB          =      1
4TMW: CHCKTIME       =     60
4TMW: DEADTIME       =     60
4TMW: DISTRIBUTION   = START
4TMW: PTCSYNCH       = (WAIT  ,WAIT  )
4TMW: LOG            = PUBLIC
4TMW: LOG-2          = NO
4TMW: LOG-SIZE       = (    192,    192)
4TMW: RESERVE        = NONE
4TMW: WARMSTART      = STD
4TMW: DBDCSYNCH      = YES
4TMW: DEACT          = YES
4TMW: STDCKPT        = YES
4TMW: ADM            = REMOTE
4TMW: CPU            = MONO-PROCESSOR
4TMW: DISTABLE       = UDSDBB.VT.EXAMPLE.START
4TMW: SQL            =     4
4TMW: SQL-LIMIT      =     10
4TMW: TASKLIB        = NO
4TMW: DUMP           = ALL
4TMW: MPSEG          = STD
4TMW: UCON           = C'<U  ',MSG
4TMW: SECLEVEL       = NO      ,NO-AUDIT
4TMW: LOCK           = STD
4TMW: TA-ACCESS      = STD
4TMW: WAIT           = EVENT
4TMW: RESULT-DELAY   =      0
4TMW: SCHEDULING     = SYMMETRIC
4TMW: IO             = ASYNC
4TMW: ORDER-DBSTATUS = STD
4TMW: PRIVACY-CHECK  = OFF
4TMW: BCAM-PREFIX    = SUD$
4TMW: CONFNAME       = $XXXXXXXX.CONFEXMP
4TMW: DATABASES OF CONFIGURATION:
4TMW:   $XXXXXXXX.SHIPPING                      ,EXCLUSIVE-UPD     ,*SYSTEM
4TMW:   $XXXXXXXX.CUSTOMER                      ,EXCLUSIVE-UPD,   1,*EXCL
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  COMMAND  (OPCC074,09:29:13/4TMW) 

DISPLAY FPA -
Show information on free pages in all realms

Input format:	DISPLAY FPA
Comment line:	DATABASE
Information line(s):	dbname

Comment lines:          RLM        REALM       NR        NR FREE      SECOND
                        REF                    PAGES     PAGES        SCAN

Information line(s):    realm-     realm-name  n         n            second
                        reference                                     scan

Explanations:

The database administrator can obtain information on the number of free pages in the realms.

DATABASE

dbname
Name of the database

RLMREF

realm-reference
Number of the realm

REALM

realm-name
Name of the realm

NR PAGES n

Number of pages in the realm

NR FREE PAGES n

Number of free pages in the realm

SECOND SCAN -

second scan
Search mode

-
The realm has not yet been searched completely for free pages. The search mode"First Scan" is used (space for new data which is to be stored is searched for in the free area at the end of the realm).

YES
The realm has already been searched completely for free pages once. The search mode "Second Scan" is used (space for new data which is to be stored is searched for from the start of the realm).

Example

//EXECUTE-DAL-CMD CMD=DISPLAY FPA

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY FPA (OPOX073,09:29:22/4TMW)  
4TMW: DATABASE
4TMW: -------------------------------------------------------------
4TMW: SHIPPING
4TMW: =============================================================
4TMW: RLM  REALM                          NR      NR FREE  SECOND
4TMW: REF                                 PAGES   PAGES    SCAN
4TMW: -------------------------------------------------------------
4TMW:   1  DATABASE-DIRECTORY                100       49    -
4TMW:   3  CUSTOMER-ORDER-RLM                 36       22    -
4TMW:   4  PURCHASE-ORDER-RLM                 60       33    -
4TMW:   5  CLOTHING                           54       29    -
4TMW:   6  HOUSEHOLD-GOODS                    24       16    -
4TMW:   7  SPORTS-ARTICLES                    44       35    -
4TMW:   8  FOOD                               18        9    -
4TMW:   9  LEISURE                            44       35    -
4TMW:  10  STATIONERY                         24       17    -
4TMW:  11  ARTICLE-RLM                        62       13    -
4TMW:
4TMW: DATABASE
4TMW: -------------------------------------------------------------
4TMW: CUSTOMER
4TMW: =============================================================
4TMW: RLM  REALM                          NR      NR FREE  SECOND
4TMW: REF                                 PAGES   PAGES    SCAN
4TMW: -------------------------------------------------------------
4TMW:   1  DATABASE-DIRECTORY                100       55    -
4TMW:   3  CUSTOMER-RLM                      126       23    -
4TMW:   4  FINANCE-RLM                       126      117    -
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:22/4TMW) 

DISPLAY FPA,DB=dbname -
Show information on free pages in all realms of a database

Input format:	DISPLAY FPA,DB=dbname
Explanation:	Same as DISPLAY FPA; output refers to database dbname only

DISPLAY FPA,RN=realm-name[,DB=dbname]-
Show information on free pages in a realm

Input format:	DISPLAY FPA,RN=realm-name[,DB=dbname]
Explanation:	Same as DISPLAY FPA; output refers to the realm realm-name [of database dbname] only The specification of DB=dbname can be omitted if the realm name specified is unambiguous in the configuration.

DISPLAY XFPA -
Show extended information on free pages in all realms

Input format:	DISPLAY XFPA
Comment line:	DATABASE
Information line(s)	dbname

Comment       RLM      NR    NR FREE NR FULL PARTIAL-FILLED  SECOND SEARCH
lines:        REF      PAGES PAGES   PAGES   NR PAGES  FIL%  SCAN   IN FPA

Information   realm-   n     n       n       n         n            second search
line(s):      reference                                             scan   in fpa

Explanations:

The database administrator can obtain information on the number of (free) pages in the realms.

DATABASE	dbname Name of the database
RLMREF	realm-reference Number of the realm
NR PAGES
	Number of pages in the realm
NR FREE PAGES
	Number of free pages in the realm
NR FULL PAGES
	Number of full pages in the realm
PARTIAL-FILLED NR PAGES
	Number of partially filled pages in the realm
FIL%	Average filling level of all partially filled pages in the realm
SECOND SCAN
	second scan Search mode - The realm has not yet been searched completely for free pages. The search mode"First Scan" is used (space for new data which is to be stored is searched for in the free area at the end of the realm). YES The realm has already been searched completely for free pages once. The search mode "Second Scan" is used (space for new data which is to be stored is searched for from the start of the realm).
SEARCH IN FPA
	search in fpa The value of SET-FPA-SCAN-PARAMETERS which was stored by the UDS online utility or, for BMODTT, the value SET/RESET REUSE-FREE-SPACE. REUSE Space for new records and tables which are to be stored is searched for from the start of the realm (Second Scan). NOREUSE Space for new records and tables which are to be stored is searched for at the end of the realm after the first page of the contiguous range of free pages (First Scan).

Example

//EXECUTE-DAL-CMD CMD=DISPLAY XFPA

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY XFPA (OPOX073,09:29:28/4TMW) 
4TMW: DATABASE
4TMW: ------------------------------------------------------------------
4TMW: SHIPPING
4TMW: ==================================================================
4TMW: RLM     NR      NR FREE   NR FULL  PARTIAL-FILLED  SECOND  SEARCH 
4TMW: REF     PAGES   PAGES     PAGES    NR PAGES  FIL%  SCAN    IN FPA 
4TMW: ------------------------------------------------------------------
4TMW:   1       100        49        44         7    75    -     NOREUSE
4TMW:   3        36        22        13         1     2    -     NOREUSE
4TMW:   4        60        33        25         2    37    -     NOREUSE
4TMW:   5        54        29        10        15    27    -     NOREUSE
4TMW:   6        24        16         8         0     -    -     NOREUSE
4TMW:   7        44        35         9         0     -    -     NOREUSE
4TMW:   8        18         9         5         4     7    -     NOREUSE
4TMW:   9        44        35         9         0     -    -     NOREUSE
4TMW:  10        24        17         7         0     -    -     NOREUSE
4TMW:  11        62        13        42         7     7    -     NOREUSE
4TMW:
4TMW: DATABASE
4TMW: ------------------------------------------------------------------
4TMW: CUSTOMER
4TMW: ==================================================================
4TMW: RLM     NR      NR FREE   NR FULL  PARTIAL-FILLED  SECOND  SEARCH 
4TMW: REF     PAGES   PAGES     PAGES    NR PAGES  FIL%  SCAN    IN FPA 
4TMW: ------------------------------------------------------------------
4TMW:   1       100        55        38         7    74    -     NOREUSE
4TMW:   3       126        23       100         3    39    -     NOREUSE
4TMW:   4       126       117         7         2    22    -     NOREUSE
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:28/4TMW) 

DISPLAY XFPA,DB=dbname -
Show extended information on free pages in all realms of a database

Input format:	DISPLAY XFPA,DB=dbname
Explanation:	Same as DISPLAY XFPA; output refers only to the database specified with dbname.

DISPLAY XFPA,RN=realm-name[,DB=dbname] -
Show extended information on free pages in a realm

Input format:	DISPLAY XFPA,RN=realm-name[,DB=dbname]
Explanation:	Same as DISPLAY XFPA; output refers only to the realm specified with realm-name [of the database dbname]. The specification of DB=dbname can be omitted if the realm name specified is unambiguous in the configuration.

DISPLAY INCR -
Show information on online extensibility of all activated realms in the database configuration

Input format:              DISPLAY INCR

Information line(s):   DATABASE (USERID: $xxxxxxxx.)
Information line(s):   dbname              
Comment lines:         RLM REALM       INCR  NR      MIN      FMT   EXT  EXT
                       REF             ACT      PAGES   PAGES       PND  SIZE
Information line(s):   n   realmname   incr  n       n        fmt   ext  n
                                       act                          pnd

Explanations:

The database administrator can obtain information on the online extensibility of the realms.

USERID

User ID in which the database concerned is located.

DATABASE

dbname
Name of the database

RLM REF

realmname
Number of the realm

REALM

Name of the realm

INCR ACT

incr act
Online extensibility

YES
Online extensibility is activated for the realm and not suspended.

NO
Online extensibility is not activated for the realm.

SUSP
Online extensibility is activated for the realm, but suspended in the current part of the session.

NR PAGES n

Number of pages by which the realm is to be extended if required.

MIN PAGES n

Number of free pages in the realm below which an online realm extension will be started.

FMT

fmt
Formatierung der neu hinzugefügten Datenbankseiten

YES
It is necessary for the DBH to format the newly added database pages.

NO
It is not necessary for the DBH to format the newly added database pages.

EXT PND

ext pnd
Display for unconditional realm extension.

YES
Unconditional one-time realm extension (one realm extension per DAL command) is noted.

NO
Unconditional one-time realm extension (one realm extension per DAL command) is not noted.

EXT SIZE

Number of database pages required for extension.
This is displayed only if unconditional one-off realm extension is noted, in other words EXT PND is equal to YES. 

Example

//EXECUTE-DAL-CMD CMD=DISPLAY INCR

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY INCR (OPOX073,09:29:34/4TMW)   
4TMW: DATABASE (USERID: $XXXXXXXX.)
4TMW: --------------------------------------------------------------------------
4TMW: SHIPPING
4TMW: ==========================================================================
4TMW: RLM REALM                      INCR NR      MIN       FMT EXT   EXT 
4TMW: REF                            ACT     PAGES    PAGES     PND   SIZE 
4TMW: --------------------------------------------------------------------------
4TMW:   1 DATABASE-DIRECTORY         YES        64        0 YES NO 
4TMW:   3 CUSTOMER-ORDER-RLM         YES      2000      400 NO  NO 
4TMW:   4 PURCHASE-ORDER-RLM         YES        64        0 NO  NO 
4TMW:   5 CLOTHING                   YES        64        0 NO NO 
4TMW:   6 HOUSEHOLD-GOODS            YES        64        0 NO  NO 
4TMW:   7 SPORTS-ARTICLES            YES        64        0 NO  NO 
4TMW:   8 FOOD                       YES       500       50 NO  NO 
4TMW:   9 LEISURE                    YES        64        0 NO  NO 
4TMW:  10 STATIONERY                 YES        64        0 NO  NO 
4TMW:  11 ARTICLE-RLM                YES      1000      100 NO  NO 
4TMW:
4TMW: DATABASE (USERID: $XXXXXXXX.)
4TMW: --------------------------------------------------------------------------
4TMW: CUSTOMER
4TMW: ==========================================================================
4TMW: RLM REALM                      INCR NR      MIN       FMT EXT   EXT 
4TMW: REF                            ACT     PAGES    PAGES     PND   SIZE 
4TMW: --------------------------------------------------------------------------
4TMW:   1 DATABASE-DIRECTORY         YES        64        0 YES NO 
4TMW:   3 CUSTOMER-RLM               YES       500       30 NO  NO 
4TMW:   4 FINANCE-RLM                YES        64        0 NO  NO 
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:34/4TMW)  

DISPLAY INCR, DB=dbname -
Show information on the online extensibility of all activated realms in a database

Input format:	DISPLAY INCR, DB=dbname
Explanation:	As for DISPLAY INCR; the output only relates to the active realms of the database dbname.

DISPLAY INCR,RN=realm-name [,DB=dbname] -
Show information on the online extensibility of a realm

Input format:	DISPLAY INCR[, DB=dbname],RN=realm-name
Explanation:	As for DISPLAY INCR; the output only relates to the realm realm-name. The specification DB=dbname can be omitted if the named realm name is unique in the configuration.

DISPLAY DBTT-INCR -
Show information on the online DBTT extensibility of the record types for the user schemata in the DB configuration

Input format:              DISPLAY DBTT-INCR

Information line(s):  DATABASE (USERID: $xxxxxxxx.)

Information line(s):  dbname

Comment lines:        REC RECORD    RLM DBTT   NR      EXT   HIGHEST    EXT
                      REF           REF ACT    ENTRIES PND          RSQ SIZE

Information line(s):  n   recordname n  dbtt   n       ext   n          n
                                        act            pnd

Explanations:

The database administrator can obtain information on the online extensibility of the DBTTs.

USERID

User ID in which the database concerned is located.

dbname

Name of the database

REC REF n

Number of the record type

RECORD

recordname
Name of the record type

RLM REF n

Number of the realm
The DAL command DISPLAY INCR,DB=dbname can be used to identify the name of the realm.

DBTT ACT

dbtt act
Indicates whether online DBTT extension is active:

SCAN
Online DBTT extension is active and not suspended. No online DBTT extension is performed until no further free entry can be found in the entire DBTT.

NOSCAN
Online DBTT extension is active and not suspended. Online DBTT extension is performed if the search for a free entry is unsuccessful with the highest currently possible RSQ. Consequently, no renewed search for free entries with a lower RSQ is undertaken.

NO
Online DBTT extension is not active.

SUSP
Online DBTT extension has been suspended in the current session.
This may be because online realm extension has been suspended in the corresponding realm or because the maximum size of the DBTT has been reached.

SWTOFF
The realm containing the DBTT is not currently available. The activation state is unclear.

NR ENTRIES n

Number of entries for DBTT extension.

EXT PND

ext pnd
Information on as yet unexecuted EXTEND-DBTT requests:

YES
A request has been noted for this record type. The request will be executed the next time a record is stored.

NO
No request has been noted.

HIGHEST RSQ n

Highest possible RSQ for the record type in the current DBTT

EXT SIZE n

Number of DBTT entries required for extension.
This is displayed only if unconditional one-off DBTT extension is noted, in other words EXT PND is equal to YES.

If the maximum number of output lines for a DISPLAY command is not sufficient to output the information for all the record types then a corresponding message is output:

OUTPUT OF nnnn FURTHER LINES SUPPRESSED

There is no command allowing you to resume this interrupted DISPLAY command. To obtain the information for all the record types, you must repeat the command, for example with LINES=ALL. The corresponding information can also be provided for individual databases using the BSTATUS utility routine.

In all cases, the following message is then output:

UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND

If an online DBTT extension fails, you can obtain information on the reasons for its suspension as follows:

• with the DAL command DISPLAY INCR

• using the value HIGHEST RSQ in the DISPLAY DBTT-INCR command

Example

//EXECUTE-DAL-CMD CMD=DISPLAY DBTT-INCR

%  UDS0220 UDS RECEIVED COMMAND: DISPLAY DBTT-INCR (OPOX073,09:29:40/4TMW) 
4TMW: DATABASE (USERID: $XXXXXXXX.)
4TMW: -------------------------------------------------------------------------
4TMW: SHIPPING
4TMW: =========================================================================
4TMW: REC   RECORD               RLM DBTT   NR       EXT HIGHEST    EXT
4TMW: REF                        REF ACT    ENTRIES  PND        RSQ SIZE
4TMW: -------------------------------------------------------------------------
4TMW:     2 CUSTOMER               3 SCAN      21184 NO        331
4TMW:     3 CST-ORDERS             3 SCAN      31808 NO        497
4TMW:     4 ORD-ITEM               3 SCAN      63680 YES      1990    63680
4TMW:     5 INSTALMENT             3 SCAN      63680 NO        995
4TMW:     6 ART-TYPE              11 NOSCAN    31808 NO        497
4TMW:     7 ART-SELECTION         11 SCAN      31808 NO        497
4TMW:     8 ART-DESCR             11 SCAN      31808 NO        497
4TMW:     9 ARTICLE               11 NOSCAN    63680 YES       995    63680
4TMW:    10 SUBSET                 6 SCAN      63680 NO        995
4TMW:    11 COLORS                11 SCAN      63680 NO        995
4TMW:    12 MATERIALS             11 NOSCAN    63680 NO        995
4TMW:    13 SUPPLIER               4 SCAN      21184 NO        662
4TMW:    14 PURCHASE-ORDER         4 SCAN      31808 NO        497
4TMW:    15 P-ORD-ITEM             4 SCAN      63680 NO        995
4TMW:
4TMW: DATABASE (USERID: $XXXXXXXX.)
4TMW: -------------------------------------------------------------------------
4TMW: CUSTOMER
4TMW: =========================================================================
4TMW: REC   RECORD              RLM DBTT   NR        EXT HIGHEST    EXT
4TMW: REF                       REF ACT    ENTRIES   PND       RSQ SIZE
4TMW: -------------------------------------------------------------------------
4TMW:     2 CUSTOMER              3 SCAN      21184  NO        662
4TMW:     3 OPEN-ITEMS            3 SCAN      63680  NO        995
4TMW:     4 KREDIT                4 SCAN      63680  NO       1990
%  UDS0218 UDS COMPLETED EXECUTION OF DAL COMMAND  (OPCC074,09:29:40/4TMW) 

DISPLAY DBTT-INCR,DB=dbname -
Show information on the online DBTT extensibility of the record types for the user schema in a database

Input format:	DISPLAY DBTT-INCR,DB=dbname
Explanation:	As DISPLAY DBTT-INCR; the output relates only to the record types of the user schema in the database dbname.

DISPLAY DBTT-INCR,DB=dbname,RECR=recordref -
Show information on the online DBTT extensibility of a record type

Input format:	DISPLAY DBTT-INCR,DB=dbname,RECR=recordref
Explanation:	As DISPLAY DBTT-INCR; the output relates only to the record type with the record type recordref of the user schema in the database dbname.

DISPLAY PUBSETS -
Show the settings of the UDS/SQL pubset declaration

Input format:              DISPLAY PUBSETS

Explanations:

Header line:          UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS

Information line:     UDS-PUBSET-JV: jv-name


Information line(s):  PUBSETS: catid-group


End line:             DEFAULT PUBSET: default-catid


jv-name

Name of the pubset declaration job variable

catid-group

Catid group which was specified in the UDS/SQL pubset declaration.

default-catid

Default catalog ID of the configuration user ID

The database administrator can obtain information on the current settings of the UDS/SQL pubset declaration. Between the DAL commands NEW PUBSETS and PERFORM the settings of the new UDS pubset declaration are also shown in the same format but with the insert "PENDING" instead of "CURRENT" in message UDS0746.

If no UDS pubset declaration is available, the following is shown to indicate that there is no explicitly specified catid group "*":

UDS0747 UDS PUBSET DECLARATION NOT PRESENT, DEFAULT IS CATID * (CURRENT) (...,tsn4)

DISPLAY ALOG [,DB=dbname] -
Show ALOG settings

Input format:              DISPLAY ALOG [,DB=dbname]

Comment line: USERID  DATABASE-NAME DEF-SUP  RES-SUP  PRIM-ALL SEC-ALL SHARE
Information   userid .dbname        def-cat  res-cat  prim     sec     share
line(s):

End line:     UDS/SQL Vn.n nnn DATABASE(S) IN confname

Explanations:

The database administrator can obtain information on settings of the ALOG files.

USERID

userid
User identification to which the database is assigned.

DATABASE-NAME

dbname
Name of the database

DEF-SUP

def-cat
BS2000 catalog ID for default support

RES-SUP

res-cat
BS2000 catalog ID for reserve support

PRIM-ALL

prim
Primary allocation of ALOG file

SEC-ALL

sec
Secondary allocation of ALOG file

SHARE

share
ALOG file accessibility

YES
ALOG file is accessible for all users

NO
ALOG file is accessible only for owner

Vn.n       UDS/SQL version number

nnn        Number of databases in the DB configuration

Example

0L9M: USERID    DATABASE-NAME       DEF-SUP  RES-SUP  PRIM-ALL  SEC-ALL  SHARE 
0L9M: -------------------------------------------------------------------------
0L9M: $XXXXXXXX.SHIPPING               IUDS     ABN2       192      576     NO 
0L9M: $XXXXXXXX.CUSTOMER               IUDS     IUDS       300      600    YES 
0L9M:
0L9M: UDS/SQL V2.9   2 DATABASES IN CONFEXMP