SAP IQ COCKPIT: Shared-Nothing Multiplex - Configuring DAS DBspace

• Create IQ multiplex(iqmpx1001c, iqmpx1001q1, iqmpx1001q2, iqmpx1001q3, iqmpx1001q4) (http://scn.sap.com/docs/DOC-65374)
• Create Logical Server and add logical server to the login policy

      CREATE LOGICAL SERVER "ls1" MEMBERSHIP (FOR LOGICAL COORDINATOR,  "iqmpx1001q2", "iqmpx1001q3", "iqmpx1001q4");

      ALTER LOGICAL SERVER "ls1" POLICY "root";

•   Select New for creating logical server

• Select Resource for which logical  server will be created.

• Specify logical server name and logical server policy

• Confirm Node Membership

• Refresh Logical Servers

•     View logical server ls1 in logical Sever pane   

• Enable DQP in logical server policy

• If you have a single shared-nothing logical server which includes all multiplex servers (including the coordinator), set the login policy option DEFAULT_LOGICAL_SERVER to the name of this shared-nothing logical server.

For example, if ls1  is the only shared-nothing logical server, and all multiplex servers are members (including the coordinator), execute:

• Confirm that the DAS listener port is not blocked. Each time the SAP IQ server starts, it assigns a random free port for the DAS listener. Open .stderr and check for DAS Listener stared message

• Create DAS dbspace using create dbspace wizard

• Specify Resource Name

• Specify Logical Server Name  

• Add dbfiles to DAS dbspace

• sp_iqdbspace does show logical server for DAS dbpace

• sp_iqfile: Server name and Mirror to logical file displayed for DAS dbfiles