SDB utility checks are used to verify database integrity. These checks enable you to identify any discrepancies in data within the database and fix them. For example, you may already have some duplicate idents or commodity geometric data from previous releases. These existing duplicate idents or geometrics may be in use in S3D, BOM, or REQ modules. To identify the duplicate idents and geometric data after migration, you can use the database integrity scripts, Find Duplicate Geometric Data or Find Duplicate Idents. Based on the requirement, you may opt to either delete or retain the data.
The delivered SDB database with the SDB Utility Tool has the following integrity checks:
|
Script Group Name |
Name of the Script |
Description of the Script |
|---|---|---|
|
Commodity code checks |
Find Duplicate Commodity Groups |
Verifies duplicate commodity groups |
|
Find Duplicate Commodity Parts |
Verifies duplicate commodity parts |
|
|
Find Duplicate Commodity Codes |
Verifies duplicate commodity codes |
|
|
Find Duplicate Short Codes based on Description |
Verifies duplicate short codes |
|
|
Find Invalid Commodity Codes |
Verifies invalid commodity codes |
|
|
Find Disused Commodity Codes in Spec |
Verifies disused commodity codes in specification |
|
|
Find Commodity Code without Symbols in Specs |
Verifies commodity code without symbol with respect to specifications |
|
|
Find Commodity Code without Symbols in SDB |
Verifies commodity code without symbols in SDB |
|
|
Ident Checks |
Find Duplicate Idents |
Verifies duplicate idents |
|
Find Invalid Idents not in Spec |
Verifies invalid idents not mentioned in specifications |
|
|
Find Invalid Idents in Spec |
Verifies invalid idents in specification |
|
|
Find Invalid Idents in all Specs |
Verifies all invalid idents in specifications |
|
|
Geometric Checks |
Find Duplicate Geometric Data |
Verifies duplicate geometric data |
|
Find Duplicate Geometrics within Rule |
Verifies duplicate geometrics within rules |
|
|
Find Duplicate Geometrics across Rules |
Verifies duplicate geometrics across rules |
|
|
Find Missing Commodity Relations in Spec |
Verifies for missing commodity relations in specification |
|
|
Find Missing Geometric Details |
Verifies missing geometric details |
|
|
Find Geometric Data with Invalid Nominal Size (0.XX) |
Verifies geometric data with invalid nominal size (0.XX) |
|
|
Table Details Checks |
Find Duplicate Table Details based on Short Description and Description |
Verifies duplicate table details based on short description and description |
|
Find Disused Table Details in Item Mappings |
Verifies disused table details in item mappings |
|
|
Find Disused Table Details in Geometric Rules |
Verifies disused table details in geometric rules |
|
|
Find Disused Table Details in Active Commodity Codes |
Verifies disused table details in active commodity codes |
|
|
Find Mismatching Code Lists in Table Details |
Verifies mismatching code lists in table details |
|
|
Find Missing Base Material in Table Details |
Verifies missing base material in table details |
|
|
Weight/COG/DSTD Checks |
Find Weight Geometric Data without Weight Values |
Verifies weight geometric data without weight values |
|
Find Commodity Codes without Weight Tables |
Verifies commodity codes without weight tables |
|
|
Find Commodity Codes without Dimension Tables |
Verifies commodity codes without dimension tables |
|
|
Find Commodity Codes without COG tables |
Verifies commodity codes without COG tables |
|
|
3D Sheet Configuration Checks |
Find Invalid Commodity Codes in Selection Filters |
Verifies invalid commodity codes in selection filters |
|
Find Disused Commodity Codes in Selection Filters |
Verifies disused commodity codes in selection filters |
|
|
NLS Checks |
Find Parameters without NLS Description |
Verifies applications parameters without NLS descriptions |
|
Find Specification Names without NLS Description |
Verifies specification names without NLS descriptions |
|
|
Find Commodity Codes without NLS Description |
Verifies commodity codes without NLS descriptions |
|
|
Find Idents without NLS Description |
Verifies for idents without NLS descriptions |
|
|
Find Table Details without NLS Description |
Verifies for table details without NLS descriptions |
|
|
Find Parts without NLS Description |
Verifies parts without NLS descriptions |
|
|
Find Geometric Names without NLS Description |
Verifies geometric names without NLS descriptions |
|
|
Find Short Codes without NLS Description |
Verifies short codes without NLS descriptions |
|
|
Find Table Group Details without NLS Description |
Verifies table group details without NLS descriptions |
|
|
Find Specification Types without NLS Description |
Verifies specification types without NLS descriptions |
|
|
Find Units without NLS Description |
Verifies units without NLS descriptions |
|
|
Find Unit Systems without NLS Description |
Verifies unit systems without descriptions |
|
|
Find Table Names without NLS Description |
Verifies tables without NLS descriptions |
|
|
Find Documents without NLS Description |
Verifies documents without NLS descriptions |
|
|
Find Verification Reports (Attributes) without NLS Description |
Verifies verification reports (attributes) without NLS descriptions |
|
|
Find Verification Reports (References) without NLS Description |
Verifies verification reports (references) without NLS descriptions |
|
|
Find Symbol Libraries without NLS Description |
Verifies symbol libraries without NLS descriptions |
|
|
Find Class Hierarchy Names without NLS Description |
Verifies class hierarchy without NLS descriptions |
|
|
Find Object Parameters without NLS Description |
Verifies object parameters without NLS descriptions |
|
|
Find Object Parameters Details without NLS Description |
Verifies object parameter details without NLS descriptions |
|
|
Find DBA Setting without NLS Description |
Verifies DBA setting without NLS descriptions |
|
|
Find Class Dependency Property Values without NLS Description |
Verifies class dependency property values without NLS descriptions |
|
|
Find Class Hierarchy Layouts without NLS Description |
Verifies class hierarchy layouts without NLS descriptions |
|
|
Find CMS Ident Property Values without Description in this NLS but present in other NLD |
Verifies all CMS ident property values without descriptions in this NLS but present in any other NLS |
|
|
SDB Other Useful Scripts |
Find duplicate geometric |
To find duplicate geometrics data on decimal places, mm values |
|
Find duplicate ident |
To find duplicate idents data on decimal place, mm values |
|
|
Find duplicate table detail code |
To find duplicate table detail codes |
|
|
Find commodity codes associated with duplicate table detail code |
To find commodity codes associated with duplicate table detail codes |
|
|
Find geometric rules associated with duplicate table detail code |
To find geometric rules associated with duplicate table detail codes |
|
|
Find item mappings associated with duplicate table detail code |
To identify item mappings associated with duplicate table detail codes |
|
|
Find invalid ident geometrics for commodity codes with group/part (FLJ, MFKN, OSOC, GSW) |
To identify invalid ident geometrics for commodity codes with group/part (FLJ, MFKN, OSOC, GSW) |
|
|
Find SPRD and SP3D short code mapping in SDB |
To print the SPRD and S3D short code mapping in SDB |
|
|
Find geometric relation for a given commodity code |
To verify commodity geometric relation |
|
|
Get ident description for CMS class |
To get ident description (CMS INL, CMS INS) for CMS class |
|
|
Get CMS ident layouts for CMS class |
To get CMS ident layouts for CMS class |
|
|
Get class layout for CMS class |
To get class layout (CMS CLL M, CMS CLL S, CMS CLS M, CMS S CLS S) for CMS class, based on all the attributes defined on the CMS class |