search_db2_catalog
Find Db2 tables, views, or aliases by name pattern and retrieve row counts, creation dates, and remarks for catalog discovery.
Instructions
Search the Db2 catalog for tables, views, or aliases matching a name pattern. Includes row count, creation date, and remarks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| type | No | Object type filter: "TABLE", "VIEW", "ALIAS", "MATERIALIZED QUERY TABLE". Case-insensitive. | |
| schema | No | Optional schema/creator filter (exact match), e.g. "PAYROLL". | |
| pattern | Yes | Table/view name pattern with wildcards (*, ?), e.g. "PAY*". | |
| maxResults | No | Maximum number of catalog objects to return (default 50, max 200). | |
| environment | No | Named target environment (see list_environments), e.g. "dev", "prod". Omit to use the server default. |