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

Reply via email to