Extending TAMIT ASSETNUM attribute field length

Here is the procedure to extend the size of the attribute ASSETNUM in the ASSET MBO in TAMIT:

• Do a database backup
  
• Go To-> System Configuration -> Platform Configuration -> Database Configuration
• Object: ASSET
• Select ASSET
• Go to Attributes tab
• Select ASSETNUM
• Change the length to 32
• The attribute will be in Change mode
• Save it
• Go to List tab
• Select Action -> Managed Admin Mode
• Click Turn Admin Mode On
• Click Refresh Status until Admin Mode is ON
• Connect to TPAP DB
• db2 drop trigger multiassetloccip_u
• db2 drop trigger multiassetloccip_t
• Select Action -> Apply Configuration Changes
• Check Do you have a current backup?
• Click Start Configuring the Databsase
• Click Turn Admin Mode OFF