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(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x (tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(error)
Microsoft SQL Server(error)
CSS3(tick)
CSS2(tick)
CSS1(tick)
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