Sp_iqstatus;Sp_iqversionuse;key points to see: device size;dynamic memory;Active TXN versionscluster:1, the operating system should be the same2, the ability of concurrent query can be extended horizontally;3, single-machine, concurrent more than 1 seconds of query, to forty or fifty of the simultaneous query, performance will be sharply reduced. One of the secondary contacts is the backup node as the coordination node. adding contacts requires an IQ license (CPU license), plus a Mutiplex server license. To start a single-node IQ:Start_iq @params. CFG - N Mpxnode_c- x "tcpip{host=host1;port=2763}"-n names are generally specified on the command line. hostnameServerDatabase Pathpath to IQ main &tempdbisql-c "Uid=dba;pwd=sql;eng=mpxnode_c"Master node:start_iq @params. cfg-n T2 t2.dbCreate Multiplex server mpxnode_w1 DATABASE ' host2\\mpx\\mpxtest.db ' HOST ' host2 ' s IP ' PO RT 2957 ROLE WRITER STATUS INCLUDEDpath to existfrom the node you need to configure:HostPortIQ Softwareno need to build a libraryDb/.log/iq/store Pathafter completion, go to the slave node path:dbbackup-c "UID=DBA;PWD=SQL;ENG=T2;"-d-y.>dbbackup-c "uid=dba;pwd=sql;eng=mpx_n1;links=tcpip{port=2765}"-d-y.>dblog-r-T mpx_n1.log mpx_n1.db>start_iq-n mpx_sec-x "tcpip{port=2689}" @params. CFG mpx_n1.dbConnect to a nodedbisql-c ""-X "tcpip{}"alter tablespace iq_system_temp add FILE mpx_node_temp ' temp_file.iqtmp ' sizeSp_iqmpxinfo View the master-slave interface information. DBLogthe data mining function inside the IQ, etc., requires an additional charge. text scanning, custom functions, can be implemented. Virtual Backup.
From for notes (Wiz)
SAP Sybase Training Note 3
