Skip to Content
0
Jun 19, 2020 at 08:09 AM

SAP IQ 16.1 SP03 - IQUNLOAD not working and not printing useful error output

248 Views Last edit Jun 19, 2020 at 08:10 AM 2 rev

Hello,

Am using below IQUNLOAD command on a Linux server and the command isn't executing. Unable to debug since the tool isn't pointing out the error.

Both variants does nothing and the log file has the syntax of IQUNLOAD redirected. Please help on how to find out where the syntax error is.

iqunload –n -c "UID=DBA;PWD=password;DBF=/opt2/sybaseiqdata/xyz.db" –r /tmp/DDL_xyz_schema.sql -v -o /tmp/DDL_xyz_schema.log

iqunload –n -c "UID=DBA;PWD=password;ENG=10.000.000.000_xyz;DBF=/opt2/sybaseiqdata/xyz.db" –r /tmp/DDL_xyz_schema.sql -v -o /tmp/DDL_xyz_schema.log

iqunload –n -c "UID=DBA;PWD=password;DBF=/opt2/sybaseiqdata/xyz.db" –r /tmp/DDL_xyz_schema.sql -v -o /tmp/DDL_xyz_schema.log

=================================OUTPUT : onto screen and in the log file=======================
SAP IQ Unload Utility Version 16.1.24.1129
Usage: iqunload [options] <directory>
    @<data> expands <data> from environment variable <data> or file <data>

Options (use specified case, as shown):
    -ap <size>     set page size of rebuilt database
    -au            unload and reload schema
    -c "keyword=value;..."
                   supply database connection parameters
    -dc            redo computed columns
    -ms_filename   specify filename for new IQ_SYSTEM_MAIN store
    -ms_reserve    specify reserve for new IQ_SYSTEM_MAIN store
    -ms_size       specify size for new IQ_SYSTEM_MAIN store
    -n             no data - unload schema only
    -o <file>      append output messages to file
    -q             quiet: do not display messages or show windows
    -r <file>      path of reload SQL file (default "reload.sql")
    -ru <file>     path of unprocessed SQL file (default "unprocessed.sql")
    -new_startline <command line>
                   specify command line parameters for reload engine
    -t <list>      only output the listed tables
    -tl <pattern_list>
                   only output tables matching the given pattern string
    -tld <pattern_list>
                   restrict the data extracted
    -ul <pattern_list>
                   only output users matching the given pattern string
    -null_string <string>
                   specify the null string string to use on extracted ascii character data
    -up            unload password hashes (not permitted with -no)
    -v             verbose messages
    -y             replace existing SQL script file without confirmation

    <directory> must be specified as a path meaningful to the database
    server unless an external unload is used.