Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Task syntax

GetCPUTopology task

Gets a list of the logical processors on a given host, along with the socket, core, and thread number they map to.

Syntax 1 (SQL)
CALL DBCloud.GetCPUTopology ( host=host )
Syntax 2 (Cloud Command utility)
dbcloudcmd run GetCPUTopology host
  • host

    The host whose topology is to be reported. Accepts a search query that identifies one host, for example a host name or ID. (Required)

  • virtual_cpus

    An output parameter. Internal use only.

Required privileges



The information returned from this task tells you how many cores are used by cloud servers started on this host. To restrict the number of cores used, you can specify which logical processors to start a cloud server on by using the -gta option.


To get the list of logical processors available on hostA:

dbcloudcmd run GetCPUTopology name:hostA

Suppose the above task returned the following data:

Collecting CPU topology information of host ">a href="event: /dbcloud/Hosts(HS-c5w5)"< hostA>/a<".
    args              host Hosts('hostA')
    creation_time     2012-03-05T17:32:31.403000-05:00
    endtime           2012-03-05T22:32:33.247000+00:00
    event_id          EV-b7w5
    object_uri        /dbcloud/Tasks(TK-v7w5)
    outargs           virtual_cpus 0(socket:0,core:0,thread:0;servers:hostA#1);
    server_id         SV-v5w5
    starttime         2012-03-05T22:32:32.231000+00:00
    task_name         GetCPUTopology
    task_status       Success
    taskdefinition_id TD-5r2c

To make sure that all cloud servers on hostA use no more than 2 cores, add an extra parameter to the cloud server command line for each cloud server on this host, such as:

-gta 0,1