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