Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. MX Views Reference
  17. PowerCenter Reports Reference

Repository Guide

Repository Guide

Creating MX Views

Creating MX Views

Each time you create or upgrade a repository, the Repository Service runs SQL scripts that creates the MX views.
The following table lists the SQL scripts to create MX views:
Repository Database
SQL Script
IBM DB2
db2mxbld.sq_ and db2mxbl2.sq_
Microsoft SQL Server
sqlmxbld.sq_ and sqlmxbl2.sq_
Oracle
oramxbld.sq_ and oramxbl2.sq_
Sybase
sybmxbld.sq_ and sybmxbl2.sq_
These SQL scripts are stored in the Repository Service installation directory.

0 COMMENTS

We’d like to hear from you!