Reports/Troubleshooting

Get ReplQueue Count

The Get ReplQueue Count retrieves the replqueue count for a specific thread number or all the threads. Along with the thread number, you can specify the maximum number of replqueue records that you want to count for the threads.

Generate the Get Replqueue Count report:

1. In the Thread Number field, enter the thread number for which replqueue count report is to be generated. The default value for this field is 0, which retrieves the replqueue count for all the threads.
2. In the Max Record Count field, enter the number of records to be included in the report. The default value for this field is 0, which retrieves the count for all the replqueue records.
3. Optional. Select the Applied checkbox to count only the applied replqueue records and the Audited checkbox to count only the audited replqueue records.
4. Click Submit.

   The job scheduler runs the Get ReplQueue Count job request to generate the Get Replqueue Count report.

5. After the job request runs successfully, download the rqcounts.txt file from the job record to view the report output.

   The rqcounts.txt file gets saved in the user download directory.

   The rqcounts.txt file contains the following fields: Thread, Source DB, Source Table, # Records, Unapplied, Applied, Audited, No Map, No GenQRec, To be Replicated.

Get Replqueue List

The Get Replqueue List report lists the replqueue records with the not applied status. The report organizes the records by thread number, source table, and the event date.

1. In the Replication Thread Number field, specify the thread number to retrieve the respective replqueue records.
2. In the Start Date and End Date fields, set the date range for the records to be included in the report. The default value for the End Date field is the current date.
   Note: The Start Date is an optional field. If you do not specify a start date, the report lists all the unprocessed replqueue records up to the entered end date.
3. In the Max Record Count field, enter the number of records to be included in the report. The default value for this field is 0, which retrieves the count of all the unprocessed replqueue records.
4. Click Submit.

   The job scheduler runs the Get Replqueue List job request to generate the Get Replqueue List report.

5. After the job request runs successfully, download the RQList.csv file from the job record to view the report output.

   The RQList.csv file gets saved in the user download directory.

   The RQList.csv file contains the following fields: Record ID, Sequence Number, Thread Number, Source Database, Source Table, Event Date, Event Type, Applied.

Get Table Configuration

The Get Table Configuration report generates a list of tables and the threads to which the tables are mapped. The report includes the flag values (yes or no) for the Gen Queue Records, Process Queue Records, and the Include/Exclude properties of the tables.

Generate the Get Table Configuration report:

1. Select the Source Database from the list. The report runs for one database at a time.
2. In the Table include list field, specify the table name in case of a single table. If you want to run the report for multiple tables, enter a list of table names separated by commas. The default value for this field is * asterisk, which retrieves the records for all the mapped tables within the selected database.
3. Click Submit.

   The job scheduler runs the Get Table Configuration job request to generate the Get Table Configuration report.

4. After the job request runs successfully, download the TableConfigList.csv file from the job record to view the report output.

   The TableConfigList.csv file gets saved in the user download directory.

   The TableConfigList.csv file contains the following fields: Source Database, Source Table, Thread Number, Gen Queue Rec, Process Queue Rec, Include/Exclude.

Get Table Activity Count

The Get Table Activity Count report contains the replqueue activity count for a specific table or multiple tables from the source database. The three activity event types are: create, update, and delete records.

1. Select the Source Database from the list. The report runs for one database at a time.
2. In the Table include list field, specify the table name in case of a single table for retrieving the replqueue activity count. If you want to run the report for multiple tables, enter a list of table names separated by commas.
   Note: For this report, * asterisk is not supported in the Table include list field. Fetching activity records for all the tables within the specified source database may take a long time to run the report to completion.
3. Click Submit.

   The Alert dialog box notifies the time it will take to run the report if the queue backlog is large.

4. Click Ok to proceed.

   The job scheduler runs the Get Table Activity job request to generate the Get Table Activity Count report.

5. After the job request runs successfully, download the TableactivityList.csv file from the job record to view the report.

   The TableactivityList.csv file gets saved in the user download directory.

   The TableactivityList.csv file contains the following fields: Source Database, Source Table, Create Record, Update Record, Delete Record.