sp_iqmpxaliasdbspace procedure

Function

Adds a dbspace alias to SYSIQFILE.

Syntax

“DBA”.sp_iqmpxaliasdbspace( IN _dbspace_name VARCHAR(128), 
IN _server VARCHAR(30),
IN _path VARCHAR(255)	 default NULL,
IN _fromserver VARCHAR(30) default ‘ ‘,
IN _offset UNSIGNED BIGINT default NULL	)

Description

Table 9-33: sp_iqmpxaliasdbspace columns returned

Column

Data type

Description

_dbspace_name

varchar(128)

Name of dbspace for which to add alias

_server

varchar(30)

Server name for the alias

_path

varchar(255)

Path to dbspace file or partition on _server

_fromserver

varchar(30)

Server whose definition is copied

_offset

unsigned bigint

offset to start of user data on raw partition