Full backup

[t***@yahoo.com.br]

Hi all,

I´m trying to do a full backup, but the following error occurs:

[code]
BACKUP DATABASE CRPDB004 TO "E:\DB2\CRPDB004\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING

SQL1035N The database is currently in use. SQLSTATE=57019
[/code]

How can I do in this case?

Must I disconnect all users?

the script to perform the backup is:

[code]
CONNECT TO CRPDB004;
UNQUIESCE DATABASE;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE CRPDB004 TO "E:\DB2\CRPDB004\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO CRPDB004;
UNQUIESCE DATABASE;
CONNECT RESET;
[/code]

thank U very much!!!!

[]´s

[r***@lionbridge.com]

try
deactivate db before backup

[t***@yahoo.com.br]

I´m going to test your sugestion.

thanks!!!

[Knut Stolze]

Post by t***@yahoo.com.br
Hi all,
[code]
BACKUP DATABASE CRPDB004 TO "E:\DB2\CRPDB004\" WITH 2 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING
SQL1035N The database is currently in use. SQLSTATE=57019
[/code]
How can I do in this case?
Must I disconnect all users?

Singe you are taking an OFFline backup, all users must be disconnected and
the database deactivated.

[t***@yahoo.com.br]

Hi all,

About full backup, I´ve tried to create a incremental backup, but I don´t know
to create this. I´m learning now about DB2 backups.

To create a backup, I use backup wizard of control center.
But only Backup type "Full Backup" is available.

I can make to choice incremental option. This option is disable.
I don´t know why.

thank you all!!!!

[Thomas Ritter]

Hi,

to be able to start incremental backups you have to update the database configuration parameter TRACKMOD to 'yes'.
After that, you have first to start a full backup of that database in order to have a baseline against which incremental backups can be taken.

Hope that helps.

Regards,
Thomas

[t***@yahoo.com.br]

Thank you :-)