Log on as the db2 instance owner or a user who is sysadm for the db2
instance then
first make sure there are no connections to the sample db2
db2 force applications all
then do the backup (full offline is the default)
db2 backup db sample to /backupdir
where 'backupdir' is a directory you where you want the backup dataset
----- Original Message -----
From: "Noll, Ralph" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 22, 2003 12:48 PM
Subject: Re: db2 backup
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
>
>
