IFCID 183 - DRDS RDS/SCC Interface
This topic shows detailed information about Record Trace - IFCID 183 - DRDS RDS/SCC Interface
.
This record provides information about the type of request being processed at the requester.
This record is produced only for DRDA requests.
Record trace - IFCID 183 - DRDS RDS/SCC Interface
The field labels shown in the following sample layout of Record Trace - IFCID 183 - DRDS RDS/SCC Interface
are described in the following section.
DRDS RDS/SCC 'BLANK'
INTERFACE NETWORKID: DEIBMIPS LUNAME: IPSAR721 LUWSEQ: 1
EVENT TYPE : RETURN TO RDS/SCC
FUNCTION : CONNECT RESET FOR BIND
LOCATION : LOCATIONNAME0002
COLLECTION : COLLECTIONNAME0002
PACKAGE ID : PROGNAM2
SQL STATEMENT NUMBER: 0
SQL STATEMENT TYPE: 80 RETURN CODE: 77
- EVENT TYPE
-
The type of event.
Field Name: QW0183E
- FUNCTION
-
The type of function.
Field Name: QW0183FN
- LOCATION
-
The location name of the application server.
Field Name: QW0183LN
- COLLECTION
-
The collection name.
Field Name: QW0183CO
- PACKAGE ID
-
The package ID.
Field Name: QW0183PN
- SQL STATEMENT TYPE
-
The SQL statement type:
-
003 - OPEN
-
004 - FETCH
-
005 - CLOSE
-
014 - PREPARE
-
015 - EXECUTE
-
016 - EXECUTE IMMEDIATE
-
017 - DESCRIBE
-
018 - EXPLAIN
-
231 - SELECT
-
232 - INSERT
-
233 - DELETE
-
234 - UPDATE
-
239 - SELECT
-
259 - SET CURRENT SQLID
-
268 - GRANT
-
271 - REVOKE
-
276 - REMOTE SQL
-
277 - ROLLBACK
-
278 - LOCK
-
308 - CREATE VIEW
-
310 - COMMIT
-
666 - INTOPEN
-
710 - CREATE DATABASE
-
716 - CREATE TABLESPACE
-
719 - CREATE STOGROUP
-
721 - CREATE TABLE
-
726 - CREATE INDEX
-
728 - CREATE SYNONYM
-
729 - DROP VIEW
-
730 - DROP SYNONYM
-
731 - DROP INDEX
-
732 - DROP TABLE
-
733 - DROP TABLESPACE
-
734 - DROP DATABASE
-
735 - DROP STOGROUP
-
736 - ALTER STOGROUP
-
738 - ALTER TABLESPACE
-
739 - ALTER INDEX
-
740 - ALTER TABLE
-
741 - COMMENT ON
-
742 - LABEL ON
-
745 - SET CURRENT PACKAGESET
-
746 - SET HOST VAR
-
747 - CONNECT TO
-
748 - CONNECT RESET
-
749 - CONNECT
-
750 - IMPLICIT CONNECT
-
755 - CREATE ALIAS
-
759 - DROP ALIAS
-
761 - DROP PACKAGE/PROGRAM
-
763 - ALTER DATABASE
-
768 - SET CURRNT DEGREE
-
769 - CONNECT TO TYPE 2
-
770 - CONN RESET TYPE 2
-
771 - CONNECT TYPE 2
-
772 - SET CONNECTION
-
773 - RELEASE LOCATION
-
774 - RELEASE CURRENT
-
775 - RELEASE ALL
-
776 - RELEASE ALL SQL
-
777 - RELEASE ALL PRIV.
-
781 - SET CURRENT RULES
-
782 - CALL
Field Name: QW0183ST
-
- SQL STATEMENT NUMBER
-
The SQL statement number.
Field Name: QW0183SN
- RETURN CODE
-
The return code.
Field Name: QW0183RC