Is there an SQL statement to determine the number of logical logs that are not backed up?
By querying the sysmaster database you can determine the number of logical logs that are not backed up. You can use this information to decide if a logical log backup is necessary.
Run the following SELECT statement from any application:
SELECT COUNT(*) AS ll_not_backup,
(SELECT COUNT(*) FROM syslogs) AS total_ll
WHERE is_backed_up = 0;
The following table explains the columns in the output of the SELECT statement:
|Is the number of logical logs that are not backed up.|
|Is the total number of logical logs defined for the instance|
Note: The information displayed changes dynamically, so it is accurate at the time it is generated.
This example shows that the instance has 6 logical logs defined and 1 of these log was not backed up.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.