On one is connected to database . I tried to delete the records from indexed
table using command center . The message was coming as Transaction log full
and deletion was aborted . After increasing the number of log files and log
file size and repeating the same step again it gave the same message and
then database went to inconsistent state . How to resolve it . In my view it
appears to be the problem of Transcation log . How to restore the state .

Anurag



----- Original Message -----
From: "Sathyaram Sannasi "
<db2udbdba-ezmlmshield-x10151684.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 18, 2004 3:51 PM
Subject: RE: online backup question


> Log file is closed and flushed by default ...
>
> The db2set parm DB2_DISABLE_FLUSH_LOG can be set to ON to disable it ...
>
> HTH
>
> Sathyaram
> www.db2click.com
> www.idug.org/user/UserLogin.asp
>
>
>
>
> -----Original Message-----
> From: ighiurea
> [mailto:db2udbdba-ezmlmshield-x86727763.[Email address protected]
> Sent: 17 August 2004 23:03
> To: LazyDBA Discussion
> Subject: online backup question
>
>
> DB2 UDB EEE version 8.1
>
> Questions for online backups:
>
> After an full online backup is complete:
> do you have to issues cmd manual to close the active logs ? OR
> DB2 forces the currently active log to be closed automat ?
> and as a result, it will be archived.
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
> **********************************************************************
> This email and any files transmitted with it are confidential and are
> intended solely for the use of the individual or entity to whom they are
> addressed. This communication represents the originator's personal views
and
> opinions, which do not necessarily reflect those of HPI Limited. If you
are
> not the original recipient or the person responsible for delivering the
> email to the intended recipient, be advised that you have received this
> email in error, and that any use, dissemination, forwarding, printing, or
> copying of this email is strictly prohibited. If you received this email
in
> error, please immediately notify [Email address protected]
>
> This message has been scanned by Panda Anti-Virus. Recipients are advised
to
> apply their own virus checks to this message on delivery.
> **********************************************************************
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page