Symptom
When an IQ full backup is executed via local "dbisql" client, the IQ full backup completes before displaying 100% message like below.
(DBA)> BACKUP DATABASE FULL TO ' /backup_directory/iq_full.bk' ;
BACKUP DATABASE FULL TO '/backup_directory/iq_full.bk';
Snapshot created.
48 (155203 of estimated 3441442 MB) complete after 00:05:00; estimated 01:45:52 remaining
9% (313098 of estimated 3441442 MB) complete after 00:10:00; estimated 01:40:00 remaining
13% (476974 of estimated 3441442 MB) complete after 00:15:00; estimated 01:33:17 remaining
18% (636907 of estimated 3441442 MB) complete after 00:20:00; estimated 01:28:06 remaining
23% (796293 of estimated 3441442 MB) complete after 00:25:01; estimated 01:23:06 remaining
27% (961507 of estimated 3441442 MB) complete after 00:30:01; estimated 01:17:25 remaining
32% (1122188 of estimated 3441442 MB) complete after 00:35:01; estimated 01:12:22 remaining
37%(1281081 of estimated 3441442 MB) complete after 00:40:01; estimated 01:07:29 remaining
41% (1439285 of estimated3441442 MB) complete after 00:45:01; estimated 01:02:37 remaining
46%(1600985 of estimated 3441442 MB) complete after 00:50:01; estimated 00:57:30 remaining
51% (1764586 of estimated 3441442 MB) complete after 00:55:01; estimated 00:52:17 remaining
55% (1926285of estimated 3441442 MB) complete after 01:00:02; estimated 00:47:13remaining
60% (2089887 of estimated3441442 MB) complete after 01:05:03; estimated 00:42:04 remaining
65% (2251586 of estimated 3441442 MB) complete after 01:10:05; estimated 00:37:02 remaining
70% (2417090 of estimated3441442 MB) complete after 01:15:07;estimated 00:31:50 remaining
74% (2578935 of estimated 3441442 MB) complete after 01:20:08; estimated 00:26:48 remaining
79% (2738586 estimated3441442 MB) complete after 01:25:08; estimated 00:21:51 remaining
84% (2900279 of estimated3441442 MB) complete after 01:30:09
89% (3063083 of estimated 3441442 MB) complete after 01:35:09
93% (3223666 of estimated 3441442 MB) complete after 01:40:11
98% (3383103 of estimated 3441442 MB) complete after 01:45:11
-- Execution time: 6423.38 seconds
Read more...
Environment
- SAP IQ 16.1
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.