Teamcenter Admin Cheat Sheet

Delete an attribute
set POM_RM_ATTR=ON (run this from the teamcenter command prompt)
[-remove_attr infobda password dba class AttributeName]
Example – install -remove_attr infobda password dba Item_IRMstr data1

Unlock DB – Error “Only SA can log in”
install -unlock_db -u=infodba -p=password -g=dba

Regenerate schema file
install -regen_schema_file -u=infodba -p=infodba -g=dba

generate the pom_xmt file
install -gen_xmit_file -u=infodba -p=password -g=dba

make sure there are no db processes
clearlocks -assert_all_dead -u=infodba -p=password -g=dba

Rename an attribute
[–rename_attr user-id password group class old-attribute-name new-attribute-name]
Example – install –rename_attr infodba password dba Item_IRMstr oldname newname

Edit a attribute
Ex: Adding “Null is Valid” to TXT_ECO
[–mod_attr user-id passwd grp class name token {+ | –}]
install -mod_attr infodba infodba dba TXT_ECO Affected POM_null_is_valid +

Tokens
POM_attr_export_as_string
POM_attr_follow_on_export
POM_attr_ignore_export_errors
POM_attr_is_candidate_key
POM_attr_may_not_be_stubbed
POM_attr_no_pom_backpointer
POM_cannot_be_frozen
POM_has_initial_value
POM_has_lowerbound
POM_has_upperbound
POM_is_classvariable
POM_is_unique
POM_null_is_valid
POM_public_read
POM_public_write
POM_transient

Edit the string length
EX: Extending string length to TXT_ECO.ChangeClass TXT_ECO
install -alter_str_len -u=infodba -p=infodba -g=dba TXT_ECO ChangeClass 15

Add a new attribute
EX: Adding attributes to TXT_ECO
[–add_attr user-id passwd grp class name type length descriptor {strlen | ref_class}]
install -add_attr infodba infodba dba TXT_ECO SoftwareAffected 2008 1 64 3

Attribute type by code
2001 – POM_char
2002 – POM_date
2003 – POM_double
2004 – POM_float
2005 – POM_int
2006 – POM_logical
2007 – POM_short
2008 – POM_string

*This post is more of for reference and is not meant to give detialed information.