IMS Connect QUERY DATASTORE command

Use the QUERY DATASTORE command to display the data store status.

QUERY or QRY is used to query the status or attributes of a specified resource. For example, the specified resource is DATASTORE which is an IMS Connect managed resource.

The data store resource type refers to the destination that is accessing IMS OTMA. With the data store resource type, IMS Connect can communicate with IMS through IMS OTMA. If a data store name is used, this name must match the ID parameter of a DATASTORE configuration statement of the HWSCFGxx configuration member and only the information for this data store is displayed or updated. QUERY DATASTORE performs similar functions as the VIEWDS command.

Subsections:

Syntax
Keywords
Equivalent IMS Connect type-2 and WTOR commands
Output fields
Examples

Syntax

Keywords

NAME(datastoreName)

Specifies the data store name to be displayed. You can specify a single data store name, a wildcard name, or a list of data store names separated by commas. You can specify name(*) for the command to be processed for all data stores.

SHOW( )

Specifies the output fields to be returned.

ALL: Returns all output fields. This is the default.

Equivalent IMS Connect type-2 and WTOR commands

The following table lists IMS Connect type-2 commands and IMS Connect WTOR commands that perform similar functions as the QUERY DATASTORE command.

QUERY DATASTORE command	Equivalent IMS Connect type-2 command	Equivalent WTOR command
QUERY DATASTORE NAME(*) SHOW(ALL)	QUERY IMSCON TYPE(DATASTORE) NAME(*) SHOW(ALL\|`show_parm`)	VIEWDS ALL
QUERY DATASTORE NAME(`datastore_name`)	QUERY IMSCON TYPE(DATASTORE) NAME(`datastore_name`) SHOW(ALL\|`show_parm`)	VIEWDS `datastore_name`

Output fields

The following list shows the output fields of the QUERY DATASTORE command.

DATASTORE=

Name of the data store, as defined in the ID substatement of the DATASTORE configuration statement in the HWSCFGxx configuration member, or

No active
Datastores

. The data store is an IMS system or, more precisely, a connection to an IMS system.

STATUS

State of the data store: ACTIVE, NOT ACTIVE or DISCONNECT.

If the data store goes down, IMS Connect is notified (from IMS OTMA through z/OS® cross-system coupling facility (XCF)) of the status of the data store. When the data store is brought back up and restarted, IMS Connect is notified and automatically reconnects to the data store.

GROUP

XCF group name for the group to which the IMS Connect and IMS OTMA belong.

MEMBER

IMS Connect member name in the XCF group listed.

TARGET MEMBER

IMS OTMA member name in the XCF group listed.

STATE

Indicates the state of the OTMA server. The STATE value can have one of the following values:

AVAIL: Indicates that the OTMA server is available.
WARN: Indicates that the OTMA server has one or more resources in warning state.
SEVERE: Indicates that the OTMA server is experiencing some severe resource issues.
N/A: Indicates that OTMA has not reported status for this data store.

DEFAULT REROUTE NAME

The name of an alternative destination specified in a client reroute request.

RACF® APPL NAME

The RACF APPL name for PassTicket and data store access control.

MULTIRTP

Shows the current specification of the MULTIRTP parameter in the DATASTORE statement for the currently displayed DATASTORE connection. Possible values are:

Y: The client bid requests for this DATASTORE connection request a TPIPE that supports multiple active resume TPIPE requests.
N: The client bid requests for this DATASTORE connection request a TPIPE that supports only a single active resume TPIPE request.
#: The client bid requests for this DATASTORE connection do not contain a MULTIRTP specification. OTMA determines whether the TPIPEs for this DATASTORE connection support multiple active resume TPIPE requests.
␢: A MULTIRTP value is not specified in the DATASTORE statement. TPIPE support for multiple resume tpipe requests is determined by either the MULTIRTP specification in the HWS statement or in the OTMA client descriptor.

CASCADE

Shows the specification in the data store definition for support for cascading global RRS transactions to IMS TM data stores that are located on different LPARs than IMS Connect.

This specification was set either by the CASCADE= parameter of the DATASTORE= statement in the HWSCFGxx member of the IMS PROCLIB data set or by the SET(CASCADE() keyword on type-2 command CREATE IMSCON TYPE(DATASTORE) or UPDATE IMSCON TYPE(DATASTORE).

The value shown here overrides the IMS Connect default value for CASCADE.

One of the following values is displayed:

blank: A blank value indicates that cascaded transaction support was not specified for this data store. Support for this data store is determined by the IMS Connect default specification.
Y: Indicates that when IMS Connect and the IMS data store are on different z/OS images (LPARs), this data store connection supports cascading global IMS TM transactions.
N: Indicates that by default, this data store connection does not support cascading global IMS TM transactions.

OTMA ACEE AGING VALUE

The current OTMA accessor environment element (ACEE) aging value specified in the IMS Connect DATASTORE configuration statement. The OTMA ACEE aging value determines how frequently OTMA refreshes the security definitions that are cached in an ACEE for IMS Connect.

OTMA ACK TIMEOUT VALUE

The OTMA ACK timeout value in the IMS Connect configuration member.

OTMA MAX INPUT MESSAGE

The OTMA input message flood control value in the IMS Connect configuration file.

SENDALTP

Shows the current specification of the SENDALTP parameter in the DATASTORE statement. You can specify the following values:

Y: If specified, the SENDALTP function is activated for client bid requests for this DATASTORE connection. The ALTPCB output that is initiated by an IMS Connect commit-then-send send-receive transaction is sent back the originating IMS Connect client without placing a RESUME TPIPE call.
N: If specified, the ALTPCB output is put on a tpipe hold queue for client bid requests for this DATASTORE connection.
#: If specified, no SENDALTP specification is contained in client bid requests for this DATASTORE connection. OTMA determines the status of SENDALTP activation.
blank: If specified, no SENDALTP value is specified in the DATASTORE statement.

SUPER MEMBER NAME

The name of the OTMA super member to which this data store belongs.

IMSPLEX=

Name of the IMSplex as defined in the TMEMBER parameter of the IMSplex statement in the IMS Connect configuration member HWSCFGxx.

STATUS: The state of the IMSplex.
MEMBER: IMS Connect member name as defined in the IMS Connect configuration file IMSplex statement for MEMBER= parameter.
TARGET: IMS Connect target member name as defined in the IMS Connect configuration file IMSplex statement for TMEMBER= parameter.

ODBM=

Identifies an instance of Open Database Manager (ODBM) present in the IMSplex.

STATUS

Shows whether this instance of IMS Connect is registered with the identified instance of ODBM. STATUS can have one of the following values:

REGISTERED: IMS Connect is registered with the identified instance of ODBM.
NOT ACTIVE: The ODBM instance is not available.
NOTREACHABLE: The ODBM instance is not reachable.

ODBMRRS

Indicates the RRS specification in an ODBM. When IMS Connect registers with ODBM, ODBM provides IMS Connect with its RRS setting in addition to the aliases.

ALIAS

The alias name of an IMS data store defined to the instance of ODBM identified in the preceding ODBM output field.

STATUS

Shows whether the IMS system associated with the preceding alias name is active or inactive. The status can have one of the following values:

ACTIVE - IMS Connect can route messages to the identified alias.
NOT ACTIVE - IMS Connect cannot route messages to the identified alias.

Examples

Example 1 for QUERY DATASTORE command

Command input:

F HWS1, QRY DATASTORE NAME(*) SHOW(ALL)

Command output:

HWSC0001I  DATASTORE=IMS1     STATUS=ACTIVE
HWSC0001I    GROUP=XCFGRP1  MEMBER=HWS1
HWSC0001I    TARGET MEMBER=IMS1           STATE=AVAIL
HWSC0001I    DEFAULT REROUTE NAME=CFG$DEF
HWSC0001I    RACF APPL NAME=APPLID1       MULTIRTP=Y   CASCADE=Y
HWSC0001I    OTMA ACEE AGING VALUE=2147483647
HWSC0001I    OTMA ACK TIMEOUT VALUE=120
HWSC0001I    OTMA MAX INPUT MESSAGE=5000
HWSC0001I    SUPER MEMBER NAME=SM01  CM0 ACK TOQ=
HWSC0001I  ODBM=ODBMAOD  STATUS=REGISTERED   ODBMRRS=Y
HWSC0001I    ALIAS=IMS1  STATUS=ACTIVE, TRACE
HWSC0001I    ALIAS=IMS2  STATUS=NOT ACTIVE(IMSCON)
HWSC0001I  ODBM=ODBMBOD  STATUS=REGISTERED ODBMRRS=N
HWSC0001I    ALIAS=IMS1  STATUS=ACTIVE
HWSC0001I    ALIAS=IMS2  STATUS=ACTIVE 
HWSC0001I  ODBM=ODBMCOD  STATUS=NOT ACTIVE
HWSC0001I  ODBM=ODBMDOD  STATUS=NOT ACTIVE

Explanation: The status of all the data stores defined to IMS Connect is displayed.

Example 2 for QUERY DATASTORE command

Command input:

F HWS1, QRY DATASTORE NAME(IMS1) SHOW(ALL)

Command output:

HWSC0001I  DATASTORE=IMS1     STATUS=ACTIVE
HWSC0001I    GROUP=XCFGRP1  MEMBER=HWS1
HWSC0001I    TARGET MEMBER=IMS1           STATE=AVAIL
HWSC0001I    DEFAULT REROUTE NAME=CFG$DEF
HWSC0001I    RACF APPL NAME=APPLID1       MULTIRTP=Y   CASCADE=Y
HWSC0001I    OTMA ACEE AGING VALUE=2147483647
HWSC0001I    OTMA ACK TIMEOUT VALUE=120
HWSC0001I    OTMA MAX INPUT MESSAGE=5000
HWSC0001I    SUPER MEMBER NAME=SM01  CM0 ACK TOQ=

Explanation: The status of a single IMS Connect data store, IMS1, is displayed.