Increase System Log message text field length

[Anand]

Hi All,

In our environment, System Log message text field is configured for 254 characters length. As for audit purpose, we added to log few of the metadata field values in System Log during document retrieval. Since the field length is 254 chars only, some of the metadata field values are truncated. So planning to increase the message text length to 500 chars.

Kindly advise whether updating the System Log AG is also same as others (Rename old AG , Copy and create a new System Log AG and update the field with 500 chars in new AG and map to Sys Log folder) or Update DB or any other way?

Thanks !

[Justin Derrick]

In CMOD 8.5 and above, the System Log Message Text field should be a varchar field of up to 2048 characters wide.

If you haven't done this as part of your upgrades, go back over the readme documents for your version (and maybe the version before) to find the instructions on how to migrate your CMOD installation to the new System Log table with the longer message text field.

-JD.

[Anand]

I have got SQL error while trying to update the System Log using steps mentioned in the upgrade guide. Anyone, kindly help.

[Justin Derrick]

There's a field missing from your Application Group table (arsag) in CMOD.  Sounds like a failed upgrade to me.

-JD.

[Anand]

Hi JD

I could see ARSAG table contains all 34 columns as given in the IBM 9.0 Admin guide in my upgraded instance. Also I am able to bring up the application in 9.0V. Only issue is the System Log message text still having the 254 varchar.

Thanks
Anand

[Alessandro Perucchi]

Hi JD

I could see ARSAG table contains all 34 columns as given in the IBM 9.0 Admin guide in my upgraded instance. Also I am able to bring up the application in 9.0V. Only issue is the System Log message text still having the 254 varchar.

Thanks
Anand

Did you try to run the command:

Code: [Select]

arssyscr -I instance -u -l