CSS Tools - Optimize - Updating the statistics - using Cssoptimize exe on a schema
Purpose
This page outlines the command line to update statistics on any CSS schema.
Applicable in CAST Version
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
| 7.2.x | ✅ |
| 7.0.x | ✅ |
Applicable RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ❌ |
| Microsoft SQL Server | ❌ |
| CSS3 | ✅ |
| CSS2 | ✅ |
| CSS1 | ✅ |
CSS1
CssOptimize.exe -host localhost -password CastAIP -log <log location> -schema <schema_name>
CSS2
CSSOptimize.exe -host localhost -port 2280 -user operator -password CastAIP -log <log location> -schema <schema_name>
CSS3
CSSOptimize.exe -host localhost -port 2282 -password CastAIP -log <log location> -schema <schema_name>
Notes/comments
- For CSS2, if you use parameter "-username" (only supported in CSS1), the command line will not execute, hence use "-user" instead
Related Pages