DB2 Version 10.1 for Linux, UNIX, and Windows

db2SetStogroupPaths API - Redirect storage group paths

Sets the storage paths of a storage group during a redirected restore operation. A redirected restore is a restore in which the storage (table space containers or storage group paths) of the restored database is different from the storage that was referenced by the source database at the time that you produced the backup image. Use this API before using the RESTORECONTINUE command and after using the RESTOREREDIRECT command when all table spaces are in STORAGE DEFINITION PENDING state or STORAGE DEFINITION ALLOWED state.

Authorization

One of the following authorities:

SYSADM
SYSCTRL

Required connection

Database

API include file

db2ApiDf.h

API and data structure syntax

SQL_API_RC SQL_API_FN 
  db2SetStogroupPaths (
  db2Uint32 versionNumber, 
  void * pParmStruct,
  struct sqlca * pSqlca); 

typedef SQL_STRUCTURE db2StoragePath
{
  char path[SQL_STORAGEPATH_SZ + 1]; 
} db2StoragePath;

typedef SQL_STRUCTURE db2StoragePathList
{
  struct db2StoragePath *list; 
  db2Uint32 numPaths; 
} db2StoragePathList;

typedef struct db2SetStogroupPathsStruct
{
  char iStogroupName[SQL_MAX_IDENT + 1];
  struct db2StoragePathList iPaths; 
} db2SetStogroupPathsStruct;

db2SetStogroupPaths API parameters

versionNumber: Input. The version and release level of the structure that you specify for the second parameter, pParmStruct.
pParmStruct: Input. A pointer to the db2SetStogroupPathsStruct structure.
pSqlca: Output. A pointer to the sqlca structure.

db2SetStogroupPathsStruct data structure parameters

iStogroupName: Input. Specifies the storage group name.
iPaths: Input. A list of storage group paths to be used by the storage group.
iNumPaths: Input. The number of paths in the piPaths list.