Use this command to maintain and display the structured query language
(SQL) database management system (DBMS) directory. You can perform the
following functions:
- Define a new relational database
- Change an existing relational database definition
- Delete an existing relational database definition
- Display information about a relational database
- Initialize the SQL DBMS directory.
Requirements and Restrictions
The TPF Application Requester (TPFAR) feature must be installed on the TPF
system.
Format
Notes:
- This parameter is optional when you specify the MODIFY parameter.
- 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
- Online help information is available for this command. To display
the help information, enter one of the following:
ZSQLD HELP
ZSQLD ?
- To switch from Advanced Program-to-Program Communications (APPC) to
Transmission Control Protocol/Internet Protocol (TCP/IP), enter the ZSQLD
command with the MODIFY and HOSTNAME parameters specified; the values for
LU name, net ID, and mode that were previously associated with APPC will no
longer be used.
- To switch from TCP/IP to APPC, enter the ZSQLD command with the MODIFY and
LUNAME parameters specified; the host name previously associated with
TCP/IP will no longer be used.
- The MAXHC parameter refers to hotcons, which represent
conversations in APPC and connections in TCP/IP. The socket sweeper
will not clean up the socket associated with a hotcon in TCP/IP.
- When connected to more than one physically separate network, ensure that
the specified host name resolves to an IP address that points to the correct
network. You can use the TPF IP routing table for this
condition.
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