Wildcard support for name parameters for Query requests

For more flexible Query requests, you can use a wildcard (an asterisk) in several keyword parameters that specify names. This wildcard support enables you to specify a name pattern for your query, expanding some queries and filtering others.

The asterisk can be used in two formats:

  • Use the asterisk alone to request information for all DB names, groups, or subsystems, depending on the query type.
  • Use the asterisk at the end of a name to request information for DB names, groups, or subsystems whose names match the patterns. In this case, the asterisk must be preceded by at least one alphabetic character.

Use of wildcards is supported in the following parameters:

Table 1. Parameters for DBRC QUERY with wildcard support
Parameter name Query type Syntax
DBNAME DB DBNAME=dbname | dbname*
GROUP All xxxxGROUP GROUP= * | name | name*
NAME All xxxxGROUP NAME= * | name | name*

NAME=*
SSID
  • BACKOUT
  • OLDS
  • SUBSYS
 SSID= * | symbol | symbol*