Monday, 29 June 2015

Backup details in SAP Sybase IQ

BACKUP START TIME:

To get the backup start time you need to execute the following System Procedure :

exec sp_iqstatus

execution of this proc will show you a lot of output regarding your SAP IQ database but, you need to give some extra time to understand those points...:)

From the above output you need to locate these few lines which will let you know the information regarding Backup.

  

BACKUP END TIME :

To get the backup end time in SAP IQ:

1) Login to the server(not database)
2) Go to the path 

# cd $ASDIR/logfiles                 (for IQ 12.7 and earlier)
# cd $IQDIR15/logfiles               (for IQ 15.x and later)

here you will find a file named 'backup.syb', last modified time of this file will be the Backup End time.

There are few other ways to get the more backup details, like :

select * from SYSIQBACKUPHISTORY
select * from SYSIQBACKUPHISTORYDETAIL

exec sa_read_backup_historyexec sp_iqbackupsummaryexec sp_iqbackupstatus


Cheers....!! 
  

Keep updating me with your suggestions and queries in the comments below...everything will be appreciated..Thanks...!!

No comments:

Post a Comment