Suspends or resumes
the I/O write operations for a database. I/O write operations must
be suspended before a split mirror of a database can be taken.
Scope
This API affects only
the database partition where the API is run. In DB2® pureScale® environments, this API can be run from any member to
suspend I/O write operations for all the members, or to resume I/O
write operations for all the suspended members.
Authorization
One of the following authorities:
Required connection
Database
API include file
db2ApiDf.h
API and data structure syntax
SQL_API_RC SQL_API_FN
db2SetWriteForDB (
db2Uint32 versionNumber,
void * pParmStruct,
struct sqlca * pSqlca);
typedef struct db2SetWriteDbStruct
{
db2int32 iOption;
char *piTablespaceNames;
} db2SetWriteDbStruct;
db2SetWriteForDB API parameters
- versionNumber
- Input. Specifies the version and release level of the structure
passed as the second parameter pParmStruct.
- pParmStruct
- Input. A pointer to the db2SetWriteDbStruct structure.
- pSqlca
- Output. A pointer to the sqlca structure.
db2SetWriteDbStruct data structure parameters
- iOption
- Input. Specifies the action. Valid values are:
- - DB2_DB_SUSPEND_WRITE
- Suspends I/O write operations to disk.
- - DB2_DB_RESUME_WRITE
- Resumes I/O write operations to disk.
- piTablespaceNames
- Input. Reserved for future use.