That message is somehow generic and can be result of many reasons (timeout, connection dropped by DBA or by particular event, etc.). You need check the corresponding messages in IQ server logs (iqmsg, srvlog, stder) and cfg file to check timeout s...

What's the result of select db_property('collation'); ?Try connect using client charset UTF-8 and test query to see if data are correct.in connection parameters add CharSet=UTF-8SeeCharSet (CS) Connection ParameterOnce connected, double check the act...

Outputs ofselect db_property('collation');In dbisql connection executed Load table :select connection_property('Charset') as load_charset;In dbisql connection displaying data loaded :select connection_property('Charset') as result_charset;In client d...

see alsoIQ Database activity auditsKBA 2137269 - How to Use Auditing in SAP IQ 16Logging Server Requests

Let's say, you need replicate A (prod) to B (quality/maint).Install SAP IQ software in B.Download/place suitable licensePerform full backup of Prod IQ database in ARestore database in B from that A backup archive.If IQ dbfiles path are different, you...