Get Advisor Rules (Reserved)
Retrieve the list of rules associated with a specific advisor for an application.
This operation returns rules from the latest advisor version and supports pagination through query parameters.
URI
GET /rest/applications/{name}/advisors/{advisor}/rules
Path parameters
name (string)
This parameter identifies the analyzed application. The application name must be properly encoded if required. Character back-quote is not allowed.
advisor (integer)
The unique identifier for the advisor.
Query parameters
limit (integer)
Optional. The maximum number of rules to return in the response. Used for pagination.
skip (integer)
Optional. The number of rules to skip before starting to return results. Used for pagination.
Responses
application/json
Example:
{
"results": [
{
"id": 1106080,
"name": "Ensure DB2 Scalar Function RAND is not used",
"description": "This rule checks the DB2 Scalar Function RAND is used in DB2 Database(s).",
"migration": "Database Migration",
"version": "3.6.0"
},
{
"id": 1106082,
"name": "Ensure DB2 Scalar Function TIMESTAMP is not used",
"description": "This rule checks the DB2 Scalar Function TIMESTAMP is used in DB2 Database(s).",
"migration": "Database Migration",
"version": "3.6.0"
},
{
"id": 1106084,
"name": "Ensure DB2 Scalar Function CHAR is not used",
"description": "This rule checks the DB2 Scalar Function CHAR is used in DB2 Database(s).",
"migration": "Database Migration",
"version": "3.6.0"
},
{
"id": 1106092,
"name": "Ensure DB2 Scalar Functions DAY/DAYS are not used",
"description": "This rule checks the DB2 Scalar Functions DAY/DAYS are used in DB2 Database(s).",
"migration": "Database Migration",
"version": "3.6.0"
},
{
"id": 1106096,
"name": "Ensure PARTITION is not used in ALTER TABLE statements",
"description": "This rule will check if the following sql statements exist into DB2 SQL files:\n ALTER TABLE ADD PARTITION\n ALTER TABLE DETACH PARTITION\n ALTER TABLE ATTACH PARTITION",
"migration": "Database Migration",
"version": "3.6.0"
}
],
"limit": 5,
"skip": 10,
"total": 37
}
JSON representation
| Property | Type | Description |
|---|---|---|
| results | array | list of rule objects. |
| results[].id | number | The unique identifier for the rule. |
| results[].name | string | The name of the rule. |
| results[].description | string | Detailed description of what the rule checks. |
| results[].migration | string | The migration category or advisor name this rule belongs to. |
| results[].version | string | The version of the advisor (latest available version). |
| limit | number | The maximum number of results returned (matches query parameter). |
| skip | number | The number of results skipped (matches query parameter). |
| total | number | The total number of rules available for this advisor. |