DB2 IMS Regions Attributes
Use the DB2 IMS Regions attributes to create situations to monitor IMS dependent regions.
Application Name The PSB name active in the IMS dependent region. This field applies only to dependent regions (not to the control region). Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Command Recognition Character The command recognition character used to pass commands to the external subsystem. Valid entry is an alphanumeric text string, with a maximum length of four characters.
Connection Status The region connection status.
Error Option Specification The type of error option specification in use.
Value | Description |
---|---|
R | The appropriate return code is sent to the application, and the SQL code is returned. |
Q | The application is abended. This is a PSTOP transaction type. The input transaction is re-queued for processing and new transactions are queued. |
A | The application is abended. This is a STOP transaction type. The input transaction is discarded and new transactions are not queued. |
Valid entry is an alphanumeric text string, with a maximum length of four characters.
IMS Name The ID for this IMS connection. Valid entry is an alphanumeric text string, with a maximum length of four characters.
IMS Version The version of the IMS system. Valid entry is an alphanumeric text string, with a maximum length of four characters.
Interface Control Module The name of the interface control module. Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Language Token Interface The name of the language interface token. Valid entry is an alphanumeric text string, with a maximum length of four characters.
Originating System ID The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters; for example, DB91:SYS1:DB2.
Region Name The region started task name. Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Region Type The type of IMS region.
Resource Translation Table The name of the resource translation table. This table maps the IMS application names into DB2 plan names. If this entry is omitted, the DB2 plan name is the IMS application program name. Valid entry is an alphanumeric text string, with a maximum length of eight characters.
Status The current DB2 status of the thread. Valid entry is an alphanumeric text string, with a maximum length of 12 characters.
- Status
- Description
- IN-ABORT
- The thread is in abort processing.
- IN-ACCEL
- The thread is executing in accelerator.
- IN-AUTO-PROC
- The thread is processing an autonomous procedure.
- IN-BIND-DYNM
- The thread is in dynamic bind processing.
- IN-BIND-STAT
- The thread is in static bind processing.
- IN-COMMAND
- Command threads display this status when they are active in DB2 and executing within the DB2 command processor. (This type of thread always has a blank.)
- IN-COMMIT
- The thread is in commit processing. It applies only to threads that originate from an attachment that does not use a two-phase commit protocol.
- IN-COMT-PHS1
- The thread is in commit phase 1 processing.
- IN-COMT-PHS2
- The thread is in commit phase 2 processing.
- IN-CRTE-THRD
- The thread is in create thread processing.
- IN-DB2
- The thread is executing in DB2. A more descriptive status could not be determined.
- INDOUBT
- The thread is in doubt.
- IN-SIGNON
- The thread is in signon processing. This status applies only to threads originating from CICS or IMS attachments.
- IN-SQL-CALL
- The thread is processing an SQL call.
- IN-SQL-SORT
- The thread is executing an SQL call and is doing the sort processing required to satisfy the request of the call.
- IN-STOR-PROC
- The thread is currently running in a stored procedure.
- IN-TERM-THRD
- The thread is in termination as a result of allied task termination. This status corresponds to the DB2 DISPLAY THREAD=D.
- IN-TRIGGER
- The thread is currently running in a trigger.
- IN-USER-FUNC
- The thread is currently running a user-defined function.
- NOT-AVAIL
- The thread is not available
- NOT-IN-DB2
- The thread is currently not running in DB2.
- SP/UDF-INACT
- The thread is trying to but cannot run in a stored procedure or user-defined function.
- SWAPPED-OUT
- The thread is currently not running in DB2. The thread originating address space is swapped out.
- WAIT-ARCHIVE
- The thread is waiting for an archive log tape mount necessary during thread abort processing.
- WAIT-ARCREAD
- The thread is currently waiting for read of archive log from tape.
- WAIT-ASYNCRD
- The thread is currently waiting for completion of a read I/O that is done under a thread other than this one (such as sequential or list prefetch).
- WAIT-ASYNCWR
- The thread is currently waiting for completion of write I/O that is done under a thread other than this one (such as deferred writes).
- WAIT-CLAIMER
- The thread is currently waiting for claimers to be released after acquiring DRAIN lock.
- WAIT-CONVLIM
- The distributed thread is in a synchronous wait because the conversation limit has been reached for its designated logmode.
- WAIT-CTHREAD
- The thread is queued in create thread processing because DB2 reached the CTHREAD value. This status corresponds to DB2 DISPLAY THREAD=QD status.
- WAIT-DRNLOCK
- The thread is currently waiting to acquire DRAIN lock.
- WAIT-GLBLOCK
- The thread is currently waiting for one of the following:
- A lock held by another subsystem in the data sharing group.
- intersystem communication within the data sharing group to determine if there is lock contention.
- WAIT-LOCK
- The thread is waiting for a lock
- WAIT-LOGQSCE
- The thread is currently suspended because of an ARCHIVE LOG MODE(QUIESCE) command.
- WAIT-MSGSEND
- The thread is currently waiting because of intersystem message sending contention.
- WAIT-PGLATCH
- The thread is currently waiting for page latch.
- WAIT-REMREQ
- The database access thread is in a synchronous wait (waiting for a response or a request from the originating DB2 subsystem).
- WAIT-REMSQL
- The distributed allied thread is in a synchronous wait (waiting for a response from the remote DB2 subsystem being accessed).
- WAIT-REUSE
- The thread is not currently in use and is waiting to be reused. This status applies only to CICS and IMS threads.
- WAIT-SERVICE
- The thread is currently waiting for completion of a DB2 service. Types of DB2 services include open/close of data set, DFHSM recall of a data set, SYSLGRNG update, or define/extend/delete of a data set, rollback, and commit phase 2 for read only threads.
- WAIT-SP-STOP
- The thread is queued waiting for a stopped stored procedure.
- WAIT-SPSCHD
- The thread is waiting for a TCB to become available in the stored procedures address space to schedule a stored procedure.
- WAIT-SYNC-IO
- The thread is currently waiting for completion of a synchronous
Read I/O or Write I/O. Note: This status can indicate that a DB2 resource is not large enough. You can use the OMEGAMON XE for DB2 PE resource manager or object analysis displays to further isolate the problem.
- WAIT-TERM-TH
- The thread is queued and waiting for thread termination as a result of allied task termination. This status corresponds to the DB2 DISPLAY THREAD=QD status.
- UTIL-STOP
- The DB2 utility was started but not completed because of abnormal termination.
Time The date and time, as set on the monitored system, indicating the instance when the agent collects information.
- C = Century (0 for 20th, 1 for 21st)
- Y = Year
- M = Month
- D = Day
- H = Hour
- M = Minute
- S = Second
- m = Millisecond