SQL Object Consistency Analyzer and Upgrade Rebind Utilities › SQL Object Consistency Analyzer › Running the SQL Object Consistency Analyzer

Running the SQL Object Consistency Analyzer

The SQL Object Consistency Analyzer can verify all constraints, views, and plans in a single execution, or can be limited to a subset. Analysis can be limited by object type, authorization ID, and object name as indicated by the following syntax diagram. This syntax should be added as a parameter to the execution statement in your JCL. The parameter may be omitted if all constraints, views, and plans are to be analyzed and the default values for UID=, PSW=, and OVRD= are acceptable.

►►─ PARM=' ─┬─────────────────────────────────┬─┬──────────────────┬──────────►
            └─┬────────────┬─ authid.sqlname ─┘ └─ UID=dd-user-id ─┘
              └─ objtype= ─┘

 ►─┬───────────────────┬─┬─────────────────────────┬─┬─────────┬─ ' ──────────►◄
   └─ PSW=dd-password ─┘ └─ OVRD=dd-override-code ─┘ └─ TRACE ─┘

Note: Use a single space to separate parameters, but do not use any other spaces (or any commas) in the statement. The parameters can be entered in any order. Use uppercase letters to specify values for the parameters.

objtype=

(Optional) Identifies the entity-type of the object(s) to be verified.

Valid Entries:

CONSTRAINT= or PLAN= or VIEW=

Default:

If objtype= is not specified, constraints, plans, and views are verified.

authid

(Required, if objtype= is specified.) Enter the authorization ID of object(s) to be verified, or * (an asterisk) to verify all AUTHIDs of the specified entity type(s).

Valid Entries:

An existing AUTHID or * (the AUTHID may not exceed 18 characters.)

Default:

(No default)

.sqlname

(Required, if authid is specified.) Enter the name of a constraint, view, or plan, or * (an asterisk). Specifying * will cause all entities of the specified AUTHID to be verified. If * was specified as the AUTHID, then SQL name is treated as if * was specified.

Valid Entries:

The SQL name of an existing constraint, view, or plan, or * (the name may not exceed 32 characters).

Default:

(No default)

UID=

(Optional) You must specify a valid user ID if DATACOM-INSTALL has been removed as a valid CA Datacom Datadictionary user ID (a PERSON entity-occurrence), or if NEWUSER has been removed as the CA Datacom Datadictionary password for the DATACOM-INSTALL user ID.

Note: If you specify a CA Datacom Datadictionary user ID but not a CA Datacom Datadictionary password, blanks are used as the password.

Valid Entries:

A valid CA Datacom Datadictionary user ID

Default:

DATACOM-INSTALL

PSW=

(Optional) You must specify a valid password assigned to the CA Datacom Datadictionary user ID if DATACOM-INSTALL has been removed as a valid CA Datacom Datadictionary user ID (a PERSON entity-occurrence), or if NEWUSER has been removed as the DATACOM-INSTALL password, or if UID= has been specified but the password is something other than blanks. If the password parameter is specified, then the user ID must also be specified.

Valid Entries:

A valid CA Datacom Datadictionary password

Default:

blanks (if UID= is specified) or
NEWUSER (if UID= is not specified)

OVRD=

(Optional) A valid four-character CA Datacom Datadictionary override code must be specified if PRIV is no longer the CA Datacom Datadictionary override code.

Valid Entries:

A valid four-character CA Datacom Datadictionary override code

Default:

PRIV

TRACE

(Optional) Prints additional output to help CA Support diagnose problems found by the Analyzer.

Important! Do not specify any entity-type that includes the character string TRACE unless instructed to do so by CA Support.

Valid Entries:

TRACE

Default:

(No default)