IFCID003: DDF Location

The IFCID003 DD contains the extracted IFCID 003 (DDF Location) records. Only IFCID 0003 records that contain a distributed data facility statistics (DSNDQLAC) block are reported; other IFCID 0003 records are ignored. Only selected IFCID 0003 fields are used.

Fields

Begin program-specific programming interface information.

The IFCID003 DD has the following fields:

REMOTE LOCATION: The name of the remote location that this information is associated with. If the local location is the requester, this field is a server location. If the local location is a server location, this field is the requester location. An allied thread is created at a Db2 requester, and a database access thread is created at a Db2 server. An accounting record is for either a requester or a server, but not for both.; Field Name: QLACLOCN
COMMIT SENT: The number of single-phase commit requests that are sent to the server location. This value is maintained at the requester location.; Field Name: QLACCOMS
COMMIT RECEIVED: The number of single-phase commit requests that are received from the requester location. This value is maintained at the server location.; Field Name: QLACCOMR
REQ.ELAPSED TIME: The elapsed time at the requester location until the database access agent completed its work, including Db2 processing time and network time. This value is maintained at the requester location and is calculated by accumulating the difference between the store clock values that are obtained before and after each network request.; Field Name: QLACCPUL
ROLLBK SENT: The number of rollback requests that were sent to the server location (single-phase commit operations only). This value is maintained at the requester location.; Field Name: QLACABRS
SER.ELAPSED TIME: The elapsed database access agent time at the server location. This time is updated at the requester location and is reported only for Db2 private protocol. If the agent uses both methods to communicate with the server location, only the elapsed time that is associated with the Db2 private protocol is reported, and this time can be misleading. If only DRDA is used, this value is 0.; Field Name: QLACCPUR
ROLLBK RECEIVED: The number of rollback requests that are received from the requester location (single-phase commit operations only). This value is maintained at the server location.; Field Name: QLACABRR

Example

   DDF DATA BY LOCATION           
REMOTE LOCATION    COMMIT SENT    
                   COMMIT RECEIVED
REQ.ELAPSED TIME   ROLLBK SENT    
SER.ELAPSED TIME   ROLLBK RECEIVED
----------------------------------
STLEC1B                 0000000000
                        0000000000
09:48:00                0000000000
09:48:00                0000000000

End program-specific programming interface information.