About Caching Aster Schemas - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

When working with Aster databases, you can designate specific schemas to be cached. Caching Aster schemas creates a schema cache file that contains the metadata for the schema. The metadata describe the schema tables, columns, constraints, indexes, mr functions, views, and so forth.

Cached schema are associated with a Connection Profile. If you delete the Connection Profile, the Schema Cache list and any schema cache files associated with that Connection Profile are also deleted.

You can cache Aster schema and set cache properties when you:
  • Create a new Connection Profile - Select cache schemas when you create a new Connection Profile using the New Aster Connection Profile wizard. See Caching Aster Schemas.
  • Edit existing cache schema list - Modify Aster cache properties from the Data Source Explorer. See Editing Aster Cache Schema Properties.

Each cached Aster schema node in the Data Source Explorer is indicated by an icon.

When you connect to the Aster database and open the Schemas folder, a schema cache file is created in a background job. You can view the progress of the schema cache job in the Progress Monitor view by selecting Window > Show View > Other > General > Progress and click OK.

After you select schema to cache or edit cache and open the Schemas folder, the Serialization process occurs. To complete the caching process, you must disconnect and reconnect to the Connection Profile. You can open the Progress Monitor to view the serialization process.