IBM Support

How to enable DOCLINKS_ASSETID Relationship to use for Attachments to be moved with Asset to another Site

Technical Blog Post


Abstract

How to enable DOCLINKS_ASSETID Relationship to use for Attachments to be moved with Asset to another Site

Body

You may have read the article below that describes how DOCLINKS_ASSETID relationship can be used so that attachments can be moved with an asset if you move it to another site.

/support/pages/node/262541

However in that article it doesn't have specific instruction on how to use the said relationship

To use the relationship,  you would need to set the property SYSTEMLEVASSETDOCS = 1.

You may use the following SQL command to enable it.

First retrieve the rowstamp by using this command.
select * from maxvars WHERE varname = 'SYSTEMLEVASSETDOCS'

Second is to update the value using the following:
update maxvars set varvalue = 0 where rowstamp = ??? <-- use rowstamp from value returned in SQL above

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11130151