QUERY ODBM TYPE(CONFIG) command
Use the QUERY ODBM TYPE(CONFIG) command to query information about Open Database Manager (ODBM) configuration.
Subsections:
Environment
The QUERY ODBM command is applicable only to the CSL Open Database Manager (ODBM). To issue this command, a CSL type-2 command environment must be enabled and an ODBM instance must be active.
Syntax
Keywords
The following keywords are valid for the QUERY ODBM TYPE(CONFIG) command.
- SHOW()
- Specifies the ODBM TYPE(CONFIG) output fields to be returned.
The parameters supported with the SHOW keyword are:
- ALL
- Returns all information about the CSLDCxxx configuration member in PROCLIB.
- ALIAS
- Returns alias names for the data store, which are used by Open Database applications to access IMS data stores.
- TIMER
- Returns the amount of time (in seconds) between attempts by ODBM to establish a connection to an IMS data store. The value can be a number between 1–99.
- IDRETRY
- Returns the number of times ODBM will attempt to connect (identify) to an IMS data store after the initial attempt is unsuccessful. The value can be a number between 0–255.
- FPBUF
- Returns the number of Fast Path DEDB buffers to be allocated and fixed per thread.
- FPBOF
- Returns the number of Fast Path DEDB overflow buffers to be allocated per thread.
- CNBA
- Returns the total number of Fast Path NBA buffers for ODBM use.
- MAXTHRDS
- Returns the maximum number of concurrent active threads to an individual IMS data store.
- MINTHRDS
- Returns the minimum number of concurrent active threads to an individual IMS data store.
- SOD
- Returns the SYSOUT class of the SNAP dumps produced by the ODBM address space. The value returned is a single alphanumeric character.
Usage notes
You can issue this command only through the Operations Manager (OM) API.
The syntax for this command is defined in XML and is available to automation programs that communicate with OM.
Output fields
- Short label
- Contains the short label that is generated in the XML output.
- Long label
- Contains the long label generated in the XML output.
- Keyword
- Identifies keyword on the command that caused the field to be generated. error appears for output fields that can appear for a nonzero completion code. N/A (not applicable) appears for output fields that are always returned.
- Meaning
- Provides a brief description of the output field.
| Short label | Long label | Keyword | Meaning |
|---|---|---|---|
| CC | CC | N/A | Completion code. |
| CCTXT | CCText | error | Completion code text that briefly explains the meaning of the non-zero completion code. |
| CNBA | CNBA | CNBA | CNBA value for a data store connection. |
| CNFG | ConfigName | N/A | CSLDCxxx PROCLIB member name. |
| DSTR | DatastoreName | N/A | Data store name. |
| FPBOF | FPBOF | FPBOF | FPBOF value for a data store connection. |
| FPBUF | FPBUF | FPBUF | FPBUF value for a data store connection. |
| GBL | Global | N/A | Y or N value will be presented. Y indicates information is from the Global section in the CSLDCxxx configuration member. N indicates information is from the Local section in the CSLDCxxx configuration member. |
| IRTRY | IdRetry | IDRETRY | IDRETRY value of a data store connection. |
| MALIAS | Aliases | ALIAS | The alias names associated with an IMS data store connection. |
| MBR | MbrName | N/A | Name of the ODBM member that processed the command. |
| MXTHD | MaxThrds | MAXTHRDS | MAXTHRDS parameter value. |
| MNTHD | MinThrds | MINTHRDS | MINTHRDS parameter value. |
| SOD | SOD | SOD | SYSOUT class of ODBM snap dumps. |
| TIMER | Timer | TIMER | TIMER parameter value for a data store connection. |
Return, reason, and completion codes
The return and reason codes that can be returned as a result of the QUERY ODBM TYPE(CONFIG) command are standard for all commands entered through the OM API.
The following table includes the return and reason codes and a brief explanation of the codes. The return or reason code returned for the command might also indicate an error from a CSL request.
| Return code | Reason code | Meaning |
|---|---|---|
| X'00000000' | X'00000000' | The QUERY ODBM TYPE(CONFIG) command completed successfully. |
| X'04000008' | X'00002004' | Invalid command keyword or invalid command keyword combination. |
| X'04000008' | X'00002008' | Insufficient number of keywords. |
| X'04000008' | X'00002014' | Invalid character in resource name. |
| X'04000008' | X'0000203C' | Invalid parameter specified. |
| X'0400000C' | X'00003000' | At least one request was successful. |
| X'0400000C' | X'00003004' | No requests were successful. |
| X'04000014' | X'00005034' | An OM response buffer request failed. |
| X'04000014' | X'00005038' | A CSLDCMD0 GETBUF request failed to get a command buffer. |
Errors unique to the processing of this command are returned as completion codes. A completion code is returned for each action against an individual resource.
| Completion code | Completion code text | Meaning |
|---|---|---|
| 0 | The QUERY ODBM TYPE(CONFIG) command completed successfully. | |
| 1 | INVALID CHARACTER, RESOURCE NAME | The resource name in the command input has invalid characters. |
| 10 | NO RESOURCES | No resources were found. |
Examples
Example 1 for QUERY ODBM TYPE(CONFIG) command
TSO SPOC input:
QRY ODBM TYPE(CONFIG) SHOW(ALL)TSO SPOC output:
MbrName ConfigName Global DatastoreName CC FPBUF FPBOF CNBA MaxThrds MinThrds IdRetry Timer Aliases SOD
DIAGDPSBMSG
ODBM1OD CSLDC001 Y 0 500 5 5200 1000 0 60 A
LONG
ODBM1OD CSLDC001 N IMS1 0 IMS1,O1I1,ANY
ODBM1OD CSLDC001 N IMS2 0 IMS2,O1I2,ANY
ODBM2OD CSLDC002 Y 0 500 5 5200 1000 10 0 60 A
SHORT
ODBM2OD CSLDC002 N IMS1 0 IMS1,O2I1,ANY
ODBM2OD CSLDC002 N IMS2 0 IMS2,O2I2,ANY
Explanation: The QUERY command will display all SHOW parameter values for the CSLDCxxx configuration members.
Example 2 for QUERY ODBM TYPE(CONFIG) command
TSO SPOC input:
QRY ODBM TYPE(CONFIG) SHOW(ALIAS,CNBA)TSO SPOC output:
MbrName ConfigName Global DatastoreName CC CNBA Aliases
ODBM01OD CSLDC000 Y 0 0
ODBM01OD CSLDC000 N IMS1 0 0 IO1A,IO1B
ODBM01OD CSLDC000 N IMS2 0 500 IO2A,IO2B
ODBM02OD CSLDC000 Y 0 100
ODBM02OD CSLDC000 N IMS3 0 200 IO3A,IO3B
Explanation: The QUERY command will display information about alias names for the data store and the total number of Fast Path NBA buffers for ODBM use.
Example 3 for QUERY ODBM TYPE(CONFIG) command
TSO SPOC input:
QRY ODBM TYPE(CONFIG)TSO SPOC output:
MbrName ConfigName Global DatastoreName CC
ODBM01OD CSLDC000 Y 0
ODBM01OD CSLDC000 N IMS1 0
ODBM01OD CSLDC000 N IMS2 0
ODBM01OD CSLDC000 N IMS1 0
ODBM01OD CSLDC000 N IMS1 0
ODBM02OD CSLDC000 Y 0
ODBM02OD CSLDC000 N IMS3 0
Explanation: The QUERY command will display information about Open Database Manager (ODBM) configuration.