Skip to Content
SAP IQ

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

Tags:
  • 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