Wildcard characters in requests


You can use plus signs (+) or asterisks (*) as wildcard characters to generate requests for multiple resources or workloads that have similar names.

You can use wildcards with:

  • Parameters for various analyzer and trace services
  • Selection criteria keywords for workload monitor and summary trace data collection services

You can use the wildcard characters (+) and (*) based on the following rules:

Wildcard character

Meaning

Examples

+

The effect of the plus sign varies, based on where you place it in a string:

  • At the end of a string, the plus sign represents any characters that might follow.
  • At the beginning of the string or within the string, the plus sign represents a single character; that is, to represent exactly two characters in the middle of a string, you would enter two plus signs.
  • On the Database and Table Space Status panel, entering S XYZ+ displays all database names that begin with XYZ.
  • Entering S A++D displays all names that consist of the letter A, followed by two characters, followed by D.

*

The asterisk always represents any number of chacters (zero, one, or multiple characters), regardless of its position in the string.

  • On the DB2 Trace Entries (LTRAC) display, entering PLAN=DSNTI* displays trace entries for all PLAN names that begin with DSNTI (for example, DSNTI, DSNTIW, and DSNTIZV5).
  • Entering PLAN=DSNT*I displays trace entries for PLAN names DSNTI, DSNT3I, and DSNTAPOI).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*