Skip to content

Troubleshooting

As the first step for analysis, we would request the support team to fetch the following custom plugin log files from the customer environment and upload them to the same case along with the support bundle.

Plugin Logs

Download the Plugin logs using the following methods:

  • Using dvp
    > dvp download-logs -c plugin_config.yml -e -u admin --password

  • Using GUI
    Help --> Supports Logs --> Plugin Logs --> Download

  • Plugin log file location on Delphix Engine:

/var/delphix/server/log/plugin_log/<plugin_id>/debug.log
  • Plugin log file location on Remote host:
/<toolkit_directory>/Delphix_COMMON_<appliance_id>>/plugin/sc:SAPIQ_<plugin-id>/SAPIQ/log_<os_user>/debug.log

SAPIQ Logs

Server Output Log:

$IQDIR/logfiles/<db_name>.0029.srvlog
  • IQDIR16 identifies the location of the SAPIQ directory
  • db_name identified the name of SAPIQ database.

Backup logfile:

$IQDIR/logfiles/backup.syb
  • IQDIR16 identifies the location of the SAPIQ directory.

SAPIQ Troubleshooting Queries:

SAPIQ Version:

. $IQDIR/../IQ.sh
dbisql -c "uid=${username};pwd=${password};eng=${server_name};dbn=${db_name};links=tcpip{host=${hostname};port=${port}" -nogui "select @@version"
start_iq -v
strings -a $IQDIR16/lib*/libiq16.s? 2>/dev/null |grep "IDENT=" | head -1 |cut '-f2,5' -d'/'

Start SAPIQ Server:

. $IQDIR/../IQ.sh
start_iq start_iq -x "tcpip{port=${PORT}}" ${MOUNT_Path}/${DB_NAME}.db

Stop SAPIQ Server:

. $IQDIR/../IQ.sh
echo "Y"| dbstop -c "uid=${username};pwd=${password};eng=${server_name};dbn=${db_name};links=tcpip{host=${hostname};port=${port}"

DBISQL Console Command:

. $IQDIR/../IQ.sh
dbisql -c "uid=${username};pwd=${password};eng=u${server_name};dbn=${db_name};links=tcpip{host=${hostname};port=${port}" -nogui

For backup & restore commands, please refer to SAPIQ official documentation here.