gtpo1m2bOperations

ZCDCO-Managing Continuous Data Collection

Use this command to manage TPF Application Requester (TPFAR) continuous data collection (CDC).

Requirements and Restrictions

Format




START
starts TPFAR CDC.

Freq
specifies how often a TPFAR CDC record is collected, where:

3
indicates that the record is collected every 3 seconds.

seconds
is the number of seconds in the range 1-99.

TIme
specifies how long a TPFAR CDC record is generated, where:

Inf
indicates that the record is generated until TPFAR CDC is stopped.

minutes
is the number of minutes in the range 1-1440.

RDB-rdbname
specifies the name of a remote relational database, where rdbname is the 1- to 18-character alphanumeric name.
Note:
Ensure that you entered the ZSQLD command previously to define the database specified by the RDB parameter.

CREATE
creates the TPFAR CDC table on the specified remote relational database and adds an entry to the remote relational database list.

CLEAR
clears all entries in the TPFAR CDC table on the specified remote relational database.

DELETE
deletes the TPFAR CDC table on the specified remote relational database.

MIGRATE
migrates the TPFAR CDC table on the specified remote relational database to the current level needed to run CDC.

STOP
stops TPFAR CDC on the specified remote relational database.

DISplay
displays TPFAR CDC information, where:

COLLECTORS
displays the items that have been started and are currently running.

DATABASES
displays databases and tables that have been created or defined.

INIT
clears the list of all the remote relational databases on the TPF system.

Additional Information

Examples

In the following example, the TPFAR CDC table is created.

+--------------------------------------------------------------------------------+
|User:   ZCDCO CREATE RDB-TPFDB                                                  |
|                                                                                |
|System: CDCO0007I 10.01.37 RDB-TPFDB -CREATED CONTINUOUS DATA COLLECTION        |
|                           TABLE ON THE REMOTE DATABASE                         |
+--------------------------------------------------------------------------------+

In the following example, all previously created TPFAR CDC tables are displayed.

+--------------------------------------------------------------------------------+
|User:   ZCDCO DISPLAY DATABASES                                                 |
|                                                                                |
|System: CDCO0020I 10.01.37 DISPLAYING CREATED CONTINUOUS DATA COLLECTION TABLES |
|        DB                  TABLE                                               |
|        ----------------    ----------                                          |
|        TPFDB               IBM_TPF_DATA                                        |
|        END OF DISPLAY                                                          |
+--------------------------------------------------------------------------------+

In the following example, TPFAR CDC is started for remote relational database TPFDB.

+--------------------------------------------------------------------------------+
|User:   ZCDCO START RDB-TPFDB FREQ-10                                           |
|                                                                                |
|System: CDCO0002I 10.01.37 RDB-TPFDB -CONTINUOUS DATA COLLECTION HAS BEEN STARTE|
+--------------------------------------------------------------------------------+

In the following example, all CDC collectors that are currently running are displayed.

+--------------------------------------------------------------------------------+
|User:   ZCDCO DISPLAY COLLECTORS                                                |
|                                                                                |
|System: CDCO0016I 10.01.37 DISPLAYING RUNNING CONTINUOUS DATA COLLECTORS        |
|        DB      TABLE           FREQ    RUN TILL    LAST RUN    NEXT RUN        |
|        ----    ----------      ----    --------    --------    --------        |
|        TPFDB   IBM_TPF_DATA      5     10:02:29    10:01:34    10:01:39        |
|        END OF DISPLAY                                                          |
+--------------------------------------------------------------------------------+

In the following example, TPFAR CDC is stopped for remote relational database TPFDB.

+---------------------------------------------------------------------------------------------+
|User:   ZCDCO STOP RDB-TPFDB                                                                 |
|                                                                                             |
|System: CDCO0003I 10.01.37 RDB-TPFDB - CONTINUOUS DATA COLLECTION HAS BEEN STOPPED           |
+---------------------------------------------------------------------------------------------+

In the following example, TPFAR CDC records are cleared from remote relational database TPFDB.

+--------------------------------------------------------------------------------+
|User:   ZCDCO CLEAR RDB-TPFDB                                                   |
|                                                                                |
|System: CDCO0006I 10.01.37 RDB-TPFDB - CLEARED ALL CONTINUOUS DATA COLLECTION   |
|                           RECORDS FROM THE REMOTE DATABASE                     |
+--------------------------------------------------------------------------------+

In the following example, a TPFAR CDC table is deleted from remote relational database TPFDB.

+--------------------------------------------------------------------------------+
|User:   ZCDCO DELETE RDB-TPFDB                                                  |
|                                                                                |
|System: CDCO0019I 10.01.37 RDB-TPFDB -CONTINUOUS DATA COLLECTION TABLE DELETED  |
|                           FROM THE REMOTE DATABASE                             |
+--------------------------------------------------------------------------------+

In the following example, the list of all the remote relational databases on the TPF system is cleared.

+--------------------------------------------------------------------------------+
|User:   ZCDCO INIT                                                              |
|                                                                                |
|System: CDCO0012I 10.01.37 -THE REMOTE DATABASE LIST HAS BEEN INITIALIZED       |
|                                                                                |
+--------------------------------------------------------------------------------+

Related Information