search cancel

Output Cluster Wide Property Values To A File

book

Article ID: 243697

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

Is there any method in which I can output all of the cluster wide property values to a text file ?

Environment

CA API Gateway 10.x

Resolution

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.