Show the configuration of the JMS queue
| Command | Description |
|---|---|
|
Show the current configuration of the JMS. | |
|
Ask for help on target jms. This shows all the options that can be configured for JMS and their usage. |
Check if all the processes are running
| Command | Description |
|---|---|
|
sp_ctrl()> show |
Provide status information on the JMS queue. For example, when you run the show or status command if the Post Process is Pending then sp_cop may have experienced a problem starting the JMS bridge server. The bridge service log file can be found in the SharePlex for Oracle install directory var/log/openbridge.log When you run the qstatus command if there are messages in the backlog of the post queue then those messages have not been delivered to SharePlex Connector for Hadoop. Perhaps SharePlex Connector for Hadoop has stopped. |
|
sp_ctrl()> status | |
Post process writing to the JMS queue:
| Command | Description |
|---|---|
|
Use these commands to monitor the post process. | |
Ensure PK/UK supplemental logging is enabled on the Oracle database. If you see the error "minimal supplemental logging should be enabled" then check the status of the supplemental_log_data on the Oracle database and enable using the following SQL query:
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
--------
NO
SQL> alter database add supplemental log data;
Database altered.
SharePlex Connector for Hadoop supports the following data types:
| Oracle Type |
XML Type |
|---|---|
| CHAR | string |
| DATE |
dateTime |
|
FLOAT |
decimal |
| NCHAR |
string |
|
NUMBER |
decimal |
|
NVARCHAR2 |
string |
|
ROWID |
string |
|
VARCHAR2 |
string |
|
INTERVAL YEAR TO MONTH |
yearMonthDuration |
|
INTERVAL DAY TO SECOND |
dayTimeDuration |
|
TIMESTAMP |
dateTime |
| TIMESTAMP WITH TIME ZONE |
dateTimeStamp |
|
TIMESTAMP WITH LOCAL TIME ZONE |
dateTimeStamp |
