full offline backup.. how do i do that?? R
> -----Original Message----- > From: Joseph Nocket [mailto:[EMAIL PROTECTED] > Sent: Monday, December 22, 2003 10:40 AM > To: [EMAIL PROTECTED] > Subject: Re: db2 backup > > > Sounds like you set the log retain or user exit configuation > paramters on > for the sample database to retain or yes. This would put the > db in backup > pending and not allow a connect. > do a > db2 get db config for sample > command and check that the following parms are no > > Log retain for recovery status > User exit for logging status > > If you want them set the best soution is to just do a full > offline backup or > you can set them off and this sould remove the > backup pending state. > > > ----- Original Message ----- > From: "Noll, Ralph" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, December 22, 2003 9:20 AM > Subject: db2 backup > > > db2 => connect to sample > SQL1116N A connection to or activation of database "SAMPLE" > cannot be made > because of BACKUP PENDING. SQLSTATE=57019 > > > i was trying to do a backup of my sample database > it did not work > > do now when i go back to connect i get the above error msgs.. > > any help will be appreciated > > > Ralph > >
