DescribeOptionGroups - Amazon Relational Database Service

DescribeOptionGroups

Describes the available option groups.

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.

EngineName

A filter to only include option groups associated with this database engine.

Valid Values:

  • db2-ae

  • db2-se

  • mariadb

  • mysql

  • oracle-ee

  • oracle-ee-cdb

  • oracle-se2

  • oracle-se2-cdb

  • postgres

  • sqlserver-ee

  • sqlserver-se

  • sqlserver-ex

  • sqlserver-web

Type: String

Required: No

Filters.Filter.N

This parameter isn't currently supported.

Type: Array of Filter objects

Required: No

MajorEngineVersion

Filters the list of option groups to only include groups associated with a specific database engine version. If specified, then EngineName must also be specified.

Type: String

Required: No

Marker

An optional pagination token provided by a previous DescribeOptionGroups request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

Type: String

Required: No

MaxRecords

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a marker is included in the response so that you can retrieve the remaining results.

Default: 100

Constraints: Minimum 20, maximum 100.

Type: Integer

Required: No

OptionGroupName

The name of the option group to describe. Can't be supplied together with EngineName or MajorEngineVersion.

Type: String

Required: No

Response Elements

The following elements are returned by the service.

Marker

An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

Type: String

OptionGroupsList.OptionGroup.N

List of option groups.

Type: Array of OptionGroup objects

Errors

For information about the errors that are common to all actions, see Common Errors.

OptionGroupNotFoundFault

The specified option group could not be found.

HTTP Status Code: 404

Examples

Example

This example illustrates one usage of DescribeOptionGroups.

Sample Request

https://rds.us-east-1.amazonaws.com/ ?Action=DescribeOptionGroups &MaxRecords=100 &OptionGroupName=myawsuser-grp1 &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140421/us-east-1/rds/aws4_request &X-Amz-Date=20140421T231357Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=fabfbeb85c44e3f151d44211790c5135a9074fdb8d85ec117788ac6cfab6c5bc

Sample Response

<DescribeOptionGroupsResponse xmlns="http://rds.amazonaws.com/doc/2014-10-31/"> <DescribeOptionGroupsResult> <OptionGroupsList> <OptionGroup> <AllowsVpcAndNonVpcInstanceMemberships>true</AllowsVpcAndNonVpcInstanceMemberships> <MajorEngineVersion>5.6</MajorEngineVersion> <OptionGroupName>myawsuser-grp1</OptionGroupName> <EngineName>mysql</EngineName> <OptionGroupDescription>my test option group</OptionGroupDescription> <Options/> </OptionGroup> </OptionGroupsList> </DescribeOptionGroupsResult> <ResponseMetadata> <RequestId>8c6201fc-b9ff-11d3-f92b-31fa5e8dbc99</RequestId> </ResponseMetadata> </DescribeOptionGroupsResponse>

Example

This example illustrates one usage of DescribeOptionGroups.

Sample Request

https://rds.us-west-2.amazonaws.com/ ?Action=DescribeOptionGroups &MaxRecords=100 &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140613/us-west-2/rds/aws4_request &X-Amz-Date=20140613T223341Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=5ae331adcd684c27d66e0b794a51933effe32a4c026eba2e994ae483ee47a0ba

Sample Response

<DescribeOptionGroupsResponse xmlns="http://rds.amazonaws.com/doc/2014-10-31/"> <DescribeOptionGroupsResult> <OptionGroupsList> <OptionGroup> <OptionGroupName>default:mysql-5-5</OptionGroupName> <AllowsVpcAndNonVpcInstanceMemberships>true</AllowsVpcAndNonVpcInstanceMemberships> <MajorEngineVersion>5.5</MajorEngineVersion> <EngineName>mysql</EngineName> <OptionGroupDescription>Default option group MySQL 5.5</OptionGroupDescription> <Options/> </OptionGroup> <OptionGroup> <OptionGroupName>default:postgres-9-3</OptionGroupName> <AllowsVpcAndNonVpcInstanceMemberships>true</AllowsVpcAndNonVpcInstanceMemberships> <MajorEngineVersion>9.3</MajorEngineVersion> <EngineName>postgres</EngineName> <OptionGroupDescription>Default option group for postgres 9.3</OptionGroupDescription> <Options/> </OptionGroup> <OptionGroup> <OptionGroupName>default:sqlserver-ex-10-50</OptionGroupName> <AllowsVpcAndNonVpcInstanceMemberships>true</AllowsVpcAndNonVpcInstanceMemberships> <MajorEngineVersion>10.50</MajorEngineVersion> <EngineName>sqlserver-ex</EngineName> <OptionGroupDescription>Default option group for sqlserver-ex 10.50</OptionGroupDescription> <Options/> </OptionGroup> <OptionGroup> <OptionGroupName>default:sqlserver-se-10-50-mirrored</OptionGroupName> <AllowsVpcAndNonVpcInstanceMemberships>true</AllowsVpcAndNonVpcInstanceMemberships> <MajorEngineVersion>10.50</MajorEngineVersion> <EngineName>sqlserver-se</EngineName> <OptionGroupDescription>Default Mirroring-enabled option group for sqlserver-se 10.50</OptionGroupDescription> <Options> <Option> <OptionName>Mirroring</OptionName> <OptionDescription>SQLServer Database Mirroring</OptionDescription> <Persistent>false</Persistent> <Permanent>false</Permanent> <OptionSettings/> <VpcSecurityGroupMemberships/> <DBSecurityGroupMemberships/> </Option> </Options> </OptionGroup> <OptionGroup> <OptionGroupName>default:sqlserver-se-11-00</OptionGroupName> <AllowsVpcAndNonVpcInstanceMemberships>true</AllowsVpcAndNonVpcInstanceMemberships> <MajorEngineVersion>11.00</MajorEngineVersion> <EngineName>sqlserver-se</EngineName> <OptionGroupDescription>Default option group for sqlserver-se 11.00</OptionGroupDescription> <Options/> </OptionGroup> <OptionGroup> <OptionGroupName>myawsuser-opt-grp</OptionGroupName> <AllowsVpcAndNonVpcInstanceMemberships>false</AllowsVpcAndNonVpcInstanceMemberships> <MajorEngineVersion>11.2</MajorEngineVersion> <EngineName>oracle-ee</EngineName> <OptionGroupDescription>test option group</OptionGroupDescription> <Options> <Option> <OptionName>NATIVE_NETWORK_ENCRYPTION</OptionName> <OptionDescription>Oracle Advanced Security - Native Network Encryption</OptionDescription> <Persistent>false</Persistent> <Permanent>false</Permanent> <OptionSettings> <OptionSetting> <DataType>STRING</DataType> <IsModifiable>true</IsModifiable> <IsCollection>true</IsCollection> <Description>Specifies list of checksumming algorithms in order of intended use</Description> <Name>SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER</Name> <Value>SHA1,MD5</Value> <ApplyType>STATIC</ApplyType> <DefaultValue>SHA1,MD5</DefaultValue> <AllowedValues>SHA1,MD5</AllowedValues> </OptionSetting> <OptionSetting> <DataType>STRING</DataType> <IsModifiable>true</IsModifiable> <IsCollection>true</IsCollection> <Description>Specifies list of encryption algorithms in order of intended use</Description> <Name>SQLNET.ENCRYPTION_TYPES_SERVER</Name> <Value>RC4_256,AES256,AES192,3DES168,RC4_128,AES128,3DES112,RC4_56,DES,RC4_40,DES40</Value> <ApplyType>STATIC</ApplyType> <DefaultValue>RC4_256,AES256,AES192,3DES168,RC4_128,AES128,3DES112,RC4_56,DES,RC4_40,DES40</DefaultValue> <AllowedValues>RC4_256,AES256,AES192,3DES168,RC4_128,AES128,3DES112,RC4_56,DES,RC4_40,DES40</AllowedValues> </OptionSetting> <OptionSetting> <DataType>STRING</DataType> <IsModifiable>true</IsModifiable> <IsCollection>false</IsCollection> <Description>Specifies the desired encryption behavior</Description> <Name>SQLNET.ENCRYPTION_SERVER</Name> <Value>REQUESTED</Value> <ApplyType>STATIC</ApplyType> <DefaultValue>REQUESTED</DefaultValue> <AllowedValues>ACCEPTED,REJECTED,REQUESTED,REQUIRED</AllowedValues> </OptionSetting> <OptionSetting> <DataType>STRING</DataType> <IsModifiable>true</IsModifiable> <IsCollection>false</IsCollection> <Description>Specifies the desired data integrity behavior</Description> <Name>SQLNET.CRYPTO_CHECKSUM_SERVER</Name> <Value>REQUESTED</Value> <ApplyType>STATIC</ApplyType> <DefaultValue>REQUESTED</DefaultValue> <AllowedValues>ACCEPTED,REJECTED,REQUESTED,REQUIRED</AllowedValues> </OptionSetting> </OptionSettings> <VpcSecurityGroupMemberships/> <DBSecurityGroupMemberships/> </Option> <Option> <OptionName>XMLDB</OptionName> <OptionDescription>Oracle XMLDB Repository</OptionDescription> <Persistent>false</Persistent> <Permanent>false</Permanent> <OptionSettings/> <VpcSecurityGroupMemberships/> <DBSecurityGroupMemberships/> </Option> <Option> <Port>1158</Port> <OptionName>OEM</OptionName> <OptionDescription>Oracle Enterprise Manager (Database Control only)</OptionDescription> <Persistent>false</Persistent> <Permanent>false</Permanent> <OptionSettings/> <VpcSecurityGroupMemberships/> <DBSecurityGroupMemberships> <DBSecurityGroup> <Status>authorized</Status> <DBSecurityGroupName>sg-db-sec-grp</DBSecurityGroupName> </DBSecurityGroup> </DBSecurityGroupMemberships> </Option> </Options> </OptionGroup> <Option> <OptionName>APEX</OptionName> <OptionDescription>Oracle Application Express Runtime Environment</OptionDescription> <Persistent>false</Persistent> <Permanent>false</Permanent> <OptionSettings/> <VpcSecurityGroupMemberships/> <DBSecurityGroupMemberships/> </Option> </Options> </OptionGroup> </OptionGroupsList> </DescribeOptionGroupsResult> <ResponseMetadata> <RequestId>b2ce0772-f55a-11e3-bd0f-bb88ac05a37c</RequestId> </ResponseMetadata> </DescribeOptionGroupsResponse>

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: