Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Reference Guide
Main menu
Connect to Database
Connecting to databases directly without client libraries installed
Connecting to an Oracle database
Connecting to a DB2 database
Options
General options
Thumbnail options
Hex view
The work area
SQL editor
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Post-processing Office files
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data
DICOM images
Hidden Excel worksheets

Connecting to a DB2 database

SQL Image Viewer supports DB2 databases via the use of the DB2 ODBC driver.

When setting up the ODBC driver, it is important to provide a value for the BlockForNRows parameter, so that images are only retrieved on demand. This is especially important when exporting images and files. If this option is not set, the ODBC driver will retrieve all the images from the database before saving them to disk, which consumes a lot of system memory. When this option is set, the ODBC driver retrieves the images in batches, on demand.

Enter a value to limit the number of rows that the ODBC driver will fetch every time data is retrieved from the server. You can start off with a value of 10, and increase it if you want better performance at the cost of using more memory, or reduce the value if your system memory is inadequate to hold that number of rows in memory.

connect-db2-01