Local Model Item Lookup Table Utility - Intergraph Smart P&ID - 11.0 - Help - Intergraph

Intergraph Smart P&ID Utilities Help

Language
English (United States)
Product
Intergraph Smart P&ID
Subproduct
Smart P&ID Utilities
Search by Category
Help
Smart P&ID Version
11
Smart Engineering Manager Version
12

Use the LocalModelItemLookupTable.sql utility if your connected Workshare satellite experiences performance problems when transferring piping data from Smart P&ID to PDS. This script converts a satellite database view (namely, the T_ModelItemLookup) that references a host table into a local table, allowing the data transfer to proceed without using a database link.

Smart P&ID uses the database link to fetch unique Long IDs from the Host when running from a connected Workshare satellite. If the performance of opening the PID file in PDS is an issue or if maintaining the correlation between Smart P&ID and PDS after the merge is not an issue, then you can run this script to change the lookup for the Long ID from a view to the host to a local query.

This utility is delivered as an SQL script to the ..\SmartPlant\P&ID Workstation\bin folder and can be executed using any Oracle user interface, such as SQLPlus.

Do not use this script if the transferred PDS data will be merged back into a host PDS database because the Long IDs will not be unique at the host.

For more information about transferring piping data, see the Smart P&ID Piping Data Transfer Configuration and Reference Guide.

For more information about Workshare and database links, see the Workshare Configuration and Reference Guide.