LISTDBSERVERS()`¶

About ListDbServers¶

Returns information about the database servers that belong to the specified Exadata infrastructure.

Method Signature¶

IMPORTING¶

Required arguments:¶

`iv_cloudexadatainfrastruct00` `TYPE /AWS1/ODBRESOURCEIDORARN` `/AWS1/ODBRESOURCEIDORARN`¶

The unique identifier of the Oracle Exadata infrastructure.

Optional arguments:¶

`iv_maxresults` `TYPE /AWS1/ODBINTEGER` `/AWS1/ODBINTEGER`¶

The maximum number of items to return for this request. To get the next page of items, make another request with the token returned in the output.

Default: 10

`iv_nexttoken` `TYPE /AWS1/ODBSTRING` `/AWS1/ODBSTRING`¶

The token returned from a previous paginated request. Pagination continues from the end of the items returned by the previous request.

RETURNING¶

`oo_output` `TYPE REF TO /aws1/cl_odblistdbserversout` `/AWS1/CL_ODBLISTDBSERVERSOUT`¶

Domain /AWS1/RT_ACCOUNT_ID

Primitive Type NUMC

Examples¶

Syntax Example¶

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->/aws1/if_odb~listdbservers(
  iv_cloudexadatainfrastruct00 = |string|
  iv_maxresults = 123
  iv_nexttoken = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lv_string = lo_result->get_nexttoken( ).
  LOOP AT lo_result->get_dbservers( ) into lo_row.
    lo_row_1 = lo_row.
    IF lo_row_1 IS NOT INITIAL.
      lv_resourceid = lo_row_1->get_dbserverid( ).
      lv_resourcestatus = lo_row_1->get_status( ).
      lv_string = lo_row_1->get_statusreason( ).
      lv_integer = lo_row_1->get_cpucorecount( ).
      lv_integer = lo_row_1->get_dbnodestoragesizeingbs( ).
      lo_dbserverpatchingdetails = lo_row_1->get_dbserverpatchingdetails( ).
      IF lo_dbserverpatchingdetails IS NOT INITIAL.
        lv_integer = lo_dbserverpatchingdetails->get_estimatedpatchduration( ).
        lv_dbserverpatchingstatus = lo_dbserverpatchingdetails->get_patchingstatus( ).
        lv_string = lo_dbserverpatchingdetails->get_timepatchingended( ).
        lv_string = lo_dbserverpatchingdetails->get_timepatchingstarted( ).
      ENDIF.
      lv_string = lo_row_1->get_displayname( ).
      lv_string = lo_row_1->get_exadatainfrastructureid( ).
      lv_string = lo_row_1->get_ocid( ).
      lv_string = lo_row_1->get_ociresourceanchorname( ).
      lv_integer = lo_row_1->get_maxcpucount( ).
      lv_integer = lo_row_1->get_maxdbnodestorageingbs( ).
      lv_integer = lo_row_1->get_maxmemoryingbs( ).
      lv_integer = lo_row_1->get_memorysizeingbs( ).
      lv_string = lo_row_1->get_shape( ).
      lv_timestamp = lo_row_1->get_createdat( ).
      LOOP AT lo_row_1->get_vmclusterids( ) into lo_row_2.
        lo_row_3 = lo_row_2.
        IF lo_row_3 IS NOT INITIAL.
          lv_string = lo_row_3->get_value( ).
        ENDIF.
      ENDLOOP.
      lv_computemodel = lo_row_1->get_computemodel( ).
      LOOP AT lo_row_1->get_autonomousvmclusterids( ) into lo_row_2.
        lo_row_3 = lo_row_2.
        IF lo_row_3 IS NOT INITIAL.
          lv_string = lo_row_3->get_value( ).
        ENDIF.
      ENDLOOP.
      LOOP AT lo_row_1->get_autonomousvirtmachineids( ) into lo_row_2.
        lo_row_3 = lo_row_2.
        IF lo_row_3 IS NOT INITIAL.
          lv_string = lo_row_3->get_value( ).
        ENDIF.
      ENDLOOP.
    ENDIF.
  ENDLOOP.
ENDIF.

/AWS1/CL_ODB=>LISTDBSERVERS()¶