Multiplex system procedures [CR 385880]

Chapter 9, “System Procedures,” in the Sybase IQ Reference Manual contains errors in syntax for multiplex system procedures. The syntax for sp_iqmakempx should read:

call sp_iqmakempx('host', 'servername',
'dbname.db', 'nnnn ')

where nnnn is the TCP port number where the write server should listen.

Syntax for the following stored procedures also lists internal names (such as l_host_name) instead of parameters (such as host):

The syntax for sp_iqmpxaddremoteusers should read:

 call sp_iqmpxaddremoteusers(‘servername’, ‘qname’	)

Permissions should state that user must have DBA authority.

The syntax for sp_iqmpxaliasdbspace should read:

call sp_iqmpxaliasdbspace( dbspace, ‘server1’,
‘path’, ‘server2’, ‘offset’	 )

Function should state that it adds an alias of an existing dbspace on a new server to SYSIQFILE.

Permissions should state that user must have DBA authority.

The syntax for sp_iqmpxcreatepublication should read:

sp_iqmpxcreatepublication('newserver')

**Table 8: Parameters in sp_iqmpxcreatepublication**
Name	Data type	Description
new server	varchar(30)	Name of server that requires a publication.

Permissions should state that user must have DBA authority.

The syntax for sp_iqmpxcreatequeryserver should read:

call sp_iqmpxcreatequeryserver(‘host’, ‘servername’, ‘path’, ‘nnnn’)

The syntax for sp_iqmpxdropqueryserver should read:

call sp_iqmpxdropqueryserver(‘servername’)

Permissions should state that user must have DBA authority.

The syntax for sp_iqmpxdropserverdbspaces should read:

call sp_iqmpxdropserverdbspaces (‘servername’)

Permissions should state that user must have DBA authority.

The syntax for sp_iqmpxdumptlvlog should read:

sp_iqmpxdumptlvlog(‘struc_type‘, ‘row_order‘)

This procedure displays the following log information:

**Table 9: Columns returned by sp_iqmpxdumptlvlog**
Parameter	Value	Description
struc_type	local or main	Type of IQ store
row_order	desc or asc	Descending or ascending row order

The syntax for sp_iqmpxexcludeserver should read:

call sp_iqmpxexcludeserver(‘servername’, ‘status’)

Permissions should state that user must have DBA authority.

The syntax for sp_iqmpxmakeclean should read:

call sp_iqmpxmakeclean( )

Permissions should state that user must have DBA authority.

The syntax for sp_iqmpxprotectexec should read:

call sp_iqmpxprotectexec(‘command’)

The syntax for sp_iqmpxreplacewriteserver should read:

call sp_iqmpxreplacewriteserver(‘servername’)

Usage should state that the DBA must run it on a query server.

The syntax for sp_iqmpxresetquerysubscription should read:

call sp_iqmpxresetquerysubscription(‘servername’)

The syntax for sp_iqmpxretryexec should read:

call sp_iqmpxretryexec(‘cmd’ , ‘msg’ )

The syntax for sp_iqmpxsetpublisher should read:

call sp_iqmpxsetpublisher(‘servername‘)

The syntax for sp_iqmpxsubscribeuser should read:

call sp_iqmpxsubscribeuser(‘user ‘ , ‘path’ , ‘perm‘)

The syntax for sp_iqmpxunsubscribeuser should read:

call sp_iqmpxunsubscribeuser(‘user ‘)

The syntax for sp_iqmpxvalidate should read:

call dbo.sp_iqmpxvalidate(‘show_msgs’)

The syntax for sp_iqmpxversionfetch should read:

call sp_iqmpxversionfetch( ‘CatalogID ‘ , ‘VersionID ‘ , ‘OAVID ‘ , ‘ServerType‘ , ‘CatalogSync‘ , ‘WCatalogID ‘ ‘WVersionID ‘ )