This structure is used to pass information to sqluroll - Rollforward Database.
Table 14. Fields in the RFWD-INPUT Structure
| Field Name | Data Type | Description |
|---|---|---|
| VERSION | sqluint32 | Rollforward version. |
| PDBALIAS | Pointer | Database alias. |
| CALLERACTION | UNSIGNED SHORT | Action. |
| PSTOPTIME | Pointer | Stop time. |
| PUSERNAME | Pointer | User name. |
| PPASSWORD | Pointer | Password. |
| POVERFLOWLOGPATH | Pointer | Overflow log path. |
| NUMCHNGLGOVRFLW | UNSIGNED SHORT | Number of changed overflow log paths (MPP only). |
| PCHNGLOGOVRFLW | Structure | Changed overflow log paths (MPP only). |
| CONNECTMODE | UNSIGNED SHORT | Connect mode. |
| PTABLESPACELIST | Structure | A pointer to a list of table space names. For information about this structure, see SQLU-TABLESPACE-BKRST-LIST. |
| ALLNODEFLAG | SHORT | All node flag. |
| NUMNODES | SHORT | Size of the node list. |
| PNODELIST | Pointer | List of node numbers. |
| NUMNODEINFO | SHORT | Size of pNodeInfo in RFWD-OUTPUT. |
| DLMODE | UNSIGNED SHORT | This parameter is not currently used. |
| PREPORTFILE | Pointer | This parameter is not currently used. |
| PDROPPEDTBLID | Pointer | A string containing the ID of the dropped table whose recovery is being attempted. |
| PEXPORTDIR | Pointer | The directory into which the dropped table data will be exported. |
| NODENUM | SQL_PDB_NODE_TYPE | Node number. |
| PATHLEN | UNSIGNED SHORT | Length of the new log path. |
| LOGPATH | CHAR(255) | New overflow log path. |
Language Syntax
C Structure
/* File: sqlutil.h */
/* Structure: RFWD-INPUT */
/* ... */
SQL_STRUCTURE rfwd_input
{
sqluint32 version;
char *pDbAlias;
unsigned short CallerAction;
char *pStopTime;
char *pUserName;
char *pPassword;
char *pOverflowLogPath;
unsigned short NumChngLgOvrflw;
struct sqlurf_newlogpath *pChngLogOvrflw;
unsigned short ConnectMode;
struct sqlu_tablespace_bkrst_list *pTablespaceList;
short AllNodeFlag;
short NumNodes;
SQL_PDB_NODE_TYPE *pNodeList;
short NumNodeInfo;
unsigned short DlMode; /* This parameter is not currently used. */
char *pReportFile; /* This parameter is not currently used. */
char *pDroppedTblID;
char *pExportDir;
};
/* ... */
|
/* File: sqlutil.h */
/* Structure: SQLURF-NEWLOGPATH */
/* ... */
SQL_STRUCTURE sqlurf_newlogpath
{
SQL_PDB_NODE_TYPE nodenum;
unsigned short pathlen;
char logpath[SQL_LOGPATH_SZ+SQL_LOGFILE_NAME_SZ+1];
};
/* ... */
|
COBOL Structure
* File: sqlutil.cbl
01 SQL-RFWD-INPUT.
05 SQL-VERSION PIC 9(9) COMP-5.
05 SQL-DBALIAS USAGE IS POINTER.
05 SQL-CALLERACTION PIC 9(4) COMP-5.
05 FILLER PIC X(2).
05 SQL-STOPTIME USAGE IS POINTER.
05 SQL-USERNAME USAGE IS POINTER.
05 SQL-PASSWORD USAGE IS POINTER.
05 SQL-OVERFLOWLOGPATH USAGE IS POINTER.
05 SQL-NUMCHANGE PIC 9(4) COMP-5.
05 FILLER PIC X(2).
05 SQL-P-CHNG-LOG-OVRFLW USAGE IS POINTER.
05 SQL-CONNECTMODE PIC 9(4) COMP-5.
05 FILLER PIC X(2).
05 SQL-P-TABLESPACE-LIST USAGE IS POINTER.
05 SQL-ALLNODEFLAG PIC S9(4) COMP-5.
05 SQL-NUMNODES PIC S9(4) COMP-5.
05 SQL-NODELIST USAGE IS POINTER.
05 SQL-NUMNODEINFO PIC S9(4) COMP-5.
05 SQL-DLMODE PIC 9(4) COMP-5. * This parameter is not
* currently used.
05 SQL-REPORTFILE USAGE IS POINTER. * This parameter is not
* currently used.
05 SQL-DROPPEDTBLID USAGE IS POINTER.
05 SQL-EXPORTDIR USAGE IS POINTER.
*
|
* File: sqlutil.cbl
01 SQLURF-NEWLOGPATH.
05 SQL-NODENUM PIC S9(4) COMP-5.
05 SQL-PATHLEN PIC 9(4) COMP-5.
05 SQL-LOGPATH PIC X(254).
05 FILLER PIC X.
05 FILLER PIC X(1).
*
|