9.4 sampleݿΪڿпɸısampleݿòLOGRETAINΪRecoveryҲִС

db2 update db cfg for sample using LOGRETAIN on

ı˲ٴݿʾݿ⴦ڱݽ״̬ʱҪݿһѻݡڿѡݿѻݻdb2 backup db sample ʵʩ˺ݿͿɽˡ
ѡڿжݿݣҲִС

db2 backup db sample online

ɱʱֹݿӡAPIͷļdb2ApiDf.h

/* C API﷨      */
/* ļ: db2ApiDf.h */
/* API: db2Backup */
SQL_API_RC SQL_API_FN
db2Backup
(
db2Uint32 versionNumber,
void *pDB2BackupStruct,
struct sqlca *pSqlca
);

typedef SQL_STRUCTURE db2BackupStruct
{
char*piDBAlias;
charoApplicationId[SQLU_APPLID_LEN+1];
charoTimestamp[SQLU_TIME_STAMP_LEN+1];
struct db2TablespaceStruct *piTablespaceList;
struct db2MediaListStruct *piMediaList;
char*piUser name;
char*piPasswor d;
void *piVendorOptions;
db2Uint32 iVendorOptionsSize;
db2Uint32 oBackupSize;
db2Uint32 iCallerAction;
db2Uint32 iBufferSize;
db2Uint32 iNumBuffers;
db2Uint32 iParallelism;
db2Uint32 iOptions;
} db2BackupStruct;

typedef SQL_STRUCTURE db2TablespaceStruct
{
char**tablespaces;
db2Uint32 numTablespaces;
} db2TablespaceStruct;

typedef SQL_STRUCTURE db2MediaListStruct
{
char**locations;
db2Uint32 numLocations;
charlocationType;
} db2MediaListStruct;

/* Generic API﷨ */
/* ļ: db2ApiDf.h */
/* API: db2Backup */
SQL_API_RC SQL_API_FN

db2gBackup
(
db2Uint32 versionNumber,
void *pDB2gBackupStruct,
struct sqlca *pSqlca
);

typedef SQL_STRUCTURE db2gBackupStruct
{
char*piDBAlias;
db2Uint32 iDBAliasLen;
char*poApplicationId;
db2Uint32 iApplicationIdLen;
char*poTimestamp;
db2Uint32 iTimestampLen;
struct db2gTablespaceStruct *piTablespaceList;
struct db2gMediaListStruct *piMediaList;
char*piUser name;
db2Uint32 iUsernameLen;
char*piPasswor d;
db2Uint32 iPasswordLen;
void *piVendorOptions;
db2Uint32 iVendorOptionsSize;
db2Uint32 oBackupSize;
db2Uint32 iCallerAction;
db2Uint32 iBufferSize;
db2Uint32 iNumBuffers;
db2Uint32 iParallelism;
db2Uint32 iOptions;
} db2gBackupStruct;

typedef SQL_STRUCTURE db2gTablespaceStruct
{
struct db2Char *tablespaces;
db2Uint32 numTablespaces;
} db2gTablespaceStruct;

typedef SQL_STRUCTURE db2gMediaListStruct
{
struct db2Char *locations;
db2Uint32 numLocations;
charlocationType;
} db2gMediaListStruct;

typedef SQL_STRUCTURE db2Char
{
char*pioData;
db2Uint32 iLength;
db2Uint32 oLength;
} db2Char;

9.5 ʵУͨTSMͻ񱸷SAMPLEݿ⵽TSMϣʹ4棬ĬϻСΪ10244Kҳ

db2 backup database sample use tsm open 2 sessions with 4 buffers
db2 backup database payroll tablespace (syscatspace, userspace1) to
/dev/rmt0, /dev/rmt1 with 8 buffers without prompting

9.6 ڿɻָݿ⣬ÿݵʵÿݿⱸݲÿķۻıݲһݲ

(Sun) db2 backup db kdruse tsm
(Mon) db2 backup db kdronline incremental delta use tsm
(Tue) db2 backup db kdronline incremental delta use tsm
(Wed) db2 backup db kdronline incremental use tsm
(Thu) db2 backup db kdronline incremental delta use tsm
(Fri) db2 backup db kdr online incremental delta use tsm
(Sat) db2 backup db kdronline incremental use tsm

9.7 ִWindowsԴŴ豸ıݲ

db2 backup database sample to \\.\tape0

9.11 ڻAѶTSMDB2ݿ˱ݣνЩݻָBϣ¡
1.	ҪָĻϴյݿ⣬޸ݿò

db2 update db cfg for <dbname>
using TSM_NODENAME=A

УAʾڵ
db2 update db cfg for <dbname>
using TSM_PASSWORD=Password for Node A

УPassword for Node AʾڵATSM롣

db2 update db cfg for <dbname>
using TSM_OWNER =Instance ID from Node A

УInstance ID from Node AʾڵAʵ

9.12 ²裬ʵʩɾĻָ
1.	ȴݿòlogretainuserexitȷDB2ݿɽǰָ
2.	Ҫָɾıռ䣨Ϊռ䣩ִ

alter tablespace ռ
dropped table recovery on

ͷļdb2ApiDf.h﷨˵

/* C API﷨      */
/* ļ: db2ApiDf.h */
/* API: db2Rollforward */
SQL_API_RC SQL_API_FN
db2Rollforward_api
(
db2Uint32 versionNumber,
void *pDB2RollforwardStruct,
struct sqlca *pSqlca
);

typedef SQL_STRUCTURE db2RollforwardStruct
{
struct db2RfwdInputStruct *roll_input;
struct db2RfwdOutputStruct *roll_output;
} db2RollforwardStruct;

typedef SQL_STRUCTURE db2RfwdInputStruct
{
sqluint32 version;
char*pDbAlias;
db2Uint32 CallerAction;
char*pStopTime;
char*pUser Name;
char*pPasswor d;
char*pOver flowLogPath;
db2Uint32 NumChngLgOvrflw;
struct sqlurf_newlogpath *pChngLogOvrflw;
db2Uint32 ConnectMode;
struct sqlu_tablespace_bkrst_list *pTablespaceList;
db2int32 AllNodeFlag;
db2int32 NumNodes;
SQL_PDB_NODE_TYPE *pNodeList;
db2int32 NumNodeInfo;
char*pDr oppedTblID;
char*pExpor tDir;
db2Uint32 RollforwardFlags;
} db2RfwdInputStruct;

typedef SQL_STRUCTURE db2RfwdOutputStruct
{
char*pApplicationId;
sqlint32 *pNumReplies;
struct sqlurf_info *pNodeInfo;
} db2RfwdOutputStruct;

/* Generic API﷨*/
/* File: db2ApiDf.h */
/* API: db2Rollforward */
SQL_API_RC SQL_API_FN
db2gRollforward_api
(
db2Uint32 versionNumber,
void *pDB2gRollforwardStruct,
struct sqlca *pSqlca
);

typedef SQL_STRUCTURE db2gRollforwardStruct
{
struct db2gRfwdInputStruct *roll_input;
struct db2RfwdOutputStruct *roll_output;
} db2gRollforwardStruct;

SQL_STRUCTURE db2gRfwdInputStruct
{
db2Uint32 DbAliasLen;
db2Uint32 StopTimeLen;
db2Uint32 UserNameLen;
db2Uint32 PasswordLen;
db2Uint32 OvrflwLogPathLen;
db2Uint32 DroppedTblIDLen;
db2Uint32 ExportDirLen;
sqluint32 Version;
char*pDbAlias;
db2Uint32 CallerAction;
char*pStopTime;
char*pUser Name;
char*pPasswor d;
char*pOver flowLogPath;
db2Uint32 NumChngLgOvrflw;
struct sqlurf_newlogpath *pChngLogOvrflw;
db2Uint32 ConnectMode;
struct sqlu_tablespace_bkrst_list *pTablespaceList;
db2int32 AllNodeFlag;
db2int32 NumNodes;
SQL_PDB_NODE_TYPE *pNodeList;
db2int32 NumNodeInfo;
char*pDr oppedTblID;
char *pExportDir;
db2Uint32 RollforwardFlags;
};

typedef SQL_STRUCTURE db2RfwdOutputStruct
{
char*pApplicationId;
sqlint32 *pNumReplies;
struct sqlurf_info *pNodeInfo;
} db2RfwdOutputStruct;


