You can use the query interfaces
in the monitoring console and in the xscmd utility
to retrieve small sets of keys and values from
a map and invalidate sets of data.
About this task
You can use the console or the xscmd utility
to query data grid contents. You can query the data by running a regular
expression on the data key. You can then use the same query to invalidate
data. For examples of regular expressions, see Regular expression syntax.
Procedure
- Query display, or invalidate
data with the console.
- Go to the query page in the console.
In the web console, click . Choose the map on which you want to filter.
- Search or filter the data in the map.
You
can use one of the following options to search or filter the data:
- Type a regular expression in the field and click the Search button
().
A list of keys that match the regular expression displays. The list
of data could be a subset of all of the matching data.
- To filter the results on a set of partitions, click the Filter button
(). You
can then type a regular expression and choose a range of partitions
on which you want to filter the results.
- Display values for the displayed keys.
Select
Show values. The values display
in the table. If the value is too long to display, an ellipsis (
...)
truncates the value. Click the value to display the full field. Values
are returned as text strings. Some values might not convert to human
readable strings, and hexadecimal numbers are displayed.
Important: The application might store object values for which
the Java™ class is not known
to the server. If the application is using eXtreme Data Format (XDF),
these values display. If XDF is not being used, and the Java class is not known to the server, a message
is returned that the class of the object was unavailable to the server.
- Invalidate data.
When you invalidate the
data, the data is permanently removed from the data grid.
- Selected keys
- You can select keys from the table to invalidate. You can either
click entries individually or click the select all check box, which
selects a maximum of 500 entries that are in the table. When you have
the entries selected that you want to remove, click .
- All keys matching query
- You can also invalidate all the data that matches your regular
expression. Using this option deletes all data in the data grid that
matches the regular expression, not just the maximum of 500 entries
that is displayed in the console. To invalidate entries with the selected
regular expression, click .
- Delete the entire contents of a map.
Click Clear Map. You must confirm that
you want to delete all of the entries in the selected map.
- Query display, or invalidate
data with the xscmd utility.
- Query data:
xscmd.sh –c findbykey –g <data_grid> -m <map>
-fs <find_string> [-fp <partitionid>]
You
must include the data grid, map, and regular expression for the find
string value. You can also filter on the partition ID. The result
returns a subset of the entire query.
- Invalidate data:
- Include the -inv argument in the command
to invalidate the data that is selected by the query.
xscmd –c findbykey –g <data_grid> -m <map>
-fs <find_string> [-fp <partitionid>] -inv
You
must include the data grid, map, and regular expression for the find
string value. You can also filter on the partition ID. When you run
the invalidation, all matching values are invalidated, not just the
small set that is returned by the query.
- Display values for queried data:
- Include the -rv argument in the command to
display values for the data that is selected by the query.
xscmd.sh –c findbykey –g <data_grid> -m <map>
-fs <find_string> -rv
You must include
the data grid, map, and regular expression for the find string value.
You can also filter on the partition ID. The result returns a subset
of the entire query and includes the values for each key.
Important: If your
regular expression starts with the characters
.*
,
the characters might not process correctly when you run the command.
To resolve this issue, format your regular expression in one of the
following ways:
- Enclose your regular expression with apostrophe characters:
-fs
'.*'
- Use a backslash to escape the asterisk character:
-fs
.\*
Example:The following example
looks for all entries in the
Grid data grid
and
Map1 map.
xscmd -c findbykey -g Grid -m Map1 -fs ".*"
The
command returns the following results:
3 matching keys were found.
Partition Key
--------- ---
2 keyghi
4 keydef
6 keyabc