Is there any method in which I can output all of the cluster wide property values to a text file ?
CA API Gateway 10.x
There are a few different methods you can pursue to accomplish this.
1. From the gateway database host you can enter the following command:
mysql -e "select propkey, propvalue from ssg.cluster_properties \G" > /tmp/cwp.txt
This will generate a /tmp/cwp.txt file which contains all of the cluster wide properties and their values.
2. From the gateway database host you can execute the following:
mysql
use ssg
\T cwp.txt
select propkey, propvalue from cluster_properties\G
\t
exit
The above will create a cwp.txt file in your current working directory which will contain the output from the mysql queries which were executed.