SAP Knowledge Base Article - Preview

3665208 - When executing a PITR Backup, the Message "No blocks to backup for PITR log!" is reported in the .iqmsg file - SAP IQ

Symptom

When executing a Point-in-Time Recovery (PITR) backup using one of the following methods, the No blocks to backup for PITR log! message may appear in the .iqmsg file:

  1. Automatic Backups
    Using the IQ_LOG_BACKUP_INTERVAL option

    SAP IQ Administration: Backup, Restore, and Data Recovery:
    https://help.sap.com/docs/SAP_IQ/a893f37e84f210158511c41edb6a6367/e616328ad3ae4a74bb4124265c1af524.html?locale=en-US&version=16.1.5.0

  2.  Manual Backups
     Executing PITR backups manually

    SAP IQ Administration: Backup, Restore, and Data Recovery:
    https://help.sap.com/docs/SAP_IQ/a893f37e84f210158511c41edb6a6367/8d65cebfcdd44b809fc243f940983d5b.html?locale=en-US&version=16.1.5.0

Sample Log (.iqmsg excerpt)

I. 10/02 11:16:49. 0000000107 ValidateBackup
I. 10/02 11:16:49. 0000000107 ValidateBackup
I. 10/02 11:16:49. 0000000107 OpenLog: <4/1> log</work/iq1601SP05PL15/IQ-16_1/testdb/PITR/PITR_log_000_000004_0001_20251002_021649621043.iqlog>
I. 10/02 11:16:50. 0000000107 IQ Checkpoint position: 0
I. 10/02 11:16:50. 0000000107 Chk
I. 10/02 11:16:50. 0000000107 ChkDone [NumTxnCP: 1]
I. 10/02 11:16:50. 0000000107 IQ Checkpoint block: 2594
I. 10/02 11:16:50. 0000000107 PrepareForBackup
I. 10/02 11:16:51. 0000000107 PostChk
I. 10/02 11:16:51. 0000000107 IQ Checkpoint position: 0
I. 10/02 11:16:51. 0000000107 Chk
I. 10/02 11:16:51. 0000000107 ChkDone [NumTxnCP: 1]
I. 10/02 11:16:51. 0000000107 IQ Checkpoint block: 2610
I. 10/02 11:16:52. 0000000107 PostChk
I. 10/02 11:16:52. 0000000107 IQ Checkpoint position: 0
I. 10/02 11:16:52. 0000000107 s_pitrlog::SwitchLogForBackup() Moved log to file: /work/iq1601SP05PL15/IQ-16_1/testdb/PITR/PITR_log_000_000004_0001_20251002_021652436644.iqlog
I. 10/02 11:16:53. 0000000107 Chk
I. 10/02 11:16:53. 0000000107 ChkDone [NumTxnCP: 1]
I. 10/02 11:16:53. 0000000107 IQ Checkpoint block: 2594
I. 10/02 11:16:53. 0000000107 PostChk
I. 10/02 11:16:53. 0000000107 DoBackup
I. 10/02 11:16:54. 0000000107 No blocks to backup for PITR log!
I. 10/02 11:16:54. 0000000107 PostBackup
I. 10/02 11:16:54. 0000000107 Cmt 210 Txn 205
I. 10/02 11:16:54. 0000000107 TINFO t=205 v=205 c=210 gt=0 gc=0 pcv=0 ME=0 MSE=0 TRR=0 #=0
I. 10/02 11:16:54. 0000000107 IQ Checkpoint position: 0
I. 10/02 11:16:55. 0000000107 Chk
I. 10/02 11:16:55. 0000000107 ChkDone [NumTxnCP: 0]
I. 10/02 11:16:55. 0000000107 IQ Checkpoint block: 2610
I. 10/02 11:16:55. 0000000107 PostChk


Read more...

Environment

  • SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.