gtpo1mfaOperations

ZSQLD-Display and Maintain the Structured Query Language Database Management System Directory

Use this command to maintain and display the structured query language (SQL) database management system (DBMS) directory. You can perform the following functions:

Requirements and Restrictions

The TPF Application Requester (TPFAR) feature must be installed on the TPF system.

Format




Notes:

  1. This parameter is optional when you specify the MODIFY parameter.

  2. The default values apply only when you specify the ADD parameter.

Add
defines a new relational database.

Modify
changes an existing relational database definition.

Attention: This parameter can deallocate all conversations in the hot conversation or hot connection (hotcon) table (HCT) or close all sockets in the HCT.

Rdb-rdbname
is the 1- to 18-character alphanumeric name of a remote relational database.
Note:
If you specify the DISPLAY SHORT or REMOVE parameters, you can use an asterisk (*) as a wildcard character for this parameter.

Lu-luname
is the 1- to 8-character alphanumeric name of the logical unit where the relational database is located.
Note:
The logical unit must be a primary remote LU 6.2 resource.

Hostname-hostn
is the 1- to 128-character alphanumeric host name of the server or a dotted decimal notation of the Internet Protocol (IP) address of the server.

MOde-mode
is 1- to 8-character alphanumeric name of the Advanced Program-to-Program Communications (APPC) mode used with the relational database when an APPC allocate verb is issued.

Netid-netid
is the 1- to 8-character alphanumeric ID of the network where the relational database is located.
Note:
To clear the network ID, you must specify the MODIFY parameter and specify an asterisk (*) for the NETID parameter.

CCsid-ccsid
is the coded character set identifier (CCSID) for the relational database in the range 0-65 536.

The CCSID for the server is what you specify until the server completes connection. After the server completes connection, the CCSID is the coded character set (or sets) actually used by the server.

CCSIDs are specified by a single CCSID or three CCSIDs connected by periods. If you specify a single CCSID, the corresponding relational database must be a single-byte or a multi-byte system.

CCsid-ccsid.ccsid.ccsid
are the coded character set identifiers (CCSIDs) for the relational database in the range 0-65 536.

The CCSID for the server is what you specified until the server completes connection. After the server completes connection, the CCSID is the coded character set (or sets) actually used by the server.

CCSIDs are specified either by a single CCSID or three CCSIDs connected by periods (ccsid.ccsid.ccsid). If you specify several CCSIDs, the corresponding relational database is assumed to be a mixed-byte system. If you specify a mixed-byte system, the CCSIDs specified must be a legal combination of single-byte, double-byte, and mixed-byte CCSIDs in that order.

TPFCCsi-ccsid
is the coded character set identifier (CCSID) for the TPF system database in the range 0-65 536. The same considerations described for CCSIDs also apply to the TPFCCsi parameter.

TPFCCsi-ccsid.ccsid.ccsid
is the coded character set identifier (CCSID) for the TPF system database in the range 0-65 536. The same considerations described for CCSIDs also apply to the TPFCCsi parameter.

MAxhc-maxhc
is the maximum number of hot conversations or hot connections (hotcons) allocated to the relational database in the range 0-65 535.

Display
displays information about a relational database.

Long
displays summary information and diagnostic information about a relational database.

Short
displays only summary information about one or more relational databases.

INITialize
initializes the SQL DBMS directory.

Remove
deletes one or more relational database definitions.

Trace
controls the retention of SQL trace entries. Trace information from the SQL communications area is retained in a circular buffer. You can display this information by using the ZSTTD command. Specify one of the following:

ALL
specifies that global tracing is active, so that all request and response traffic with a remote database is retained. If tracing is not set, it defaults to ALL.

SEL
specifies that selective tracing is active and only request/response traffic for a specified relational database is retained. Databases are specified by using the SELECT parameter with the ADD or MODIFY parameters ZSQLD command.

SELect
controls the retention of SQL trace entries for an individual relational database when selective tracing is enabled, where:

ON
means trace entries are retained.

OFF
means trace entries are not retained.

The default is ON. If selective tracing is enabled and no relational databases have been selected, no trace entries are retained.

For example, if ZSQLD TRACE SEL is issued, followed by ZSQLD MODIFY RDB-DB23PRD SEL-ON, selective tracing is enabled for DB23PRD relational database traffic. Specifying ZSQLD MODIFY RDB-DB23PRD SEL-OFF stops retention of the traffic between the TPF system and the remote server.

POrt-port
is the port number for the database on the remote application server in the range 0-65 536.

Additional Information

Examples

A new relational database with a specified host name is defined in the following example.

+--------------------------------------------------------------------------------+
|User:   ZSQLD A R-DB23TST HOST-9.117.147.166                                    |
|                                                                                |
|System: SQLD0011I 17:09:22 SDD ENTRY FOR RDB-DB23TST ADDED                      |
+--------------------------------------------------------------------------------+

The SQL DBMS directory is initialized in the following example.

+--------------------------------------------------------------------------------+
|User:   ZSQLD INITIALIZE                                                        |
|                                                                                |
|System: SQLD0014I 10:38:33 SDD INITIALIZED                                      |
+--------------------------------------------------------------------------------+

A new relational database is defined in the following example.

+--------------------------------------------------------------------------------+
|User:   ZSQLD A R-DB2A LU-LU62AAA MAXHC-12                                      |
|                                                                                |
|System: SQLD0011I 10:40:12 SDD ENTRY FOR RDB-DB2A ADDED                         |
+--------------------------------------------------------------------------------+

In the following example, a relational database with a mixed-byte CCSID is defined with the TPF system also having a mixed-byte CCSID and with selective tracing being enabled for it.

+--------------------------------------------------------------------------------+
|User:   ZSQLD A R-DB2A LU-LU62AAA CC-1027.4396.5035 TPFCC-1027.4396.5035 SEL-ON |
|                                                                                |
|System: SQLD0011I 10:40:12 SDD ENTRY FOR RDB-DB2A ADDED                         |
+--------------------------------------------------------------------------------+

Summary information about all the relational databases is displayed in the following example, where:

 RDB 
is the name of the remote relational database.

 NETID 
is the network ID of the remote relational database, or N/A if this relational database is accessed by TCP/IP.

 LU 
is the logical unit name of the remote relational database, or N/A if this relational database is accessed by TCP/IP.

 MAXHC 
is the maximum number of hot conversations or hot connections allocated to the remote relational database.

 SEL 
is the selective trace status (either ON or OFF).

 HOSTNAME 
is the name of the host or IP address of the server, or N/A if this relational database is accessed by TCP/IP.
+--------------------------------------------------------------------------------+
|User:   ZSQLD DIS S RDB-*                                                       |
|                                                                                |
|System: SQLD0118I 10.48.54                                                      |
|        START OF ZSQLD DISPLAY                                                  |
|        RDB                 NETID    LU        MAXHC  SEL  HOSTNAME             |
|        ---                 -----    --        -----  ---  --------             |
|        TPFDB               N/A      N/A       3      ON   9.117.147.166        |
|        DB23TST                      DB2TESTP  0      ON   N/A                  |
|        DB23PRD             TPFNOD1  DB2PRDS   2      OFF  N/A                  |
|        END OF ZSQLD DISPLAY                                                    |
+--------------------------------------------------------------------------------+

Summary and diagnostic information about the DB2TST relational database is displayed in the following example, where:

 RDB 
is the name of the remote relational database.

 NETID 
is the network ID of the remote relational database, or N/A if this relational database is accessed by TCP/IP.

 LU 
is the logical unit name of the remote relational database, or N/A if this relational database is accessed by TCP/IP.

 HOSTNAME 
is the name of the host or IP address of the server, or N/A if this relational database is accessed by TCP/IP.

 CCSID 
is the coded character set ID.

 TPFCCSID 
specifies the TPF system coded character set identifiers.

 SEL 
is the selective trace status (either ON or OFF).

POrt-port
is the port number for the database on the remote application server.

 MAXHC 
is the maximum number of hot conversations or hot connections (hotcons) allocated to the remote relational database.

 SRVRLSLV 
is the server release level.

 SRVRNAM 
is the server name.

 SRVCLSNM 
is the server class name.

 TRACE 
is the trace status.

 MODE 
is the APPC mode name, or N/A if this relational database is accessed by TCP/IP.

 AVAIL HC 
is the number of available hot conversations or hot connections.

 NEXT HC ADDR 
is the next hot conversation or hot connection entry address.
+--------------------------------------------------------------------------------+
|User:   ZSQLD DIS L RDB-TPFDB                                                   |
|                                                                                |
|System: SQLD0117I 10.48.54                                                      |
|        START OF ZSQLD DISPLAY                                                  |
|        RDB                 NETID     LU       HOSTNAME                         |
|        ---                 -----     --       --------                         |
|        TPFDB               N/A       N/A      9.117.147.166                    |
|                                                                                |
|        CCSID (S.D.M.)      TPFCCSID (S.D.M.)  MAXHC  SEL   PORT                |
|        -----               --------           -----  ---   ----                |
|         1252.    0.    0     500.    0.    0      3   ON    446                |
|        SRVRLSLV - DB2 UDB                                                      |
|        SRVNAME  - DB2                                                          |
|        SRVCLSNM - QDB2/NT                                                      |
|        TRACE    - ALL                                                          |
|        MODE     - N/A                                                          |
|        AVAIL HC -     1     NEXT HC ADDR - 056CD010                            |
|        END OF ZSQLD DISPLAY                                                    |
+--------------------------------------------------------------------------------+

The specified relational database is deleted in the following example.

+--------------------------------------------------------------------------------+
|User:   ZSQLD R R-DB2                                                           |
|                                                                                |
|System: SQLD0016I 10:52:52 SDD ENTRIES MATCHING RDB-DB2 REMOVED                 |
+--------------------------------------------------------------------------------+

The logical unit and network ID for the specified relational database is changed in the following example.

+--------------------------------------------------------------------------------+
|User:   ZSQLD M R-RDB LU-TPFDB2T NETID-01234567                                 |
|                                                                                |
|System: CSMP0097I 09.55.30 CPU-B SS-BSS  SSU-HPN  IS-01                         |
|        SQLD0015I 09.55.30 SDD ENTRY FOR RDB-RDB MODIFIED                       |
+--------------------------------------------------------------------------------+

Related Information